PROFESSIONAL SUMMARY:

• Over 10 plus years of experience as a Data warehousing Consultant in Analysis, Design, Development, Testing, Administrating and System Maintenance of software applications and Business Intelligence (BIRT) projects in different environments using Business Objects/BI Suite Enterprise products namely SAP Business Objects 4.1, 4.0, XI R3/R 2/6.5.1/6.1/5.1.
• Worked on FACETS Systems for Healthcare Insurance experience across Claims, Membership, or Providers Data Marts using SAP BO
• Experienced on EPIC/Cerner system for Medical transactions and Data marts using BO
• Extensively worked on Crystal reports development and generated various reports using different data sources.
• Expertise working in Universe Design Tool (UDT) and Information Design Tool (IDT).
• Experience creating dash boards using Tableau 4.0
• Good exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support.
• Worked in various Heterogeneous Source Systems databases like MS SQL Server, Oracle, Sybase, Flat files and other Legacy systems.
• Experience in all aspects of project development life cycle in Data Warehousing.
• Expertise in gathering the business requirement and building Universes in the Designer, retrieving data using Universes, Personal data files, Stored procedures, Free hand SQL methods and creating complex Ad - Hoc Reports using Business Objects & Web Intelligence Tools..
• Involved in converting various Business Intelligence reports to SAP Business Objects.
• Involved in Migration of Business Objects 6.5 to higher versions BO XI-R2, XI-R3 Enterprise
• Worked on BO Upgrade project for converting BO XI 3.1 reports to SAP BO 4.1 in Delivery systems
• Worked on Grouping, Running totals, Summary reports, Charts, Report level variables using Crystal reports
• Experience in Performance Tuning of the Business Objects using various methods to ensure timely delivery of Critical Reports.
• Expertise in working with Business Objects Performance Management to create Dashboards and Analytics & Xcelsius
• Experienced in working on Agile, Scrum project methodologies and tracking the development tasks in JIRA & Rally tools
• Experienced in installing and Administrating of Business Object Server hardware and software products
• Worked with Developers to consolidate the Business Objects repository before migrating to higher versions
• Installed and configured different environments (DEV/TEST/UAT/PROD) with Business Objects XIR2/XIR3.2 with Apache and Tomcat as web and application servers
• Effectively administered and supervised the Business Objects environment by, monitoring/granting permissions and rights to users for viewing, creating and publishing reports.
• Knowledge about Business Objects Security Model and experience with Business Objects Security Implementation (Row level, Object level, Command level in both 6.5 and XIR 2).
• Having good knowledge on Informatica PowerCenter (versions 7.1/8.1/9.0), Mappings, Mapplets, Transformations, Workflow Manager, Workflow Monitor, Repository Manager, FACT Tables, Dimension Tables, OLTP, OLAP and Data Reports
• Documenting detail development procedures and coordinating other team members for collecting Meta data which is used in data dictionaries and other documentation to the users.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Extensively used SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.
• Effectively communicate with business, project manager and team members.
• Strong ability to work within a demanding and aggressive project schedules and environments.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative.

TECHNICAL SKILLS:

BI Tools: SAP Business Intelligence 4.1 Information Design Tool (IDT), Business Objects XIR3/R2/6.5.1/5.x (XI- CMC, CCM, Designer, WebI, DeskI) Crystal Xcelsius, Crystal XI, SSRS, QAAWS, Cognos 8.4.1, Microstrategy, SSRS, Report Express(RPX)

ETL Tools: Informatica Power Center 9.0,8.6, 8.1/7.1.2/6.2, Informatica Power Mart 6.2, Power Exchange, SAP BODS, Data Stage, SSIS 2005/2008 and Oracle Warehouse Builder (OWB)

Databases: MS SQL Server 2003/2005/2008, Oracle 11g/10g/9i/8i/7i, IBM UD2 DB2, Sybase SQL Server 11.0, MS Access 2000, Teradata, Netezza

Programming Languages: JAVA, .Net, SQL, PL/SQL, Perl, COBOL

Web Technologies: JavaScript 1.2, HTML 4.0, DHTML, JSP, Serve lets

