SUMMARY:

Confidential is a Data Warehousing Consultant that has more than 13 years of rich Data Warehousing and Business Intelligence experience on various domains and platforms across multiple geographies.

SKILLS:

SAP Business Objects (4.2/3.1/XIR 2/6.5/5.1/5.2 ): WebIntelligence, Universe Designer, IDT, Crystal Reports Enterprise (2008/2011/ Enterprise Edition), SAP HANA, CMC, Publications, Server Administration, APOS, Sherlock

OBIEE: Reports/RPD Developer, Admin (Server Administration/Branding)

Dashboard: Tableau, Spotfire, Design Studio, Xcelsius

ETL: Informatica

DataWarehousing: Data Analysis, Data Modelling (3NF, Fact/Dimensional), SQL, PL/SQL, Teradata, Microsoft SQL Server, Unix, Linux, TOAD, SQL Developer

Project Management/Testing Tools: Microsoft QC, HP, Service Now, JIRA, Clear Quest

EXPERIENCE:

Programmer Analyst

Confidential, Austin, TX

Responsibilities:

• Analyzing the legacy system reports and coming up with Technical design documents for the reports
• Worked for the Mental Health Integration Project for Substance Abuse and Behavioral Health Data Analysis
• Aware of the ICD 10 and DSM 5 codes that are used to categorize Health Conditions for Insurance and Healthcare providers
• Creating queries and analyzing the data and comparing it with the legacy system data to make sure that the reports look similar
• Providing more flexibility to users with the capabilities provided by the WebIntelligence functions
• Created Complex WebIntelligence Reports with the help of Multiple Data Providers and complex report level Variables
• Modified existing Universe to support the new report requirements and also checked the integrity of the Universe to make sure none of the existing objects/definitions were modified
• Involved in preparing the documentation for the reporting purposes and assisting in Beta testing phase of the project
• Coordinate with Business Users and Translate the Business requirement to technical solutions

Programmer Analyst

Confidential, Columbus, GA

Responsibilities:

• Analyzing the existing Universes to validate the Impact of the Confidential Changes in the current Prod System
• Creating queries and analyzing the data and data mapping to come up with a solution for the Confidential Changes
• Minimizing the rework/maintenance on the Universes by coming up with an optimal solution
• Modified the Universes in both the Universe Design Tool (UDT) and Information Design Tool (IDT) for the Confidential Changes
• Implemented the solution using the Master/Derived Universes concept
• Involved in the Unit Testing and UAT phase of the project
• Modify the existing 70 + Universes with the Confidential Changes
• Created Derived tables in the Universe to have Customer queries for reports as per the User Requirements
• Used Aggregate Awareness in the Business Objects Universe when using multiple Fact tables along with Aggregate Navigation
• Created new Dimension Objects for further enhancements that came during the discussions with the Business Users
• Extending the existing Contexts and creating new Contexts for the new requirements for Single Bank
• Worked on Spotfire to create some Management Level Dashboards across different KPI’s
• Worked on Spotfire (Evaluation Phase) to create Dashboards for higher management which was out of scope for the project

Programmer Analyst

Confidential, Tampa, Fl

Responsibilities:

• Working as a BO Administrator and supporting both the Current (BO 4.1) and Legacy (BO 4.0) system
• Handling failures of BO Scheduled Jobs using Failure notifications, Event Based triggers for Sequential Job scheduling and Email notifications for Publication Job completion.
• Creating and Modifying WebIntelligence Reports as per the User Requirements
• Creating Users to access the BO system and providing them with the correct access by creating the appropriate groups and providing the corrects rights and restrictions
• Handling Servers by creating new Services to accommodate specific Jobs during the Month End activities when the data volumes are high
• Providing Training sessions to front end users as to how to build Reports using WebIntelligence and creating Report level Variables
• Establishing Connectivity to new Servers hosting Database Sources for new Reporting Requirements
• Created Dashboards using Tableau for a POC Initiative for evaluating a Dashboarding tool for Higher Management reporting
• Resolving issues with Universes built on Information Design Tool and Universe Design Tool as there was a lack of expertise in the company

Programmer Analyst

Confidential, WestBend, WI

Responsibilities:

