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.

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

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

AutoSys, IBM Support Utilities: MQS options, File Manager by IBM

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

ETL designer - Project Lead

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.
• Involved in the conversion of huge data when pertaining to the new customers when Confidential acquired new (US TRUST, Military Bank & Countrywide). Maintaining Sync with the existing data.

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

Mainframe/ETL Developer

Responsibilities:

• Customer Database Retirement: worked on the customer database retirement from Confidential 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 Confidential 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