Project Data
Resume:
Ashwini Wathare
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
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
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
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
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
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
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
wbic7t@r.postjobfree.com
Contact this candidate