Data Sql

Raghu Satya

610-***-**** (USA)

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

US Citizen

PROFESSIONAL SUMMARY:

. 15 years of IT experience and expertise in SDLC Oracle (9.i/10g/11g)

. 10 years of experience in Design and Manage/Lead -Data Warehouse

Application using Informatica and SAP Data Integrator/Data Services

. 10+ years of total IT experience with projects emphasis on Database

designing, Data Warehousing, Data services, and Client/Server data

services systems architecture.

. About 8 years' experience in designing Dimensional Data modeling (Star

Schema) with ERWIN

. Extensive hands on experience with moving data from using SAP BO Data

Services 3.2/4.0 and successfully implemented more than FIVE SDLC

projects. Working knowledge on SAP Hana projects.

> April 2009 - Till date

. Proficient in DBA skills, performance and tuning of SQL queries, database

tables, and indexes

. Manage/Lead data warehouse projects/team- from capturing business

requirements, design to implementation, and various phases of data

migration

. Experience in Pharmaceutical industry (sales & distribution & clinical

trials), Utility, Supply Chain, and Federal & State projects.

PROFESSIONAL EXPERIENCE:

GE Capital

Dataware house Analyst (ETL Architect)

April 2009 to Present

. Lead ETL code migration (BODI to BODS) projects, preparing project plan

and oversee ETL code migration and Database (oracle10g -11g) migration

and review and sign off

. Designed, development and implementation of SAP Data Services 3.2/4.0 in

client's landscape.

. Manage ETL applications using Business Objects data integrator /Data

Services from DB2/400, SQL server Oracle 9i/10g, flat files

. Responsible for gathering business requirements and develop technical

design documents for the total application about the production of ETL

solutions.

. Perform Analysis, Design and Implementation of Dimensional data models as

per the business needs

. Responsible for peer code reviews in addition to development like Data

mappings to follow the coding standards.

. Managing admin console, job scheduling and server monitoring of all

applications.

. Work in conjunction with the Business Intelligence reporting and Data

Warehouse team to offer end-to-end Business Intelligence solutions

. Manage multiple projects working with global teams/offshore teams and

manage offshore BO resources to translate the reports specifications into

business reports

. Review Design and code standards, technical documentation, and finalize

deployments to suit to production environment

. Communicate project status proactive and resolve the conflicts within

internal management teams.

. Understanding of EAI, Database, Data Modeling in order to ensure proper

usage of these methodologies as part of the design efforts in building a

system to be put into production.

. Promote and follow the established processes, policies, standards and

procedures to assure compliance with corporate and regulatory policies

and standards.

. Understandings of life cycle development through production

implementation and post implementation and present them at the

architecture review meeting, whenever required.

Environment: Oracle 10g/11g, SAP BODS/BODI/Data Services, informatica 8.X,

PL/SQL, SQL, Linux, UNIX Shell Scripts, Erwin

Accenture Technology solutions (2004-2009)

Merck Pharmaceuticals (Clinical Study Designer)

sr Systems Analyst

Oct 07 to Nov 08

Responsible for deliverables and develop in accordance with standard

business processes, and meet client requirements. Work with onshore and

offshore resources including Design, Develop and Deliver (3D) -client team

members, project managers and other Merck functional departments during the

initial specification & final User Acceptance Testing (UAT) of EDC

applications for clinical studies, specifically SDTM mappings. Technical

liaison and coordination with offshore, onshore and client managers, and

responsible for the implementation of trails

Roles & Responsibilities:

. Responsible for technical aspects /specifications (SDTM mapping CDISC

etc.) of EDC trials for coding standards and processes

. Designed, development and implementation of SAP Business objects Data

Services

. Responsible for setting up, Clinical views, Creation of Specs to load the

clinical data and update the Define.xls document

. Develop the technical specification (SDTM specs and Define.xls) and

development efforts for assigned deliverables for EDC studies

. Build and maintain strong working relationships with the technical

support groups handling the EDC and warehouse data environments as well

as with the technical teams supporting the Phase Forward software with

client personnel

. Work with onshore and offshore resource on therapeutic area and shared

service roles to promote consistent operations, efficient use of

resources and sharing knowledge/best practices. Support management of CDM

in achieving common goals.

Accenture Technology Solutions

Merck Pharmaceuticals (Onshore Lead)

