Sales Engineer

BACKGROUND

With more than ** years in the Information Technology industry, Jatin has a

wide range of experience in all phases of SDLC in providing Data

Integration and DataWarehousing solutions using technologies such as

Informatica, DataIntegrator, WebMethods, Teradata, BusinessObjects, and

Hyperroll. He has excellent technical and analytical skills with clear

understanding of design goals of ER modeling for OLTP and dimension

modeling for OLAP. He has extensive experience in providing Work Effort

Estimates, and responding to RFP's and creating SOW. He also has experience

of leading team in onsite, near shore and off shore model. Through

excellent delivery he has managed to increase the foot print of his company

at different client sites and has successfully increased the company's

revenue. He is a team player with excellent communication and problem

solving skills.

Technical skills

. Roles - Solution Architect, ETL Architect, BI Architect, Technical

Lead, Programmer Analyst

. Data Modeling - Logical, Physical, OLAP, OLTP, ODS, Star and Snowflake

schemas.

. Data mining - Data Cruncher, ODM

. SAP Data Integration - Informatica PowerConnect for R/3, Data

Services, WebMethods

. XML Interfaces - Informatica, SAP Data Services

Softwares

. ETL: Informatica, Data Integrator, Sybase IQ, Data Stage

. Reporting Software - Business Objects, OBIEE, Actuate Reports, Crystal

Enterprise, Cognos

. RDBMS - Oracle, Teradata, DB2, SQL Server, Ingres

. Enterprise solution - SAP R/3, i2 SRM/SCM suite

. Languages - Java, ABAP,CA- Open Road, PLSQL, SQL

. Scripts - Perl, Shell scripts, BTEQ, MLOAD, Fastload, and Fast Export

. Tools - PVCS, Mercury Quality Center, Microsoft Office suite, Visio,

MS Project

. OS - Windows NT/2000/XP, HP-UX, Sun Solaris, UNIX/LINUX

Education - Bachelor of Engineering (Mechanical)

Sardar Patel College of Engineering, Mumbai University (1995)

CURRENT EXPERIENCE (03/2005 - To Date)

CGI Inc

Solution Architect

CGI Inc provides Software Services, Consulting and Managed Services to

various clients in US and rest of the world.

Projects

ETL Architect/Technical Lead, Tractor Supply Company (10/2008 - 06/2010)

NPOS - New Point Of Sales Project

. Classify the key business drivers for the data warehouse initiative

. Design and Develop ETL processes using Data Integrator to integrate

data between SAP R/3 with DataVantage Point of Sales system (Outbound)

and Audit balancing sub system (Inbound)

. Instrumental in chain wide rollouts of the new stores to DataVantage

POS system

. Designed ETL Jobs and PL/SQL code to replicate data for volume testing

. Designed cubes using Hyperroll for capturing metrics related to file

transfer to different stores

. Monitor Volume and Performance testing the ETL code

. Responsible for reconciliation of summary transactional data all the

NPOS Stores in Sales Audit

. Analyze Data in the Xcenter central store database and individual

Xstore database to correct any data anomalies to successfully balance

stores in Sales Audit

. Maintenance of existing Data model using Erwin. Create Logical and

Physical Data Model. Designed Star schemas as per the reporting

requirements for Flash Sales Report, Layaway, Special order reports,

Terminal Summary and Tender Summary reports

. Use Data mining and Problem solving techniques to detect fraud for

Loss Prevention group

. Designed IDOC's for different goods movement types using Data

Integrator

. Involved in integration tool selection for Tractor Supply's future

integration roadmap amongst SAP PI, Software AG WebMethods, IBM

Message Broker and SAP Data Services

. Respond to RFPs, create SOW, Proposals and identify additional

opportunities for business development for CGI at TractorSupply

Ecommerce - Drop Ship Project

. Design XML Schema's and target

. Design and architect security around XML file exchanges between

Commerce Hub and Web Commerce and PFS Web

. Design and develop control tables, jobs, workflows and dataflows for

different integration points between WebCommerce, PFS Web and

CommerceHub

Technical Environment: DataIntegrator, Business Objects, SAP, PLSQL,

FogBugs, TIDAL, XML DTD/Schema's, Hyperroll

Technical Lead, Bell South Long Distance - (03/2005 to 09/2008)

. Part of the Enterprise Data Management group

. Responsible for carving a road map for data governance and Master Data

Management at the Enterprise Level

. Develop General Design, Solution Requirements Document, and Details

Design for developing Reports/ETL Mappings as per the requirements

. Architect the Datamodel and ETL Design as per the requirements

. Designed BI Reports as per requirements using Business Objects

. Create Data Validation documents for verifying Data Integrity

. Perform Code reviews

. Mentor and Lead a team of 10 developers

. Oversee, Guide and Review the deliverables of the team members

. Define ETL Coding Standards, Project Standards, Job-Aids and Templates

that can be used within the Project and for BI Practice

. Design Dashboards, Reports in OBIEE

. Design Teradata utility scripts including MLOAD, BTEQ and Fast Load

. Create Product Support guidelines and be part of the production

support rotation escalation

. Upgrade Informatica to 7.1.1

. Design ETL process using Informatica Powercenter 8.x for BMD group

Technical Environment: UNIX, Informatica, Teradata, OBIEE, Business

