Experience Summary:

• Around 9 years of extensive IT experience including experience in business analysis, requirement gathering, design, development of database centric corporate intelligence solutions including Data warehouses, Data Migration, Decision Support Systems, Enterprise Business Intelligence and all phases of Data warehouse Development Life Cycle.
• Specific business domain knowledge includes advertising, gaming, biotechnology, telecommunication, technology, financial services, manufacturing, healthcare, etc.
• Designed and Developed Data Warehouse/Data Mart systems, using various RDBMS Oracle, MS-SQL Server, UDB/DB2, Sybase , PL/SQL, and ETL tools Informatica PowerCenter, Informatica Cloud .
• Business Analyst responsibilities include gap analysis, requirement gathering and analysis, test case creation and execution.
• Hands on experience in preparing Business, Functional and User Requirement Documents, Technical Design Documents, Solution Definition Documents, UAT Documents, etc.
• Involved in Physical and Logical database design, and performance tuning for development, testing and production environments.
• Trained in Cloudera Hadoop technologies like HDFS, MapReduce, Pig, Hive, Hbase, Zookeeper, Oozie, Sqoop, etc.
• Experience in Salesforce data migration, development, administration, testing deployment.
• Experience in developing OBIEE Repository at three layers Physical, Business model and Presentation Layers , ad-hoc reports in Answers, Interactive Dashboards.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Filters, Ranking, Sections and Breaks.

Professional Experience Summary:

Confidential

Salesforce Developer

I have been working in different modules functionalities of Salesforce Sales Cloud Service Cloud.

Responsibilities:

• Migrating data related to article, attachment and other Salesforce objects to Oracle and Salesforce in different organization.
• Helping organization in migration from Oracle RightNow to SFDC Service Cloud.
• Creating modifying salesforce objects, fields, sites, validation rules, reports, dashboards, workflow rules, approvals, etc.
• Creating and managing users, profiles, permission sets, field level record level security.
• Preparing Business Requirement, Test Cases documents User Guides.
• Used Informatica Cloud to transfer data from Salesforce to Oracle.
• Testing of functionalities of different SFDC objects, apps.

Environment: Salesforce.com, Apex Data Loader 30.0.0, Force.com Explorer, Dataloader.io, Informatica Cloud, Oracle 11.2, Oracle SQL Developer 3.2, Jira

Confidential

Informatica Specialist

Project: MDM

This project involves providing recommendation on SCEA's Informatica Environment structures along with Mappings, Session, Workflows and fixing according to the recommendation. This project also involves creating OBIA to Staging, Staging to MDM mappings.

Responsibilities:

• As part of ETL process, loaded data from Oracle tables into target Oracle data warehouse using Informatica PowerCenter.
• Extensively used Informatica Marketplace tools Sameeksha Informatica Support Console to identify issues with existing mappings, sessions, workflows and fixing them. Issues included data type mismatch, precision mismatch, naming violations
• Prepared SCEA Developer's standard guide, Technical Design Document.
• Worked as a Delivery Manager to provide sign off for any code moving from Development to other environments. Made sure developed code maintained standard naming convention.

Environment: Informatica 9.1, Oracle 11.2, Toad 9.7.2, Oracle SQL Developer 3.2, Jira, XML Marker 1.1, Sameeksha, Informatica Support Console

Confidential

Senior ETL/Informatica Developer

Responsibilities:

• Responsible for Requirement Gathering, Analysis and documenting Sunshine Tool Disputes/Held process.
• As part of ETL process, loaded data from Oracle/SFDC tables into target Oracle/SFDC data mart/management tool using Informatica PowerCenter utilities.
• Created various Transformations such as Expression, lookup, Joiner, Aggregator, Filter, Router, sorter, Sequence Generator, Update Strategy, Normalizer, Java transformations.
• Created detailed field level Technical Design Documents, Unit Test Documents.
• Loaded end-to-end Aggregate Spend data in development, QA, UAT environments and validated data at every stage.
• Worked closely with QA/UAT testing teams and in case of any defects raised, analyzed the defects, tracked related transactions all the way and made necessary code changes.

Environment: Informatica 9.1, Oracle 11.2, SFDC salesforce.com , Apex Explorer 8.0, Mercury Quality Center 8.2, Jira, XML Marker 1.1, Toad 9.7.2

Confidential

Business Intelligence Solutions Specialist

Responsibilities:

• Responsible for daily maintenance, monitoring, performance analysis, trouble shooting and problem resolution of ETL processes.
• Created eligible list, bonus calculation of telecom campaigns and packages, ETL preparation of different reporting requirements by using Informatica PowerCenter.
• Responsible for monitoring the ODS Operational Data Source transfer operation of recharge, customer, call charge, MSC telecom base station controller , SMS, scratch card, postpaid prepaid usage related source data. This transfer was done to keep 1 year history.
• Responsible for creating more than 50 reports that would show usage pattern revenue by age group, geography, call types, product, etc. for finance sales teams.
• Responsible for Port configuration by using SQL statements.
• Participated in Oracle Communication Data Model OCDM training conducted by Oracle.

