12642 Bloomfield Ave, Apt:107 • Norwalk, CA 90650

M OHIT A RORA +1 (818) 619 6039  mohit.aroraa85@gmail.com

Linkedin: https://www.linkedin.com/in/maroraa/
PROFE SSIONAL SUMMARY
Data Engineer | Data Analytics
A collaborative engineering professional with over 12 years of experience in designing and executing solutions for complex business
problems involving large scale data warehousing and reporting solutions. Known for using the right tools when and where they make
sense and creating an intuitive architecture that helps organizations effectively analyze and process terabytes of data.

ARE AS OF E XPE RTISE

• SAP Native HANA on AWS • SAP SDI • SAP SLT
• Informatica Powercenter • Informatica Power Exchange • Teradata Database
• SQL • Data warehouse • Sqoop
• SAP Analysis for Excel • Modeling and Design
PROFE SSIONAL E XPERIE NCE

Accenture Jan. 2018 – Present

Data Engineering Specialist – SAP HANA Modeller
Project: Disney/ Enterprise Data platform(EDP) – Multiple Projects

Description: The Walt Disney Company is the world's largest media conglomerate, with assets encompassing movies, television,
publishing, and theme parks. Enterprise Data platform(EDP) is established as an data foundation and HANA reporting and analytics
in-memory platform for near-real-time data access.

Responsibilities:
• Created Technical specifications and standard modeling documents for HANA.
• Involved in business and blueprint gathering discussion.
• Performing the role of onsite,offshore coordinator, for co-coordinating the current development and support activities.
• Develop the HANA data model, HANA view and HANA procedures.
• Developed complex calculation view using SQL and CE-Function.
• Created advanced modeling using Hierarchies, derived views, restricted calculated column, variable, input parameter.
• Developed the security model, Naming conventions, folder structure.
• Created Users, Roles, privileges, Packages, schema as part of HANA security and development.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Developed HANA model to be consumed from SAP Analysis for Excel and WeBI for reporting.
• Involved in developing test scripts and assisted user during UAT.
• Design the solution to publish the data to google pub sub using Smart data integration (SDI) tool.
• Configured tables in SLT SAP Landscape Transformation (SLT) to move data from SAP ECC system to SAP HANA in real time.
• Collaborate with the different teams (Network, Maestro, Security) for end to end delivery.
• Worked closely with Vendor SAP on product issues.
• Responsible to create OSS message with SAP for the issues identified with the product.
• Design the UI solution on SAP HANA using SAP UI5, Angular 5 , XSJS and Odata services.

Environment: SAP HANA, SAP SLT, SAP SDI, SAP Analysis for Excel, TWS, SAP UI5, Angular, XSJS and Odata.

Accenture Jun. 2013 – Jan. 2018

Data Engineering Specialist – ETL Developer/Lead
Project: Cisco/Supply Chain –Large Scale Services

Description: Supply Chain Large Scale Services (SC LSS) is a business critical initiative comprised of standardized systems and
technology that will enable enhanced commercial capabilities for Cisco.
A foundation has been laid for the Next Cisco — a simpler, more focused company that is easier to do business with — where
employees are empowered and leaders are accountable. Supply Chain LSS will enable more innovation, sharpen our focus on the
competition and enhance our ability to solve customer challenges. As we continue the transformation to the Next Cisco, this is one of
the key initiatives helping to pave the way. To meet the demands of the business and lead the transformation to the Next Cisco, Supply
Chain LSS will: Build agility into the supply chain and make conducting business with Cisco easier for partners, customers and
employees. Expand the company’s reach into new geographies such as BRIC (Brazil, Russia, India, China) countries and other emerging
markets. Accelerate time to market and allow for new business models (e.g., solutions, consumer, cloud) Reduce the overall supply
chain cost and infrastructure for Cisco and its contract manufacturing partners.
Responsibilities:
• Responsible for understanding and leveraging approaches for designing, developing, testing, debugging data integration and
reporting needs and assisting with issues.
• Prepared the Technical Design Documents and Unit Test cases.
• Designed, developed and involved in Performance tuning of required ETLs & Sqls.
• Validated History data for all the new enhancements brought about in the Marketing 3NFs as per the flow; performed sanity
checks for the code which has to be migrate.
• Provided data to Business users for application level testing and ensuring data accuracy and consistency.
• Worked closely with other team members to plan, design and develop robust solutions in a timely manner.
• Worked on Teradata utilities like BTEQ, Fast Load and TPT to load and transform the data.
• Migrated ETL from development, testing environment to Production environment using Kintana, Udeploy tools.

