SUMMARY:

• 15+ years of working experience in various complex and high volume datawarehouse projects that involved with various tools and technologies such as, Informatica, Teradata, Oracle, Netezza, Sybase IQ, DB2, PL/SQL, Erwin, Power Designer, UNIX shell scripting and Microsoft Visio etc along with having experience in complete development life (SDLC) cycle from gathering requirements, technical design, development, unit testing, system testing, integration testing, user acceptance testing, implementation, post implementation support, agile methodologies and working with on - site and offshore teams.
• 15+ years of ETL design, development and testing experience using Informatica product versions from 5.1 to 10.1.1along with performance tuning of queries and Informatica code.
• Expertise in extracting and loading data from various sources / targets such as Teradata,Oracle, SQL Server, MySQL, DB2 Sybase IQ, Flat files databases using various PowerCenter Designer transformations including but not limited to Source Qualifier, Expression, Joiner, Aggregator, Router, Filter, Union, Update Strategy, Connected and Unconnected Look-ups, Sequence, Rank, Sorter, SQL, Stored procedure, reusable transformations, Mapplets, Sessions, Workflows etc.
• Also, executing and monitoring jobs using Workflow Manager / Monitor, pmcmd commands, schedule jobs using Informatica scheduler, Crontab, Maestro, Control-M, UNIX shell scripting etc.
• Expertise indesigning ETL jobs based on data models, preparing high level and low level designs, source to target mappings along with business transformation rules, ETL process flow diagrams depicting data flows with dependencies, slowly changing dimensions, Performance consideration such as generating Explain Plans, evaluating and optimizing joins based on keys / indexes, creating table partitions, using loader utilities, adjusting PI on tables to reduce skew factor,PDO, delta processing, parameterization, MD5, restart-abilityand provideother alternate approach to avoid performance bottlenecks etc.
• 4+ years of working experience as an Informatica administrator (Version 6.x, 7.x) and managed 14 Informatica repositories using Repository admin console, Repository Manager tools such as, upgrading repositories, create and maintain users, folders, privileges, code migration, perform repository backups, automate admin related jobs using shell scripts, installation of client software at developers desktop / laptops, establishing ETL standards and best practices, participate in disaster recovery of Informatica environments and Sarbanes-Oxley audits, planned outages, create metadata reports, work with DBAs, developers and other application architects etc.
• 5+ years of data modeling experience working with Erwin 4.1&9.7 and Power Designer 13.1 for Teradata and Netezza databases and created logical and physical data models, DDLs containing tables, views, preparing volumetric estimates, perform model reviews, implementation etc.
• 10+ years working experience in data analysis and profiling of database objects like querying database metadata, obtaining columns, identifying keys, indexes, data-types, null-ability, constraints, relationships, data volume, and data exceptions based on business scenarios and test data preparation.
• 6 years in Application Support and Maintenance activities of Informatica projects and followed ITIL processes for Incident, Problem and Change Management processes, providing on-call support, resolving batch issues, performing root cause analysis, impact analysis, meeting SLAs for response and resolutions, metrics consolidation about batch job performances, incidents / problems, SLAs and publishing dashboards etc.
• 1 year working experience with Hadoop / HiveBig Data environment.
• Certified Informatica Developer and Certified Trifacta Wrangler.
• 2 years of project management experience using waterfall methodology by managing project plans, scope, cost, quality and deliver on time. Manage end client expectations and communicate project stakeholders on the scope changes, impacts to schedules, cost etc. Mentor the team by way of conducting training; suggest using best practices, coding standards, quality requirements, providing technical guidance. Also conduct semiannual appraisals, evaluate candidates for various positions required for the project.
• Experience working with various business domains such as Retail, Telecom, Banking and Life Insurance.

TECHNICAL SKILLS:

Languages: UNIX Shell Programming, AWK programming, SQL, PL/SQL.

