SUMMARY

• Over 7 plus years of experience in design, modeling, analysis, development, testing and implementation of data warehouse/data mart applications, web applications and client/server applications on windows and unix platforms.
• Extensive experience in using the data - warehousing tool, Data Stage 9.1/8.1/8.5/7.5. x (manager, designer, director and administrator) extensive experience with Data Stage parallel extender.
• Expert in requirement gathering, analysis and Data cleansing using Quality Stage(Investigate, Standardize, Cross Column Analysis)
• Knowledge of all phases in software development life cycle (sdlc).
• Extensively worked on parallel and server jobs using various stages like join, lookup, lookup file set, change capture, filter, funnel, copy, column generator, peek, dataset, sequential file, oracle enterprise, DB2/UDB, merge, transformer, aggregator, remove duplicates stages.
• Excellent knowledge in extraction, cleansing and modification of data from/to various data sources, flat files and comma delimited files (.csv).
• Strong knowledge in OLTP/OLAP systems, normalized (OLTP), denormalized (DW and ODS) models, dimensional strategies, surrogate key, star schema, snowflake schema.
• Good knowledge of dimensional modeling (star and snowflake schema) for data warehouses and data marts.
• Experience in integration of various data sources like DB2, Oracle into staging area.
• Used stage variables, constraints in datastage jobs.
• Efficient in all phases of the development life cycle, coherent with data cleansing, data conversion, performance tuning and system testing.
• Good working knowledge in UNIX environment, java script, HTML and Agile methodology.
• Having good knowledge on cognos reporting tool.
• Etl code migration & testing etl project’s (around 5000 ETL jobs) from ds 8.5 to new ds 9.1
• Knowledge transfer, mentor & training to existing/new team members 24 /7 rotational on call production support of etl projects.
• Strong analytical and technical exposure working effectively as a team member.
• Excellent written and communication skills and ability to work independently in a time sensitive environment.

TECHNICAL SKILLS

ETL Tools: IBM Web Sphere Data Stage 9.1/8.5/8.1 / 7. x/6(Manager, Designer, DirectorAdministrator), Kettle

Data Modeling: Erwin 4.1/3.5, Designer2000 and MS Visio

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

Web Development: Java Script, XML, HTML and DHTML

Application Servers: IBM Web sphere Application Server 5.0/4.0/3.5

Operating Systems: UNIX, AIX, Windows 2000/XP/2003 and Linux

Database Tools: SQL Plus, SQL Server Management Studio, and TOAD, PL/SQL

Databases: DB2 9.x/8.x/7.1, Oracle 10g/9i/8i, SQL Server 2005/08/12,Teradata

PROFESSIONAL EXPERIENCE

Confidential, Atlanta

ETL Developer

Environment: Data Stage 8.5/9.1, SAP, SQL Server 2008, Toad11, WinSCP5.0, Windows Task Scheduler, SharePoint

Responsibilities:

• Understanding the Technical specifications and Mapping techs provided by the Client
• Creating and maintaining tables and updating them according to the changes requested by the business in the data to SQL Server.
• Closely working with the business analyst to understand the specifications
• Used IBM Quality Stage 9.1 for data cleansing and validating it before sending it to Developers.
• Implemented CDC stage for Type 2 dimensions and Fact for multiple projects.
• Creating Store procedures and kicking off them using Data Stage jobs and also implementing Store procedures into Data Stage jobs.
• Running the Curl PostScript to move the data from Data stage Server to Client Database.
• Sending the XML zipped load files through FTP
• Designing the jobs and building the sequence jobs to schedule the daily loads
• Writing Script for UAT testing and documenting in Unit Test report
• Using secure FTP to send /receive file other applications
• Automate the process in Production using Store Procedures for reusable codes and FTP stage
• Exporting and importing the jobs from Development to Prod environment
• Using the Execute command stage to back up the files once processed
• Checking IN and OUT of Data stage code in Serena change man version control manager (PVCSDB).
• Requesting the change request for moving the code into production along with implementation guidelines
• Installing IBM Data stage 8.5/9.1 on machines and creating the parameters, DSN, Migrating code and unit testing.
• Used IBM Infosphere Connector Migration tool to convert SQL server Database stage to ODBC Stage.

Confidential, Atlanta

Programmer/Analyst

Environment: Datastage8.0.1, SAP, MM, FICO, Oracle11g, Toad11, FileZilla, WinSCP5.0, UNIX, SharePoint

Responsibilities:

• Understanding the Technical specifications and Mapping techs provided by the Client
• Participated in all phases including Requirement Analysis, Design, Testing Support and Documentation.
• Developed more than 50 XREF tables and updated them according to the changes requested by the business in the data to Oracle Database.
• Closely working with the business analyst and functional team to understand the specifications and helping them in SAP load program (LSMW).
• Invoked shell script to handle the loads into SAP by splitting the file to required number of records.
• Involved in dividing the assignments to the offshore team and giving 24/7 support to meet the deadlines of the tasks and taking the status updates daily from the team to report onshore manager.
• Experience in interacting with business users to understand the requirements, problems and ability to resolve issues as early as possible.
• Played a key role and Involved in solving the issues within the team.
• Actively involved in developing the parallel jobs and server jobs depending upon the requirement.
• Extensively worked on various stages like Transformer, Filter, Sequential file, Join, Lookup, Sort, Aggregator, Copy, Dataset, Merge, Oracle, Remove duplicates stages
• Extensively used the various Partitioning Methods like Hash, Entire, Auto, Same, Round Robin to increase the job performance.
• Worked on server jobs for moving the data from the legacy system Tax ware to Vertex.
• Exported and imported the project from development to QA.
• Interacting with the DSADMIN to resolve the issues with Data stage Client.
• Performing the administrative work to unlock the job, kill the PID, installing the patches on DS client.
• Analyzing the jobs developed by the team and guiding them to improve the performance of the jobs.

