SUMMARY

• 8 years of IT experience in Analysis, Design, Development, Implementation, and Testing of Client/Server, and Data Warehousing & OLAP Applications using ETL Tools.
• Extensive experience using DataStage stages such as Lookup, Join, Merge, Funnel, Remove duplicates, Aggregator, DB2 Enterprise, Oracle Enterprise, Sequential file, Dataset, File Set.
• Extensive experience with data warehousing and business intelligence applications with participation in entire life cycle of projects.
• Extensive knowledge in Pipeline/Partition concepts and techniques - Round Robin, Entire, Hash by Field, Modulus and Range.
• Experience with ETL design and development of DataMarts /Enterprise wide Data Warehouses / Operational Data Stores.
• Experience in creation of Star and Snowflake dimensional data marts using Microsoft Visio and Erwin.
• Used job Sequencer to specify the network/sequence of jobs to run.
• Extensive knowledge and experience in various parallel stages (Sort, Merge, Aggregator, and Transformer, Funnel, Filter, Look-up, Surrogate Key, Remove Duplicate, Transformer, Column/Row Generator and Peek) and Mainframe stages (Aggregator, Join, Look-up, Fixed Width Flat File).
• Excellent skills in the development of Extraction, Transformation and Loading (ETL) solutions to meet the business needs of our clients and in providing technical leadership to outsourcing team members.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and Dimension Modeling for OLAP
• Proven track record in troubleshooting of DataStage jobs and addressing production issues like Performance Tuning and enhancement.
• Involved DDL Shell data definition language(DDL) that allows you to create, modify, inspect, and delete table layouts.
• Responsible for interacting with business partners to identify information needs and business requirements for ETL jobs.
• Proficiently participated in resolving EDI issues related to customer and supplier EDI requirements
• Comprehensive knowledge of EDI or EC (Electronic Commerce) system
• Worked with varied Stages like Lookup, Join Merge, Sort, Copy, Filter, Transformer, Aggregator and Funnel Stage.
• Monitoring and administered the EDI system/application.
• Extensive knowledge in handling Slowly Changing Dimensions (SCD).
• Analyzed business processes w/managers to ID Electronic Data Interchange (EDI) opportunities.
• Experienced in writing complex SQL scripts, Stored Procedures, Views and Triggers using, PL/SQL.
• Involved in writing TWS, UNIX Shell Scripts and experience in executing scripts from DataStage.
• Execution of test plans for loading the data successfully into the targets.
• Self-motivated, customer-focused, teamwork oriented and strategically focused experienced professional with strong analytical, pattern detection and problem-solving abilities.
• Experience in PL/SQL stored procedures, Triggers and Packages.
• Expertise knowledge improving Performance by fine tune the jobs.
• Programming experience in C, C++.
• Excellent interpersonal, communication skills with a friendly positive attitude.

TECHNICAL SKILLS

Operating System: Windows 2000/XP/Vista, Unix and Linux

Databases: Teradata 13.0, Oracle 11g/10g/9i/8i, SQL Server, DB2, Mainframes

Scripting languages: Shell Script, Pl/Sql, JSON,TWS

Tools: Queryman, Designer 1.3/2.0/6I; Developer 6i; Erwin, SQL Loader; OracleToad, Query Analyzer, OEM.

Warehousing Tools: IBM Information Server 11.3/9.1/8.5, IBM Information Analyzer 11.3/9.1 DataStage 11.3/9.1/8.5

Testing Tools: Win Runner 7.0, LoadRunner7.0, Test Director 7, Rational Clear Quest, Jira

Other Tools: MSOffice, MSWord, MS Excel, MS Project.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr. Data Analyst/ Data stage Developer

Responsibilities