• Creating and Modifying WebIntelligence Reports as per the User Requirements
• Working on JIRA tickets which were assigned as small projects and following the whole SDLC life cycle process before moving it to Production
• Working Simultaneously on Operation and Development tasks based on what the priority is set
• Working with the ETL team in understanding the Data Extraction process
• Modifying Universes for the new Report requirements and also modifying existing Reports to accommodate new requirements
• Working with Business Analysts in gathering requirements and involving them in Discussions with Business Users
• Translate Business Requirements into Technical Solutions for reporting purposes

Senior COnsuiltant

Confidential, Dallas, TX

Responsibilities:

• Involved in the Design and Solution part of the CII 2.0 Application from a technical perspective
• Working with the Business Analysts in clarifying gaps in the Functional Documents and also recommending best solutions as per the needs
• Designed the Hi - Performance universe by Business Objects data model, selecting/joining tables, indicating cardinalities, created aliases to resolve the loops, used Aggregate Aware function and created the objects which are grouped into classes based on Business Functionality.
• Implemented User Level Access Security in the Universe
• Understanding of the HL7 standards that are utilized for clinical data and administrative data used by multiple healthcare providers
• Worked as Team lead and working with Offshore team to enable 24/7 support for the Project.
• Co-ordinating and Assigning tasks to team members and setting expectation as per the priorities and deadlines set by the project timelines
• Worked on creating a strategy as to how to run the Publications and making sure the Performance was not affected.

Senior COnsuiltant

Confidential, Denver, CO

Responsibilities:

• Contributed to successful transition of the project from Development to the AMS team
• Supporting the Europe Activities related to the Dock and helping the Europe Business with a Business Understanding of the Report Calculations and other functionalities
• Interacting with the Business Users and gathering requirements for Report Enhancements
• Created a few Dashboards using Tableau for the POC purposes which pulls data from multiple sources
• Creating complex dashboards using charts and tabular formats on Tableau
• Was the only resource from the Client location with expertise on OBIEE and also worked as an Onsite lead in gathering requirements and making sure the offshore team understands them well and the technical implementation is done efficiently
• As a Team lead was also responsible with the team deliverables from both EU and US Support perspectives
• Managing CR’s and aligning them for each release and sharing the same with the client for approvals and other processes
• Configuring new environments and also customizing the OBIEE application with the branding as per Prologis standards
• Created Drill-Through reports to provide users with more detailed information and query linking.
• Configuring LDAP functionality to enable SSO authentication

Senior COnsuiltant

Confidential, Santa Monica, CA

Responsibilities:

• Playing a Team Lead role Involved and making sure all the Project Deliverables are made
• Involved in preparing the processes involved for the Support Engagement
• Worked on Resource allocation at different phase of the project
• Minor Enhancements in the Dashboards as per the requirement
• Minor Enhancements in repository
• Gathering new requirements from the Business Users and coordinating with the team to have them in the Reports
• Providing optimal solutions which is out of scope of the Project and meet the client requirements
• Coordinating with the Onsite team and resolving gaps that are required for the Reporting purpose
• Coordinating with the ETL team on the changes to be made to the ETL Dataflows for the new requirements
• Involving in client discussions for new Requirements and proposing efficient/scalable solutions.

Senior COnsuiltant

Confidential

Responsibilities:

• Involved in creating/Modifying Technical Specs as per the Functional Specs provided by the client.
• Develop Unit Test Scripts required for the reporting
• Created and managed Universes in the Universe Designer.
• Created the WebIntelligence reports using universes as the main data provider.
• Created Aliases and Contexts for solving the join problems in Business Objects.
• Created Hierarchies and Predefined Conditions using Business Objects.
• Exported the Universes to the Repository to make resources available to the users
• Created user Conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report
• Formatted the WebIntelligence Reports to the Users Requirements using all the requirements in Business Objects like Slice and Dice, Drill down, @ Functions and Formulas etc.
• Minor Enhancements in the BO Universe as per the requirement
• Develop WebIntelligence Reports as per the requirement
• Coordinating with the Onsite team and resolving gaps that are required for the Reporting purpose.
• Published reports using Info view, and trained end users for ad hoc reporting.