Confidential, Atlanta

Data stage Developer

Environment: Data stage 8.0.1, Oracle 9i, and windows 2000, IBM AIX, Autosys

Responsibilities:

• Understanding the Technical specifications and Mapping techs provided by the Client
• Participated in all phases including Requirement Analysis, Design, Testing Support and Documentation.
• Work closely with users, business analysts, systems analysts, and application developers to define and resolve information requirements, data flow and data content/quality issues
• Transform business requirements into environment specific rule-set and data validation designs
• Design and develop ETL jobs, scheduling and monitoring consistently across the project.
• Performed Import and Export of Data Stage components and table definitions
• Provided technical solutions for the Process requests raised by Data team to fix the issues in the existing system.
• Designed the mappings between sources (external files and databases) to operational staging targets.
• Used the Data Stage Designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Worked on extensively on migration from 7.5.2 to 8.1.0 version of IBM Info Server(enterprise data stage).
• Extensively worked on various stages like ODBC, Transformer, Filter, Sequential file, Join, Lookup, Lookup file set, Sort, Aggregator, Copy, Dataset, Merge, Oracle, Remove duplicates stages.
• Extensively used the various Partitioning Methods like Hash, Entire, Auto, Same, Round Robin to increase the job performance. .
• Provide staging solutions for Data Validation techniques and Cleansing applications for different source systems.
• Designed, developed and Unit tested using Data Stage for Extraction, Transformation and Loading of data from source to target.
• Expert in unit testing, integration testing, implementation, maintenance and performance tuning.

Confidential, Warren NJ

Data Stage Developer

Environment: Data Stage 7.5.2, PL/SQL, and Oracle9i

Responsibilities:

• Understand the Technical specifications and Mapping Data Items from Source System to the Target System.
• Used the Data Stage Designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Created various local containers and shared containers.
• Developed jobs using various stages-Transformer Stage, column generator Stage, Filter Stage and Sequential File Stage.
• Designed and developed jobs using Parallel Extender for splitting bulk data in to subsets and to dynamically distribute to all available nodes to achieve best job performance.
• Used Data Stage Designer to extract, cleanse, transform, integrate, and load data into the data mart.
• Developed Data Stage Parallel jobs and Shared Containers using Lookup, JOIN, Copy, Change Capture, Aggregator, Column Export, Column Import, Remove Duplicates, Dataset, Transformer, Lookup File Set, Filter, and Funnel Stages.
• Extensively used the various Partitioning Methods like Hash, Entire, Auto, Same, Round Robin to increase the job performance.

Confidential, Chicago, IL

ETL Developer

Environment: Ascential Data Stage 7.5.1, DB2, Teradata, Windows 2000, IBM AIX 5.2, Autosys 4.0

Responsibilities:

• Involved in requirement gathering and analysis to define business and functional specifications.
• Created, optimized, reviewed and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs
• Involved in data modeling. Worked closely with data modeler and database architect during the design and development of ETL technical specification document
• Developed Data Stage jobs for extraction transformation and loading of the data from source systems
• Loaded data into Teradata using Datastage, FastLoad, BTEQ, FastExport, MultiLoad
• Extensively used Sequential File stage, DB2 UDB Stage, and Aggregator Stage during ETL development
• Loaded the Collateral source system to CDS using Datastage, SQL, Teradata Utilities, Un
• Analyzed business requirements; Performed SQL optimization
• Used Data stage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouse database.
• Performed Import and Export of Data Stage components and table definitions
• Used Data Stage Director to monitor the Jobs performed, automation of sequence execution.
• Designed and created reusable components like Shared Containers
• Created and used views in Oracle to simplify the mappings and make them easier to maintain.
• Involved in Production Support to resolve production issues in a timely and efficient manner.

Confidential

Java Developer

Environment: Java, J2EE 1.3, Tomcat, JDBC, XML, Java Script, HTML, CSS, UNIX, Eclipse

Responsibilities:

• Designed and developed JSP, Servlet, HTML and java Script.
• Developed front end web pages using HTML, DHTML, JSP, JavaScript.
• Configured and tested Web application on local Tomcat.
• Used Apache to parse/process XML files.
• Involved in the front-end design using HTML and JavaScript.
• Developed various SQL queries and used stored procedures for updating and searching the database which is residing in UNIX OS.
• Developed UI screens using Swing components like JLabel, JTable, JScrollPane, JButtons, JTextFields, etc.
• Participated in requirement analysis and designed case diagrams using UML.
• Involved in System and Unit Level Testing with Excel.
• Developed the logic for implementing Property Search Module of this project.
• Completely involved in Production support from client requirements to developmental aspects with coding, system optimization and testing.