• Understanding the specifications for the IBM Banking Data Warehouse and Basel II compliant ETL Processes by interacting with the client and end users for gathering business requirements.
• Worked with the Team and organized meetings to halp team regarding the Data Analysis.
• Created the Functional Specific documents on various retail and wholesale loan sources including Student Lending, Auto Loans, Corporate Loans
• Created the TSDs, technical specific documents for the Business specifications for all the ETL jobs.
• Created the mapping documents for the various Held for sale accounts / source systems.
• Gathered requirements and developed various ETL jobs which generate meaningful financial data across multiple source systems.
• Developed Data stage jobs for the Comprehensive Capital Analysis and Review - CCAR Auto Loans, Student loans, Small Business, Corporate Loans, CUSTID and CCAR Credit Cards.
• Responsible for all pre-ETL tasks upon which the Financial Data Warehouse depends, including managing and collection of various existing data sources.
• Worked on the XML Stage for providing the data under CCAR to Federal Reserve.
• Created Master sequencers using User variable Activity, Job Activity, Execute Command Stage, Start Loop Activity, End Loop Activity, Nested Condition, Exception Handler Stages
• Created UNIX Shell scripts to generate reports to end users, handle data from staging to target, custom configuration files to handle source data, generic shell scripts to manage Data Transfer Control.
• Created UNIX shell scripts for the CCAR project to get the monthly and daily measurement period ids for the Quarterly runs.
• Automated both Monthly and Weekly refresh (data load) using the UNIX shell scripts.
• Audit internal financial process on a quarterly basis and monitored and analyzed key performance indictor(kPI) and financial ratios.
• Used Autosys as a scheduling tool to handle event-based scheduling and time based scheduling.
• Expertise in creatingdatabases, users, tables, triggers,macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• Extensively worked with Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, TeradataSQL Assistantand Query man.
• Proficient in performance analysis, monitoring and SQL query tuning usingEXPLAIN PLAN,Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle.
• Created Shared containers to effectively re use the etl jobs for Classification lookup and generating the surrogates on source to target tables.
• Involved in Unit testing, System testing and debugging.
• Involved in Performance tuning of Datastage jobs with proper datastage partitioning techniques and Node configuration
• Involved in the Production On call Support during Migration event
• Used Quality Centre to track defects and updated the status as and when the changes are done
• Wrote complex Shell Scripts to handle pre and post job runs

Environment: IBM Information Server 11.3, IBM Information Analyzer 11.0, Ascential DataStage (Designer, Director and Administrator),Infosphere 8.7, Oracle 10g/11g, DB2, SQL, PL/SQL, SQL* Loader, SAP interface, UNIX Shell Script, TOAD 7.3, ERWIN 4.2, Win XP and AIX UNIX 4.2, Autosys.

Confidential, Lansing, Michigan

Data Stage Developer

Responsibilities:

• Dynamic career reflecting pioneering experience and high performance in System Analysis, design, development and implementation of Relational Database and Data Warehousing Systems using IBM Data Stage 8.0.1/7.x/6.x/5.x (Info Sphere Information Server, Web Sphere, Ascential Data Stage).
• Experience in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.
• Excellent knowledge of studying the data dependencies using metadata stored in the repository and prepared batches for the existing sessions to facilitate scheduling of multiple sessions.
• Proficient in writing, implementation and testing of triggers, procedures and functions inPL/SQLandOracle.
• Used different Parallel job stages like Sequential File, XML Stage, Dataset Stage, Join, Merge, Lookup, Filter, Col and Row generator, Transformer, Change Data Capture, Modify, Aggregator, Remove Dup, Source and Target Stages, Oracle and ODBC Stages etc.
• Extensively worked on XML files using XML Input stage, XML Output stage - for extracting data from XML files into database, XML stage (XML Composer, XML Parser) to parse, compose and transform the XML data.
• Developed jobs to provide the RISK analyzed data thru XML files/ format to Federal Reserve.
• Used Information Analyzer for profiling data, check the data content and structure, analyze various source system data according to business need.
• Responsible for all pre-ETL tasks upon which the Data Warehouse depends, including managing and collection of various existing data sources.
• Expert in designing Server jobs using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, Link Partitioner and Link Collector.
• Experienced in integration of various data sources (DB2-UDB, SQL Server,PL/SQL,Oracle, Teradata,XMLand MS-Access) into data staging area.
• Educated and trained staff of assigned business areas on EDI applications.
• Acted effectively as point-of-contact on status of EDI transactions from internal and external customers.
• Extensively used Infosphere Quality Stages - Investigate Stage, Standardized Stage, Match and Survive Stage for generating reports, keeping the data clean and structured according to business.
• Generated the Pattern report and Token report as requested by the Business in identifying the Data patterns and inconsistency in the source data using Infosphere Quality Stage.
• Effectively used Standardized stage in standardizing the source data by using the existed rule sets like name, address and area etc. for multiple countries and generated the valid and invalid data reports.
• Involved in the Discussions with Business again to validate the Standardized reports and prepared ACL doc again with the action points.
• Involved in the design of Match Templates suggestions made by the Business and validated the results to identify the duplicates coming from the source depending on different Match types using Match Stage - Infosphere Quality Stage.
• Used Oracle PL/SQL for writing stored procedures, packages for extracting the data.

