Data Sql Server

D a rshana Pa rma r

E-Mail: *******.**@*****.***

Phone: 650-***-****

Professional Summary

• 6+ years of experience in areas of problem analysis, database design, implementation

as well as testing

• Excellent working knowledge in Data modeling, Data Warehouse Design, Development

and Testing using ETL-IBM WebSphere DataStage

• Experience in analyzing the data generated by the business process, source to target

mapping of the data elements, creating Indexes and Aggregate tables for the data

warehouse design and development

• Efficient in incorporation of various data sources such as Oracle, MS SQL Server, MS

E xcel, DB2 and Flat files using Active/Passive stages available in DataStage

• Experience in Mapping parallel/server Jobs in DataStage to populate tables in Data

warehouse

• Experience in dimensional and relational database design

• Expert in Data Warehousing techniques for Data Cleansing, Slowly Changing

D imension process (SCD), surrogate key assignment, CDC (Change Data Capture)

and Change Apply.

• Proficient in PL/SQL programming – Stored Procedures, Functions, Packages, SQL

t uning, and creation of Oracle Objects – Tables, Views, Materialized Views, Triggers,

Sequences, Synonyms and User Defined Data Types.

• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.

• Strong background in Oracle as well as MS SQL Server databases

• Expertise in PL/SQL and T-SQL, UN IX shell scripting

• Expertise in building Operational Data Store (ODS), Data Mar ts, and Decision

Support Systems (DSS) using Star and Snowflake schema design

• Experience in developing large scale resource/performance intensive database

applications for Banking and Insurance domains

• Experience of working onsite with clients and OEM partners in different count ries

and coordinating teams at off-shore location

• Consistently recognized for picking up new technologies rapidly and being highly

p roductive

• Have ability to work independently with minimal supervision in a team environment

• IT I L v3 Foundation Certified

Technical Skills

- Programming I BM WebSphere D ataStage E TL tool, P L/SQL, T-SQL, UN IX shell

scripting, PowerBuilder, Developer 2000 (Oracle Forms 6i and Reports

6 i), I nformatica, Hyperion

- D atabases Oracle 8i/9i/10g, M icrosoft SQL Server 2005

- Tools Toad, SQL Navigator, SQL*Plus, Visual SourceSafe, PVCS, Control-M

- Operating Windows 2000/NT/XP, Unix, Linux

Systems

- Certifications IT I L v3 Foundation

Education

Bachelor of Engineering (Computer Engineering) from Ni rma Institute of Technology, Gujar -

at University, Ahmedabad, India (October 2001 to June 2005)

P rofessional Experience

Royal Bank of Canada, Toronto, Canada November 2011 – July

2012

via iGATE Global Solutions

Royal Bank of Canada (RBC) has an Enterprise Information Management (EIM) application,

w hich is a data warehouse application at an enterprise level. I LDM is one of the data mar ts

i n EI M. This project includes extraction and load of historical data, and will allow for the

f uture growth of additional fields.

Technologies used : DataStage 8.1, PL/SQL, Oracle 10g

Responsibilities:

• Designed new ETL jobs as per the requirements to fetch data from source and load i t

i nto target tables

• Used DataStage Designer to develop processes for extracting, cleansing, t ransforming,

i ntegrating, and loading data into database

• Came up with efficient PL/SQL stored procedures to reduce the number of complex

DataStage jobs required to join multiple input files. This resulted in cleaner and

reusable code, which ran more efficiently and faster in the system

• Developed jobs using various stages, which includes Sequential file, Stored procedure,

Aggregator, Join, Transformer, Sort, Merge, Copy, Lookup, Fil ter, Funnel, ODBC,

Change capture, Remove duplicates, etc

• Worked with client to understand requirements to design DataStage jobs based on the

mapping sheets

• Developed job sequencer with proper job dependencies, job control stages, t r iggers

• Volume testing and Performance Tuning of DataStage jobs

• Wrote detailed Technical Design document for DataStage jobs

• Prepared work status report of the entire team to be presented to client as well as

u pper management

• Fix QA defects

Royal Bank of Canada, Toronto, Canada M ay 2011 – October

2011

via iGATE Global Solutions

IAM program enables organization to ensure that the r ight people have access to the r ight IT

systems and services. In order to achieve this goal, the program endeavors to establish

governance process that accurately identify those who work on behalf of RBC, provide them

w ith appropriate access to IT systems, and demonstrate access is correctly assigned.

Technologies used : DataStage 8.1, T-SQL, MS SQL Server 2005

Responsibilities:

• Used DataStage as an ETL tool to extract data from sources systems, loaded the data

i nto the MS SQL Server database

• Created complex jobs which have re-usable components like shared containers, can

r un on multiple instances and call various procedures

• Developed DataStage jobs by understanding system requirements and business rules

• Experience in using Data Stage Director to Validate, Run, Schedule and Monitor Data

S tage jobs and checking logs

• Created Data Stage jobs and Job sequences and tuned them for better performance

• Interacted with client, source system and down stream teams to understand new

Change Requests from ETL development perspective

• Implemented T-SQL stored procedures for different DataStage jobs

