Project Manager Data
Resume:
KATIE BHORKAR
*.*******@*****.***
Phone no:
Cleveland, OH 44130
DATA WAREHOUSE ETL ANALYST
OBJECTIVE
To attain an increasingly responsible position within a dynamic IT
organization where my experience can be fully utilized and further
enhanced.
PROFILE
. Result oriented Data warehousing ETL Analyst with 7+ years of
technical experience.
. Worked with Fortune 100 companies like IBM, Medco Health Solutions.
. Experience in Insurance, Pharmaceutical, Telecommunication, Finance,
Retail domain.
. Strong Data Warehousing ETL experience of using SSIS and Informatica .
Spanning various stages of development, Maintenance/ Production
support and Data Migration projects.
. In-depth knowledge of data warehousing processes involving business
requirements, logical data modeling, database design, data sourcing,
data transformation, and data loading.
. Demonstrated expertise utilizing ETL tools, including SQL Server
Integration Services (SSIS), Data Transformation Services (DTS), and
Informatica and ETL package design, and RDBM systems like SQL
Servers, Oracle, and Teradata.
. Teradata V2R5 Certified Professional.
. Strong Experience in writing and tuning SQL SERVER,Oracle SQL, PL/SQL
Stored Procedures, functions, Packages and Database Triggers.
. Worked with very large databases (multiple terabytes).
. Expert level related to SQL scripting/ Performance tuning and with
Logical and Physical Data Model design process in Star and Snowflake
Schema, 3NF
. Successful Management of multiple projects.
. Hands-on experience across all stages of Software Development Life
Cycle (SDLC) including business requirement analysis, data mapping,
build, unit testing, systems integration and user acceptance testing
. Excellent technical and analytical skills with clear understanding of
design goals of ER modeling for OLTP and dimension modeling for
OLAP.
. Team player with excellent communication and problem solving skills.
. Well versed with database tuning and optimization.
. Excellent written and verbal communication skills.
EDUCATION
MS in Computer Application, University of Pune, India.
Bachelor's degree in Commerce,
University of Nagpur, India.
TECHNICAL SKILLS
Business Intelligence Tools and Programming Languages : SSIS, SQL Server
DTS, Informatica Power Center 7/8.x, Business Objects
Languages: UNIX Shell Scripting, .Net, ASP, HTML, Java script, Java, C#,
SQL SERVER, Oracle PL/SQL
Tools: TOAD, Visual Studio, .NET, Informatica, SQL*Loader,
Queryman RDBMS: SQL SERVER 2008/2005/ 2000,
Teradata V2R5/6, Oracle 10.x/9.x/8.x/7x, VLRDB
Hardware and Operating Systems: IBM AIX, Windows XP, 2000, 9x and NT
servers Programming Language/Tools: SQL, Oracle PL/SQL, T-SQL, UNIX shell,
Teradata BTEQ,C#, ASP, JAVA
PROFESSIONAL EXPERIENCE
Medco Health Solutions Inc. Franklin Lakes, NJ Aug 09 - Present
Data Warehouse Teradata Consultant
Project: Medco Datamart
Environment:
Teradata V2R6, AS400, Unix,ETL
. Responsible for database analysis, design and defining database and
metadata architecture, including database structures.
. Responsible for creating the Functional Requirement Specification/FRS
for the Data Warehouse and/or Data Mart for the project performing ETL
and view design adhering to ETL development standards for a Teradata
warehouse environment.
. Responsible for understanding business requirements and transforming
them into project deliverables and implementing them effectively.
. Effectively develop and maintain best practices for data modeling,
data extraction, data loading, and data transformation into and out of
a data warehouse or data mart.
. Responsible for cleansing of extracted data to make it suitable for
use with existing group projects, integration of extracted data with
other internal & external data feeds, and data analysis.
. Developed and tested processes to create various daily, weekly,
monthly reports .
. Created/Enhanced Stored Procedures to generate automated testing SQLs.
. Responsible for Unit and End to End testing for all ETL process and
reports generating applications.
. Responsible for performing performance tuning / optimization.
. Document and maintain project deliverable like design document, test
cases, time-lines, project milestones, and project status throughout
life of the project.
. Implement complete application life cycle management such as analysis,
design, programming, testing and support.
IsleOfCapri Casino Inc. St. Louis, MO Oct 08 - July 09
Senior Data Warehousing Analyst / Business Analyst
Project: Marketing Data warehouse
Environment: SQL SERVER 2005, SSIS 2005, AS400, ETL
. Responsible for development and designing the ETL requirements for
initial development of the Corporate Data Warehouse.
. Responsible for defining, designing business rules and have
familiarity with data modeling, and data design tools.
. Design and develop SSIS packages, store procedures, configuration
files, tables, views, and functions; implement best practices to
maintain optimal performance.
. Extensively worked on confirmed Dimensions for the purpose of
incremental loading of the target database.
. Tuning of the mappings and SQL Scripts for a better performance.
. Conduct code walkthroughs and review peer code and documentation.
. Work with developers, DBAs, and systems support personnel in elevating
and automating successful code to production.
. Provide on-call support to production system to resolve any issues.
. Gather requirements and design of data warehouse and data mart
entities.
. Assisting the project manager in generating status reports, metrics
and project planning.
IBM GLOBAL SERVICES, Overland Park, KS Mar 04 - Oct 07
Business Intelligence / Data warehousing
Analyst
1) Project: SPRINT TELECOM
Environment: Oracle
9/10.x, Teradata V2R5/6 RDBMS VLRDB(multiple terabytes), Informatica 7/8.x, Trillium, Unix, Shell scripting, TOAD, OLAP.
2) Project: NEXTEL TELECOM
. Effectively developed and designed applications for mapping source
system data to data warehouse models (source to target mappings),
conducting ETL process design and developing, testing, and
implementing extraction, transformation, and load (ETL) processes.
. Extensively used various Informatica transformations Lookup, Update
Strategy, Expression, Aggregator, Filter, Stored Procedures and Joiner
etc.
. Performed Unit Testing and tuned the Informatica mappings for better
performance
. Created UNIX shell scripts and processes to extract data from various
sources such as Teradata and Oracle.
. Effectively developed SQL code in ORACLE database using TOAD to
migrate data mart from Oracle to Teradata.
. Extensively used SQL*Loader to load data from flat files to database
tables in Oracle.
. Developed Oracle cursor-based stored procedures to Teradata set-based
stored procedures.
. Used Informatica Power Center Workflow manager for session management,
database connection management and scheduling of jobs to be run in the
batch process.
. Designed and developed code and procedures by using Teradata Utilities
like BTEQ, Multi LOAD (MLOAD), FASTLOAD and carried out performance
tests including load and stress testing of applications.
. Conduct code walkthroughs and review peer code and documentation.
. Created system for capturing, reporting, and correcting error data.
. Fixed performance issues, locks, etc.
. Responsible for effective communication between the project team and
the customer.
. Followed the exact Quality Procedure by documenting and testing the
quality analysis results and requirements of each phase of the project
and continuously meeting quality goals.
Lambent Technologies, Nagpur India Oct 03 - Mar 04
Data warehouse Consultant
Environment: MS SQL SERVER 2000,DTS, PL/SQL, UNIX, .NET, ASP
. Design and develop DTS packages,store procedures, database triggers,
Functions and Packages configuration files, tables, and views and
implement best practices to maintain optimal performance.
. Provided post production maintenance and support.
. Participated in preparation of the functional design document with
information and data flow across the application.
. Implemented complex transformations by creating custom transformations
in addition to using built-in ones.
. Prepare test plan and Test Procedures for the Reports. Unit Testing of
the Reports and Review of the Test Results.
SVN Financial Services, Mumbai, India Feb 02 - Oct 03
Software Developer
Environment: Oracle 7/8i, PL/SQL, UNIX, .NET, ASP, C #
. Developed complex reports using multiple data providers, user defined
objects, aggregate aware objects, charts, and synchronized queries.
. Created classes and dimension and measure objects according to
business requirements.
. Developed database triggers, Procedures, Functions and Packages using
PL/SQL.
. Unit Testing of the Reports and Review of the Test Results.
. Provided post production maintenance and support.
Contact this candidate