SUMMARY

• Over 8 years of experience in IT Industry in analysis, design, development, implementation, testing and maintenance of Data Warehousing applications in Pharmaceutical, Retail and Energy & Utilities industries.
• Experience in providing solutions in Business Intelligence (OBIEE, Tableau) Data warehousing and Master Data Management using Informatica Power Mart/ Power Center and Informatica MDM (formerly Siperian)
• Experience in Software Analysis, Design, Development, Testing and Production Support using Oracle, Green Plum & VectorWise databases
• Experience in developing OBIEE Dashboards, Tableau Dashboards & BIP Reports with scheduling
• Experience in developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Informatica Power Center 8.6/9 and Power Mart 5.1
• Experience with MDM suite using Siperian XT SP2, Siperian XU, Informatica MDM Multi domain Edition 9.0.1 and Informatica MDM multi domain Edition 9.7.1.
• Experience in full life cycle development of Data warehousing
• Experience in Repository Administration and Performance Tuning.
• Implemented complex business rules in Informatica by creating re - usable transformations, and robust mappings/mapplets.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Experience in configuring MDM Data Model, Stage Process, Load Process, Match & Merge Process, Batch Processes and User Objects
• Experience in MDM Kalido for data loads
• Knowledge in building MDM Trust Frame Work and Validation Setup
• Experience in defining MDM Relationship Types and Lookups
• Experience in creating Cleanse Functions, Conditional Execution Components, building Mappings, Re-usable Cleanse Components and configuring Delta Detection and Audit Trail Settings
• Experience in defining Match Columns for Fuzzy and Exact Match, Match Rules,
• Merge Settings, Match Key Distributions and Primary Key Matching and External Match.
• Experience in creating MDM Queries
• Experience with MDM Merge Manager and Data Manager to view Merge/Unmerge the data.
• Experience in configuring Batch Groups, execute jobs from Batches tool (Batch Viewer) and calling Stored Procedures.
• Experience in automating the Power Center Sessions and MDM Batch Jobs using automated tools like UC4 and Autosys
• Knowledge using SQL, PL/SQL Procedures, Functions, triggers and Exceptions
• Knowledge in working with web servers such as Web logic and Tomcat
• Experience with UNIX Operating System, shell scripting to perform job scheduling
• Excellent problem solving skills with a strong technical background and good interpersonal skills

TECHNICAL SKILLS

BI Tools: OBIEE 10g/ 11g, Tableau v8/ v9, OOD, BI Publisher, QlikView (Support).

ETL Tools: Informatica Power Mart 5.1, Power Center 8.1/9.1, Talend

MDM Tools: Informatica MDM 9.0.1

Databases: Oracle 8i/9i/10g.

Languages: SQL, PL/SQL.

Scheduling Tools: Autosys, UC4

Web Technologies: HTML, XML.

Operating Systems: Windows 2000, XP, 2007, UNIX

Applications: MS-office.

Other tools: SQL *Plus, Toad, PL/SQL Developer.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

BI Project Lead

Responsibilities:

• In the role of Project BI Lead, I am responsible to understand the business requirements and deliver new/Enhanced high quality DI solutions to clients in response to varying business requirements.
• Responsible for effective communication with the client, Provide weekly project status to the stakeholders
• Build the MDM mappings, various Address and Specialty Cleanse functions and Address Standardization using Address Doctor(AD5) cleanse functions, Conditional Execution Components (CEC) all the other required components to meet the business requirements from various source systems staging data(Talend ETL) load all the way to Base objects
• Build the new match rules, match columns, match rule sets, trust set up and validation rules to satisfy the business requirements and enforce valid and good matching.
• Build the unit test scripts for end to end development, did end to end System test and verify if the results meet the requirements.
• Explore Address doctor AD5 function to test various input and output ports to determine best options to retrieve maximum level of details like GEO codes, latitude, longitude... Etc.
• Utilized the’ MDM Wrapper’ feature to customize the Vertex batch jobs command line execution with the Talend executor and scheduler
• Migrate the MDM code from Development environment to Test and finally deploy the code into Production according to the project timelines.
• Customize the XML code (SOAP UI calls) according to the business requirements and assist the team in timely manner to help their SIF interface testing.
• In the current role, responsible to prepare and review L0/L1/L2 estimates, IDR (Initial development request), TRD (Technical requirement document) and TDD (Technical design documents)
• Have done project management from organization stand point.
• Captured the business requirements, worked on different services and delivered the requirements within the time lines.
• Extensively worked on Tableau Application to deliver the reports as per the requirements
• Migrated SAP BO reports into Tableau Reports also Migrated into Tableau Server & schedule the reports accordingly.
• Created the Tableau, OBIEE - BIP reports & Schedule the reports as per the end users requirements.
• Applied Tableau Security for tableau reports
• Updated the BI Publisher Data models with SQL with post-test analysis migrated in to Pre-Production environments. BI Publisher scheduling is also implemented.
• Providing resolutions for all types of issues like.. Data, report, access & performance etc...
• Effectively deployed all types of operational & enhancement change request activities as per the markets requirement.
• Addressed Daily, Weekly Service Review meetings, also technical calls on major issues
• Responsible for on time and bug free delivery and worked closely with end user to support UAT
• Proactively taking up charge on Incident and Problem management activities
• Following the 3 week sprint and attending daily scrum meeting and updating the daily status
• Communicating effectively and working closely with offshore development team to complete end deliverables on time with quality.
• Good Experience on migration of SAP BO reports into Tableau Reports.
• Wrote complex sql queries on ERP tables to source DWH for both customized OBIA and Tableau reporting
• Worked on data level and object level security implementation
• Worked on creating analysis, dashboards and various types of views including charts, tables, pivot table, narrative views & static text