Tools: Informatica 5.1, 6.2.1, 7.1.3, 8.6.1, 9.1.0, 9.6.1&10.1.1,Teradata SQL Assistant 15.10, Teradata Studio, Netezza Workbench, Rapid SQL 8.7.2 & 17, Erwin 4.1, 9.5& 9.7, Power Designer 13.1, Bitbucket, Putty, Microsoft Visio,Maestro Tivoli Scheduler, Control-M Scheduler, Crontab, TOAD, SQL Developer, UltraEdit 23, Alation, Attunity, Trifacta, Bugzilla 4.0, Visual Source Safe(VSS), Concurrent Version System (CVS), Polytron Version Control System (PVCS), WinCVS, Exceed, Microsoft Project

Databases: Teradata 13& 15.10, Hive, Oracle 6.x, 7.x, 8i, 9i, 10g, 11i & 12, Netezza, DB2/UDB, MySQL, SQL Server 2008, SybaseIQ 15.3

Systems: HP-UX, DG-Aviion, Sun Solaris, NEC, DRS-3000, DRS-9000, SCO, SCO-UnixWare, Windows 7, NT, 2000,XP,10 and Linux

Concepts: Datawarehousing, SDLC, Sarbanes-Oxley audit, ITIL.

PROFESSIONAL EXPERIENCE:

Confidential, Omaha, NE

ETL Designer, Developer and Architect

Responsibilities:

• Contributed to key projects from their requirements phase to implementation and supportare, PLV (Premium, Lives and Volume) datamart, BDP (Bill, Due and Paid Basis) datamart, DTC-NIGO (Direct to Customer - Not in Good Order) data integration and IVOC (Interconnected View of Customer) using both waterfall and agile project methodologies.
• Designed, Developed and Implemented PLV& BDP data marts in which data sourced from Oracle andDB2andintegrated into Teradata.
• Performed various ETL activities inIVOC, such as validating the data ingestion of Big Data residing inHadoop data lake environment using HQL (Hive Query Language) and data cleansing and integration across various zones to support analytic team needs and business users.
• Performed real time data replication and monitored using Attunity toolto replicate data from Oracle, DB2 to Teradata.
• Participated Proof of Concepttesting of various tools evaluations such as Alation, Attunity, Trifacta,Talend Big Data and provided feedback to make the purchase decisions.
• As part of agile methodology, some of the projects were developed as a prototype initially and enhanced to reach a final delivery solution by continuous engagement with end users.
• Participated Informatica upgrade testing from 9.6 to 10.1.1 and identified potential issues in the product and suggested solutions.
• Gathered Business Requirements from business users / business analysts and executed multiple projects.
• Performed Data Analysis on various source system data and identified necessary source data elements and ETL rules needed to meet business requirements.
• CreatedLogical and Physical Designsusing Erwin data model tool and reviewed with stakeholders, architects to better suit project needs and standards. Also metadata is captured for each object, data element as part of the design and populated in metadata repository.
• Generated physical structures for database objects such as tables, views etc. and implemented them in various Teradata database environments.
• PreparedHigh Level, Low level designsand System and Data flow diagrams of ETL components using Visio.
• PerformedETL design reviews with projectteams, architects, business users, database administrators, developers to ensure design meets requirements and standards.
• Performed reconciliation between newly built and existing systems and explaineddata differences to business customers and stakeholders.
• Analyzedpreviously developed ETL components and implemented variousperformance tuningmethods to decrease the run timeof long running Informatica and Teradata batch jobs.
• Suggested and Implemented best practices of Informatica and Teradata for efficient processing like changing PI on tables for even distribution, PDO operations using SQLs, delta processing, restart during failures without intervention, parameterization, Teradata loader utilities, MD5, bulk load and partitioning etc.
• Proposed and Implemented ETL standards (methodologies, naming, coding, parameters, environment variablesetc.) and improved existing processes / standards.
• Scheduled batch jobs using Informatica and Control-M and resolved production issues with ETL jobs, dependencies and scheduling issues.
• Performed Code migration from development to, user acceptance testing and production environments.
• Conducted trainingon Informatica, Teradatabasics along with application knowledge about PLV and BDP data marts to project teams as and when needed.
• Completed 2 levels of Trifacta Certifications for Data Wrangler. Used Trifacta product to provide a proof of concept for pattern masking of sensitive data for privacy compliance.
• Environment: Informatica 9.1.0, 9.6.1& 10.1.1,Teradata 14.1& 15.10, Teradata Studio 15.10, DB2, Oracle 10g & 12.1.0.2,Hadoop/Hive, Alation, Attunity, Trifacta, Windows 7& 10,Putty, Linux, Control-M, Microsoft Visio 2007

