SUMMARY

• Around 10 years of experience in business analysis, development and implementation of applications using Data Warehousing, OLAP and BI Analytics, Application Design & Architecture, Data Modeling, Database Development on various Data warehouse and Client Server systems.
• Extensive experience working over 10 years in end to end Data Warehousing, Data Migration projects and Business Intelligence tools including IBM Infosphere Information Server, DataStage 7.5/8.1 Server and Parallel Extender, Sunopsis V3/ODI, Crystal Reports XI, Informatica v7.1/8.6, SSIS, SSRS, SSAS, DTS, BOXI, Knowledge of Microstrategy. Worked on Oracle Form 6i/9i and Reports 6i,9i.
• Extensive experience over 8 years in Data Modeling using tools including ER/Studio 8.5.3, Erwin (Conceptual, logical and physical Modeling). Strong understanding of Dimensional Modeling - Star schema modeling, Snowflake modeling in multiple data warehousing and business intelligence projects. Strong understanding of Data warehouse concepts. Have worked on ER modeling for OLTP systems as well. Have worked on databases including Oracle 11g, 10g, 9i, SQL Server Version 2000/2005, DB2 Version 8.2, some hands on Teradata. Some hands on experience on IBM system Architect.
• Proficient in Database Development with over 9 years of expertise in PL/SQL programming in Oracle 11g,10g,9i, coding XML, XML Queries, XML Tables, PL/SQL tables, GTT, External Tables, IOT, procedures/packages, objects, triggers materialized views, views, working with large amounts of data including Teradata, state of art in built packages. Have worked on databases including Oracle 11g,10g,9i, SQL Server Version 2000/2005, DB2 Version 8.2, some hands on Teradata.
• Have experience in Data profiling and data quality analysis for various heterogeneous source and target systems, identify facts, dimensions, quality of data, understand the requirements and provide mapping, impact analysis, audit reports of the data. Knowledge on Quality stage. Knowledge on Quality stage. Independently performed Data quality analysis for some of the projects.
• Experience in various domains namely Oil and Gas, Insurance, Banking and Finance, Airline, Retail, Energy and Manufacturing.
• Proficient in data warehouse performance tuning. Tuning of ETL jobs design and strategize efficient error handling. Proficient is features namely parallelism, Web sphere MQ stages, Bulk Loads. Worked on heterogeneous source and target types namely CRM -SAP/SFDC, databases (Oracle/SQL Server/DB2), Files (CSV, XLS, Delimited, Mainframe VSAM), XML.
• Highly Proficient in Design, optimize and performance tuning of database applications. Worked extensively on database development, DB tuning like index optimization, partition management, hints, statistics, explain plan, SQL Loader, SQL*Trace, TKPROF, GTT, dynamic SQL,, clusters.
• Performed DBA related activities like Installed Oracle 8i/9i/10g database, Export and Import utilities, created tablespaces, datafiles, Users, and Profiles, database tuning. Good knowledge on Oracle architecture, Data Dictionary views (V$ views, DBA xx views etc.).
• Experience in providing project plans and estimations, project metrics, code reviews and mentoring of team members.
• Experience in gathering business requirements, working closely with the clients, users, business team in identifying their needs and challenges. Translating them to technical specifications, Use Cases, UML, data flow diagrams, data mapping documents independently. Provide support to the technical team to understand and resolve queries in the specification; provide mapping and database needs to the team. Conducted several Requirement Gathering Sessions (RGS) for gaining detailed requirements and finalizing Business Requirement Document (BRD) and resolving issues related to data quality, mapping.
• Testing of ETL and PL/SQL jobs, scripts and integration testing. Documenting High level, Low level design documents, unit test cases, Metrics Reports, Audit Reports, ETL mapping documents, test cases, elevating code to UAT, Production. Provide Production support.
• Extensively written Unix Shell Scripts and Batch Scripts for the automation of various ETL jobs.
• Played variety of roles namely Technical Lead, Module Lead, ETL Architect/Developer, Data Architect/Database Developer/Data Modeler, Business/Data Analyst. Also have exposure to playing Client facing roles in various projects.
• Involved extensively in organizational activities like conducting technical training, participating in submitting technical papers.
• Strong analytical, presentation, problem solving and excellent inter-personal skills.

TECHNICAL SKILLS

Languages: PL/SQL Programming, UNIX scripting, Knowledge of C, C++, Java, .NET., XML

