PROFESSIONAL SUMMARY:

• Over all around 10 years of experience in IT industry. Hands on experience in software design, analysis, coding, development, support, testing and software development life cycle (SDLC).
• Design and Implementation of jobs by extensively using DataStage/ Talend/ Teradata/ Netezza / Greenplum/ Informix/ SQL Server/DB2.
• Strong experience in using IBM information analyzer/IBM Web Sphere/ Ascential DataStage Server edition.
• Good experience in preparing Business Requirements specifications and translating them into technical requirements for development.
• Exceptional background in Analysis, Design, Development, Customization and Implementation & Testing of software applications and products.
• Adept at managing all facets of ETL and ELT processes, including capturing, reporting and managing data from diverse sources.
• Proven record of accomplishment in troubleshooting of DATASTAGE jobs and addressing production issues like performance tuning and enhancement.
• Experience in Parallel Extender (DS - PX) developing parallel jobs using various stages including Aggregator, Join, Transformer, Sort, and Remove duplicates, Merge, Filter and Lookup.
• Developed mappings /Transformation/Joblets and designed ETL Jobs/Packages using Talend Integration Suite (TIS) in Talend 6.1.
• Demonstrated ability in dealing with different stages (Hash, Shared, Containers and Merge).
• Excellent experience in most of the RDBMS including Oracle 11g,10g/9i/8x, DB2 & Teradata
• Experience on DW/Business intelligence tools.
• Extensive experience in using Oracle development tool set (SQL * PLUS, SQL DEVELOPER, TOAD)
• Demonstrated expertise utilizing ETL tools including DataStage and RDBMS like Oracle and DB2.
• Extensive knowledge of UNIX.
• Experience in MS- SQL 2005, SQL, Procedures and Oracle 11g/10g/9i.
• Strong understanding of the principles of DW using Fact tables, Dimension Tables, Star and snowflake schema modeling.
• Production job scheduling on UNIX through Control-M scheduling tool and CA7.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling.
• Strong experience in Financial and Retail domains.
• Knowledge of Reporting tools and Quality Assurance.
• Experience with the Build, Migrate and Shakeout process of the development code to higher environments (SYST, UAT, and PROD).
• Effective in cross-functional and global environments to manage multiple tasks & assignments concurrently.
• Team player with excellent Communication and Problem solving skills.

TECHNICAL SKILLS:

ETL Tools: IBM Information Analyzer/IBM WebSphere /DataStage 11.5/9.1/8.5/8.1/8.0/7.5 x2, Talend 6.1, Informatica Power Center, Alteryx

Bug Reporting Tools: JIRA,Clear Quest, Rational Team Concert

Operating Systems: Windows 2000, NT, XP, DOS, UNIX, AS400

Programming Languages: Business Objects 6.X, OBIEE 11.1.1.7, OBIEE 10.1.3.4.2

Databases: Netezza, MS SQL Server, MS Access, Teradata, ORACLE 8, 9i, 10g, 11g, 12c, DB2, Informix, MS-Access

Business Applications: Word, Excel, Access, Project, PowerPoint

Tools: Teradata Sql Assistant, Aginity, Squirrel, Sql developer, Erwin, PG Admin, Dbeaver, Reflection host

Domains Worked: Retail, Financial services, Bank

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Technical Lead

Responsibilities:

• Worked on all phases of Software Development Life Cycle from Planning to Deployment.
• Performed requirement gathering, analysis and designing decisions based on business analysis and technical design discussions with the stakeholders.
• Interact with Business Analyst, Product owners to understand requirements.
• Interact with various other teams that are involved to resolve the technical debt
• Providing technical solution to complex business problems.
• Preparing design documents for implementation i.e. functional design and technical design documents.
• Creating High level and low level ETL /ELT flow diagram in gliffy
• Understanding the needs of analysts and coming up with the logical data model for the data mart.
• Interact with Data modeler to design tables and constraints.
• Interact with DBA on improving the performance of SQL queries and procedures.
• Interact with data architect in database re-modelling to enhance performance of Datastage jobs
• Ensure compliance to Standards
• Design and developed Control - M cycles to trigger Datastage Jobs
• Setting up the datastage project as per the requirement which includes creation of environmental variables, directories, service accounts.
• Worked extensively on IDT and UDT. Built universes on top of Netezza and DB2 connection
• Worked collaboratively with business owners to assist in development of Business Objects reports.
• Responsible for fixing the issues raised by business users before or after rolling out to production

Environment: IBM Ascential DataStage 9.1 / 11.5, Business Objects IDT 4.2, Netezza, Control M, UNIX, IBM RTC, Confluence, Gliffy

Confidential, Bentonville, AR

Technical Lead/ ETL - BI Architect

Responsibilities:

