Mona Sharma Email & Phone Number

Plano, Texas, United States

Rejoined Freddie Mac in 2020, pivotal role in key reporting projects, earning accolades for exceptional customer support. Expertise spans development lifecycle, from research and requirements analysis to design and implementation. Leader in ensuring on-time delivery of high-quality products, consistent accolades and awards for excellence. Commitment to quality code, documentation, and process implementation, consistent hallmark.Experience Highlights:Played principal role in key reporting projects, earning accolades for exceptional customer support.Led various projects, ensuring on-time delivery of high-quality products, resulting in recognition and awards.Excelled in delivering quality code from development to production, prioritizing thorough documentation.Provided leadership, guiding developers and testers, offering UAT & PROD support while strictly adhering to processes and change management.Specialized in advanced Static Application Security Testing (SAST), FOSS scans, CERT upgrades, and robust password encryption in realm of security.Collaborated with InfoSec teams to fortify system security and effectively mitigate risks.Foreseeing potential risks, proactively recommended risk mitigation strategies, contributing to robust and secure data environment.Expertise in gap analysis, data profiling, and data engineering solutions, ensuring quality delivery of ETL products by working closely with architects and information security leads.Mentored and trained junior developers, fostering collaboration.Created vital documentation, including data architecture, mapping, and process improvement documents, along with Operations Handbook, Runbooks, Knowledge Base, and Knowledge Management Articles.As Lead Data Engineer, comprehensive technical proficiency, leadership, and commitment to excellence, coupled with proactive risk management, contribute to success in complex technical environments.

Phoenix, Arizona, United States

Proven Senior Data Engineer at USAA, showcasing a dynamic combination of technical expertise and leadership. My contributions to diverse projects, coupled with a focus on program and execution layer responsibilities, demonstrate my commitment to excellence. Beyond routine tasks, I actively engage in company events and mentor colleagues to foster a collaborative and growth-oriented environment.Highlights:Successfully centralized payment and accounting entries in compliance with ASC 842, demonstrating a notable achievement. The end-to-end design of the ETL solution, collaborated for approval, underscores my dedication to efficiency.Throughout my tenure, I consistently translated complex business requirements into effective technical solutions, ensuring alignment with the CFO architecture.Actively supported the decommissioning of User Developed Applications (UDAs) by designing ETL solutions that adhered to CFO standards, emphasizing a commitment to organizational efficiency.Drove compliance goals by delivering comprehensive documentation for the Leases project. Regular engagement in meetings with architects and proactive involvement in Data Development Life Cycle (DDLC) training highlighted my alignment with Information Governance processes.Displayed leadership in risk mitigation and compliance through mentoring, addressing data control concerns, and implementing COBIT controls.Actively supported UDA projects and optimized OneSumX PAM ETLs, reflecting my ongoing commitment to efficiency and standardization in diverse technical environments.

Bakersfield, California, United States

Excelling in comprehensive data analysis, I provided crucial support in all environments. Proficient in investigating and resolving root causes, I recommended effective solutions, leveraging advanced skills in report writing and business analytics. I significantly contributed to dashboard reporting efforts, aligning operational needs with IT capabilities and fostering advanced analytical discussions.Highlights:Adept in comprehensive data analysis, offering crucial support in all environments.Investigated and resolved root causes for failures and issues, consistently recommending effective solutions.Leveraged advanced skills in report writing and business analytics, contributing significantly to dashboard reporting efforts.Excelled in data profiling, process improvement, and ensuring data integrity through meticulous data collection, association, review, and interpretation.Played a pivotal role in aligning operational business units' needs with IT capabilities, fostering advanced analytical discussions.Possessed an advanced understanding of the organization's data analytical tools, bringing extensive experience in methodologies and techniques for data analysis.Proficient in SQL within large operational data stores or warehouses, creating complex charts, pivot tables, formulas, and calculations.Actively mentored junior and peer roles across all levels of complexity in analytics, report writing, and presentation.Contributed to essential documentation creation, including ETL mapping documents, process flow charts, and design documents.Proactive and skilled professional, delivering impactful insights and ensuring data-driven decision-making processes.

El Segundo, California, United States