• Performed performance tuning of the jobs by interpreting performance statistics of the

jobs developed

• Created and executed unit test cases and also prepared detailed High/Low level

Design document

Ciena Corporation, Baltimore, MD, USA (Onsite) December 2010 –

Apri l 2011

via iGATE Global Solutions

The goal of this project was to archive data extracts provided by the business from different

f unctional areas (Operations, Finance, Vendors and Customers) and store i t in data

warehouse. Users can access the archived data and generate various reports through

H yperion.

Technologies used : Oracle 10g, Informatica 9, Hyperion 11

Responsibilities:

• Involved in Logical & Physical Design, Data In tegration and creating Database objects

( tables, indexes, t r iggers, views)

• Extensively worked with relational Data Modeling

• Designed database schema for storage of archival data

• Guided/coordinated offshore development team to develop Informatica mappings to

load archival data

• Worked with business users to understand requirements and come up with Functional

specification and Technical Design documents

• Designed various Hyperion reports

• Worked with DBA team to validate the archived data after loading

• Worked with business users to validate Hyperion reports for accuracy of data

Royal Bank of Canada, Toronto, Canada April 2010 –

December 2010

via iGATE Global Solutions

RBC-RBTT is replacing their credit cards processing system from Vision Plus to TS Prime.

TS Prime provides facility to interface with external applications/systems, but the format of

i nterface files are not fully supported “As is” by TS Prime. However TS Prime will continue to

p rovide the interfaces for some Batch and all the real-time interfaces. For all other batch

i nterfaces, Batch In tegration Service (BIS) is commissioned by RBC-RBTT to act as an

i ntermediate layer between the existing applications and TS Prime.

T echnologies used : DataStage 8.1, PL/SQL, Oracle 10g

Responsibilities:

• Created complex jobs which have re-usable components like shared containers, can

r un on multiple instances and call various PL/SQL procedures.

• Ensured proper data handling by using different types of rejection criteria in

DataStage jobs

• Designed DataStage ETL jobs for extracting data from source systems like Oracle,

D B2, Teradata, Flat Files, etc and applied t ransformations and finally loaded into the

Data Warehouse

• Used Change Data Capture stage to process only records that have changes

• Prepared Functional Specification and Design documents based on the client

requirements

• Understood the requirements from the client and acted as a sole functional resource.

I nvolved in identifying the business logic and implementation of the same

• Developed and modified stored procedures for Credit Card Processing module

• Created Test Plan and Test Cases. Also Supported the UAT phase.

Deutsche Bank, Frankfurt, Germany M arch 2008 – March 2010

via HCL Technologies

IDMS is used to collect index and assets data from 29 different vendors. The data is loaded

i nto a common structure and validated against a GDH (Global Data Hub). Once the

validation is successful, information is distributed to 23 different downstream business

systems.

T echnologies used : PL/SQL, UN IX, Shell scripting, Oracle 10g

Responsibilities:

• Prepared initial Change Request signoff document and Impact analysis document

• Wrote PL/SQL scripts, stored procedures and packages in Oracle for extracting as well

as loading data. Worked with cursors, record type and collection type variables in

P L/SQL.

• Verified quality of requirements and worked with business users to refine them

• Spearheaded design and coding for changes required in the packages and identifying

data needed to be inserted and updated in the necessary tables

• Test all the scenarios as per the change request in the Unit testing

• Perform UAT Review and sign-off for the CR

Deutsche Bank, Singapore (Onsite) April 2007 – Februa ry 2008

via HCL Technologies

DB-Cheque is payable p roduct offered by Deutsche Bank to Cash Management customers for

making payments to the beneficiaries.

Technologies used: P L/SQL, PowerBuilder, UN IX, Oracle 10g, Control-M, Oracle Reports

Responsibilities:

• Designed and developed various new screens in areas of Customer Profile, funds

t ransfer and New Requests in Powerbuilder for the DB-Cheque application

• M igrated Powerbuilder application from version 9 to version 11

• Updated corresponding PL/SQL stored procedures, t r iggers, packages for compatibility

• Designed and developed PL/SQL t r iggers to store audit information in database

• Developed various new reports for Finance module using Oracle Reports 6i

• Prepared Functional specs, low level design and high level design documents for the

reengineering dbFastCollect application.

AbaadSoft, Malaysia (Now AET I NS) M arch 2006 – March 2007

PentaISF is a future generation solution for Life Insurance Companies. I t is a complete

I nsurance Solution that is ideal for automating and managing the front-end operations in a

L ife Insurance Organization.

T echnologies used: Developer 2000 (Forms 6i, Reports 6i), Oracle 9i

R esponsibilities:

• Responsible for developing and customizing the forms from conventional Insurance to

Takaful for the client HLTMT – Malaysia. I t deals with changes in the forms as per

new requirements from client. These forms belong to the various major modules of

I nsurance.

• Worked on Reports and Claim Module – w hich included claim intimation, claim

registration, claim processing and maturi ty processing components. Developed more

t han 30 Letter reports and M IS reports as per given specifications by client. Was

responsible for customizing the existing reports as per client request.

Contact this candidate