Web/Application Servers: Apache Tomcat, Web logic, Web sphere

Others: Erwin 4.1.2/3.5.2, TOAD, SQL Developer, SAP Lumira, MS Office, Winscp(FTP), MS.Visio, Version Control SVN, Mercury Quality center(defects), Share Point, JIRA, Rally, Clarity, Collibra Data Governance

Medical Systems: FACETS, EPIC,CERNER, EDIFECS & EDI

Operating Systems: Windows NT 4.0, Windows 95/98/2000/XP, MS DOS 6.22

PROFESSIONAL EXPERIENCE:

Confidential

Lead SAP Business Objects /Business Intelligence Consultant

Responsibilities:

• Lead the development tasks in the projects and implemented successful roll outs to production with utmost satisfaction to the business customers
• Implemented FACETS changes to in ODS/GDS systems data mart Universe namely Claims, Underwriting, Sales, Members etc.
• Responsible for Designing, Developing Universe as per business requirement for various business like Medicare, Medicaid, MI Child etc
• Effectively implemented all ICD-10 changes to the all the Universes and Reports which was using ICD-9 values
• Successfully transition the Pharmacy Benefits Management (PBM) from Argus to ESI and changes updated in Universe and impacted hardcoded Webi reports
• Used 360eyes tool to conduct the impact analysis for changes in the existing Databases that impacts the Universes and reports list.
• Created dash boards using Tableau 4.0 for various sales reports for Small, Large and Individual business DASH reports.
• Created dash boards using Xcelsius for various domain reports in the organisation
• Experienced in working on Agile, Scrum and Waterfall methodologies project plans and tracking in JIRA, Rally
• Worked on JIRA, Rally and Clarity tools for Defect logging for support tasks.
• Worked with all levels of development process from the Analysis, Design, Development, Testing and Implementation the project
• Analyzed all the Facts and Dimension tables from the existing database and updating the Universes
• Leading the development team and taking responsibilities to develop the WEBI Reports development as per customer defined targets on weekly basis
• Developed stored procedures to validate the data files coming from various sources and helping to import the files into the Data warehouse system.
• Created Joins, Contexts, and Aliases for resolving Loops and checked the Integrity of the Universes.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects
• Worked with the Web team, App Dev team to understand the programming and design of large scale web based distributed systems in the Insurance applications and supplying the required report information.
• Promoting the Universe changes from Dev to Test using CMC. Creating BIAR files and import/Export to Dev/Test and Change control process to Production, creating the User groups, security groups and setting up the Connections for Dev/Test and production
• Preparing the impact analysis for any changes in Universe design for the completed reports
• Improved the performance and reduced the coding with the use of @functions (@aggregate aware, @select, @prompt, @where). Created complex reports using different data sources.
• Used Aggregate tables to increase the performance of the reporting system.
• Extensive use of drill down capabilities, drill through capabilities, dynamic visibilities, dynamic filter conditions
• Created complex conditions (Dates), Prompts and free hand custom SQL to create Derived tables in Universe. Defined logical classes and objects and hierarchies for analysis and drilling on hierarchies in the WEBI reports
• Responsible for creating /updating the documents changes in the System Wiki and loading the updated documents.
• Performing Unit Test for the reports and documenting the test cases and sharing with Quality team
• Resolved number of defects which was discovered during System/UAT testing.
• Created reports included formatting options such as Grouping, Sorting, Parameter prompts & Conditional objects.
• Experienced using Oracle ETL, RPX reporting and Apex tools and knowledge on Oracle Warehouse Builder (OWB) and Oracle Data Integrator (ODI)
• Implemented Sub Reports & dynamic cascading prompts for parameter passage.
• Created relevant Cross-Tab reports, Pie charts, Bar Charts, Line Charts for the reports.
• Implemented various complex formulas and filters to meet the complex report requirements.
• Developed ad-hoc reports and used various techniques like Master-Detail, Breaks, Filters, Slice and Dice, Ranking.
• Experience with SQL scripting and Relational Database modeling to build and develop the applciations and writing separate packages as per project requirements
• Implemented the creation of Hyperlink Open Document functionality to display Master-detail reports.
• Participated in the workshops for converting SAP BO XI 3.1 reports to SAP BI 4.1 version in GDS and Delivery System
• Gathering the updates in the projects and Keeping track of the daily work progress.

