Chirag R Patel

Citizenship : USA

Contact

Tel : 312-***-****

E-Mail : acq2fl@r.postjobfree.com

Address

**** * **** ******** **., Palatine, IL 60074

Profile

Objective

Well-rounded and energetic professional with valuable experience seeks new challenge and opportunity to apply consummate skills in Business Intelligence, Data Warehousing and Information Technology

Availability

Need 2 weeks’ notice

Key Skills

Over 11 years of experience in IT industry with strong background in software development and 7+ years of experience in development, architecture, and testing Business Intelligence solutions in data warehouse and decision support systems using ETL tool Informatica Power Center 7.3/8.6/9.1/9.5

Strong understanding of Extraction Transformation and Loading (ETL) Process.

Strong experience using Informatica Power Center 9.5.1/9.1/8.6.1 (Workflow Manager, Workflow Monitor, Repository Manager, Mapping Designer, Mapplet Designer, Transformation developer

Implemented Slowly Changing dimensions Type 1, Type 2, and Type 3 methodology for accessing the full history of transactional information.

Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier, XML Parser, Web service Consumer, etc.

Expertise in implementing complex business rules using different transformation, mapplets and worklets.

Experience with code migration from between repositories and folders.

Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.

Involved in Full Life Cycle Development of building a Data Warehouse.

Warehouse Architecture and Designing. Expert in programming in free hand SQL, PL/SQL

Experience in developing strategies for Extraction, Transformation and Loading (ETL) mechanism using various ETL Tools.

Extensive experience with Oracle 11g/10g/9i/8i, SQL, PL/SQL.

Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.

Experience in logical/physical data models and Forward/Reverse Engineering using ER Studio.

Experience in team management and a good team player.

Good experience in ETL technical documentation.

Quickly learn and master new technology; equally successful in both team and self-directed settings; and proficient in a range of computer systems, languages, tools and testing methodologies.

Technical Skill

ETL

Informatica PowerCenter 9.5/9.1/8.6/7.3, Data flux 8.2, Data Validation Option

RDBMS

Oracle 11g/10g/9i/8.0/7.x, SQL Server 2008/05/00, XML, Sybase

Methodologies

Dimensional Data Modeling, Star schema and Snowflake schema

Languages

SQL, PL/SQL,T-SQL, C, C++, C#, ASP.Net, VB.Net VB script, XML, XSL,HTML,UNIX Shell Scripting, PowerShell Scripting

Operating systems

Window 2008, HP-UX, Linux

BI tools

Business Objects XI

Modeling Tools

ER Studio/ER Portal

Others

Rapid SQL, SQL Developer, Proactive Monitoring, MS Visio 2007/2010, Cisco Tidal Enterprise Scheduler, SharePoint 2007/2010, Visual Studio 2010/2008/2005, TFS Explorer.

Work Experience

Volkswagen Credit Inc., Libertyville, IL

Full Time

ETL Developer/ETL Lead

Feb 2007 to Present

Guiding and working with development team to complete various complex projects within very tight project deadlines

Working as ETL/Data Architects to come up with design solutions for complex requirements

Owner of various products like Proactive Monitoring, Informatica and Databases. As a product owner, was responsible to manage product documentation, upgrade and different tasks to maintain those products

Coordinated Informatica Powercenter and other Informatica product upgrades

Member of Tech Lead group which is responsible to set up enterprise wide standards and processes

Developed re-usable transformations and mapplets using various transformations like expression, aggregator, joiner, source qualifier, lookup, and Router

Analyzed Business requirements and translated them into technical specifications for developers

Worked with IT Operation and Informatica company consultant to create and set up automated deployment process and functionality to deploy all Informatica Objects without any manual intervention

Improved the performance of the jobs by identifying the bottlenecks and eliminating them

Coordinated with business and operations teams during user testing, serving as main point of contact, identifying aspects of design/functionality to be tested

Planned and managed project roll out into production environment. This was done through meticulous approach detailing every aspect of the migration ranging from version control of ETL code, DDL and DMLs for the database

Extensively worked with Informatica, Oracle and Sybase metadata to identify dependencies and data lineage

Responsible to set up auto deployment process for database objects using TFS and PowerShell scripting

Involved in hiring process, helping and training new developers for team

Worked as Member of strike team which was responsible to resolve the production issues right away following full development life cycle

Applied slowly changing dimensions (SCD) in various complex Mappings to load data from source to target

Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads

Extracted and loaded data from XML documents by using XML Source, Parser and Generator transformations

Created mappings using web service consumer transformations to access web services.

Used Informatica PowerCenter/PowerExchange to extract/transform and load data from different operational data sources like Oracle, Sql Server, XML, Flat files, Webservices into staging area (Oracle) and load in to Oracle data warehouse

Worked on ETL design, development, administration, source to target mappings, data warehouse transformations, on call support, troubleshooting, testing, and documentation.

Developed huge workflows with worklets, event waits, assignments, conditional flows, email and command tasks

Had created and set up generalized data verification process to verify integrity of data within table.

Worked to IT Operation to create and set up automated deployment process and functionality to deploy all Informatica Objects without any manual intervention

Involved in scoping, post scoping, detail design estimation for projects

Helped IT Operation to set up Proactive Monitoring too and also created and set up custom rules to identify various Informatica run time errors and various code standard issues

Involved in following projects

Enterprise Data Warehouse (ETL) Duration: 6 years - Continue

Maturity Manager (ETL) Duration: 1 year

ECOMM (ETL) Duration: 6 months

EOT (ETL) Duration: 6 Months

RMK Elvis Daily (ETL) Duration: 4 years - Continue

ELVIS Daily (ETL) Duration: 6 years - Continue

Consumer Internet (ASP.Net) Duration: 2 years

LeasePak Upgrade (XML/XSL) Duration: 1 year

Wolters Kluwer Financial Services, St. Cloud, MN

Consultant

Developer/Software Developer Lead

(VB, ASP.Net, SQL Server, Oracle)

August, 2005 to January 2007

Responsible for requirements analysis.

Creation and documentation of estimation guidelines and effort analysis.

Creation of design documents for team based on the requirement analysis.

Assist other team members in creation of project deliverables.

Ensure high quality of deliverables, compliance to agreed SLAs.

Quality Review of Deliverables.

Chicago Transit Authority, Chicago, IL

Internship

Programmer

(VBA, Oracle, MS Excel)

October, 2004 to August 2005

Responsible for requirement gathering.

Developing code and reviewing project artifacts.

Creation of Test Cases, Test Results and analyze results.

Using VBA and Excel created datagrams for train tracks which was used by real time train tracking in SCADA system.

Developed Performance Metrics Generation program which was used to generate Performance Metrics using different statistical function and data fetched from Oracle database.

Span Solutions Pvt. Ltd, Vadodara, India

Full Time

Software Developer

(C++,VB)

August 2002 to September, 2003

Worked on three different product based projects;

Assist with design, analysis, maintenance, documentation, and testing of software.

Code, debug, test, and document functionalities.

Make Install and test routine software packages.

Assist users with procedural or minor technical problems.

Advice or train users regarding the technical aspects and use of standard software packages.

Assist in maintaining program libraries, users' manuals, and technical documentation.

Education

2004 to 2005

Master in Computer Science at Illinois Institute of Technology, Chicago, IL

1999 to 2002

Master in Computer Application at Bhavnagar University, Bhavnagar, Gujarat, India

1995 to 1998

Bachelor of Science in Instrumentation at M. S. University, Vadodara, Gujarat, India

Activities and Interests

Technology

Learning about new technologies and try to implement it.

Sports

Volleyball, Cricket, Ping-Pong, Biking.

Travelling

Like to travel with family on long drives.

Languages

Gujarati (Native)

English (fluent)

Hindi (fluent)

Contact this candidate