Mona Sharma

• Lead multiple projects and applications, ensuring timely delivery and high-quality products. Received an excellence award for outstanding customer support.
• Proficient in research, requirement analysis, data analysis, data profiling, design, development, and implementation of solutions.
• Ensured the timely delivery of quality code from development to production, including thorough documentation and process implementation.
• Provided leadership and support to developers and testers, ensuring the delivery of quality code and conducting quality assurance testing within specified timelines.
• Worked extensively with business users and provided UAT & PROD support as needed.
• Delivered code in adherence to Freddie Mac processes, change management, standards, and Jira logging activities.
• Extensive experience in troubleshooting, root-cause analysis, impact analysis, incident management, and vulnerability fixes.
• Immense experience in performing gap analysis, data profiling, and providing data engineering solutions.
• Collaborated with, mentored, and trained college hires and junior developers.
• Teamed up with architects and information security leads to ensure the quality delivery of ETL products and solutions.
• Created data architecture, data mapping, and process improvement documents, along with presentations to stakeholders and IT teams.
• Documented Operations Handbook, Runbooks, Knowledge Base, and Knowledge Management Articles.

Lead multiple projects and applications, ensuring timely delivery and high-quality products.
Received an excellence award for outstanding customer support.
Proficient in research, requirement analysis, data analysis, data profiling, design, development, and implementation of solutions.
Ensured the timely delivery of quality code from development to production, including thorough documentation and process implementation.
Provided leadership and support to developers and testers, ensuring the delivery of quality code and conducting quality assurance testing within specified timelines.
Worked extensively with business users and provided UAT & PROD support as needed.
Delivered code in adherence to Freddie Mac processes, change management, standards, and Jira logging activities.
Extensive experience in troubleshooting, root-cause analysis, impact analysis, incident management, and vulnerability fixes.
Immense experience in performing gap analysis, data profiling, and providing data engineering solutions.
Collaborated with, mentored, and trained college hires and junior developers.
Teamed up with architects and information security leads to ensure the quality delivery of ETL products and solutions.
Created data architecture, data mapping, and process improvement documents, along with presentations to stakeholders and IT teams.
Documented Operations Handbook, Runbooks, Knowledge Base, and Knowledge Management Articles.

As an Informatica Consultant at Expedia through Adoresoft Corporation, I undertook the following roles and responsibilities:
Extensively engaged in operational support, including deployments to Test, DR, and Production environments.
Managed users and folder privileges, ensuring proper permissions.
Conducted daily data validation and data quality checks at the database level using SQL scripts.
Utilized Informatica Server Manager to create, schedule, monitor sessions, and sent pre and post-session emails to communicate the success or failure of session execution.
Developed and unit tested Type I and Type II mappings.
Played a key role in loading Fact and Dimension tables in the Data Warehouse.

Conducted requirements gathering, data analysis, and offered data engineering solutions.
Recommended and designed end-to-end ETL solutions, collaborating closely with architects and leads to obtain approval.
Developed conceptual, logical, and physical designs for tables.
Architected ETL solutions, defining transformation rules, validation rules, and ETL logic.
Created data flow diagrams and source-to-target mapping documentation for data integrations.
Provided guidance to teammates in translating business requirements into technical solutions.
Automated User Developed Applications using ETL tools.

Conducted comprehensive data analysis and provided support for QA, UAT, and PROD phases.
Executed data profiling, facilitated process improvement, maintained department metrics, and ensured data integrity through the collection, association, review, and interpretation of data and operational processes.
Investigated root causes in case of failures and issues, recommending solutions and evaluating their impacts.
Played a central role in aligning the needs of the assigned operational business unit with capabilities delivered by IT and other departments, facilitating and governing advanced analytical discussions between all groups.
Generated various documents, including data mapping documents, Process Flow Charts, and Design Documents.

