Resume

Sign in

Project Data

Location:
Mooresville, NC, 28117
Posted:
August 08, 2012

Contact this candidate

Resume:

Ashwini Wathare

704-***-****

wbic7t@r.postjobfree.com

Professional Summary:

7.5 years of IT experience in Data Analysis, Data Warehousing, Database TERADATA

**, *** **** ****** **** Integrator and BI Cognos8 reporting tool.

Expertise in ETL Development for data loading and extracting data from source to Data

warehouse.

Environment using Teradata SQL Assistant and Teradata Utilities like FASTLOAD,

MULTILOAD,

BTEQ, TPT,FASTEXPORT.

Proficient in TERADATA SQL, Stored Procedures, Macros, Views.

Experience in performance tuning of large scale databases using Views, Indexing mechanism

and Global Temporary tables in Teradata.

In Depth understanding and usage of TERADATA OLAP functions.

Good exposure to creating jobs in ELT tool Oracle Data Integrator (Sunopsis V4).

Good exposure for creating reports using BI Cognos8 reporting tool.

Experience in Dimensional Data Modeling using Star and Snow Flake Schema.

Hands on experience Oracle 9i, TOAD,SQL Server,Mainframe.

Worked on Migration project of SQL Server to Teradata SQL.

● Expertise in understanding the Business requirements and converting them into Technical

specifications.

Excellent written and verbal communication skills. Extensive experience in handling the Team.

Had been to USA, Virginia-Richmond for Philip Morris Altria Project.

Had been to USA, Dallas-Texas for Sabre Holding Project.

Had been to CANADA, Toronto for Bell Canada project during development phase.

Professional Certifications:

Teradata Certified Master V2R5

Oracle Certified Associate 9i - Oracle Database Administrator

Education:

Bachelor of Engineering Electronics and Telecommunication, First Class, Mumbai University

India Jun-2004.

Skill Sets:

Database

Teradata V2R12, Teradata V2R6, Oracle9i,SQL Server 2000

ETL/ELT Tools

Oracle Data Integrator (Sunopsis V4),Toad

TERADATA- Tools &

Utilites

Teradata SQL Assistance 7.2,BTEQ,Fastload, Multiload, Fastexport, TPT

Operating Sysytem

Windows 95/98/NT/2000

BI Tool/Reporting Tool

Cognos8-Report Studio,MS Excel,MS Power Point

Ashwini Wathare

704-***-****

wbic7t@r.postjobfree.com

Experiences:

Organization

Duration

Designation

Cap Gemini India Pvt Ltd

Aug 2011 – Mar 2012

Sr. Technical Consultant

Teradata India Pvt. Ltd, India

Apr 2006 – Jul 2011

Technical Consultant

HDFC Bank,India

Sep 2005 – Apr 2006

Oracle Developer

Udyog Software (India) Ltd,

India

Jun 2004 – Sep 2005

Developer

Work Experiences:

Cap Gemini India Pvt Ltd Mumbai Aug 2011 - Mar 2012

Designation: Senior Technical Consultant

Cap Gemini is the Global Strategy and Transformation Consulting brand of the Cap Gemini Group,

specializing in advising and supporting organizations in transforming their business, from the

development of innovative strategy through to execution, with a consistent focus on sustainable results.

Projects:

Project Name : Nordea FDW Sweden

Project Type : Development, Banking Domain

Environment : Teradata 12, Teradata Utilities, UNIX, Data stage

Duration : Aug 2011 - Mar 2012

Role : Offshore Developer, Data Analyst

Responsibilities:

Interacted with the Business Users to analyze the business requirements and transform the

business requirements into the technical requirements.

Loading data from Flat Files into the Staging area using Teradata BTEQ scripts.

Developed a new process by using TERADATA Dynamic SQL and UNIX shell scripting that can

directly sends email to the business users by attaching the analytic results after each production

run.

Developed new FASTEXPORT scripts to generate the files that feed the upstream systems.

Ashwini Wathare

704-***-****

wbic7t@r.postjobfree.com

Worked as Data Analyst, by gathering requirements related to designing of report and overall

functionalities to be included. Made changes to the report based on the feedback given by the

user.

Analyzing data issues and providing strategies to handle such data.

Handling day-to-day operations and user queries.

Analyzing data and reporting to manager.

Developing Unit Test case, Tech Specifications.

Responsible for training people on Teradata and guide them in their project work.

Provide timely responses to all work requests.

Teradata India Pvt Ltd Mumbai Apr 2006 – Jul 2011

Designation: Technical Consultant

Teradata Corporation (NYSE: TDC) is the global leader in data warehousing and analytic technologies.

Teradata offers a robust and innovative portfolio of horizontal and industry analytical applications such

as data warehousing, customer management, finance and performance management, and demand and

supply chain.

Projects:

Project Name : McCain Food Canada

Project Type : Development, Retail

Environment : Teradata 12, Teradata Utilities, UNIX, Data stage, Micro strategy

