SUMMARY

• 13 + yrs of IT experience in developing, designing and modeling reports using SAP BI 4.1, SAP HANA Studio, Business Objects 4.1/3.1/XIR3/R2/R1/6/5.1, BEx Query Designer and Analyzer, IDT, Design Studio 4.1, SLT, Analysis for Microsoft Excel, Explorer, Lumira/Visual Intelligence, Crystal Reports Enterprise 2008/11/10,8.5, SAP BW 7.3/7.0, SAP R/3, ABAP, Xcelsius 2008, Universe Designer, Data Services 4.1,SSIS, Promotion Management, CMC, Import Wizard, BIAR files, Web Intelligence Reports, Data Foundations, Business Views, UDB/DB2, Oracle 10g/9i, SQL Server2005/2000 and Access, XML, UNIX and LINUX.
• 4+ years of HANA experience with Oil and Gas industries.
• Strong experience with Multi - Dimensional, Star Schema and Snow Flake Schema Data Models.
• Strong SQL/PLSQL experience for analyzing reports, testing and improving the performance of the reports.
• Experience designing HANA models with Attribute, Analytical, and Calculation views using Graphical and SQL Script.
• Created SAP HANA models for Supply Chain, Sales Order, Purchase Order, General Ledger, Account Payables, FICO, MM and Account Receivables.
• Experience using CE Functions and procedures within HANA studio.
• Performed data provisioning using SLT and Data Services ETL tool.
• Expert in designing Business Objects Universes and utilized most of the features in Information Design Tool (IDT) tool.
• Used Aggregate Awareness, variable, Contexts, Hierarchies and Derived tables in the universe designer.
• Migrated content, security and structures from Business Objects lower version to higher versions.
• Created complex reports using Web Intelligence tool and distributed reports to various levels of users.
• Created different types of reports such as Standard, Crosstab, Drilldown, Sub Reports, and Hyperlink reports, Dashboards, Label Reports and Chart Reports, Forms, Tables, Sections, Breaks, Sorts, Ranking, Prompts, Drill-Up, Drill-Down, Drill-By, Charts, Blocks, Conditional formatting using Alerts for the end users.
• Extensively used Crystal Report tool functionalities for the reporting needs (Custom formulas, running totals, Custom suppress, DrilldowngroupLevel, shared and global variables).
• Heavily used Crystal reports tool for creating complex reports and supported crystal reports in the BO environment.
• Experience using Analysis for Office, Explorer and Lumira analysis tools for reporting needs.
• Successfully implemented production releases and migrated content and structure to business objects web interface.
• Experience creating procedures, functions and database views.
• Installing, configuring, promoting and migrating lower environments to higher environments (DEV to TEST and PROD).
• Created solution architecture documents and recommended best available options, data models, process flows, templates, and design templates for the BI environment.
• Participated with principal architects to understand the complexities and created blueprints and executed pilot projects.
• Experience working with Oil and Gas, Food, Health Care, Mortgage and Financial companies.
• Experience in translating Business requirements to Technical specifications.
• Experience using Data Services ETL tool - Created packages using transformations in the Data Flows and scheduled using SQL Server Agent job server
• Mentored end-users and power users for their ad-hoc needs.
• Lead the development team to take up the incidents and work orders from the clients.
• Monitored work and reported status on a weekly basis to the Business group.
• Experience with Data Warehouse Concepts, Methodologies and SDLC.
• Strong Knowledge with Multi-Dimensional, Star Schema and Snow Flake Schema Data Models.
• An intelligent and responsible software developer, fast learner, good technical abilities and skills developed by a strong work ethic and self-learning.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Senior HANA Developer

Responsibilities:

• Created HANA models Script views and Analytical and Calculation views.
• Extracted data from SAP and Non-SAP sources and loaded in to SAP HANA database.
• Created conceptual models by analyzing the requirements and data from the SAP and non- SAP sources.
• Provisioned data from SAP and Non-SAP sources.
• Created Base and Query layer HANA Models.
• Wrote SQL procedures within the HANA database
• Created CE Functions for the query performance.
• Interacted with Business users and data scientist to understand the conceptual models.
• Helped report team to build reports and dashboards.
• Created parameter modules to the report and dashboards can filter data on the module level in increase the performance.
• Tested HANA models and migrated to DEV to QA and Production.

