• Migration of Manufacturing data from Various Plants to Cloud (AWS)• Data Quality, Data Analysis of SQL Servers and creating mapping document for data migration • Creating Metadata & data dictionary for migration projects• Creating logic & queries for reporting • Root cause analysis for debugging reports and queries • Working with cross functional teams to get the requirements and delivering the product

Client -Vituity, CA Responsibilities• Performed gap analysis for data migration from SQL Server to Snowflake on Azure Blob• Data Analysis for RCM & Non- RCM data from new sources to Snowflake on Azure Blob• Analysis of Merging RCM & Non-RCM data for new data sources• Mapping of New Sources RCM & Non-RCM to Azure Blob (Data Lake)• Provided recommendations for Data Modeling for RCM & Non-RCM data Client – Beacon Health Care• Mapping for EDI X12 for Capital BlueCross for 270/271 requests • AAA Error Mapping for EDI requests for 271• Cross Walk for Eligibility benefits based on business rules • Performed Gap Analysis for 270/271 requests to consume • Worked with cross functional teams to determine solutions for the request initialing and receiving • Created test cases for Eligibility benefits for Capital BlueCross

• Data mapping for Utilization management & Clinical notes for Accolade & Conifer extract as per joined agreement. Extract data is sent from BCBSMA Data warehouse to Accolade/Conifer using SFTP• Develop edge cases for Utilization management & Clinical notes extract for Accolade & Conifer for QA • Production support for Accolade & Conifer Utilization management & Clinical notes extract• Release 2 for Accolade & Conifer extract. Drove the project to identify solution for automation of Account number & Group numbers fetched using OLB rider from Data warehouse working with cross functional teams• Resolution of discrepancies in Type of service categories; Revenue Codes, Cpt Proc codes & HCPCS proc codes on DWH • Learn to Live, which is a pilot program for BCBSMA. Analyze data consumed by DWH from Salesforce & ODH. Identify inconsistencies in data consumed by DWH and propose solution to get better data from salesforce & ODH• Migration from Geo Access tool to Quest Analytics tool. Create workflow for smoother transition for end user to understanding & to use new tool. Create remediation documentation for new tool& Identify bottle necks in Quest Analytics and help team to migrate to Quest Analytics• Provide data expertise to Data Warehouse personnel as well as customers. Data mapping for Accolade & Conifer extracts for migration from MCPS which is mainframe to MHK which is advanced MCPS • Optimization of I/O’S for Impact Pro DB Server, Impact Pro is predictive analytics tools used by BCBSMA & Service providers to get future estimates of member and diagnostics. • Tech lead for migration of DB from Oracle 12g to SQL Server 2016 for application Optum Impact pro. • Load & Performance testing for Impact pro DB to benchmark results before & after migration • Migration of extracts for Accolade & Conifer from MCPS (Mainframes) to MHK• Testing strategies & Data Analysis for Blue View data mart which is used for reporting

• Involved in creating and developing reports and dashboards using Tableau Desktop 10.5-2018.2• Involved in creating data visualizations like Bar charts, cross tab, Tree Maps, Line charts, Scatter plot, Mapping Visualization with Tableau desktop 10.5-2008.2• Involved in Data Blending.• Involved in Admin activities like creating users and groups, publishing workbooks to server and end users, assigning permissions, subscriptions etc.• Managed reporting of the day-to-day activities based on the scope, budget, and schedule constraints Analyzed large volumes of data and develops medium to complex reports/dashboards, insights for clients. • Managed data on Amazon redshift and created views for custom reports.• Created inventory management system using run rate of past 90 days and sales between last 2 days to have control over stock and sales.• Understanding KPIS and generate reports for those KPIS.• Has an in-depth understanding of the tools used for analysis, reporting and developing business insights, involved in creating reports and dashboards using various charts with Tableau• Created different Maps and charts to improve productivity and sales.• Involved in Creation of Tableau Mobile Reports Development process.• Prepared Unit Test Cases and Test Plans for the Reports Developed.• Interacted with the users extensively and gathered the requirements, and analyzed the needs of the end users.• Designed Templates, Filters to generate Reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report.• Compared the monthly data between 2019 and 2018 fiscal year and redesigned the UI of those high bounce rate pages and home page to bring in more traffic.• Analyzed geographical and behaviors of website visitors to better understand and serve the target audience, then build great customer relationship with them

