SUMMARY

• Around 10 years of extensive experience in technology industry and executing data warehouse solutions to provide valuable insights on problem solving and decision making to enhance business.
• Specializes in Data Analysis, Data Mapping, Data Conversion, Data Masking, Data integration, Data Modeling, Business analysis, Functional design, Technical design and different aspects of data/information management.
• Extensive experience in Data warehousing, Data Integration, Business Intelligence and ETL projects
• Extensive ETL experience in building ETL progression using Informatica PowerCenter 8x/9x and Datastage 8x/9x/11.5
• Experience in all phases of SDLC using both Waterfall and Agile methods
• Expertise in OLTP/OLAP database design and database schemas like star and snowflake
• Expertise in writing UNIX shell scripts and SQL queries over the ETL platforms
• Experience in resolving production issues and as well as performance tuning
• Experience in ERwin tool in Data Modeling (both Physical and Logical Design).
• Strong knowledge in relational DBMS like DB2, Netezza, Oracle, MSQL and Microsoft SQL Server
• Good knowledge in job scheduling and monitoring using Control - M Workload Automation tool
• Good Experience in handling the Enterprise data warehouse, Analytical and Reporting Databases
• Experience in ETL Administration activities like handling access request, migrating ETL between environments, Creating Repository Services, Setting up firewall etc.,
• Experience in handling SCDs (Slowly Changing Dimensions)
• Good Insights into Big Data and Knowledge on Hadoop HDFS environment
• Good knowledge in developing reports using IBM Cognos Report Studio and Business Objects
• Experience in preparation of S2T documents, Technical Design documents and test cases
• Research-oriented, motivated, proactive, self-starter with strong technical and analytical skills.
• Ability to grasp new concepts and handle multiple projects with minimal supervision

TECHNICAL SKILLS

Data Integration Tools: Informatica PowerCenter 8x/9x, IBM Datastage 8x/9x

Business Intelligence: SAP Business Objects 4.0, IBM Cognos 8

Relational DBMS: IBM Netezza, DB2, Oracle, Microsoft SQL Server, MySQL, IBM dashDB

Query Languages: SQL, PL/SQL

Programming Languages: C, C++, Shell Scripts, Java, Python

Markup Languages: HTML, XML workload automation BMC Control-M

Applications: Eclipse, Edit plus, WinSCP, Putty, Squirrel, Aginity, Oracle SQL Developer, RTC, HP Service Manager, VMware Service Manager ServiceNow, BMC Remedy

Operating Systems: Windows OS, Red hat Linux, AIX Unix, Ubuntu

PROFESSIONAL EXPERIENCE

Datastage Lead Developer

Confidential - San Antonio, TX

Responsibilities:

• Develop measurements for SOR quality metrics at MSR level
• Responsible to integrate sales and member experience data to enable holistic view of MSR efficiency
• Understand business/reporting requirements and implement ETL process
• Responsible for complete analysis, design, development and implementation of ETL through agile methodologies
• Coordinate with clients and offshore/onshore developers to deliver the ETL code
• Develop SQL queries to source data and load mart tables
• Designed and developed Datastage parallel jobs and performed data loads
• Design and customize data models for EDW and mart database
• Proficiently handled Parallel Extender for creating jobs for the stages like Aggregator, Transformer, sort, merge, join, lookup, remove duplicate, filter and Change Capture
• Implement best practices, standards and procedures to encourage team uniformity, efficiency, and maintainability
• Design ETL flow and schedule using Control M Automation scheduling tool
• Created Unix scripts to extract zip files, to ftp files from different server.
• Written Unix scripts to for QC check and Empty file check
• Created SQL Queries to extract data from SQL server and Netezza,
• Accommodated Datastage jobs for Version upgrade
• Perform unit and system testing
• Leading the ETL development by providing them job level requirements, reviewing the code, scheduling and implementation.

Environment: Datastage 9.1/11.5, Shell Scripts, Netezza, Oracle, SQ Server 2014, RTC, Squirrel, Aginity, Putty, Windows 7 and Red hat Linux 5.11

