17+
years of experience in developing database applications and 8+ years of
experience in data warehouse, data mart and Report development,
architecture, data modeling, design, mapping, extraction, migration, data
validation, administration and design/development of various Enterprise
Solutions.
Very well adept
at troubleshooting and crisis management. Well-rounded background of IT
development including OOP.
Strengths:
-
22+ years of experience in writing PL/SQL stored procedures,
functions, packages and triggers.
-
Large-scale
logical and physical data modeling using Erwin and Oracle Designer.
-
Master in
C/C++ development and JAVA programming.
-
Experience of
Oracle Forms and Reports of any complexity.
-
Experience in
using external loading, using ftp, using incremental aggregation.
-
Experience in
various RDBMS platforms such as Oracle and SQL Server;
-
Analysis, design,
and development of data ETL using Informatica,
DataStage, SSIS and OLAP reporting applications using Business Objects, SSAS, SSRS, Crystal Reports, COGNOS etc.
-
Expertise in ER and Dimensional Data
Modeling, Star and Snowflake schema creation,
-
Experience in developing Informatica Mappings, creating
Sessions, and maintaining Informatica Repository, developing UNIX scripts,
creating CRON jobs for supporting Informatica processes.
-
Performance
Tuning of the Data Warehouses
including the creation of materialized
views, bitmapped indexes and partitions.
-
UNIX Shell scripts to automate the process of loading, pushing and pulling data from
& to different servers.
-
Expertise in
Create/Build/Run/Schedule Batch Job streams, Sessions, Workflows using the Workflow Manager, Server Manager.
Technical
skills summary:
-
Database: ORACLE 6-10g, MS SQL Server
2000/2005, Sybase, Access;
-
Oracle Tools: Forms, Reports, Designer, Sql*Loader,
Portal, Webutil, Enterprise Manager, PL/SQL
-
BI/ETL: COGNOS, SSIS, SSAS, Informatica,
DataStage, OWB, Business Objects
-
Web Server: ORACLE APPLICATION WEB SERVER (OAS)
4, 9ias
-
Language: C++, C, OCI, PRO-C, SQL, C#, HTML,
Java, JSP, JAVASCRIPT, XML;
-
Tools: TOAD; RapidSQL, WEBDB, PVCS,
StarTeam, CC Harvest, Kintana, Visual Studio, Visual SourceSafe,
.NET, RATIONAL, TUXEDO, Autosys
Industry
summary:
Finance, Food, Health
Care management, Health and dental
Insurance, Defense, Auto,
Banking, Sports & Entertainment, General
Mercantile Retail, Auto Insurance
Education
& professional certifications:
-
Engineering Bachelor
of Computer Science. 1987
-
Oracle
Certifications:
OCP Internet Application Developer 6/6i 1999
OCP Developer 2000 Release 2 2000
OCP Oracle Forms Developer 9i/10g 2003
OCP Oracle 9i DBA 2004
-
Java
Certification: Sun Certified Java Developer 2005
-
ETL
Certification: Informatica
Developer 2006
Experience summary:
State Street Corporation, MA August 2007 Current Consultant
Projects:
-
IBT integration
(2007-2008) , Security Finance Business Intelligence (2008-2010), APMD
violation cleanup for SLD and SFBI databases(2010-2011), SLD Remediation and
performance tuning (2010-2011), Enterprise Self Service Platform(2011-2012)
ETL Process Design & Development
-
Wrote PL/SQL
function, Stored Procedures to invoke several ETL functionalities
-
Involved in
understanding of source to target data mapping, design and developments for
processes required to extract, transform, and load data into the data
warehouse.
-
Participated in
Designing of Dimension model (STAR Schema).
-
Design Dataflow
Diagram.
-
Used
active/passive transformations and connected/unconnected lookup to design
mapping
-
Involved in
importing Source/Target Tables from the respective databases and created
Reusable Transformations in DataStage
-
Transform
business requirements into mart design and develop marts in ESP platform
-
Design on-the-fly
any-currency-to-any-currency conversion of RORs
Reporting
-
COGNOS - Reporting Framework
Database Administration:
-
Application team
DBA
-
Lead for many
projects, like APMD violation, cc2db deployments, etc.
Environment: Oracle 9i and 10g, COGNOS, DataStage,
ERwin Data Modeler, Clear Case, Clear Quest, MS Access, Visio, TOAD, in-house tools
Progressive Insurance, OH August 2006-August 2007 Consultant
Data Warehouse Project Lifecycle management
-
Performed Business
Requirement Definitions which included Interviews, facilitating sessions,
developing questionnaire, and prioritizing next steps
-
Performed Dimensional
Modeling including Estimate data complexity, maintain user involvement, and
determine slow changing dimension strategy
-
Performed Technical
Architecture Design -
-
Involved in Product
Selection with responsibilities to Develop product evaluation matrix, trial
test product, select/recommend product
-
Designed Oracle tables and view for ASP application.
Environment: MS
Access, Oracle 8.0/9i, Visual
Studio, DTS, SSIS, SSAS, SSRS, Crystal Reports, BO, Visio
Smuckers, Orrville, OH August 04-July 06 Consultant
Data Modeling:
-
Performed Data
analysis work for new and existing business requirement.
-
Design data mart
for Products, Customers, Broker and Marketing Hierarchies.
-
Reviewed and
documented policies on PK, FK, related indexing, naming conventions, data
typing, defaulting and the consistency of their implementations.
-
Reviewed and
developed SCD strategy on all dimensions.
ETL Process Design & Development
-
Wrote PL/SQL function,
Stored Procedures to invoke several ETL functionalities for aggregation and
summation.
-
Prepared ETL
standards, Naming conventions and wrote ETL flow documentation.
-
Design Dataflow
Diagram.
-
Participated in
Designing of Dimension model (STAR Schema).
-
Used
active/passive transformations and connected/unconnected lookup to design
mapping
-
Involved in
understanding of source to target data mapping, design and developments for
processes required to extract, transform, and load data into the data
warehouse.
-
Created
Repositories and Users and groups assigning privileges to users Using
Informatica Repository Manager.
-
Involved in multi-source
Extraction Transformation and loading into the Repository using Informatica.
-
Involved in
importing Source/Target Tables from the respective databases and created
Reusable Transformations, Mapplets and Mappings using Designer Tool set of
Informatica.
Performance Tuning
-
Enhance
performance of existing and new ETL processes (e.g. indexes, aggregations,
caching, incremental versus full load, Drop/Re-Create Indexes and RI, using
Dual as a source, etc.).
Error Handling
-
Developed
strategy for "Validation, Errors and Exceptions Handling"
-
Designed pre- and
post- validation rules for all ETL processes.
Environment: Informatica Power Center 7.1, UNIX, Oracle 9i, SQL
Server 7.0, Toad 6.3, Autosys, Oracle Forms 6i, Vista CPG
McKesson Health Solutions, AZ November 2003August 2004 Developer & Analyst
-
Involved in the
data warehouse fact and dimension tables design using star schema.
-
Creating source
definitions from the operational sources and target definitions.
-
Worked
Extensively on Repository Manager, Designer and Workflow Manager and Workflow
Monitor.
-
Designed and
developed various mappings in Mapping designer and sessions and workflows in
Workflow manager to extract data from flat files, oracle and SQL Server
sources.
-
Developed Transformation
logic and designed various complex Mappings in the Designer
-
Created and ran
Pre-existing and debug sessions in the Debugger to monitor and test the
sessions prior to their normal run in the Workflow Manager.
-
Involved in
Disaster Recovery Coordination for my project.
-
Created and
Scheduled Workflows based on demand, run on time, run only once using
Informatica Workflow Manager.
-
Efficient
Documentation was done for all mappings and workflows.
-
Provided End-user
training and support.
Environment:
SQL Server, Informatica Power
Center 7.1, UNIX, Oracle 9i, SQL Server 7.0, Toad 6.3
Green Shield Canada August 2000October 2003 Senior Oracle Developer & Analyst
* Project: Liberty Medical Health Insurance Application
* Project: Dental OLTP Processing System * Other projects with Green Shield Canada in C++ and PL/SQL): Tuition Refund adjudication system, Travel health upload and re-adjudication system, Taxable Benefit Payroll File. Symphony Solutions, Toronto, ON Mar 1999August 2000 Senior PL/SQL Developer & Analyst
* Project: DGS Procurement ERP Application
* Project: Auto Dealer Voice Application CIBC, Toronto, ON January 1996February 1999 Oracle Developer
* Project: Payroll Time and Rates Reporting Web Application
* Project: Currency Back-office System* Project: Security Electronic Interface Glen Abbey Golf Course, Canada January 1995December 1995 Oracle Developer
* Project: Scheduling