Environment: Informatica 8.6, Oracle 11.2, Toad 10.6, OBIEE 10.1.3.4.1, OWB 10g, Discoverer Desktop 10.2, Windows 7, Sun Solaris

Confidential

Business Intelligence Developer

Responsibilities:

• Created User, Functional Requirement Technical Design documents.
• As part of ETL process, loaded data from Oracle tables into target Oracle based Enterprise Data Warehouse using Informatica PowerCenter.
• Used Type 2 Slowly Changing Dimension SCD mappings to insert new dimensions and update dimensions in the target in order to maintain the history.
• Responsible for performance tuning and production support of Informatica processes.
• Converted complex reports from Business Objects to OBIEE.
• Developed many Complex Reports / Dashboards with different kind of views like narrative, table, title, pivot table, graph, gauge, view selector, column selector, filter, and chart.
• Responsible for maintaining development, test and production dashboards.

Environment: Informatica 8.1, Business Objects 6.5, Oracle 9i/10g, Toad 9.1, SQL Plus 9.2, OBIEE Oracle Business Intelligence 11.1.1.5/10.1.3.4.1, Windows XP, Sun Solaris

Confidential

Technical/Business Analyst

Responsibilities:

• Gathered project requirement information from a commercial mortgage performance benchmarking organization called Lifecomps and thoroughly analyzed the requirement.
• Conducted JAD sessions with SMEs and business users to analyze and understand the new requirement.
• Conducted gap analysis to find out the missing link between source and target and interacted with source systems SMEs to identify the source of the data needed to implement this project.
• Created User, Functional Requirement, Solution Definition, and Technical Design documents.
• Created Business Workflow, Use Case, Activity, and Process Flow diagrams.
• Designed the staging database.
• Assisted the Project Manager in setting realistic project expectations.
• Worked independently to meet the project goals and deadlines along with resolving issues in the absence of the manager.
• Assisted the QA team in creating, reviewing and modifying test plans and test cases using HP Quality Center and participated in unit, integration, regression and user acceptance testing.

Environment: Informatica 7.1.3, RapidSQL 7.4.0, Oracle 10g, Sybase, Toad 9.1, SQL Plus 9.2, SharePoint, MS Visio, HP Quality Center 9.2, Windows XP

Confidential

Database Developer

Responsibilities:

• Analyzed source, business logic and prepared technical design and functional design documents. Involved in Performance Tuning.
• Developed PL/SQL Stored Procedures, Functions, Packages, and other database objects for implementing complex rebate logic.
• Worked closely with the B2B team providing specific inputs to ensure specific reporting related aggregations were included at the design stage.

Environment: Oracle 10g, SQL Plus 9.2, TOAD 8.5, Windows XP, Sun Solaris

Confidential

Business Intelligence Developer

Responsibilities:

• As part of ETL process loaded data from Flat files, Oracle tables into Oracle based Unified Sales Data Mart using Informatica PowerCenter utilities.
• Responsible for unit testing and validating the data loaded in to Target tables by using SQL queries in TOAD and by generating reports using Business Objects.
• Maintained mappings that loaded Data from Oracle to Salesforce.
• Created Ad-hoc reports in Business Objects to satisfy other business needs and other validation required for different client needs using reporting functionalities such as Master Detailed, Filters, Ranking, Sections and Breaks and by linking data from multiple data providers and using free hand SQL.

Environment: Informatica 8.1/6.2, Business Objects 6.5, Oracle 9i, Toad 9.1, SQL Plus 9.2, Hyperion Essbase Hyperion Planning 9.3.1, Windows XP, Sun Solaris

Confidential

Informatica Developer

Responsibilities:

• As part of ETL process loaded data from Flat files, Excel, DB2, SQL Server, Sybase tables into target SQL Server database and Flat files using Informatica PowerCenter.
• Developed production workflows with different error checking conditions and used Command task to make the workflow email the production support team.
• Used Workflow Manager for Creating, Validating, Testing and Running the sequential and concurrent Batches and tasks including sessions, decision tasks, command tasks, event wait tasks, event raise tasks, timer, and scheduled them to run at a specified time.
• Responsible for monitoring and troubleshooting daily processes in Production environment.
• Other tasks involved Performance Tuning, Production Monitoring/Support.

Environment: Informatica 8.1/6.2, Microsoft SQL Server 2005, DB2 UDB 8.2, DbVisualizer 5.1.1

Confidential

Data Warehouse Developer

Responsibilities:

• Participated in the initial building of the Pharmacy Data Mart.
• Responsible for developing PL/SQL Stored Procedures, Functions, Packages, and other database objects.
• Extensively used Informatica for ETL activities.
• Involved in Performance Tuning of SQL Queries, Sources, Targets, mappings and sessions.

Environment: Informatica 7.1, Oracle 9i, SQL Navigator, SQL PLUS, PL/SQL, UNIX Solaris