Loaded data from comma and pipe-delimited files to SQL Server.
Gathered requirements from the business and documented them.
Conducted analysis of source data and performed data profiling.
Wrote SQL queries to extract the desired data from Oracle.
Based on the results, created ETL technical specifications and mapping documents for the project team.
Designed and developed ETL mappings, facilitating the transfer of data from Oracle to SQL Server.
Utilized the Informatica Data Quality (IDQ) tool to provide data quality reviews to management.
Ensured adherence to deadlines and oversaw the deployment of all code to production.
Conducted data validation and resolved issues in case of discrepancies.
Troubleshot failures and recommended solutions.
Raised concerns and escalated risks when anticipated, proactively seeking resolution.
Implemented an automatic error reporting system through ETL, sending reports to the support team attached to emails.

Directly collaborated with clients and end-users to elicit ETL requirements.
Documented all requirements, ensuring comprehensive distribution to the entire team and conducting walkthroughs.
Conducted data analysis and data profiling to gain a thorough understanding of the source data.
Designed the solution and developed ETL code in alignment with project requirements.
Ensured timely delivery of ETL code, facilitating the loading of data in DEV, QA, and PROD environments.
Wrote SQL queries for analysis, testing, and data validation in Oracle.
Provided PROD and end-user support for the loaded data.
Ensured the implementation of the new solution without disrupting existing processes.

Gathered requirements by meeting with users and documented comprehensive business needs.
Performed thorough analysis and provided effective solutions.
Designed and developed solutions using ETL, ensuring correct implementation.
Verified with users and business stakeholders to confirm that their needs were met.
Assisted junior developers by providing guidance and solutions.
Mentored other developers in the implementation of solutions through Informatica.
Contributed to both long-term and short-term projects involving ETL solutions.
Coordinated with other teams such as Informatica Admin and Unix Admin, ensuring awareness of project details, needs, permissions, and accesses.
Took on the role of architecting the ETL design and solution for project work.
Supported other developers in meeting project deadlines.

Developed ETL/DI mappings, conducted unit testing, and ensured correct implementation all the way to PROD.
Provided comprehensive QA, UAT, and PROD support.
Diagnosed and fixed ETL defects in DI/DB, successfully implementing solutions in various environments.
Upgraded the ETL repository from SQL Server 2005 to SQL Server 2008.
Led the upgrade from Data Integrator v2 to Data Services v3, ensuring a seamless transition.
Established a virtual server on Windows 2008 and installed DS 3.2.
Executed the migration of code and upgraded the DI local and central repository on SQL Server 2008.
Configured a virtual client on a Windows 7 machine, troubleshooting and resolving various connectivity issues.
Created Job server and configured both client and server to ensure the code functioned optimally on the upgraded version across all machines.

Engineered the complete solution and architected the ETL process for Data Movement Control (DMC) & Reconciliation tables for the Data Mart tables loaded by Data Admin Console (DAC).
Designed & developed the DMC process for Financial Data Mart.
Created DMC and Recon design documents along with sample mappings to guide other developers.
Built the complete ETL architecture of the ASL project.
Developed Informatica mappings to load staging tables and create journal entries received from Pass-Thru and Event files.
Generated extensive documentation, including Design documents, Business Requirement Specifications, Unit Test Results Doc, Deployment plan, etc.
Mentored team members new to the Informatica ETL tool.
Performed performance tuning using session partitioning, reducing data load time by 40% for 84 million records, earning recognition from managers and team members for the achievement.
Provided SIT, UAT, and Production support to other teams, fostering positive relationships.
Played a key role in helping the operations support team understand all FDW processes and functionalities.
Mentored Level 3 support in operational and system understanding of the load process.

Designed and developed mappings, sessions, mapplets, worklets, and workflows.
Collaborated closely in versioning and team-based development.
Worked with various data sources, including relational databases (Oracle 10g), flat files, Unix (AIX), and tools such as SQL Nav, Toad, UltraEdit, HP Reflection, FTP Client, and Putty.
Actively utilized Admin Console and RTM utility for effective Informatica administration.
Provided support to an ETL team consisting of 12-15 developers.
Conducted repository maintenance and user management tasks.
Actively engaged in communication with other teams, including DBA, Unix, Testing, and Operations teams.
Created and scheduled various scripts through workflows for Informatica maintenance, including backup scripts, update statistics scripts for the Informatica repository, recycle scripts, removal of old logs scripts, auto-purge scripts, etc.