• Assist with internal and external data reporting of regulatory requirements• Complete analysis of internal ad hoc data requests for executive team• Predict future organizational goals using forecasting models• Validate data requests from external parties for research opportunities• Visualize data in presentations for leadership using Tableau • Assist in user acceptance testing of new module applications• Test user experiences to improve current data entry processes• Gathered business requirements, working closely with business users, project leaders and developers. Analyzed the business requirements and designed Conceptual and Logical Data models• Prepared ETL technical Mapping Documents along with test cases for each Mapping for future developments to maintain SDLC• Involved in Data flow analysis, Data modeling, Physical database design, forms design and development, data conversion, performance analysis and tuning. • Involved in extracting the data from various sources like Oracle, SQL, Teradata, and XML• Performed Data Analysis and Data Profiling using complex SQL queries on various sources systems including Oracle, Teradata. • Implemented data blending using various data sources and created stories using Tableau for better understanding of the data and reporting.• Documented Source to Target mappings as per the business rules.

• Resolved business and technical queries from business partners related to decision making and reporting on data available in the Data warehouse. • Responsibility included requirement study, developing use cases for business layer and Dimensional Data Modeling and coordinating the team for development. • Audit internal database system to reconcile commercial and government (Medicaid) claims with third party entities to recover profit losses and maintain positive relationships• Develop plan of action to increase business through analyses of state health care needs and current utilization and through researching existing policies and programs• Prepare geographical mapping of provider network using Quest Analytics Suite to assist the Chief Marketing Officer and sales teams with business development initiatives• Involved in using Complete-Compare Technology to support iterative development by keeping the models and databases. • Involved in Data Warehouse Support - Star Schema and Dimensional Modeling to help design datamarts and data warehouse. • Identify source systems, their connectivity, related tables, and fields and ensure data suitably for mapping.

• Analysis of housing trends and review mortgage product characteristics such as underwriting parameters, closing costs, mortgage insurance, qualification rules, rate sheets and price adjustments• Minimize losses within the delinquent collections segments by providing specific collection treatments• Implementing ETL process using Teradata Utilities like BTEQ and Ab Initio.• Validated any changes of data, Behind Logic/Formula/Calculation of new created fields • Preprocessing and cleansing data using Excel and SQL queries • Management reporting design using Tableau and automation in Access/Excel with dashboards, pivot tables, charts (standard/pivot) and linked data refreshes • Developed BTEQ Scripts in Teradata for as per the requirement.• Performed the Unit testing and prepared the Test Case• Coordinate with partners both inside and outside the company, understand the business need, perform the required data analysis, and provide valuable insights • Provide ad-hoc reports to key business partners across different groups to help drive the business decisions. • Created Project Plan documents, Software Requirement Documents, Environment Configuration and UML diagrams. • Directly worked with project managers, SME and various stakeholders for project budgets, billing hours and schedules. • Using Data visualization and reporting tools like QlikView and Micro Strategy.• Created data flow, process documents and ad-hoc reports to derive requirements for existing system enhancements. • Participated in design discussions and assured functional specifications are delivered in all phases of SDLC in an Agile Environment. • Performed User Acceptance Testing, Device and Performance testing, Functional and Regression testing.

• Working closely with project manager/Test Lead and Project team to learn about the project functionalities and provided testing timelines. • Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications. • Experience in writing SQL queries involving multiple tables inner and outer joins. • Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views. • Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications. • Experience in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS). • Experience in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases. • Experience in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement. • Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts. • Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision. • Good understanding of Health care, Financial and Retail domains. • Involved in writing Requirement Tractability Matrix (RTM) detailed Test Plan and Test scenarios. • Involved in testing application on different mobile Platform such as Windows, iOS and Android devices.