SUMMARY

• Over 8 years of total IT experience in installation, configuration, administration, design, development, deployment, testing and production support of Business Application Systems for Retail, Finance, Health Care, Pharmaceutical & Insurance Industries under all the phases of SDLC.
• Eight (8) years of experience in Support of Products/Applications for data integration/data migration/data conversion jobs in Data Warehousing and Business Intelligence areas.
• Three (3+) years of experience in Migration & New Development of DataStage and QualityStage Projects and Jobs from previous versions to 8.x Version of IIS InfoSphere Information Server suite.
• Extensively worked on various Database Stages, File Stages, Debug/Development Stages and Processing Stages like Join, Funnel, Merge, Transformer, Lookup, Filter, Sort, Sequential File, DataSet, Remove Duplicate Stages etc to develop Server, Parallel and Sequence jobs.
• For QualityStage: investigated dirty data character descrete, character concatenate, word investigate. Standardized data using rulesets. Removed duplicates using match frequency, reference match & unduplicate match. Also used survive stages.
• Experience in preparing high level and low - level design documents based on the business and functional requirements of clients.
• Implemented Unit Test Plans to ensure the successful execution of the data loading processes.
• A team member wif excellent analytical, verbal and communication skills, always eager to learn and understand.
• Prepared Application Understanding, Installation, Configuration, Administration, Design Specification and Disaster Recovery Plan Documents for the supported applications.

TECHNICAL SKILLS

ETL Tools: IBM Ascential DataStage 8.x/7.5x2/7.x EE & SE, Parallel Extender, IBM WebSphere Information Server 8.0.1/8.0.1a/8.0.2, IBM InfoSphere Information Server 8.1.1, ProfileStage, QualityStage

Databases: Teradata V2R5/R6/R7, Oracle 11g/10g/9i/8i, DB2 9.x/7.x, SQL Server 2005/2008, Netezza 3.x/4.x

Programming: C, SQL, PL/SQL, Perl/Shell Scripting

Operating Systems: Unix, Linux, Windows NT/XP/2000/2003 server

Scheduling: CA7, Control-M, Autosys

Connectivity: Citrix, Putty, Cygwin X, WinSCP.

PROFESSIONAL EXPERIENCE

Confidential, AR

CHILE OBIEE INTEGRATION PROJECT

Responsibilities:

• Participated in meetings wif Business users and Subject Matter Experts (SMEs) to understand the business requirements.
• Assessed the current environment and implementation standards.
• Used DataStage Designer/Director to design and run jobs to implement the Import and Export Interfaces.
• Extensively used DataStage Designer components to design various Parallel jobs in accordance wif business specs.
• Imported table definitions from ODBC/Plug-in table definitions available.
• Used Partition methods and collecting methods for implementing parallel processing.
• Worked on performance tuning of ETL jobs via SQL queries, data connections, configuration files, job parameters and environment variables.
• Created shared containers and multi instance jobs to enhance the performance by using more modular components.
• Customized UNIX/PERL scripts as required for preprocessing steps, to validate input and output data elements, along wif Data purging activites to ensure that no data footprints are left on the production server
• Extensively worked on various Database Stages, File Stages, Debug/Development Stages and Processing Stages like Join, Funnel, Merge, Lookup, Filter, Sort, Sequential File, DataSet, etc to develop jobs.
• Led onsite/offshore teams for delivery in specified timeframe.
• Performed Knowledge Transfer KT to internal team members and prepared extensive documentation of development standards and ETL good practices.
• Participated in meetings wif Business to understand the business requirements.
• Build Data Stage Jobs to read the table and create files.
• Build Data Stage Jobs to Read the HAT tool data and create files.
• Build Data Stage Jobs to TPump or Upsert the Insert/Update file to the production tables on the target Teradata Servers.
• Build Data Stage Jobs to delete from the production table the records to be removed on the Teradata Servers.
• Imported table definitions from ODBC/Plug-in table definitions available.
• Extensively worked on various Database Stages, File Stages, Debug/Development Stages and Processing Stages like Join, Funnel, Merge, Lookup, Filter, Sort, Sequential File, DataSet, etc to develop jobs.

Environment: IBM InfoSphere Information Server V8.1.1 Suite DataStage Oracle 11g/10gR2, Teradata V2R6.2/ V12, DB2 9.5, SQL Server 2005, WAS 6.0.2.27, Java, J2EE, SQL, PL/SQL, Shell Scripts, SUSE Linux Enterprise Server 10

Confidential, NY

PAYROLL MANAGEMENT SYSTEM

Responsibilities:

• Participated in meetings wif Business users and Subject Matter Experts (SMEs) to understand the business requirements.
• Assessed the current environment and implementation standards.
• Held workshops and information gathering sessions to understand the current environment concerns and advise accordingly.
• Assist in the planning for the upgrade & provide an overview of the new features, usage, tips and tricks to make full use of functionality
• Provide expertise, consulting and best practices for using performance Analysis, resource monitoring and data flow analysis.
• For QualityStage: investigated dirty data wif character discrete, character concatenate, word investigate. Standardized data using rulesets. Removed duplicates using match frequency, reference match & unduplicate match. Also used survive stage.
• For DataStage Extensively worked on various Database Stages, File Stages, Debug/Development Stages and Processing Stages like Join, Funnel, Merge, Transformer, Lookup, Filter, Sort, Sequential File, DataSet, Remove Duplicate Stages etc to develop jobs.
• Installed, Configured and Administered Oracle 10gR2 Metadata Repository Database and WebSphere Application Server 6.0.2.27.
• Involved in DataStage security - assigned IIS suite and suite component roles in IIS Web Console.
• Installed and Configured fix pack 1 on IIS 8.1 and resolved errors.
• Involved in migration of DataStage and QualityStage projects and jobs from earlier versions to 8.1.1 version.
• Prepared disk, file and network resources. Modified kernel parameters and user limits. Resolved incompatible JRE errors during upgradation.
• Configured .odbc.ini, dsenv, uvconfig, DSParams, uvodbc.config files and upgraded Branded ODBC/DataDirect Drivers.
• Configured parallel engine, database connectivity in parallel environment and access to ODBC sources.
• Started and stopped DataStage Engine, WebSphere Application Server and Information Server and managed logs.
• Raised PMRs wif IBM on upgradation problems, patches and fix packs
• Worked wif Administrator Client to manage projects and jobs.
• Worked wif Director Client to schedule, run and view the logs of jobs.
• Unlocked jobs. Set up Configuration Files, Job Parameters, Environment Variables and Data Connections across jobs in a project.

Environment: IBM InfoSphere Information Server V8.1.1 Suite DataStage & QualityStage,, Oracle 11g/10gR2, Netezza 3.x/4.x, WAS 6.0.2.27, Java, J2EE, SQL, PL/SQL, Autosys, Shell Scripts

Confidential, OH

BANKING WAREHOUSE MANAGEMENT SYSTEM BWMS

Responsibilities:

• Participated in meetings wif Business users and Subject Matter Experts (SMEs) to understand the business requirements.
• Installed, Configured and Administered DataStage, QualityStage, ProfileStage, Metadata Workbench, Business Glossary, FastTrack, IS Manager and Metadata Server of InfoSphere Information Server 8.1 suite in Pilot, Dev and Prod Phases.
• Installed, Configured and Administered Oracle 10gR2 Metadata Repository Database and WebSphere Application Server 6.0.2.27.
• Unlocked jobs. Set up Configuration Files, Job Parameters, Environment Variables and Data Connections across jobs in a project.
• Involved in DataStage security - assigned IIS suite and suite component roles in IIS Web Console.
• Worked wif Information Analyzer and QualityStages like character discrete, character concatenate, word investigate.to understand and cleanse metadata to build Data Model. Removed duplicates using match frequency, reference match & unduplicate match.
• Used FastTrack to automate multiple data integration tasks from analysis to code design and to integrate mappings and jobs into metadata repository.
• Used Business Glossary Anywhere to display the business definition of categories and terms wifout logging into IS web console and Business Glossary.
• Used Metadata Workbench to understand, analyze and explore the assets of business, technical and operational metadata and different metadata models.
• Performance tuning of DataStage jobs, IIS suite products and WAS.
• Stopped and Started Logging Agent, ASBAgent, DataStage Services & WAS and managed logs.
• Participated in application and infrastructure engineering review and security audit.
• Developed Common Error Management and Audit Management process at Project level.
• Enabled IIS and WAS Security and configured internal and external user registries.
• 24x7 DataStage ETL support and resolution of errors related to all IIS suite products.

Environment: IBM InfoSphere Information Server V8.1.1 Suite DataStage, QualityStage, ProfileStage/Information Analyzer, IS Manager Oracle 11g/10gR2, Teradata V2R7, DB2 9.5, SQL Server 2005, WAS 6.0.2.27, Java, J2EE, SQL, PL/SQL, Autosys, Shell Scripts, Windows XP, Unix (AIX 6.1/Solaris 10)

Confidential, IL

METADATA MANAGEMENT SYSTEM MMS

Responsibilities:

• Involved in migration of DataStage and QualityStage projects and jobs from earlier versions to 8.1 version.
• Participated in meetings wif Business users and Subject Matter Experts (SMEs) to understand the business requirements.
• Assessed the current environment and implementation standards.
• Held workshops and information gathering sessions to understand the current environment concerns and advise accordingly.
• Designed parallel and server jobs using different processing stages like Join, Funnel, Transformer, Surrogate Key Generator etc to load data from different data sources.
• Used Teradata Parallel Transporter TPT to load and unload the data using different operators.
• Worked on performance tuning of ETL jobs using SQL queries, data connections, configuration files, parameter sets and environment variables.
• Used Information Analyzer ProfileStage and QualityStage for Data profiling and Quality.
• Enabled operational metadata at project and job levels. Managed operational metadata from job runs.
• Documented steps for Upgradation, Configuration, Administration and Development of IIS suite tools.
• Used Autosys to schedule jobs and e-mailed the status of ETL jobs to operations team daily.
• Performed Root Cause Analysis RCA in production support for tickets in IBM ESR tool.
• Performed Knowledge Transfer KT to team members and lead the whole project in all the phases.
• Migrated DataStage and QualityStage jobs from earlier versions to DataStage 8.0 version.
• Worked on setting up users for IIS suite and suite components for different products.
• Used IIS Web Console for administration areas: security, licensing, logging, and scheduling.
• Created different type of reports like Administrative reports, IA Column Analysis reports, Metadata reports and Fast Track Mapping specification reports from IIS console.
• Used Investigate, Standardize, Match and Survive stages in WebSphere QualityStage to improve data quality.
• Designed server and parallel jobs for extracting, transforming, integrating, and loading data into data mart using DataStage Designer.
• Developed, executed, monitored and validated the ETL DataStage jobs in the DataStage designer and Director Components.
• Worked wif DataStage Director to schedule, monitor, analyze performance of individual stages and run DataStage jobs.
• Extensively used various Processing and debug/development stages to develop server and parallel jobs.
• Generated Surrogate Keys for composite attributes while loading the data into Data Warehouse using Key Management functions.
• Developed user defined Routines and Transformations for implementing Complex business logic.
• Developed Job Sequencer and batches and have edited the job control to have jobs run in sequence.
• Worked on performance tuning of ETL jobs via SQL queries, data connections, configuration files, job parameters and environment variables.
• Performed Knowledge Transfer KT to team members and lead the whole project in all the phases.
• Developed shell scripts to validate, automate and schedule DataStage jobs using UNIX shell scripting and Crontab Utility.
• Provided production support and resolved tickets in IBM ESR tool.

Environment: IBM WebSphere Information Server V8.0 Suite DataStage, QualityStage, ProfileStage/Information Analyzer} Oracle10gR2/9i, SQL Server 2005, DB2 9.1, Teradata V2R6, WAS 6.0.2.11, Java, J2EE, SQL, PL/SQL, XML

Confidential, IL

INDIRECT TAX DATA WAREHOUSE ITDW

Responsibilities:

• Involved in requirements gathering and source data analysis and identified business rules for data migration and for developing data warehouse.
• Issued DataStage engine commands from Administrator. Started and stopped DataStage engine and managed logs.
• Interacted wif business analysts and data modelers for better understanding of data and modified specifications to reflect accurate user needs.
• Created design documents and proto type jobs based on the business requirements and high level design (HLD).
• Used Lookup, Join, Funnel, Merge, Lookup, Transformer etc processing stages to design server, parallel and sequence jobs.
• Defined and documented the required data validation rules on the source feed files that were used in ETL.
• Designed and developed all subject modules using DataStage engine. Applied validation rules, constraints using DataStage variables and transformations.
• Created shared containers and multi instance jobs to enhance the performance by using more modular components.
• Customized UNIX scripts as required for preprocessing steps and to validate input and output data elements, along wif DataStage routines.
• Created source to target mapping and job design documents from staging area to Data Warehouse.
• Developed job sequences wif restart ability, check points and implemented proper failure actions.
• Created Unit test plan documents and executed the same successfully.
• Created documentation for supporting the deployment of the code into production.
• Developed ETL scripts to extract and cleanse data from SQL databases for loading into data warehouse.
• 24x7 production support of DataStage ETL tool.

Environment: Ascential DataStage 7.5.3 EE Parallel Extender, MetaStage, Teradata V2R5, Autosys, Teradata SQL, XML, Shell Scripts, UNIX (AIX 5.1/ HP-UX 11) and Windows 2003.

Confidential, CA

RETAIL INFORMATION WAREHOUSE APPLICATION RIWA

Responsibilities:

• Used DataStage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Responsible for building and loading dimension tables and fact tables for the target warehouse system.
• Used DataStage Designer/Manager/Director to design and run jobs to implement the Import and Export Interfaces.
• Extensively used DataStage Designer components to design various Server and Parallel jobs in accordance wif business specs.
• Imported table definitions from ODBC/Plug-in table definitions available.
• Used Partition methods and collecting methods for implementing parallel processing.
• Monitored the performance of Parallel jobs by turning on various environment variables.
• Used Job Control routines and Transform functions in the process of designing the job.
• Developed jobs in Parallel Extender using different stages like Transformer, aggregator, lookup, source dataset, external filter, row generator, and column generator.
• Validated and debugged the developed jobs.
• Used Teradata Utilities to manage queries and import/export data.
• Created user defined objects to support data cleansing and data scrubbing concepts in business objects.
• Worked as SME and maintained support matrix and resolved tickets in production support activities.
• Requirement analysis/documentation, developing functional and technical specifications, DW and ETL designing, developing detailed mapping specifications and scheduling charts.
• Closely working wif the end business users to comprehend their requirements in order to design and develop interactive reports that meet business expectations.
• Identify opportunities for improvements to policies, procedures and systems.
• Comprehended and converted critical business requirements into technical functionalities for the ETL and Reporting teams.
• Provided integration and post production support for the ETL and reporting systems.
• Expert usage of Oracle utilities and applications like SQL*Loader, External Tables, export / import etc.