Pragya S. Email & Phone Number

Indianapolis, Indiana, Us

Work on BCBSA mandates for National data warehouse Business team, where responsible for Accuracy of Member and Claim data of Anthem blue cross blue shield 14 plans in BCBSA National data warehouse.2.Creates UAT test plans, feature test strategies, performs quality analysis, develops tableau reports on claims , provider, Products and member data to analyze business performance and provides notations of performance deviations and anomalies.3. Proactively works with product owners to anticipate and identify opportunities for improvement.4. addresses risks and implements contingency plans to resolve issues impacting data goes out to BCBSA and downstream team across the enterprise.5. Creates the Business requirements and process documents for different deliverables.6. writes use stories in JIRA, collaborate with IT dev operations team, actively participates with the Agile team for scheduling and managing of assigned work.7. Leveraging the newly developed Internal Artificial Intelligence tool to create meeting notes, Weekly status report for leadership, analyzing data in reports, SQL, write email based on audience, process document. 8. Lead of the Asian community for Excellence Business Resource group in Woburn. I create opportunities for people to connect with others in the same profession or interest like volunteer opportunities to help our community, address food insecurities, and celebrate cultural events and find other opportunities to support the community.

 Created knowledgebase to improve self-service reporting experience for the business.  Streamline processes through automation and executed strategies using new technology. Mentored team on cross-functional areas to serve as back up to SMEs. Influenced better documentation practices by example, creating requirements, specifications, process flow and audit reports for clients. Advocated and educate team to gain efficiencies and reduce complexity building report time and automate them through SSRS, SQL-Plus.

Provide decision support through reporting and analytical skills to Beacon’s internal and external customers. Manage all project and priorities with collaboration Account executives and deliver on time. Act as a subject matter expert for data, analytics, and testing within a business unit to ensure accurate and proper interpretation of core business metrics.  Lead planning, Interface with account executives and product manager, gather requirements and deliver complete analytics/reporting solutions. Document Technical Specs, Business Requirements, Process Flows to from Request to deliver the solution to client, Change Requests and Urgent Data Audit Reports. Stay proactive with the business team/client guiding them to their next solution and fill the gaps in requirements. Write T-SQL queries to combine data sets, Store Procedures, Design SSIS Packages to transfer data from SQL Server for automation purposes using Business intelligence development studio.  Support existing data processes, Identify opportunity to improve and create new processes and strategies with technology solutions and automation, and standardized them. Make recommendations for new metrics, techniques, and strategies to improve existing/new reports measurement. Trained BI Team over some important modules to understand business logic flow and need to create correct reports.  Communicate complex ideas simply, coherently and fluently both in writing and verbally.

Business Intelligence Report developer for Knowledge Management & Reporting team for TX Clients.  Write T-SQL queries, Store Procedures for Scheduled and ad-hoc reports.  Design SSIS Packages to transfer data from legacy to SQL Server and used Business intelligence development studio for automation purposes. Design, Develop and Deploy reports in MS SQL Server environment using SSRS & Crystal reports.  Create SQL Job to automate reports to be run according to frequency defined before. SQL Job monitoring and rerun failed reports. Deploy SSIS Package into Production to Create report based on Business requirements.  Monitor SQL Job agent for re running the jobs ended with failure. Provide ad-hoc and automated access to large data sets. Write the technical specification for code documentation purposes.

London, Gb

 Gathered business requirements and wrote SQL Queries/NSQL for Custom Jobs. Debugged and Modified Stored Procedures as needed. Created Crystal and ad-hoc Report on business demand. Run Project forecast reconciliation and Validate Project Forecast hours. provided technical support, Functional Administration and configuration of application along with design and Implementation of Custom Object, Portlet, Dashboards Designs to manage Resource and Projects portfolio. Completed Unit testing/created test cases for Quality Assurance in all Environment Development, Sandbox, QC, and Production. Supported salesforce CRM admin and application where created objects, Workflow rules, Reports, Configuration, customized reports and dashboards on business request.

Boston, Ma, Us

1. Designed (SSRS .rdl) reports and .Net (.rdlc) reports hosted in SQL 2008 R2 & SQL Azure Cloud environments. Maintained existing report in production and make updates as business needed.2. Analyzed data for Geo-referenced & Digitized existing nuclear zones for Nuclear Power Plant Emergency Evacuation plan.3. Designed and Quality checked front end user interface within a .Net programming environment.

Jaipur, Rajasthan, In

Identified technical design and specification, prepared Business Mapping Report. Analyzed source systems, database structure and analytical reporting need. Created Meta data, dimensional modeling, and schema. Quality checked once the reports were created in the database.

Masters, Computer Science

Bachelor Of Engineering (B.E.), Computer Science