Environment: Informatica 9.5.1, Oracle, Teradata

Accenture Jun. 2009 – Jun. 2013

Senior System Analyst - Informatica Architect/Administrator
Project: Best Buy/R3 Revolution

Description: Best Buy Co., Inc. is a provider of technology products, services and solutions. The Company offers products and
services to the customers visiting its stores, engaging with Geek Squad agents, or using its Websites or mobile applications. It has
operations in the United States, Canada and Mexico. R3 Revolution application is an integration application for retail business which
transform approximately 80% of the forecasting and replenishment (F&R) tools and processes for the client. It support the client’s
sales forecasting and advanced inventory planning suite within the R3 revolution application. The client’s R3 Revolution application’s
allocation allows business users to execute stock allocations and purchase.

Responsibilities:
• Install, configure and upgrade Informatica environments (Power Center, IDQ and PowerExchange).
• Responsible for maintaining 39 Informatica server (Red-Hat 64 bit Linux) and 23 repositories.
• Experienced in managing share (multi-users) Informatica environments.
• Architect environment with Informatica Product Suite following the best practices
• Configure ODBC driver connection to Nodes and Windows server using Informatica provided driver or third party driver.
• Security implementation in both Native and LDAP domains.
• Upgraded Informatica from version 6.2 to 8.1.1, 8.1.1 to 8.6.1, 8.6.1 to 9.1.0.
• Implemented multiple feature like Grid implementation, OS profile and SFTP.
• Troubleshoot and resolve issues with Informatica application. Work with Informatica vendor support if required.
• Extensively worked with repository tables and views - OPB and REP, to generate reports for analytical reporting.
• Coordinating downtime with the application support team to perform upgrades and install hot fixes.
• Supporting current configuration of Unix and BTEQ scripts, Informatica objects and connections to multiple database platforms.
• Understanding of database design concepts and best practices, and management techniques.
• Informatica capacity planning and on-going monitoring (e.g. CPU, Memory, etc.) to proactively increase capacity as required.
• Monitor ETL workflows and logging, providing job reports and status as required.

Environment: Informatica Power Center 6.2/8.1.1/8.6.1/9.1.0, Informatica PowerExchange 8.6.1/9.2.1, Informatica IDQ, Oracle,
Teradata, RedHat Linux.

Accenture Jun. 2008 – Jun. 2009

System Analyst - Informatica Developer
Project: Best Buy/R3 Revolution

Description: Best Buy Co., Inc. is a provider of technology products, services and solutions. The Company offers products and
services to the customers visiting its stores, engaging with Geek Squad agents, or using its Websites or mobile applications. It has
operations in the United States, Canada and Mexico. R3 Revolution application is an integration application for retail business which
transform approximately 80% of the forecasting and replenishment (F&R) tools and processes for the client.It support the client’s
sales forecasting and advanced inventory planning suite within the R3 revolution application. The client’s R3 Revolution application’s
allocation allows business users to execute stock allocations and purchase.
Responsibilities:
• Designed and developed required ETLs & Sqls.
• Created reusable transformations, mappings, mapplets and workflow.
• Prepared test cases, test scripts and test data for testing of Informatica mappings and workflows.
• Worked closely with other team members to plan, design and develop robust solutions in a timely manner.
• Worked on Teradata utilities like BTEQ, Fast Load, Mload, Tump and TPT to load and transform the data.

Environment: Informatica 8.1.1/8.6.1, Oracle, Teradata

TE CHNICAL PROFICIE NCIES

• ETL: Informatica PowerCenter 10.x, 9.x, 8.x, 6.x
• CDC TOOLS: Informatica Power Exchange 9.2.1/8.6.1, SAP SLT
• Databases: Teradata, Oracle, SAP HANA, MS SQL Server, Netezza
• Programming Languages: Python

CE RTIFICATE S
• AWS Solution Architect Associate
• Teradata
• Informatica PowerCenter

E DUCATION HISTORY
• Maharishi Dayanand university 2003 - 2007
Bachelor’s Degree in Electronics and Communication Engineering