Himen Negandhi Email & Phone Number

Greater Atlanta Area

Design and develop BI processes to automate the existing manual tasks performed and reports generated by the business users. Optimize the current ETL process as needed.

Greater Atlanta Area

Sr. Software Engineer responsible for design and development of ETL needs for “Customer Experience” system. Also support the existing system by resolving the data issues, developing new ETL requirements, improving the system performance and debugging the existing code.• Gather and document the requirements for the Customer Experience system.• Design the architecture for the system. Develop the ETL system for the project.• Debug the legacy system to extract existing business rules and enhance upon them.• Support the existing BIS system by resolving the CRs related to data issues, working on new development and enhancing the reports.• Meet with the business users to understand flaws in the current system and suggest improvements.

Data Migration expert responsible for migrating data from legacy system to new system. Technical lead for team of 3 SQL developers. Successfully designed and implemented the data migration solution for migrating around 30 GB (10 million records) within the agreed SLA. Interacted with client for understanding current system, thereby did gap analysis, requirement elicitation and documentation. Proposed and designed technical solution including the data migration plan.• Responsible to design and develop data migration ETL system to migrate the data from legacy system to the new system.• Designed and documented the migration transformation rules on client interaction.• Designed the architecture for the migration process using staging tables, control tables, SSIS ETL packages, Error handling and logging, Data reconciliation and ETL automation.• Created and maintained important project documents like data flow diagrams including ER diagram, Data and column Mapping sheets, transformation rules, test cases, HLD and LLD, data mapping documents.• Created Error handling store procedures, process control tables, data transformation stored procedures, ETL status logging procedures and 10 SSIS packages for the ETL process including a master package for ETL automation.SSRS Reporting lead responsible for creating and maintaining 80 SSRS reports. Gathered requirements for the reports by taking requirement interviews with end users. Enhanced Performance for existing reports to meet the agreed SLA using advanced SQL skills. • Used new SQL 2008 R2 features like shared dataset (SSRS), recursive CTE, APPLY joins, ranking functions etc...• Received Client appreciation for having multiple technical skills and for suggesting change to SSRS reports which reduced excel tasks for the end users.• Suggested and Implemented visual changes to the reports to improve readability and make them more client specific.

Secaucus, Nj

SQL developer responsible for creating and maintaining 20 complex SSIS ETL packages to transfer data from transaction databases to forecasting Hyperion cubes. Designed and implemented the architecture for the entire ETL process including control tables, ETL automation, table partition, SSIS configuration, data archiving, error handling, process logging, data transformation and data reconciliation. • Created 10 SSIS packages to extract transaction data from 4 systems, transform data using mapping defined in 5 excel and 3 csv files.• Designed the architecture for the migration process including staging tables, control tables, SSIS ETL packages, Error handling and logging, Data reconciliation and ETL automation.• Implemented the ETL architecture including table design, nested SSIS packages, data validation procedures, mapping file archiving process, configurable error logging, ETL automation using SQL control tables, SSIS packages restart ability and configurable SSIS package configuration.• Used For and For Each loop to process multiple mapping files and used child packages to load multiple table partitions.• Increased ETL performance by loading incremental data using SQL table partition based on fiscal year, implementing SSIS restart ability to start the ETL package from the point of failure.• Created and maintained important project documents like ER diagram, transformation rules, test cases, HLD and LLD, data mapping documents.• Engaged in active discussions with different teams like QA team, Data Reconciliation team, transactional System team and end users to support project testing and provide excel reports using adhoc SQL queries.• Used new features of SQL server 2008 like Output clause, Merge command, recursive CTEs.• Received Client appreciation for detailed analysis and quick turnaround time.

Mumbai Area, India