SUMMARY:

• Over 11 years of proficiency in Analysis, Design, all phases of Development, Testing, Implementation, Administration, Deployment, Maintenance and Support of Business Intelligence and Data Warehouse applications using various BI tools
• Experience in creating Data flows, Work flows, Batch Jobs, various Platform/Integrator transformations, Exception Handling, Recovery, cleansing, Scripts, implemented Confidential, Slowly Changing Dimensions (SCD), Performance tunings and scheduling jobs in Management Console using SAP Data Services 3.x/4.x ETL tool. Extracted data from BW/ECC Source using SAP BODS. Utilized BODS cleansing transforms like Associate, Match, Global Address Cleanse, Data Cleanse, Geocoder, etc.
• Experience in designing Complex Universes using Universe Designer, IDT, canned and Ad - Hoc Reports, Drill Down, Cross Tab reports, Hyper link reports using Confidential reporting application like Web Intelligence and interactive Dashboard with visual effect using Lumira/Dashboard Design. Used BICS/JCO connectivity to connect SAP ECC/BW Sources from BO IDT
• Experience in designing SAP Hana Models (Attribute View, Analytical View, Calculation View), Decision tables, Scripts, Analytical Privilege, Roles, SQL Privilege. HANA Data provisioning (SLT, SAP and Non SAP Sources using BODS, Virtualization using Smart Data)
• Experience in Data Profiling using Data Insight, Score Cards, Metadata Management, Usage & Lineage, Metapedia and Data cleansing using SAP BO Information Steward 4.x
• Extensive experience in Confidential Folder/objects permissions, Scheduling reports in Confidential Row Level Security, Report Publications (Bursting), LCM (Life Cycle Manager), QAWS, Live Office
• Evaluated SAP BW (BI) and created Info Providers, Info Cubes, DSO, Process Chain, Master Data, Multi Provider, Scheduled DTP, Info Package, Info Source, Info Set, etc.
• SAP Crystal Reports Certified Professional, Created reports using Crystal Reports formulae, Grouping, Parameters, Selection criteria, Sub Reports, Charts, Cross Tabs, Suppression, Drill Down
• Oracle PL SQL Certified, created Stored Procedures, Functions, Partitions, Indexes, Packages, Complex queries and Unix Shell Scripts
• Confidential Certified Professional (BO Administration), Extensive experience in Installation, Sizing, Scaling, Users, Group, Security Setup, Administration and Deployment, Performance Tuning Confidential 3.x/4.x, BO Data Services, BO Information Steward in Windows/ UNIX platforms and migrate reports from one environment to other
• Experience in migrating reports from Confidential to Cognos. Designed model using Cognos Framework Manager and developed reports using Cognos Report Studio
• Hands on experience in Performance tuning at Report Level, Universe Level, BO Server, HANA Models, BODS Jobs and Database level, end to end automation to largely reduce manual work force and involved in setting up infrastructures for new BI applications
• Over 6 six years of proven experience as Tech Lead/ Architect in managing large team and hands on project management experience, Offshore Onsite model and involved in estimation, Plan, Risk management, Co-ordination
• Monitor Servers for proactive space management and resource utilization and performance, Created Report Alerts to monitor thresholds and setup alerts for success and failure of scheduled reports, worked on Backup and Disaster Recovery planning
• End to end ownership of various BI applications, providing Proactive solutions and provide alternative solutions for technology limitations, involved in providing Corporate Trainings, presentations, internal/User training on the functionalities of the Confidential Suite of products
• Experience in interacting with Business Users, Customer facing reporting, getting and documenting requirements, negotiating requirements based on timelines, providing estimates, creating tech design, end user trainings
• Active team player and as an individual with Excellent Communication, Interpersonal skills, self-motivated fast learner and good listener

TECHNICAL SKILLS:

Reporting Tools: Confidential 3.x/4.x, Web Intelligence, Crystal Reports XI R2/2008, Crystal Xcelsius, Query Builder, Confidential, Info View, Query Builder, Import Wizard, Universe Designer, Data Federator, Query As Web Service, Live Office, Desktop Intelligence, Information Design Tool, Business View, Publication (Bursting), Life Cycle Manager (LCM), BI Launch Pad, CCM, SAP Lumira, Cognos Framework Manager, Cognos Report Studio

Dashboard Tools: Crystal Xcelsius/Dashboard Designer, SAP Lumira

ETL Tools: SAP BO Data Integrator (BODI), SAP BO Data Services (BODS), SAP BO Information Steward, SAP BW/BI

Database Tools: SAP HANA, Oracle SQL, PL SQL, Informix SQL, SQL Server, MySQL, Data Pumps, Import/Export, SQL Loader, SQL* Plus, MS Access, Toad, SQL Developer, SAP HANA

Operating Systems: Windows 98/2000/2003/ NT, UNIX, LINUX, AIX

Other Tools: Apace Tomcat, Web Logic, Web Sphere, BO Security Viewer, UNIX Shell scripting, Unix ODBC, Data Direct, HP Quality Center (QC)

Data Warehousing: Star-Schema Modeling, Snowflakes Modeling

PROFESSIONAL EXPERIENCE:

Confidential

Solution Architect

Responsibilities:

• Interacted with users to gather requirements and to provide end user training to develop Ad Hoc reports using Cognos Query Studio
• Designed Cognos model with multiple layered approach using Cognos Framework Manager (10.2.1) for Confidential Confidential
• Developed relational based Query Subjects, Model based query subjects and derived tables based on custom SQL, Created and published packages
• Implemented row level security using filters and Macros
• Designed Prompt page to filter the reports
• Developed various reports for Confidential Due Diligence using Cognos Report Studio and BO Confidential
• Migrated Confidential Universe to Framework Manager

Environment: Confidential (BOBJ), Cognos, Oracle

Confidential

Senior Consultant

Responsibilities:

• Evaluated data model designs leveraging Info Area, Info Catalog, Info Cubes, Info Provider (DSO, Multi Provider, Info Set, etc.)
• Integrated BO with SAP ECC, BW to develop BO universe (IDT) and reports using BICS connectivity (OLAP) and JCO connectivity (relational) and created reports HANA using ODBC/JDBC (Relational) and Hana Client (OLAP)
• Developed BO Report using BEx Query
• Scheduled Info Package to move data from source to PSA, DTP from PSA to Target
• Evaluated BW ETL activities like Extraction, applying transformation rules, Data Transfer Process (DTP), Process Chains, Open Hub Service
• Developed SAP HANA Views (Attribute View for master data, Analytical View for transactional data, Calculation View as complex data model), Decision tables, Variables, Input Parameters
• Imported remote sources using SMART Data Provisioning for Data virtualization
• Created Column/Row tables, analytical privileges, schema, package, Roles as part of HANA model development
• Used Plan Viz Perspective to analyze whether proper engine is invoked in the model for better performance
• Leveraged replication (initial load and incremental) from SQL Server to Hana database using SLT data provisioning and loaded flat/excel files to HANA
• Extracted data from SAP ECC/SAP BW as Source, Read Open Hub to HANA database using SAP BODS
• Used ABAP Data Flow with data transport to extract SAP ECC data for better performance
• Setup SAP BO Information Steward to Profile source data using Data Insight (Column, Redundancy, Unique, etc.), Score Cards, defined Metapedia for the source systems, Metadata Management for Impact, Usage and Lineage, defined custom data quality transforms

Environment: Confidential (BOBJ), Data Services (BODS), SAP BO Information Steward, SAP BI (BW), SAP HANA and SAP Lumira

Confidential

Solution Architect / Lead

Responsibilities:

• Designed Batch Jobs utilizing Data Flows, Work Flows, various Platform/Integrator Transforms using SAP BO Data Services
• Used Bulk Loader, Push Down, Degree of Parallelism, Parallel processing, Partitioning in Data Services
• Used Global Variables, Parameters, Local/Central repositories, System Configurations for code migration
• Leveraged History Preserve, Data Transfer, Table Comparison, Pivot, Query, SQL, Date Generation, Key Generation, Validation, Map Operation and Scripts
• Used Interactive debugger, Audits, Global Variables, Local Variables, Parameters, System Configurations
• Loaded data from various source files like Excel, CSV, Flat files, etc.
• Used Aggregate Aware, Aggregate navigation, @ functions, setup Aggregate tables and setup Partition Tables for performance
• Implemented Security using Analytical Privileges, Groups, SQL Privileges, Scripts
• Plan capacity, Size/scale, setup and manage infrastructures needed for Confidential, Data Services
• Drive conference call involving Business Users, Technology team, Analysts to discuss Functional Requirement Document (FRD), Technical Design document, defects, priorities, efforts, etc.
• Used Try/Catch exceptions (Error handling), recovery
• Managing technical team (Offshore Onsite model) of various expertize like Confidential, PL SQL, BO Data Services
• Created Crystal Reports using Crystal Reports formulae, Grouping, Parameters, Selection criteria, Sub Reports, Cross Tabs, Suppression, Drill Down Reports and Performance Tuning
• Install, configure and manage Confidential Servers
• Created Contexts, Alias, Aggregate Aware, @functions, Aggregate Navigation, Delegate measures
• Developed complete automation solution to trigger PL SQL jobs based on need and Calendar metadata and setup various alert reports using Confidential Publication for Proactive notification and critical failures
• Responsible for delivering the Project involving multiple components like Confidential Reporting, Data Services, Oracle PL SQL, End to end automation of various flows in the system, setup publication, security setup, end user support, scheduling, design strategies for Universes
• Project management activities including resource planning/allocation, efforts estimation, etc.
• Assisting technical team for best design practices, code reviewing standards, alternative solution, performance tuning, training on new tools
• Created Publication (external email ids) to deliver customized reports specific to the users
• Setup row level security and access restrictions in BO Universe

Environment: Confidential (BOBJ), Crystal Reports, SAP Data Services (BODS), SAP Lumira and Oracle PL SQL

Confidential

Tech Lead

Responsibilities:

• Developed BO Universe, Confidential Reports, Crystal Reports, Xcelsius dashboards
• Developed complex Data Flow, Work Flow, Project, Batch Jobs, HTML Email notifications on job status, Automation of Jobs using SAP Data Services
• Installed SAP Data Services and setup configurations, Create local and Central repositories
• Migrated the code from Local to Central repositories (DEV to UAT, UAT to PROD), Export to ATL and Import to repository, created Global, Local Variables and Parameters, Setup System Configurations, Data Stores
• Cleanse, Extract, Validate, Transform, Load from various files formats (separated files, Excel) into ODS database
• Used various transforms like Pivot, Reverse Pivot, Query, Map, Merge, Lookup, Decode, History Preserve, Confidential , etc.
• Schedule, Administer jobs in Data Services Management Console
• Developed jobs for loading SCD (Slowly Changing Dimensions) for Type 1, Type 2, Type 3
• End to end ownership of Finance Data Mart including requirement gathering, documenting, development, Testing, Administration, Maintenance, support for Confidential and Data Services
• Troubleshoot issues using Interactive Debugger, setting up of error handling and recovery mechanisms
• Identify production issues and provide fixes, performance tuning to improve the job execution time
• Drive weekly technology call proactively with Business Stake holders for understanding limitations and get enhancements to serve better
• Ad Hoc and On Demand reporting from top management for business decisions
• Metadata lineage from Confidential Reporting, Universe, Data Integrator Jobs, Source Tables
• Implemented automatic Oracle STATS pack based on loading/updating strategies in the job