ENVIRONMENT: SAP HANA Studio, SAP HANA, Tableau, Business Objects 4.1, SQL Server, Flat Files, Rally, share point, Microsoft Excel, Word, Visio.

Confidential, Houston, TX

Senior HANA modeler

Responsibilities:

• Created HANA models using HANA Studio.
• Create universes on top of SAP HANA Calculation views a
• Created HANA models in the Private, Re-use and query layers.
• Created parameterized modules to decrease the performance of the dashboard analytics.
• Wrote Script views to increase the performance and to reduce the complexity.
• Converted SAP BW Info Cubes (GLPCT, GLPCA) in to SAP HANA model.
• Extracted data from SAP and Non-SAP sources and loaded in to SAP HANA database.
• Created conceptual models by analyzing the requirements and data from the SAP and non- SAP sources.
• Created dashboards for Data Driven Marketing team. (Key Performance, Credit Card Sales, Prop card Analysis, Site over Sight, Sales to Purchases) using design studio 4.1.
• Created conceptual data models for understanding the database tables and views.
• Created SQL views and Procedures within the SQL Server database and Oracle.
• Created universes for financial and Invoice modules.
• Created Marketing dashboard using BO 4.1 design studio.
• Created and analyzed Customer Business Metrics and Sales to Purchases data using Analysis for office.
• Created Web Intelligence reports and published to the repository.
• Created groups and users for the Data Driven Marketing project
• Created BEx queries and supported users.
• Promoted reports and universes from DEV to TEST and PROD.
• Used agile methodology for the projects.
• Writing SQL queries and views to extract the data.

ENVIRONMENT: SAP HANA Studio, SAP HANA, SAP BW 7.3, Tableau, Business Objects 4.1, IDT, Design Studio 4.1, Crystal Reports Enterprise, SAP Web Intelligence 4.1, Oracle 11G, Rally, Share Point, INFOVIEW, PL/SQL.

Confidential, San Antonio, TX

SAP BI Developer/HANA modeler

Responsibilities:

• Created reports with Analysis for office tool and saved criteria for the end users.
• Created column and row tables within the HANA schemas.
• Created HANA Models using attribute, analytical and calculation views.
• Created procedures using CE functions.
• Created universes using Information Design Tool (IDT)
• Created performance and metrics dashboards using Design Studio.
• Created Universes using IDT tool.
• Converted BEx Query books from 7.1 to 7.3.
• Created HANA Standards user guide for maintaining and naming the packages, attribute views, analytical views, stored procedures and tables.
• Analyzed data using Explorer and Visual Intelligence (Lumira).
• Created Marketing dashboard tiles (Site transaction Count, Credit/Cash, Retail Excellence, Contract Compliance), Key performance dashboards using design studio 4.1.
• Migrated reports and converted universes from 3.1 versions to 4.0.
• Converted existing. unv files to .unx (3.1 universes to 4.0)

ENVIRONMENT: SAP HANA Studio, SAP BW 7.3, Business Objects 4.1, IDT, Design Studio 4.1, Eclipse for IDE, Web Intelligence 4.1, Oracle 11G, INFOVIEW, PL/SQL.

Confidential, San Antonio, TX

Lead Reports Developer

Responsibilities:

• Created universe for Exceptions, Missing Docs business domains using BO Designer 3.1 version.
• Created WEBI reports and scheduled to go out user emails and shared folders.
• Created Xcelsius Dashboard for LCAMP Trending project.
• Created users, groups and folders in the CMC and assigned security group.
• Created Cross Tab, Drill Down, Sub Reports and standard reports.
• Created stored procedures and database views
• Modified existing Stored Procedure and Crystal reports for the Fore Closure reports.
• Created SSIS package to transform some of the complex data to a new Table in the SQL Server database.

ENVIRONMENT: Business Objects 3.1, Xcelsius 2008, Crystal Reports 2008, INFOVIEW, PL/SQL, Stored Procedures, SQL Server 2005 and Oracle database.

Confidential, Roseville, MN

Lead Reports writer

Responsibilities:

