ETL Lead

Sirisha Nandipati

***** ******* **, ****** **- **035 Cell 989-***-****

E-mail ***.*******@*****.*** Office 214-***-****

Work ***********@*****.***

Results-oriented, achievement-driven, highly accomplished software professional with excelllent management capabilities and decision-making responsibilities. Experiecence in leading and guiding the team through service delivery to ensure maximum customer satisfaction. Expertise in coordinating diverse teams and resources to complete project objectives. A self-motivated problem solver with over 8+ years of IT industry experience. Seeking new professional challenges and enhancement of Management skills.

HIGHLIGHTS OF QUALIFICATIONS

Key Skills & Expertise

Project Management Requirements Gathering & analysis Team Leadership

Buisness Intelligence Project Life Cycle/Agile scrum ETL Design and Developmet

Informatica suite of Products Dimensional Data Modeling Database- SQL/PLSQL

Netezza/Greenplum/Oracle/ SQl Server Quality Assurance

UNIX shell scripting Java/ Big data / Hadoop concepts

PROFESSIONAL EXPERIENCE

3i Infotech Inc, Edison, NJ Sep 2015 –Present 2017

Client: Army and Air force Exchange Service (AAFES), Dallas, TX

ETL Lead

Project Lead: resource estimation/planning, schedules, risks & mitigation, status reporting, code development.

Oversee multiple projects across all phases of devlopment.

Responsible for interacting with customers to communicate and resolve project issues and handling escalations and assisting team members with questions or issues.

Lead status meetings with cross-functional teams, manage, and maintain project plans.

Monitor workflow and make time adjustments as needed.

Able to almost single-handedly repair and redesign the past mistakes (made by others), quickly transforming the project into a viable product for the company- 100% bug free code.

Lead and guide Informatica based ETL architecture.

Review scope and solution documents with the business team on immediate basis.

Coordination with Architects, business SME's.

Participate in project Go-No Go decision making process.

Experienced in data analysis and in creating logical and physical models for the ETL Architecture.

Assessed the requirements for completeness and accuracy.

Developed solutions and provided hands on guidance to team members.

Designed and set standards for preparing mapping documents, test case documents, migration documents.

Recommend and implemented the ETL process and architecture improvements.

Provide gudelines to team to load the data from mainframe COBOL files using power exchange connection in Informatica power center.

Extensive use of postgres SQL and PL/SQL in developing complex Stored Procedures and Functions in Greenplum.

Coordination with Admin team for deploying code in all production environment.

Worked extensively with reporting teams and loaded the data into the Greenplum reporting tables as per the business need.

Environment: Informatica 9.5.1, Greenplum, pgAdmin III 1.16.1, SQL Server 2014, ERWIN 9.5.02, Teradata, flat files, XML files, mainframe COBOL files.

3i Infotech Inc, Edison, NJ Aug’14- Aug'15

Client: Magellan Health, Glen Allen, VA

Sr. Informatica/ Netezza Consultant

Responsible to provide technical guidance in ETL and Netezza on multiple projects.

Work with Business Analyst to understand the business requirements.

Effectively communicate project expectations to team members in a timely and clear fashion

Provided technical guidance for re-engineering of Oracle warehouse operations into Netezza

Created Erwin models, doing reverse engineering the models.

Collaborated with architects to align the ETL design.

Developing the UNIX shell scripts for master workflows.

Created the ETL source to target mapping documents.

Created design standards of the ETL code by applying SCD logics.

Created Parameter files, mapplets, and worklets for reusability in the code.

Reviewed and maintained the ETL coding standards.

Performance tuning of ETL using Persistent cache and adjusting session properties.

Performance tuning of Netezza tables by selecting right distribution keys, ‘Organize On’ for better SPU performance and avoid data skews in Netezza objects.

Created Oracle stored procedures for capturing the ETL run statistics for the daily delta loads.

Performance tuning of Netezza SQL scripts.

Created NZLoad Scripts to load the Flat Files into Netezza Staging tables.

Execute unit test plans based on system and validation requirements.

Migration of the code from DEV, QA, UAT, PROD using XML migrations.

Environment: Informatica 9.1/9.6.1 Netezza 6.0.8, Oracle 11g, Cognos, ERWIN 9.5.02, Toad 12.1.0, Aginity Workbench 4.3, flat files, XML files.

3i Infotech Inc, Edison, NJ Oct’ 10– Apr’14

Client: University of Wisconsin Health, Madison, WI

Informatica Lead Developer

Technical lead involved in all phases of software development and delivered the projects within the timelines.

Analyze the requirements and prepared ETL specifications from business requirement.

Present impact analysis for any change management.

Assisted ETL developers on the ETL errors and resolve problems.

