SUMMARY:

• Over nine years of extensive experience in Information Technology with special emphasis on design, development and administration of Database/Data Warehousing/Client - Server applications.
• Experience in all the phases of the Data warehouse life cycle involving Data analysis, design, and development and testing using ETL, Data Modeling, Online Analytical Processing & reporting tools.
• Extracted data from various sources such as Relational Sources (Oracle, SQL Server, Teradata and DB2) and File formats.
• Strong hands-on in developing Scripts using UNIX Scripting.
• Designed and developed complex jobs, from varied transformation logic using different stages like Transformer, Lookup, Filter, Aggregator, Join, Merge, Funnel, Sort and many more.
• Worked on different partitioning methods (Round Robin, Entire, Hash by Field, Modulus and Range) and collection methods (Round Robin, Order and Sort Merge) in processing sequential data.
• Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, Query), Teradata parallel support and Unix Shell scripting.
• Proficient in coding of optimized Teradata batch processing scripts for data transformation, aggregation and load using BTEQ.
• Strong experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Teradata.
• Strong skills in coding and debugging Teradata utilities like Fast Load, Fast Export, MultiLoad and Tpump for Teradata ETL processing huge volumes of data throughput.
• Proficient in interaction with the business users, pioneered strategies of loading staging area and data marts.
• Hands on experience in analyzing and troubleshooting issues at functional and technical aspects of the business.
• Good knowledge of Data Warehouse concepts and principles (Kimball/ Inman) - Star Schema, Snowflake, SCD, Surrogate Keys, Normalization/ De-normalization.
• 24X7 production support for Data warehouse.
• Worked extensively in Development of large Projects with complete END to END participation in all areas of Software Development Life Cycle and maintain documentation.
• Quick adaptability to new technologies and zeal to improve technical skills.Good analytical, programming, problem solving and troubleshooting skills

TECHNICAL SKILLS: 

•  IBM InfoSphere DataStage 8.5, 9.1, Designer, Director, Flat File, Administrator, UNIX, Teradata, IBM Tivoli, Microsoft Visio
•  IBM Datastage 8.7, IBM Datastage 8.1, SQL Server 2008, Oracle 11g, PL/SQL, Red hat 4.2 Linux Shell Scripting, FileZilla, Winscp, Putty, SQL Developer, Jira, Marvel, Remedy.

WORK EXPERIENCE:

Sr. Datastage Developer

Responsibilities:

• Technical requirement gathering And technical analysis for each job data stream, including Identified source systems, their connectivity, the related tables and fields and ensured that data was appropriate for mapping.
• Designing and development application solution for the technical requirements.
• Extensive development of the UNIX and Perl scripts.
• Imported and exported repositories across different servers using Data Stage.
• Improved job performance by gathering the performance statistics of the jobs in the production server using DataStage Director.
• Extensively used the Sequential File stage, Modify, DataSet, Filter, Funnel, Join, Lookup, Merge, Sort, Copy, and Aggregator during ETL development.
• Simplified the existing transformer logic in the jobs to make them perform better.
• Worked on different partitioning methods (Round Robin, Entire, Hash by Field, Modulus and Range) and collection methods (Round Robin, Order and Sort Merge) in processing sequential data.
• Presented numerous technical reviews and participated in many technical, Business Transformation Requirements Documentation.

Sr. Datastage Developer

Confidential, Eden Prairie, MN

Responsibilities:

• Technical requirement gathering And technical analysis for each job data stream, including Identified source systems, their connectivity, the related tables and fields and ensured that data was appropriate for mapping.
• Designing and development application solution for the technical requirements.
• Extensive development of the UNIX and Perl scripts.
• Imported and exported repositories across different servers using Data Stage.
• Improved job performance by gathering the performance statistics of the jobs in the production server using DataStage Director.
• Extensively used the Sequential File stage, Modify, DataSet, Filter, Funnel, Join, Lookup, Merge, Sort, Copy, and Aggregator during ETL development.
• Simplified the existing transformer logic in the jobs to make them perform better.
• Worked on different partitioning methods (Round Robin, Entire, Hash by Field, Modulus and Range) and collection methods (Round Robin, Order and Sort Merge) in processing sequential data.
• Presented numerous technical reviews and participated in many technical, Business Transformation Requirements Documentation.
• Effective Troubleshooting while design the Data stage jobs, UNIX scripts.
• Writing Teradata sql queries to join or any modifications in the table
• Creation of customized Mload scripts on UNIX platform for Teradata loads
• Creation of BTEQ, Fast export, MultiLoad, TPump, Fast load scripts for extracting data from various production systems
• Created job sequences and job schedules to automate the ETL process using IBM Tivoli (TWS).
• Documented the changes made to the jobs, the comparative performances of the old and new jobs and the test plan that was used to test the jobs.
• Monitored and resolved the ITG ticketing issues that arouse during the implementation of the jobs.

