Manager Data
Resume:
BHARAT BHANUSHALI
SUMMARY:
o Over *years of total IT experience in software analysis, design and
development for various software applications in client-server
environment with expertise in providing Business Intelligence solutions
in Data Warehousing for Decision Support Systems.
o Excellent hands on experience in OLAP and ETL processing using
Informatica Power Center 7.x,
8. x, Oracle8i/9i/10g.
o Excellent command in producing reports employing various SAS Peocedure
and handling Large Databses to perform complex data manipulation using
files in SAS data steps.
o Experience in ETL process using ETL Tools, creating and maintaining
Repository, Source systems, Target Databases and developing strategies
for ETL mechanisms using ETL tools like Informatica Power Center.
o Gathering and analysis, design, development, testing, performance
tuning, and production support.
o Extensive experience in Data warehouses with strong understanding of
Dimensional Modeling, Star and Snowflake Schemas.
o Designed and developed complex mapping logic from varied transformation
logic like Unconnected and Connected lookups, Router, Filter,
Expression, Aggregator, Joiner, Update Strategy, Union and more.
o Proficient in using Workflow Manager Tools like Task Developer, Workflow
Designer and Worklet Designer
o Hands on experience in tuning mappings, identifying and resolving
performance bottlenecks at various levels like sources, targets,
mappings, and sessions.
o Experienced in developing applications in Oracle and writing
Stored Procedures, Triggers and
Functions in PL/SQL. Used SQL*loader to load data from Flat files into
Oracle database.
o Good in writing shell scripts in UNIX to automate the process of loading
and pulling data from different servers.
o Expertise In data analysis
Education: M.S Information Technology Management
Certification's:
. Lean Six Sigma
Achieved excellence in process improvement and expertise in using
DMAIC methodology. Expertise in implementing Lean Six Sigma tools
like FMEA, SIPOC, process mapping, cause and effect. Proven
experience identifying bottle necks in system, reducing defects and
data analysis using statistical tools.
. SAS certification In Business Intelligence and Data Mining
Expertise in performing Market Basket Analysis, Association Rule,
Decision Tree, K- Means, Neural Networks and applying business logic
to the results. Proven experience with SAS Base and SAS enterprise
version 9.2.
.
TECHNICAL SKILLS
ETL Tools Informatica Power Center6.x/7.x, 8.x, SAS enterprise Manager
9.2, SAS Base
BI Tools Cognos, Business Objects
Project Management Microsoft Project 2k3
Databases Oracle 10g/9i/8i, SQL Server 2000/2005, DB2 7.x/8.x, My SQL.
Database Tools Oracle SQL*Plus, SQL Navigator, Toad 7.4
Languages C, C++, SQL, PL/ SQL, UNIX Shell Script (Bash, ksh), JSP,
ASP,HTML.
Case Tools Erwin, Rational Rose Clear Case, Quest, Microsoft Visio, UML
Office Suite MS Word, MS Power Point, MS Excel, MS Access
Operating Systems Windows XP/2000/NT/95/98, UNIX (Solaris 7/8/9, HP-UX, AIX)
PROFESSIONAL EXPERIENCE
Capital One, Dallas,TX June 09 - Present
Informatica Developer
Description:
Capital one is one of the diversified financial services company providing
banking, insurance, investments, mortgage and consumer finance .Worked on
maintaining the Datwarehouse for retail banking and marketing .
Responsibilities:
. Responsible for preparing the technical specifications from the
business requirements
. Analyze the requirement, work out with the solution. Develop and
maintain the detailed project documentation.
. Improved performance by identifying the bottlenecks in Source, Target,
Mapping and Session levels.
. Provide overall direction and guidance to ETL development and support
for the Prescription Solutions'
Data Mart.
. Used the Shell Scripts for running the session.
. Used Update strategy and Target load plans to load data into Type-2
Dimensions.
. Created and used reusable Mapplets and transformations using
Informatica Power Center.
. Executed several sessions and created batches to automate the loading
process.
. Worked and developed extensively on Autosys job scheduling tool to
schedule the Informatica Workflows.
. Ensure integrity and availability of DBMS and reporting applications
per service level agreements.
Environment: Windows, Sun Solaris, Informatica 8.5, Oracle 10g, DB2 UDB,
Autosys, Unix Shell Scripts,Soalris, windows 2008 advance server.
Patni Computers, San Jose, CA Mar 08 - May 09
Informatica Developer
Description:
Worked on Informatica projects for Clients of Patni like Cisco System and
Mcafee.
Responsibilities:
. Created Informatica mappings to build business rules to load data.
. Analyzed and Created Fact and Dimension Tables.
. Developed mappings using Informatica PowerCenter Designer to load data
from various source systems to target database.
2
. Created complex mappings using transformations like Source qualifier,
Aggregators, Connected &
Unconnected Lookups, Filters, Sequence generators, Routers, Update
Strategy, Expression, Sorter etc.
. Responsible to design, develop and unit test the mappings.
. Created Mapplets with the help of Mapplet Designer and used those
Mapplets in the Mappings.
. Used Task developer in the Workflow manager to define sessions
. Written design documentation for the ETL maps.
. Unit tested the maps by running SQL queries on source and target.
. Used heterogeneous files, flat files, Spreadsheets, Oracle stored
procedures as sources
. Imported an XML file to Designer, did some modifications, used in the
Mappings and exported into an XML file.
. Worked with source teams to resolve data quality issues raised by end
users
. Used different Data Warehouse techniques like Star-Schema,Snowflake
Schema.
. Loaded data into target database from source database using Workflow
Manager.
. Created and Scheduled Sessions based on demand, run on time, run only
once using Informatica work flow Manager
. Was responsible for preparation and review of Solution Design
Documents.
. Provided technical assistance during development and testing.
. Coordinated between the client and the other developers.
. Was involved in Raising and Resolving Issues.
. Prepared project documentation.
Environment:
Oracle 9i, ERWIN4.0, PowerCenter 7.1, 8.1.3 (Designer, Repository Manager,
Workflow Manager and Workflow Monitor), PL/SQL, DB2, Solaris 9, AIX/HPUX
10.20 and 11.0.
Cingular Wireless, Dallas, TX May 07 - Mar 08
Informatica Developer
Description:
This Data Warehouse is constructed to stage customer related data for
Cingular (Billing, Usage, Account, Device Usage). Informatica PowerCenter
7.1 is used as ETL tool to extract the data from source systems to target
systems. The source data is coming from different sources, like Oracle,
flat files. Target data warehouse resided in Oracle Database
Responsibilities:
. Coordinated with the Analysts and team lead to work on the business
requirements.
. Worked on compiling the Business Requirements document, Mapping
Documents, Unit test cases.
. Created many ETLs as part of development and worked on various
transformations like Source Qualifier, Expression, Aggregator,
Lookups, Router, Filter, Update Strategy and many others.
. Used Task developer in the Workflow manager to define sessions
. Written design documentation for the ETL maps.
. Unit tested the maps by running SQL queries on source and target.
. Developed korn shell scripts for various Informatica pre and post
session operations.
. Used heterogeneous files, flat files, Spreadsheets, Oracle stored
procedures as sources
. Imported an XML file to Designer, did some modifications, used in the
Mappings and exported into an XML file.
. Developed Interfaces using UNIX Shell Script to automate the bulk load
& update Processes.
. Used different Data Warehouse techniques like Star-Schema.
. Extensively worked in the performance tuning of the programs, ETL
Procedures and processes.
3
. Created and Scheduled Sessions based on demand, run on time, run only
once using Informatica work flow Manager.
Environment:
Oracle 9i, ERWIN4.0, PowerCenter 7.1.1, PL/SQL, SQL*Loader, DB2, Cognos,
Oracle DBA Studio, AIX/HPUX 10.20 and 11.0, Windows NT 4.0
Albertsons, Boise, ID Sep 06 - May 07
Informatica Developer
Description:
Albertsons is one of the world's largest food and drug retailing
companies. The project involved developing an integrated Data Warehouse
system, to meet the demands of detailed, targeted customer data and sales
analysis. The Data Warehouse was designed with expansion in mind, as the
final stage of this project was to incorporate atomic level detail data.
Responsibilities:
. Involved in identifying dimensions and facts to create enterprise data
warehouse and model.
. Involved in Designing a Star-Schema based warehouse after
understanding the business logic.
. Source systems data from the distributed environment was extracted,
transformed and loaded into the Data warehouse database using
Informatica.
. Involved in the Design, development and implementation of mappings
using Informatica PowerCenter designer.
. Extracted Data from flat files and various relational databases to
Oracle Data warehouse Database.
. Created mappings using various Transformations like Aggregator,
Expression, Filter, Router, Joiner,
Lookup, Update strategy, Source Qualifier, Sequence generator, Stored
Procedure and Normalizer.
. Developed various Mappings & Mapplets to load data from
various sources using different
Transformations.
. Implemented Performance tuning in Mapping by identifying the
bottlenecks and Implemented effective transformation Logic.
. Performed various update strategies using Lookup and Update Strategy
transformations.
. Creating Stored Procedures to populate sample data and carrying out
test load.
. Loaded data from flat files and XML files to temporary tables in
Oracle database using SQL*Loader.
. Created different types of catalogs using Impromptu.
. Expertise in creating Crosstab and Nested Crosstab reports in
Impromptu.
. Created Cubes from IDQ using power play Transformer.
Environment:
Oracle 9i, Informatica Power Center 7.1, UNIX/AIX, Windows 2000,
SQL*Loader, SQL Server 2000, Erwin 4.1, Cognos 7.0,Toad. SQL, PL/SQL
TCS, Bangalore, India Feb 04 - Aug 06
Informatica Developer
Description:
Premium Billing System (PBS) of Humana Health Insurance replaced their
existing Legacy Billing system with a lot more new features. The Major
partitions of the system are Billing, Cash Posting Retro, Collections and
Reconciliation. The source data is coming from different sources, like
Oracle, flat files, PeopleSoft, Siebel and legacy systems. Target data
warehouse resided in Oracle Database and DB2.
4
Responsibilities:
. Analyzed the Specifications and identifying the source data needs to
be moved to data warehouse.
. Involved in various discussions with end user to analyze Meta Data.
. Extracted data from different systems into Repository using
Informatica PowerConnect.
. Used IPC to connect People soft, Siebel CRM and legacy systems.
. Used different Data Warehouse techniques like Star-Schema,Snowflake
Schema.
. Created Source and Target Databases on Oracle 8 and DB2.
. Analyzed and created Facts and Dimension Tables.
. Extracted data from different systems into Source.
. Created Mappings between Source and Target using PowerCenter Designer.
. Developed different Transformations to load the data into target.
. Created and scheduled Sessions based on demand, run on time, run only
once using Informatica Server Manager.
. Developed Shell scripts for the data warehouse.
. Created various data marts from data warehouse and generated reports
using Cognos Impromptu.
. Use of Designer Module to implement Universes, linkages between
tables, creating prompts and queries, parsing the Universes, applying
contexts and alias tables to remove cyclic dependencies.
. Creation of reports like Reports by Product, Reports by Customer,
Reports by Period, Demographic reports and Comparative reports.
Working with database connections, SQL joins, cardinalities, loops,
aliases, views, aggregate conditions, parsing of objects and
hierarchies.
. Creation of different types of reports, such as: Master/Detail, Cross
Tab and Chart (for trend analysis). Use of filters, conditions,
calculations, etc.
. Use of Analyzer and Explorer to view reports from different prospect
(Slice and Dice and Drill down).
Environment:
Informatica Power Mart /PowerCenter 6.0, Oracle 8.1.6 database and DB2,
Erwin Datamodeling tool, Cognos, AIX/HP-UX 11.0 hardware
Client: Eclerx June 03
- Feb 04
Role: Data warehouse Programmer/Analyst
Responsibility
. Interfaced with users and business analysts to gather information and
requirements.
. Performed in depth analysis in data & prepared weekly, biweekly,
monthly reports by using SAS, Ms
Excel, Ms Access, SQL, PL/SQL AND UNIX.
. Extracted data from existing data source and performed ad-hoc queries
by using SQL, PL/SQL, Ms
Access and UNIX.
. Understood basic business analysis concepts for logical data modeling,
data flow processing and data
base design.
. Utilized skills for problem solving. Developed databases and data
warehouse.
. Assisting with the Design and coding and implementation of new
production and data storage systems.
. Performing in-depth quantitative analysis or data analysis.
. Extensive system study, design, development and testing were carried
out in the Oracle environment to
meet the customer requirements.
. Performed various SQL queries for business analysts.
. Analyzed the data & build data warehouses by using SQL, PL/SQL, and
SAS.
. Assisted in the analysis, design, coding and development of building a
new schema (staging tables,
views, SQL files).
Contact this candidate