• Involved in gathering user requirements and reporting requirements for a better understanding of the business process.
• Extensively worked with Team Leads to understand and modify the code as per business.
• Designed & developed Datastage Jobs in the project which involved complex transformations, performance enhancements, and validations
• Extensively Used DS ENVIRONMENT Variables, Parameters, DS Functions, Stage Variables.
• Developed parallel jobs using various stages like Sort, Transformer and Aggregator stage, Join, Lookup, Filter, Funnel, Remove duplicates and etc.
• Working in AGILE and SCRUM methodologies for development and performance tuning.
• Extensively used ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation and Loading using Datastage /Talend.
• Consolidated data from multiple sources into central data warehouse environment-using Datastage / Talend as an ETL and as database.
• Modeled the Star Schema Data Marts by identifying the Facts and Dimensions
• Created Talend jobs to load data into various MySQL and PostgreSQL tables.
• Scheduled Talend jobs using Talend Administration Center.
• Used UNIX Shell scripts to run Datastage jobs using CA7 Scheduler.
• Analyzed and performed data integration using Talend open integration suite.
• Worked on the design, development and testing of Talend mappings.
• Developed project specific 'Deployment' job responsible to deploy Talend jar files on to the windows environment as a zip file
• Extensively created mappings in TALEND using tMap, tJoin, tReplicate, tParallelize, tConvertType, tflowtoIterate, tAggregate, tSortRow, tFlowMeter, tLogCatcher, tRowGenerator.
• Worked Extensively on Talend Admin Console &Schedule Jobs in Job Conductor
• Mainly Involved in Performance Tuning of Datastage / Talend Jobs.
• Hands on Experience on many components, which are there in the palette to design Jobs & used Context Variables to Parameterize Talend Jobs.
• Hands on Experience in creating Generic schemas, Context Groups and Variables to run jobs against different environments like Dev, Test and Prod.
• Read the data from a variety of sources including DB2, Teradata, and Flat Files.
• Analyzing the source data to know the quality of data by using Talend Data Quality
• Involved in Testing for preparing Unit Test cases.
• Support warranty period after the production install.

Environment: IBM Ascential DataStage 9.1 / 11.5, Talend 6.1, alteryx, OBIEE 11g, Teradata 13, UNIX, Jira, Confluence, Gliffy

Confidential

Sr. Data Stage Developer

Responsibilities:

• Involved in understanding Business Process and coordinating with Business-users to get specific user requirements to build the Data Marts.
• Involved in Designing, Source to Target Mappings between sources to operational staging targets, using Star Schema.
• Modeled the Star Schema Data Marts by identifying the Facts and Dimensions
• Extensively used DataStage to develop various Parallel jobs to extract, cleanse, transform, integrate and load data into Enterprise Data Warehouse.
• Developed jobs using various stages like Lookup, Join, Merge, Sort, Transformer, Dataset, Row Generator, Column Generator, Datasets, Sequential File, Aggregator and Modify Stages.
• Worked with Newly introduced loop activity in transformer and other new functions.
• Hands on experience on configuration files for Parallel jobs.
• Worked with different sources such as flat files, sequential files, oracle and Teradata database.
• Used different partition methods in Parallel Extender job for bulk loading of data and to get better performance.
• Extensively worked on Teradata utility like Fast Load to load the data from file to a table while doing a history load and also used Multi Load utility to load the incremental data into the tables.
• Extensively used Teradata Connectors and Traditional Teradata stages for loading data using Teradata utilities.
• Have knowledge working on XML data.
• Involved in Performance Tuning of Parallel Jobs using Performance Statistics.
• Used Various Standard and Custom Routines in DataStage jobs.
• Responsible for adopting the Company Standards for Stage & Link Naming Conventions.
• Extensively worked with DataStage Shared Containers for Re-using the Business functionality.
• Extensively worked on user-defined SQL for overriding Auto generated SQL queries in DataStage.
• Involved in unit testing, system testing and integration testing.
• Created and edited the design specification documents for the jobs.
• Actively participated in the Team meetings to gather the business requirements and developing the Specifications.
• Prepared Unit test cases and UAT test cases to ensure the data quality.
• Participated in the review of Technical, Business Transformation Requirements Document.
• Participated in discussions with Team leader, Group Members and Technical Manager regarding any technical and Business Requirement issues.

Environment: IBM Information Infosphere 8.5 / IBM Information Server 8.1(DataStage EE), Teradata 13, Oracle 11g, IBM DB2, SQL, UNIX Shell Scripts, HP Quality Center.

Confidential

Sr. Data stage Developer/Production Support

Responsibilities:

• Design and Implementation of the DataStage jobs as per the Wal-Mart Transportation business requirement.
• Developed/Created source to target mapping documents and technical specification documents.
• Maintenance of the jobs (DataStage/Greenplum) based on change requests from the client according to changing business needs.
• Involved in the performance tuning of the existing parallel jobs.
• Testing the implemented components in different non-prod and prod environments.
• Resolving Defects and issues in production environment and bug fixing.
• Involved in the Analysis of issue related to code/data and provided timely resolutions and process improvements.
• Worked on standing up the Performance Environment by creating Value Files, Parameter Sets, running one time DataStage jobs for addressing data issues in various tables
• Implementing enhancements to the project modules and applications.
• Worked with team in proposing design improvements to the ETL process and implementations, which makes performance improvements. Successfully Integrated data across multiple and high volumes of data sources and target applications.
• Involved in production support and performed enhancement of existing projects.
• Automation of ETL processes using DataStage Job Sequencer and CA7 scheduler tool to schedule the jobs.
• Transition of projects, validation of job execution in production environment and providing sign-off between Development and Support team
• Monitoring and Tracking the incident trend for reporting purpose as well as problem management.
• Design and deploy the data stage Code from one environment to other environment and give support to QA, UAT and SIT during code release.
• Debugged bi issues with the help of customer provided obiee xml and added filters.
• Modified obiee repository according to business requirements to create joins between tables and performed load testing on repository.
• Necessary and timely action for job aborts and failures in batch run.
• Mentoring new team members, provided technical assistance and in understanding the functionality when needed.

Environment: IBM Ascential DataStage 8.5/9.1, Teradata, Oracle 10g, Informix, SQL Server, Green Plum, HANA, Mainframe files, AnthillPro (Team Forge), CA7 Job Scheduler, UNIX, MS Access 2007, MS Outlook 2010

Confidential

DataStage Developer

Responsibilities:

• Involved in requirements gathering, Analysis, Design and Develop and maintenance Phases.
• Worked closely with Business Analysts and Architects to gather the requirements and business rules.
• Developed/Created source to target mapping documents and technical specification documents.
• Creating Technical Design documents (TDD).
• Involved in the performance tuning of the existing parallel jobs without affecting the current functionality
• Review the code and suggest the modifications/changes.
• Obtained detailed understanding of data sources, Flat files and Complex Data Schema.
• Resolving Defects and issues in production environment and bug fixing.
• Developed jobs in DEV environment and moved them across SIT/UAT and PROD environments through Power and AnthillPro (Team Forge)and performed version controlling using SVN
• Provided SIT/UAT/Production support for jobs running on daily and weekly schedule
• Worked on standing up the Performance Environment by creating Value Files, Parameter Sets, running one time DataStage jobs for inserting/updating values in the various tables
• Project maintenance and support for the end users and business analysts to ensure the application is working as expected.
• Implementing enhancements to the project modules and applications.
• Designed parallel jobs using various stages like Join, Transformer, Sort, Merge, Filter and Lookup, Sequence, Modify, Peek etc. stages.
• Broadly involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using DataStage PX.
• Extensively used DataStage Manager, Designer, Administrator, and Director for creating and implementing jobs.
• Developed UNIX shell scripts to manipulate the data.
• Successfully Integrated data across multiple and high volumes of data sources and target applications.
• Automation of ETL processes using DataStage Job Sequencer and CA7 scheduler tool to schedule the jobs.

Environment: IBM Ascential DataStage 8.1, Teradata, Oracle 10g, DB2, Mainframe files, AnthillPro (Team Forge), CA7 Job Scheduler, UNIX, MS Access 2007, MS Outlook 2003/2007

Confidential

ETL Consultant

Responsibilities:

• Understand the Technical Specifications and develop the DataStage jobs for Extraction Transformation, Cleansing and Loading process of EDW.
• Read the data from a variety of sources including Oracle, Flat Files.
• Designed & developed numerous Jobs in the project which involved complex transformations, performance enhancements, and validations.
• Extensively Used DS ENVIRONMENT Variables, Parameters, DS Functions, Stage Variables.
• Involved in preparing test cases and SDD document.
• Deploy the data stage Code from one environment to other environment and give support to SIT testing team, UAT testing team during code release
• Designed jobs using different parallel job stages such as Join, Merge, Lookup, Remove Duplicates, Copy, Filter, Funnel, Dataset, Lookup File Set, Change Data Capture, Modify, and Aggregator.
• Used the Quality Stage to standardize and cleansing the source data which comes from GIF.
• Extensively used INFORMATION SERVER (8.1) to develop the parallel jobs.
• Exporting of DataStage Components & Packaging of Projects using DataStage Designer and to create backups.
• Worked on Teradata enterprise stage, Multi load stage, Teradata connector to load data in data warehouse and data marts.
• Involved in the design and documentation of High Level design document and detailed design document.
• Involved in development of UNIX shell scripts for Batch jobs etc. /State file creations etc.
• Involved in mapping team discussions to solve the issues in mapping document/Design.
• Extensively worked on Integrity’s processes such as Investigation, Standardization, Matching and Survive and pre-defined rule sets for data cleansing.
• For Effective Standardization manually defined rule sets.
• Implemented the slowly change dimensions (Type 2) using CDC (change data capture) Process.
• Done the Performance tuning on long run ETL jobs.

