SUMMARY

• Around 8.0 years of professional experience working as
• Technical Architect designing solutions to improve Business efficiency, working closely with the client.
• Application developer for Datawarehouse/OLAP Application design and development with specialized knowledge on Microsoft SQL Server, Oracle database, Informatica, SalesForce.com and OBIEE.
• Informatica Certified Developer.
• Expertise with Informatica data Integration Tools 7.x/8.x/9,Power Exchange ERP (SalesForce, Hyperion Essbase, PeopleSoft, SAP)
• Extensive experience in Data Integration - Extraction from multiple data source systems like SAP, Salesforce.com, PeopleSoft, Hyperion Essbase, Oracle, SQL Server and Flat files, Performing Complex custom transformations and finally Loading data into Datawarehouse using Informatica PowerCenter Designer.
• Explored Informatica Cloud’s Data Replication Service to replicate data from sales force to Microsoft SQL Server DB tables.
• Proficient in reporting tools, OBIEE 11.1.1, Siebel Analytics and Hyperion Financial Reporting.
• Proficient in cloud based applications, SalesForce.com.
• Proficient in Designing, Developing the Semantic Layer (BMM/Data-Model) involving complex joins and cardinalities, Developing Ad-hoc Dashboard/Reports using OBIEE, Perform Report analysis and Report scheduling.
• Strong Knowledge of SQL, PL/SQL Stored Procedures, SOQL.
• Worked with advanced MS SQL Server and Oracle Analytic functions for various business requirements.
• Extensive experience in writing various PL/SQL Stored procedures and Functions based on Client requirements.
• Extensive experience in analysis/debugging of existing PL/SQL Stored procedures and conversion of PL/SQL Stored procedures into Informatica mappings.
• Worked with Oracle Data Integrator in projects to load data into Hyperion systems for financial reporting.
• Experience in Dimensional data modelling - Star/Snow Flake Schemas and building Dimensions and Fact tables using tools like ERwin.
• Designed and developed a powerful tool - DART, an out of box solution for the ETL process tracking and analysis of the huge transactions in organizations.
• Highly proficient in Data Analysis and data cleaning techniques.
• Sound knowledge in SSIS.
• Extensive experience in the complete project life cycle phases starting from Requirements gathering, Analysis of User Requirements, preparation of Functional Specification Documents, Technical Design Document, Coding & Unit Testing, Integration Testing, Implementation, post production Support & User Training.
• Excellent Analytical, problem solving, communication and presentation skills.
• Ability to understand the business environment and translate business requirements into technical solutions.
• Good team player and interpersonal skills; Worked with customers exemplifying technical and functional excellence.

TECHNICAL SKILLS

ETL Tools: Informatica 7.x/8.x/9.x, SSIS,ODI

OLAP Tools: OBIEE 10.x/11.1.1, Siebel Analytics, Hyperion Financial Reporting

Cloud Based Tools: SalesForce.com

Databases: MS SQL Server 2000/2005/2008 , Oracle (9i/10G)

Multi-Dimension Databases: Hyperion Essbase

Operating Systems: Windows 7,2003, 2000, 9X and XP

Languages: SQL,PL/SQL, SOQL

Other: Informatica Cloud, TOAD, SQL*PLUS, SQL Navigator, SQL Developer, VSS, DAC

PROFESSIONAL EXPERIENCE

Confidential

Technical Architect

Responsibilities:

• Analyzing existing spend system; translating client requirements into highly specified project briefs, responsible for creating requirement specifications.
• Examine existing business models and flows of data; Identifying options for potential solutions and assessing them for both technical and business suitability.
• Converted the data warehouse tables from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database
• Responsible for the Design, development and testing of the ETL processes necessary to extract data from SAP data sources, Transform and cleanse the data, and Load it into the Accounts Payable data mart.
• Designed and developed the Metadata Repository (.rpd) using OBIEE Server Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies) & Logical Facts / Measures objects in Business Model Layer, and created the Presentation catalogs in Presentation Layer.
• Developed AP Reports / Dashboards with different Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBIEE Web.
• Implemented security by creating roles & web groups, checks with External tables and LDAP.

Confidential, Collegeville, PA

Subject Matter Expert and Application Developer

Responsibilities:

• Establishing a detailed program specification through discussion with clients; requirement analysis by breaking down the specification into its simplest elements and translating the requirementsinto a working interface
• Produce outline designs of new systems, specifying the operations the system will perform, and the way data will be viewed by the user.
• Analyzing and translating client requirements into highly specified project briefs; responsible for creating Software requirement specifications.
• Involved in creating data models using ERwin.
• Present design to the client and, once approved, work closely with the technical team to implement the solution.
• Perform data analysis and create documents for source to target mapping.
• Responsible for the Design, development and testing of the ETL processes necessary to extract data from various operational data sources, Transform and cleanse the data, and Load it into the data marts.
• Created several stored procedures and functions using SQL Server.
• Implemented new enhancements in SalesForce.com including creation of custom objects, workflows, email alerts and templates
• Maintained multiple user roles, security, profiles, workflow rules, etc. Support train new end users on the salesforce.com application
• Developed and maintained Visualforce, AppExchanges, Force.com pages and integration to third party tool Cameleon Software
• Demonstrated ability to effectively communicate technical issues and resolve problems at all levels of the organization both internally and externally
• Providing training to users to work using the new system.
• Involved in Informatica Powercenter migration from version 8.1.1 to 9.1.1