Informatica Lead Developer

Confidential - San Antonio, Texas

Responsibilities:

• Understood the requirement and developed the ETL process
• Coordinated with onsite team and delivered the task as per business needs
• Developed reusable components to reduce 20% of ETL work
• Improved the data availability to end users through parallel processing from 2 day to 1 day lag
• Created ETL using Informatica PowerCenter by applying best practices and error handling process
• Developed Unix script to pull the Informatica PowerCenter session logs errors and extract/load counts to populate into control m scheduling tool log
• Created validation and data refresh scripts on the table.
• Written scripts to ftp the files and to remove the invalid characters in the flat file
• Developed Extract queries on Netezza, SQL Server, Oracle and DB2
• Tuned ETL by enabling partition, increasing query performance and various techniques

Environment: Informatica PowerCenter 9.6, Control M, Shell Scripts, Netezza, SQL Server, DB2, Oracle and My SQL, Squirrel, Aginity, VMware Service Manager, ServiceNow, Windows 7 and Red hat Linux 5.11

ETL Support Lead (Informatica and Datastage)

Confidential

Responsibilities:

• Maintenance of Data Warehouse, User Rights, Data Mining, Reporting, QC of Data
• Experience in using various tuning techniques to improve performance in Mappings, Sessions, Workflows, Datastage parallel jobs and sequences.
• Debugged, maintained existing codes by SQL Query Tuning.
• Analyzed and designed source code ETL overview documentation for Enterprise Data Warehouse
• Collaborated with database administrators, application developers, and business users to ensure business requirements meet expected results.
• Provided permanent fix for repeated failures and created automated scripts to validate the data
• Regular monitoring of Control M jobs to resolve jobs failures and keep Return to Service (RTS) times low
• Managed a team of 8 people by providing them initial training in ETL and monitoring the RTS activities.

Environment: Datastage 8.1/8.5, Informatica PowerCenter 9.6, Shell Scripts, Control M, Netezza, SQL Server, DB2, Oracle, Squirrel, VM Service Manager, Windows 7 and Red hat Linux

Informatica Developer

Confidential

Responsibilities:

• Loaded enterprise customer data from legacy systems to Siebel interface tables
• Cleanse data through ETL by applying business transform logics
• Developed ETL jobs using Informatica PowerCenter application
• Created mappings by efficiently using the required transformations such as Source Qualifier, Expression, Sorter, Lookup, Aggregator, Filter, Router, Update Strategy, Joiner, etc.,
• Scheduled Workflow using Informatica PowerCenter Scheduler.
• Performed validation on target tables to ensure the data quality
• Performed unit test on ETL code and written test cases

Environment: Informatica PowerCenter 8.1, Oracle, HP Service Manager 7.1, Putty, WinSCP Windows, Unix

Informatica Administrator

Confidential

Responsibilities:

• Performed administration activities like user creation, folder creation, assigning access, configuring DB connections and monitoring Informatica PowerCenter services
• Migrated ETL objects from lower environment to higher environment
• Created Unix script to move data and to clean up data from staging area using shell scripts
• Performed Informatica Health checkup, monitored the disk utilization and clean up the old components.
• Managed backup and security of the ETL Infrastructure and performed maintenance activities
• Monitoring the Server Utilization constantly to ensure availability
• Created Unix scripts to automate the mount space check and alert the team when the 90% mount space is used

Environment: Informatica PowerCenter 8.1, Shell Scripts, Unix

Process Expert

Confidential

Responsibilities:

• Coordinated with onsite team to understand new requirements and ensured content quality for kindle users
• Worked closely with development team to apply permanent fix, automating blogs content and new QA tools
• Validated the XML content and generated HTML based file to for easy navigation
• Written shell scripts to automate the fix for repeated issues
• Ensure 24/7 operational support for delivering the content to kindle store
• Inserted missing content, removed old and duplicate content to match actual source
• Managed a team of 28 members by mentoring them in internal tools

Environment: Shell Scripts, HTML, HML, Putty, WinSCP, BMC Remedy, Windows, Unix