Confidential, Omaha NE

ETL Designer/ Architect

Responsibilities:

• Worked on ETL interfaces integration for EKA, Thede, KCL, FI and IMOS source systems.
• Interacted with source system architects to understand source data architecture and provide EDW specific sourcing requirements.
• PerformedReverse Engineering of existing applications and identified required data elements needed.
• Prepared High Level and Low level designs of ETL components along with Visio diagrams.
• Designed and created database tables needed.
• Create extract files by creating SQLs and fine tune existing Informatica jobs to reduce run timings.
• Created batch scripts, Sybase loader control files to improve and integrate ETL jobs.
• Designed & Developed Source to Target mapping for all interfaces according to business requirements.
• Designed & Developed reusable objects such as lookups, mapplets, mappings, generic mapping templates etc.
• Design, Develop, Unit Test, System Test, Deploy and Support the interfaces.
• Implemented ETL standards (methodologies, naming, coding, parameters, environment variables etc) and ensuring compliance to processes.
• Prepared and Scheduled jobs using Control-M scheduler.
• Resolved production issues with ETL jobs and scheduling issues.

Environment: Informatica 9.1.0 with Hotfix1, Oracle 10g, Sybase IQ 15.3, SQL Developer, SQL Server, Windows XP, Control-M, Microsoft Visio

Confidential

ETL Designer/ Architect& Project Manager

Responsibilities:

• Interacted with source system architects to understand source data architecture and provide EDW specific sourcing requirements.
• Designed &DevelopedSource to Target mapping.
• Implemented ETL designs& Architecture for Staging and Foundation layers.
• Designed and ledDevelop & Unit Test Informatica ETL mappings.
• Involved inSystem Testingand Resolved critical data Architecture issues.
• Implemented ETL standards (methodologies, naming,coding,parameters,environment variables etc) and ensuring compliance to processes.
• Identify, Evaluate and mentor developmentresources to be productive in project.
• Status updates to clients, ensure on time delivery and On-site-Offshore co-ordination.
• Manage project plans, scope, cost, quality, estimates and deliverables using project management methodologies.
• Manage, mentor, conduct performance appraisals of project team members.

Environment: Informatica 8.6.1, Oracle 10g, DB2 Connect, Teradata SQL Assistant, SQL Developer, Putty, Windows XP

Confidential, Deerfield, IL

Business Analyst, Data Analyst, ETL Designer/Architect

Responsibilities:

• Interacted with Business users and prepare Business requirements, Business rules documents.
• Performeddata profiling of source tables such as keys, indexes, relationships, data anomalies etc.
• PreparedSource to Target mappings.
• Reviewed Data Models to ensure design met requirements and standards.
• Prepared and ReviewedETL designs for staging and EDW layers.
• Prepared System test scenarios as per business requirements and special business scenarios.
• Prepared test data for Unit and System testing purposes using excel and UNIX shell scripts.
• Participated in User acceptance testing phase and resolved open queries and issues.
• Identify, evaluate and fulfill resources needs in the project.
• Implementing ETL standards (methodologies, naming,coding,parameters,environment variables etc) and ensuring compliance to processes.

Environment: Oracle 9i, Teradata SQL Assistant, SQL Developer, Putty, Bugzilla,Windows XP

Confidential, Hoffman Estates, IL

Data Analyst, Data Modeler & ETL Designer

Responsibilities:

• Performeddata profiling of source tables such as data types, keys, relationships, data exceptions.
• Preparedlogical/physical data models for Staging and EDW environments using dimensional data modeling concepts.
• PreparedAggregation tables as per reporting requirements and performance considerations.
• PreparedSource to target mappings along with transformation rules &ETL designs.
• Preparedprocess flow diagrams depicting the current ETL process flow and proposed ETL process flow.
• Calculatedvolumetric estimates for new tables to provide estimates for database sizing.
• ImplementedETL design standards and ensuring compliance to processes.

