Nikitha Nelloor Email & Phone Number

Bengaluru, Ka, In

United States

Title: Sr. Data Analyst / ETL Developer September 2021 - Present Client: Elevance Health (San Francisco, CA) Project: Elevance Health, Inc. is an American health insurance provider. Prior to June 2022, Elevance Health was named Anthem, Inc. The company's services include medical, pharmaceutical, dental, behavioral health, long-term care, and disability plans through affiliated companies such as Anthem Blue Cross and Blue Shield, Empire BlueCross BlueShield in New York State, Anthem Blue Cross in California, Wellpoint, and Carelon.The project scope was to build a data warehouse solution to send monthly reports to client’s external providers about their membership, medical claims, and pharmacy claims data. Implementing a data warehouse and a reporting system to send monthly reports on client’s membership, medical claims, and pharmacy claims to different providers. Designing,developing and testing Informatica workflows, sessions, and mappings, to integrate data coming from different upstream applications in Teradata.  Developing various mappings using mapping designer, which used aggregator, lookup, filter, router, joiner, source qualifier, sorter, and sequence generator transformations. Managing System Integration Testing activities and preparation for User acceptance testing and sign-off. Guiding Business in improving deliverables’ quality and cost-effectiveness through deep data analysis using SQL.  Scheduling ETL workflows using Control-M. Providing post-production support by monitoring and troubleshooting Control-M jobs. Building dashboards, creating data sources for Executive Leads using Tableau.Environment: Informatica PowerCenter, Teradata, Control-M, Tableau

United States

Title: Data Analyst / ETL Developer June 2019 – August 2021Client: Lam Research (Fremont, CA)Project: Lam Research Corporation is an American supplier of wafer-fabrication equipment and related services to the semiconductor industry. Its products are used primarily in front-end wafer processing, which involves the steps that create the active components of semiconductor devices (transistors, capacitors) and their wiring (interconnects). The project scope is to build a data warehouse system to report on the performance of chip manufacturing tools, after collecting data from the external partners. Captured Metrics/KPIs requested by stakeholders, identified end use cases, documented requirements, converted Business use cases to data requirements and provided timelines to the Business team. Performed data profiling on various source systems to identify the correct source of truth. Designed and developed ETL packages using SSIS to load data from different source systems such as flat files, csv files, Oracle, and SQL Server Implemented slowly changing dimensions of Type 2 to populate current and historical data into Dimensions. Prepared source datasets for analysis using Pivot tables, V Lookup, H Lookup and Conditional formatting in MS Excel. Developed Microsoft Power BI dashboards, and visualizations with SSRS to deliver meaningful and actionable insights.Environment: Microsoft SSIS, SQL Server, Microsoft SSRS, Microsoft Power BI

United States

Title: Data Analyst June 2018 – May 2019Client: Baxter Healthcare (Chicago, IL) Project: Baxter International Inc. is an American multinational healthcare company with headquarters in Illinois. The project scope was to build a Data warehouse to support the reporting needs of both Supply Chain and Finance streams.  Managed co-ordination of project related tasks, which includes interacting with clients to capture requirements, prepare technical specification and User Acceptance documentation. Cleansed Excel files to remove duplicates, fix date formats and handle missing values. Prepared data for analysis using Pivot tables, V Lookup, H Lookup and Conditional formatting in MS Excel. Managed system Integration Testing activities and preparation for User acceptance testing and sign-off. Performed root cause analysis for data issues reported by Business team, using SQL.Designed and developed key Tableau dashboards for sales performance, and customer targeting. Developed and published Tableau data sources to PROD environment to support Supply Chain and Finance dashboards. Environment: Microsoft Office, Oracle