SUMMARY

• 16+ years of OLTP and OLAP architect experience in Information Technology Systems. Experience in ETL, SAP HANA, SAPUI5, BODS, SAP BO Design Studio, Jquery, Advanced javascript(prototype, inheritance, etc..) Reporting, Analytical, web and Database environment service oriented applications using software methodologies like SDLC/Scrum Agile.
• Excellent Scheduling experience in Oil & Gas industry.
• Expertise experience in Data migration and development projects including data mining, data masking, refreshing test data base with production database, denormalize the data for OLAP using SAP BODS/ MS SSIS.
• Strong OOPS concepts with SOA experience in Design and Development of IT Apps.
• Strong development experience in SAP HANA Cloud in modeling, Universe design, SAP BODS, SAP Hana XS, SAP UI5,
• SAP Hana modeling identifying KPIs, Attributes, Measures, Fact tables, Analytical, Attribute, Calc views along with security using Hana Analytical privileges
• Design Star Schemas, Hierarchies, Variable design, and Input parameters for perf. gains
• POC for SAP Hana XS Development to expose Hana data to external apps using JS/Odata
• Creating Hana Databases, Users, Roles, and Analytical Privileges to control the Hana View Accesses.
• Architected a HTML5 based solution for responsive website using SAP Hana, Sap Web IDE, SapUI5, AngularJS, Jquery, KendoUI, Ajax, SAP Bods, and IDT
• Installation experience to support DB installation, Maintenance, Backups/restores, Bulk loads
• Extensive experience in writing Database batch jobs, stored procedures to process data.
• Technical Subject Matter Experience (SME)in writing hands on code for web, mobile and database driven systems for analysis, design, coding, testing, deploying and support.
• Excellent communication skills to work with Business users in explaining system capabilities reverse engineering functionalities, documentation, conducting review meetings and Training.
• Performance and security improvements experience for both web and database driven apps.
• Deployment of Code to test and prod environments as release coordinator.

TECHNICAL SKILLS

Programming: SAP Hana SP8, Sap Hana Cloud, Sap Web IDE, Sap River, SAP Hana ALM, Predictive Analysis, SAP Bods 4.2, BOBJ 4.1(WEBI, IDT), SAP BO Design Studio 1.3, SAPUI5, .NET, ASP.NET, Microsoft BI, MVC, JavaScript, JQuery, SAP Hana SLT replication, Hana data provision, Information Design Tool(SAP IDT)

Tools: /Patterns: ETL, SSIS, HP ALM (QC), Business Intelligence, JQuery, Ajax, SAP Hana Studio, SAP Lumia, SAP Fiori, Visual Studio 2013, MVC, HTML5

Databases: MS SQLSERVER 2005/2008 R2, SAP ECC, SAP HANA, DB2, Oracle, MS Access, JDBC/ODBC and Transact SQL, Oracle PL/SQL, Stored Procedures and Triggers, SQL Management Studio, SQL Profiler

PROFESSIONAL EXPERIENCE

Tech Lead Consultant

Confidential, San Antonio

Responsibilities:

• Architect and Lead for developing the project that’s involved in SAP HANA SP8, BODS 4.2, SAPUI5, HTML5, Jquery, OData services, using Ajax/JSON based solution
• Provide mobile options to client based on the environment using HTML5, SAPUI5, FIORI, and SAP Hana XS Engine.
• Developed HANA info view Ana/Calc views using HANA Studio and identify KPIs, Attributes, Measures, Normalization techniques, Fact tables, charting needs, etc..
• Consume Hana models to Develop mobile friendly websites based on Html5, JavaScript using BO Design studio
• Developed a Movements Dashboard using SAP BO Design Studio by connecting to Hana DB, JavaScript for IPAD View port.
• Develop Hana info views Analytical, Attribute, Calculation views using graphical and sql engines.
• Develop Hana Analytical privileges to set up security to Hana Info views
• Create users/roles in Hana database.
• Develop SAPUI5 dashboard using Shell control, grid, message box, JSON, ODATA, server side JavaScript on Hana to provide charts and projection inventory.
• Define Data migration and Data validation rules to define sub test, phase, and study information for sampling.
• Advised on Data migration from various systems to Hana using SLT, Data services, for reporting.
• Develop SAP BODS jobs with transformation not limited to table comparison, work flows, control tables, template tables, Type I, Type II, Type III changes, ABAP transformations.
• Developed Business Objects Data Services jobs to load all the master data from spread sheets to SQL Server/HANA using various transformation/validation rules/query transform/history preserve, key generation, table comparision options
• Architected and Designed Scheduling system to develop UI, BODS jobs, Hana replication using Kendo, CSS, SAPUI5, Unity patterns, AJAX, J query, JavaScript.
• Designed BOBJ IDT for Business Layer, data foundation layer by renormalizing the data, creating derived tables, identify Measures, Dimensions, Splitting the movement records by each day, common volume conversion from Barrel, gallons, M3, KBBL.
• Advanced sql programming for Inner Joins, Sub queries, unions, scalar functions, UDFs, logical joins, case, if, etc…

Sr. Software Developer

Confidential, San Antonio

Environment: SAP BOBJ, SAP BODS, WEBI, Universe, VS2008/2012, SSIS, SOA, SSRS

Responsibilities:

• Developed Transformation flows using Table comparison, work flows, audit logs, ABAP work flows to move the data from source to target
• Develop Connections, Business Layer using Universe for reporting purpose.
• Developed BODS jobs to retrieve student data and mask secured information to load into test DB.
• Developed jobs together student info, demographics, test score to load into SQL Server DB.
• Developed bulk upload to database to process auth applications.
• Developed batch jobs to extract student information, ethnicity, demographics, and norms data from other systems using Business Object Data services to transform the data into sql server.
• Development and maintenance of SQL Server stored procedures, triggers for business logic that can es/look be used by both web and legacy.
• Created Data stores, connecting to sql, ecc, etc…

Assistant Manager

Confidential

Responsibilities:

• Managing a team of 3 at onsite and 4 at offshore in the role of SME and lead designer.
• Coordinate with VISA and Carlson business teams for requirements, user work flow, UI Design to develop design documents & daily status reports on Production issues to business users.
• Provide designs/estimates on and allocate the work to offshore resources for development.
• Unit/Integration testing on components to deliver and signoffs
• Manage all releases as release manager to coordinate with Business, technical, client teams and provide back out plans and update the status.
• Interact with IBM infrastructure team for releases, upgrades and configuration changes.
• Involved in Production Support, Estimations, Design, and Development of CRs/Adhocs/SCRs using MS SSIS, SSRS, C#, SQL Server
• Provide Integration solutions using SOA to integrate IVR, A2K, etc…