Environment: OBIEE11.1.1.7, Tableau 8.x/9.x Informatica MDM 9.7.1, Siperian XT, Oracle 11g, SQL Developer, SOAP UI 5.0.0, UNIX, Windows XP.

Confidential

BI lead

Responsibilities:

• Played a role as Technical Team lead for Confidential Delivery & Support Service Team
• Captured the business requirements, worked on different services and supporting the end users across the global.
• Investigating the issues technically and replicating the issue with RCA from our end. Providing resolution to end user with in time lines
• Monitoring the ETL workflows for data loads and Daily ETL load checks circulating the status to the respective markets Admin’s.
• Loading monthly data loads from respective various regions by using MDM/ Kalido
• Start up and Shut down the OBI Application services by Enterpriser Manager & Web Logic console.
• Monitoring the Remedy and assigning tickets to respective reporters.
• Extensively worked on OBIEE Application to support the end user with their issues on Confidential standard reports and regional reports
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Admin experience on Enterprise Manager Console in OBI 11g & Risk Management Skills.
• Scheduled the MDM Jobs and followed match & merged Process.
• Created groups & app roles in EM console and build up the relationship between the app roles and groups
• Preparing documents for deliverables like solution approach, technical specification, technical design, Unit test plans and results etc.
• Esteem good knowledge on OBIEE Coding skills.
• Enhanced out of box (OBIA) and customized Informatica mappings and workflow and OBIEE RPD to implement new requirements
• Providing resolutions for all types of issues like... data, report, access & performance etc...
• Effectively deployed all types of operational & enhancement change request activities as per the markets requirement.
• Arise valid points in Monthly and Weekly technical review calls on major issues.
• Proactively taking up charge on Service Request, Incident and Problem management calls
• Setting the visibility matrix - permissions set up during the application release in all pre-production environments with co-ordination of development team.
• Played a role as a SPOC during the application release and upgrade times

Environment: OBIEE 10.1.3.4.1 & 11.1.1.6.2/9/11 and Oracle 10g, Windows XP, SQL developer.

Confidential

Offshore BI Senior Developer

Responsibilities:

• In the role of Offshore BI Senior Developer was responsible to understand the business requirements and deliver new and complex high quality solutions to clients in response to varying business requirements.
• Worked as OBIEE Senior Developer in ENU Domain
• Captured the business requirements, worked on gap analysis, and prepared the gap analysis document.
• Involved the technical specification document based on the FRS documents
• Extensively worked on OBIEE Administration Tool for Customizing and modifying the physical, business, and presentation layer of the repository
• Implemented Time Comparison and calculation measures in the business model using Time series of data
• Developed the level based and ragged hierarchies in BM layer in .RPD which helps for to create pro-rated reports in OBI analysis
• Developed the logical tables, columns in BMM layer in .RPD
• Performed Repository Testing and validation before exposing Business Models in the Presentation layer
• Pro-actively done Cache Management activities
• Developed the KPI’s, KPI’s Watch lists, KPI’s Scorecards, and Marketing Segments as per client requirement in Analytics
• Developed different kinds of views (pivots, charts, tabular) using Filters. And developed the Master Detail Linking and also the Briefing Books etc…
• Maintained effectiveness in creating the dashboards by appropriately using the dashboard objects and setup the visibility of dashboards to employees with respect to their responsibilities.Applied security for different web groups based on responsibilities.
• Developed Role-Based Dashboards for Managers and Business Heads to review the Forecasts vs. Revenues and customer relationship manager to analyze the Forecasted item statistics for different campaigns, Customized pre-built dashboards
• Hands on knowledge to build data models in presentation layer as per the client’s requirement
• Responsible for effective communication with the client, Provide weekly project status to the client
• Created Schema objects like Indexes, Views, and Sequences
• Developed ETL procedures to transform the data in the new target tables according to thebusiness rulesandfunctionality requirements
• Designed and developed the OBIEE Metadata Repository (.rpd) using Oracle Business Intelligence Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions (Drill-down Hierarchies) & Logical & Facts Measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer.
• Worked on data level and object level security implementation
• Worked on creating analysis, dashboards and various views including charts, tables, pivot table, narrative views, static text etc.…
• Communicating effectively and working closely with offshore development team to complete end deliverables on time with quality.
• Sharing the functional and Technical knowledge gained with the team.

Environment: OBIEE 11.1.1.5, Oracle 10g, Windows XP, SQL Developer, Toad.

Confidential

BI Developer

Responsibilities:

• In the role of BI Developer at start of project, responsible to understand the business requirements and deliver new and complex high quality solutions to clients in response to varying business requirements.
• Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Oracle BI Analytics Platform
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer, also created hierarchies, variables, along with various business models and event poll strategies in the repository
• Used the security settings in BI Administration Tool to set up Groups, Access Privileges, and Query Privileges and managed security for groups in OBI Answers.
• Created Dashboard prompts and criteria prompts for better understanding of the trends and projections.
• Implemented Time Comparison and Calculation Measures in the business model using Time Series Wizard and modeled slowly changing dimension data.
• Developed different kind of reports (Pivots, Charts & Tabular) using filters
• Configuring Interactive Dashboards with Drill-Down capabilities using Filters and Dashboard prompts, OBIEE Security Setup (groups, access privileges), Metadata objects and Web Catalog objects (Dashboard, Pages, Folders, Reports).
• Implemented prompts to provide dynamic filters
• Providing object level security for different web groups based on responsibilities
• Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Oracle BI Analytics Platform
• Handled all customer meetings and sent the minutes across and delivered all the BI tasks as per the project plan
• Monitored Informatica Power Center workflows and shared the status timely to customer.

Environment: OBIEE 10.1.3.4, Oracle 10g, Windows XP, Toad