• Created universes for the Qlikview model and ERP models.
• Converted 34 Qlikview reports to Crystal Enterprise version 11 from the scratch.
• Created 15 brand new Crystal Reports for Account Receivable and Account Payable department analysts.
• Created Weekly and Monthly reports using WEBI and scheduled using CMC.
• Upgraded Business Objects Fix packs to the current environment.
• Maintained Business Objects Server and monitored jobs and created groups and users.
• Extensively used Sub Reports and Shared Variables within Main report to accomplish the Qlikview requirements.
• Created Xcelsius Dashboards for Daily Flash dashboard requirements.
• Migrated contents from one environment to another environment
• Designed report specification document and business requirement document for the both business and report writers.
• Created ETL packages using SQL Server 2005 Business Intelligence Development Studio.
• Automated some of the manual processes using SSIS tool.
• Configured Report bursting for distributing the reports to multiple recipients.
• Administered groups, users and increased the licenses for the current environment.
• Created users/groups with report level permissions
• Upgraded Crystal Reports Server with latest service packs.

ENVIRONMENT: Business Objects 3.1, Universe Designer, Xcelsius 2008, Crystal Reports 11,SQL Server Integration Services (SSIS), CMC, QlikView, MS-Excel, MS- Word, PL/SQL, Oracle and SQL Server 2005.

Confidential, Eagan, MN

Lead Systems Developer

Responsibilities:

• Migrated reports and universes to CMC
• Created Universes and restriction sets
• Created users/groups with report level permissions
• Migrated contents from one environment to another environment
• Supported Incidents and Work Orders.
• Setup limits to the report instances to retain X no of day’s history.
• Designed report templates for the report company standards.
• Wrote specs for the Business needs by getting the information from the users.
• Lead the team of 6 report developers and maintained the good relationship with them.
• Scheduled weekly developer meetings for tracking the issues and vacation time.
• Created Dashboards for Key performance indicators and group summaries.
• Created BEx queries and reports for end users.
• Gathered requirements by talking to Business Users and documented in the Word Document.
• Created complex reports for Prime Mail from Crystal 8.5 to Crystal Reports 11 version.
• Created Prime Mail and Order Pharmacy reports using Web Intelligence.
• Created 4 new Universes for the for the Mail order pharmacy team.
• Published report to Enterprise server
• Created folders, users and groups.
• Analyzed data in the SQL Server 2005 and DB2 databases by creating SQL queries.
• Created mappings stored procedures for the executing or updating the data in to the target tables using Informatica tool.
• Used Import wizard for migrating universes across the environments
• Created restriction sets in the universe and migrated
• Used aggregate awareness and contexts in the universe.

ENVIRONMENT: Business Objects XI R2, SAP BW, Xclesius 2008,Crystal Reports 2008/11,VB.net, Web Intelligence, MS-Excel, MS- Word, PL/SQL, IBM DB2, Oracle and SQL Server 2005

Confidential, Minnetonka, MN

Senior Business Objects Developer/Crystal Reports Developer

Responsibilities:

• Designed report templates for the report company standards.
• Used IMPORT wizard to migrate stuff from one environment to another environment
• Maintained and supported reports and universes in the CMC.
• Upgraded and applied patches to the BO environments.
• Wrote specs for the Business needs by getting the information from the users.
• Gathering the Business Requirements from the users and translating them into Technical Specifications.
• Created standard, Chart, Label and Sub reports using Crystal reports XIR2.
• Created Business Objects Universes for the claims module.
• Created Standard and Ad-hoc reports using Desktop Intelligence and Web Intelligence.
• Analyzed specs and database model to generate the reports for the sign-off specs
• Wrote procedures for the complex reports.
• Created DTS packages using SQL Server 2005 and extracted data from the external sources.
• Created Claims and Provider data models for the Ad-hoc needs.
• Created reports using SSRS reporting tool
• Used Business Objects XI Enterprise to design the front end reports
• Wrote Formulas to calculated the Percentages and Summaries based on the group levels
• Published report to Enterprise server, to get the report access from INFOVIEW.
• Used Version Manager to maintain the code and lock the code
• Used Team Track to track the status of the report by developer, state and comments.

ENVIRONMENT: Business Objects XI R2, Crystal Reports XI R2, Desktop Intelligence, Web Intelligence,, INFOVIEW, Web Intelligence, MS-Excel, MS- Word, PL/SQL, Stored Procedures, Functions, Packages, Oracle database.