Sr Systems Analyst/SR ETL Consultant

Jan 07 to Sep 07

As Lead, provide Tier II support to the user community across a suite of

Clinical Applications. In addition responsible for translate the business

needs into work for the Tier 3 portion of the team(offshore) and guide the

team to complete the task and meet the SLA.

Roles and Responsibilities:

. Troubleshooting technical issues and providing resolution and

Communicate with users and provide resolution

. Gather Requirements and Lead development team and provide technical

specifications to the break-fix (PL/SQL procedure) and strictly adhere

to the client service level agreements (SLA)

. perform the data analysis and write the SQL queries to validate the

data.

Environment: Oracle 9.i, PL/SQL, SQL, SQLNavigator, Erwin, VLDB (Very large

databases)

Accenture Technology Solutions

Qualcomm, San Diego, CA

Sr Systems Analyst

Oct 06 - Jan 07

Description: As Lead Data modeler- responsible for the gather the

requirement and translate them logical and physical and as an Informatica

developer responsible for load the into target table from multiple source

using various transformations (Source Qualifier, Aggregate, Look-ups,

sorter etc).

Roles and Responsibilities:

? Design and update the dimensional Data model using ERWIN as per the

reporting requirements.

? Work with Client management, ETL (Informatica) and BI teams update

the data model as requirement changes

? Load the data from multiple sources (approx 10) using the

transformation into target tables using Informatica

? Responsible for user requirements as per the reporting need and

translate to the as appropriately

? Identify, update, create and deploy the indexes as per the

requirements and modify the model to up to date

Environment: Oracle 9.i, PL/SQL, SQL, SQLNavigator, Erwin, VLDB (Very large

databases)

Accenture Technology Solutions

PPL Solution's Billing/ER Portal -Allentown- PA

Sr Systems Analyst /SR ETL Consultant

Jan 05 to Oct 06

PPL implemented two versions of Customer/1; one for their distribution

company (PPL Electric Utilities) and one for their supplier company (PPL

Solutions). The PPL Solutions version of Customer/1 is primarily used as a

billing and deregulation enrollment system for PPL and other supplier

companies not owned by PPL. The resource will provide day-to-day

analytical, programming and performance support to the PPL Solutions

(supplier) Customer/1 system. Additional responsibilities include, but not

limited to, supporting other applications and modules developed and

maintained by PPL Solutions and working with client counterparts to provide

additional services where needed.

Roles and Responsibilities:

. As PPL System-Analyst responsible for design, coding and enhancing the

exiting application

. Use automation application to automate file transfers with new trading

partners

. Work with department managers, business system programmers, IT group

and EDI staff to define, build, and implement solutions.

. Gather the requirements from business user and update the data model

using ERWIN as per the requirements/enhancements.

. Perform the process improvements of packages and procedures using

PL/SQL tables, user defined record types and bulk collect processing

. Support all EDI import and export projects; appropriately schedule all

EDI transactions; document daily EDI jobs/transactions in job control

log; identify, document and communicate any problems or issues to

appropriate personnel.

. Gather, design, configure, develop and deploy the Oracle portal

(Oracle HTTP) applications

Environment: Oracle 8.i/9.i, PL/SQL, SQL, HP-UX, UNIX Shell Scripts, SQL*

LOADER, PVCS, SQLNavigator, Erwin

Accenture Technology Solutions

Profit line profitability, Unisource

Systems Analyst /SR ETL Consultant Oct 04 - Dec 04

Profit line profitability is a Tool for Unisource to identify the

profitability at the line level as well as group level. It Assists Business

Managers in evaluating the profitability of customers served by their sales

teams and their individual orders enables

Roles and Responsibilities:

. Assist the business in refinement of data model and Assist with

initial database setup.

. Write PL/SQL packages and procedures to perform the profitability of

customers served by their sales teams and their individual orders

. Create and modify the Adhoc queries using Oracle 9.i analytical

functions

. Perform Unit testing and Co-ordinate with development team in System

testing and work with UAT team for data requirement.

. Lead the performance testing Phase of PL/SQL code and SQL queries and

complete conduct peer code review

Environment: Oracle 8.i/9.i, PL/SQL, SQL, HP-UX, TOAD, Erwin, Autosys

Accenture Technology Solutions

AstraZeneca (BIS Sales Tools Support)

Systems Analyst

