Experience Summary
A seasoned IT Professional around 11+ years of experience.
Extensive experience in full software project lifecycle implementations including the Requirements gathering, Design, Development, Testing, Performance Tuning, Implementation, Support, and Training, Developing Standards; Data Migration, Data Conversion, Data Quality, Basis Support, and Administration phases.
Extensively Worked in Broadband, Manufacturing,Supply chain, Banking, Insurance and Health Care domains.
Has the ability to understand and transform complex business requirements into software ensuring applications are delivered on time, to specification, are scalable, performance optimized and maintainable. Ability to interact with End Users in Understanding the Business Requirements and also provide training to end-users.
A highly motivated individual who is always learning, able to work to tight deadlines, and who can communicate effectively with technical peers as well as business users.
Excellent communication skills, can work independently and also as part of diverse teams, and can deliver under all circumstances.
Data warehouse and SAP Data Services (BODS) Experience
Over 3+ years of experience in Analysis, Design, Development and Migration of SAP Business Objects.
Extensive experience in
oImplementing Kimball’s methodologies to build/support data warehouses.
oDesigning Dimensional Data Modeling, Star-schemas, snow-flake schemas.
oCreating Type 1, 2, 3 dimensions and slowly/rapidly changing dimensions.
oCreating Jobs, Workflows, Data flows and Data stores.
oDefining file formats for file Data source.
oExtracting data from multiple databases/file formats and transforming using various BODS Transformations such as Query, Case, Merge, Map Operation, table comparison and Pushdown SQL etc.
oUsing local/global variables, built-in functions, creating custom functions and lookups.
oAggregating data at required granularity.
oAnalyzing data and check the feasibility to meet the business requirements.
oPropagating Job from development to staging and production environment
oScheduling Jobs
oDesigning ETL with auto documentation in mind.
oConnecting to Big data and SAP HANA databases
oError handling by validating, auditing and debugging the jobs and reviewing logs.
SAP HANA Experience
Over 3+ years of experience in Design, Development and analysis of SAP HANA databases, Information models and security with 5 full sidecar implementations of SAP HANA.
Extensive experience in
oHANA architecture.
oData provisioning into HANA using SAP BODS, flat files and SLT
oDesigning database Schemas, SQL Views, Stored Procedures and Tables (both column store and row store).
oDesigning, validating and activating Information Models – Attribute, Analytical and Calculation models using both Graphical and SQL scripts.
oDesigning Calculated Attributes, Variables and Input parameters.
oProviding security and authorization on HANA objects by creating Users, Roles.
oProviding row level security by creating Analytical privileges.
oDesigning Decision Tables with Update Values and Return Values.
oPartitioning tables with more than 2 billion records using Range/Hash/Round robin partitioning methods.
oProgrammatically loading and unloading data from memory to resolve memory issues.
oConnecting to various databases such as Oracle 12C and Big Data Hive and creating Virtual tables using HANA Smart Data Access (SDA) and building models on top of virtual tables.
oSeparation of Hot and Cold data programmatically.
oImporting and Exporting HANA contents using Delivery Units and Developer modes.
oChanging the ownership of content objects during UAT/Production promotion.
oGenerating Auto Documentation of HANA models.
oIntegration with BOBJ, BO Explorer and SAP Lumira.
Microsoft Experience
Over 6+ years of experience in Design, Development and analysis of web applications using Microsoft Visual Studio .Net, and reporting using SSRS.
Certifications:
C_HANAIMP_1: SAP Certified Application Associate – SAP HANA 1.0
(SAP ID: SAP0032675, Registration ID: 253549751, Validation ID: 100*******)
Technical Expertise
Elements
Particulars
Primary Skills
SAP HANA 1.0, SAP Business Objects 4.2,
Data provisioning tools
SAP LT, SAP BODS 4.0,4.1 and 4.2
Reporting Tools
Crystal Reports 8.5,9, 2011, Enterprise, Webi 4.0 BO Explorer and SAP Lumia.
Development Tools
SAP BO 3.0,3.1 and 4.0, SAP HANA Studio, Visual Studio 2003,2005,2008, SQL Server
Databases
Oracle 10, SQL Server 05, 08 and SAP HANA 1.0
Qualification
Master of Computer Applications, Kakatiya University, India, 2004
Project Details
Project- Genesys (Aspect Conversion) 05/15 to Till Date
Client: Suddenlink Communications
Role: SAP HANA Architect
Team: Size 10
Environment: SAP HANA, BODS 4.0, and Business Objects 4.0 (WEBI, BO Explorer)
Suddenlink Communications is a top-10 cable broadband services provider in the United States with approximately 1.4 million subscribers. Suddenlink operates in 16 states in primarily medium-sized communities.
The existing Aspect call center system is now replaced with Genesys. A new database is created to load call center data (such as customer calls and agent’s event information) coming from Genesys BI feed every 30 minutes. Several ETL jobs has been designed to process these files into LD and Stage tables. Existing Aspect/Velocity HANA models have been modified to accommodate data coming from both Aspect and Genesys tables until all the call center regions go live with Genesys. During the first phase of this project only North Carolina and Shared Services region’s residential calls are routed to Genesys system where as the remaining regions residential/commercial calls are still being routed to Aspect.
Role / Responsibility
As a SAP Data Services and HANA Architect:
Involved in all the business meetings with Suddenlink and Genesys teams.
Designed the architecture of Genesys database.
Designed and tested ETL jobs to extract, transform and load the call center information coming in BI feed files into HANA Genesys database.
Available during the go live of each region to support ad-hoc requests/modifications.
Developed new ETL jobs to process Commercial calls into Velocity using commercial business rules.
Modified and enhanced the Existing Transformations, HANA Models based on the Genesys logic and specification changes.
Created User accounts and new roles for providing security.
Created Analytical Privileges for providing row level security for individual regions.
Scheduled the ETL jobs to run in near real time.
Performed Unit, Integration, and UAT testing to assure the accuracy in data and calculations.
Regular monitoring activities on HANA Server.
Project- Velocity 02/13 to Till Date
Client: Suddenlink Communications
Role: SAP HANA Architect
Team: Size 10
Environment: SAP HANA, BODS 4.0, and Business Objects 4.0 (Crystal Reports Enterprise, WEBI, Dashboards IDT, BODS, BO Explorer).
Project Description
Velocity is about designing CRM dashboards and BO Explorer reports that provides vital signs information. The source for Velocity is Suddenlink Warehouse(SDW) which is a centralized location for Calls, IVR, Sales and Financial data.
Suddenlink recently upgraded to SAP HANA and SAP Business Objects 4.0 to optimize the performance of their analytical reports. The data from SDW will be loaded into HANA database in regular intervals. Multiple HANA Information models were designed to be used as source for dashboards and Explorer reports.
Role / Responsibility
As a SAP HANA Architect:
Designed Schema’s for various sources in SAP HANA. Created Users, Roles, Privileges, as part of HANA Security and Administration.
Designed, developed and tested various DB Views, Stored Procedures, Information Models (Attribute, Analytic and Calculation Views) to model data for reporting team.
Delivered SAP HANA Packages to Production Server.
Modified and enhanced the Existing Transformations, HANA Models based on the specification changes.
Performed Unit, Integration, and UAT testing to assure accuracy in data and calculations.
Regular monitoring activities on HANA Server.
Project - Agent Scorecard 10/13 to 03/16
Client: Suddenlink Communications
Role: SAP HANA Architect
Team: Size 10
Environment: SAP HANA, BODS 4.0, and Business Objects 4.0 (WEBI, BO Explorer).
Project Description
Agent Scorecard is an application designed using PHP and SAP HANA technologies. This application is to evaluate how all call center agents are performing on various measures. Agent’s performance will be converted into points and scores which will then be used in their performance appraisal process. Suddenlink also would like to compare each agent’s performance with his/her Region’s and Department’s performance for each measure. The performance calculation will happen on monthly and yearly basis.
All the day to day performance data available in SDW data warehouse will be brought into HANA database in a near real time fashion. Several models have been designed to aggregate the data at day, month and year level to calculate the performance, points and scores.
Role / Responsibility
As a SAP HANA Architect:
Designed Schema’s for various sources in SAP HANA. Created Users, Roles and Privileges for PHP application to connect HANA database, as part of HANA Security and Administration.
Designed, developed and tested various DB Views, Stored Procedures, Information Models (Attribute, Analytic and Calculation Views).
Designed HANA Decision Tables for the business analysts to feed scale data for points and scores.
Delivered SAP HANA Packages to Production Server.
Modified and enhanced the Existing Transformations, HANA Models based on the specification changes.
Deployed SAP HANA Models/Packages to QA and Production using Developer Mode/Delivery Unit.
Performed Unit, Integration, and UAT testing to assure accuracy in data and calculations.
Regular monitoring activities on HANA Server.
Project- Product History Database 05/09 to 01/13
Client: Carrier – UTC, Indianapolis, IN
Role: Sr. BOBJ/HANA Developer
Team: Size 7
Environment: SAP Business Objects 4.0 (BODS, BO Explorer) and HANA, SQL Server 2008.
Role / Responsibility
As an SAP BO, ETL and HANA Developer:
Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Development
Designed, Developed and Debugged various Information Models (Attribute, Analytic and Calculation Views) to model data for reporting team.
Performed Source System Analysis(OLTP). Analyzed the Source and Target Data elements, created Mapping documents, Unit and System Test Plans.
Designed and Debugged ETL process to extract data from Sources systems (SQL Server, XML and Flat Files etc) using BODS.
Transform as per business requirements and load the data into SAP HANA database using SAP Business Objects Data Services (BODS) and SAP Landscape Transformation (SLT).
Deployed SAP HANA Models/Packages to QA and Production using Developer Mode/Delivery Unit.
Modified the Existing Transformations/Jobs based on the specification changes.
Designed Hierarchical Reports in Excel 2007 and 2010 using SAP HANA models.
Create/Personalize/Manage/Index Information Spaces using various data sources (HANA, Universes and Spreadsheets) and Exploration View sets in Business Objects Explorer.
Project- Payne Title Change Analysis 03/09 To 09/09
Client: Carrier – UTC, Indianapolis, IN
Environment: VS 2008 C#, TFS, XML, JavaScript, SQL Server 2008
Role / Responsibility: Designed, developed and maintained web applications.
Project: Kronos Points Viewer Application 03/09 To 09/09
Client: Carrier – UTC, Indianapolis, IN
Environment: VS 2008 C#, TFS, XML, JavaScript, SQL Server 2008
Role / Responsibility: Designed and maintained reports using MS SSRS.
Project: ASRS (Automated Storage and Retrieval System) 08/06 To 03/09
Client: Honeywell, Phoenix, AZ
Environment: Microsoft .Net and Oracle 9, Crystal Reports
Role / Responsibility: Designed, developed and maintained web applications.
Project: Loan Origination System 01/06 To 07/06
Client: ICICI Bank, Canada
Environment: ASP.Net, C#.Net, Oracle 8i and Crystal Reports 8
Role / Responsibility: Designed, developed and maintained web applications.
Project: Environmental Health and Safety Metrics (Compass) 04/05 To 11/05
Client: SKF Corporation Ltd, USA
Environment: ASP.Net, VB.Net, SQL server 2000
Role / Responsibility: Designed, developed and maintained web applications.
Project: Watson Global Environmental Information Systems 04/05 To 11/05
Client: Watson Corporation Ltd, Corona, CA
Environment: ASP.Net, VB.Net, SQL server 2000
Role / Responsibility: Designed, developed and maintained web applications.