USA Resume
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
Subhajeet Jana
Senior DW
ETL/Informatica Developer, Emblem Health
newyork city,
NY 10001
US
US
Home: -
Mobile: -
Resume
ETL/Informatica Developer
please call me
on : 552-751-2278
Please send the
requirements to plm@shivntech.com
ETL/Informatica
Developer
Profile:
·
8 years of
total IT experience
·
6 years of
Informatica experience
·
4 Years of Data
Modelling experience
·
4 years of
Business Intelligence experience
Summary:
·
SDLC: 7 years of IT experience in System Analysis, Design,
coding and testing of Data Warehousing implementations across Financial,
Insurance and Telecom Industries.
·
Informatica: 6 years of Data Warehousing experience using Informatica
Power Center 8.0, PowerMart 6.1, Warehouse Designer, PowerConnect for
Siebel/DB2, Power Exchange, Power Analyzer, Power Plug, ETL, Siebel
7.0/2000/5.5, Siebel Warehouse 6.3, Siebel EIM, OLAP, OLTP, Autosys, Control M,
Sybase.
·
Data Modeling: 4 years of Dimensional Data Modeling,
ERwin 4.5, Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake
Modeling, Datamarts, OLAP, FACT & Dimensions tables, Physical & Logical
data modeling and Oracle Designer.
·
Data Cleansing: 3 years of Data Cleansing experience
using Trillium 7.6/6.5 (Converter, Parser, and Converter & Geocoder),
Firstlogic 4.2/3.6, UNIX Shell Scripting and SQL coding.
·
Business Intelligence: 4 years of Business Intelligence
experience using Cognos 7.0/6.0/5.x, Business Objects 6.5/6.0/5.1.
·
Tools: 7 years of experience using Oracle 10g/9i/8i/8.0/7.0,
DB2 8.0/7.0/6.0, MS SQL Server 2005, Teradata V2R5, Sybase 12.x/11.x, SAP R/3,
MS Access 7.0/2000, Oracle Report Writer, SQR 3.0, Erwin 3.5/3.x, SQL, XML,
PL/SQL, SQL*Plus, SQL*Loader and Developer 2000 and Sun Solaris
2.x./2.6/2.7/2.8/8.0.
TECHNICAL SKILLS:
Data
Warehousing
|
Informatica Power Center 8.x/7.x, Power Mart 6.2/5.x,
Informatica Power Analyzer, I ETL, Datamart, OLAP, OLTP.
|
Dimensional Data Modeling
|
Data Modeling, Star Schema Modeling, Snowflake
Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling,
ERWIN 4.5
|
BI Tools
|
Business Objects 6.5/6.0, Cognos Series 7.0/6.0
|
Databases
|
Oracle 10g/9i/8i, IBM DB2 UDB 8.0/7.0, MS SQL Server
2000/7.0, Sybase 12.x/11.x, MS Access
|
Programming
|
SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, Unix
Shell Scripting, Kernel Programming
|
Environment
|
UNIX (Sun Solaris, HP-UX, AIX), Windows
2003/2000/XP/98, Sun-Ultra, Sun-Spark, Sun Classic, RS/6000, HP 9000, Compaq
Tru64, SCO Unix
|
Professional Experience:
Emblem Health,
NY
Sep '09 - Till Date
Informatica Developer
Emblem Health a leading health insurance provider is an
Integration of HIP (Health Plan of New York) which provides access to physician
services and hospital care in a variety of ways and GHI (Group Health
Incorporated) which offers customers a variety of PPO, EPO, and HMO programs,
as well as prescription drug, dental, and vision plans. The purpose of this
project was to feed the Thompson's Medstat system with modified HIP data
structure and associated data elements.
Responsibilities:
·
Worked with
Business analysts for requirement gathering, business analysis, and testing and
project- coordination.
·
Analyzed source
data and gathered requirements from the business users.
·
Worked on
understanding and creating ETL Design documents and specifications.
·
Prepared
technical specifications to develop Informatica ETL mappings to load data into
various tables confirming to the business rules.
·
Developed
mappings with transformations and mapplets confirming to the business rules.
·
Designed and
developed complex Informatica mappings using different transformations to
ensure movement of the data between various applications.
·
Created
different transformations for loading the data into target database using e.g.
Source Qualifier, Joiner transformation, Update Strategy, Lookup
transformation, Rank Transformation, Expressions, Aggregator, Sequence
Generator.
·
Scheduled and
monitored developed Workflows, Worklets for Mappings using Workflow manager to
load data from Source flat files and RDBMS Oracle 9i tables to Target tables.
·
Created
workflows and worklets to run several sessions sequentially and concurrently.
·
During
Implementation phase, tuned Informatica Mappings for optimum performance.
·
Extensively
worked on the performance tuning of the Informatica Power Center Mappings as
well as the tuning of the sessions, SQL Queries for better performance.
·
Provided
Knowledge Transfer to the end users and created extensive documentation on the
design, development, implementation, daily loads and process flow of the
mappings.
·
Automated the
Data Load processes to target Data Warehouse.
·
Involved in the
entire UAT support of the Application.
Environment: Informatica Power Center 8.5, PL/SQL, Oracle 9i, Toad,
UNIX, SQL*Loader, DB2, Windows 2000
Hartford
Insurance,
CT
Dec
'0 - July09
Senior DW Informatica Developer
HARTFORD is one of the nation's leading Insurance
providers, which offer a variety of products and services including life
insurance, property, auto, business and home insurance. The primary Objective
was to develop Data warehouse using Informatica PowerCenter for Insurance
Claims Department to achieve single point of reference to get the customer data
from the source databases.
Responsibilities:
·
Designed and
developed end-to-end ETL process for Sales Data Mart.
·
Worked with
Business analysts for requirement gathering and Analyzed source data and
gathered requirements from the business users.
·
Studied and
analyzed the existing OLTP system(s) and Created facts, dimensions and star
schema representation for the Data mart.
·
Analyzed the
Informatica from the source systems to create a road map for the Data warehouse
designing.
·
Extensively
worked on Informatica to extract data from flat files and Oracle, and to load
the data into the target database.
·
Used
First Logic as a Data Cleansing tool to correct the data before loading into
the staging area
·
Created
Informatica mappings with PL/SQL procedures to build business rules to load
data. Most of the transformations were used like the Source qualifier,
Aggregators, Connected & unconnected lookups, Filters & Sequence.
·
Created
Worklets to run several sessions sequentially and concurrently
·
Writing PL/SQL
procedures for processing business logic in the database
·
Tuned
Informatica Mappings for optimum performance.
·
Tuning of SQL
queries for better performance.
·
Developed
various reports using the BI tool to generate reports for the Sales department
and Marketing representatives.
·
Generated Adhoc
reports using the Business Objects free hand SQL. Extensively used Autosys for
scheduling of the UNIX shell script jobs
·
Used Pmcmd
command in the UNIX shell scripts. Did the unit testing and helped in the
process of integration testing
Environment: Informatica PowerCenter 8.0, Erwin
4.5, Business Objects 6.0, Autosys, PL/SQL, Oracle 10g/9i, SQL Server
2000, SQL*Loader, SCO-UNIX, Windows 2000
McDonalds, IL
Mar'05
- Nov'06
Senior DW Informatica Consultant
This project mainly involves the development of Customer
Master File which is an Operational Data Store and Customer Data Mart to
develop analytics for CRM.The CMF receives data from different sources in
different format such as Flat Files and Xml Files.This involves Batch and Real
time movement of data between the systems.
Responsibilities:
·
Designed the
Mapping Technical Specifications on the basis of Functional Requirements.
·
Developed ETL
procedures to ensure conformity, compliance with standards and lack of
redundancy, translating business rules and functionality requirements into ETL
procedures.
·
Performed
Informatica Administrator functions like Creating Users, Folders, giving
permissions on the folders to the Users.
·
Created shared
folders, local and global shortcuts to reuse metadata.
·
Imported the
sources using Power Connect webMethods.
·
The objective
is to extract data stored in different sources such as Flat Files, XML Files,
Oracle and to load finally into a single Data Warehouse Oracle.
·
Wrote UNIX
shell scripts for automating the process.
·
Developed and
implemented Error Handling Strategies.
·
Created and
Monitored Workflows, Work lets and Sessions.
·
Developed and
tested all the backend programs, Informatica mappings.
·
Scheduled and
monitored developed Workflows, Worklets for Mappings using Workflow manager to
load data from Source flat files and RDBMS Oracle 9i tables to Target tables.
·
Worked in the
performance tuning of the programs, ETL Procedures and processes.
·
Automated the
Data Load processes to target Data Warehouse.
·
Involved in the
entire UAT support.
Environment: Informatica Power Center V7.1,
Informatica Power Analyser4.1, Power Connect For webMethods, webMethods6.x,
Oracle9i, Windows 2000, UNIX AIX, ERWIN, TOAD
BancFirst Bank,
OK
Jun'04
- Feb'05
ETL / Informatica Consultant
The BancFirst Bank Business
Intelligence solution is to identify and retain the most profitable portion of
its customer base, attract new customers with similar profiles, and increase
the overall effectiveness of its marketing programs and overall profitability.
Responsibilities:
·
Involved in
design, development and maintenance of Data Marts using Erwin 4.0.
·
Developed
various Mappings with the collection of all Sources (Oracle, DB2 UDB, Sybase,
Flat Files, and XML files), Targets (Oracle), and Transformations.
·
Constructed
mapplets with the help of Mapplet Designer and used those Mapplets for reusable
business process in development.
·
Conducted
performance tuning on sessions by optimizing block size, data cache size,
sequence buffer length, by pipeline partitioning and commit interval.
·
Wrote PL/SQL
stored procedures for processing business logic in the database. Tuning of SQL
queries for better performance.
·
Created and
managed the global and local repositories and permissions using Repository
Manager in Oracle Database.
·
Used different
Data Warehouse techniques like Star-Schema.
·
Created various
data Marts from data warehouse and generated reports using Business Objects.
Environment: Informatica PowerCenter
6.2/7.1, PowerMart, ERwin 4.0, XML, Sybase, Oracle9i, DB2 UDB, Toad, SQL*Plus,
UNIX and Windows 2000/NT.
Amerisure
Insurance, MI
Jan'
03 - May' 04
ETL/Informatica Consultant
The Insurance Company started to build a data warehouse
system to evaluate policyholders and setup regional markets. The code involved
reading from complex sources like Oracle, Sybase, SQL Server, and flat files,
having variable length records, performing various transformations and writing
to proprietary target systems in a specified format.
Responsibilities:
·
Involved in
Analysis and design of table structure for the development of Data Warehouse
and Data Marts.
·
Created generic
scripts for the extraction of data from different source systems to staging.
·
Created complex
mappings for extraction, transformation and loading from flat files to targets
(Teradata).
·
Developed
reusable Mapplets and Transformations.
·
Maintained
custom session logs to administer error on scheduled Workflow.
·
Incorporated
email facility into the Workflow for better process management.
·
Extensively
applied performance tuning to the programs, ETL procedures and processes.
·
Testing for the
Data integrity and Consistency.
·
Created
dimensional cubes for web reporting using Informatica and reporting tools.
·
Created
Universes in Business Objects to support the requirements of business users.
·
Analyzed and
generated reports as per requirements.
Environment: Informatica 6.1(PowerCenter,
PowerMart) , Business Objects 5.0,Erwin, SQL *Plus, Teradata V2R4, Oracle 9i,
SQL, Sybase, DW builder, Unix, Windows 2000/NT, SQL Server 7.0, TOAD.
US Cellular,
IL
Feb
'02 - Dec'02
DW Informatica Developer
US Cellular Corporation provides wireless service to
several major metropolitan markets as well as mid- and small- sized cities.
U.S. Cellular provides its customers with many different wireless products and
services. Enterprise Data Warehouse (EDW) is carried out of US Cellular for
their Billing, Retail Management System and, Warehouse Management System.
Responsibilities:
·
Attended
Business meetings and did Business Analysis and gathered the requirements.
·
Designed ETL
functional specifications and converted them into technical specifications.
·
Developed a
data mart for fund performance to support the reporting requirements.
·
Developed
Logical and Physical data models that capture current state/future state data
elements and data flows using Erwin.
·
Developed ETL
methodology to custom fit the ETL needs of Fund Performance.
·
Applied Audit
and control checking at the stage, and ODS. Also ensured referential integrity
at each and every phase (Source to stage, Stage to ODS, and ODS to Datamart).
·
Developed a
UNIX Shell scripts which will send the reports to client over the network by
using file transfer protocol (FTP) and generating the log file, which will keep
the history for the FTP reports.
·
Worked on
Informatica - Source Analyzer, Data warehousing designer, Mapping Designer
& Mapplet, and Transformations. Configuration and Administration of
Informatica Servers.
·
Extensively
worked in the performance tuning of the programs, ETL Procedures and processes.
·
Made
performance improvements to the database by building Partitioned tables, Index
Organized Tables and Bitmap Indexes. Worked on Data Analysis reports Business
Objects.
Environment: Informatica PowerCenter 4.7, Erwin
3.0, MS SQL Server 2000, Oracle 8i, PL/SQL, Business Objects, IBM MQ series, MS
Access 2000, Shell Programming, SQL * Loader, IBM DB2 UDB 7.0, Mainframes,
OS/390, JCL, Sun Solaris, Toad, SQL Navigator, Excel and Unix scripting,
Windows NT
MCI WorldCom,
IL
Aug'01
- Jan'02
Informatica Developer
Developed a business intelligence system to quickly
identify customer needs and better target services using Informatica
PowerCenter software. With PowerCenter a large amount of customer-related data
from diverse sources was consolidated, including customer billing, ordering,
support and service usage. Then decision support system analysis on this data is
using various BI tools to support the Daily/Monthly activity summary of the Gross Adds/Net Adds/Disconnects of the subscribers for the sales team.
using various BI tools to support the Daily/Monthly activity summary of the Gross Adds/Net Adds/Disconnects of the subscribers for the sales team.
Responsibilities:
·
Analysis,
requirements gathering, functional/technical specification, development,
deploying and testing.
·
Significant
Multi-dimensional and Relational data modeling experience with modeling tools
like ERwin with a strong emphasis on Data Warehouse/Data Marts analysis,
design, and implementation.
·
Extracted
source data from Oracle, SQL Server, using Informatica, and loaded into Targets
(Oracle).
·
Created
Informatica Mappings for initial load and daily updates.
·
Involved in
testing of Informatica Mappings.
·
Developed,
tested Stored Procedures, Functions and Packages in PL/SQL.
·
Involved in
fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and
Integration Testing of Informatica Sessions, Batches and the Target Data.
·
Extensively
used Mapping Parameters, Mapping Variables and Parameter files.
·
Analyzed the
query performance and designed the loading process schedules.
·
Created
sessions and batches for various mappings and automated using UNIX shell
scripts.
· Involved in
troubleshooting the loading failure cases, including database problems.
Environment: Informatica PowerCenter 5.0,
PowerMart, Business Objects, Oracle, PL/SQL, SQL Server, Windows 2000, and
UNIX.
Jim Mobile, Hyd,
India
Mar'00
- Jul'01
Oracle Developer
JMI responds to market demands in a fraction of the time
it takes most manufacturers. We often go from the idea stage to a
working prototype in less than 24 hours. Of course, they are always
working on improvements throughout the lifetime of the products. It
definitely is an exciting place to work. Designed and developed customer
Database (CDB) for a Telecommunication company.
This CDb system helps the customer service
representatives to perform all their duties helping customers in assisting
their problems and questions. This project also helps the representatives in
update, delete, modify customer profile and also arrange for bill payments.
Responsibilities:
·
Designed and
developed a Generic Billing System for a Telecommunication company
·
Created tables,
Indexes, sequences, constraints and snapshots.
·
Developed
packages, procedures and functions. Developed many PL/SQL blocks for the
validation of the forms.
·
System study,
analysis and prepared the system design document & prototypes.
·
Developed SQL
queries for the manipulation of data.
·
Generated
periodic reports using Reports Designer.
·
Prepared the
test plan and test cases document.
Environment: Oracle 7.3/8.0, Developer 2000
(Forms 4.5 & Reports 2.5), SQL PLUS, PL/SQL, Windows NT.
Additional Info
Career Information
Most recent
employer
Emblem Health
Relevant work
experience
-
Highest
Education
Bachelor's
Degree
Career Level
Experienced
(Non-Manager)
Availability
-
Location
US-NY-newyork
city
Relocate
Will Relocate
Travel
Up to 100%
Willing to work
weekends
-
Active security
clearance
-
Willing to work
shifts
-
Target Job
Company size
-
Desired status
Part Time
Job type
Temporary /
Contract / Project
Salary
-
Locations
US
Work
authorization
US - I am
authorized to work in this country for any employer.
Job titles
Senior DW
ETL/Informatica Developer;
Senior DW ETL/Informatica Develope
Senior DW ETL/Informatica Develope
Industry
Computer
Software
Occupation
Database
Development/Administration
Enterprise Software Implementation & Consulting
General/Other: IT/Software Development
IT Project Management
Usability/Information Architecture
Enterprise Software Implementation & Consulting
General/Other: IT/Software Development
IT Project Management
Usability/Information Architecture
Download Resume Format
.JPG)
0 comments:
Post a Comment