Environment: IBM Information Server 11.3, IBM Infosphere Quality Stage, IBM Information Analyzer 11.3, DataStage 11.3 (Designer, Director and Administrator), Oracle 10g/11g, SQL, PL/SQL, TWS, SQL Server, UNIX, SUNOS 5.1, Corn Tab TOAD 7.3, Win XP.

Confidential, Hartford, Ct

DataStage Developer

Responsibilities:

• Understanding the specifications for Data Warehouse ETL Processes by interacting with the client and end users for gathering business requirements.
• Designed the specifications and analyzed the data for business requirements and developed metadata mappings and detailed design documents.
• Involved in designing, developing and documenting of the ETL (Extract, Transformation and Load) strategy to populate the Data Warehouse from various source systems (Teradata) feeds using Data Stage, and Unix Shell scripts
• Used different Parallel job stages like Join, Merge, Lookup, Filter, Col and Row generator, Transformer, Modify, Aggregator, Remove Dup, Teradata Enterprise Stage, Teradata Load Stage, Teradata multiload/Tpump/Fast Export stages.
• Used Teradata utilities like Fast Load, Multi load, Pt Api Interface, BTEQ to efficiently handle data.
• Created Master sequencers using User Variable Activity, Job Activity, Execute Command Stage, Start Loop Activity, End Loop Activity, Nested Condition, Exception Handler Stages
• Used DataStage Director and the runtime engine to schedule running the server jobs, monitoring and debugging its components.
• Worked on Datastage admin activities like creating ODBC connections to various Data sources, Server Start up and shut down, Creating Environmental Variables, Creating Data Stage projects and Message Handler files, Dsparams File.
• Design and create weekly and monthly spending reports in financial process

Environment: IBM Information Server 9.1, IBM Information Analyzer 9.1, DataStage 9.1 (Designer, Director and Administrator), Oracle 10g/11g, DB2, SQL, PL/SQL, SQL* Loader, SAP interface, UNIX Shell Script, TWS, TOAD 7.3, ERWIN 4.2, Win XP and AIX UNIX 4.2, Autosys.

Confidential, San Jose, Ca

DataStage Developer 

Responsibilities:

• Understanding the specifications for Data Warehouse ETL Processes and interacting with the data analysts and the end users for informational requirements.
• Analyze business requirements and develop metadata mappings and detailed design documents.
• Code reviewed for the other developers and made performance improvements
• Developed jobs to load type II dimensional tables and fact tables.
• Imported data from various transactional data sources residing on SQL Server 2005, DB2 9.5 and Flat files and loaded into Oracle database.
• Used Information Analyzer for Column Analysis, Primary Key Analysis and Foreign Key Analysis.
• Identified and documented the slowly changing dimensions.
• Extensively worked on Parallel jobs Enterprise Edition Environment for splitting bulk data into subsets and to dynamically distribute to all available processors to achieve best job performance.
• Designed Parallel jobs using various stages like join, merge, remove duplicates, filter, dataset, lookup file set, aggregator, change capture, slowly changing dimension and funnel stages.
• Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
• Enhanced the reusability of the jobs by making and deploying shared containers and multiple instances of the jobs.
• Imported and exported Repositories across Datastage projects.
• Extensively used Autosys for automation of scheduling for UNIX shell script jobs on daily, weekly monthly basis with proper dependencies.
• Used Oracle PL/SQL for writing stored procedures, packages for extracting the data.
• Involved in creating technical documentation for source to target mapping procedures to facilitate better understanding of the process and in corporate changes as and when necessary.
• Involved in the migration of Datastage jobs from development to production environment.
• Responsible for the delivery of solution-oriented complex reports using Cognos Report Studio.
• Used Framework Manager to build models, packages and publish packages to Cognos Report Net Server.

Environment: IBM Information Server 8.5/ 8.0.1, IBM Information Analyzer 8.0, DataStage (Designer, Director and Administrator), Teradata 12/13, SQL, PL/SQL, SQL* Loader, UNIX Shell Script AIX UNIX 4.2, Control-M.