SUMMARY

• Dynamic, self - motivated and results oriented BI professional with a strong passion to enable Businesses to leverage the power of BI and IT via data mining and process improvements
• 12+ years of IT experience in Design, Modeling, Development and Testing of Data warehouse applications
• Specialties: Analytics, Business Intelligence, Dashboard and Mobile.
• Disciplines: Manufacturing, Semi-conductors, Retail, Utilities, Bio Tech, Pharmaceuticals, Insurance.
• Functions: Finance, Sales & Marketing, Human Resources, Customer Service
• Strong experience with Relational and Dimensional Data bases.
• Responsible for full life cycle ofreporting solutions including developmentand maintenance of reports and databases.
• Successfully Planned, Tracked, Designed, Developed and implemented web/reporting projects.
• Experience in creating Databases, Tables, Indexes, Stored Procedures, T-SQL in SQL Server 2005/2008/2012
• Experienced with Microsoft Reporting and Web technologies, SQL Server 20xx, SSRS, and DTS.
• Experienced in developing Custom Reports and different types ofReports,and distributing reports in multiple formats using SQL Server Reporting Services (SSRS).
• Experienced in SQL Server DTS package design, Configuration, Deploymentand Scheduling packages
• Experience with Data Cleansing and Loading, Performance Tuning, Reporting, Backup & Recovery, SQL Query Tuning and developing complex stored procedures and functions in T-SQL.
• Excellent experience with different types of reports including Operational and HR reports.
• Experienced with SAP ASAP methodology for BI implementations. Experience with Agile and Waterfall models for delivering Data Mart projects, focused reporting projects and dashboard projects.
• Experienced with SAP Business Objects 4.2, Business Objects 4.x/ XI3.1 / XI-R2 /6.x /5.x, Crystal Reports, Design Studio, Xcelsius (Dashboards), SAP Lumira (SAP Visual Intelligence), Tableau, SAP HANA, SAP BW, SAP Rapid Marts (SCM & Finance - COPA, AR, AP, GL, Cost Center, SPL Management Ledger ), SAP BEx Query Designer, SAP BEx Analyzer, BICS, Translation Tool.
• Strong Dashboard presentation and design skills, including designing Enterprise Level Dashboards
• Experienced in architecture design of Extraction, Transformation & Loading environment using Informatica 6.1 / 8.6 and Data Integrator XIR2, SAP Data Services.
• Proven excellence in SAP Business Objects 3.1/4.x & BW Integration skills. Multiple implementation experience, including, troubleshooting integration issues
• Excellent OLAP Cube Building experience using Business Objects Designer.
• Expertise in dimensional data modeling, Star Schema Modeling, Snow Flake Modeling, fact and dimensional table design, physical and logical data modeling using Erwin
• Experience as Data & BI Architect, Team Lead and managing onsite and offshore teams.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
• Certified Trained in MACESS application by SunGard.

TECHNICAL SKILLS

Tools: DTS, SSIS, SSRS

Business Intelligence: Microsoft Power BI, SAP BI/BO Integration, Business Objects 4.2/4.x/3.1/XI-R2/6.X/5.1Broadcast Agent, ZABO, LCM, Dashboard Manager, Crystal Xcelsius, SAP BW, SAP BEx Analyzer, SAP BI Mobile, Tableau.

Data Modeling Tools: Erwin 3.5.2/4.1, Star-Schema Modeling, Snowflake Modeling

ETL Tools: SAP Data Services, Data Integrator XIR2, Informatica (Source Analyzer, DW designerMapping Designer, Mapplet, Transformations)

Database: MS SQL Server 2000/2012, Oracle 12C/11g/10g/9i/8i/7.x, MS Access, SAP ECC

Reporting Tools: SSRS, Crystal Reports XI-R2, COGNOS Report Net

Languages: SQL, PL/SQL, XML, HTML, Java, Java Script

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

MS SQL Server Developer/SSRS/SSAS/ SAP Consultant / Tableau

Responsibilities:

• Identify restrictions (600+) and analyze options to automate security rather TEMPthan manual intervention in the universe.
• Build BU Dashboard for Executives. Manual, Performance testing on the Dashboard.
• Bring in Novartis data in to existing database using SAP Data Services.
• Modify existing universe to report against integrated data.
• Build new reports off integrated data.
• Update security design (data availability) to business needs.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Designed a new schema for the Data Mart databases.
• Implemented SSAS Cubes, Facts and Dimension tables to perform analysis.
• Created Multi-Dimensional Expression (MDX) queries to extract data from the Data Mart.
• Use Data Analysis Expressions (DAX) to create tabular model projects (cube).
• Generated Dynamic reports from Cubes (SSAS) using SSRS.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.
• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
• Used HTML code to make Report manager more functional & customizable.
• Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning

Environment: Microsoft SSIS, SSAS, SSRS, SAP Business Objects 4.2 SP3, SAP Business Objects 4.1 SP 6 (CMC, UDT, IDT, BI Launchpad, Dashboards, Design Studio), SAP Data Services, Oracle 12C, 11g - MViews, Tableau 9.3 / 10.0.2.

Confidential, San Francisco, CA

Business Intelligence Consultant / PL/SQL Developer / Tableau

Responsibilities:

• Responsible for complete back end and front end development from Database Design, Report Development and Maintenance.
• Developed front end interactive reports and dashboards using Stored Procedures, SSRS, Excel data tools.
• Developed SSRS reports like a Dashboard with parameterization to show KPI’s like # of Open Tickets, Severity, etc. User specific reports were created to show # of tickets open.
• Scheduled the distribution of reports to managers to get updates on tickets daily
• Identify tables required to build the ODS/ QM Data Mart.
• New reporting tables/procedure on the MACESS (OLTP) Reporting database created dynamically in order to support the QM Data Mart; further to support the Grievance and Appeals reports.
• Create new data model on OLTP system and populate data with incremental procedures.
• To support the new QM-G&A reports, the new QM Data Sets are created, and the new Professional Services (PS) reports.
• Involve in PE2E, DMX reporting project for delivery of reports.
• Develop visualizations on Tableau

Environment: Microsoft SSIS, SSAS, SSRS, Business Objects 4.0 SP06, Tableau, Microsoft SQL Server 2008 SP06 EE, MS SQL Server 2012 Management Studio, Windows XP, Microsoft Excel 2010, Sungard (MACESS) application, Agile, Oracle 10g.

Confidential, Monrovia, CA

Business Intelligence Developer / Dashboard Developer

Responsibilities:

• Gather the business requirement and build functional / technical documents.
• Identify tables required to extract data using Microsoft SSIS.
• Build cube using Microsoft SSAS.
• Develop reports using Microsoft SSRS.
• Identify the executive KPI dashboards & management reports and develop semantic layer using Information Design Tool.
• Develop Grants KPI dashboards using Dashboards 4.0 SP06 to accommodate Super User and Departmental User access the data.
• Create groups, assign, and develop security setup data Confidential row level in IDT and folder level security in CMC.
• Use Promotion Management tool move Dev to QA / UAT.

Environment: Dashboards 4.0 SP06, Business Objects 4.0 SP06, Microsoft SSIS, SSAS, SSRS, Microsoft SQL Server 2012, Windows 2010.

Confidential, Indianapolis, IN

SAP Business Objects Consultant

Responsibilities:

• Identify tables required to extract data using SAP Data Services based on the BURT process and load in to Oracle database (DW).
• Identify the management reports and develop ad-hoc universe on SAP Project Systems using Information Design Tool with multi source connection for future needs.

Environment: Business Objects 4.0 SP06, Oracle 11g, SAP Data Services 4.0, Windows 2010

Confidential, Austin, TX

Business Intelligence Consultant (SSIS, SSAS, SSRS)

Responsibilities:

• Gather, analyze the business requirement and build functional / technical documents.
• Develop reports on the 1Box, Data Miners projects.
• Create test cases to support the new report and execute before promotion to Production.
• Make recommendations on best architecture approaches, standardized libraries, and framework in order to support the standardization of an architecture dat will support the needs of the user experience and the user interface.
• Provide deep technical expertise over a broad set of current technologies and mentoring of other team members in these areas.
• Within project teams, designs, develops, tests and documents final solutions according to agile methodology.

Environment: Microsoft SSIS, SSAS, SSRS, MS SQL Server 2000/2008, MS Excel, T-SQL.

Confidential, Ashburn, VA

SAP Business Objects Tech Lead / Dashboard Consultant

Responsibilities:

• As a Dashboard / WebI Report Developer, analyze the business requirement (HCM, CRB, PM) and build functional / technical documents
• Based on the business requirement develop the HCM Dashboard KPIs using Dashboards 4.0.
• Use Query Browser, BICS in developing the Dashboard & WebI reports
• Create / Modify BEx queries using BEx Query Designer to support HCM KPIs using reports like Headcount Analysis, Attrition Rate, Employee Diversity, Average Years of Service and Separations.
• Using BI Web Service, develop QaaWS and publish to support the Dashboard KPIs

Environment: Business Objects 4.0 SP05 (BI Web Service, QaaWS, BICS, IDT, Designer), Dashboards4.0 SP05, SAP BW, SAP BEx Query Designer, SAP BEx Analyzer 7.x, Windows 2010.

Confidential, NE

SAP Business Objects Tech Lead / BW Support Developer

Responsibilities:

• As a BOBJ / BW Developer, analyze the post production issues (IS-U FICA, CRB, HCM) & resolve them necessarily Confidential Web me reports, Crystal Reports
• Create the HCM, CRB Dashboard using Xcelsius as per the business needs.
• Create / Modify BEx queries using BEx Query Designer.
• Create Filters (Mandatory / Optional), Functions, Formulae in the Query Designer.
• Analyze data using BEx Analyzer prior to build semantic layer (BO Universe).
• Develop the semantic layer (universe) on top of SAP BEx queries to report needs as per the Functional Specs.

