SUMMARY:

• 11+ Years of Exp in DW&BI, IBM Datastage 11.5 & lower, UNIX, SAP, Various Databases
• Having core experience in Data Warehousing domain (Banking/Telecom /Retail and Manufacturing).
• Have played various roles Onsite Coordinator, Project/Team/Module Leader, Admin, Designer and Developer.
• Worked with various Business Users, Business Owners as part of functional and technical requirement gathering.
• Worked on IBM Datastage 11.5, 11.3, 9.1, 8.5, 8.1, 7.5(PX) and IBM Datastage 7.1 (Server Edition).
• Worked on Abinitio, Informatica, SSIS and Talend ETL tools for few months during project work.
• Datastage server installations on Linux and other administration tasks also carried out on adhoc basis.
• Good experience in Data Stage Administration task, IBM Information Server (IIS) Console user access grants.
• Worked on various Data warehousing, Data Quality, ETL Upgrades and Data Integration projects.
• Supported the operations team 24*7 with solutions for all sorts of day to day production issues/errors.
• Developed low level / High level designs for various ETL Data warehousing applications/ projects.
• Source & Target Mappings Analysis and Design for new applications in ETL projects.
• Used Both Pipeline Parallelism and Partition Parallelism and other methods to improving performance.
• Involved in Performance Tuning of Server/Parallel Datastage jobs in complex ETL data warehousing projects.
• Written Unix Shell Scripts, Powershell scripts & CO - SORT Scripts for minimizing the efforts.
• Unit testing of Datastage Jobs (along with documentation and test cases).
• Good knowledge on Creation, Review and Execution of Test Plan, Test Cases and Closure Summary.
• Expertise in SDLC lifecycle including designing, coding applications and solving critical Production issues.
• I have a good working knowledge in Project Management and team management.
• Working knowledge of Teradata involving architecture,  Teradata SQL, Indexing, Performance Tuning.
• Familiar with different  Teradata Utilities involving FastLoad, MultiLoad, TPUMP and BTEQ .
• Ability to learn new technologies with in a minimal time period and Good team management skills.
• Good communication skills and effectively interacts with Clients.
• Taken training sessions for Datastage development of multiple version and UNIX scripting.

TECHNICAL SKILLS:

ETL Tools Used: IBM Datastage 11.5 and all prior versions, Abinitio, Talend (Basic) & Informatica

Other BW Tools: IBM Optim, IBM InfoSphere CDA, IRI Co-sort 8.1, Toad, Sql developer

BI Tools Used: Business Objects, Hyperion, SAP, SAP-BW and Power BI

Operating Systems Used: Linux, UNIX, Sun Solaris, MSDOS and Various WINDOWS versions

Programming Languages: C, C++, VB (Basic), HTML, Basic and XML

Databases Worked: MSSQL Server, Oracle, Teradata, MS Access, DB2 and Green plum

Scripting worked: UNIX Shell Scripting, Powershell, and Batch Scripting

Scheduling Tools: Autosys, Tivoli TWS, Control M, Windows Scheduler and UNIX Crontab

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Senior Datastage Consultant, SME and Datastage Administrator

Responsibilities:

• Ensure deliverables are prepared to satisfy the project schedule as well as management schedule.
• Built ETL jobs for migration of data and extensively worked on the Performance tuning of Datastage jobs.
• It involved an end to end testing of inbound and outbound transactions from corporate to Warehouse.
• Status reporting on a daily & weekly basis, defect capture, retesting and closure of defects.
• Performance tuning of ETL jobs for optimum performance and provided to production support as well.
• Involved in Datastage installation and administration tasks. Including creating the PMRs to IBM and followup.

Confidential

Project Leader, Designer and Administrator

Responsibilities:

• Provide status reporting of team activities against the program plan or schedule Keep the project manager and product committee informed of task accomplishment, issues and status of the ongoing subprojects.
• Worked with ETL architects to determine space requirements on the ETL server.
• Ensure deliverables are prepared to satisfy the project schedule as well as management schedule.
• Establish and enforce technical standards for deliverables of projects.
• End to End job modification and data testing of 5000 Datastage jobs, 3000 + Teradata scripts in DS11.3 and DS9.1.2.
• Involved in Datastage administration tasks. (i.e. Installation/Bring down/up Datastage engine, unlocking the DS Jobs)
• Parallel testing against existing prod system and new prod system loaded data.
• Upgrade Cutover Activities, Go live on prod. Post upgrades support activities.

Confidential

Onsite Coordinator/Module Lead

Responsibilities:

• Handling the Team and Allocating the work accordingly.
• Provide status reporting of team activities against the program plan or schedule Keep the project manager and product committee informed of task accomplishment, issues and status of the ongoing subprojects.
• Handling the Team and Allocating the work accordingly.
• Obtain summary spreadsheet and create the data definition file.
• Use the raw data file and the definition file for Extracting data from Mainframe.
• Run IBM Optim to mask necessary fields. Using Optim, write the data into a database.
• Created the CFF files to unload the data back to Mainframe systems.

Confidential

Onsite Coordinator/Designer / Module Lead

Responsibilities:

• Understanding the current solution and analyzing it and captured business requirement.
• Creating the Job’s High/low level design as per the business requirements.
• Documentation, flow diagrams, ops manual and other such metadata maintenance for the application.

Confidential

Senior Developer / Module Lead

Responsibilities:

• Creating the Job’s, UNIX and Co sort scripts as per PX requirement.
• Creating Test cases for all changed applications and job’s accordingly.
• Refers Job books for Previous developed applications for understanding job logic
• Documentation, flow diagrams, other such metadata maintenance for PX Migrated application.
• Discuss with Business analysts for Data validation for migrated applications.

Confidential

Datastage Developer

Responsibilities:

• Understanding the new requirement from business analysts/owners to create DataStage jobs.
• Creating the Job’s, UNIX and Co sort scripts as per the business requirements.
• Reconciliation of the database in cases of bulk backend updates in the source system.
• Replication of the tables in other database for the vigilance reports, Documentation, flow diagrams, ops manual and other such metadata maintenance for the application.