Databases: Oracle versions 8i,9i,10g and 11g, SQL Server 2000/2005, DB2 7.2, 8.2

Data Modeling Tools: ERstudio, Erwin 3.5.2

ETL Tools: Datastage 8.1/7.5, Informatica 7.1/8.0, Sunopsis V3/ODI, SCRIBE, SSIS

Reporting Tools: Crystal Reports XI, BOXI, SSRS

Documentation: Microsoft Office Tools, IBM Rational Rose.

User interfaces: TOAD, PL/SQL Developer, Forms (6i, 9i), Reports (6i, 9i) D2K

Operating Systems: Windows 98/XP/NT/2000/Vista, UNIX, LINUX

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Data Architect

Environment: Datastage 8.1 Erwin, TOAD, Oracle 11g, Liferay Java, JSP, XML, EDI, JSON, PL/SQL Developer, UNIX, Tortoise SVN

Responsibilities:

• Involved in different SDLC phases including, Gathering and analyzing business requirements, technical feasibility studies, Work break Down Structures and High Level Estimates, Technical Design Documents.
• Design/Modify/Review the existing data model objects for the RRST/VHOS projects using Erwin. Involve in the complete SDLC lifecycle for this project from Requirements gathering to post production support.
• Design and Develop Complex database objects, packages, views using PL/SQL programming for Phase 1 and Phase 2 for VHOS system - ERCOT market.
• Provided architecture and design for the system Data Conversion Project. Used state of art features XMLQUERY, XMLTABLES, GTT, IOT, used oops concepts using object types using PL/SQL, Reading, generating and parsing XML’s.
• Design and provide strategies for the functional requirements on the ETL and PL/SQL conmponents.
• Deploy existing code for the New York System. Develop packages as per the enhancements required for the existing New York Market system.
• Performance tuning of the existing PJM, New York systems.
• Provide production support on the existing system for the PJM, New York Markets.
• Gather requirements for the RRST projects meeting with the business analysts and business users.
• Developed ETL jobs for the data conversion project.
• Develop UNIX shell scripts as and when required for scheduling.

Confidential, Houston, TX

Data Architect

Environment: ERSTUDIO, TOAD, Oracle 11g, BPM PEGA, Datastage 8.1

Responsibilities:

• Independently lead the design, review and complete of the conceptual, logical and physical data models for the entire system of over 1300 tables using ERSTUDIO.
• Source System Analysis of the existing V5 system, identify the data quality issues. Provide Audit reports.
• Understand the requirements and translate them to mapping documents, data flow diagrams and data models.
• Perform and Review Data cleansing and Data profiling activities.
• Involved in the design and documentation of the Naming standards, Develop Data Flow Diagrams, ETL Design Documents, Error Handling Documents.
• Provide architectural strategies for the entire Project. Involve in the technical and architectural discussions with Users, Lead architects, Business Analysts and ETL teams.
• Document the Logical and Physical Architecture for the project and specific to the ETL design. Provided strategy related to data cleansing, data quality and data consolidation
• Prepare a plan and metrics for the Data Architecture (Modeling, Design, and Analysis) and Data Migration of the Project.
• Assign tasks to offshore and onsite team members. Assist and Review the data model, mapping documents independently.
• Provide support to the technical team to understand and resolve issues/queries regarding the technical aspects of the project;
• Involved in Design and Architecture of the of ETL design strategies such as Jobs Design, Error Handling Strategies, Scheduling and Maintenance. Develop ETL jobs using Datastage.
• Conducted several Requirement Gathering Sessions (RGS) for gaining detailed requirements and finalizing Business Requirement Document (BRD) in understanding the requirements and also resolving issues related to data quality.
• Working closely with the, users, business team in identifying their needs, challenges and understanding the existing system. Review and lead team members to translate the Use Cases, UML to data flow diagrams.

Confidential, Houston, TX

Senior Developer

Environment: Datastage Version 8.1, Oracle 11g, SQL Server 2008, SSIS, SSAS, SSRS, PL/SQL, Embarcadero ERStudio, TOAD, PL/SQL Developer, Tidal Enterprise Scheduler

Responsibilities:

• Design/Modify logical and physical data models for the system using ERStudio.
• Involved in the Data Quality Analysis of the existing Blue cherry and Blue Martini source systems.
• Involved in design, development and testing of complex ETL jobs, sequences, scheduling of the jobs. Used various stages and features like hash files, CDC, XML, OCI,,ODBC, SCD, Container, File Stages, Web sphere MQ stages, Configuration Files, Environment variables for tuning and configuration. Parameter sets, Built routines PX and Server.
• Provided support for existing ETL jobs, DB objects, change management, production elevation, review of code developed by team members.
• Performance tuning of ETL jobs, Database, SQL queries.
• Involved in developing complex PL/SQL procedures, packages using dynamic queries, bulk loads, optimizer hints, bind variables, views, triggers, hash tables, external tables, IOT.
• Performance tuning of SQL queries, procedures, views, DB related activities like export/import, grants.
• Worked on development and support of ETL packages with different data sources and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Experience in different type of reports including Tabular forms, Matrix (Cross /tab Report) form, Conditional, Drill down, Top N, Summary, List items, Charts and Sub Reports.
• Assisted in production OLAP cubes, queries to produce reports using SSAS and SSRS.
• Coding UNIX shell scripts as and when required for ETL.

Confidential, TX

Data Architect/Senior Data Modeler

Environment: Datastage Version 8.1, Oracle 11g, PL/SQL, SQL Server 2008, SSIS, SSRS,SSAS, UNIX shell scripting, Embarcadero ERStudio, TOAD.

Responsibilities:

• Design/Modify logical and physical data models for the system using ERStudio.
• Worked on Data Dictionary, Naming Standards, Macros, and Reports on Models.
• Used to create reports, exports of metadata using macros and analyze the metadata.
• Work with the business team from IATA, Business Analysts to understand the requirements and translate them to mapping documents, data flow diagrams and data models.
• Created the ETL architecture and provided strategy related to data cleansing, data quality and data consolidation
• Interacted with the business users on regular basis to consolidate and analyze the requirements and present them the design results.
• Involved in design, development and testing of complex ETL jobs using DataStage for extract, transform and load.
• Performance tuning of ETL jobs, Database, SQL queries.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS).
• Created cubes and defined the dimensions and Responsible for defining calculated members.
• Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes for the Million Miler project.
• Performance tuning of SQL queries, procedures, views on Oracle for MOSAIC and SQL Server 2008. DB related activities like export/import, grants on Oracle.

Confidential

ETL Lead

Environment: Datastage Version 7.5.2, DB2 Version 8.2, UNIX shell scripting, Microsoft Office Tools, IBM Rational Rose.

Responsibilities:

• Involved in different SDLC phases including, Gathering and analyzing business requirements, technical feasibility studies, Work break Down Structures and High Level Estimates, Technical Design Documents.
• Have meeting with clients to understand requirements and effectively identify data needs and challenges
• Translate the requirements to Technical Specification documents.
• Provide estimations for the business requirements.
• Design, develop and test complex DataStage jobs for extract, transform and load
• Worked extensively on Datastage PX jobs tuning and building reusable components for the project.
• Was involved independently in developing the main master sequencer monthly and weekly sequence job which invoked the sequences to load data of all the 40 source systems.
• It incorporated complexities including error handling, restart ability, holiday checks. Code to perform Job Monitoring of Jobs running.
• Developed complex stored procedures and UNIX shell scripts independently.
• Testing and production support of the ETL jobs and scripts.
• Conduct code reviews/approvals, tracking the progress, provide metrics while I played a lead role.
• Mentoring team members.

Confidential, NJ

ETL Lead

Environment: Datastage Version 7.5.2, Oracle 11g/10g, BOXI, UNIX, Crystal Reports XI, SQL Developer, Control-M, TOAD, SCRIBE, Microsoft Office Tools, Erwin

Responsibilities:

• Analyzing and understanding business requirements.
• Support offshore team with the queries on the specifications.
• Provide project plan and Estimation for the requirements. Assign the tasks to the team. Involve in tracking the progress, review of the tasks(code/documents) to completion.
• Interacting with the Client for collecting the requirements and documenting the same.
• Design of the source to target mappings, ETL specifications, workflows and jobs schedules
• Data Modeling and Design of Minor End to End enhancements.
• Design, develop and review complex ETL jobs using Datastage.
• Design, develop and review complex PL/SQL Procedures to support the Reports, ETL jobs.
• UNIX Scripting like scheduling jobs using crontab.
• SQL and Database tuning. Provide production support for the existing ETL jobs under three different Business units, ensuring that load processes are completed and data is reconciled and correct.
• Independently involved in tracking the tasks to design, develop and release each code.
• Created different types of reports including Master/Detail, Cross Tab and Charts Crystal Reports XI.
• Prepare Metrics report for each member of the team to generate the effort and schedule variance.
• Developed jobs using SFDC as source using SCRIBE.
• Review code of team members. Mentor juniors in the team.
• Worked Onsite in the initial phase for analysis and knowledge transition.

