Manager Sql Server

Ashrut P. Shah

Contact : 908-***-**** ** Gardenia Ct

Sayreville, NJ 08872

**********@*****.***

Areas of Strength

OBIEE – SIEBEL ANALYTICS –DATA WAREHOUSING – ETL – INFORMATICA – CRYSTAL REPORTS

DEVELOPER – BUSINESS ANALYST - MODELER

SUMMARY:

Result Oriented IT professional with over Five (5+) years of progressive expertise in analyzing the requirements,

application design, development, testing, Business, Data, Quality Analysis and a comprehensive background in

ETL (Informatica), Data Warehousing, Business Intelligence and Business Analyst.

Overall IT industry experience includes Data Integration and Analysis for Decision Support System in

Insurance, Financial, Manufacturing and Government sector.

4 years of Data Warehousing experience using Informatica PowerCenter 8.1/7.1/7.0/6.x (Workflow Manager,

Workflow Monitor, Server Manager, Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet

Designer, Transformation developer), Informatica PowerMart 6.2/6.1/5.1.x/4.7, Power Connect, Datamart,

ETL, OLAP.

2 years of strong experience in Siebel Analytics or OBIEE, Crystal Reports modeling, developing metadata,

repositories, dashboards and interacting with business users to identify information needs and initiating process

changes, requirements gathering.

Good Analytic and Statistical Exposure to create Reports, Proficient in building analytical repository, business

models, generating reports, and creating dynamic Dashboards using Siebel Analytics and other BI tools.

Job roles include gathering business requirements, establishing functional specifications, translating them to

design specifications.

Strong experience in Requirements elicitation techniques - conducting user interviews, document analysis, JAD

sessions and Manage the requirements using Rational RequisitePro.

Experienced in working with all phases of SDLC through out the project life cycle in Rational Unified Process

(RUP) environment.

Extensive experience in developing business documents, mapping documentation and implementing initial QA

testing.

Familiar with Business Object and Hyperion for reporting purpose.

Worked on various sources like DB2, Oracle, SQL Server, and Flat files.

Experience in writing stored procedures (PL/SQL) and triggers using Oracle.

Excellent Self Driven project management skills, Team Player, Good communications, Presentation and

Telephony skills.

Profound Knowledge of SDLC and Software Testing Life Cycle. Experienced in providing 24/7 Production

Support.

TECHNICAL EXPERTISE:

OBIEE 10.1.3.2/3.4, Siebel Analytics, Crystal Reports, Hyperion, Siebel CRM

BI Tools

Informatica PowerCenter 8.1/7.1/7.0/6.x

ETL

Erwin 7/4.1

Data Modeling

Oracle 10G/9.2/8i/, MS SQL Server 2005/2000, DB2, MS Access

RDBMS

SQL, PL/SQL, C, C++, Perl, Unix.

Programming Language

MS Project, MS Office, MS Visio.

Software Packages

Toad, SQL Developer, SQL*Plus/SQL*Loader.

Tools

EDUCATION:

Master of Science in Electrical and Computer Science, California State University Long Beach, CA, USA

Graduated: 2007

Bachelor of Engineering in Electronics, South Gujarat University, India. Graduated: 2002

Ashrut Shah’s Resume, 1

Ashrut P. Shah

WORK EXPERIENCE:

DPSCS, Baltimore, MD November 2008-Present

OBIEE/Informatica Developer (Consultant)

Department of Public Safety and Correctional Services was developing OBIEE for making its service better. DPSCS

wants us to develop reports and dashboard on Crime, Gun Record, Parole Information, Financial Transaction,

Employment, Legal Information, Warrants, Case Details, Health and Improvement of criminals, Chronic Care,

Juvenile Information etc.

Responsibilities:

Used the OBIEE 10.1.3.2, Siebel Analytics Administration tool to develop and enhance repository (.rpd).

Installed OBIEE 10.1.3.2 in Window environment, clustered production databases.

Created connection pools to Oracle 10g, DB2, SQL Server, MS Access etc, physical tables, defined joins and

implemented authorizations in the physical layer of the repository.

Worked on Informatica PowerCenter 8.1, created various mappings, mapplets to implement the business logic

using different transformations like Aggregator, Connected and Unconnected Lookups, Router, Update Strategy,

Filter, Rank, Joiners, Expression, Sequence generator. Used debugger to test the mapping and fixed the bugs.