Environment: SAP BO 4.0, 4.1,IDT,UDT SAP BO XI 3.1/XIR2, SAP Lumira 1.25,Web Intelligence, Oracle 10G,11i, MS-SQL Server Management Studio 2008, Netezza, SQL Developer, COBOL and TOAD, Erwin, Tableau 4.0, Xcelsius, Informatica 9.1, Oracle Report Builder, FACETS, Windows 2003, JIRA, RALLY,RPX

Confidential, Kalamazoo, MI

Sr SAP Business Objects /Intelligence Consultant

Responsibilities:

• Worked closely with the Project Manager, Subject Matter Experts (SME’s) and the Business Analyst /Technical Lead to understand the requirements.
• Interacted with Business User’s to analyze the Business Requirements to transforming reports requirements to SAP Business Object reports using SAP ECC 6.0 Business Data warehouse
• Conducted detailed feasibility study for existing Cognos reports, dash boards and to provided the solution to recreate in SAP Business Objects
• Responsible for Designing, Developing Universe as per business requirement.
• Worked with all levels of development process from the Analysis, Design, Development, Testing and Implementation the project
• Analyzed all the Facts and Dimension tables from the existing database.
• Leading the development team and taking responsibilities to develop the WEBI Reports development as per customer defined targets on weekly basis
• Analyzing the Cognos Architecture, Design & Modeling and Developed the BO Universe as per client requirement
• Developed stored procedures to validate the data files coming from various sources and helping to import the files into the Data warehouse system.
• Creating stored procedures to load and populate the data from centralized PGSDW source system to SFMIS reporting system
• Created Joins, Contexts, and Aliases for resolving Loops and checked the Integrity of the Universes.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects
• Maintaining the Universe tracker to record the Universe level changes and maintaining the backup of the Universe for each change control.
• Promoting the Universe changes from Dev to UAT, Test environment as per the Confidential defined compliance document.
• Experience with SQL scripting and Relational Database modeling to build and develop the applciations and writing separate packages as per project requirements
• Preparing the impact analysis for any changes in Universe design for the completed reports
• Created Cascading Prompts to meet the customer specific requirements
• Improved the performance and reduced the coding with the use of @functions (@aggregate aware, @select, @prompt, @where). Created complex reports using different data sources.
• Used Aggregate tables to increase the performance of the reporting system.
• Extensive use of drill down capabilities, drill through capabilities, dynamic visibilities, dynamic filter conditions
• Created complex conditions (Dates), Prompts and free hand custom SQL to create Derived tables in universe. Defined logical classes and objects and hierarchies for analysis and drilling on hierarchies in the WEBI reports
• Worked on Oracle ETL, RPX reporting and Apex tools to build the Confidential Data warehouse system
• Creating request to migrating Universes, Reports, Securities from the Development to Production environment after System Integration Testing(SIT) and then followed by User Acceptance Testing(UAT).
• Responsible for creating documents for RSV and Combo documents and loading the updated documents in PDOCS
• Performing Unit Test for the reports and documenting the test cases and sharing with Quality team
• Resolved number of defects which was discovered during System/UAT testing.
• Created reports included formatting options such as Grouping, Sorting, Parameter prompts & Conditional objects.
• Implemented Sub Reports & dynamic cascading prompts for parameter passage.
• Created relevant Cross-Tab reports, Pie charts, Bar Charts, Line Charts for the reports.
• Created column charts, Alerters, Line charts and Gauge charts using Xcelsius.
• Converted the Excel data in to Chart format using Xcelsius and created the various charts as per the client requirement using single value, map and selector.
• Implemented various complex formulas and filters to meet the complex report requirements.
• Developed ad-hoc reports and used various techniques like Master-Detail, Breaks, Filters, Slice and Dice, Ranking.
• Implemented the creation of Hyperlink Open Document functionality to display Master-detail reports.
• Responsible for migrating BOXIR2 to BOXIR3, upgrade from Business Objects XIR2 to XIR3.1 with repository migration tool and Import Wizard of BO users, Groups, Folders, Universes and Reports in XI R2
• Worked with LCM(Life Cycle Manager)in migrating universes and reports from Dev to Test/UAT and Production
• Published Reports to CMC (Central Management Console) and involved in Scheduling and exporting the reports in different Formats.
• Worked on aggregate awareness to ensure the query is pulling correct level of aggregation.
• Created necessary transition documents and conducted Knowledge Transfer sessions to ensure smooth transition
• Participated in the workshops for converting BO XI 3.1 reports to BI 4.0 version in PGSDW
• Working as Lead Co-coordinator for Offshore team and clarifying the issues after discussions with the SME’s and client business managers.
• Gathering the updates in the projects and Keeping track of the daily work progress.
• Maintaining the status reports and Passing on the Requirements required towards the project related reports.