Environment: Power Designer 13.1,Oracle 9i,SQL Developer,Teradata SQL Assistant, Netezza Workbench, Putty,Windows XP

Confidential, Lincolnshire, IL

Data Modeler& Project Manager

Responsibilities:

• Prepared logical/physical data models using dimensional modeling.
• Createddimension, hierarchical, fact and aggregate tables.
• Defineddata types, Primary keys, slowly changing dimensions, business views, unique indexes, data distribution using primary indexes based on ETL and Reporting requirements.
• Calculated volumetric metrics of new tables to estimate database sizing for staging, ODS & reporting layers.
• Implemented design standards and ensuring compliance to processes.
• Manage project plans, scope, cost, quality, estimates and deliverables using project management methodologies.
• Manage, mentor, conduct performance appraisals of project team members.

Environment: Erwin 4.1, SQL Developer, Teradata SQL assistant, MS Project, Putty,Windows XP, Sun OS, Oracle 9i

Confidential, IL

ETL Architect& Project Manager

Responsibilities:

• Interacted with source system architects to understand source data architecture and provide EDW specific sourcing requirements.
• PreparedSource to Target mapping.
• Prepared and ReviewedETL designs for Staging and EDW.
• Defined datatypes, Primary keys, slowly changing dimensions, business views, unique indexes, data distribution using primary indexes based on ETL and Reporting requirements.
• Developed data models and defined ETL approach.
• Performed, Developed& Unit Test Informatica ETL mappings.
• Performedperformance tuning of SQLs, reviewing explain plans, defining additional indexes, using partitioning in Informatica.
• ImplementedETL standards (methodologies, naming,coding,parameters,environment variables etc) and ensuring compliance to processes.
• Manage project plans, scope, cost, quality, estimates and deliverables using project management methodologies.
• Manage, mentor, conduct performance appraisals of project team members.

Environment: Informatica 8.1.x, TOAD, Putty, MS Project, Oracle 9i,Windows XP

Confidential, Horsham, PA

Informatica Administrator, ETL Architect, Support Analyst

Responsibilities:

• Performed Informatica Upgrades from 6.2.1 to 7.1.3.
• Developing and implementing business solutions for Confidential data warehouse.
• Administering Confidential Informatica & data warehouse systems.
• Carried out performance tuning ofInformatica components.
• Supporting Information Delivery applications and other In-house developed applications.
• Actively participated in various Confidential initiatives such as Equip-IT, TL-9000, Application Rationalization, OASES using ITIL Processes, Sarbanes-Oxley audits etc.

Environment: Informatica 6.2.2, 7.1.3, Shell and AWK programming, Crontab, TOAD, Putty, Oracle 9i, MySQL

Confidential

ETL Developer

Responsibilities:

• Establish the ETL development project team and lead at offshore.
• Create ETL standards and operating procedures for developers.
• Analyze business requirements, technical specification documents and guided the team to complete the development and testing.
• Develop mappings, workflows using Informatica and UNIX Shell scripts.
• Trained & Mentored teams for efficient and successful delivery.
• Review the development and test result documents and ship on-site for implementation.

Environment: Informatica 7.1, Shell & AWK programming, TOAD, Putty, HP-UX,Windows XP, Oracle 9i

Confidential, MN

Informatica Administrator, ETL Designer,Developer & Support Analyst

Responsibilities:

• Created standards and operating procedures for developers both at on-site and for offshore.
• Analyzed business Requirement and translated the logical model to technical specification document for development.
• Provided solutions for development, testing and ensured standard operating procedures compliance.
• Executed more than 20 ETL projects within Confidential .
• Provided support for developed applications and knowledge transition to Application support and Maintenance team at on-site.
• Created and maintained 14 Informatica repositories across Confidential enterprise and performed Informatica Administration at on-site.
• Trained & mentored multiple teams in ETL processes, Design & Modeling skills and acted as Version control administrator.
• Participated the user forums for Informatica and provided technology solutions to Confidential .

Environment: Informatica 5.1 &6.2.1, Shell & AWK programming, TOAD, Maestro, Exceed, HP-UX,Sun OS,Windows XP, Oracle 9i, Microsoft Visio, WinCVS.