Environment: Confidential, Crystal Reports, Data Integrator / Data Services, Oracle PL SQL

Confidential

DATA SERVICES ADMINISTRATOR

Responsibilities:

• Involved in Confidential, TOMCAT, Data Services, Confidential Architecture planning, Server installation, Configuration under Linux, Server sizing, Optimization and Performance Tuning, Content migration, creating users, groups and setting up access levels, Security Model design
• Used BO Life Cycle Manager, Report Publication, Security Query, Relationship Query, Federation for Cross Site replication, Backup and restore
• Work with SAP Support Team to reproduce Product issues, bugs and get the fixes, enable server level logging, work on alternative solutions.
• Involved in installing, configuring Confidential Servers under Red Hat Linux
• Involved in applying Service Packs, Fix Packs, LA Fixes
• Involved in Web Logic Web Server installation and configuration, building and deploying war files for Confidential Server, Wdeploy
• Involved in creating automated script to fire the event files based on event server, automated script to Zip the report output and email, automated scripts to run monthly reports/weekly reports
• Configured CMS servers in a cluster environment
• Involved in providing various database connectivity using Oracle Client, Informix Client setups, ODBC configurations setup, MySQL connector, UNIXODBC setup, auto script to bring up all the servers online when server is physically rebooted
• Created Users, Groups, Folders, Security Setup in BO Confidential and Data Services Management Console, Row Level Security, Access Restrictions in Universe
• Performance Tuning at Report, Universe, Database and Confidential Servers level
• Involved in server recovery, Disaster planning
• Created Auditing reports using ACTIVITY universe and other custom reports
• Owned Confidential Development, UAT server environments for installation, configuration, maintenance, support, Security
• Responsible for migrating Confidential, Data Services content across Development, QA and Production Environments

Environment: Confidential, BO Data Services, Linux, Web Logic, Import Wizard, CCM

Confidential

Responsibilities:

• Requirement gathering, analyzing the requirements
• Universe, Confidential, Crystal Reports Development based on new features
• Extensively used various features like Joins, Alias and Contexts in Universe designer
• Getting User Acceptance and sign off from the Business users
• Migrating existing Crystal Reports from Crystal Enterprise 10
• Linked multiple data-providers (Merge Dimensions) and Used calculation contexts/extended contexts
• Code Review, Performance Tuning, Deployment, Providing custom SQL
• Leading technical calls and providing solution on limitations
• Leading contract team members, assisting them and get daily progress
• Used advanced reporting functionalities such as Master Detailed, Drill, Filters, Ranking, Alerters, Prompts, Sections, Breaks, Graphs, Cross Tabs, LOVs
• Scheduled Reports using scheduler Info View as well as Confidential
• Migrating and testing the reports/Universes from DEVELOPMENT, UAT, PRODUCTION environments (Import Wizard)
• Trained new team members about the Business and Confidential XI/Crystal Reports XI/BO Universe/ Confidential
• Providing automated solution, Scheduling the reports to various locations
• Developed set of reports/Universe which would provide YTD usage trends and the quality tickets for external customers
• Providing Production support to the report objects in Confidential XI
• Implemented BO Encyclopedia

Environment: Confidential, Crystal Reports, Universe Designer, Confidential, Oracle

Confidential

BO Consultant

Responsibilities:

• Developed BO Confidential, Crystal Reports and Universes for various users of Confidential
• Used report level, query filters, Created Drill down, Cross tab reports using Confidential
• Used Confidential variables and created Alerters, Helped scheduling the reports
• Created Sub Reports, Dynamic Parameters, Section formula, Global and Shared Variables in Crystal Reports, Created custom SQL Queries using Add command object in Crystal Reports
• Used multiple connections in Crystal Reports like Universe, Oracle connection, SQL Server, ODBC, JDBC, OLEDB, Excel Files, etc.

Environment: Confidential, Crystal Reports, Universe Designer, Confidential, Oracle