SUMMARY:

• More than 18 years of IT experience in software design and development of data warehouses in various IT consulting domain including Health Insurance, Utilities, Retail, Manufacturing and Health Science.
• More than 15 years of strong experience in designing & building end - to-end Data Warehouses and BI Applications (Business Intelligence based Applications).
• Currently working as a DWH Technical Lead and Project Manager at Confidential .
• Designed and built various Enterprise-Wide Base Data Warehouse and Data-Marts for large clients including Confidential.
• Worked as DWH Architect and Lead in various projects. The responsibilities include from planning, designing and implementing DWH for various clients.
• Worked as onsite Manager for DWH outsourcing project. Involved planning and tracking the progress of transition.
• Worked extensively in data warehousing projects as DWH Consultant, including architecture design, data transformation and implementation.
• Involved in End to End implementation of DWH projects from Requirement gathering, design, development and implementation of project.
• Prepared roadmap for DWH development and support process.
• Worked Extensively as ETL Architect/developer using Informatica as ETL tool. Created ETL Architecture document, source system analysis and Mapping Design document
• Designed and Developed complex ETL mappings and mapplets using various transformations
• Extracted data from various source systems i.e. SAP, JDE, Seibel, Mainframe application, Custom build applications from various databases.
• Have extensive data modeling experience in creating Conceptual Data Model, Logical Data Models and Physical Data Models using ERWIN and Power Designer.
• Also worked in various OLAP technologies such as Business Objects, Cognos, MSOLAP
• Built data warehouse on various databases involving UDB (DB2 7.2), Oracle, SQL Server 2000 and Teradata.
• Writing complex MDX Expressions using Named Sets (for Rolling Date Ranges) for selecting the default time periods in Analytics reports.
• Capable of overseeing project from conceptual phase to successful implementation.
• Involved in total life-cycle development of software systems.
• Implementation of Data cleanup, transformations, scripts, triggers and stored procedure.
• Proficient in writing SQL, PL/SQL (Stored Procedures), Complex queries using oracle Analytical functions and other supported warehouse features like materialized views.

TECHNICAL SKILLS

RDBMS: Oracle 10g/9i/8i (Including PL/SQL and SQL), Teradata 7,UDB (DB2 7.2, 8.x),Informix, SQL Server 2000

ETL Tools: Informatica PowerCenter 5.1/6.2/7.3/8. X/9.X, SQL Server DTS/SSIS and ETL using PL/SQL

OLAP Tools: Business Objects 5.1/6.5, COGNOS 7.x (Impromptu and Power Play), Hyperion Planning, Essbase 6.5.4.2

Data Modeling: Erwin, ER Studio and Power Designer

Tools: Power Builder 7 with PFC, Developer 2000, ER-Win 4.1, S-Designer, Seibel Analytics.

Language: SQL, PL/SQL, C++, C, UNIX, Shell Scripting, PERL, Informix-4GL

Sources: SAP 4.7, SAP APO, JDE (Oracle), Siebel, I2, Trade Promotions Management (MEI), IBM Mainframe, Oracle

PROFESSIONAL EXPERIENCE:

Project Manager

Confidential

Responsibilities:

• Interact with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Understand the requirement and developed ETL design document to develop mappings. Also prepared strategy to load historical and incremental loading of the mappings.
• Worked closely with Data Architects in designing the data model for EDM.
• Analyzed source system data, which helped in designing the ETL rules.
• Prepared test cases and completed Unit testing of developed mappings. Coordinated ETL testing with Business analysts and users.
• Assisted other team members in designing and developing their mappings. Also involved in doing the peer review of team members mappings.
• Analyzed ETL code and tuned the mappings to improve their load performance by tuning mappings or redesigning the code.
• Migrated code from individual user folders to Project folder.
• Analyzed the defects identified by the project team and fixed them.

Technologies: Microsoft Project, Microsoft Office tools, Informatica 8.1/9.5.1, Oracle

DWH Architect / Project Lead

Confidential

Responsibilities:

• Lead for responding to RFP, solution feasibility, and technical architecture.
• Interact with business directors/sponsors to finalize the scope of the enhancement of existing data warehouse.
• Interacted with business managers for Gap analysis in existing Data warehouse for new business requirements.
• Overview of MDM, data warehousing, data quality and business intelligence initiatives.
• Created Project plan and cost and resource estimate for the project and tracked the progress/finances of the project
• Understand current business process and collected requirement for the project.
• Presented solutions to clients to address data governance, data stewardship, data profiling, and six components of data quality including Completeness, Conformity, Consistency, Accuracy, Uniqueness/De-duplication and Integrity.
• Interacted with business to prepare business case for justifying cost associated with the project.
• Worked with business steering committee members to prioritize enhancement requests and scheduling releases to move these requests into production.
• Worked with source system analysts to analyze the source system and design the interface with existing data warehouse.
• Interacted with support team members on weekly basis for scheduling and prioritizing work and releases.
• Worked closely with technical team in designing solution for various enhancements. This involves redesigning some components of data warehouse to enhance the functionality of data warehouse.
• Modified the current interface with SAP to capture change data in Data warehouse from SAP on daily basis.
• Improved the ETL performance from 12 hours to 2 hours by using tuned queries and optimizing the database and Informatica ETL mappings. Performed major role in analyzing the database and ETL mapping and providing inputs to modify ETL and database for better performance.

