Engineer Software

SAKSHI KAURA Phone: 650-***-****

******.*********@*****.***

Address: **** *** *******, *** ***, San Jose, California 95126

BRIEF PROFILE

●9 years of experience in SAP HANA modelling and development, Oracle database design and development, Business Intelligence and ETL tools.

●Working experience in designing machine learning solutions using different models (Predictive Analysis, Neural Network, Regression, Classification, Clustering, etc.)

●Designed and developed the database for SAP Patented “Systems, Methods and Apparatuses For Detecting Activity Patterns” methodology. (US20160063072)

●Expertise in Database Design, Development, Performance Tuning & Optimization and Data Loading & Migration.

●Experience in big data analytics and predictive analytics.

●Experience in SAP Technologies like SAP SCP, SAP Predictive Analytics and HANA.

●Experience in leading topics and managing development teams with excellent people skills.

●Expertise in SQL, PL/SQL.

●Good knowledge of scripting in Unix Shell and Python.

●In depth knowledge of BI tools like D2K Reports 10g, COGNOS and ETL tools like Informatica.

●Extensive experience with retail (promotions, billing, pricing, inventory, POS), telecom (phone browsing history and phone marketing response) and Finance domains (Charles River, Investment Trading).

●Hands-on experience in all stages of project development, including requirements analysis, design, coding, testing and support.

●Experience with Agile methodology, planning and working sprint to sprint.

●Contribution to Defect Prevention/PQA groups for Organizational Process improvement.

●Experience in Version Control through VSS and SVN.

●Good problem solving and analytical skills.

●Excellent verbal and written communication skills.

TECHNOLOGIES and TOOLS

Programming Languages

SQL, PL/SQL, Shell Script, Python

ETL & BI Tools & Technologies

D2K Reports, Informatica, COGNOS 8

Database

HANA, Oracle 8i/9i/10g, SQL Server 2005/2008

Big Data Analytics

Machine Learning, Natural Language Processing, Text Analysis

Development Tools

HANA dev studio, HANA CDS, D2K, Toad, PL/SQL Developer, SAP HANA XS Advance

Version Control Tools

VSS, SVN

UML Tools

Microsoft Visio 2000/2003

EDUCATION AND CERTIFICATIONS

●Bachelor of Engineering in Computer Science

●Oracle Certified Associate (OCA)

SUMMARY OF WORK EXPERIENCE

SAP LABS, PALO ALTO - Oct 2012 to Oct 2014 as HANA Expert

NTT DATA US (For CISCO) - Mar 2012 to Aug 2012 as Principal Consultant

Sapient Corporation Gurgaon - Feb 2011 to Mar 2012 as Senior Associate

GlobalLogic India. Noida - Sep 2007 to Jan 2011 as Sr. Software Engineer.

HCL Technologies. Noida - Jul 2005 to Sep 2007 as Lead Engineer.

PROFESSIONAL EXPERIENCE

SAP LABS, Oct 2012 to Oct 2014

Role – HANA Expert

Customers – Daimler Benz, Barclays, EBay, Turkcell

Group/Team – P&I Customer Engagements – Business Development, US

P&I Customer Engagements team works to build a customer base for SAP HANA database, through highly personalized and complex Proof of Concepts, built specifically to cater to customers’ persistent issues or needs. The team works on four to six week short sprint cycles, which include the complete software development life cycle, starting from requirement gathering and analysis, to modelling, development, peer testing, and then customer presentation.

Responsibilities:

●I worked directly with clients and sales teams for design and creation on Proof of Concepts on the viability of HANA for their day to day work, as well as solving their persistent problems. These POCs translated to deals with multiple major clients worth more than 10 million dollars.

●Given the most pertinent business issues related to databases the clients were facing, I was involved in solving these database challenges and designing/building HANA database models and software architecture supporting the models to demonstrate a minimum of 10X factor of reduction in general processing time.

●I worked on co-occurrence analysis of huge amounts of data and Predictive Analytics.

●I created of HANA objects (procedures, triggers, and functions), relations (tables, views, materialized views) and code.

●I enhanced processing by further Performance tuning of database models and code.

●I constructed and executed shell scripts to load data dumps to staging and further onto HANA database.

NTT DATA, Mar 2012 to Aug 2012

Role - Principal consultant for Cisco Systems, San Jose

Customer – Cisco Systems (www.cisco.com)

Project – EMAN MEMS

EMAN provisions Cisco meet its goals as a service provider to internal clients by making it possible to automate ordering and provisioning. With this set of network-based tools and its ability to access back-end databases and create a centralized information repository, we can quickly create new services, deploy them, and support customer self-service, whether on the San Jose campus or in any Cisco office around the globe. The services catered are operational monitoring, performance monitoring, operations automation, inventory management, service provisioning and reporting.

Responsibilities:

●I led and managed team of database developers to procure client requirements, offer solutions and drive the development, testing and deployment of the solution.