Configured and Created repository using Siebel Analytic Admin tool.

Involved in Analysis, Design and Development, test and implementation of Informatica transformations and

workflows for extracting the data from the multiple systems.

Worked extensively on Physical Layer, Business Layer and Presentation Layer.

Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements.

Created proactive agents iBots for cache purpose on many reports and interactive Dashboards to alert the Higher

Authority about different issues.

Managed day-to-day rpd, Scheduler & iBots.

Created groups in the repository and added users to the groups and granted privileges explicitly and through

group inheritance.

Modified some of the existing reports and dashboards, and fixing some of the issues related to performance, data

quality etc., during production support.

Environment: OBIEE 10.1.3.2, Informatica 8.1,Oracle 10g, DB2, SQL Server 2005, MS Access, TOAD, PL/SQL,

MS Window.

Oracle/CPD, Chicago, IL August 2008-Oct 2008

OBIEE/Informatica Developer (Consultant)

Chicago Police Department wants Oracle team to implement BI solution and develop its Apex and Web system. I

worked for Oracle to implement OBI EE in CPD. CPD chief police officers want BI solution for analysis of the

records like crime, awards, arrest, police officers’ performance, Traffic cards, Firearms, Search Warrants etc. This

would help Commanders or Chief Police Offices to make strategic decision and improve management.

Responsibilities:

Requirement analysis, Designed and implemented custom business intelligence solutions (Metadata and

Dashboards/Reports) using the Siebel / Oracle Business Intelligence (OBI) Analytics platform.

Performed the detailed design of Reports / Dashboards and Analytical Data Model (Metadata / .rpd). Installed and

configured Oracle BI EE 10.1.3.4.

Developed the repository model for the different work streams with the necessary logic that involved creating the

Physical, BMM and the Presentation layer. Also created hierarchies, variables, and event poll strategies in the

repository.

Enhance performance of Reports / Dashboards by implementing the Aggregate tables, Creation / Rebuilding of

Indexes and managing Cache etc.,.

Worked on Informatica Power Center Designer, Workflow Manager, Workflow Monitor, and Repository

Manager.

Extracted data stored in Oracle 9i and Flat files and loaded data into Oracle Data warehouse.

Environment: OBIEE 10.1.3.4, Oracle 10g, TOAD, Informatica 8.1, PL/SQL, Informatica 8.1, Red Hat Linux.

Ashrut Shah’s Resume, 2

Ashrut P. Shah

Health Net, Inc, Rancho Cordova, CA March 2008 - July 2008

BI Analyst/Informatica Consultant

Health Net provides managed health care and other medical coverage to more than 6.6 million members in 27 states.

The firm's Health Plan Services unit offers HMO, PPO, Medicare, and Medicaid plans. As a Siebel Analytics/OBIEE

consultant involved in developing BI solution for strategic analysis by sales, marketing, and pricing. This would help

managers drive key business decisions, improve category management, lower inventory costs, and optimize pricing

decisions to strengthen its dominance.

Responsibilities:

Used the OBIEE 10.1.3.2, Siebel Analytics Administration tool to develop and enhance repository (.rpd).

Created numerous executive level reports. ‘Dashboards’ were generated to provide insight into the

sales/marketing/financial data.

Created business reports using Siebel Answers as per requirements.

Identified and solved numerous technical and operational problems in the Data mart design and ETL

implementations.

Involved in modifications of physical, business and presentation layers of metadata repository using Siebel

Analytics Administration Tool.

Involved in managing appropriate security privileges on subject areas and dashboards according to business

requirements.

Developed custom reports/Ad-hoc queries using Seibel Answers and assigned them to application specific

dashboards.

Developed different Reports (pivots, charts, tabular).

Knowledge evocation through user interviews and JAD sessions and used work flow diagrams, Process flow

diagrams and E-R diagrams for the representation.

Gathered client specific business requirements and translated it in a proper manner to the developers, and ensured

that these requirements were fully tested and implemented accordingly for each production cycle.

Extensively used transformations like Aggregator, Expression, Sorter, Sequence Generator, Joiner, Filter, Router,

Rank, Look up and Update Strategy transformations to model various standardized business processes.

Used Informatica features to implement Type I and II, changes in slowly changing dimension tables.

Environment: OBIEE 10.1.3.2, Siebel Analytics 7.8.2, Oracle 9i, SQL Server 2004, SQL, SQL*Plus, TOAD,