Environment: SAP BO XI 3.1/XIR2 SP3,BO 4.0, Web Intelligence, MS-SQL Server Management Studio 2008, Oracle 11g, OWB,Informatica 9.0, Crystal Xcelsius, Cognos 8.4.1, Windows 2003, Apache Tomcat and TOAD, Erwin

Confidential

Java/Oracle/Business Objects / Crystal Report Consultant

Responsibilities:

• Worked closely with the Project Manager, Subject Matter Experts and the Business Analyst /Technical Lead to understand the requirements.
• Interacted with Business User’s to gather and analyze the Business Requirements to build the reporting applications.
• Worked and build Java SWC application for replacing the existing cost share programme and build the contract and Payment Modules
• Responsible for Designing Universe, WEBI Reporting, Xcelsius dashboards, Crystal Reports. Also performed admin responsibilities like migration of WEBI Reports from BOXIR2 to BOXIR3, upgrade from Business Objects XIR2 to XIR3.1 with repository migration tool and Import Wizard of BO users, Groups, Folders, Universes and Reports in XI R2.
• Analyze Crystal Reports in XI and the sequel queries behind these reports by looking at the database expert, preparing the requirement documents as specifications for the Universe development.
• Designed and developed Universes using Business Objects Designer for ACSP/CCAP.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Improved the performance and reduced the coding with the use of @functions (@aggregate aware, @select, @prompt, @where). Created complex reports using different data sources.
• Used Aggregate tables to increase the performance of the reporting system.
• Interacted with SAP -BEACON Team to collect the Information for report requirements and generating business reports using BO XI WebI
• Creating and populating data in the tables with in the data systems for external sources.
• Created Sales reports for contracts created in the fiscal year for each county wise and funding source wise based on monthly & weekly basis
• Created the utilization of Financial reports for each contract, county, funding source wise for generating the balances for each county
• Created various reports with multiple data sources, dynamic cross tabs and drilldowns using various Business Intelligence tools like WebI and DeskI.
• Created WebI reports like Approved Contracts, Pending Contracts, Completed contracts, Payment Approved, Payment Pending, Maintenance contracts & closed contracts.
• Imported and exported reports to and from repository.
• Created Webi Reports using Webi Rich Client tool with Excel as Data Source for legacy system data in XI 3.1
• Scheduled the reports through Infoview, Monitoring and converting Reports to text file.
• Extensive use of drill down capabilities, drill through capabilities, dynamic visibilities, dynamic filtering, scorecard components, containers, combo boxes, list views, complex excel logic, highly formatted excel model with defined naming conventions for design of these complex dashboards
• Responsible for documenting the whole Contract process.
• Documenting detail development procedures and coordinating other team members to collect Meta data which is used in data dictionaries and other documentation to the users.
• Unit Testing is performed on Dashboards, Reports and Universe using JIRA issue tracking system and updated the results in JIRA system.
• Migrated Universes, Reports, Securities from the Development to Production environment after System Integration Testing(SIT) and then followed by Business Acceptance Testing(BAT). Used Import Wizard for the Migration process across the environments.
• Administer and supervise the BO environment by monitoring/granting permissions and rights to vast users, creating and publishing reports and implement Folder and object level restrictions.
• Used different Web services like QAAWS to make a live connectivity between the Crystal Xcelsius Dashboards and BO Enterprise 3.1.
• Importing the groups and users from windows Active Directory into Business Objects and granting the users and groups with appropriate rights trough Central Management Console.
• Administer and supervise the BO environment by monitoring/granting permissions and rights to vast users.
• Involved in the Single Sign-On (SSO) application team for the Operations Updates project and used the BO SDK to accomplish this task
• Validated the installation by checking the public folders, Reports in Personal folders, Groups, Row level security, Scheduling and by running some sample reports.
• Resolved number of defects which was discovered during System/UAT testing.
• Created standard reports to meet business requirements using Crystal reports for getting sign off firms from the cooperators.
• Developed various Business requirement forms for day to day operations for Payments, Contract submissions, Govt mandatory forms using Crystal XI.
• Generated custom reports on approved contracts, pending contracts, approved payments, pending payments, available funding sources using Crystal XI reports for end user requirements.
• Created charts for completed contracts, pending contracts, used amounts and unused amounts using Crystal report
• Created sub-reports and linked with the main report using Crystal report for displaying contractor information
• Extensively created report level variables and formulas to meet the customer requirement in Crystal reports
• Developed the payment forms, contract forms using crystal reports.

