We provide IT Staff Augmentation Services!

Lead And Onsite Manager Resume

SUMMARY

  • 11+ years of proven IT experience (with 7+ years of experience in United States) in White box testing (ETL, SAS reports, Database upgrade /migration testing), UNIX shell programming, Python scripting, Automation using shell scripts, Oracle SQL Development, Data Analyst, Test Data Management, SAS to Oracle migration, Oracle Database Administration, PLSQL, SQL, Data Migration and Red Hat Linux Administration
  • Certified Red Hat Linux Engineer and very strong in UNIX scripting
  • Good knowledge in automation using Python scripting
  • Very strong in data intensive testing like ETL testing, Business Intelligence Reporting, PEGA business rules validation, Data Migration, Database Upgrade, Legacy Application migration, Application migration, Master Data Management and SAS reports for various US government projects
  • Lead teams through agile, scrum and waterfall SDLC models. Created Test Strategies, Test Plans and provided estimations to management
  • 2+ years of project level resource management experience
  • Performed ETL testing using INFORMATICA, analyzed mapping documents, tested Filter, Rank, Lookup, Aggregator and Joiner transformations thoroughly
  • Strong in SQL scripts and reverse coding for SAS Reports that are based on Behavioral health, Primary care physicians and Non - BH Reporting (Pharmacy and Medical)
  • Strong in Oracle at Architectural level and in UNIX shell scripting, played key role in coordinating with data teams, development teams during various stages of the project in creating data, testing swiftly, efficiently and to meet release deadlines in the scrum environment with no compromise on quality and reduced turnaround time that’s involved in fixing an issue in process.
  • Successfully lead and managed ICD-10 Legacy Insulation solution with a strong hold on International Classification of Diseases-10
  • Certifications - PAHM(Professional, Academy for Healthcare Management), Test Data Manager - Advanced Certified, Foundation and Advanced Level certified, Oracle 12c Certified Database Administrator (OCA), REDHAT LINUX Certified Engineer (RHCE), Accredited Integration Specialist (AIS), CTFL - ISTQB Foundation Level Certified

PROFESSIONAL EXPERIENCE

Confidential

Lead and onsite manager

Responsibilities:

  • Worked as a Lead and onsite manager handling a team of 8 associates as part of Database and ETL testing and automation using shell scripts
  • Created more than 50 new UNIX shell scripts as part of 12c migration and organizational modernization
  • Created pre and post SQL scripts for INFORMATICA module as wrappers to validate testing
  • Validated QA deployments to track and make deployments transparent to QA team thus avoiding defect hiding and validated the release document efficiently against what was deployed
  • Proactively solved gaps in requirements, environment issues, deployment issues and system configuration issues
  • Received Bravo awards from client for outstanding performance for automating Oracle 12c migration scripts, Provider Sync shell scripts automation and ETL testing
  • Tested INFORMATICA ETL transformations like Filter, Rank, Lookup, Aggregator and Joiner transformations thoroughly. Very strong in automation using shell scripts for routine tasks.
  • Onsite lead for INFORMATICA, Java, PLSQL, Shell scripts, environment readiness, System integration modules and conducted business user trainings
  • Responsible for testing various ETL transformations and part of mapping document creation
  • Successfully completed ICD-10 migration

Confidential

Lead and onsite manager

Responsibilities:

  • Created UNIX scripts for Medicare and Medicaid reports for different states - Kentucky, Hawaii, Georgia, Florida, Missouri, Illinois, New York and New Jersey
  • Data load using UNIX scripts that involved with more than 258 INFORMATICA workflows
  • Validated end to end workflows including Lookup, stored procedure, rank, joiner and look up transformations making sure the source files from different vendors and plan partners were loaded successfully to the client database system
  • Extensive Database testing and INFORMATICA load validation of the flat files
  • Technical point of contact for all SAS critical reports ensuring delivery on time redefining tangible quality in the team
  • Created a new process to help Confidential client to test SAS reports efficiently with more quality
  • Extensive testing of SAS reports by reverse coding for Medical, Pharmacy, Behavioral, Non-Behavioral reports
  • Tuned SQL Queries to provide better performance for SAS report validation
  • SQL Assistance to SAS Team Dev and QA to improve SAS Code on Technical and Business front

Confidential

Lead and onsite manager

Responsibilities:

  • As the Data Migration Lead, actively participated discussions with Data Architects, Business Analysts, DEV Team and SMEs in understanding source and target systems
  • End to end application testing for PEGA application which also helped to enhance the credit cards portal
  • Created an approach to test the legacy systems that are migrated to PEGA and published white paper. White paper got published in an international conference. Details will be shared upon request
  • Developing SQL Queries to make sure of the proper Data Migration through the old Mainframes system that is being deprecated to the new PEGA BPM system.
  • Understanding Physical Data Model, Data Mapping and DB Design documents
  • UAT and Production support for the Data Migration module

Hire Now