Feb 2019 – May 2022 · 3 yrs 3 mos · Bengaluru, Karnataka, India

• Understand and communicate data requirements and needs.
• Drive and gather conversion mapping rules (business rules analysis) with business partners; including ad hoc meetings and workshops as appropriate
• Extract data from several sources
• Build cross reference/lookup rules and understand data relationships
• Transform data to target format and create load files
• Perform iterative analysis and work to refine rules and process to load data into target environments for multiple cut-overs
• Develop validation plans.
• Perform validation activities and report and document results
• Work with cross functional teams to trouble shoot load/pre-load data issues and support error resolution
• Manage and track conversion statistics and values and relevant reports as needed
• Prepare and execute data cleansing reports and activities as needed pre- and post-conversion.

Feb 2017 – Feb 2019 · 2 yrs · Bengaluru Area, India

• Database design, development and maintenance on SQL Server (2005/2008/2012)
• T-SQL including designing of databases, creation and troubleshooting of complex stored procedures, user defined functions, triggers and views
• Installation and configuration of SQL Server 2000, 2005, 2008, 2008R2, 2012
• Implementation of High Availability Disaster Recovery solution using Database Mirroring and Log Shipping, clustering.
• Implementing and managing backup strategy
• Applying patches and service packs to keep the database at current patch level
• Troubleshooting and problem solving skills that impact SQL Server performance using Event viewer, Profiler, Performance monitor.

Feb 2014 – Feb 2017 · 3 yrs · Bengaluru, Karnataka, India

• Gather requirements for Data Migration by working closely with business users
• and also provide timeline and cost estimates for the project
• Extract Data from various Client based Databases like SQL Server, Oracle, Sybase and cloud based EHR Databases
• Extensive Database Schema Analysis to find required data for migration
• Determine vivid relations between data across the database and generate crosswalk tables
• Create specification document which includes detail data migration plan
• Negotiate client requirements and set expectation for data migration
• Migrate data into eClinicalWorks Database using SSIS and custom JAVA Programs
• Schedule automated batch migration/data upload based on the business needs
• Performing the unit testing after the migration to check migration is performed as per client’s
• requirement
• Generate SQL scripts for data cleansing as per client requirements
• Technologies: Java, SQL Server 2008, MySQL, MS Access

Jul 2013 – Jan 2014 · 6 mos