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.

Professional Experience

Confidential

• Worked extensively on end to end Data warehouse and OLTP projects in varied roles and technologies for esteemed clients as below:
• Project:VHOS PJM,NewYork,ERCOT , RRST Client: Reliant Energy - NRG Company, Houston, TX Role: 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

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.

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

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

• To extend and implement a common database repository EDW that will store the entire bank's information. Both development and production environments will be upgraded with the latest version of tools.
• To Migrate historical data from existing Oracle DWH to DB2 EDW. The one-time history load will include 3 calendar years of financial data.
• Create interfaces, where do not exist, to re-direct the source data feeds from DWH to EDW based on the frequencies.
• Create extracts from EDW tables for loading the external downstream systems.

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

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

Responsibilities:

The project to be obtained was testing the SAP BW Version 7 tool in comparison with Other ETL tools. Testing the SAP BW for typical DW scenarios in various domains and various functionalities. Was involved in the project to gather requirements from the client with constant client interactions and present to them an innovative solution and approach to their requirements. Trained in SAP BW and worked hands on developing and testing jobs for various challenging DW scenarios. Won the project for Mindtree.

Confidential

Role: Offshore Lead Environment

Description: This Project involves the Data Migration of the existing Reinsurance Systems SRI and RDPS into the new eTreaty system. The eTreaty system will be a new treaty reference application intended to replace and expand the functionality of the existing SRI, Treaty Search, and RDPS treaty databases and related applications. Data Migration involves validating the correctness of the existing data and a one time, complete migration of the existing Data in the two systems SRI in SQL Server and RDPS VSAM Extracts into the target eTreaty systems DB2 Version 7.2 . It involves complex Datastage jobs to migrate the existing data to the new system. This system migrates the data and provides a detailed AUDIT Report with successful and rejected records and their counts during migration.

Responsibilities:

• Independently provided the ETL design strategy for the data migration.
• Support offshore team with the queries on the specifications.
• Transform the requirements to Technical specifications.
• Requirements gathering for the project by constant Client Interactions and come up with a suitable design.
• Development of Complex Datastage Jobs.
• Independently involved in the complete Data Quality Analysis of the existing system.
• Data Modeling and database tuning for the project.
• Involved in complete Design and Development of the Data Migration project.
• 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.
• 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

• A centralized and highly automated invoice system.
• Integration and standardization of the accounting systems and practices.
• A centralized and streamlined accounting organization.
• Delivering timely, relevant and accurate financial and business information.
• Replacing agents and third party invoices by electronic invoices.

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

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

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.
• Project: Public-Mutual Berhad Online Transaction Processing PBM-OLTP Role: Developer Environment: J2EE, EJB, Servlets, Java, JSP, JDBC, XML, JAXP, WebSphere Studio 5.0, 9iAS Developer, TOAD, UML, WEB Sphere 5.0, 9iAS v2, ORACLE 9i, Windows 2000, Linux Advanced server, VSS6.0, Reports 9i, PL/SQL, Microsoft Office Tools Duration: Mar'04 Jun'04
• Description: OLTP is a comprehensive Online Transaction Processing system for Fund holder and agent to address the current business problems and convoluted workflow procedures that revolve around the system. The new system is designed specifically towards handling the dynamic growing of daily transactions, efficiency in managing operations and offer better services requirement to fund holders, agents, IUTA and products.

Responsibilities:

• As a team member involved in Development of reports using Reports 9i
• Project: Autodeal Role: Developer Environment: Forms 9i, Reports 9i, Oracle9i, PL/SQL Programming, TOAD 7.0 Duration: Nov'03 Mar'04
• Description: Autodeal provides facilities of automobile sales and service. It caters to the Manufacturers and Dealers. It is a complete system that takes care of a vehicle right from presales, sales to service and housekeeping needs. This project deals with converting the existing system to a web enabled system using state of art technologies.

Responsibilities:

• 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.

Confidential

Responsibilities:

• 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.

Role: Developer Environment

• Description: This project is modularized into three categories.
• 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.

Responsibilities:

• 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.