Jan 04 - Oct 04

BIS OPM directly supports the US Business by providing the application

delivery and support services needed to promote and sell AstraZeneca

products.

Roles and Responsibilities:

. Load and configure data for STP (strategic targeting plan) aka sample

allocation

. Develop and modify the existing programs for Individual De-Dup for

operating time or improve efficiency.

. Test, debug, and refine the STP team alignment and ZS/IMS data.

. Prepares required documentation, including both program-level and user-

level documentation

Environment: Oracle 8.i/9.i, PL/SQL, SQL, HP-UX, UNIX Shell Scripts, SQL*

LOADER, Visual Source Safe, TOAD, Erwin, Autosys

Marketing solution to Customers

ETL Consultant

Mar 03 - Nov 03

It is a development and maintenance project. For Marketing Research Company

the data is in the form of flat files, either in fixed or comma-delimited

format depending on the needs of the business clients. Roles and

Responsibilities:

. Responsible for loading the data into staging area using SQLSERVER DTS

(Data Transformation Service).

. Write automation scripts using UNIX Korn Shell script to load the data

into oracle tables and develop procedures and packages using oracle

. Enhancing the existing stored procedures, packages and building

reports using new features as ROLLUP and CUBES functions of Oracle and

SQL SERVER

Environment: Oracle 8.i/9.i, PL/SQL, SQL, UNIX Shell Scripts, Erwin, SQL

Server 2000, Cognos -BI-Suite

RCG Information Technology

NWAES APPLICATION (Merck Pharmaceuticals)

Sr.Consultant Dec 01 - Jan 03

This project is for Merck Pharmaceuticals. NWAES is a complex, multi-

layered application designed to replicate in 35 different countries

worldwide. As a developer (back end), responsibilities include developing

packages and procedures, data analysis, loading, extraction and

transformation of pharmaceutical data.

Roles and Responsibilities:

. developing test programs for database applications and perform Unit,

Integration and User Acceptance testing for accuracy and performance.

Also responsible for creation of deployment specifications

. Responsible for Audit Trails, Validations, Edit checks and coding of

PL/SQL programs.

. Responsible for Performance and Tuning of tables and indexes.

Environment: Oracle 8.i/9.i, PL/SQL, SQL, HP-UX, Win NT/XP, UNIX Shell

Scripts, SQL* LOADER, SQL Navigator

Accounting Management Company

Data warehouse (OLAP) Federal Govt

Sr. Consultant Dec 99 to Nov 01

Description

This project is for Department of Veteran Affairs, Federal Government

Agency that processes the claims for Veterans. The size of application

varied from 150-500 GB, and daily records varied from 1 mil- 2 mil, weekly

and monthly basis. Based on application requirements the partition are

maintain (add/drop) and purge on Daily/Monthly basis.

Role and Achievements:

. Responsible for gather requirements, design, develop and automate the

programs

. Perform full life-cycle systems development. Design and implement data

models (STAR SCHEMA) for database application using ERWIN.

. Design and build Cognos catalogs using Impromptu and cubes using Power

Play based on business requirements.

. Create Informatica Mappings with PL/SQL procedures/functions to build

business rules to load data from multiple sources using

Transformations like Source Qualifier, Aggregator, Expression, Joiner,

Connected and Unconnected lookups, Filters and Sequence, Router and

update strategy. Data mapping from COBOL load transformation.

. Develop and modify queries, programs (packages), database triggers and

stored procedures to provide support for standard and ad-hoc

reporting.

. Analyze source data of different types and design programs for data

integration, cleansing and transformation using data junction.

Environment: Oracle 7.3/8.i, PL/SQL, SQL, Sun Solaris 4000, Sun Solaris

10K, Cognos (impromptu, power play, power prompts), PVCS/Visual source

safe, VLDB (Very Large Database). Informatica (Power Center/Power Mart),

IBM mainframe, COBOL, Autopsies

Covansys

MDOS, Lansing -MI

ETL Consultant

Sep 97 - Oct 99

Responsibilities:

. Responsible for gather requirements, design, develop and automate the

programs

. Perform full life-cycle systems development. Design and implement data

models (STAR SCHEMA) for database application using ERWIN.

. Participate in day to day - job related work.

Education:

M S -in Computer Applications -India

B S- in Mathematics Physics and Chemistry

Contact this candidate