Mona Sharma Ph: 312-***-****

Sr. Data Engineer Email: ad3hua@r.postjobfree.com

Summary:

• Over 18 years of extensive experience in data architecture, data integration, data analytics, data engineering, and data modeling and design solutions.

• Proven track record across diverse industries including Mortgage, Finance, Federal, Investment & Securities, Health Insurance, Travel, and Oil/Gas Industry.

• Adept at creating robust data solutions to meet business needs, leveraging a comprehensive skill set in data management and design.

• Extensive proficiency in the realms of Data Warehousing, Datamart, and Data Integration leveraging advanced ETL tools and technologies.

• A highly seasoned and proficient professional, demonstrating over a decade of expertise in ETL technologies while occupying a lead role.

• Accumulated five years of hands-on experience in Informatica Administration, specializing in ETL tools and proficiently managing user access controls.

• Evidenced as a self-motivated team player, showcasing excellence through an all-inclusive approach.

• Demonstrates proven excellence in technical expertise, data analytics, root cause analysis, and problem-solving skills.

• Proficiently adept in conducting impact analysis, risk analysis, and implementing effective risk mitigation strategies.

• Recognized for displaying self-initiative and a rapid learning aptitude, possessing the capability to function both independently and collaboratively within a team environment.

• Recognized as a dependable individual contributor with robust technical, communication, development, documentation, and management skills.

• Possesses formidable planning, organizing, decision-making, and negotiating skills.

• Demonstrates a proven ability to cultivate professional relationships with customers, senior staff, and co-workers.

• Expertise lies in Decision Support Systems, Data Warehousing, and Online Analytical Processing technologies. ● Exhibits strong analytical, quantitative, troubleshooting, and problem-solving skills

• Possesses a comprehensive understanding of Business Intelligence and dimensional models.

• Brings extensive experience in analyzing risks, impact, mitigation, and remediation solutions.

• Acts as a coach and mentor to other team members, including new hires, analysts, and developers

• Adept at creating design, data architecture, maintenance, and operational documentation. Skill Set:

Informatica PowerCenter 7.x/8.x/9.x/10.x, Informatica Cloud (IICS), Power Exchange, Informatica IDQ, Informatica MDM, RTM, EPM Cloud Applications, OBIEE Reporting, Hyperion SmartView, DAC (Data Warehousing Console), Oracle 8/9/10/11, SQL Server 2000/2005/2008/2012/2016/2017, Peoplesoft 10, TOAD, SQL Navigator, SQL Developer, SQL Server Management Studio, SQL*Plus, SQL Loader, Designer, Repository Manager, Workflow Manager, Workflow Monitor, Unix/Linux/AIX/HP, Shell Script, Informatica Debugger, SQL/PL SQL, HTML/XML, MS Excel/Word/PowerPoint/Visio, Putty/HP Reflection, Star Schema, Snowflake Schema, MS-Office, Lotus Notes, WinSCP/HP FTP Client, Dimensional Modeling, Windows XP/NT/2003, DB2 UDB, RTM Service, Kimball/Inmon Models, ETL Administration, SQL Developer, ClearCase, ClearQuest, DART & Doors System, Rapid SQL, Hummingbird Exceed, SharePoint, Business Objects Data Integrator 2.0, Informix 10, DataStage 11.5, SSIS 2012, Control-M 9.0, MobaXTerm 9.4, Jira 7.13, Gitlab 12.2.5, GitEye 1.10, Teamforge, Python, AWS services, NoSQL, MongoDB, Snowflake, Git Eye, Git Hub, CI/CD pipeline, Confluence, Jenkins, Docker, Kubernetes. Education:

● Master of Computer Application, Sikkim Manipal University, Karnataka, India.

● Master of Information Technology, Manipal Academy of Higher Education, Karnataka, India.

● Bachelor of Computer Applications with Honors, Punjab Technical University, Punjab, India. Training:

● Informatica Administrator 8 Training from Informatica Corp.

● Informatica PowerCenter 8 Level II Developer Training Informatica Corp.

● Oracle BI 11G R1: Create Analyses and Dashboards from Oracle University.

● SAP Business Objects Data Services 3.0 online training.

● High Level Overview in-class training of Hyperion SmartView.

● SAFe Agile and Data Development Life Cycle training.

● Udemy Training on Python Bootcamp.

Freddie Mac – McLean, VA

Sr. Developer May 2020 - Current

Rejoined Freddie Mac and contributed a total of approximately 7 years as a Senior Developer, playing a key role in various reporting projects. My roles and responsibilities include:

• 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. Environment: Informatica 10.x, Autosys, EPM Cloud Applications, Oracle 11, Linux 12.0, SSMS 2018, GitEye 1.10, Teamforge, MobaXTerm 9.3, WinSCP 5.7.5, Jira, Putty, SQL Developer 19.4, CyberArk 10.10, Service Now, SAFe Agile, Python, AWS S3, CI/CD Pipelines, Jenkins, Docker.