Duration : Nov 2010 - Jul 2011

Role : Offshore Team Leader, Data Analyst

Responsibilities:

Worked as a Team lead.

Coordinated/attended transition planning meetings with client.

Review deliverables list to determine requirements.

Identified project activities to be completed before transition can start.

Extensively worked on understanding the business requirements of project.

Involved in data loading using Teradata BTEQ scripts.

Converted a multi-level and redundant SQL process into one simplistic BTEQ script.

Developed new FASTEXPORT scripts to generate the files that feed the upstream systems.

Developing shell script, wrapper in UNIX.

Working on Teradata SQL to build complex queries on Warehouse tables.

Worked as Data Analyst, by gathering requirements related to designing of report and overall

functionalities to be included. Made changes to the report based on the feedback given by the

user.

Analyzing data issues and providing strategies to handle such data.

Performance tuning of SQL (Explain plans, Collect statistics, Primary and Secondary indexes).

Achieve low level knowledge on Data stage ETL Tool.

Developing Unit Test case, Tech Specifications.

Ashwini Wathare

704-***-****

wbic7t@r.postjobfree.com

Project Name : Bank of America USA

Project Type : Development, Banking Domain

Environment : Teradata 12, Teradata Utilities, Sybase

Duration : May 2010-Aug 2010

Role : Offshore project coordinator, ETL Developer

Responsibilities:

Worked on individually assigned task such as Sybase to Teradata code conversion.

Worked on performance tuning of Teradata query, PI, SI,PPI Indexing, use of compression of

Columns, stats collection, checking sub queries with IN/NOT In and try to replace with Joins.

Attending Meetings and Conference calls with client for further necessary actions and status.

Worked in System Analysis, Design, Coding, Testing, Development and Documentation.

Project Name : Philip Morris Altria, Product Freshness USA

Project Type : Development, Retail

Environment : Teradata 12, Teradata Utilities, UNIX,

Duration : Dec 2009- Apr 2010

Role : Onsite project coordinator, ETL Developer

Responsibilities:

Coordinating with the technical and business team at client site (Richmond, Virginia) to analyze

the

requirements and transform the business requirements into the technical requirements.

Worked with Teradata BTEQ, TPT to run the scripts in batch mode.

Worked on UNIX Shell Scripts for copying and moving files to and from server.

Developing Unit Test case, Tech Specifications.

Worked on mapping documents provided by client.

Worked as Data Analyst, by gathering requirements related to designing of report and overall

Functionalities to be included. Made changes to the report based on the feedback given by the

user.

Team building, like giving training on the application and new technologies to offshore team.

Wrote the Document of understanding and other technical documents including user guides.

Project Name : Bell Canada, CANADA

Project Type : Development, Telecom

Environment : Teradata 12, Teradata Utilities, Teradata Stored Procedures, UNIX

Duration : May 2009 -Oct 2009

Role : Onsite project coordinator, ETL Developer

Responsibilities:

Coordinating with technical team at client side (Toronto, Canada) and understanding new change

Request and helping Users to do UAT.

Extensively worked on understanding the business requirements.

Worked on mapping documents.

Coded Teradata Stored Procedures, Macros

Optimization and performance tuning of SQL’s for fixing Teradata Spool issues.

Develop UNIX Shell Scripts to perform load tasks with complex TERADATA SQL

Ashwini Wathare

704-***-****

wbic7t@r.postjobfree.com

Developed test cases which would help users doing UAT.

Create necessary documentation which would give overview about the change.

Attend weekly meeting with client and offshore team to discuss about any major issues.

Project Name : Sabre Holding Non-Air Billing System USA

Project Type : Development, Travel

Environment : Teradata 6, Teradata Utilities, UNIX, Oracle Data Integrator (Sunopsis),DB2

Duration : Nov 2008 - Apr 2009

Role : Offshore project coordinator, ETL Developer

Responsibilities:

Extensively worked on understanding the business requirements.

Development & Implementation of Interface, Procedures, Packages, User Functions,

Variables in ELT Process using ODI.

Load Data from Fixed, Delimited files to Teradata and also Extract data from TD tables to flat

files.

Created transformation, Load data using fast load generated in ODI.

Schedule and monitor the Jobs in ODI.

Understanding DB2 procedures and converted into Teradata DDL, DML.

Used UNIX shell script into ODI Packages

Reviewed all the code developed by the team, before moving to next environment (Peer review)

Unit testing of data and sending to client.

Project Name : Sabre Holding Annual Passenger Segments

Project Type : Development, Travel

Environment : Teradata 6, Teradata Utilities, UNIX, Cognos8, Oracle Data Integrator

Duration : Mar 2008 – Sept 2008

Role : Onsite project coordinator, Business Analyst

Responsibilities:

Extensively worked on understanding the business requirements.

Work as Business analyst for designing overall Cognos reporting requirements.

