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
SUMMARY
TECHNICAL SKILLS
Technical Specialties
PROFESSIONAL
EXPERIENCE
Download Resume Format
Farah
248 504 9876
farah@gmail.com
SUMMARY
·
6+
years of IT experience majorly in Data warehousing and Business
intelligence with emphasis on Business Requirements Analysis, Application
Design, Development, testing, implementation and maintenance of Data Warehouse
and Data Mart systems in the Medical Instruments and supplies, Financial
service , Retail, Wind Power,
Aerospace, Transportation and Manufacturing
industries.
·
Involvement in all phases of SDLC (Systems Development Life Cycle) from
analysis and planning to development and deployment.
·
4+years of
development and design of ETL (Extract , Transform and Loading data)
methodology for supporting data transformations and processing, in a corporate
wide ETL Solution using Informatica PowerCenter (9.x/8.x/7.x/6.x/5.x).
·
4+ years of experience with relational
databases such as Oracle 8i/9i/10g/11i, SQL SERVER 2000/2005.
·
3+ years of experience in OLTP
Modeling (2NF,3NF) and OLAP
Dimensional modeling (Star and Snow
Flake)
·
3+
years of experience in UNIX Shell Scripting (IBM AIX, Sun Solaris)
·
2+ years of experience in Cognos 8 BI (8.3,
8.4, 10.1). [ Framework Manager, Report Studio, Query Studio, ,Cognos connection ]
·
2+ years of experience in Informatica
administration like installations, configurations, etc on Informatica
PowerCenter (9.x/8.x/7.x)
·
Strong skills in SQL, PL/SQL
packages, functions, stored procedures, triggers and materialized views to
implement business logic in oracle database.
·
Experience with Database SQL tuning
and query optimization tools like Explain Plan.
·
Experience in Oracle 8i/9i/10g/11i systems,
SQL*Loader, Import and SQL*Plus, DBMS Packages.
·
Experience in moving the Program Files (FTP) to the
server by using the Tools like FileZilla, WINSCP, Putty and Telnet.
·
Strong Data cleansing / Data Migration experience
using ETL Informatica.
·
Extensively
worked on developing Informatica Mappings, Mapplets, Sessions, Worklets
and Workflows for data loads.
·
Experience
in identifying and resolve ETL production root cause issues. Experience in maintenance, enhancements, performance
tuning of ETL code.
·
Knowledge
of Informatica administration in windows and Linux environment.
·
Knowledge
of reporting tool OBIEE.
·
Knowledge
of Business objects Enterprise XI 3.1, Universe
designer, Web intelligence, Desktop intelligence, etc.
·
Worked with Cognos 8.3/8.4/10.1
BI Framework Manager to create BI metadata modeling. Experience in using Query studio, Report Studio in creating
ad-hoc and complex reports.
·
Developed test case’s
for business and user requirements to perform System / Integration / Performance testing.
·
Continuously
monitor the accuracy of the data and the content of the delivered reports.
·
Provided off-hour and weekend production
support on a rotational, on-call basis.
·
Carried out training sessions, presentations for end-users
(Business users).
·
Strong analytical and problem
solving skills.
·
Sound experience in mentoring/leading a team in Onsite-Offshore model project execution
·
Team and Independent Player with excellent Organizational and
Interpersonal skills. Excellent written and oral communication skills.
EDUCATIONAL
QUALIFICATIONS
·
Masters
in Management and Information Systems , SIUe, IL, USA
·
Bachelors
in Computer Science, JNTU, India
TECHNICAL SKILLS
ETL Tools
|
Informatica PowerCenter 9.0.1/8.6/8.5/8.1.1/7.1
|
Reporting Tools
|
Cognos BI 10.1/8.4/8.3, Business Objects Enterprise XI, Desktop
Intelligence 12.1.0.914, Web Intelligence,
Universe Designer 12.1.0.914, OBIEE
|
Data Modeling
|
ERWin Data Modeler r7.3/4.x (ERD) , MS Visio 2000
|
Databases
|
Oracle 8i/9i/10g/11i, MS SQL Server 2000/2005, MS
Access
|
Database Utilities
|
TOAD 8.x , SQL*Plus ,
SQL*Loader, PL/SQL Developer
|
Operating Systems
|
Linux (Red Hat), UNIX (Solaris, AIX v5.2), Windows
(NT, 2000, 2003, XP)
|
Languages
|
SQL, Oracle PL/SQL , T-SQL , Korn Shell Scripting
(KSH), C++, Java, J2EE, XML
|
Others
|
Microsoft Office 2010 (Excel, PowerPoint), WINSCP,
PUTTY, FileZilla, FTP, SFTP, SCP, Telnet.
|
Technical Skills
Software: Oracle Developer/Designer, SAP 4.6c & ECC 6.0,Mercury
Quality Center, Rational Rose, Microsoft Visio, Microsoft Access, Microsoft
Excel, Informatica Power center 7.1/8.1.1/8.5/8.6/9.0.1, SQL Server Management
Studio, Microsoft Project, Cognos 8 BI 8.1/8.3, Business Objects Enterprise XI
3.1, Desktop
Intelligence 12.1.0.914, Web Intelligence,
Universe Designer 12.1.0.914, Oracle 9i/10g/11i
Software Languages: SQL, PL/SQL, C, C++
Platforms: Windows 98 / Me / NT / 2000 / XP / 2003, UNIX, Linux
Technical Specialties
DWBI: Data Modeling, Data
Warehousing, Business Intelligence, ETL Informatica, Informatica with SAP, Informatica
with Oracle, Cognos 10.1/8.4/8.3 BI Reporting and Oracle PL/SQL Database.
PROFESSIONAL
EXPERIENCE
Noetix Corporation Aug’09
– Current
Consultant
Top three projects
that I worked through Noetix are as follows:
Client: Invacare
Corporation, Elyria, OH Sept’11- Feb’12
Role: Lead DW/BI Consultant (of Noetix
Corporation)
Global Management
Reporting (GMR) system: GMR system was global warehouse
developed to provide timely visibility to global sales (Europe, Canada, North America,
New Zealand and Australia) and standard margins by product.
Responsibilities:
·
Interacted with Business users/Managers (Line of Business) to
understand requirements and translated them into the appropriate technical
solution.
·
Implemented Noetix Analytics solution(packaged analytics solution
that simplifies implementation of enterprise data warehouse)
·
Actively involved in designing, developing, creating Mappings, Mapplets
using Informatica source, warehouse and loading the data.
·
Worked with Informatica Power Center to move data from multiple
sources into a common target area such as Data Marts and Data Warehouse.
·
Scheduled the workflows using Informatica scheduler and enhanced
the data mart as per business specifications.
·
Took part of Informatica administration. Migrated development
mappings as well as hot fixes them in production environment.
·
Performed DEV, QA and Code review for my code.
·
Responsibilities
included designing and developing complex Informatica mappings including
Type-II slowly changing dimensions.
·
Identified,
researched, and resolved ETL root cause of production issues or system
problems.
·
Performance
tuned ETL programs, Maintenance and enhancements of ETL code.
·
Administered cognos environment, installed hot fixes
to fix bugs in product, etc.
·
Implemented Row level security in Cognos 10.1.
·
Created and published packages in Cognos Frame work
manager 10.1.
Environment:
Informatica 9.0.1, TOAD, Oracle11g, Cognos 10.1, UNIX
General
Electric Shared services, Atlanta, GA Jun’10-
Dec’10
Role: Lead DW Consultant (of Noetix
Corporation)
Buy to Pay Global
Data warehouse: This global warehouse was setup
to facilitate Global Executive management reporting of the AP, PO data from
around 30 different sources (BAAN, SAP, ORACLE, FLAT FILES, etc) for their
Buy-to-pay program.
Responsibilities:
·
Interacted with Business users/Managers, Program managers (Line of
Business) to understand requirements and translated them into the appropriate
technical solution.
·
Implemented Noetix Analytics solution (packaged analytics solution
that simplifies implementation of enterprise data warehouse) for each of the
sources.
·
Actively involved in designing, developing, creating Mappings, Mapplets
using Informatica source, warehouse and loading the data.
·
Worked with Informatica Power Center to move data from multiple
sources into a common target area such as Data Marts and Data Warehouse.
·
Scheduled the workflows using Informatica scheduler and enhanced
the data mart as per business specifications.
·
Provided instructions to GE for migration of development mappings,
sessions, workflows and worklets in production environment.
·
Assisted GE Team in code migration from DEV to QA to PROD.
·
Performed DEV, QA and Code review for my code.
·
Monitored the migration process closely and fixed issues
(if any).
·
Identified,
researched, and resolved ETL root cause of production issues or system problems.
·
Performance
tuned Informatica mappings, sessions, etc. Maintenance and enhancements of ETL
code.
·
Coordinated
weekly meetings with GE program managers, project leads to discuss the status
of previous week and the action plan for the upcoming week.
Environment:
Informatica 8.1.1, TOAD, Oracle11g, UNIX
GE Transportation,
Erie, PA Feb’11- Apr’11
Role: Lead Informatica Consultant (of Noetix
Corporation)
Delete Detection
Implementation: Implemented delete detection
functionality on the existing data warehouse so that as soon as the data gets
deleted in the oracle EBS source, the corresponding records will also be
deleted from Target data warehouse.
Responsibilities:
·
Interacted with Business users/Managers to understand requirements
and translated them into the appropriate technical solution.
·
Implemented Noetix Analytics delete detection functionality for
major FACT, DIMENSION, DETAIL, MASTER tables.
·
Actively involved in designing, developing, creating Mappings,
Mapplets using Informatica source, warehouse and loading the data.
·
Created test cases and scenarios to test the delete detection
functionality.
·
Performed testing and data validation in DEV environment.
·
Provided instructions to GE for migration of development mappings,
sessions, workflows and worklets in production environment.
·
Assisted GE Team in code migration from DEV to QA to PROD.
·
Performed DEV, QA and Code review for my code.
·
Monitored the migration process closely and fixed issues
(if any).
·
Identified,
researched, and resolved ETL root cause of production issues or system
problems.
·
Performance
tuned Informatica mappings, sessions, etc. Maintenance and enhancements of ETL
code.
Environment:
Informatica 8.1.1, TOAD, Oracle11g, UNIX
Other short
term projects(less than 2months) I worked on (through Noetix):
Navilyst
Medical
Role: Informatica Consultant (of Noetix
Corporation)
Project: Analyzed requirement of
sourcing new Oracle EBS tables and implemented those enhancements (new tables,
columns) in the existing data warehouse
GE Nuclear
Role: Informatica Consultant (of Noetix
Corporation)
Project: Implemented a new Oracle EBS
module of ‘Enterprise Asset Management’ in the existing data warehouse.
Arvin Meritor
Role: Informatica Consultant (of Noetix
Corporation)
Project: Implemented some enhancements
(new tables, columns) in the existing data warehouse
CVS Pharmacy (Europe
and North America)
Role: Informatica Consultant (of Noetix
Corporation)
Project: Implemented some enhancements
(new tables, columns) in the existing data warehouse
Jaros
Technologies, Granite City, IL Dec’08-
Aug’09
Role: Informatica/Cognos Developer
Responsibilities:
·
Participated in engineering, development and Support of Jaros
Analytics product (Packaged Enterprise Data warehousing solution, which later
became Noetix Analytics after Jaros Technologies was acquired by Noetix
Corporation).
·
Participated in analysis of Oracle EBS tables to design, develop new
objects to be sourced into the Jaros Analytics Product (Packaged enterprise
Data warehousing solution).
·
Actively involved in designing, developing, creating Mappings,
Mapplets using Informatica source, warehouse and loading the data.
·
Worked with Informatica Power Center to move data from multiple
sources into a common target area such as Data Marts and Data Warehouse.
·
Scheduled the workflows using Informatica scheduler and enhanced
the data mart as per business specifications.
·
Identified,
researched, and resolved ETL root cause of production issues or system
problems.
·
Performance
tuned Informatica mappings, sessions, etc. Maintenance and enhancements of ETL
code.
·
Provided
on call support to GE on rotation basis even on the weekends.
·
Migrated
cognos reports and dashboards from 8.4 to 8.3(backward migration).
Environment:
Informatica 8.1.1, TOAD, Oracle11g, UNIX, Cognos 8.3, Cognos 8.4
United States
Steel Corporation, Granite City, IL May’08-
Dec’08
Role: ETL Developer
Responsibilities:
·
Participated in Development,
deployment and support of database objects (stored procedures, triggers, etc)
to populate data warehouse for Steelmaking Process Control Project
·
Participated
in user sessions (with business users, analyst and other managers) to
understand the business specific requirements
·
Participated in design and development of ETL procedures for cast
heat, slabs area to load these data sources into data warehouse.
·
Participated in Unit
testing and System Integration Testing the stored procedures, functions and
triggers.
·
Created
test plan, test cases to test the database objects.
·
Provided
production support for any issues related to the database objects (procedures,
functions and triggers) of the project.
Environment: Oracle 9i/10g, SQL, PL/SQL, UNIX, Cognos 8.3
St. Clair
County Housing Authority, Belleville, IL Jan’07-
Dec’07
Role: Database projects Developer
Responsibilities:
·
Participated in user meetings to gather new business requirements
for new projects or change requests to the existing projects.
·
Managed and maintained three major in-house database projects
namely, Utility Database, Interim, community service tracking system.
·
Developed reports from these data bases as per business
requirement to support business decision making.
·
Participated in analysis of Oracle EBS tables to design, develop
new objects to be sourced into the Jaros Analytics Product.
·
Provided
on call support to GE on rotation basis even on the weekends.
·
Migrated
cognos reports and dashboards from 8.4 to 8.3(backward migration).
Environment:
Microsoft Access, SQL, Microsoft Excel, Some custom applications, Windows 2000
Galaxy Software
Solutions, India Jan’06-
May ’06
Role: Database Developer
Responsibilities:
·
Participated in user meetings to gather new business requirements.
·
Participated in design and development of a HRM software solution
(using Java/J2EE, Oracle, ASP) for an organization
·
Managed timely delivery/completion of each phase, activity or
deliverable and the project as a whole.
·
Participated in designing database structures to meet the business
needs.
·
Participated in presentations and training to the users about the
final product.
·
Lead the project team of 3 people and coordinated project and team
from start to finish.
Environment:
Oracle
9i/10g, SQL, PL/SQL, UNIX, Java
Download Resume Format
0 comments:
Post a Comment