Analyst/ Datawarehousing

Tejas Sarangdhar

***** ****** ***** ****., ***# *11, Austin, TX 65401.

*****.**********@*****.*** 540-***-****

Summary:

Highly motivated individual with entry-level ERP skills for FI-CO, MM, SD and BI modules in SAP seeking a career as an analyst.

Areas of concentration:

• Enterprise Resource Planning: ERP systems design & Implementation (SAP), ERP systems configuration & integration (SAP)

• Business Intelligence: Business Intelligence (SAP), Data warehousing.

• Project management: Leadership in technology based organizations, Info systems Project management.

Education:

M.S in Information Science and Technology 2011

Missouri University of Science and Technology GPA: 3.778

B.E in Electronics and Telecommunication 2007

Mumbai University 63%

Technical Skills:

Programming: Java, C, C++, and Matlab

ERP:

SAP Modules •Logistics: Material Management, Sales & Distribution, Production, Production Process, Planning

•Accounting: Financial, Controlling

•Information Systems: Financial Analytics, Business Intelligence

Databases: Database Design, ER Diagramming,SQL

Versioning: Clearcase, Clearquest

Software: Microsoft Office

Platforms: MS Windows 2000/XP/2003

Networking: Routing protocols like RIP, OSPF and configuration of Cisco routers

Projects:

MST ERP Systems Configuration & Integration (Rolla MO) Feb 2010 – May 2010

The project included setting up company parameters and testing the robustness of these configurations for various business scenarios. Worked on FICO, MM, SD modules hand in hand to understand the overlap between the modules.

MST Data Warehousing (Rolla MO) Feb 2010 –May 2010

Configured the ETL process for different business objects. Here the data from various flat files like the CSV or the transaction files was loaded into the target object using SAP BW as the platform for achieving it. The process included working on various information providers, persistent staging areas, flat files; data store objects, information areas, and information area catalogs as well as fields such as characteristics and key figures. The project also included designing the star schema and the snowflake schema for the Data Warehouse.

MST ERP Systems Design & Implementation (Rolla MO) Oct 2009 –Dec 2009

Implemented end-to-end ERP business scenarios that included purchase, procurement cycle, production cycle, and the sales cycle. Simulated the business scenarios using SAP.

Experience:

Contract Consultant at Alcatel-Lucent (Motive) (TX, Austin) Sept 2010- till date

Project: ATT ISAAC ADSL, Workflow Development

Working in quality assurance to test the automated flows for the IVRs used by the ATnT agents. The flows are developed on a proprietary tool (workflow builder) using J2EE.

Portfolio Recovery Associates (VA, USA) June 2010- July 2010

Interned in the I.T department for the ETL process on Informatica. Included documentation of the existing transformations in the ETL using Informatica as well as solving defects in them.

KPIT Cummins Info Systems Ltd, India Feb 2008- Aug 2008

Actively involved in the development of the calibrations for the Tier 4 emission norms to be launched using the Cummins proprietary tool Calterm and Microsoft Excel.

Certifications:

• Cisco Certified Networking Associate (CCNA) from Cisco Systems.

• Pursuing SAP Certificate of Excellence from SAP AG in affiliation with MST

Honors and Activities:

• Professional Table Tennis: Captain of the winning team at Mumbai Interclub team championships as well as a professional coach.

• Music: Trained percussionist & Accompanist for Indian classical instrument.

• Foreign Language: German from Max Muller Institute, Mumbai, India.

Contact this candidate