Environment: Business Objects XI3.1 (Web Intelligence), SAP BW, SAP BEx Query Designer, SAP BEx Analyzer 7.x, Xcelsius 2008, Windows 2007, Microsoft Excel 2007, Crystal Reports 2008.

Confidential, CT

SAP Business Objects Tech Lead/ Developer/ Administrator

Responsibilities:

• As a Business Objects Lead & Developer, gather report requirements, analyze, define, and develop the semantic layer (universe) to report needs.
• Develop Universes on top of SAP BEx queries and reports (Web me).
• Involve in designing the data model dat supports future report requirements.
• Fine tuning and performance improvement by identifying the bottlenecks.

Environment: Business Objects XI3.1, SAP BW, SAP BEx Query Designer, SAP BEx Analyzer 7.x, MS SQL Server 2008, Xcelsius, Windows 2007, Microsoft Excel 2003, Agile Methodology.

Confidential, Indianapolis, IN

Business Objects Tech Lead/ Developer

Responsibilities:

• As a Business Objects Lead, conduct gap analysis, gather requirements, analyze, define, develop the existing Out of Box SAP Rapid Mart Universes (SCM - Inventory, Sales, Production Planning, Purchasing, Sales) & (Finance - GL, AP, AR, Cost Center, COPA), SPL (M1, M2, A1 & A2).
• Gather the requirements and understand the merge process, involved in doing successfully the SPL (M1&M2) with Cost Center Rapid Mart.
• Understand the gap requirements and make changes to the Business Objects Data Services (ETL) to accomplish the business needs.
• Setting data security on the Inventory universe and restrict the sensitive information to the users based on the SAP ECC system security.
• Involve in merge process of SPL and COPA to the business needs.
• Identify the conformed dimensions used across multiple standalone Rapid Marts published by SAP to create the IDM (Integrated Data Model).
• Develop Finance reports. Validate SAP ECC data with the Rapid Mart reports.

Environment: Business Objects XI3.1, SAP Rapid Marts, Business Objects Data Services, DS - Management Console, Oracle 10g, Xcelsius, Windows 2003, Toad, Agile Methodology, Sybase ASIQ 12.

Confidential, Cambridge, MA

Business Objects Tech Lead / Developer

Responsibilities:

• As a Business Objects Lead, gather the requirements, analyze, defining, developing and populate Universes to support creation of canned and ad-hoc reports.
• Involved in designing the data model dat supports fully metadata-driven requirements.
• Involved in designing the prototype using PL/SQL to support the creation of dynamic schemas, dynamic targets dat is entirely driven based on metadata for creating BO Universes.
• Knowledge of 21CFR
• Implement Oracle VPD security on BO Universes for blinded/full access to data.

Environment: Business Objects XI3.1, Oracle 10g, Windows 2003, Toad, Tortoise SVN, Informatica 8.6, Unix, Ruby on Rails, Agile Methodology.

Confidential, Milpitas, CA

Business Objects Developer & Administrator/ BW integration

Responsibilities:

• Involved in the SAP ERP implementation in the company on the SAP BI-BO integration team. nvolved in the integration of CRM, Finance, P2P, and OTC modules to SAP.
• New reports were created to the AV division on CoAMS and successfully useful in the department to track the CSF $ vs. Est. Amt$ spent on each customer.
• Migrate BO XI R2 to XI3.1
• Responsible for the migration of EDW (QAD application-Oracle system) to SAP with latest version of SAP BW.
• Business Objects integration with CRM, Finance, P2P, and OTC modules.
• Revenue Analysis (P&L Statements, Gross Margin, Balance Sheet & GL based universe and reports); Product Return Analysis.
• Enterprise Reporting Management (Booking, Backlog, Shipments, Inventory, Forecast, Invoices).
• Product Marketing; Purchase Requisition; CoAMS (Program and Promotion Management).

Environment: SAP Business Objects XI3.1 / XIR2, Oracle 10g, Windows 2003, Microsoft Excel 2003, Toad, QAD application, SAP MDX query, SAP BW.

Confidential, Foster City, CA

Sr. Business Objects Developer

Responsibilities:

• Design Complex Workflows and Dataflow, where used Conditions, Loops, Functions, Scripts and Variables. Written Data Integrator Scripts for data transformation.
• Use various Data Integrator Custom Functions, like Database Functions, Lookup Function, String Function, Validate Function, Database Function, Aggregate Function and date Function.
• Involve in Migration of Business Objects 6.5 to Business Objects XI R2.

Environment: Business Objects XIR2 / 6.5, Data Integrator 11.7, Xcelsius, Oracle 10g /OEM