Experience in Agile working model.

Developed and maintained the ETL standards document for use in the Organization.

Trained QA teams on data validation (DVO) tool for testing the data end to end.

Experience on the Metadata Manager (MDM) tool to identify the dependencies of the objects in the Informatica repository.

Developed different ETL methods for Change Data Capture (CDC) using incremental loads and MD5 checksum methodology.

Extensively used Aginity to create CTAS scripts for retaining data in the tables, use Netezza built in functions, change distributing keys, creating external tables in Netezza 6.0.8

Developed views/materialized views, stored procedures, grooming the tables, generating statistics for better performance on a scheduled basis in Netezza database.

Developed stored procedures in Netezza to maintain log details and batch processing for the ETL code.

Created batch files to do the FTP and SFTP and get the XML source files from the vendor websites and integrated the process in the Informatica workflows.

Provided on call production support on rotation basis within the team.

Created re- usable Mapplets, worklets and used them in different mappings to streamline the process.

Implemented Slowly Changing Dimensions - Type I & II in different mappings, transactional facts and aggregated facts as per the requirements.

Performed tuning of Informatica sessions by implementing database partitioning, increasing block size,data cache size and target based commit interval in sessions, tuned SQL overrides in the Sources, Targets, Transformations and Mapping to remove bottlenecks for better performance.

Developed unit test plan templates and Performed code reviews.

Managed the post production issues and delivered all assignments / projects within specified time lines.

Created weekly project status report for senior management.

Help reporting team whenever they had any ETL questions.

Environment: Informatica 8.6.1/9.1,Netezza 6.0.8, Oracle 10g,SQL Server 2008, SAS, Business objects, Qlikview, ERWIN, Aginity Workbench, Informatica Data Validation Option(DVO), flat files, XML files, IDE,SQL plus, SQL/PLSQL,Control-M.

Verinon Technology Solutions, Arlington Heights, IL Jun ’10 – Sep’10

Client: Russell Investments, Tacoma, WA

On site Technical Lead

On-site Technical Lead responsible to manage off shore development and testing team in India.

Analyzed business documents and created HLD and LLD documents for ETL.

Assured that all enterprise procedures are followed such as system testing, change management, project prioritization, and code promotion to production.

Responsible to co-ordinate user acceptance and sign-off process. Worked effectively with onsite Business users.

Participated in the review and maintenance of data security standards to protect information assets.

Used Erwin for logical and database modeling and helped DBA generate DDL.

Extensively used the transformations Sequence Generator, Expression, Filter, Router, Sorter, rank, aggregator, lookup (Static and Dynamic), update strategy, source qualifier, joiner, and normalizer to load data from different sources such as databases, flat files.

Developed Informatica mappings, re-usable transformations, mapping parameters and variables,

Mapplets for data load to data warehouse.

Loading data from various data sources and legacy systems into Teradata production warehouse using the utilities BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.

Developed Microsoft SSIS packages to load the historic data from CSV files to a SQL server tables.

Created UNIX shell scripts for scheduling the workflows in Informatica

Environment: Informatica Power Center 8.5, SQLServer 2005,Teradata, Teradata Fast load, BTEQ, Microsoft Visio, Erwin 7.0, TOAD 8.6.1, Windows XP.

McNeese State University June ’09 – Dec’09 SQL Developer/Web Developer

Developed a small project of a team of four .The project is mainly used for assigning User Id and Password to students. To view or Update their Personnel information. To register for the classes. View their academic grades and Transcripts. Assigning read / writes permissions to students, advisor, professor and administrator.

Created and maintained SQL Server databases.

Create table’s indexes, sequences, constraints, triggers and procedures to implement business rules.

Create triggers, stored procedures to update the data using DDL and DML functions.

Responsible for integration of the front end with the SQL Server backend.

Migrated the data (Import & Export of data) from one server to other servers using tools like Data Transformation Services (DTS)

Written complex T-SQL statements (Queries) for retrieval of data and involved in performance tuning of TSQL queries

Created documentation of the performed tasks.

Extensively Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.

Scheduled Backing up, restoring for databases.

Managing the security of the servers, creating the new logins and users, changing the roles of the users.

ACHIEVEMENTS AND AWARDS

Best performer of the project winner 2016 – AAFES

Appreciation award for the project 2017 - AAFES

Best developer of the Quarter winner – 2013 – UW Health

EDUCATION

McNeese State University– Lake Charles, LA – Master’s of Science in Computer Science. Jan 2008 – Dec 2009

Jawaharlal Nehru Technological University, AP, India - Bachelor of Technology in computer Science Engineering. Jun 2002 – Jun 2006

Microsoft SQL Server 2005 Technology Specialist – Certified in 2009

Contact this candidate