Confidential, Minneapolis, MN

Lead Reports Developer

Responsibilities:

• Created report templates and company standard logos for the GF6S project.
• Gathered requirements for the Security reports for AIM Project.
• Created SAP BW Cubes, DSO’s and multi-providers.
• Created BEx Queries using SAP BW sources.
• Administered Users and their roles in BO Enterprise.
• Created 2 universes for the FSC Audit project.
• Created Cross Tab, Drill Down, Sub Reports and standard reports.
• Converted existing 30 Business Objects reports from version 6 to XIR2.
• Created 18 brand new security reports using Crystal Reports XI.
• Created mappings and workflows in the Informatica tool.
• Created 25 Web Intelligence reports using existing universe.

ENVIRONMENT: Business Objects XIR2, SAP BW, WEBI, Crystal Reports Enterprise XIR2, INFOVIEW, Web Intelligence, Informatica, PL/SQL, Stored Procedures, Functions, Packages, AS 400, IBM DB2, SQL Server, Access, TOAD for Oracle.

Senior Business Objects Developer

Responsibilities:

• Created report templates and company standard logos for the Image Capture Team.
• Created 35 daily and weekly reports for the Image Capture Team.
• Lead the team of 8 report developers.
• Involved gathering requirements directly from the end users.
• Created universes for the Image Capture Performance reports
• Created Cross Tab, Drill Down, Sub Reports and standard reports.
• Administered users and reports in the CMC.
• Actively involved with Data Modeler while creating the Data Model.
• Increased performance of the existing reports by re-writing them by writing calculations and summary values at the database level.
• Created stored procedures and database views.
• Involved during the production releases and able to fix some of the critical issues.
• Re-written some of the Access reports to Business Objects.

ENVIRONMENT:, Business Objects XIR2, Crystal Reports Enterprise XIR2,INFOVIEW, Web Intelligence, PL/SQL, Stored Procedures, Functions, and Packages. Oracle 9i, SQL Server 2005/2000, Access, TOAD for Oracle, Excel, HTML, XML.

Confidential, Minnetonka, MN

Senior Business Objects/ Crystal Developer

Responsibilities:

• Designed report templates for the report company standards.
• Wrote specs for the Business needs by getting the information from the users.
• Analyzed specs and database model to generate the reports for the sign-off specs
• Wrote procedures for the complex reports and list of values for the parameters
• Wrote functions to reuse code in procedures like Address, Full Name, Active members
• Created Dynamic data base connections for the different environments, i, e OAPDEV, OAPSYS, OAPFNC.
• Created 5 brand new universes for the ad-hoc requirements.
• Created Web Intelligence reports using Infoview web tool.
• Created Data Foundations for each and every procedure and attached dynamic list of values to the procedure parameters.
• Created Business Elements and Business Views
• Migrated reports and universes from one environment to another environment.
• Used Crystal Report XI Enterprise to design the front end reports
• Connected to Business Objects Repository as a Business View and created reports
• Used Drill down Group Levels, Conditional formatting, Alerters, Alternate row shading futures and Created Label reports for Providers and Subscribers.

ENVIRONMENT: Business Objects XIR1, Crystal Reports XI, INFOVIEW, Web Intelligence, MS-Excel, MS- Word, PL/SQL, Stored Procedures, Funcitons, Packages.Oracle 9i, DB2, SAP, SQL Server2005/2000,Web services, Database, Mainframe. Team Track, Merant Version Manager.

Confidential, Saint Louis, MO

Sr.Reports Developer

Responsibilities:

• Created universes and reports using Business Objects 5.1 tool.
• Exported reports to info view.
• Created Cubes and DSO using SAP workbench.
• Created reports using BEx Query Analyzer.
• Wrote SQL statements for the analysis and data validations.
• Used Crystal reports tool for complex reporting.

Confidential

JAVA / Crystal Developer

Responsibilities:

• Wrote Java Scripts for the JSP pages.
• Wrote HTML tags for the JSP pages.
• Connected to data bases using Crystal Reports tool and generated reports.

ENVIRONMENT: Crystal Reports 8.5, JAVA, JSP, SWING, SQL Server 7.0, and Windows 98.