●I did database/query tuning using advanced DB statistics, indexes, partitioning, data definition changes and efficient archival methods.

●My oracle database programming tasks included the use of advanced language features like conditional compilation, collections and records, partitioning of indexes and tables, legacy Big Data Analysis and Large Object handling.

●Creating and maintaining shell scripts for extensive data loads

●Data modeling (on ERWIN).

Sapient Corporation, Feb 2011 to Mar 2012

Role – Senior Associate

Customer – Fidelity Investments Limited (www.fidelity.co.uk)

Project – Charles River Development (Position Services)

The Charles River trading Application is being implemented as part of FIL’s (Fidelity Investment Limited) separation from FMR. The view is to build a separate Position Service, which will augment holding records, received from the accounting applications, with unaccounted trades and transactions. Position Service (PS) is being developed as part of Investment Service Program to provide the start-of-day trading view to downstream applications like Charles River and other IM Decision Support applications, with data sourced from Holding Service, intraday transactions data from the Transaction Service and escrow quantity from Escrow Service.

Responsibilities:

●I led a team of 4 senior developers in an “Agile” environment to drive the project from software design, development and testing phases.

●I was responsible for overall technical design, coding the base framework and subsequent implementation of unaccounted and unprocessed trading on bulk positions data.

●My team designed, implemented and optimized the data transformation processes in the Informatica ecosystems, including consolidating, validating and cleansing data from a vast range of sources – from applications and databases to files and Web services.

●Mainly responsible for data dump extraction from Holdings, Transaction services and Escrow services to compute intraday and end of day trading positions, using PLSQL and Informatica.

●I tuned the data transformations to make the current trade positions available in the exact time windows required by the Fidelity trading managers in varied geographies across the world.

Globallogic Inc, Sept 2007 to Feb 2011

Role - Senior Software Engineer / Onsite Consultant

Customers – Amdocs (http://www.amdocs.com); Giant, Malaysia (http://www.giant.com.my/); Health and Glow (http://www.healthandglow.in/), 7-Eleven (https://www.7-eleven.com/)

Project – Changing Worlds for Amdocs

Changing Worlds is the market-leading provider of Intelligent Wireless Portal solutions. Business Intelligence (BI) is a reporting application that uses an Oracle database instance to generate reports based on stored navigator hits logs and portal files.

Responsibilities:

●I worked with the sales team for a Proof of Concept on BIRT and successfully brought the reporting modules of the project to my company and subsequently completed the pilot project.

●I worked on tuning and modifications of oracle backend packages/procedures/functions for increased performance.

Project – Migration from Legacy to Relational Model for Giant.

E Merchant system covers core record functional areas such as Vendor Maintenance, Product Hierarchy Maintenance, and Product Maintenance etc. and also cover areas such as Promotions & PO Maintenance. The product is being used in Hypermarkets/Supermarkets in Malaysia with more than 60 stores spread across Malaysia and Singapore. This project involved migration of database to SAP system and work on backend PL/SQL procedures and front end forms and reports to cater to new data requirements.

Responsibilities:

I was responsible for BI requirement analysis with business and technical users and did the subsequent development of D2K reports for sales data analysis.

●I gave periodic application demos to business users to capture their comfort level as well as feedback for further improvement of the product.

●I worked on migrating my client’s legacy data to an efficient and standardized relational database, specifically data extraction to a staging database, data transformation packaged procedures, data loading to Relational model through packaged procedures and tuning through partitioning large tables for efficiency.

Project - Merchandise Management System for H&G and 7-Eleven.

MMS (Merchandise Management System) deals with construction & deployment of MMS (Merchandise Management System), BOS (Back office system) & POS (Point of sale) for a retailing major. Enhancements are being done on the existing MMS system, to handle another banner under the same group company while Store BOS and POS were developed afresh.

Responsibilities:

●I was responsible for facilitating the clients with sales, product return, POS exceptions and customer data analysis and created 50 different D2K reports.

●I worked on processing point of sale and back office data for inventory management, pricing and promotions through PL/SQL packages/functions/triggers.

HCL Technologies, Jul 2005 to Sep 2007

Role - Lead Engineer

Customer - Dairy Farm, Hong Kong (http://www.dairyfarmgroup.com)

Project - MMDS

MMDS (Merchandise Management Database System): MMDS is an integrated system for Merchandise Management of Retail Stores across the Supply Chain. MMDS includes product management, trading terms, purchasing, receiving, promotions, sales, invoice matching, reporting and analysis. Currently retail chain stores in Hong Kong, Singapore and South Korea use the MMDS product.

Responsibilities:

●Development/maintenance / enhancement of backend Oracle PL/SQL packages/functions/triggers and front end Forms/Reports (D2K).

●I was the configuration controller for all project objects using Visual Source Safe.

●I was on the 24 hour support team for bug fixing and customer issues resolution.

Contact this candidate