In the role of Sr. ETL Developer and Lead at Cetera, I encompassed responsibilities as ETL Team Lead, Informatica Admin, and Sr. Developer, overseeing the project lifecycle comprehensively. From gathering business requirements, analyzing source data, to designing ETL technical specs and managing project deployments, my involvement was pivotal for project success. My expertise spanned ETL mappings, data loading, data quality reviews, and exposure to Big Data and Hadoop technologies. Integral to my role was leadership in team management, collaboration with offshore teams, and active participation in meetings and ticket management.Highlights:Led roles as ETL Team Lead, Admin and Sr. Developer, taking charge of end-to-end responsibilities in the project lifecycle.Gathered business requirements, documented, and analyzed source data using SQL queries on Oracle.Designed ETL mappings from Oracle to SQL Server, conducted data quality reviews using IDQ.Managed entire code deployment to production, conducted data validation, and addressed daily and monthly job functionalities.Actively managed team responsibilities, scripted Informatica workflows, scheduled them in Control-M, and participated in QA and PROD deployments.Collaborated with offshore teams, gaining exposure to Big Data and Hadoop technologies.Participated in CCB meetings, agile methodologies, and scrum meetings with project managers.Played a significant role in Jira and Help desk ticket management, proactively raising concerns and escalating risks.Communicated effectively with various teams, including Managers, BAs, DBAs, Business Users, Data modelers, and Architects.Ensured a holistic approach to project management, contributing to designing, development, testing, deployment, and post-deployment responsibilities for both myself and my team.Overseeing the entire development lifecycle, with added exposure to Big Data and Hadoop technologies, emphasizing collaboration and leadership throughout.

Torrance, Ca

As a seasoned Tech Lead at Honda through Accenture (May-August 2015), I played a pivotal role in a short-term project, engaging directly with clients and end-users. My expertise included gathering ETL requirements, meticulous documentation, comprehensive data analysis, and profiling. I ensured timely delivery, smooth data transitions, and provided unwavering support in Oracle, crafting SQL queries for analysis and data validation. My commitment to excellence was evident in creating automated solutions for flat file generation, showcasing efficiency enhancement.Achievements:Engaged directly with clients and end-users, gathering ETL requirements and meticulously documenting them for team comprehension.Performed comprehensive data analysis and profiling, designing efficient solutions, and developing precise ETL code.Ensured timely delivery, facilitating smooth data transitions across development, quality assurance, and production environments.Proficient in Oracle, crafted SQL queries for analysis and data validation.Provided unwavering production and end-user support, guaranteeing a seamless experience while safeguarding existing processes.Demonstrated commitment to excellence by creating automated solutions for flat file generation, streamlining processes, and enhancing overall efficiency.

Bakersfield, California, United States

As a Senior ETL Consultant at Aera Energy in Bakersfield through Avadine. Pivotal for successful project outcomes, covering ETL lifecycle, showcasing expertise in translating business needs, conducting analyses, and implementing solutions. Mentored, collaborated, and contributed significantly to projects, demonstrating adaptability. Recognized for addressing production break fixes, ensuring successful solution implementation through collaboration, meticulous documentation, and identifying patterns. Operated in Agile and Scrum framework, maintained transparent communication, addressed issues promptly, and offered effective ETL solutions.Achievements:Recognized for identifying patterns and resolving missing data issues.Drove successful project outcomes as lead Consultant.Engaged in end-to-end ETL lifecycle, translating business needs into actionable requirements and implementing innovative solutions.Collaborated with users and business stakeholders, confirming alignment with expectations.Assumed mentorship role, guiding junior developers and fostering a collaborative environment.Contributed significantly to long-term and short-term projects, demonstrating adaptability and versatility in crafting ETL solutions.Addressed production break fixes with agility, creating CCB tickets and facilitating approvals.Collaborated with Informatica Admin and production deployment team, ensuring successful solution implementation.Created comprehensive documentation, including design documents, mappings, runbooks, and scheduling request forms.Supported QA team in testing and clarifying requirements, emphasizing commitment to quality.Operated within Agile and Scrum framework, maintaining transparent communication, providing regular updates, and addressing issues promptly.Delivered impactful solutions within dynamic project environments, underscoring multifaceted track record.

Washington, District Of Columbia, United States