Technologies: Microsoft Project, Microsoft Office tools, SAP, I2, Informatica 7.1.3, Informatica 8.x, DB2 8.0, Business Objects 4.1

DWH Architect / Lead

Confidential

Responsibilities:

• Understand current business process and collect requirement for the projects.
• Analyze source system and understand various data issues pertaining in source systems.
• Created ETL Architecture and source system analysis document for the Project. Prepared development standards and guidelines for the project to be followed by team.
• Designed data model for the project and came up with space requirement for the database and its growth.
• Created ETL Source to target mapping document. Prepared strategy to load history and incremental data into Data warehouse.
• Estimated the scope of development and tracked the development effort of ETL work from other team members.
• Designed, developed and reviewed ETL mappings for the project.
• Involved in User testing phase of the project. This involves interacting with the users, explaining to user queries regarding data and tracking any issues occurred during user testing.
• Prepared strategy to migrate code from development to production. Migrated code initially to production from their test environment.
• Interacted closely with Microstrategy team in coordinating the loads and testing of the project.

Technologies: Microsoft Project, Microsoft Office tools, JDE, Informatica 7.1.3, SQL Server 2000, Business Objects 4.0

DWH Onsite Lead

Confidential

Responsibilities:

• Identifying and mitigating the project risks and communicating the risks and risk impacts to business teams and to other project stake holders.
• Working closely with business analyst’s and System Analyst’s in tracking the scope changes and working through resolutions.
• Designed the system to receive the data into data warehouse on 24x7.
• Leading the effort on Extracting and reformatting data from various trading desks into Target DWH and to Data marts.
• Develop new strategies and execution plans, measure, track, analyze and optimize programs to produce strong ROI.
• Manage various integration programs and processes as well as recommending new methods and vendor tools to improve demand generation results.
• Responsible for database and list management, importing external lead data, efficient distribution of lead data. Analyze and measure effectiveness of marketing programs, reporting results and strategy recommendations to senior management.
• Leading the effort on Root Cause Analysis and planning the corrective actions.
• Analyzing the data growth and planning for the continuous improvements for consistence performance and scoping and planning the increasing needs of resource needs.
• Leading the Development team for issue’s relating to ETL, Report Development and QA Team for Functional / User Acceptance Testing.
• Drafted and implemented a data security model for the BO XI R2 reporting platform.
• Worked on cube migration from MSAS 2000 to MSAS 2005 and to MSAS 2008 cube.
• Reduced the reporting data availability turnaround time by 65% with the design changes in data loading architecture.
• Implemented the load balancing and clustering solution for the 2005 cube environment using Big IP clustering solution, which is an innovative approach in OLAP clustering solutions.
• Implemented a dimension member based Dynamic security in MSAS 2005 cube.
• Handled the multiple BI projects simultaneously.

Technologies: Microsoft Project, Microsoft Office tools, Informatica 7.1.3, MSAS

DW Lead

Confidential

Responsibilities:

• Analyze source systems and understand source system applications with the help of PTS Business Analysts.
• Created ETL Architecture and source system analysis document for the Project. Interacted with Informatica Administrator group, source system and Data warehouse DBA’s and source system application owners.
• Design data model for PTS Metrics data warehouse using Erwin
• Worked with team in preparing Source to Target Mapping and unit test case documents.
• Designed, Developed and Reviewed ETL mappings from source to staging and from staging to Data warehouse.
• Prepared Test Strategy and coordinated system, integration and user acceptance testing.
• Prepared strategy to implement ETL code in production and load historical data in production.

Technologies: Informatica 7.1.3, Power Designer 9.0, Oracle 10g, JDE (Oracle), Track wise (SQL Server)

Project Lead / ETL Architect

Confidential

Responsibilities:

• Interacting with clients in Analyzing Business Requirements.
• Created Functional and Technical Design document of the Project. The document contains strategy of converting history data from 13 periods to 12 months and modifying incremental mappings from 13 to 12 periods.
• Created ETL mappings to convert history data from 13 periods to 12 months. Modified incremental ETL mappings to load ongoing data in 12 periods.
• Created parameter files to remove any hard coding which was used in previous mappings for 13 periods.
• Interacted with support team for configuration management of changed mappings for this project.
• Interacted with Business Objects team in explaining requirements and modifying cubes and reports due to these changes.
• Involved in testing with business users from system testing to regression testing.
• Communicate and facilitate discussions with the business owners and make presentations to drive resolution on proposed features and functionality.
• Define and achieve client needs through one-on-one sessions and on-going communication.
• Implementing data warehousing Bus Architecture methodologies and document systems, which introduced a cohesive development team of 3 to 5 rather than individualized task outcomes?
• Introduced the defect tracking system and quality assurance systems, to organize project assets, and reduce time to generate the quality and delivery metrics.
• Successful implementation of project release management for a data warehouse project by implementing VSS for ETL in Informatica.
• Providing the technical consulting to the project team and BI Practice and participated in the review sessions of the RFP’s.
• Providing the technical leadership to the team and mentoring in various activities.

Technologies: Informatica 6.2, UNIX, Oracle, Business Objects.

ETL Lead

Confidential, ATLANTA

Responsibilities:

• Interacted with business users in Analyzing Business Requirements. Collect requirement to transfer and load history data into data warehouse.
• Create a data model for the project based on business requirements.
• Work with SAP and TPM source system resources to understand source system data.
• Created mapping design documents and unit test cases to transfer data from source system to data warehouse.
• Extracted data from various source systems. Extracted data from SAP using Informatica Power Connect. Extracted data from other source systems via directly connecting to source system using native informatica connections.
• Developed ETL mappings and mapplets using various transformations in informatica.
• Scheduled Informatica mappings through Unix shell scripts.
• Involved in testing the system with business users during various testing stages.
• Helped Cognos team in testing Cognos reports and Cubes. Also worked in Cognos in developing some Cognos impromptu reports.

Technologies: Oracle 8.1.3, Informatica Power Center 6.2, Cognos, ERWIN, SAP R/3 4.7, AIX.

ETL Lead

Confidential

Responsibilities:

• Interacting with clients and Analyzing Business Requirements.
• Designing Consumer Relations Datamart
• Created Functional and Technical Design document of the Project.
• Extracting data for Siebel Source System using Power Connect for Siebel and load into datamart.
• Development of Informatica Mappings, Sessions, Worklets and Workflows.

Technologies: Oracle 8.1.3, Informatica Power Center 6.2, Cognos, ERWIN, Siebel

ETL Developer/Tuning

Confidential

Responsibilities:

• Created Mapping Design document to transfer data from source system to datawarehouse.
• Development of Informatica Mappings, Sessions, Worklets, Workflows.
• Created Complex mappings using various transformations using Informatica.
• Scheduling of Informatica Jobs through Shell script.
• Migrating form Informatica Power Center 5.1 to Informatica Power Center 6.2
• Wrote Shell Scripts to monitor load on database and Perl Scripts to format data extracted from Data warehouse based on user requirements.
• Prepared a process document from moving Informatica code from Development to Production.
• Developed Cognos Reports Using Impromptu Administrator.
• Developed Catalogs to build reports.
• Developed Informatica Mappings and Reusable Transformations for Daily, Weekly and Monthly Loading of Data.
• 80% of user-defined functions (consists of business logic) are converted into simple/complex SQL queries to process the huge volumes of data in considerable period.
• Achieve client needs through the defined process and an ongoing communication.
• Tuned the Pl/SQL stored procedures using the PL/SQL Profiler.
• Responsible for requirement analysis, design, and implementations using the various web and database technology solutions.
• Reviewing and analyzing the stats pack report for the resource usage of the application and to consider other aspects for the performance tuning.

Technologies: UDB 7.2, Informatica Power Center 6.2, Informatica Power Center 5.1, Cognos, Perl

Datamart Developer

Confidential

Responsibilities:

• Creating Universe in Business Objects Designer
• Creating Reports using Business Objects
• Managing Users using Business Objects Supervisor
• Implementation and optimal Configuration of Web Intelligence and BCA.
• Developing, Analyzing and Maintaining Informatica mappings and sessions.
• Supporting Application and handling user queries.

Technologies: Oracle 8.1, Business Objects 5.1.2 and Informatica Power Center 5.1

Developer/Analyst

Confidential

Responsibilities:

• Interacting with clients and collecting requirements.
• Designing Data Model for Warehouse Using ERWIN Data Modeling Tool.
• Writing Parsing Scripts Using PERL
• ETL Scripts Using PL/SQL
• ETL mappings Using Informatica Mappings
• Olap Reporting Using Cognos

Technologies: Oracle 8.1, Perl, PL/SQL, ERWIN Data Modeling Tool, Informatica PowerCenter 5.1, Cognos Upfront, Cognos Impromptu Administrator, Cognos Power Play, Cognos Transformer, Cognos Impromptu Reports.