Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download
Download Resume Format
Subhro Saha
(720) 642-2051 ©
Summary:
- 8+ years of experience as ETL Consultant in
all phases of Data Warehousing lifecycle involving requirements gathering,
design, development, analysis and testing using industry accepted
methodologies and procedures.
- Experience
in Financial, Healthcare, Pharmaceuticals, Insurance and
Telecommunications industries.
- Experienced
in Ralph Kimball’s methodology and Bill Inman’s approach.
- Experienced
in developing database schemas like star schema and snowflake schema in
dimensional modeling using tools like ERWIN.
- Extensively
worked on Informatica Powercenter tools like Repository Manager, Designer,
Workflow Manager and Workflow Monitor and Repository Databases.
- Experience
using Informatica Data Quality tools like Workbench and server.
- Worked
extensively with complex mappings and expertise in implementing all types
of slowly changing dimensional logics.
- Hands
on experience in performance tuning and extensive experience in debugging
and identifying the issues.
- Worked
with SQL Server DTS packages, stored procedures and Functions.
- Design
and database development experience with Oracle SQL, PL/SQL, stored
procedures, functions and triggers.
- Experienced
in UNIX shell scripting, cronjobs and using pmcmd commands (Informatica
command line utility) to create, schedule and control workflows and tasks.
- Knowledge
with reporting tools like Cognos 8, Cognos Report Net and Business Objects
XI.
- Extensive
technical experience developing custom applications on a broad range of
operating systems and hardware platforms.
- Excellent
Communication and Inter-personal skills and strong documentation skills
and problem solving skills.
|
Technical Skills
|
|
|
Operating Systems
|
MS-DOS, HP-Unix, Windows 9x//NT/2000/XP, Mainframe.
|
|
ETL & Reporting Tools
|
Informatica Power Center 5.x/6.x/7.x/8.x, Power Mart (Source Analyzer,
Mapping Designer, Mapplet, Transformations, Workflow Monitor, Workflow
Manager), Informatica Data Quality 8.5 ( workbench, server), MS SQL Server
DTS, SSIS & SSRS, Cognos 8, Cognos Report Net, Business Objects XI,
6.x,5.x
|
|
Languages
|
C, C++, SQL, PL/SQL, XML,
L,
DHTML, Java (JSP, JDBC), Visual Basic, Unix Shell Scripting.
|
|
Databases
|
Oracle 8i/ 9i/10g, db2 UDB 9.1.6, Teradata V2R5.01, My SQL, MS SQL Server 2005
|
|
Data Modeling
|
Erwin, Star-Schema and Snowflake-Schema Modeling
|
|
Scheduling Tools
|
SQL*Plus, SQL*Loader, SQL Assistant, Control-M
|
|
Developer2000
|
Forms, Reports
|
|
Packages & other tools
|
MS Office (MS Access, MS Excel, MS PowerPoint, MS word), Rational Clear case 5.0, WRQ Reflections
13.0, Altova XML-Spy, Syncsort DMExpress 6.5
|
Project Experience:
Wells Fargo Bank – San Francisco, CALIFORNIA
ETL Lead/Data Analyst
MDM Brokerage Integration Project:
As a
result of Wells Fargo (WFI) / Wachovia (WFA) merger, there is a need to combine
the Beta/Brokerage data maintained separately for WFI and WFA. As the decision
was made to convert all the brokerage data to WFA, Castor ODS (WFI), which is
the MDM Brokerage SOR, is being decommissioned and the go forward SOR will be
BDW on WFA. The project purpose is to identify the potential impacts on the MDM
and take necessary steps to ensure the data integrity and also engage the
downstream Interface Partners to test their Business functionality. This will
focus on streamlining the converted brokerage data files from WFA to meet the
needs of the Brokerage MDM’s downstream business partners which will favorably
impact service level agreements, business functionality and usability.
Responsibilities:
- Analyze
highly complex business requirements, design and write technical
specifications to design or develop ETL processes.
- Participate
in requirements, design, and code reviews and get the big picture.
- Interpret
the transformation rules for all target data objects and develop the
software components to support the transformation.
- Integrated
the Data Quality with Informatica Power center to deliver
enterprise-strength data quality capablility.
- Automate
the ETL process through scheduling and exception-handling routines as well
as source to target mapping development, support, and maintenance.
- Responsible
for ETL processes and tools as well as database loading and manipulation.
- Deploy
an error management mechanism to capture all relevant error information
and associate data in a manner that can be re-processed independently.
- Lead
the project independently and communicate with Business Analysts, and QA
team.
- Follow
ETL development guidelines, standards and procedures.
- Provide
thorough metrics to measure progress and accuracy of data transfers.
Environment: Informatica Powercenter 8.6, DB2/AIX64
9.1.6, Data Quality 8.5, Oracle 10g, Teradata 13.00.00.26, Teradata SQL Assistant
12.0, Embarcadero Rapid SQL 9.1/ER Studio Data Architect 8.5, Syncsort
DMExpress 6.5, Microsoft Visio XP, Pac2000 V7.1, Tortoise CVS
Spectrum Health - Grand Rapids , MICHIGAN
Sr. ETL Developer
Spectrum Health is a West-Michigan
based health care system dedicated to improving the well-being of families and
individuals. Worked on “eSHare all patient Registry” project, this project
provides physician practices with a tool to manage and track patient care
across an array of chronic conditions and thereby improve clinical outcomes and
enhance revenue realization across pay for performance incentive programs. The
solution will bring together traditional clinical registry and point of care
clinical decision support to address patient outreach, visit management, and
data collection. The goal is to provide physicians with evidence based,
guideline-driven measures to help address selected medical conditions.
Responsibilities:
- Worked
with the customers and business analysts for requirements gathering, rules
and metadata, understanding the business and designing the solution.
- Worked
with architects and DBA in designing the rules engine and implementing the
logical and physical model based on the rules and metadata.
- Worked
with third party interface team to understand the layout and
specifications of the data files and handled the automated process of
placing the files onto development server and automate on production
server.
- Worked
with eSHare application development team to create and populate the
presentation tables and also SQL Server point of care application tables.
- Complex
mappings were designed which process the source data through rules engine
to populate the registry data mart tables.
- Extensively
used transformations like lookup, update strategy, expression, aggregator,
normalizer, filter, router, stored procedure, sequence generator, union
and rank.
- Worked
on reusable Custom Transformation by using the C, C++ functionality procedure
code.
- Worked
with mapping parameters and variables, created multiple mapplets and
reusable transformations and used them appropriately in different
mappings.
- Followed
best practices Informatica and Spectrum Health standards for EDW at
various levels of SDLC.
- Created
UNIX shell scripts to be used for pre and post processing.
- Performed
Unit test and Integration test for the process created in Informatica and
all the test cases were well documented for process improvements.
- Implemented
Informatica best tuning techniques to increase the performance of the
process.
- Complex
Oracle SQL queries were developed for validating the registry data.
- Developed PL/SQL procedures in Oracle for processing
business logic in the database.
- Performed Table partitioning for Oracle Fact tables
on bitmap Indexes.
- Created the Oracle scripts for QA releases and for
the production releases to create the list of tables in Oracle Target data
mart.
- Assisted
the Business Intelligence team in understanding the registry data mart and
also involved in Registry Universe design.
Environment: Informatica Powercenter 8.6, Oracle
10g, WRQ Reflections 13.0, TOAD 9.5, MS SQL Server 2005, SQL, Windows NT 4.0,
SQL Developer, Erwin 4.5, Business Objects XI R2.
Pfizer Pharmaceuticals – Kalamazoo , MICHIGAN
Sr. ETL Developer
Worked
on Supply Chain Regional Data warehouse Project (SCRIP), the project goal was
to consolidate various IT support and Business processes across mid-west region
to use common tools and processes in an effort to align with PGM center and
thereby reducing overall operational and support costs. All the mid-west
regional supply chain applications, data management and reporting were
standardized to use Informatica Powercenter 8.1.1 for consistent data extract
and management and Cognos 8 for consistent Reporting needs.
All the
data was extracted and consolidated into a region-wide data warehouse
accessible for business user query and reporting needs.
Responsibilities:
- Collaborated
with business analysts and DBA for requirements gathering, business
analysis and to design the data marts.
- Designed,
developed Informatica v8.1.1 mappings to extract, transform and load the
data into Oracle 10g target tables.
- Designed
and developed source to stage mappings/sessions/workflows.
- Designed
and developed stage to ODS mappings/sessions/workflows.
- Designed
and developed ODS to data mart mappings/sessions/workflows.
- Extensively
worked with heterogeneous sources from various channels like Oracle, DB2,
SQL Server and Flat Files.
- Extensively
worked on Informatica tools like source analyzer, warehouse designer,
mapping designer, workflow manager, and workflow monitor and repository
manager.
- Used
Informatica repository manager to create repositories, users, permissions
and privileges.
- Extensively
worked with XML files as Target for sending the data to the Digital field.
- Extensively
worked on Altova XML-Spy for editing the XSDs as per the requirements
before importing into Informatica and also for validating the XSDs and the
generated XML files.
- Used
Altova XML-Spy to create tables based on the XSD.
- Worked on Custom views in creating the views in the XML wizard based
on the Global elements.
- Developed
UNIX shell scripts and PL/SQL procedures.
- Extensively
worked on performance tuning of ETL mappings and sessions.
- Used
TOAD to run SQL queries and to validate the data.
- Documented
all mappings, crested effective test cases by performing unit testing and
Integration testing to ensure the successful execution of data loading
process.
- Analyzed
session log files if the session failed and resolved the errors.
- Provided
technical assistance by responding to inquiries regarding errors or
questions with programs/interface.
- Tested
the data and data integrity among various sources and targets.
- Associated
with production support team in various performances related issues.
Environment: Informatica Powercenter 8.1, Oracle
10g, AS/400 DB2, Altova XML-Spy, XML, Microsoft SQL Server 2005, MS
Access, TOAD, SQL Plus, PL?SQL, UNIX Shell Scripting, Sun Solaris 5.8, Windows
NT 4.0, Erwin 4.0.
Amerigroup Corporation – Arlington , TEXAS
Sr. ETL Developer
Worked
on “Amerivantage Medicare System Project”, which integrates the complete
information of the customers enrolled in Amerivantage Product from 11 states
into one data warehouse and to determine the effective cost and usage of the
product in turn provide its customers with better health related offers and
improved quality with lower costs.
As a
Senior ETL Consultant, my primary responsibility is working with overall
project life cycle and with team members of Amerigroup data warehouse team in
Informatica and Oracle SQL Plus.
Responsibilities:
- Analyzed
the requirements, data layout, source layout, target layout (size,
retention period) and proposed schedule (load window timings) for the
process flow.
- Base
lined ETL specs and prepared detail design documents for ETL process using
standard templates.
- Developed
source code for extraction, transformation and loading data from source to
IDW tables.
- Assisted
in updating the logical model with all related entities, attributes and
relationship with each entities based on the rules provided by the business
manager using Erwin 4.0.
- Implemented
slowly changing dimension for accessing the full history of accounts and
transaction information.
- Used
workflow monitor to monitor the job, reviewed error logs that were
generated for each session in the session log file, rectified the cause of
failure and restarted them.
- Configured
and ran the debugger from within the mapping designer to troubleshoot the
mapping before normal run of the workflow.
- Worked
with Informatica best practices guidelines to minimize performance issues.
- Mappings
developed were tested extensively based on test cases and all the tested
cases were well documented for process improvements.
- Implemented
error handling logic that involves testing of incorrect input values for
the mappings and the means of handling those errors.
- Import/Export
data from/to text files and excels spreadsheets into SQL Server 2005
database using MS SQL Server Integration Services (SSIS).
- Created
a scheduling process, which would extract and import data from text files
using SSIS packages and BCP utility.
- Worked
with SQL Server DTS packages to understand and convert them into
Informatica mappings and automated the batches to run on daily basis.
- Created
Ad-hoc reports based on predefined models using SQL Server Reporting
Services.
- Export
reports to other applications and subscribe to published reports.
Environment: Informatica Powercenter 8.1/7.2, Oracle
10g/9i, MS SSIS, MS SSRS, MS SQL Server 2005, SQL Plus, PL/SQL, Essbase, UNIX
Shell Scripting, Sun Solaris 5.8, Windows 2000, Erwin 4.0.
National City Bank – Cleveland , OHIO
ETL Developer
In
order to quickly identify customer needs and better target services to its huge
subscribers, we implemented a business intelligence system using Informatica
Power Exchange Server. With Power Exchange a large amount of customer-related
data from diverse source is consolidated, including support and service usage.
Then decision support system/analysis on this data is done using various
reporting tools to gauge the effectiveness of promotional activities.
Responsibilities:
- Gathered
the system requirements and created mapping document which gives detail
information about source to target mapping and business rules
implementation.
- Identified
the required tables and registered for changes in PX Navigator and
performed Navigator extraction map row test to validate them.
- Designed,
developed and debugged ETL mappings using Informatica 6.2 designer tool.
- Created
complex mappings using Aggregator, Expression, Joiner, Filter, Sequence,
Procedure, Connected & Unconnected Lookup, Filter and Update Strategy
transformations using Informatica Powercenter designer.
- Worked
on mapping parameters and variables for the calculations done in
aggregator transformation.
- Implemented
slowly changing dimension for accessing the full history of accounts and
transaction information.
- Tuned
and monitored in Informatica workflows using Informatica workflow manager
and workflow monitor tools.
- Created
and configured workflows, worklets and sessions using Informatica workflow
manager.
- Automated
the process of creating the flat files from source tables and then loading
the flat file data into Teradata tables using mload in Informatica through
scheduling the batches which runs on daily basis.
- Worked
with Teradata utilities like tpump, fastload and mload to load target
data.
- Scheduled
the jobs using third-party scheduler tool Autosys.
- Implemented
the
- Involved
in designing and developing universes for reporting generation from
warehouse database using Business Objects.
- Resolved
loops by creating aliases and contexts.
- Created
different types of reports like list, cross tab and etc.
Environment: Informatica Power Exchange 6.2/7.1,
Informatica Power center 6.2/7.1, DB2 UDB, Teradata V2R5.01, Business Objects
5.1 Supervisor, Business Objects Designer 5.1, Business Objects 5.1 Business
Miner, Erwin 4.0, Sun Solaris 5.8, Windows 2000, Autosys.
American Income Life Insurance – Dallas,
TEXAS Feb 2004 – Dec 2004
ETL Developer
Immediate
requirements at AIL Insurance had revealed a need to develop ad-data
warehousing solutions in order to respond to the critical data that might not
be available through existing databases. The data warehousing system is
designed to provide accurate, actionable decision support information to report
customer trends and analyze data. It serves as the single point for Reporting
needs.
Responsibilities:
- Interacted
with the design team and the users to resolve various source data issues.
- Attending
meetings to finalize strategies for handling various concepts like error
handling and slowly changing dimension.
- Used
SQL Loader to load data from flat files into tables.
- Gathered
the required information in designing and developing the property &
casualty data mart.
- Understand
the ETLs and process from Oracle Warehouse Builder and converted them into
Informatica ETLs.
- Extensively
used Informatica designer tools like source analyzer, warehouse designer,
transformation developer, mapping designer and mapplet designer.
- Developed
reusable transformations for date conversion.
- Extensively
involved in unit testing and preparing technical design documents and test
cases for the mappings.
- Created
and Configured sessions and workflows.
- Created
catalogs, created different joins according to data model specifications.
- Created
standard and Ad-hoc Impromptu Reports.
- Developed
Impromptu web reports and published using Upfront.
Environment: Informatica Powercenter 5.1/6.1, Cognos
Impromptu 6.x, Cognos PowerPlay 6.x, Oracle 7i, Oracle Warehouse Builder 9i, SQL
Server 2000, PL/SQL, Windows NT, HP-UNIX, SQL* Loader.
Charter Communications – St Louis,
MISSOURI May 2003 – Jan 2004
ETL Developer
The
objective of this project is to consolidate different regions into one global
data warehouse that supports business-reporting needs at the global and
regional level by providing view of data from all regions, which have Oracle
applications as the source of information. This project was to customization or
enhances the business needs of the data warehouse. The scope of this project
includes modification in existing Mappings/Mapplets, creation of new
Mappings/Mapplets, changes in database and writing the shell scripts.
Responsibilities:
- Developed
the detailed design document of the required data warehouse system.
- Developed
the test cases with the client for his business requirements.
- Understanding
the manufacturing business systems and building the metrics in the data
warehouse.
- Designed
and Implemented the Informatica mappings to extract data from source
system to staging and from staging to target.
- Performance
Tuning the Informatica mappings.
- Designed
PL-SQL scripts and UNIX shell scripts for pre and post session commands.
- Monitoring
the database usage and the ETL mappings so as to complete and refresh the
data warehouse within the time frame.
- Involved
in maintenance and change management process.
- Essbase
Hyperion features such as graphical interfaces, process automation and
reusable dimensions, hierarchies and business rules enable Essbase to
deliver an environment that offers the control and cost efficiency of
centralization, while enabling departments and business units latitude in
how resources are used.
- Created
universes and generated reports on using star schema.
- Designed
and developed Business Objects reports using universe and flat files.
Environment: Informatica Powermart 5.1, Informatica
Applications, Oracle 7i, Business Objects, UNIX scripting, java, Essbase
Hyperion and Sun Solaris, Clearcase.
EDUCATION:
MS, Management Science, Texas A & M University.
BE, Computer Science Engineering, Kakatiya University, INDIA.
Download Resume Format
.JPG)
0 comments:
Post a Comment