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
Cal i
Circuit
City , Richmond VA
Dakota State University ,
Madison
Jawaharlal Nehru National
College of Engineering, India
Download Resume Format
Executive Summary
·
Over 7+
years of experiance in Data
Analysis, Application Design, Data Modeling , Application Development,
Implementations and Testing in Data
Warehousing as different segments in SDLC.
·
Strong OLAP knowledge in Health Care, Pharmaceuticals, Insurance, and Banking.
·
Maintained outstanding relationship with
Business Analysts and Business Users to identify information needs as per
business requirements.
·
Having strong
skills in Designing, Coding,
Development, Implementation and Testing of Business Applications with
Web-enabled, Three tier and Client/Server environment using Informatica, Cognos Impromptu, Cognos 8.x,
Business Objects 5.0/5.1/6.1 on UNIX
and Windows Platforms.
·
Involved in developing Logical and Physical Models using Erwin and Microsoft Visio.
·
Having extensive hands-on technical
proficiencies in developments using databases like Oracle 11g/10g/9i/8.x, SQL Server 2000/2005/2008 and DB2.
·
Experience in creating and using Stored Procedures, Functions, Triggers,
Views, Synonyms, and Packages in
different databases.
·
Strong experience in Compliance and FDA
Regualated environments.
·
Implemented performance-tuning techniques at application, database and system
levels.
·
Strong knowledge on Project & Change Management, SDLC and System Analysis & Design.
·
Extensive experience in Oracle Packages, Stored Procedures, Functions and Database
Triggers using PL/SQL.
·
Expertise in preparing and running Mappings, Sessions/Tasks, Workflows,
Worklets, and Batch processes on
Informatica Server.
·
Good exposure to development, testing, debugging, implementation, documentation, and
production support.
·
Highly
skilled, motivating team player with outstanding Organizational and
Inter-personal skills.
Technical Skills
Database Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005//2000,
DB2, Teradata
ETL
Tools Informatica PowerCenter 5.1/6.1/7.1.2/8.1.0,
SSIS 2005
BI
Tools Cognos 6.0/7.0/8.x, Business Objects 6.1, SSRS
2005
GUI Visual Basic 5.0/6.0. ASP.net
Languages C, C++, Java, C#, XML, SQL and PL/SQL
Data
Modeling Erwin,
MS Visio
Operating
Systems MS Windows 2000/NT 4.0/98/95/XP, UNIX
ALM
Tools CaliberRM, Perforce, FogBugz, SilkCentral , Wi
Scheduling
Tools Autosys
Management Skills
Project
Management Microsoft
Project, FogBugz
Business
Analysis IBM Rational Rose
Requisite Pro, Cal i
Change
and Configuration Perforce,
Documentum, Microsoft Visual Source Safe
Management
Education
- Master
of Science in Information Systems (MSIS),
Specialization: Data Warehousing and
Data Mining,
- Bachelor
of Engineering in Computer Science & Engineering,
Training
·
Cognos
8i Training provided by Sentries Inc
·
Cognos Advanced
Report Author Training provided by IBM
·
Web Usability Boot
camp by Construx
·
Software
Development life Cycle 10.x by Construx
·
Informatica
7.x/8.x trainings by Informatica Corp.
·
Several webinars on
Advanced Concepts in Data Warehousing
·
IBM Special
Seminars on disaster recovery in order to be classified a Disaster Recovery
Specialist
Professional Experience
Abbott
Vascular, Temecula , CA
Data
Warehouse Analyst / Sr. Programmer Client Server
Highlights
- Expertise in providing efficient and
cost effective solutions for Data Warehousing, Integration and Reporting
projects in Quality Systems IT Department
- Experience in using all
- Coordinated with offshore teams to
accomplish the tasks
- Expertise in creating Installation
Verification Documents for various kinds of Systems.
- Handled Production support activities at
a department level.
- Actively participated in organizational
people and culture activities.
- PCA for various IT projects through out Abbott
Vascular
Project :
Supply Chain Data Warehouse, AVDW
Data
Warehouse Analyst
Responsibilities:
- Source Analysis on various areas of
Supply Chain Data Warehouse
- Assisted Project Manager in creating
Functional Requirements Template and documents
- Involved in several meetings to analyze and decide the scope of
the project
- Created PL/SQL programs on characterset conversions
- Created several mappings, mapplets and
workflows
- Created configuration files for ETL jobs to schedule through Control-M
- Developed Cognos canned reports using
- Created and deployed Cognos Adhoc packages
- Used Cognos Framework Manager to create several packages
- Reviewed requirements and provided
feedback for better understanding to the team.
- Debug
the sessions by utilizing the logs of the sessions
- Performed Unit Testing on several ETL mappings
- Created several Design, mapping, testing
documents as per SDLC
- Provided user training materials and hands on training sessions
- Analyzed the Control-M jobs flow to
group the jobs by Area for regression testing
Project:
Quality Systems Reporting Portal
Viper Adhoc Pa ckages, ViewPoint Adhoc
Pa
PPG Sale
Responsibilities:
- Created ViewPoint canned reports using Cognos 8.4.1
- Assisted in creating the Cognos Packages
using Framework Manager.
- Created and validated PPG Sales Response
reports
- Created and validated the Adhoc Packages
by verifying the relationship between the Query Objects and data.
- Demonstrated Cognos 8.x tool features
and functionalities to the Business
- Coordinated with offshore in validating
the ViewPoint and NWA SQL*LIMS reports
Project: PEH Integrated
Data Warehouse Reporting
Product Experience
Handling (PEH) Data Warehouse Reporting extracts data from VIPER, a complaint
handling system, integrated with SMART COMPLAINTS, a legacy complaint handling
system.
SQL Server 2005
Integration Services and Reporting Services are used to build this Project. The
main objective of the project is to maintain all historical and current
information in the system, and generate reports as needed with a daily job run.
Responsibilities:
- Analyzed the source
system (VIPER) and performed Reverse
Engineering to explore the relationship between the application and
the database objects
- Involved in Requirement
- Assisted in designing
the logical and physical model of the system.
- Created test scenarios
and test cases to validate complex reports with around twenty filters in
each report
- Validated the reports
data by writing complex SQL queries same as the reports’ code following
the requirements.
Project: ALM
Tools COTS Validation
- Evaluated and analyzed various
- Assisted in gathering requirements based
on Tools’ functionalities.
- Configured
- Written Test Scenarios and executed the
test cases.
- Deployed the ALM Tools into Production environment.
Project: Documentum
6.x COTS and Open Migrate Tools COTS Validation
- Assisted in
- Created sample mappings in Open Migrate
Tool to migrate the data from Documentum 5.2.5 to
Documentum
6.x
- Explored features of Documentum 6.x that
are intended to use at Abbott Vascular
- Created
Miscellaneous
Activities at Abbott Vascular
- Created PL/SQL program
to validate the VIPER data separation from
- Fixed bugs in Perforce
Web tool which generates web links for the objects stored in Perforce
- Performed COTS Validation on SQL Server
2005 database, Integration Services, Reporting Services components.
Written requirements, test scenarios and executed the test cases.
- Coordinating the effort in ViewPont CAPA
CO Admin Change data verification to identify the corrupted records
- Actively posted various documents in
Wiki tool to assist the team for better visibility.
- Evaluated the process of selecting the procedure
for CO Supporting Docs in ViewPoint upgrade Project.
- Smoke testing on ETL jobs for Discovery
Project
Environment: Oracle 9i,10g,11g, SQL Server
2005/2008, SQL, PL/SQL, TOAD 8.0, UNIX
Shell Script, Windows XP, and MS-Office
tools, MS Visual Source Safe, Perforce, SilkCentral, Wiki, CaliberRM,
FogBugz, Cognos 8i Framework Manager,
Cognos Report Studio, Analysis Studio, Cognos Office Integration, Documentum
5.3/6.0.
Sr.
Informatica Analyst/Developer
Circuit
City
Merchandise System Transformation is aimed at designing and building a “top
down’’ planning solution utilizing Oracle Retail’s “Fast Track” design and
methodology as the foundation.
By utilizing the
“Fast Track” foundation, Circuit city expects to deliver industry best practice
capabilities while minimizing implementation time and expense. MST program is a program to implement
new merchandising planning, forecasting and management systems within Circuit City
Responsibilities
- Involved in Source Analysis for PRICING tables and prepared documents for
Codes that are related to PRICING.
- Actively
participated in creating detailed technical requirements from Functional Requirement Specification
(FRS) documentation to System
Requirement Specification (SRS) documentation.
- Migrated
mappings
and workflows from RMS/RPM source to development and to test environments
- Created Data Flow Diagrams using Microsoft Visio to depict the flow of the Mappings.
- Participated in Data Profiling for the source data by column analysis,
dependency analysis and redundancy analysis to acquire data quality.
- Involved in designing and developing new
Object Oriented generic model
for EDW
- Involved in developing and maintaining
Universal Code and Data Object Registries in generic model.
- Developed various Informatica mappings and mapplets using
complex transformations like Aggregators, lookups, Filters, Sequence Generator, Normalizer, Update
strategy and stored procedure transformations.
- Extracted data
from different databases like DB2, Cobol, Informix, Oracle, SQL Server
and Flat files.
- Responsible for studying the existing
data warehouse and also working on PL/SQL packages, stored
procedures, triggers and functions.
- Handled operating system tasks by
generating Pre and Post-Session UNIX Shell Scripts.
- Created parameter files and declared values to parameters and
variables used in workflow, worklet or session.
- Used Autosys scheduler to
schedule jobs for weekly and history data loads.
- Used Webfocus to enable the efficiency
of web enabled reports by maintaining metadata in a single location.
- Designed and build Unit and System Test
Cases for the workflows.
- Used Mercury Quality Center Test
Director tool to upload and run test cases manually.
- Developed BI, Adhoc and OLAP reports
directly from Informatica metadata by Webfocus
- Used Synonym tool and accessed master
file description to access the Oracle and DB2 databases.
- Developed UNIX korn shell Scripts to load data in to SEED TABLES and
target tables.
- Involved in several meetings to design FACT and Dimension tables for PRICE PERFORMANCE REPORT ANALYSIS and
MARKET INTELLIGENCE report in EDM.
- Involved in design and building cubes in
Power play Transformer by using best practices to support the reporting
activities
- Involved in Designing and developing all
power cubes and Drill through cubes in Power play Transformer
- Designed Business Models to meet the
complex reporting requirement using Cognos Framework Manger, Report
Studio and Query Studio.
- Used PVCS Version Manager to Promote Informatica Objects from
Development to Test and then to the Production environment.
- Used Aqua Data Studio, TOAD for DB2 and
Winsql sql query tools.
Environment:
Informatica Power Center 7.1.2/8.1.0, Microsoft Visio 2003, UNIX AIX, Windows
NT, Mercury Quality Center Test Director, TOAD , WebFocus Developer Studio 4.3,
WebFocus Reporting Server, Aqua Data Studio, Cobol, Win sql, DB2 8.1, Oracle
9.1, Informix, Flat Files, Autosys, PVCS Version Control
State
Dept. of Public Welfare, PA
Jan’06
– Sept’06
Informatica
Developer
The Commonwealth of Pennsylvania
Responsibilities:
·
Involved in various elicitation techniques
facilitated by JAD sessions and
workshops with small as well as large cross functional groups and acted as
liaison between business people and the project team.
·
Prepared basic documents on Data Acquisition, Staging Area Load Process,
EDW Load Process and Source to Target Data Map.
·
Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to
design the business process, grain, dimensions and measured facts.
·
Developed
Informatica transformation rules by usage of Aggregator, SQL Overrides in Lookups, Source filter in Source Qualifier,
and data flow management into multiple targets using Router transformations.
·
Used
various transformations like Filter,
Expression, Sequence Generator, Update, Strategy, Joiner, Stored Procedure,
and Union to develop robust mappings in the
Informatica Designer.
·
Created sessions, configured workflows to
extract data from various sources, transformed data, and loading into data
warehouse.
·
Used Power Center
·
Migrated mappings, sessions, and workflows
from Development to Testing and then to Production environments.
·
Analyzed newly converted data to establish a
baseline measurement for data quality
analysis to determine cleansing requirements in data warehouse.
·
Monitor;
troubleshoot batches and sessions for weekly and Monthly extracts from various
data sources across all platforms to the target database.
·
Created unit test scripts to
check the data quality and data
integration.
·
Resolved table-joining problems like Chasm
trap and Fan trap using Alias and context
·
Loaded the target dimensional
hierarchies from the Excel File and XML file sources.
·
Created variables, @Prompt objects,
formulas and associated with Production support team
·
Developed
UNIX shell scripts to move source
files to archive directory.
·
Worked on
Informatica PowerCenter tools- Designer,
Repository Manager, Workflow Manager, and Workflow Monitor.
·
Developed
scenarios for Unit, Integration, system,
and UAT testing levels.
Environment: Informatica PowerCenter
7.1.3/5.1, Oracle 9.2, SQL Server 2000, SQL, PL/SQL, SQL* Loader, Autosys,
Erwin, TOAD 7.0, UNIX Shell Scripts, Business Objects
6.x, Teradata V2R4, Data integrator, Flat
Graduate Assistant
Responsibilities:
·
Installed and
configured client tools and connected with database using Repository Server.
·
Supported in designing by preparing UML
diagrams like class diagrams, sequence diagrams, state diagrams, and data flow
diagrams by following Rational Unified Process (RUP).
·
Involved in creating
and maintaining various database objects like SQL Joins, Synonyms, Aliases, Views, aggregate conditions,
and worked on various databases and their connectivity from various parts of
the source systems.
·
Assisted professors in writing papers and
journals
·
Involved in designing
and building web-based
feedback form project for ‘Department of Social Services’ State of South Dakota
·
Tutoring and lecturing classes on Oracle 9i,
Data Modeling and Design concepts
·
Used Stored Procedure, Views, and Functions
for faster processing of bulk volume of source data.
·
Involved in
developing SQL Scripts for extraction and loading of data in between databases.
Environment: Oracle 10g/9i, Rational Rose 4.0, RUP,
PL/SQL, Oracle 8i, SQLServer 2000, TOAD, UNIX,
ASP.net, Windows 2000, and MS-Office tools.
New Sun Star Solutions/Ilogic, India
Oracle Developer
Description: Sales
Order Processing System
Designed and
implemented Sales Order Processing System using Oracle 7.3. This project
involved designing several forms to process sales orders, updating new products
and prices, updating the customer information, preparation of online.
Responsible for designing and developing Schemas using Entity Relationships,
Data Modeling, Normalizing the relations, creating Tables, Views, Indexes,
Sequences and coding.
Responsibilities:
·
Created dimensional data model for different
modules using Erwin.
·
Developed complex SQL queries and PL/SQL
packages, including stored procedures & functions, to fetch data for
reporting and to accomplish several computations.
·
Created various SQL and PL/SQL scripts for
verification of the required functionalities
·
Generated a number of reports for management
to review for system functionality as against the old legacy system
·
Worked with various functional experts to
implement their functional knowledge into working Procedures
·
Worked on optimizing existing procedures and
functions using PL/SQL
·
Created various Database triggers using
PL/SQL
·
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.
Description: Designed, developed
and tested an embedded system to control remote appliances
Responsibilites:
·
Involved in gathering requirements for the
project
·
Participated in
hardware selection
·
Helped write the
software design document and functional outline
·
Worked on hardware in designing the embedded
system
·
Designing the data
input system
·
Written algorithms for user interface control
·
Used embedded C language in developing the
code
·
Compiling, debugging and executing the code
·
Tested the system extensively and fixed the
bugs
·
Worked on documenting the poject
Environment:
Embedded C language, microprocessor, MS Office
tools
Download Resume Format
.JPG)
0 comments:
Post a Comment