SUMMARY

• 7 years of IT experience with special emphasis on Analysis, Design, and Development of ETL methodologies in all the phases of the Data Warehousing life cycle.
• 5 years of extensive & diversified experience in loading and maintaining Data Warehouses and Data Marts using IBM Information Server 8.1.2,8.0.1/PE/EE/ 7.5/7.1/6.0/5.1/4.2 (Manager, Designer, Director, and Administrator) ETL processes, Quality Stage 8.1.2,8.0.1,7.5, Information Analyzer, Scheduling tools AutoSys, TWS / Maestro, Control - M.
• Extensively worked on standardization, Matching, survivorship, real web service (WSDL) etc.
• Used Information Analyzer to conduct end to end data profiling and content analysis.
• Extensively worked on DataQuality stages like Standardize, Investigate, Match Frequency, Reference Match, Unduplicate Match, Survive etc
• Experienced in Extraction, Cleansing, Integration, and Loading of data from/to various data sources.
• Designed the database models like Star, Snowflake and Multistar Schemas.
• Designed and developed parallel jobs in SMP architecture on Datastage Parallel Extender.
• Experienced in scheduling Batch jobs.
• Experienced in integration of various data sources (DB2-UDB, SQL Server, Oracle, Sybase, and MS Access).
• Extensively worked on various stages like ODBC, Transformer, Sequential file, Hashed file, Join, Lookup, Lookup file set, Sort, Aggregator, Copy, Dataset, Merge, Oracle, Remove duplicates, DB2 stage, Teradata Stage (Multiload, Fast load, Tpump)
• Extensive experience in loading high volumes of data.
• Experience in data modeling using tools like Erwin and MS Visio.
• Experienced in UNIX Shell Scripting as a part of file manipulation, scheduling and text processing.
• Involved in functional requirements gathering, analysis, design, development, test and implementation.
• Excellent business analysis, interpersonal and communication skills. A strong team player.

TECHNICAL SKILLS

ETL Tools: IBM Information Server V8.1.2, 8.0.1/7.5.2/7.5/7.1/7.0/6.3/5.1 (Parallel Extender), Quality Stage 8.1.2, 8.0.1, 7.5, Information Analyzer, Profile Stage, MVS Mainframe OS390.

Data Modeling Tools: Erwin 3.5.2/4.0, Visio 2003

Databases: Oracle 11i/10g/9i/8i, MS SQL Server 7.0/6.5, SQL Server 2005, Sybase12/11.9/10, DB2 UDB V9/, Teradata V2R3/V2R4.1,MS Access 2000/97

Tools: SQL*Plus, SQL*Loader, Spoof (DB2), Teradata SQL Assistant, Toad, OBIEE 10.3.3, BI, Crontab etc.

Operating Systems: IBM AIX 4.3/4.2, HP-UX, Solaris Unix, Windows NT/95/98/2000/XP/Vista

Programming: SQL, PL/SQL, Unix Shell Scripting, Java 2.0, HTML, DHTML

Languages: SQL, PL/SQL, C, C++, BASIC, Visual Basic

CM Tools: Clear Case, Clear Quest

PROFESSIONAL EXPERIENCE

Confidential, Louisville, KY

ETL developer

Responsibilities:

• Actively participated in the system design, coordinate with business groups in order to define the requirements.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Created process flow diagrams using MS Visio.
• Worked on creating on assigning projects and Metadata in Information Analyzer.
• Involved in the development of Common Error Management to capture and handle the error records.
• Used various stages like transformer, funnel, lookup, join, merge, remove duplicates, change capture, filter, aggregator etc.
• Designed parallel jobs using stages such as Join, Merge, Lookup, Remove Duplicates, Copy, Filter, Funnel, Dataset, Lookup, Pivot, Sort, Surrogate key Generator, Change Data Capture, Modify, Row Generator and Aggregator.
• Created Master controlling sequencer jobs using Data Stage Job Sequencer.
• Created UNIX shell scripts to run Datastage batch jobs through Autosys.
• Developed job sequence and implemented restart ability using various checkpoints.
• Used Information Analyzer for Column Analysis, Primary Key Analysis and Foreign Key Analysis.
• Worked on creating on assigning projects and Metadata in Information Analyzer.
• Extensively worked on Datastage Director and Datastage Administrator.
• Created Master controlling sequencer jobs using Datastage sequencer.
• Involved in preparation of ETL documentation by following business rules, procedures and naming conventions.
• Experience with Creating Datastage Web services job & Calling Existing Web service jobs through Datastage, SOAP UI.
• Used Shared Containers for reusability and reducing job complexity.
• Migrated projects from development to QA to Production environments
• Performed the Integration and System testing on the ETL application.

Environment: Environment: Data Stage 8.1.2/8.0.1 (PX & Server), Quality Stage 8.1.2/8.0.1, Information Analyzer, Webservices, XML files, CSV files, flat files, Oracle 11i (OLTP, OLAP), Oracle 10g, Teradata SQL Assistant 7.1,XML, SQL server 2005, Star Team Version Control, UNIX 4.2.

Confidential, AZ

Datastage Developer

Responsibilities:

• 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.
• 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 jobs and created job sequences for batch processing and easy maintenance.
• Set various environment variables and parameters in Datastage administrator and also used them in managing the projects.
• Assigned users to project groups, created DSN’s, ENV variables.
• Enhanced the reusability of the jobs by making and deploying shared containers.
• Extensively used Auto sys for automation of scheduling for UNIX shell script jobs on daily, weekly monthly basis with proper dependencies.
• Extensively developed and deployed UNIX Shell scripts as wrappers that provides values to Data Stage jobs during runtime, execute Data Stage jobs.
• Performed Datastage Admin activities like bouncing the DS server, unlocking jobs through UNIX etc.
• Worked on troubleshooting, performance tuning and performance monitoring for enhancement of Datastage jobs.
• Participate in meetings to explain the profiling results to the business people.

Environment: IBM Websphere Datastage 8.0, DB2 9.7, Oracle 11i, AIX 5.3, Autosys 4.5.

Confidential, MD

ETL Developer

Responsibilities:

• Designed various jobs based on technical specifications, data flow diagrams and workflow/process.
• Designing the Target Schema definition and Extraction, Transformation and Loading (ETL) using Datastage.
• Developed various Datastage jobs in Enterprise Edition (Parallel Extender) using Datastage designer.
• Designed and developed the ETL jobs using Parallel Extender which distributed the incoming data concurrently across all the processors, to achieve the best performance.
• Used Parallel Extender to load data into data warehouse with different techniques like pipeline and partition in MPP Environment.
• Created Hash tables referencing Surrogate Key tables for quicker and more efficient lookup to dimensions.
• Extensively used built-in (Sort, Merge, Oracle, Aggregator), plug-in stages for extraction, transformation and loading of data.
• Extensively used Datastage Manager to import/export metadata, jobs and routines from repository and also created data elements.
• Used the Datastage Director and its run-time engine to schedule running the solution, testing and debugging components and monitoring the resulted executable versions.
• Created Unit and System test plans for testing Datastage code based on Functional Requirement and Business Requirement Documents.
• Extensively used parameters in job properties for entering default values while loading.
• Extensively worked on Autosys JIL creations for nightly batch runs.
• Technical support to various groups and teams in solving major issues in Datastage jobs and application development.
• Developed K-shell scripts for loading initial sample data to the database.
• Developed test data and conducted performance testing on the developed modules.
• Involved in creation of Shell scripts for inbound file handling, maintenance and Archival.

Environment: Datastage 7.1/7.5, Autosys4.5, Oracle 9i/10g, DB2, SQL Server, Korn Shell Scripts, HP UX.

Confidential, Americus, GA

ETL Developer

Responsibilities:

• Gathering requirements from the business users and the in-house co-ordination team.
• Responsible to design, develop the warehouse/data marts for various functional areas.
• Joined data from different sources and loaded into data mart.
• Developing shell scripts to automate file manipulation and data loading procedures.
• Error Logs / Audit Trails were maintained.
• Enforcing data Integrity rules/ Business Rules.
• Interacting with User groups/ Corporate Testing Group / Business people.
• Developing aggregate fact tables for different users in Data marts.
• Involving in the process design documentation of the Data Warehouse Dimensional Upgrades.
• Used DataStage Manager for managing datastage repository (view and edit), define custom routines & transforms, Import and export items between different datastage systems or exchange metadata with other datawarehousing tools.
• Used DataStage Director and the runtime engine to schedule running the server jobs, monitoring scheduling and validating its components.
• Extracting, cleansing, transforming, integrating and loading data into datawarehouse using Datastage Designer.

Environment: Datastage 7.0, SQL, UNIX AIX, Windows NT/2000, Oracle 9i, DB2.

Confidential

Data Analyst

Responsibilities:

• Created forms for new Policy entry détails.
• Responsible for maintaining Policies as per the Customer requirement.
• Wrote SQL queries for data extraction.
• Creation of Reports that allows the user to retrieve complete information as required for the financial status like monthly reports, day to day transaction.
• Customizing and designing reports using Oracle Report Writer.

Environment: Oracle 7.3, SQL, Oracle forms 4.5, Oracle reports 2.5, UNIX and Windows.

Confidential

Business Analyst

Responsibilities:

• Served as a liaison between the users and cross-functional teams in application development for better understanding of the business process.
• Involved in preparing overall project plan.
• Prepared accurate and detailed requirements specification documents and functional specification documents; assisted in developing user interface guides.
• Documented the acquired results of analysis and workflows as well as obtaining sign-off from the appropriate personnel.
• Evaluated the data collected through task analysis and business processes.
• Provided suggestions to the development team at the development phase to meet the business needs of the product.
• Assisted Project Manager in preparing Joint Application Development (JAD) sessions to identify business rules and requirements and then documented the details for department review.
• Provided weekly status updates and generated follow up tasks.
• Developed use case diagrams, activity diagrams and sequence diagrams using MS Visio.
• Designed and executed the test scripts and test scenarios.
• Managed any change request related to the working project plans to meet the agreed deadlines.

Environment: MS SQL, C++, MS Project, MS Visio, MS office (PowerPoint, Excel, Word), Mercury Quality Center.