Sr.Data Stage Developer

Confidential

• Participated in architecture and design reviews and provide leadership in the areas of lifecycle, supportability, monitoring, care & feeding, and service restoration.
• Actively provided inputs on designing strategies and architecture for building a data warehouse.
• Provided recommendations regarding enhancements and/or improvements regarding to the enterprise master data, operational data stores, data warehouse and data marts.
• Actively participated in project coordination with business groups in order to define the requirements, data analysis, data validation, data profiling, data discovery and system designing.
• Extensively used sequential files, complex Flat Files, Sort, Funnel, Remove Duplicates, Merge, Aggregator and created datasets.
• Experience in SQL scripting, and PL/SQL scripting.
• Experience in writing Unix shell scripts for scheduling Datastage jobs, to handle error management and audit management, and also developed scripts for cleansing, moving and archiving the files.
• Used Datastage sequencer jobs extensively to take care of inter dependencies and to run Datastage parallel jobs in sequence.
• Responsible for supporting and managing Datastage projects and monitor daily runs of the projects in production environment and troubleshooting of the production issues.
• Performance monitoring and performance tuning of ETL design to enhance the performance of the job workflow by identifying performance bottlenecks by appropriately using the best ETL standard practices in the Datastage job design.
• Performance tuning of SQL queries by appropriately using the best SQL design standards. Operational maintenance of the Energex Performance Management, Power Quality, GSL and Service Interactions Projects for Energex and AIM, Power Quality, SCAN and MIS projects with Ergon.
• Making the necessary enhancement to fix the project bugs based on the business priority.
• Coordinating monthly releases in to production.
• Effective engagement with project stakeholders and participated in weekly meetings with project team, peers and less experienced staff regarding progress on activities.

ETL Consultant

Confidential

• Understanding the complexity behind the data model and data quality to support build enterprise wide data architectures.
• Worked on the Data Models and systems processes based on findings through use case scenarios, workflow diagrams, and data models.
• Assist in administering multiple SQL Server instances supporting business, and installation of Microsoft SQL server 2012 on the various data warehouse application environments.
• Part of BIDW team involved development and maintenance of the enterprise Data warehouse project, having good understanding of full development life cycle of the project, supporting all aspects of data warehousing including database development, ETL development (SSIS), report development(SSRS).
• Development and peer reviewing on ETL design.
• Developed of unit cases scenarios to test the ETL solution, and designed the migration plan/documentation for the designed ETL and SSRS solution.
• Performed unit and Integration testing and validated the test cases by comparing the actual results with expected results.
• Analyzed and enhanced the performance of the jobs and project using standard techniques.
• Sound knowledge in best practices of developing SSIS project using SSIS beyond ETL.
• Resolved data issues during the testing processes and reloaded the data with all the necessary modifications.

DataStage / Cognos Developer

Confidential

• Actively participated in designing strategies and architecture for building a Data warehouse.
• Actively participated in project coordination with business groups in order to define the requirements, data analysis, data validation, data profiling, data discovery and system designing.
• Proficient in interaction with the business users. Pioneered load strategies of loading staging area and data marts.
• Identified and documented data sources and transformation rules required to populate and maintain data warehouse. Developed Data Stage parallel jobs to load/extract data to/from sequential flat files load into SQL server database.
• Designed and developed complex jobs, from varied transformation logic using different stages like Transformer, Lookup, Filter, Aggregator, Join, Merge, Funnel, Sort and many more.
• Created job sequences, sub sequences and master sequences to control the flow of jobs.
• Performed Unit and Integration testing and validated the test cases by comparing the actual results with expected results.
• Resolved data issues during the testing processes and reloaded the data with all the necessary modifications.
• ETL Performance Monitoring and Tuning to enhance the Analyze ETL workflows to identify performance bottlenecks by appropriately using the Datastage job stages and Partition methods
• Tuned Data Stage transformations and jobs to enhance their performance.
• Successful Data Stage Designing as the designed jobs is running in production environment and project has gone live now.