Project Management On-Site

Saipriya Satyamsetty

Contact:*********@*****.***

Professional Summary

Highly experienced IT professional with over 16 years in project management, data warehousing, ETL processes, and cloud technologies. Proven expertise in obtaining project approvals, designing architecture, and aligning deadlines with Agile frameworks. Strong background in managing metadata, transforming data from various sources, and utilizing Informatica Cloud tools for efficient data integration and reporting. Skilled in programming and scripting with SAS, Java, Python, and Databricks, and adept at resolving production issues and providing stakeholder updates.

Key Skills

Project Management: Obtaining project approval, architecture design, aligning project deadlines with Agile framework, extensive project planning, decision-making for tool purchases.

Data Warehousing: Strong experience with Informatica PowerCenter (10.x/9.x/8.x/7.x), ETL, Netezza, Oracle, SQL Server.

ETL Processes: Managing metadata, transforming data from various sources (flat files, XML, MSMQ, Oracle) to data warehouse, ETL data migration, creating production migration tickets.

Informatica Cloud Tools: IDQ, Avion, Data Catalog, Reporting tools.

Dimensional Modeling: Creating slowly changing dimensional models, error handling, SDLC documentation.

Programming and Scripting: SAS programming, Java, Python, Databricks.

Cloud Technologies: AWS S3, AWS Aurora MySQL, Azure Data pipelines, AI tools.

Production Support: Resolving production issues, providing updates to stakeholders.

Clearance

Active Secret and Public Trust

Education

MS in Computer Applications

Certifications

Certificate of Achievement – Power Center 8.5+ Administrator

Professional Experience

Devtech Systems (USAID)

Data Engineer Specialist

Aug 2024 – Feb 2025

Master Data Warehouse Design: Designed a comprehensive master data warehouse to consolidate and manage data from various bureaus including NGA, DoS, and USAID. Ensured data integrity and accessibility for analytical purposes.

Informatica Cloud Tools Utilization: Leveraged Informatica Cloud tools such as IDQ, MDM, Data Catalog, Reporting tools, IICS, and IDMC to streamline data integration, management, and reporting processes.

AI Tools Testing: Tested AI tools like Azure Speech and AWS Transcribe to evaluate their effectiveness in automating data transcription and speech recognition tasks. Explored open-source AI tools to identify potential applications in data processing and analysis.

ETL Mappings and Workflows Creation: Developed ETL mappings and workflows using Informatica Data Quality (IDQ) and Informatica Intelligent Cloud Services (IICS) to automate data extraction, transformation, and loading processes.

Data Migration: Successfully migrated data from legacy systems, encompassing over 400 tables, into Oracle databases. Ensured seamless data transfer and integration with existing systems.

Inter-Agency Data Mapping: Created data mappings between different agencies using IICS to facilitate data sharing and collaboration. Ensured data consistency and accuracy across various platforms.

Report Creation Collaboration: Worked closely with the USAID team to understand reporting requirements and deliver accurate and timely reports. Utilized advanced reporting tools to generate insights and support decision-making.

AI Tools Evaluation: Conducted thorough testing of AI tools such as Azure Speech, AWS Transcribe, and various open-source AI solutions to assess their capabilities in enhancing data processing workflows. Provided recommendations based on performance and suitability for specific tasks.

Randstad Technologies (Federal Reserve Board, D.C)

IT Specialist

Mar 2014 – May 2024

NIC System Development: Worked on the NIC System, transforming data from SQL Server, Mainframes, and Oracle into XML/CSV files for agencies such as OCC, FDIC, SEC, and NCUA.

Cloud Migration: Migrated data into Azure cloud using data pipelines, ensuring seamless integration and accessibility.

Python and Databricks: Extensively used Python and Databricks scripts for data processing and analysis.

ETL Pipeline Administration: Administered and developed ETL pipelines, ensuring efficient data flow and transformation.

Workflow Migration: Migrated workflows from on-premises to Informatica Intelligent Cloud Services (IICS), enhancing scalability and performance.

Data Loading: Used ETL to load data from SQL Server, Mainframe, and Oracle databases into the data warehouse.

Performance Improvement: Improved session performance and job runtime by optimizing existing processes and configurations.

Testing: Conducted unit testing and user acceptance testing (UAT) for ETL-Informatica applications to ensure data accuracy and system reliability.

Production Issue Troubleshooting: Troubleshot various production issues, providing timely resolutions to maintain system stability.

Data Integration:

Read data from FRB NY Postgres DB and loaded it into the FRB database, ensuring data consistency and availability.

Read data from FRB Dallas from AWS Aurora and loaded into FRB DB through ETL process.

Read files from AWS S3 for one of the agency and loaded into FRB DB through ETL process and passed on to agencies as per MOU.

Bank of America, NY

VP, IT Specialist

Oct 2009 – Apr 2011

Bank of America is one of the world’s largest banks. As a VP, I managed both on-site and offshore teams, worked independently, and communicated with various stakeholders about ongoing and upcoming projects. I worked in the Sales and Reporting group.

Key Responsibilities:

Business Analysis and Documentation: Created functional and business documents for developers, collaborated with data modelers to create star schema models.

ETL and Data Integration: Used ETL to load data from Oracle databases, flat files, and XML to Netezza Data Warehouse. Worked on ETL-Informatica transformations (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer) to extract sources, transform data, and load into targets.

Informatica Administration: Installed Informatica Power Center 8.6 on Solaris machines, upgraded and migrated Informatica Repository, troubleshot various production issues, and worked on transformations (Connected and Unconnected Lookup, Aggregator, Expression, Filter, Router, Update Strategy, Connected and Remote Stored Procedure, Sequence Generator, Sorter).

Performance Improvement and Testing: Improved session performance by enhancing existing mappings/sessions/database tables, conducted unit testing and integrated system testing, conducted unit testing and user acceptance testing (UAT), migrated folders from Development to Test and Test to Production environments.

Operational Management: Loaded messages using MQ series, managed nightly critical loads to meet SLAs, monitored and reduced warehouse load time, worked with offshore and onshore subcontracting teams.

Informatica Configuration and Support: Upgraded Informatica from 8.6.1 to 9.1, configured Power Center domain, nodes, grids, created different services in the domain, applied hotfixes, configured OS-profiles and LDAP security, conducted Informatica backup and restore, assisted developers with ETL code issues, created users, groups, roles, granted privileges, created folders, relational and application connections, configured ODBC connectivity, registered plug-ins to connect to applications.

Nomura Securities Intl, NY Jan ’05 –Sep ‘08

ETL Lead/ Consultant

Environment: ETL -PowerCenter 7.x/8.x, PowerExchange- MSMQ, Linux – 5.8, Windows XP Professional, Oracle10g, PL/SQL, TOAD 8.0, Unix Shell Scripting, Rational Clear Quest, WinCvs 1.3, Control-M.

Merrill Lynch, NY Jun ’04 – Nov ‘04

Informatica Consultant

Environment: ETL -PowerCenter 6.2, Sun Solaris Version – 5.8, Windows 2000 Professional, Oracle9i, PeopleSoft, DB2, PL/SQL, Cognos, TOAD 7.6, ERWIN 4.x, Unix Shell Scripting, Test Director 7.x.

Contact this candidate