SUMMARY

• Almost 13 years of professional experience in IT Industry especially Client/Server architecture of Data warehousing.
• Worked extensively on analysis, design and development and administration of various applications using IBMInfoSphereDataStage 11.3.1/8.7.1/8.1.2/8.0.1/7.5. x/7.1.x/6.x,Informatica 9.5/9.1/8.5/8.1 , InformationAnalyzer, Quality Stage, IBM Infosphere CDC, Oracle11g/10g/9i/8i, DB2 9.2,DB2 - UDB9.2,SQL Server 2000/2003, Teradata.
• Expertise in all the phases of System development life Cycle (SDLC)
• Developed strategies for Data Cleansing & Migration from various operational sources into data warehouse & data marts and Data Conversion.
• Expertise of working with Pharmaceutical, Insurance, Banking, Retail, Finance and Health Care.
• Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Staging, Transformation, Preloading and Loading of data from multiple source Databases into Data Warehouse.
• Excellent knowledge and experience in data warehouse development life cycle, dimensional modeling, repository management and administration, implementation of Star & Snowflake Schemas, slowly changing dimensions and Change Data Capture.
• Analyzing the quality of data to determine its consistency and reliability, Documented detailed findings together with recommendations for standardization and reconstructions using IBM Quality Stage (integrity) System
• Used Data Stage Server, Parallel Extender Orchestrate/Enterprise Edition Environment for Job design, split the data into subsets and load data.
• Strong experience in implementing procedures for maintenance, monitoring, backup, and recovery operations for ETL environments (Datastage & Informatica) and experience in storage capacity planning for the projects.
• Utilized the available processors to achieve job performance, configuration management of system resources in Orchestrate environment
• Experienced in integration of various data sources SQL Server,Oracle,Sybase,DB2 and Teradata into Datastage and Informatica.
• Extensive working experience in Production support of different Applications
• Provided On call support to fix the Production issues on the fly to provide smooth running of Production Jobs.
• Expertise in performance tuning of the various ETL jobs & processes for better performance,
• Performed Unit testing, Volume testing and performance testing
• Experience delivering timely reports for decision making to implement EPM.
• Familiarity with OLAP reporting and business intelligence tools like Business Objects
• Experience in writing, testing and implementations of triggers, procedures and functions using PL/SQL.
• Worked as a team with good communication, interpersonal & analytical skills. Problem-solving and trouble shooting capabilities, Quick Learning, highly motivated and result oriented.

TECHNICAL SKILLS

ETL Tool: IBM Infosphere Datastage 11.3/8.7/8.1/7.5 x/7.0x/6.x, Information AnalyzerQuality Stage, Informatica9.5/8.6/8.1

Programming languages: COBOL, C, Java, Visual BASIC, SQL, PL/SQL, HTML, Java Script

DBMS: Oracle 11g, DB2-UDB 9.2, MS SQL Server 2005, MS Access 2003

Reporting Tools: Business Objects Crystal Reports 11

Modeling Languages & Tools: ERWIN 7.2/4.x/3.5,Clear Case 7.0, SQL Developer 3.2TOAD 9.0,Tivoli

Project Management Tools: Rational Rose, Rational Requisite ProOperating Systems Windows 2000/XP/7, UNIX RedHat Linux & AIX

PROFESSIONAL EXPERIENCE

Confidential, Charlotte North Carolina

Sr ETL/Datastage Administrator

Responsibilities:

• Worked on different projects containing total life cycle of Software Development Applications involving Research, Design, Analysis, Development and Testing using Data Stage (IBM Information Server), Informatica Power Center, Teradata, SQL Server, Oracle, asp.net,, Informatica, SAP, Business Objects, Cognos, Unix, Windows XP and J2EE (Java).
• Worked as a Lead Administrator proving Knowledge Transfer to other team mates and handled 100+ offshore Datastage/Informatica developers and resolving their access, design and other issues.
• Worked on the projects such as DS EDW2, DS EDW2 EXTRACTS, DS MRA, DS RMW PUIT, DS MDM, DS OPS CNTL, DS EDSVG APPS, DS ODS, DS EDW PRF, DS EDW2, DS EDW ST2, S RMW MRA.
• Worked on all the administrative activities such as Code Migrations, Access issues, Project Setup, Project Allocations, Space Issues, Connectivity Issues, Data Base Password Reset, User Requests, Performance Tuning of the Jobs, TNS Entries, Clearing Job Locks, Installations of software, Server Recycling and User Issues.
• Expert in providing Production Support and resolving issues pertaining to Job design and Environment.
• As an On call person fixed production issues for smooth run of Jobs thus meeting SLAs.
• Looked into User issues and resolved using Service Now Requests, Change Requests and Incident Requests.
• Attended the Admin meetings and User conducted meetings to resolve their issues and provide guidance on better performance of the Jobs and standard practices.
• Experience in upgrading ETL tool from Datastage 8.0.1 to Datastage 8.1.2 and currently into Datastage 11.3.1.
• Experience in upgrading the Informatica Power Center from 8.6.1 to 9.5.1
• Installed and configured Datastage 8.1 on a Linux operating system.
• Installed and configured the Grid tool kit and load leveler to support the Grid architecture.
• Installed patches, Fix packs, and other software tools related to fixing and debugging issues in Datastage
• Installed and configured Information Analyzer 8.0, and 8.1.
• Debugged issues in Information Analyzer and set up the required projects for profiling purposes.
• Established connections to various data sources for extracting and loading.
• Worked on automating the environment to stabilize and standardize it in order to reduce the time frame for simple activities like code promotion and project setup.
• Hands on experience with Informatica admin console and repository manger to perform daily Informatica admin tasks
• Performed Informatica Administrative activities such as Project/User creation, roles management and deployment activities, DB configuration setup, dataset management; apply fixes, patches and Service Packs as required.
• Created technical documentation for Installation, Configuration, Upgradation, Migration and Administration of all products on Informatica.
• Experience in migration of Informatica code between all repositories (Development,Test & Production) of projects using deployment groups and Scripts.
• Actively involved in Troubleshooting, Performance Tuning, Error handling, Product support on various Platforms in productions on Informatica and Datastage.
• Experience providing 24X7 on call production support and preparing procedures/documentation wherever required for both Informatica and Datastage.
• Debugged environment and code issues and documented the resolutions.
• Raised PMRs with IBM on Design, upgrade issues, long running Jobs, patches and fix packs.
• Helped developers to resolve all kinds of issues pertaining to Job design, Job performance, and Job abort.
• Configured parallel engine, database connectivity in parallel environment.
• Established Database connections such as Oracle, Teradata and SQL Server on Datastage for successful connectivity.
• Worked on code and Script move from one environment to another and from one Datastage version to another version.
• Monitored the Jobs in production for any issues and ran the Jobs through server using a script.
• Worked on Change Requests to move code into Production environments.
• Worked on Disaster Recovery set up and synced the code with Production to be used as backup in case of any production disasters.
• Provided access to developers into all Datastage environments including Production.
• Mentored new Datastage administrators by providing Knowledge Transfer upon Manager’s request.
• Strictly implemented TIAA policies without any favor to anyone.
• Extended support to all teammates by sharing the knowledge.
• Managed Users, Groups, active sessions, logs, schedules and licenses in IIS Web Console and Informatica Power Center Admin Console.

Environment: IBMInfosphere DataStage 11.3.1/8.1.2/8.0.1 , Informatica 9.5.1/8.6.1 , InformationAnalyzer,IBM Infosphere Metadata Workbench, IBM Infosphere FastTrack, Oracle11g, SQL Server2005, Teradata V6, WS FTP, Win SCP, Borland StarTeam (Version Control), AIX6.1, Websphere7.0 and Autosys, Windows XP/7, Service Now, Linux/Unix, Microsoft Office 2010, MQ Series, Serena & Artifactory.

Confidential, Kansas City, Missouri

Sr. Software Engineer/Administrator

Responsibilities:

• During my tenure with BCBSKC, I was involved in designing technical specification documents for different interfaces and participated in administrator activities..
• Performed ETL processes using Datastage and Informatica tools, used stage variables for source validations, capturing rejects and used Job Parameters for Automation of jobs.
• Used Lookup, Join, Funnel, Merge, Lookup, Transformer processing stages to design server, parallel and sequence jobs.
• Also involved in developing User Defined Variable script for adding the variables into the administrator for using default values in the Job to connect to Databases etc.
• Supported Operations team during production implementation and for different production issues.
• Migrated and Deployed ETL code between the repositories using Deployment groups and creating the Relational and Application Connections based on the Requirements based on tickets from HP service manager.
• Coordinating with offshore teams on daily activities and assigning them tasks.
• Worked on Business Objects and Cognos to generate the reports needed for the users, used Unix shell script to kick off the jobs,
• Worked on Databases such as Oracle, SQL Server and Teradata using them as source and target Databases.
• Also used software tools such as asp.net, java/J2EE and SAP to achieve desired output. The operating system worked on was Windows XP apart from Unix which were used exclusively.
• Projects worked included Marketing Enrollment Extract with further bifurcation into Gill Studios, Zywave, Script Save, University Of Michigan Extracts and Lockton.
• Performed administrative activities that included adding and updating user defined variables, aborting long running Jobs from Director Client and Unix Server.
• Used Datastage Designer to design the jobs, Director to run and monitor the jobs and Administrator to clear job locks and add users.
• Worked as team player by actively completing all assigned tasks with in the given time line.
• Backed up and restored Infosphere Information Server suite.
• Configured NLS to support character maps and locales.
• Managed ASB Agent, Logging Agent, DSRPC, Telnet and Engine Resource services.
• Involved in migration of Datastage and Quality Stage projects and jobs from earlier versions to 8.0 version.
• Added, deleted and moved projects and jobs. Purged job log files and traced server activity.
• Issued Datastage engine commands from Administrator. Started and stopped Datastage engine and managed logs.
• Created different type of reports like Administrative reports, IA Column Analysis reports, Metadata reports and Fast Track Mapping specification reports from IIS console.
• Involved in requirements gathering and source data analysis and identified business rules for data migration and for developing data warehouse.
• Defined and documented the required data validation rules on the source feed files that were used in ETL.
• Ran job sequences with restart ability, check points and implemented proper failure actions.
• Responsible for building and loading dimension tables and fact tables for the target warehouse system.
• 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 using different stages like Transformer, aggregator, lookup, source dataset, external filter, row generator, and column generator.
• Validated and debugged the developed jobs.

Environment: IBMInfoSphereDataStage 7.5.1/8.0.1 , Informatica8.1.0,DB2,Oracle10g,SQLServer2005,Unix, Java/J2EE, Information Analyzer, Teradata, WS FTP, Win SCP, Autosys, Windows XP & Microsoft Office.

Confidential, Detroit, Michigan

Sr Datastage Developer

Responsibilities:

• Performed various duties which included Analysis, Research, Designing and developing and testing of the ETL jobs, generating the reports with the help of Business Objects and Cognos.
• Created Unix shell scripts to perform different validations and run jobs on different instances such as development and testing environments.
• The Projects worked included On star project which needed the syncing up of ReDs database with On star database and other databases too.
• Created source and target databases using Teradata, Oracle and SQL Server, designing jobs using ETL tools such as Datastage and Informatica using the operating system Windows XP and Unix.
• Performed debugging, unit testing of jobs and created migration of jobs from one environment to the other. Also used Java in coding the ETL jobs and SAP as source validations.

Environment: IBM InfoSphere DataStage7.5, UNIX, WindowsXP, Oracle, SQL Server, Teradata

Confidential, Corning, NY

Sr Datastage Developer

Responsibilities:

• Implemented ETL Datastage for People Soft EPM 8.9 data mart deployments by delivering the jobs and build custom jobs according to the user requirements,
• Developed several Datastage jobs to improve performance by reducing run time using different partitioning techniques, performing ETL Datastage processes from OWS to MDW Data warehouse.
• Designed and developed Datastage jobs for loading data into star schema.
• Involved in development of Common Error Management process at Project level, performed testing, debugging of the jobs and migrating different projects into different environments.
• The project work was concerned to the Datastage jobs being customized in accordance with PeopleSoft jobs.
• Worked on the Windows and Unix Operating Systems and used all the technologies including Java, Cognos/Business Objects for reports, SAP, Informatica, asp.net, Oracle, SQL Server and Teradata.

Environment: Datastage EPM 8.9, DB2-UDB9.2, Oracle 9i, Teradata, SQL Server2005, AIX, Websphere, Java, SAP

Confidential, Richmond, Virginia

Sr Software Engineer

Responsibilities:

• Job duties performed were unlimited ranging from developing Technical Design specification documents, developing several Server and Parallel jobs to improve performance by reducing run time using different partitioning techniques.
• Performed ETL processes using IBM Web sphere Datastage 7.1 Version, using stage variables for source validations, capturing rejects and job parameters for automation of jobs,
• Developed the ETL jobs and combined all the jobs into one single job to send it to Frictionless database,
• Created Unix Korn Shell scripts to perform validations, run jobs on different instances and kick off the Datastage jobs.
• Used ETL Time stamp job to have a single time for all the jobs when the job runs from day 2 to day 11 every month or as and when required.
• Performed unit testing of all monitoring jobs and data manually to see whether the data is matched, if matched send it to the Frictionless database otherwise reject the data.
• Project worked was Spend Analysis and purpose was to evaluate the expenditure met by the company toward its vendors. The Source Database was SAP/R3 BW and target Database was Oracle, Teradata and SQL Server, the data to monitor was that of the Account Payee Info, Purchase Order Info and pCard Info.
• The above obtained info has to be output to the Zycus tool which does the UNSPSC classification and then from Datastage sent to the Frictionless database for final monitoring of data.

Environment: DataStage7.1, DB2-UDB, Oracle8, SQL Server2000, Teradata, Java, WindowsXP

Confidential, Dallas, Texas

Software Engineer

Responsibilities:

• The priority of the Job duties here were mainly on the health insurance related to Claims, Premiums, Capitation, and Billing apart from other activities using ETL tools such as Datastage and Informatica which has got clients like Designer, Manager, Director and Administrator.
• With the help of Designer developed jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Using the Manager imported metadata into repository and used Manager Client for importing and exporting jobs into different projects and environments.
• Used Director to schedule, validate, run and monitor the jobs.
• Used different technologies such as SAP, Java, asp.net and reporting tools such as Business Objects and Cognos.
• Also used Databases such as Oracle, SQL Server and Teradata for source and target validations.
• Purpose of this project was to load Capitation data into Financial Data Store (FDS) and General Ledger by tagging appropriate accounting attributes based on business driven configurations.
• The target for this project was Oracle Applications (General Ledger, Accounts Receivables, and Accounts Payable). Sources were provided in different formats database extracts, multilevel files and sequential files.
• Data was integrated from several systems like Claims, Premiums, Capitation, Billing, etc.

Environment: DataStage7.0, WindowsXP, UNIX, Oracle, DB2, SQL Server, Unix, Java

Confidential, West Point, PA

Sr ETL Developer

Responsibilities:

• As a Sr ETL Developer I was assigned the tasks which were related to the pharmaceutical sale figures and the inventory of the medicines by Developing Datastage server jobs to Extract, Load and Transform data by retrieving the same from source Database which was SQL Server through Datastage from heterogeneous systems to Oracle Database.
• The performances of the jobs were improved through the use of IPC, Link Partitioner and Link Collector Stages.
• For reusability of the jobs used Shared Containers for several projects.
• Different tools were used to achieve this objective which included Datastage, SAP, Cognos, Business Objects, UNIX, Java, asp, Windows and Unix.

Environment: Ascential DataStage6.x, SAP, Cognos, UNIX, Business Objects, Java, ASP

Confidential, Little Rock, AR

ETL Datastage Engineer

Responsibilities:

• The project involved was to build a data warehouse, by consolidating the company's data from different operational sources and then Extract, Transform and Load the data into a centralized data warehouse for various strategic business purposes.
• This was achieved using the ETL tool Datastage by scheduling data loading and transformations from legacy systems to Data Warehouse,
• Used Shell scripts to automate file manipulation and data loading procedures, designing the mappings between sources (external files and databases) to operational staging target databases,
• Used Parallel Extender for Partition Parallelism, the same job would effectively run simultaneously by several processing nodes, each handling separate subset of total data.

Environment: Ascential Datastage6.x, WindowsXP, UNIX, Oracle, Java

Confidential, Dallas Texas

Datastage Developer

Responsibilities:

• Being a Developer, the job responsibilities were confined to design and development of mappings between sources which was Sql Server and operational staging targets which was Oracle.
• Used Star and Snow Flake Schemas and involved in Extracting, cleansing, Transforming, integrating and loading data into Data Warehouse using Datastage Designer.
• Developed various transformations based on customer last name, zip code for internal business analytical purposes.
• Loaded data into Data warehouse based on customer credit card number with dynamic data re-partitioning,
• Developed Shell scripts to automate file manipulation and data loading procedures,
• Developed and maintained programs for scheduling data loading and transformations using Datastage.

Environment: DataStage6.x, UNIX, WindowsXP, Java, Oracle, DB2, SQL Server