Confidential

Subject Matter Expert and Technical Lead

Responsibilities:

• Analyzing existing systems; translating client requirements into highly specified project briefs, responsible for creating Software requirement specifications.
• Examine existing business models and flows of data; Identifying options for potential solutions and assessing them for both technical and business suitability.
• Converted the data warehouse tables from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database
• Responsible for the Design, development and testing of the ETL processes necessary to extract data from various operational data sources, Transform and cleanse the data, and Load it into the data marts.
• Created complex mappings which implement the logic of SCD’s.
• Extensively used Power Center/Mart to design multiple mappings with embedded business logic
• Designed and Customized data models for Data Warehouse supporting data from multiple sources on real time.
• Performing Integration testing by integrating various modules; Participate in User Acceptance testing.
• Perform deployment of the ETL Jobs and Stored procedures from Development to QA/Production environment.

Confidential

Subject Matter Expert and ETL Team Lead

Responsibilities:

• Establishing a detailed program specification through discussion with clients; requirement analysis by breaking down the specification into its simplest elements and translating the requirementsinto a working interface
• Involved in creating data models using ERwin.
• Responsible for Design and development of mappings, mapplets, sessions and workflows to create jobs that load data from the heterogeneous source systems into target database using Informatica Power Center.
• Perform deployment of the ETL Jobs and Stored procedures from Development to QA/Production environment.
• Administering the ETL server, maintaining Users, groups and Privileges
• Monitor and track completion of tasks within deadlines

Confidential

ETL Team Lead

Responsibilities:

• Examine existing business models and flows of data; Identifying options for potential solutions and assessing them for both technical and business suitability.
• Analyzing existing systems; translating client requirements into highly specified project briefs, responsible for creating Software requirement specifications.
• Perform data analysis and create documents stating the source to target mappings.
• Responsible for the Design, development and testing of the ETL processes necessary to extract data from various operational data sources, Transform and cleanse the data, and Load it into the data marts.
• Develop mappings using various transformations like SAP/ALE IDoc Prepare, SAP/ALE IDoc Interpreter, custom, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
• Responsible for the Design, development, debugging and testing of the Stored Procedures involved in the applications.
• Mentoring the development work and guiding the team throughout the development phase.
• Performing Integration testing by integrating various modules; Participate in User Acceptance testing.
• Provide production support to troubleshoot production issues and frame solutions.
• Involved in performance tuning of various ETL jobs and SQL methods.
• Involved in Informatica software migration from 7.1.2 version to 8.1.1

Confidential

ETL Team Lead and Analytics Developer

Responsibilities:

• Establishing a detailed program specification through discussion with clients; requirement analysis by breaking down the specification into its simplest elements and translating the requirementsinto a working interface.
• Devising possible solutions to anticipated problems and defining them through Technical design document.
• Involved in creating data models using ERwin.
• Involved in design and development of the reusable Informatica components - mapplets and transformations that best suit the business rules and provide effective solution.
• Responsible for Design and development of mappings, mapplets, sessions and workflows to create jobs that load data from the heterogeneous source systems into target database using Informatica Power Center.
• Develop mappings using various transformations like update strategy, custom, lookup, stored procedure, router, joiner, sequence generator, normalizer and expression transformation.
• Integrating all elements and modules of the system and performing Integration testing.
• Perform deployment of the ETL Jobs and Oracle Stored procedures from Development to QA/Production environment.
• Created several stored procedures and functions using PL/SQL.
• Designed and executed execution plans for Informatica Workflows through DAC (Datawarehouse Application Console)
• Created connection pools, physical tables, schema folders and catalog folders in the physical layer of the repository
• Defined Primary key-Foreign key relationships, complex joins between dimension tables and Fact tables in the physical layer.
• Created Business model with logical tables in the Logical Display folders.
• Created Dimensional Hierarchies in Logical Layer to achieve Drill Down functionality; created calculated logical columns according to business requirements
• Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders
• Worked Extensively on Siebel Answers to create the reports as per the client requirements
• Designed various reports with Drilldowns, Pivot Tables, Bar charts, Pie charts, Narrative Views, Legends, Multiple Guided Navigation and Combine Similar Request features in Answers
• Maintained Effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.

Confidential

Application Developer

Responsibilities:

• Responsible for Design and development of mappings, mapplets, sessions and workflows to create jobs that load data from the heterogeneous source systems into target database using Informatica Power Center.
• Develop mappings using various transformations like update strategy, custom, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
• Tuning of mappings and SQL queries for better performance and efficiency.
• Testing and deployment of the ETL jobs.
• Responsible for Design and development of Interfaces, Packages using Oracle Data Integrator to create Jobs that load data into Hyperion systems for financial reporting.
• Responsible for design and development of Business objects Universe defining complex object definitions, joins, cardinalities and aggregate awareness functions.
• Develop and maintain reports using desktop Intelligence and Webintelligence.
• Involved in Creating tables, views, indexes, partitions in Oracle.
• Created several stored procedures and functions using PL/SQL.