Data Years Experience
Resume:
KSHIPRA VAIRAGKAR
*******.*********@*****.***
PROFESSIONAL SUMMARY
. Total 6 years of experience in Data Warehousing / Business
Intelligence as Developer, Team Lead, Business Analyst and Data
Architect.
. 4 years experience in ETL development using Informatica, PLSQL,
Oracle, Teradata, UNIX shell scripts.
. 2 years experience in Reports development using OLAP tool
Microstrategy.
. 2 plus years experience as Business Analyst for the Enterprise Data
Warehouse of a large Retail & Supply chain organization.
. 1 year experience as Data Architect with the largest Corporate
Treasury in the US working on Debt & Derivatives including data from
trading systems like Wall Street Suite (WSS) and ATOM.
. Proven experience in project and team leading for a high pressure
project with zero defect delivery. Equally comfortable working
independently as well as in a team environment.
. Well experienced in functional and technical systems analysis &
design, systems architectural design, presentation, system impact
analysis and design documentation and presentation.
TECHNICAL SKILLS
Databases Teradata V2R6, Oracle 8i/9i/10g
ETL Tools Informatica 7.x.x
Reporting Tools Microstrategy
Scripting UNIX shell scripts, PLSQL scripts, Teradata
Bteq scripts
Data Modeling tool ERWIN
Operating Systems Win XP/2000/NT, MS DOS
Versioning Tools Documentum, Harvest, MS VSS
Training / Exposure Cognos, SQL Server 2000
CERTIFICATIONS
. Teradata Certified Professional (V2R5) (2006)
. Teradata Certified SQL Specialist (V2R5) (2007)
EDUCATION
Bachelors in Computer Engineering from University of Mumbai, India - Jul.
2004
PROFESSIONAL EXPERIENCE
Employer- Tata Consultancy Services Ltd. Oct
2004 till date
Project Experience:
GE Corporate Treasury - Stamford, CT
Data Architect & Analyst
Sep 2009 till date
Responsibilities:
. Involved in Requirement analysis and Designing of Database structure.
. Translate business requirements into technical specifications for Data
Warehouse.
. Perform source system Data Analysis to integrate into Enterprise Data
warehouse.
. Data Modeling and designing of new tables & enhancements as per the
Kimball methodology and create design specifications.
. Design Materialized Views & Aggregates for efficient reporting.
. In-depth data analysis of Debt & Derivatives data from various trading
systems like Wall Street Suites (WSS) and ATOM.
Environment: Oracle 10g, ERWIN Data Modeling tool, UNIX, PL/SQL, MS
Project
Supervalu, Inc. - Eden Prairie, MN
Business Analyst
Jul 2008- Sep 2009
There was a requirement to translate a number of manual operational
processes from the operational systems into the enterprise data warehouse.
With the client acquiring another company, there was a need to consolidate
the varied processes into a single repository in the data warehouse.
Responsibilities:
. Handling dual responsibility of a Developer and Business Analyst for
different projects.
. Design and develop Informatica mappings, Oracle, PL SQL, Teradata BTEQ
scripts and UNIX scripts.
. Co-ordinate with the business users and gather the requirements
. Map the new requirements to the existing Enterprise datawarehouse and
translate the requirements into Informatica/ Microstrategy design
documents
. Create / Modify existing data warehouse tables keeping performance
considerations in mind
. Handle emergency design fixes for job failures and suggest new design
Environment: Informatica 7.1.4, Microstrategy 8, Oracle 9i, Teradata, UNIX
Supervalu, Inc. - Eden Prairie, MN
ETL Developer ( Team Lead ) Sep 2007 -
Jul 2008
Responsibilities:
. Team lead of 16 members for a high pressure & time critical project.
. Work load assignment and review of deliverables
. Ensuring timely and defect free delivery of work products by the team
. Resource planning & Status Reporting
. Perform Causal Analysis of defects and make a continuous effort to
minimize the same
. Induct & mentor new members into the team and bring them to speed
. Represent / discuss issues with Business Analysts/users for time
critical deliverables
. Develop ETL code using Informatica, UNIX, Oracle and Teradata
. Perform technical code reviews
Environment: Informatica 7.1.4, UNIX, Oracle 9i and Teradata.
Supervalu, Inc. - Eden Prairie, MN
Business Analyst and Developer
Sep 2006- Sep 2007
Responsibilities:
. Responsible for studying the business behind the different operational
processes and consolidating them into a single Enterprise Data
Warehouse
. Interact with business users & operational groups to collect business
requirements for EDW reporting
. Translate technical requirements into Data Models as per Kimball
approach and with performance optimizations
. Create an exhaustive Design Specification for ETL & Reporting
. Co-ordinate development & testing efforts in terms of business /
requirement issue resolutions
. Job scheduling while maintaining dependencies on other jobs
. Perform Integration testing and assist business users in the UAT of
designed & developed code
. Handle emergency design fixes for job failures and suggest new design.
Environment: Informatica 7.1.4, Microstrategy 8, Oracle 9i, Teradata, UNIX
Supervalu, Inc. - Eden Prairie, MN
ETL & Reporting - Development & Testing (Offshore) Oct
2004 -Sep 2006
Responsibilities:
. Analyze and understand the requirements.
. Perform Impact analysis on existing system and suggest innovative &
robust solutions.
. Co-ordinate with Business / Requirement Analyst for issues in
requirements and/or design
. Development of Informatica mappings and workflows
. Developing UNIX shell scripts, Teradata scripts (BTEQs & Stored
Procedures) and Oracle PL/SQL scripts & Stored procedures
. Unit testing and Integration testing of ETL code
. Development of Microstrategy Reports, Schema Objects and Public
Objects
. Creating complex application views in Teradata for Microstrategy
Reports
. Review of deliverables for quality assurance and control
. Documentation of new development.
. Mentoring & Training new team members
Environment: Informatica 7.1.4, Microstrategy, Oracle 8i/9i
TRAININGS CONDUCTED
. Introduction to Business Intelligence & Data warehouse concepts -
Number of attendees: 10
. Unix library function - Number of attendees: 10
. Introduction to Vendor Funds Reporting - Number of attendees: 25+
PERSONAL SKILLS
. Excellent verbal and written communication skills.
. Proven ability to perform & lead under pressure.
. Proactive & Self motivated.
Contact this candidate