OBJECTIVE

• Seeking for a Professional position as Data Business Analyst/Business System Analyst/Business Intelligence analyst

SUMMARY

• More than 7yrs. of IT - industry experience in Data warehousing and all phases of Software development life cycle (SDLC).
• More than 5 yrs of experience in Data analysis using OBIEE11.7,Microsoft Excel and Tableau8.3
• More than 2 yrs of experience in Master Data Management.
• More than 2 yrs of experience in Salesforce CRM and Oracle EBS
• More than 3yrs of experience in Informatica Power center 8.x, 9.x.
• Good experience in Data Warehousing, Conceptual, Logical and Physical Data Modelling.
• Experience in Tableau Dashboards in Design and Presentation.
• Develop enterprise dashboards and reports using OBIEE Plus tools.
• Identify critical issues and processing faults to optimize BI dashboards and reports.
• Familiar with Python programing, Big data, Hadoop/Hive.
• Excellent experience of creating data models for relational schemas (OLTP) and dimensional schemas (OLAP) with proper normalization and denormalization techniques and developed Database Schemas like Star Schema and Snowflake Schema.
• Designed and developed complex mappings using transformations like Lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Sequence Generator and Update Strategy.
• Experience in creating reusable transformations, mapplets and PL/SQL stored procedures.
• Worked on requirement gatherings of the reports for several projects, designed the data warehouse and developed mappings to load the data in the dimension and fact tables.
• Implemented slowly changing dimensions of Type 1, Type 2 and Type 3 and Performance tuning of sources, mappings, targets and sessions in Informatica and SQL queries.
• Implemented Centralized ‘Banking Application Software ‘Omni’ extensively. Experience in Testing, Implementation and Support in banking software.
• Worked extensively on writing SQL queries and Oracle constructs.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills. Ability to work in high-stress environments.

TECHNICAL SKILLS

ETL Technology: Informatica 8.x and 9.x,Informatica PowerEXchange8.x

Datawarehouse: Star schema and snowflake schema

Data Modelling: MS Visio, Erwin

Application software: Banking software ‘OMNI’, MS Office and Toad and Microsoft Excel and Tableau10.3 for Data Analysis, OBIEE11.7

Programming languages: Html, CSS, UNIX Scripting, Python

Database: Ms-Access, MS Sql server 2005/2008(SSMS, SSIS, SSRS), Oracle9i, Oracle10g, Oracle11g, Teradata 12

Project Management software: Microsoft Project 2010

CRM: Salesforce and Oracle EBS

PROFESSIONAL EXPERIENCE

Confidential

Salesforce Business System Analyst

Responsibilities:

• Worked extensively on cleanup of Salesforce data and standardization of records.
• Performed the Validation of mapping between master data fields proposed for MDM hub and Salesforce fields.
• Participation in the MDM tool vendor meetings for the tool evaluation.
• Performed testing to find out the possible entry points for duplicate contacts and accounts in Salesforce.
• Involved in evaluation of account deduping tools.
• Planned and conducted meetings with different business groups to know their involvement in Customer Account life cycle and customer life cycle process and documented those fact findings.
• Created data flow diagrams and business process flow diagrams to facilitate better system understanding.

Environment: Salesforce,SQL

Confidential

Data Business Analyst

Responsibilities:

• Key member of the Data services and Analytics team and responsible for Master data management Processes.
• Improved customer data in salesforce by following the Data Governance practices
• Improved the complete view of the customers by maintaining the correct customer account hierarchies in customer data hub and Asset transfers for the customer accounts in Oracle EBS.
• Supporting the end users for the customer accounts and opportunities related queries.
• Keep a check on the synchronization between the salesforce and other upstream and downstream systems.
• Enrich the customer data in salesforce using hoovers data.
• Worked with the team members for successfully completing the goals of validating the customer account data, reducing the duplicates in the system, maintaining the correct customer account hierarchies and correct account ownerships in the system.
• Maintaining dashboards for customer accounts in salesforce.
• A Key member in generating monthly and adhoc reports in OBIEE and interactive dashboards for the management and maintaining dashboards.

Environment: Salesforce, Oracle EBS,OBIEE11.7,SQL

Confidential

Informatica Developer

Responsibilities:

• Member of Master Data Management, responsibilities includes Data governance consisting Data Stewardship, Metadata management, Data Quality, Data Profiling, Data Integration & Consolidation.
• Responsible for Data analysis of customer data in salesforce versus D&B data.
• Responsible in maintaining the correct data in salesforce and eliminating the duplicates
• Involved in tool evaluation of various MDM tools like Informatica MDM, Talend, and IBM.Trillium.
• Responsible for Business analysis, did requirement gatherings for MDM tool and prepared the BRD.
• Prepared the functional and non-functional document for MDM tool.
• Worked on the GoToMarket data and data cleansing of customer accounts before loading it in Anaplan.
• Well versed with Talend Integration cloud and Talend MDM.
• Responsible for designing MDM application architecture (tool/no tool)
• Responsible for designing the Customer Hierarchy architecture in Oracle
• Key person in designing, developing and documenting the ETL process to load the salesforce data into Oracle using Informatica power center 9.1 for designing the Customer Hierarchy in Oracle.
• Designed the complex mappings and workflows and sessions using Informatica power center 9.1.
• Implemented the scd type 1 and scd type2 tables to load the data from sources to the targets.
• Extensively involved in performance tunning of ETL process by determining the bottlenecks at various points like targets, sources,mappings,sessions.This led to better performance.
• Used Aggregator,sql overrides, source filter and source qualifier and data flow management into multiple targets using router transformations.
• Wrote complex Sql queries and Pl/Sql procedures to perform data base operations according to business requirements.

Environment: Informatica Power Center 9.1,Oracle11g,PL/SQL,Salesforce,Flat files, Unix

Confidential

Informatica developer

Responsibilities:

• Gathered report requirements with Business Users and converted them into project documentation.
• Created the mappings and workflows for loading data to the staging tables and then to the dimension and fact tables using Informatica Power center 8.6.
• Used transformations like Source qualifier, Lookup, Router, Joiner, Update strategy, Sequence generator, Expression and Filter Transformations in the project.
• Used Debugger to track the path of the source data and to check the errors in mapping.
• Involved in Data Modeling using Star/Snowflake Schema Design using Erwin.
• Used Workflow manager to create and configure workflow and session task to load data. Used Informatica workflow monitor to create, monitor workflow in case of process failures.
• Configured the sessions using workflow manager to have multiple partitions on source data and to improve performance.
• Used pmcmd to run workflows.
• Handled slowly changing dimensions of Type 1 and Type 2 to populate current and historical data to dimensions and fact tables.
• Responsible to write complex sql queries and scripts to perform database operations according to business requirements.
• Configured the sessions using workflow manager to have multiple partitions on source data and to improve performance.
• Involved in end-to-end system testing, performance and regression testing and data validations.
• Worked on Data Extraction, Transformations, Loading, Data Conversions and Data Analysis.

Environment: Informatica Power Center 8.6, Teradata 12, Oracle 11g, Erwin 8, Putty

Confidential, CA

Data Modeller

Responsibilities:

• Designed database and forms for Confidential: It included database designing (conceptual and logical).Created data related documentation like setting up the business rules, designing Entity relationship diagram, Functional Dependency Analysis, Normalization of tables and designing of forms. Wrote SQL queries for creating database objects like tables, views and indexes.
• Information system project on Online examination system: Followed SDLC approach in this project .It included designing diagrams such as Context diagram, Data flow diagram, Entity relationship diagram, Use case diagrams, Class diagrams and Sequence diagrams.

Confidential

Data analyst

Responsibilities:

• Worked as a Team Lead and Data analyst.
• Created database objects including tables, views, and indexes.
• Performance tuning of SQL queries by using Hints.
• Minimized the problems in ATM transactions by monitoring it and taking the necessary actions
• Generated statistical data by constructing and executing complex queries in oracle
• Provided support and adhoc reports to the Retail banking department regarding ATM

Environment: Oracle 10G, SQL*Plus, SQL, SQL*Loader, crystal Reports XI, UNIX, Toad

Confidential

Data analyst

Responsibilities:

• Worked as a Team lead for more than a year.
• While working in IT Department, acquired domain knowledge in retail operations enabling active support for all queries/problems of end users using banking application software
• Wrote PL/SQL Stored Procedures, Functions, Packages and SQL queries using join conditions as per business requirements.
• Implemented Extraction, Transformation and Loading using SQL Loader and PL/SQL.
• Worked on the various phases of implementation of Banking software such as: Business Process Reengineering, Gap analysis
• User Acceptance Testing: Key Member of the team, included work pertaining to creation of test scripts, test data, carrying out actual tests, interaction with implementation team of application software provider and User training
• Worked on the cut-over activities
• Production support to end users
• Service Desk
• I was the key person implementing Change management and Release Management
• Provided support to the business users for various process, configuration and data related issues by performing extensive troubleshooting
• Managed the service desk
• Created and maintained documentation
• Trained end users various times, created material and carried out in-house training

Environment: Oracle 10G, SQL*Plus, SQL, SQL*Loader, Crystal Reports XI, UNIX, Toad