Gayatri Kusampudi

• Analyzed user requirements, designed and developed ETL processes to load enterprise data into the Data Warehouse.
• Created conceptual, logical and physical data models for use in different business areas.
• Have advanced knowledge of T-SQL and/or ANSI SQL, ETL and Data Warehousing
• Developed ETL Processes with SSIS, SQL Stored procedures, and C # scripting.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed and developed SSIS packages to move data from various sources into destination flat files and databases.
• Proven ability in Troubleshootiing SSIS packages to resolve Performance issues
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence and writing MDX Scripting.
• Having Solid hands on Experience on T-SQL Queries, Procedures, Partitions and its Maintenance.
• Having solid experience in performing RCA's

● Worked in internal Project of financial Team.

● Worked in Metadata driven ETL Environment using SSIS.

● Gained an experience of migrating on premise SQL to Azure dataware house.

● Involved with product team and project teams to discuss the limitations of Azure and their future release which could support our project migration which working on POC's.

● Did Extensive POC’s on AzureDatalake, Azure data warehouse

● Wrote various technical documents, gathering Business Requirements, Functional and Technical Specifications, Data Flow and Process diagrams using MS Visio tools.

● Been a part of migrating extensive Crystal reports from Teradata backend to Microsoft Parallel Dataware house (PDW) and now called as Appliance.

● Been a part of recursive Requirements gathering session with End users and Business Analysts.

● Contributed to logical and physical data modeling for the new data warehouse.

● Prepared technical designs for SSIS mappings.

● Developed mapping for fact loading from various dimension tables.

● Designed tabulars for reporting.

● Integrated data quality plans as a part of ETL processes.

● Debugged existing ETL processes and did performance tuning to fix bugs.

● Had tuned complex report queries to improve the performance of the reports

● Participated in brain storming sessions.