Objects, Oracle, Shell scripts, PVCS, TestDirector, ERWin

PRIOR EMPLOYMENT EXPERIENCE

Programmer Analyst, RKMC Inc - (02/2004 to 03/2005)

Projects

ETL Architect, Client - Bell South Telecom

. Design and Develop ETL Specs, Mappings, Sessions and Workflows and

Reports for BellSouth Telecom using Informatica Power Center 5.1.2

and Business Objects 5.1.8

. Design scripts using TeraData utilities like MLOAD, BTEQ, Fast Export

and Shell scripts

. Extract Data into OBIEE database for reporting.

Technical Environment: Informatica, Business Objects, OBIEE, Teradata,

UNIX, Oracle, TOAD, PVCS, ERWin

Programmer Analyst, IVS Consulting Inc - (05/2003 to 01/2004)

Projects

ETL/BI Architect, GE Power Systems, Marietta, GA

. Source system analysis of varied ERP, legacy and COBOL source systems

for defining ETL Strategy

. Data mining and Data cleanings using Perl Scripts

. Design and Develop ETL Specs, Mappings, Sessions and Workflows and

Reports for GE Power Systems using Informatica 5.1.2

. Datamodel ODS, Star schemas for various reporting requirements

. Design BO Universe as per the reporting requirements

. Expert in Designing reports using aggregate aware, hyper links, drill

reports etc in Business Objects reporter

Technical Environment: Informatica, Business Objects, OBIEE, SAP R/3, UNIX,

Oracle, TOAD, PLSQL, ERWin, Perl Scripts

Solution Architect, Kraft Foods, Schoky, IL

. Design and Performance tune korn shell scritps used in i2-SRM

Application at Kraft Foods, IL

. Maintain integration between SAP R/3 and i2 SRM application at Kraft

Foods.

. Train in SAP BW and SAP APO applications

Technical Environment: Informatica, Business Objects, SAP R/3, UNIX,

Oracle, TOAD, PVCS, Java, PLSQL, i2 SRM, ERWIN

Senior Consulting Engineer,i2 Technologies US Inc - (04/1999 to 12/2002)

. Design and Develop ETL Specs, Mappings, Sessions and Workflows used to

develop batch integration between SAP R/3 and i2-SRM/SCM application

using Power Center 5.1.2 and PowerConnect for R/3

. Develop the B2B WebMethods integration between SAP R/3 client and i2

SRM Catalog

. Implement i2 SRM Proprietary Tools, Catalog Integrator, AML and AVL

forms. SRM and Content Exchange and eOperate application

. Develop the R/3 extract data scripts in ABAP

Technical Environment: Informatica, Powerconnect for R/3, WebMethods, SAP

R/3, ABAP, UNIX, Oracle, TOAD, PVCS, Java, PLSQL, i2 SRM suite.

Associate Consultant, Genisys Software - (02/1998 to 03/1999)

. Implement and support Subscribers Management Systems used in Bytel

Ltd, Slough, U.K in Ingres and CA-OpenRoad 3.5

. Lead the development and maintenance of subscriber's management

systems for Bytel Ltd. at onsite in UK and offshore in Bangalore,

India

. Convert existing SMS system from Ingres OpenRoad to Oracle Forms 4.5

. Follow all the stages of SDLC for the development effort at Bytel Ltd

. Develop Time Sheet Management systems in Visual Basic 5.0 and Oracle

for Genisys Software, Basingstoke, UK

Technical Environment: Oracle Forms 4.5, Open Road, Ingres, UNIX, VB

Software Engineer, Mastek Ltd- (02/1997 to 02/1998)

. Develop Depot Support System product using CA-OpenRoad and Ingres

. Develop standard out of the box reports using Seagate-Crystal Reports

for Depot Sales Systems

. Develop user documentation and system documentation of the Depot Sales

System product

. Demonstrate the functionality and reports and engage in pre sales of

the depot sales systems product

. Implement DSS at Videocon International Ltd, Aurangabad, India and at

Prism Cements Ltd, Satna, India

Technical Environment: Open Road, Ingres, Oracle Forms 4.5, Crystal

Reports, Test Director

Graduate Trainee Engineer, M & M Tractors Ltd - (07/1995 to 10/1996)

. As a shop engineer was responsible for ongoing production of Cam and

Crank shop

. Create reports in SAP R/3 ERP application about the daily production,

inspection

. Create requisitions for maintenance, tools in an SAP R/3 ERP

application

. Responsible for planning, interacting with Good receiving, Tools, PPC,

Purchasing, sub assemblies etc for carrying out daily production of

Shop

. Responsible for inspection, quality control of the parts

Technical Environment: SAP R/3.

Visa Status - Permanent Resident

EXPERIENCE

SNAPSHOT

Industry

. Manufacturing & Distribution

. Utilities

. Process

. Telecommunications

. Retail

Technical

Specialization

. Solution Architect

. Pre - Sales Support

. Data Warehousing

. ERP-SAP

. Supply Chain

. Data Integration

Certifications

. Informatica Certified Consultant

. SAP R/3 MM

. WebMethods

Training

. SAP R/3, ABAP

. SAP APO,SAP BW

. Informatica,

. SAP DataIntegrator

. Data Stage,

. Business Objects, Cognos

. Unix,Oracle

Contact this candidate