Informatica 8.

Orthodyne Electronics, Irvine, CA May 2006 – Feb 2008

Crystal Reports/ETL Developer

Orthodyne Electronics is the manufacturer of the Ultrasonic bonding machine and robots. Company hired as a

graduate intern for generating their purchase, marketing, sales, supply chain and inventory reports using crystal

reports and maintenance of their ETL mapping. Their customers are located in all over the world and branch offices

are in Japan, China, and Germany.

Responsibilities:

Participated in business requirements analysis, database design and modeling, development of technical

specifications, testing and implementation

Extensively worked on SQL.

Developed and Deployed reports for different modules based on accounts, purchase, Inventory, Supply chain.

Extensively worked on Migration, Integration of Crystal Reports.

Wrote formulas, parameters and conditions depending upon selection criteria.

Exported the Reports into the required formats.

Designed different levels of reports including sub reports

Designed work schedule, wages, Invoice and performance appraisal reports using Sub reports

Created various mappings, mapplets to implement the business logic using different transformations like

Aggregator, Connected and Unconnected Lookups, Router, Update Strategy, Filter, Rank, Joiners, Expression,

Sequence generator. Used debugger to test the mapping and fixed the bugs.

Prepared BSD (Business System Design) and TSD (Technical System Design) Documents.

Environment: Crystal Reports 9, Crystal Enterprise 8.5, Informatica PowerCenter7.1, SQL, SQL Server 2000.

Ashrut Shah’s Resume, 3

Ashrut P. Shah

HCL, India Jan 2004 – July 2005

ETL/Informatica Developer

The purpose of the data warehouse being developed was to provide reports for the portfolio managers to assist in

establishing, monitoring, evaluating, developing and implementing strategies for new account acquisition, credit limit

setting, account management and maintenance, loan dispersement, repayments etc. Informatica Power Center was

used to load strategic source data to the data marts based on the criteria requested. Extracted data from different data

sources and created different Data Marts to support the decision making.

Responsibilities:

Extracted data from multiple sources, which include relational sources, flat files and XML files.

Developed Mappings and Workflows using Informatica PowerCenter 7.1/6.2.

Created numerous mappings using Router, Expression, and Update Strategy, Lookup transformation, Stored

Procedure and other transformations.

Worked on Business Object for Reporting purpose.

Mappings consisted of a separate set of initial load and incremental load mappings.

Scheduling and Monitoring Workflows, Worklets and tasks using Workflow Monitor.

Implemented SCD 1, SCD 2 techniques for handling history requirements.

Made historical artifacts tables to maintain history.

Implemented performance tuning techniques at system, session, mapping, transformation, source and target

levels.

Environment: Informatica PowerCenter 7.1/6.2, Business Object, PowerMart5.1, Oracle8i, PL/SQL, SQL*Plus,

Windows NT.

Robert Bosch, India Jan 2003 – Dec 2003

Informatica / ETL Developer

The system analyzes the products and sales. The Multidimensional fact in the Data Warehouse consisting of

Inventory, Shipments, Production, and Budget could be analyzed across eight key dimensions (Product, Customer,

Location, Organization, Channel, Line item, Scenario and Period) of business. The system also provides the previous

data/history to speculate the trends seasonally and by region.

Responsibilities:

Worked on Informatica Designer, Workflow Manager and Workflow Monitor tools extensively and developed

mappings and sessions of different complexity

Used several transformations such as Look up, Update Strategy, Filter, Router, Expression, and Aggregator in

mapping and mapplet development

Optimized the performance of Mappings, Workflows and Sessions by identifying and eliminating bottlenecks.

Developed Mappings to load data in slowly changing dimensions.

Creating sessions using Workflow Manager to load the data into the Data Warehouse.

Used debugger to test the mapping and fixed the bugs.

Used ETL to extract and load data from Oracle, MS SQL Server 7.0 and flat files to Oracle 8i.

Written large volumes of notes and design documentations on MS Excel’s/ WORD.

Environment: Informatica (PowerCenter 5.1), Oracle 8.0/8i, SQL, PL/SQL, TOAD, MS-SQL Server 2000, Erwin

4.1, Microsoft Access, Windows 2000.

* US Green Card Holder.

* Willing to Relocate.

Ashrut Shah’s Resume, 4

Contact this candidate