Sindhura Kosaraju

Client: State Of Texas, Health and Human Services Commission

• Leading the requirements-gathering sessions with a broad spectrum of business and technical users, and conducting requirements review and approval sessions to secure requirements sign-off.
• Managing multiple projects, from requirements gathering to code deployment in production. Other tasks include reviewing technical documentation, allocating ETL development work, conducting design review sessions, GAP analysis, test-plan validation, coordinating code deployments, and production validation.
• Documenting and reviewing detailed technical specifications and other project-related documentation required in each phase of the SDLC, and complying with internal standards and guidelines.
• Leading and mentoring the development team on Informatica-based ETL architecture, and ensuring that the team implements Velocity best practices recommended by Informatica.
• Identifying opportunities to optimize the ETL environment, implement monitoring, quality, and validation processes to ensure data accuracy and integrity.
• Reconciling discrepancies in current state logical and physical data models, and collaborating with other team members to model additional entities and relationships.

Client: Texas Medicaid and Healthcare Partnership.

• Championed the development and implementation of ETL workflow best practices, leveraging TFS for version control and error handling techniques.
• Led initiatives to simplify complex datasets and establish comprehensive support processes for stakeholders, enabling access to self-service analytics.
• Directed ad hoc request reviews, prioritizations, and planning initiatives alongside existing objectives to drive competitive outcomes for the analytics team.
• Engineered advanced data solutions, seamlessly integrating data from over 20 diverse sources, including APIs, databases, FTP servers, and manual uploads.
• Responsible for modularizing, designing, and leading a team of five ETL developers.
• Responsible for the maintenance of all the environments (Production, Regression, Test, Development), including installation, configuration, performance tuning, monitoring, and backups of critical files.
• Worked closely with the DBA in creating the tables, indexes, materialized views, table partitioning, etc.
• Trained end users, and provided 24/7 production support.

Client: CVS Health

• Collaborated with clients and business stakeholders to gain a deeper understanding of business processes, in order to translate requirements into technical design specifications.
• Created mappings, workflows, applications, and match rules in Informatica PowerCenter and Informatica Data Quality.
• Developed ETL pipelines, and enhanced existing pipelines to fit the new requirements.
• Created deployment builds using JIRA and TFS, and coordinated deployments with release management teams.
• Developed triggers in Oracle PL/SQL to insert records into history tables from transaction tables.
• Created PL/SQL packages, stored procedures, and functions to move the data from staging tables to DataMart.
• Implemented exception handling for better and easier debugging by printing the error messages wherever required.
• Created scripts for new tables, views, materialized views, and queries.
• SPOC for multiple subject areas within the Data Analytics Platform.

Client: Bank of America.

• Worked with business report developers and end business users to understand the requirements, and identify solutions for the requirements.
• Worked on data extraction, cleansing, data integration, and loading from the Oracle database using Informatica PowerCenter capabilities.
• Extracted data from CSV files and loaded it into target tables using Informatica capabilities.
• Experience in exception handling using PMERR tables. Created PMERR tables and logged errors into PMERR tables.
• Applied business logic and loaded the data into the target Oracle system as per business requirements.
• Implemented SCD type 1 and type 2 to maintain historical data as per business requirements.
• Developed and implemented the coding of various Informatica mappings for different stages of ETL.
• Extensively used transformations, like source qualifier, lookup (connected), router, expression, sorter, and rank, etc. To load the data, transform it as per business logic, and load it into the target Oracle database.
• Performed a full load and a delta load as per business requirements.
• Created materialized views that perform complex aggregations and high-cost joins.
• Partitioned fact tables and materialized views are used to improve performance.
• Developed views to present data for the presentation layer.
• Developed triggers in Oracle PL/SQL to insert records into history tables from transaction tables.
• Used Pragma Autonomous Transaction to avoid mutating problems.
• Created stored procedures, packages, and functions to move data from staging to the data mart.
• Performed tuning of SQL and PL/SQL queries using EXPLAIN PLAN and AUTOTRACE utilities.
• Developed and implemented a UNIX shell script for the start and stop procedures of the sessions.
• Created and presented weekly and monthly performance dashboards of the jobs, and documented related processes, trends, issues, observations, feasible solutions, and recommendations.
• Deployed code to different environments: SIT, QA, and UAT.
• Coordinated the release of code to the production environment and performed post-production validations.