Development of reports using report studio in Cognos8 Report Studio.

Enabled the Drill through to the users to view the more detailed reports.

Create various types of reports like Master Detail, Cross Tab and Drill Down reports to enable

easy analysis. Worked with end users during the integration test and production to resolve the

Functional and formatting issues.

Worked as Data Analyst, by gathering requirements related to designing of report and overall

Functionalities to be included.

Made changes to the report based on the feedback given by the user.

Enabled the users to select their report type Like Date Range, YOY View, MOM View, QOQ

With the use of conditional variables and Java Scripts.

Integrated all the reports in to Single Page.

Enabled the user selections at the run time of report page.

Optimized the reports with the help of Native SQL, Query Processing Methods.

Ashwini Wathare

704-***-****

wbic7t@r.postjobfree.com

Helped users in doing UAT for entire product and also created documentation which would help

new

Users get acquainted with the product.

Project Name : Sabre Holding Strategic Air Reporting

Project Type : Development, Travel

Environment : Teradata V2R5, Teradata Utilities, UNIX, Oracle Data Integrator (Sunopsis)

Duration : Oct 2007 - Feb 2008

Role : Onsite project coordinator, ETL Developer

Responsibilities:

Extensively worked on understanding the business requirements.

Development & Implementation of Interface, Procedures, Packages, User Functions,

Variables in ELT Process using ODI.

Load Data from Fixed, Delimited files to Teradata and also Extract data from TD tables to flat

files.

Created transformation, Load data using fast load, Multiload generated in ODI.

Created transformation, Load data using fast load generated in ODI.

Used UNIX shell script into ODI Packages.

Unit testing of data and sending to client.

Wrote the Document of understanding and other technical documents including user guides.

Project Name : ST Paul Travelers USA

Project Type : Development, Travel

Environment : Teradata V2R5, Teradata Utilities, UNIX

Duration : Mar 2007 - Aug 2007

Role : Offshore project coordinator, ETL Developer

Responsibilities:

Database / SQL tuning, performance monitoring and troubleshooting. Using stats collection.

Worked on SQL optimization includes Teradata indexing, joins. Creating views, macros.

Developed BTEQ scripts to add the logic to get the related data from the source database.

Project Name : Teradata India Internal Project

Environment : Teradata V2R5, Teradata Utilities, UNIX,SQL Server 2000

Duration : Jun 2006 - Feb 2007

Role : ETL Developer

Responsibilities:

Hands on involves Teradata utilities like BTEQ, Fast load, Fast export and Multiload.

Migration SQL Server to Teradata using DTS tool .Export data in flat file and used Fastload.

Loading Data from XML to Teradata using Oracle Data Integrator for Sabre holding Client.

Hands on TD SQL Joins, Sub queries, Explain commands.

In Depth understanding and usage of TERADATA OLAP functions.

Ashwini Wathare

704-***-****

wbic7t@r.postjobfree.com

Atlas Documentary Facilitators Ltd ADFC (HDFC Bank) Sept 2005- Apr 2006

Designation: Oracle Developer, Business Analyst

ADFC Pvt Ltd, provide captive processing support to HDFC Bank Ltd in the areas of transaction

processing; broadly covering functions of Retail Assets & Liabilities, Corporate Operations such as

Clearing, Trade Finance, Cash Management Services, Treasury Operations, Depository Services and

other areas of the bank where large volume transaction processing capability was required.

Responsibilities:

Worked on Oracle 9i,Microsoft SQL Server 2000, Visual FoxPro and MS Excel.

Understanding the MIS data for each campaign and co-coordinating with each campaign

Manager for MIS data.

Creating reports in MS excel using Oracle 9i SQL statements.

Worked on SQL Server 2000 SQL and Data Migration.

Worked on Pivot table in excel sheet.

Making Execution Plans for the Optimizing the queries in SQL, using SQL Statement Tuning.

Working with SQL Loader utility.

Data loading from multiple sources using Excel upload.

Udyog Software India Pvt Ltd. Jul 2004 - Sept 2005

Designation: Oracle Developer, Business Analyst

Udyog Software provides business applications for Excise Manufacturing, Excise Trading Software.

Responsibilities:

Worked on Oracle9i, Visual FoxPro, and Ms Excel.

Installation and troubleshooting of Excise Software Product.

Troubleshooting desktop related problems and solving user Queries about Software Product.

Client interaction for requirement gathering, system analysis and finalization / understanding

of

Technical and functional specifications.

Created particular type of data based on user requirement, also displayed data graphically using

Pivot table Bar, Chart and Line chart in excel.

Building SQL queries.

Making Execution Plans for the Optimizing the queries in SQL, using SQL Statement tuning.

Personal Details:

Visa Stamping/Work Permit: L2 Visa with EAD and SSN

Job Location : Charlotte/Mooresville, NC

Ashwini Wathare

704-***-****

wbic7t@r.postjobfree.com



Contact this candidate