As a Senior Software Engineer at the US Courts in Washington DC, employed through Guident Technologies. Led mission-critical ETL/DI initiatives, developed robust mappings, and ensured flawless PROD implementations. Upgraded Data Integrator v2 to Data Services v3, migrated ETL repository, and demonstrated technical acumen in server setup and troubleshooting. Managed ClearQuest tickets, collaborated with clients, facilitated migrations, and mentored junior developers, showcasing commitment to technical excellence in complex government environments.Achievements:Led mission-critical initiatives, integrating cutting-edge ETL/DI solutions at the US Courts in Washington DC.Developed robust ETL mappings, oversaw unit tests, and ensured flawless PROD implementations.Provided pivotal support across all phases.Upgraded Data Integrator v2 to Data Services v3 and orchestrated ETL repository migration from SQL Server 2005 to SQL Server 2008.Demonstrated technical acumen in setting up virtual servers, troubleshooting connectivity issues, and implementing performance testing strategies.Managed ClearQuest tickets, collaborated with clients, and documented Configuration Management workflows.Facilitated bi-directional migrations of ETL/DI and BI objects.Demonstrated leadership by mentoring junior developers, contributing to their professional growth.Showcased commitment to technical excellence in navigating complex, high-stakes government environments.

Mclean, Virginia, United States

Development Professional at Freddie Mac from January 2010 to April 2012, showcasing expertise in ETL processes and data management across impactful projects. Led ETL solution architecture for various projexts and demonstrated end-to-end capabilities in optimizing data processes, reflecting versatile professional and technical skills across domains.Achievements:Led ETL solution architecture for Financial Data Mart (FDM) and designed end-to-end processes for Accounting Sub-Ledger (ASL).Spearheaded Financial Data Warehouse (FDW) implementation, showcasing proficiency in Powercenter, Oracle, and critical technologies.Executed ETL processes in Expense Planning, Budgeting & Forecasting, contributing to seamless data integration into Hyperion.Led performance tuning initiatives, resulting in a 40% reduction in data load time.Played a vital role in mentoring team members and collaborating with cross-functional teams.Demonstrated end-to-end capabilities in optimizing data processes through hands-on involvement from design to development to implementation.Exhibited extensive documentation practices, leadership in project execution, and commitment to excellence.

Albany, New York, United States

Dedicated ETL Developer and Informatica Administrator at CDPHP, driving successful data integration initiatives. Meticulously designed and developed end-to-end ETL processes, overseeing Informatica administration tasks. Proficient in transformations, testing methodologies, and SQL query writing, contributing to seamless deployments and maintenance scripting. Demonstrated expertise in translating business requirements into technical solutions, showcasing commitment to impactful data solutions in a collaborative environment.Achivements:Played a pivotal role in driving successful data integration initiatives at CDPHP.Meticulously designed and developed mappings, sessions, and workflows for robust data management solutions.Oversaw Informatica administration tasks, including versioning, team-based development, and repository management.Contributed to effective communication and collaboration within the team.Proficient in various Informatica transformations and testing methodologies.Ensured seamless deployments, environment setups, and maintenance scripting.Engaged in performance tuning, SQL query writing, and actively involved in complex projects like HDMS.Translated business requirements into technical solutions, demonstrating expertise in ETL development and administration.

Bellevue, Washington, United States

Versatile Informatica Consultant at Expedia through Adoresoft Corporation, excelling in dual roles as Informatica Developer and Administrator. Specialized in extensive ETL Informatica PowerCenter development, operational support, code migration, and data integrity across diverse environments. Proficient in Informatica transformations, SQL scripting, and PowerCenter client tools, contributing to successful deployments and seamless data transitions in Data Warehousing projects.Achievements:Excelled in extensive ETL Informatica PowerCenter development and operational support.Managed users and folder privileges, executed daily data validation and quality checks.Utilized Informatica Server Manager for session creation, scheduling, and monitoring.Proficient in various Informatica transformations, SQL scripting, and PowerCenter client tools.Designed mappings, developed tasks, and created workflows.Facilitated numerous successful Informatica deployments to QA, UAT, and Production environments.Contributed significantly to loading data into staging tables, unit testing of mappings, and development of Fact and Dimension tables in Data Warehousing projects.

Master Of Science - Ms, Computer Science

Master Of Science - Ms, Information Technology

Bachelor Of Science - Bs, Computer Science