SUMMARY

• Detail - oriented and result driven software professional with 9+ years of experience in populating and maintaining Enterprise Data Warehouse and subject area specific data marts using IBM DataStage
• Extensive experience in senior roles and leading a team of 3-9 developers both onsite and offshore
• Involved in all phases of SDLC: Requirement gathering, analysis, design, development, testing, production support and maintenance. Also worked on Agile/Scrum methodology project
• Working Experience in various domain: Insurance, Financial, Retail, Semiconductor, Manufacturing and Automotive industry
• Actively involved in coordinating and interacting with a large team consisting of customers, business manager, technical leads, Project Manager, Business Analysts, Testers and Developers
• Understanding with Relational Database Modeling and Dimensional Modeling - Star and Snowflake schema
• Performed data profiling using IBM Information Analyzer
• Expertise in working with various sources such as Flat files, XML files and Databases like DB2, Oracle, Teradata, SQL Server, MySQL, Oracle Exadata, Salesforce.com and Azure BLOB Storage
• Experience in development of DataStage Server, Parallel and Job sequences for complex processes
• Ability to work on SAP environment. Have basic understanding on navigating through SAP environment
• Experienced with Unit and System integration testing and writing documentation
• Excellent communication and interpersonal skills, problem solving skills, flexible, self-direct, ability to work with minimum supervision, and a team player
• Strong teamwork and initiative; highly accountable and dependable; ability to multitask and work independently

TECHNICAL SKILLS

• IBM DataStage v 11.5/11.3/8.7/8.5/8.1.1/7.5 , Microsoft SSIS, Teradata ETL, Informatica
• Oracle, IBM DB2, SQL Server, Teradata, MySQL
• SQL* Loader, SQL Developer/Navigator, Squirrel, MySQL Workbench, Teradata SQL Assistant
• Enterprise Architect 9, Microsoft Visio, TOAD
• Control-M, ActiveBatch, Autosys, Tivoli Work Scheduler, Cisco Tidal
• Borland StarTeam, SVN, Ascential Version Control
• ServiceNow, Remedy, ClearQuest, IBM Succeed, JIRA, HP-ALM Quality Centre 11.00
• MS Project, MS Office Suite, OpenOffice Suite, MS Visio, Tableau
• Windows, Linux/UNIX (IBM AIX, SuSE, HP-UX)
• SQL, HTML, XML, Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, Stevens Point, WI

Information Services Specialist (DataStage Developer)

Responsibilities:

• Primarily responsible for developing, troubleshooting, maintaining and supporting DataStage job/sequences to load Data Warehouse, Data Marts and Salesforce.com
• Worked on Salesforce environment: create and edit fields, page layouts, field permissions, in order to develop ETL related code
• Troubleshoot data issues and determine root-cause of data transformation problems
• Developed and maintained functional/technical design documents
• Understand source to target mappings and business requirements, data modeling to develop in a timely manner
• Built, maintained, and enhanced policies, standards, processes (as required) with regards to industry standard practices
• Written UNIX scripts for file manipulations and batch scripts for automating Datastage jobs in Windows environment
• Assisted with building job schedules in Tidal for job automations
• Responsible for code review and production migration of ETL code
• Trained and mentored the client team
• Developed ETL dashboard on Tableau for job monitoring and tracking

Environment: IBM Infosphere DataStage and QualityStage 11.5, Oracle Exadata, IBM DB2, Teradata v14, Cisco Tidal Enterprise Scheduler, IBM Cognos, SAP Business Objects, Oracle eBusiness application, InfoLease, Remedy, ServiceNow, Tableau 10, Oracle Exadata, Salesforce.com, Microsoft Azure, LoanIQ App

Confidential

Lead DataStage Developer

Responsibilities:

• Primarily responsible for integration data from different geographical regions to Business Data warehouse
• Collaborated with Data Architect to gather requirements, conduct analysis on data and prioritize requests
• Developed new technical specifications from functional specifications
• Worked with Data Modeler to create Source to Target mappings
• Worked on SAP. Extract data from SAP tables and load to flat file.
• Designed, developed job sequences to run multiple jobs
• Performed data profiling using IBM Information Analyzer.
• Responsible for creating unit test cases and appropriately documenting them
• Documented ETL Process following the standard naming conventions, business vocabulary, transformation rules and related enterprise consistency specifications

Environment: IBM InfoSphere DataStage & QualityStage 8.5, Information Analyzer, Business Objects, Putty, SAP R/3, Oracle, UNIX HP-UX, SQL Developer, Tivoli Workload Scheduler

Confidential, Hoffman Estates, IL

Sr. DataStage Developer/ETL Lead

Responsibilities:

• Responsible for leading a team of 5 ETL developers in a Scrum methodology project
• Designed and developed the generic ETL utility to load data from MySQL database to Teradata
• Engaged in design and development of DataStage jobs to load data from various applications to target Teradata environment
• Ensured the stable operation of ETL processes in the production environment to agreed service levels
• Created support documents for the offshore team. Conducted knowledge transfer sessions to help the offshore team understand the process
• Worked on fixing production bugs using the tool JIRA and also used IBM Succeed for change management
• Developed, prepared and used test data/cases to verify accuracy and completeness of ETL programs
• Responsible for moving code from one environment to another. DEV to TEST and then to PROD

Environment: Teradata ETL Utilities (FastLoad, Mulitload, FastExport, BTEQ), IBM Infosphere DataStage and QualityStage 8.5, MySQL, Oracle 11g, Teradata v13, BMC Control M, IBM Succeed, JIRA, SVN Tortoise, Linux, IBM Unica (Campaign/Interact)

Confidential, San Antonio, TX

Lead DataStage Developer & Offshore coordinator

Responsibilities:

• Worked closely with Business analysts and Business users on an Agile development to understand the requirements and build the technical specifications
• Worked on loading data to the SAS environment from a third party application called Yodlee (Money Manager) and validated data loaded to SAS Library
• Worked on parsing XML data and loading it to DB2 tables
• Worked on Maintenance and Support project enhancing jobs to optimize performance
• Created source to target mappings and identify business rules by understanding Informatica mappings
• Extensively used Control-M scheduler to schedule DataStage jobs
• Worked with internal resources during development phases to ensure appropriate knowledge transfer
• Reviewed and recommended test cases/scenarios to testing teams

Environment: IBM Websphere DataStage and QualityStage 8.1.1/8.5, Informatica PowerCenter 9.1, Oracle 10g, IBM DB2 9.7, Oracle 11g, SQL Server 2005, Squirrel SQL Client, BMC Control-M 7.0, Putty, Borland StarTeam, Yodlee (Money Manager), Red Hat 4, IBM AIX 6.1, Windows XP, Windows Server 2008 R2 Enterprise, SAS Enterprise Guide, Business Objects, Hadoop, IBM Unica