SUMMARY:

• Over 5 years of experience in Data warehouse Design, Data modeling, Development and Testing using ETL and Data Migration life cycle using IBM WebSphereDataStage 8.x/7.x.
• 7+ years of IT experience in software development functions encompassing Requirement Analysis, Software Development, Enhancement, Testing, Implementation and Production support activities across projects.
• Strong knowledge in Data warehousing concepts.
• Proficient in using DataStage in Development, support, Data Quality and Data conversion projects pertaining to several applications as per client specifications.
• Expertise in building Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS), Star and Snowflake schema design.
• Expertise in using highly scalable parallel processing Infrastructure using DataStage Parallel Extender.
• Experience in running and scheduling Server/parallel Jobs in DataStage to populate tables in Data warehouse and Data marts.
• Expertise in Scheduling tools like AutoSys for automating and scheduling jobs run.
• Able to resolve many production issues related to performance tuning.
• Experience in working on various data sources such as Oracle, MS SQL Server, and DB2, XML and Flat files.
• Expertise in DB2, IMS, PL/SQL, COBOL programming involving Stored procedures.
• Experience in development and Support projects involving online and large Batch processes.
• In - depth Understanding of the Banking Domain particularly in Customer Data management, Deposits applications in Retail Banking Sector.
• Spearheaded some of the critical projects of Confidential in the Consumer and Small Business banking domain.
• Efficient team player with strong technical, logical, analytical and problem solving abilities.
• Exhibit extraordinary Project execution and team management skills and often appreciated for prompt technical solutions and dynamic leadership.
• Prepared necessary technical documentation for projects with more complexity and involved in detailing architectural changes for the system.
• Participated in Joint Architect’s discussion and Project design conferences to provide system consultation and prepared SIW, Design documents (HLD/LLD), Project work break structure (WBS) and Project test plans.
• Executed many test scripts and developed test conditions and performed Unit, CIT and SIT test functions throughout my stint in all projects I have worked on.
• Have immense knowledge of how to add/update/run the test scripts status in the HP Quality Center and executed many development test cases using this tool and also logging/fixing defects as part of the project.
• Preparation of implementation plan and schedules, coordinating implementation procedures with Technical support teams.
• Excellent communication skills and great ability to blend well with team members or provide leadership to any team.

TECHNICAL SKILLS:

Primary Skills: IBM Web Sphere DataStage 8.x, (Administrator, Manager, Designer, Director, Parallel extender, Quality Stage, DataStage Plug-in, Data mining, Hadoop - Map Reduce, HDFS, Hive.

Programming language: COBOL, JCL, Easytrieve, REXX, Ca7 scheduling, MQ series, Unix Shell scripting.

Platform: OS 390, MS-DOS, Windows 9x/NT/XP/Vista/7/8, UNIX, Linux

Database and Data Modeling Tools: DB2, Oracle 8i/9i/10g, RDBMS, PL/SQL, MS SQL Server 2005/2008, SQL*Loader, SQL plus, Flat files, Sequential files, Erwin, Teradata SQL Assistant

Web technologies: HTML, XML

Supporting Tools: AutoSys, IBM Support Utilities - MQS options, File Manager by IBM

PROFESSIONAL EXPERIENCE:

Confidential - Plano, TX

ETL designer

Responsibilities:

• Perform impact analysis for the new business requirements.
• Review new test data requirements.
• Build centralized sanitized data and mask the production data coming in from various applications.
• Carry out unit testing for the components prepared.
• Run jobs during data refresh process to capture subset and sanitize data.
• Seed the lower test environments with new sanitized data from production.
• Provide support to all test platforms when and where there is an issue related to data.
• Evaluate current or emerging technologies to consider factors such as cost, portability, usability.
• Ensure the compatibility of system components.
• Creation of WBS (work break-down) structure for the project.
• Collaborate with engineers or software developers to select appropriate design solutions or ensure the compatibility of system components.
• Doing a continuous monitoring of the existing process and provide optimized solutions to improve the performance and decrease the timelines of the process.
• Installed and configured Hadoop, MapReduce, HDFS (Hadoop Distributed File System), developed multiple MapReduce jobs in java for data cleaning and processing.
• Applied MapReduce framework jobs for data processing by installing and configuring Hadoop, HDFS.
• Created Hive External tables and loaded the data in to tables and query data using HQL.
• Performing data analysis in Hive by creating tables, loading it with data and writing hive queries which will run internally in a MapReduce way.
• Performed performance tuning and troubleshooting of Map Reduce jobs by analyzing and reviewing Hadoop log files.
• Involved in design, source to target mappings between sources to operational staging targets, using DataStage Designer.
• Involved in unit, CIT, SIT, performance testing of Data Stage jobs.
• Used Data Stage Director to run and monitor the jobs for performance statistics.
• Manual maintenance to sync the data between the application and its interfaces in a periodic basis.
• Sending periodic reports to the Client managers and Customer data management group for analysis, using the advanced Database tools like Quest Central DB2 and Toad.
• Data conditioning in the Test environments to allow testing teams to perform the testing and Certification.

Software/Environment: IBM DataStage 8.5 (Designer, Director, Manager, Parallel Extender), Autosys, Quality Stage,DB2 DB, Oracle 10g, SQL Server 2008, Flat files, Sequential files, TOAD, SQL*Plus.

Confidential - Newark, DE

Datastage developer

Responsibilities:

• Worked from development phase of the application by participating in documentation of HLD and LLD as per the Requirements from the architect.
• Involved in design, source to target mappings between sources to operational staging targets, using DataStage Designer
• Involved in the all the activities like testing, certifying and implementation of the data models in production.
• Performed ETL coding using Sequential file, Transformer, Sort, Merge, Hash file, Aggregator stages compiled, debugged and tested.
• Extensively used stages available to redesign Data Stage jobs for performing the required integration.
• Design and implementation of Job flows using Autosys for the functionalities supported.
• Created Design document with flow charts for converting into ETL in Pseudo format and shared with onsite.
• Converted the ETL pseudo flow into actual Datastage job flows, Job sequences, using
• Datasets, Sequential file, Transformer, Sort, Merge, Aggregator stages compiled, debugged and tested.
• Extensively used stages available to redesign DataStage jobs for performing the required integration.
• Used DataStage Designer tools for creating Parallel jobs and importing and exporting the jobs.
• Created DataStage Jobs to build business rules to load data.
• Development of Unix shell scripts.
• Used DataStage Director to run and monitor status of the jobs. Conducted Technical and Architectural design review of the application during development Phase.
• Worked closely with data warehouse architect and business intelligence analyst in developing solutions.
• Updating and Reviewing the Control Plan, Technical Recovery Plan and other Quality Control documents and making them available for the Production Support and Client Partners.
• Coordinating Application Hands-off Meetings to the other application support teams after implementation, and helped in the design of the required documents.
• Taken care of Post Implementation Production Support (PIS) of the application.
• Coordinating the team in the Defect fixes, and addition of new Enhancements during PIS.
• Data Conversions: Involved in design, testing and developing the stages that are used for loading the Initial data to the application.
• Worked on various ETL tools while loading very large volumes Data into DB2 tables (complete customer base) during the Initial Loading.

Software/Environment: DataStage 8.0, DB2 UDB, Ascential Data Stage, Business Intelligence 10, Flat files, SQL Server -2005/2008, PL/SQL, UNIX, Windows NT/XP

Confidential

ETL Developer

Responsibilities:

• Customer Database Retirement: worked on the customer database retirement from BOSS application and ported to WCC (WebSphere Customer Center).
• Development work on routing the customer inquiry and maintenance transactions from front end applications to WCC (WebSphere Customer Center) a product of IBM.
• Development work on sending the account level updates from BOSS to FFD in real-time.
• Working on Code Fixes and Small Enhancements to the existing functionalities of the application.
• Maintaining Data Quality by Cleaning up and integrating the data.
• Tracking production issues and providing resolution for the tickets raised, conforming to the SLA with the Business.
• Regulating the data flow by solving production job defects.
• Effective Participation in all code release and walkthroughs and provide support for the installs.
• Converted the mainframe Db2 jobs to datastage jobs using ETL tools.
• Involved in design, source to target mappings between sources to operational staging targets, using DataStage Designer.
• Involved in unit, CIT, SIT, performance testing of Data Stage jobs.
• Used Data Stage Director to run and monitor the jobs for performance statistics.
• Manual maintenance to sync the data between the application and its interfaces in a periodic basis.
• Sending periodic reports to the Client managers and Customer data management group for analysis, using the advanced Database tools like Quest Central DB2 and Toad.
• Data conditioning in the Test environments to allow testing teams to perform the testing and Certification.

Software/Environment: IBM DataStage 7.5, DB2 DB, PL/SQL, Autosys, UNIX, Windows