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
Jeffrey Mure
Informatica Developer
(250)310-8021
Jefffrey.mure99@yahoo.com
PROFESSIONAL SUMMARY
- Three plus(3+)
of IT Experience in Software Design, Development, Testing and
implementation of the software applications using the Data warehousing
technologies
- Experience
in installation and
configuration of
- Extensively used Informatica for ETL purposes on various
sources and targets like Flat files,
COBOL Files, Oracle 11g/10g/9i/8i, DB2
- Extensively
worked on Designer, Repository
Manager, Workflow Manager, Workflow Monitor and Repository Server
Administration Console using Informatica
ETL Tool.
- Hands
on experience in administration
tasks including importing / exporting mappings, copying folders over
the Dev/QA environments,
managing users, groups, associated privileges and performing backups of
the repository.
·
Expertise in developing SQL and PL/SQL codes through various procedures, functions, and packages to
implement the business logics of database in Oracle.
·
Experience in Unix Shell scripting
to schedule jobs like CRON tab, and perform any actions and
responses.
·
Experience
on the MIGRATION tasks from
informatica 8.1.1 to informatica 9.1.0
·
Hands on experience with OBIEE 11g admin tool in creating
repositories, interacted
with the
client to gather the requirements for generating
reports with drill down
functionalities
and Dashboards to define the
business and functional specifications.
·
Expertise in OLTP/OLAP System Study, Analysis and E-R modeling developing Database Schemas like Star flake schema and Snowflake
schema used in relational, dimensional and multidimensional modeling
- Experience
in Scheduling the INFORMATICA batch
sessions through CRON jobs.
- Monitor troubleshoots batches and sessions for weekly and Monthly
extracts from various data sources across all platforms to the target
database.
- Experience
in Dimensional Data Modeling
(Dimensions and Fact Table) using Erwin Modeling (Erwin 7.2/4.0) like
Physical & logical data modeling.
·
Worked with Oracle and SQL Server Stored
Procedures, Triggers, Cursors and Indexes
and experienced in loading data into Data Warehouse/Data Marts.
- Involved
in moving code to the production environment and implementation
- Worked for production, maintenance projects and
having knowledge on production issues.
- Proficient in understanding business processes / requirements
and translating them into technical
requirements.
- Team Player
with excellent communication, analytical, verbal, writing and
interpersonal skill.
TECHNICAL
SKILLS
ETL Tools: Informatica
Power Center 9.x/8.x/7.x/6.x, Power Mart, Power Exchange/Connect 7.1.3, Data
Quality.
Data Modeling:
Dimensional Data Modeling, Star Schema Modeling, snow-Flake Modeling, Fact and
Dimensions Tables.
Databases:
Oracle 11g/10g/9i/8i, SQL Server 2008/2005/2000, DB2
Software Tools:
TOAD, SQL* loader, oracle SQL developer, SQL Server Management studio, ERWIN
7.2/4, MS Office Suite, Visio 2007.
Reporting Tools:
OBIEE 11.1.1.5/10.1.3.x, Crystal Reports2008/XI R2, Siebel Analytics
7.5/7.7/7.8,Oracle BI APPS, Oracle BI Services, Oracle CRM
on Demand, BI Publisher, I- Bots.
Programming Languages:
C, C++, Java, SQL, PL/SQL, T-SQL and UNIX shell Scripting.
Operating System:
Windows 2000/2003, XP, Vista , DOS, UNIX
EDUCATION QUALIFICATION
Masters in
Computer Science from SILICON VALLEY
UNIVERSITY, CALIFORNIA 2010
Bachelors
in Mechatronics Engineering from
JNTU, HYDERABAD, INDIA 2006
PROFESSIONAL EXPERIENCE
Fraank
Systems, CA OCT 2011 - Till Date
Client:
PepsiCo
Sr.
Informatica Developer
PepsiCo is a world leader in
convenient snacks, foods and beverages with revenues of more than $60 billion
and over 285,000 employees.
ODS (Operational Data Store) is a
transactional data base which plays a major role in the planning area of Supply
Chain. The ODS fulfills the need of common data requirements for the supply
chain initiatives. This saves time by preventing each application from having
to duplicate effort, pulling the same or similar data. It is a collection of
centralized relational database tables that contains data such as Locations,
Products, Authorizations, and i2 Engine Results etc. The ODS maintains very
limited history. It brings data from multiple source systems together.
Replenishment Planning (RPL)
optimizes planned shipments and transportation—filling trailers, provides
optimized suggested orders to Order Mgmt
Responsibilities:
- Moving the code from DEV environment to the ITE
environment and migration of
the informatica related tasks,
databases and unix scripts.
- Prepared migration documents to move the informatica
folders from informatica 8.1.1
to informatica 9.1.0
- Prepared the documents for the connection strings of
the DEV environment of the informatica 8.1.1 which helped in order to sync
with informatica 9.1.0.
- Designed new database tables to meet business
requirement. Created databases and the scripts to the Test servers.
- Designed and created complex source to target mappings
using various transformations inclusive of but not limited to Aggregator,
Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and
Router Transformations.
- Worked on Performance
Tuning of various mappings and sessions to identify and remove Bottle Necks.
- Developed and implemented Error Handling Strategies.
- Prepared ETL standards, Naming conventions and wrote ETL
flow documentation for RPL and ODS.
- Scheduled the informatica
jobs to run on the
- Responsible for monitoring all the sessions that were
running, scheduled, completed and failed.
- Create Visio
Diagrams of Workflow, Worklet and Mapping and documenting the
processes.
- Analyzed Session Log files in case the session failed to
resolve errors in mapping or session configurations.
Environment: Informatica Power Center 9.1.0/8.1.1,
Flat files, Oracle 11/10g, Excel, XML, Toad, Erwin 7.2,
L, Unix AIX 6.1, Windows XP, Reflection ESP Mainframe, Visio2007
SKORUZ
, CA
DEC
2009- SEP 2011
Client:
Vmware
Informatica Developer
Responsibilities:
- Analyzed
the functional specs provided
by the data architect and created technical specs documents for all the
mappings.
- Extracted data from
heterogeneous sources like
DB2, Informix, AS/400, Oracle, TOAD, Fixed width and Delimited Flat files and transformed the data
according the business requirement and then Loaded into multiple databases
- Developed
standard and reusable mappings
and Mapplets using various
transformations like expression,
aggregator, joiner, source qualifier, router, lookup, and filter.
- Implemented
Type 2 slowly changing dimensions
to maintain dimension history and Tuned the Mappings for Optimum
Performance
- Configured
the mappings to handle the updates to preserve the existing records using Update Strategy Transformation
- Created
many reusable tasks and used
them in different Worklets,
Workflows and scheduled Worklets.
- Extensively
worked in the performance tuning
of mappings and sessions.
- Involved
in Unit Testing and System Integration Testing
- Successfully
moved the Mappings, Sessions and workflows from the Development
environment to Production environment.
- Worked
on daily issue in the production environment
- Optimize
the current system and load process, by developing better techniques
- Solving
problem tickets within the specific timeframe
- Monitor
the Sessions and Workflows, if any Session or Workflow fails then investigate the reason & run it
again
- Created
complete documentation in
relation to detailed work plans, mapping documents and high-level data models.
- Interacted with OBIEE Analysts to assist them in Understanding the Source and
Target System.
Environment: Informatica Power Center 9.1/8.6.1,
OBIEE11g/10g, Oracle 11/10g, SQL, MS
Access, Excel, XML, SQL Server 2008, Toad, Erwin 7.2, HTML, Unix, Windows 2003
7Seas Technologies Inc, INDIA
Oracle
Developer
7Seas
Entertainment Limited is the first ISO 9001-2008 certified independent games
Development Company from India
Responsibilities:
·
Created
dimensional data model for different modules using Erwin3.5.
·
Developed
complex SQL queries and PL/SQL packages, including stored procedures &
functions, to fetch data for reporting and to accomplish several computations.
·
Developed
complex PL/SQL triggers.
· Developed several forms and reports in the process.
Also converted several standalone procedures/functions in PL/SQL to packaged
procedure for code reusability, modularity and control.
·
Rendered
Software design, development services applying oracle database and application
development products (Forms, Designer, PLSQL and SQL) to Financial Services,
Government, Retail and High- Tech Clients.
·
Developed and managed a team of 5
engineering resources.
Environment:
Oracle 7.3, SQL*Loader, Erwin3.5 and Windows 2003.
Download Resume Format
.JPG)
0 comments:
Post a Comment