Application Engineer

SUMMARY

Data enthusiast offering around * years of experience in the field of data-driven application development and business intelligence technologies.

TECHNICAL SKILLS

Programming: Python, T-SQL, PL/SQL

Relational Database: Oracle 11g, SQL Server 2008/2012, MySQL

NoSQL: Mongodb

ETL: Python, SQL Server Integration Services, Kronos Workforce Integration Manager

BI/Reporting: Tableau 9.2, SQL Server Reporting Services

Operating System: Windows, Linux, Mac OS

PROFESSIONAL EXPERIENCE

Application Engineer, Amazon.com, Seattle WA (March 2014-Till Date)

Interacting with HR business customers to understand and document their business processes and requirements for Amazon Time and Attendance management.

Performing gap analysis to determine custom development needed on top of existing Workforce Management System (Kronos) for supporting attendance and time offs for Amazon’s population of 200,000+ associates globally.

Analyzing employee data using tools like SQL, Python and Tableau to identify attendance and leave patterns, schedule deviations, overtime hours and payroll defects to enable leadership team to ensure compliance and design policies.

Modeled a MySQL Datamart for efficient and rapid reporting for business analysis.

Developed web based serialization APIs to distribute data in JSON form.

Designing and developing highly optimized and reusable interfaces with dependent systems like PeopleSoft, ADP, Lenel and Amazon wide scheduling systems, using Kronos Workforce Integration Manager and metadata driven PL/SQL stored procedures /functions/advanced queries.

Technologies used: Oracle 11g, PL/SQL, MySQL, SSRS, Tableau, Python

Programmer Analyst, PeopleTech Group, Bellevue WA (June 2013-Mar 2014)

As BI Consultant for the Amazon ERP system, interacted with the Amazon HR Services team to understand their data needs.

Modeled the HR Datamart using Microsoft SQL Server to serve as the single platform for HR processes and analysis.

Caused significant reduction (about 80%) in Amazon HRs manual effort to reconcile data from various sources.

Identified points of integration with enterprise-wide HCM systems like PeopleSoft, Kronos and other Amazon specific Labor Management systems to gather high volume employee data available via variety of sources like csv files, JSON feed via web interfaces and Oracle database.

Designed highly optimized and reusable ETL packages powered by extensive use of metadata driven T-SQL/PLSQL stored procedures and function as plug-ins to extract and integrate data from all sources into the HR Datamart.

Developed Python programs to extracts data from web interfaces.

Test driven development with excessive exception handling to ensure the consistency of highly volatile employee data.

Developed metadata driven SSRS reports to enable HR services team to process monthly compensations, perform employee’s effort and pay analysis.

Technologies: SQL Server 2008 R2, Oracle 11g, T-SQL, PL/SQL, SSIS, SSRS, Python, Dimensional Modelling

Senior Software Engineer, PeopleTech IT Consultancy Ltd, Hyderabad India (July 2011-May 2013)

Working in Microsoft’s Connected Sales and marketing data distribution platforms, I designed and developed the Datamart to consolidate customer, licensing, revenue, agreement and opportunity data to support Relationship Marketing analysis.

Identified CRM sources and business logic required to deliver the foundational architectural platform for SMS&P Customer Reporting

Designed highly optimized and reusable ETL packages powered by extensive use of metadata driven T-SQL stored procedures and function as plug-ins to extract and integrate data from all relevant sources.

Developed a solution to rank Microsoft’s SMS&P customers based on the revenue and agreements over its lifetime of business with Microsoft to answer questions like which are the most valuable customers of volume licensing, which are the least and which accounts have growth potential.

Working in the scrum model,constantly reviewed the business entities, qualifiers, attributes and measures with the Business Planning SME

Technologies: SQL Server 2008 R2, T-SQL, SSIS 2008, SSRS 2008

System Engineer, Infosys Ltd, Hyderabad India (Aug 2009-June 2011)

Worked as devops for Microsoft’s enterprise-wide data warehouse FeedStore.

Interacted frequently with Microsoft IT customer to analyze recurring issues and working on Problem Requests to find permanent solutions to the same.

Built downstream integrations for new customers using SQL Server replication and SSIS packages.

Responsible for maintaining the metrics on the Operation Floor.

EDUCATION:

JSS Academy of Technical Education, Uttar Pradesh Technical University, India 2005-2009 Bachelor of Science (Technology) in Computer Science & Engineering with aggregate of 74%

Contact this candidate