Confidential

Offshore Lead

Environment: DB2 Version 7.2, SQL Server, Datastage Version 7.5, RUMBA, Microsoft Office Tools

Responsibilities:

• Requirements gathering for the project by constant Client Interactions and come up with a suitable design.
• Transform the requirements to Technical specifications.
• Support offshore team with the queries on the specifications.
• Independently provided the ETL design strategy for the data migration.
• Involved in providing the project plan, estimation, assign tasks, review of the code for the project. Documenting standard project design documents, ETL and database high and low level design documents, mapping documents, Project Plans and Metrics Reports for the team. Also created various re-usable standard templates which were used for various Mindtree DW projects namely Data Quality Template, Audit Reports.
• Involved in complete Design and Development of the Data Migration project.
• Data Modeling and database tuning for the project.
• Independently involved in the complete Data Quality Analysis of the existing system.
• Development of Complex Datastage Jobs.
• Worked on DTS during the analysis of the Source SRI system.
• Develop test plans and test cases and testing the ETL jobs/scripts developed.
• Performance Tuning of the ETL Jobs and database.
• Assign tasks to team members for post production support, tracking progress of the tasks and reporting the same. Review the code developed by team.
• Worked on Metadata to Generate Audit Reports.
• Worked Onsite in the initial phase for Requirement gathering, Business Analysis.

Confidential

ETL and Oracle Senior Developer

Environment: PL/SQL Programming, Oracle 10g, SUNOPSIS V3/ ODI, JDK 1.4, JBoss Version 4.0.0 RC1, Version Name: Zion, JBoss Eclipse IDE Version: 3.1.0, Client, Hibernate 2.1, Ant-contrib 0.6, Tomcat 4.1, EAP, Windows XP Professional, TOAD, Microsoft Office Tools, ERStudio

Responsibilities:

• Independently built the data model for the system.
• Independently involved in the Design and Development of VAT Engine driven by PL/SQL which is the heart of the application that handles the business logic - invoice generation, Tax calculation, Currency Conversions of the project.
• Tuning of SQL queries and database as when required.
• Independently involved in development of ETL jobs using Sunopsis V3/ODI.

Confidential

Developer

Environment: PL/SQL Programming, Informatica PowerCenter 7.1, Oracle 9i, Informatica PowerAnalyzer 4.1, Erwin 3.5.2, TOAD 7.6, Microsoft Office Tools

Responsibilities:

• Involved in Design and Development of the Allocation Engine done for the system using Oracle 9i, PL/SQL programming.
• Involved in building the data Model for the Allocation Engine.
• Database tuning and Development of PL-SQL procedures (Like the generic Matview refresh Layer, used to sequentially refresh all the matviews), views, functions and matviews.
• Involved in development of ETL jobs using Informatica PowerCenter 7.1.

Confidential

Developer

Environment: J2EE, EJB, Servlets, Java, JSP, JDBC, XML, TOAD, UML, Web logic platform 8.1, ORACLE 9i, Reports 9i, PL/SQL Programming.

Responsibilities:

• As a team member involved in coding backend PL/SQL programming (Packages, Views, Procedures, Functions).Development of reports using Oracle Reports 9i for the system.
• As a team member involved in Development of reports using Reports 9i
• As a team member involved in Development of Masters, Transactions for the system as per the specification using Forms 9i, PL/SQL Programming and Oracle 9i.
• Development of Reports for the system using Reports 9i and Oracle 9i.
• As a team member involved in Development of Masters, Transactions for the system as per the specification using Forms 6i, PL/SQL Programming and Oracle 8i.
• Development of Reports per the specification using Reports 6i and Oracle 8i.
• Career Information System (CIS) module takes care of Advertising, Recruitment and Interviews etc.
• Personal Information System (PIS) module holds the details of all the employees.
• Training Information System (TIS) module takes care of the Training programs that the company needs to conduct.
• As a team member involved in Development of Masters, Transactions for the system as per the specification using Forms 6i, PL/SQL Programming and Oracle 8i.
• Development of Reports for the system as per Reports 6i and Oracle 8i.