Environment: IBM Information Analyzer 8.1(DataStage EE), Teradata, Oracle 10g, SQL, Shell Scripts

Confidential

DataStage Developer

Responsibilities:

• Involved in full development cycle based on IBM data model on health care data
• Worked on updating Source/Target SQL as necessary Participate in all stages of the development life cycle including requirement analysis, design, development and implementation of the system creating jobs from EDW layer till data mart.
• Monitoring Informatica Production jobs and fixing workflow failures.
• Changes to existing mappings and reports.
• Responsible for developing a data-mart for the early collection system of the bank.
• Developing various excel reports and maintaining the web based reports.
• Development of new mappings and reports.
• Implementing Change Requests as requested by the customer.
• Resolving the Service Requests and Priority Requests as raised by the businessWorking on data related issues different modules.
• Maintaining the issue tracker.
• Involve in design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
• Document process descriptions, which define and encapsulate the component interfaces.
• Design Technical documents on delivered functionality / code as required.
• Created and edited the design specification documents for the jobs
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using IBM Information Server.
• Develop SQL queries to perform DDL, DML, and DCL against the databases.
• Performed Unit and System Testing.
• Developed test data and conducted performance testing on the developed modules and unit test plans and documents.
• Identified issues, tracked, reported and resolved in a timely manner.
• Fine Tune Jobs/Process to higher performances & debug complex jobs.
• Research new features and provide analysis and recommendations for implementation

Environment: IBM Information Server 9.1, oracle, SQL Server, Shell Scripts, UNIX, Windows NT, Queues, clear case, Control-M

Confidential

Data warehouse Consultant

Responsibilities:

• Understood the Data Model for these two Projects.
• Involved in creating Conceptual design which gives the Source to target mappings with the business transformation rules.
• Read the data from a variety of sources including Oracle, Flat files, and Excel files.
• Extract the data from different Source systems and keep in to staging area.
• Developing Jobs using DataStage PX to cleansing the data from staging area to pre-loaded area and data marts.
• Developed parallel jobs using various stages like Sort, Transformer and Aggregator stage, Join, Lookup, Filter, Funnel, Remove duplicates and etc..
• Used Job Parameters and Stage Variables in developing jobs.
• To follow some techniques to improve performance tuning.
• Involved in Testing for preparing Unit Test cases.
• Worked with DS Director to monitor job log & handle errors which occurred in designing jobs.
• Designed DataStage ETL jobs for extracting data from heterogeneous source system called NEO, transform and finally load into the EDWNI Data Ware house.
• Identify other source systems like Oracle, Siebel, Db2, SQL Server their connectivity, related tables and fields, to ensure data suitably for mapping from Truedat system.
• Developed the Source to Stage/Stage to work/work to EDW jobs to pull the data from Production Servers using the Oracle Stage and ODBC stage etc.
• Extensively handled slowly changing dimension (SCD) and created the parameter sets in the IBM Websphere DataStage Designer and made use of these in the DataStage jobs.
• Developed Parallel jobs for cleaning using the stages ODBC Enterprise, Oracle, join, modify, Aggregator, Transformer and lookup, copy etc.
• Defined the data definitions and created the target tables in the database.
• Involved in development of UNIX shell scripts for executing Batch jobs etc.
• Created the Sequencers to these two projects.
• Prepared test docs which involved preparation of test data, test case and unit testing of the jobs.
• Extensively used lookup, history processing and transformations.
• Experience on Performance Tuning.
• Prepared the Status of the Development work Document for the two tracks(OEM Sales Out/Booking and Commissions)
• Having Excellent analytical skills and process-oriented.
• Done the data validation once the data was loaded in EDWNI. Written the control queries for the BIA are based on the requirements.
• Helped to the BIA’s when they are creating the reports using BO tool.
• Having experience on HP Quality Center, and written the test cases in the Quality Center for Unit testing of the DataStage jobs etc.
• Helped the QA team while preparing the Test plan, participated in the meetings with QA team to clarify the doubts on the Performance Testing.
• Demonstrated the design and document conversion and system interface specifications.

Environment: IBM Web Sphere/Ascential DataStage (V 8.1/7.5), UNIX, SQL, Oracle 11g, Oracle 10g, Business Objects 6.1, IBM AIX 5.2, Windows XP/Windows 2000 Operating system, Web OLAP, HP Quality Center.