Environment: Business Objects XI 3.1/XIR2 SP3, Web Intelligence, Crystal Reports 2008, MS-SQL Server Management Studio 2008,Oracle 10g, Windows 2003, Apache Tomcat and TOAD, Erwin, SQL, PL/SQL, MS Access 2000

Confidential, Phoenix, AZ

Reporting Consultant/SAP BO/Oracle

Responsibilities:

• Analyzed the existing database and designed the Universes using Business Objects Designer Module.
• Created over 30 Classes and more than 300 objects using inner/outer joins based on user requirement.
• Responsible for presenting the Data Warehousing concepts and tools to their prospective clients
• Generated various reports as per the client's requirements for day today business requirements
• Created Universe, Classes, Objects, Measure Objects, Conditions, Joins
• Improved the performance and reduced the coding with the use of @functions (@aggregate aware, @select, @prompt, @where). Created complex reports using different data sources.
• Involved in resolving the loops, cardinalities, contexts and checked the Integrity of the Universes.
• Published reports to users to their e-mail addresses.
• Migrated Universes, Reports, Securities from the Development to Production environment after System Integration Testing(SIT) and then followed by Business Acceptance Testing(BAT). Used Import Wizard for the Migration process across the environments.
• Administer and supervise the BO environment by monitoring/granting permissions and rights to vast users, creating and publishing reports and implement Folder and object level restrictions.
• Used different Web services like QAAWS to make a live connectivity between the Crystal Xcelsius Dashboards and BO Enterprise 3.1.
• Importing the groups and users from windows Active Directory into Business Objects and granting the users and groups with appropriate rights trough Central Management Console.
• Administer and supervise the BO environment by monitoring/granting permissions and rights to vast users.
• Involved in the Single Sign-On (SSO) application team for the Operations Updates project and used the BO SDK to accomplish this task
• Worked with supervisor module in creating users and users groups for different areas and setting privileges to them.
• Creating reports using SAP ERP ECC Business Warehousing data as source, and preparing the various reports for the different modules data combining and displaying in the WEBI reports
• Created various sales report for Sales office, Plant, Distribution channel report depends on the Material wise sales Utilization.
• Trained the users in Business Objects and in using the newly developed universe and in Report writing by Using Query Panel and Slice & Dice etc.
• Created numerous functional PL/SQL triggers on tables for testing.
• Responsible to support the production issues with reports on the Business Objects enterprise environments.
• Responsible for documenting the whole process and sharing the documents in the Enterprises Share Drive
• Attending weekly/Monthly progress meetings and discussing the various issues and providing the updates on Universe / report developments progress.

Environment: Business Objects XIR2, SQL, PL/SQL, SQL Loader, Windows 2000/NT, MS-SQL Server 2005, ORACLE 8i,