USAA – Phoenix, AZ

Sr. Data Engineer Oct 2018 – May 2020

Joined USAA in October 2018 as a Senior Data Engineer and actively contributed to a variety of projects. During my tenure, I had the opportunity to serve as both a program layer team member and an execution layer team member. My roles and responsibilities encompassed:

● 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. Environment: DataStage 11.5, Control-M 9.0, Oracle 12, Linux 2.6, SSMS 2017, Gitlab 12.2.5, MobaXTerm 9.4, WinSCP 5.7, Jira 7.13, Putty, SQL Developer 17.4, Password Safe 3.23

Kern Health Systems - Bakersfield, CA

Sr. Developer/Analyst Mar 2017 to Dec 2017

As a Senior ETL Developer (Senior Analyst) at KHS, I held the following roles and responsibilities:

● Conducted comprehensive data analysis and provided support for QA, UAT, and PROD phases.

● Investigated root causes in case of failures and issues, recommending solutions and evaluating their impacts.

● 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.

● 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. Environment: Informatica 9.1, MS-SQL Server 2012, Test Rails, Online Portal and Dashboard, M-Files, Incident and Change Ticket Online Tracking System, MS-Excel, MS-PowerPoint, CSV Files, Agile Methodologies. Cetera Financial Group

Sr. ETL Developer Aug 2015 – Mar 2017

As a Senior ETL Developer in El Segundo, CA, I took on the multifaceted role of ETL Team Lead, Informatica Admin, and Senior Developer. My responsibilities included:

● 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.

● Loaded data from comma and pipe-delimited files 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. Environment: Informatica PowerCenter 9.6.1, Oracle SQL Developer 1.5.5, SQL Server 2008, Oracle 11.2, Informatica IDQ, Putty, Flat Files, WinSCP 4.0.4, Active Batch7, Active Batch 9, Unix Server Honda, CA

Tech Lead May 2015 – Aug 2015

As a Tech Lead at Honda in Torrance, CA, engaged in a short-term project of 3 months through Accenture, I played a pivotal role with the following responsibilities:

● 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. Environment: Informatica PowerCenter 9.1, Toad 9, Oracle 10g, Putty, Flat Files, Linux server, Power Exchange 9.1. Aera Energy, CA

Sr. ETL Consultant Feb 2013 – Jan 2015

As a Senior ETL Consultant at Aera Energy in Bakersfield, employed through Avadine, I fulfilled a range of roles and responsibilities including:

● 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.

● Supported other developers in meeting project deadlines.

● 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. Environment: Informatica PowerCenter 9.0.1, Toad 9.5, Toad 11.6, SQL Server 2008 R2, Oracle 10g, Putty, Flat Files, Exceed. US Courts, Washington DC

Sr. Software Engineer April 2012 – Nov 2012

As a Senior Software Engineer (Senior Consultant) at US Courts, Washington DC, employed through Guident Technologies, I held a diverse range of roles and responsibilities, including:

● 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.

● Led the upgrade from Data Integrator v2 to Data Services v3, ensuring a seamless transition.

● Upgraded the ETL repository from SQL Server 2005 to SQL Server 2008.

● 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.

Environment: Business Objects Data Integrator 11.7.3.5, Informix 10, SQL Developer 2005, WinSCP FTP Client, Clearcase, Clearquest, Flat Files, Documentum, DB Visualizer 8.0.8.

Freddie Mac

Development Professional Jan 2010 – April 2012

Joined Freddie Mac as a Development Professional, contributing to diverse projects such as Financial Data Mart, Accounting Sub- Ledger (ASL), Financial Data Warehouse (FDW), Expense Planning, Budgeting & Forecasting (EFF), and Expense Reporting (ER). My roles and responsibilities included:

● 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. Environment: Powercenter 8.1, Versioning, Solaris 10, SQL Developer, Exceed Hummingbird FTP Client, Clearcase, Clearquest, Peoplesoft 10, DAC Scheduler, Hyperion Essbase, Sharepoint, Smartview, DAC scheduler. CDPHP, NY

ETL Developer Nov 2007 - Sep 2009

In CDPHP, I served as an ETL Developer and Informatica Administrator with the following roles and responsibilities:

● 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. Environment: Powercenter 8.0/8.1/8.6, Versioning, IBM AIX 5.0, Oracle 10g, SQL Nav, Toad, Putty, HP Reflection, HP FTP Client, Ultraedit, Admin Console, RTM, IBM Clearquest online tracking tool, Remedy tool. Expedia Inc., WA

Informatica Consultant Apr 06 – Oct 07

● 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. Environment: Informatica Powercenter 7.1.3 and 7.1.4, SQL Server 2000/2005, DB2 UDB Version 8 (Command Editor), Toad, WinSql, Windows Professional XP, Linux, Putty, Perforce, Jira, Raid, WinSCP.

Contact this candidate