Sql Server Data

Name: Sampada Rai

Email: abhuws@r.postjobfree.com

Tel: 832-***-****

Summary:

> Senior Data Warehouse Consultant with over 8+ years of experience

in all phases of software development life cycle, including

information strategy planning, requirement analysis and

prototyping, design, development, testing, debugging, performance

tuning and production support.

> 9+ years of ETL and data integration experience in developing ETL

mappings and scripts using Informatica PowerCenter

8.6/8.2/7.1,Microsoft SQL Server 2005 /2008 Enterprise Edition, SQL

Server Integration Services tools SSIS,SSRS, SSAS.

> Expert in Ad-hoc reports, drill down and drill through reports and

cross tab reports.

> Good experience using Oracle 10g/9i/8i/7.x, PL/SQL, SQL*Plus, Toad,

MS SQL Server 2008/2005/2002, MS Access.

> Vast experience in delivering business and technical documentation

for large Data warehouse projects using Microsoft suite of products

as a system analyst.

> Extensively worked on the ETL mappings, Data modeling, analysis and

documentation of OLAP reports requirements. Solid understanding of

Logical and Physical data modeling, Star schema, Snowflake schema,

OLAP and OLTP concepts and challenges, especially with large data

sets.

> Good knowledge in developing and designing reports through SSRS,

crystal reports, and Excel.

> Trouble shoots and resolves data related issues logged by customer.

> Experience in creating Transformations and Mappings using

Informatica Designer and processing tasks using Workflow Manager to

move data from multiple sources into targets.

> Experience in Performance tuning.

> Experience in Agile methodology with private and public sector as

well.

> Extensive knowledge of SQL Simple queries as well as complex

queries.

> Supported database related issues on production.

> Hands on experience in writing, testing and implementation of the

PL/SQL triggers, stored procedures, functions, packages.

> Expertise at Enterprise Database Integration and Management among

Oracle, MS SQL Server,Teradata, MS Access.

> Experience in Business Documentation especially in the Financial

Industry,Insurance and various Government sectors (like Health

Care,Agriculture,Employment)

> Excellent knowledge and experience in creating source to target

mapping, edit rules and validation, transformations, and business

rules.

> Strong leader with experience training developers and advising

technical groups on ETL best practices.

> Experience in development of software applications using Java, Java

Beans, JDBC, Java, XML, WebSphere (WSAD).

> Very analytical with excellent problem-solving and interpersonal

skills

> Good planning, organization, leadership and communication skills.

> Good knowledge of processes like CMMi Level 5 and ISO 9001:2000

Education:

Master in Computers from UPTECH University.

:

Technical Skills:

Data Warehousing Tools Informatica PowerCenter*8.5/7.1/6.2/5.1/4.7 (Source

Analyzer, Data Warehouse, Designer, Mapping Designer,

Mapplet, Transformations, Workflow Manager,

WorkflowMonitor, Worklets), Informatica PowerMart

6.2/5.2/4.7, Informatica PowerConnect, Cognos Series

7 & 8, SSIS,SSRS,SSAS

Data Modeling Dimensional Data Modeling, Star Join Schema Modeling,

Snow-Flake Modeling, FACT and Dimensions Tables,

Physical and Logical Data Modeling, Erwin

4.0/3.5.2/3.x.

Database

SQL Server 2008/2005/2008,Oracle 10g/9i/8i/8.0/7.0,

MS SQL

7.0,MSAccess7.0/97/2000, DB2,Access.

GUI Oracle Forms 6.0, Oracle Reports 6.0, VC++, MS

Excel-VBA

Macros, MS Word (VBA), Macros, FrontPage 97/98/2000,

Visual Basic 5.0/6.0, Visio.

Programming SQL, PL/SQL, Transact SQL(T-SQl), SQL*Plus, Java,C++

Front-end tools Oracle Designer, PL/SQL Developer 5.1.4,TOAD 7.x,

SQLNavigator 7.x, Eclipse 7.x, Visual Studio 6.0.

Scripting Language Unix Shell Scripting, PERL, Power shell

Environment Windows95/98/2000/XP, WinNT4.0HP-UX11/10/9, IBM-AIX

4.3/4.0/3.1, Sun Solaris 9/8/7/2.6/2.5,

AS/400,SCO-UNIX, LINUX

Professional Experience:

Hanger Orthopedic, Austin TX -Data warehouse Developer and Architect

July 2010 - Till Date

Hanger orthopedic has 800 PCC (Patient care center) all over the

USA.Responsible for creating data mart,ETL flow and how data mart will help

to create report on SSRS and SSAS for different users.

Responsibilities:

> Requirement gathering from Users.

> Developed logical and physical data models on the basis of requirement.

> Developed Data Mart from Logical design to Physical design, defined data

types.

> End-to-end ETL development.

> Maintained warehouse metadata, naming standards and warehouse standards

for future application development.

> Parsing high-level design spec to simple ETL coding and mapping

standards.

> Giving description about each element in reporting.

> Used SSIS as ETL tool and created packages as per business requirement.

> Maintain ETL packages in Development and Production environment as well.

> Trouble shoots and resolves data related issues logged by customer.

> Deploy DTS packages on server.

> Written SQL queries, PL/SQL, Functions, Package.

> Documented all test results, identifying and summarizing discrepancies.

> Participated in project review meetings.

Environment:

Microsoft SQL Server 2008 Enterprise Edition, Informatcia, SQL Server

Integration Services tools SSRS, SSAS, MS Visio, MS Excel.

Advanced Micro Device, Austin TX -Data warehouse Developer & Architect

Feb 2009 - June 2010

Description: Purpose of uYms(Unified yield management system)project to

improve efficiency of engineering teams(Taiwan)supporting yield attainment

and sustaining through automation of common analysis methods and provide

standard unified reporting for all products,accessible and useful for

yield improvement and status communication.

Responsibilities:

> Requirement gathering and Business Analysis.

> Analyzed the functional specs and created technical specs documents for

all the mapplet and mapping .

> Developed logical and physical data models..

> Converted the Data Mart from Logical design to Physical design, defined

data types

> End-to-end ETL development. Guide overseas team in development part.

> Maintained warehouse metadata, naming standards and warehouse standards

for future application development.

> Parsing high-level design spec to simple ETL coding and mapping

standards.

> Worked on Informatica Power Center tool - Source Analyzer, Data

warehousing designer, Mapping & Mapplet Designer and Transformation

Designer.

> Maintain Development, Test and Production mapping migration Using

Repository Manager, also used Repository Manager to maintain the

metadata, Security and Reporting.

> Used windows Scripting and Scheduled pmcmd to interact with Informatica

Server from command mode.

> Understand the business needs and implement the same into a functional

database design.

> Designed and developed UNIX scripts for scheduling the jobs.

> Designed the mapplet and use them for mapping so that developer can do

their work in less time.

> Extensively used Erwin for data modeling and Dimensional Data Modeling.

> Create temporary tables and optimizes the queries.

> Extracted data from engineering data to flat files and load the data to

the SQL server

> Tuning Informatica Mappings and Sessions for optimum performance.

> Build reporting with the use of business object universe.

> Created and executed test cases based on business testing requirements.

> Execute SQL queries in order to test the Aggregation Table.

> Conducted Integration/Regression, Functional, System and User Acceptance

testing for the application.

> Executed SQL statements manually to validate data from Database.

> Doing usability testing for all aggregation tables.

> Documented all test results, identifying and summarizing discrepancies.

> Worked as a team with other QA testers to ensure that all projects are

executed accurately and completely and assisted other testers with

account selection, clarification of ambiguity with test results and

general questions that arise.

> Generated weekly Status Reports to the team manager & participated in

weekly status meeting with Team members, Team managers, Business analysts

& Technical team.

> Participated in project review meetings.

Environment:

Oracle 10g, Microsoft SQL Server 2005 Enterprise Edition, Informatica, SQL

Server Integration Services tools SSRS, SSAS, MS Visio,MS Excel.

Texas Department of Aging and Disability Services (DADS), Austin TX -

Senior Software Consultant

January 2006 - January 2009

Description: The objective of Mainframe Migration is to replace the old

COBOL technology to the state of the art system based on Informatica, Java,

Oracle,and Unix platform. All the migration work is done to provide better

flexibility, scalability and maintainability to meet the ever changing user

needs.

Responsibilities:

> Requirement gathering and Business Analysis.

> Analyzed the functional specs provided by the data architect and created

technical specs documents for all the mappings.

> Used Microsoft Visio to come up with detailed diagrams for user and

technical team.

> Developed logical and physical data models..

> Converted the Data Mart from Logical design to Physical design, defined

data types

> Build a dimensional modeling using a stars and snowflake schema with

various dimensions

> Using the Informatica designer created the structure of files.

> Using the Informatica designer created mapping.

> Extensively used Informatica Power Center to design multiple mappings

with embedded business logic.

> Creation of Transformations like Lookup, Joiner, Rank and Source

Qualifier Transformations in the Informatica Designer.

> Created complex mappings using Unconnected Lookup, Sorter, Aggregator,

newly changed dynamic Lookup and Router transformations for populating

target table in efficient manner.

> Using the Informatica workflow created a workflows and session.

> Created FTP connections through the Unix shell script.

> Created an Oracle connection through parameter files.

> Created UNIX shell scripts and processes to extract data from various

sources such as Oracle.

> Experience with Cognos Impromptu and made various cubes based on the

reporting requirement.

> Used windows Scripting and Scheduled pmcmd to interact with Informatica

Server from command mode.

> Implemented complex transformations by creating custom transformations in

addition to using built-in ones.

> Developed Batch applications using core Java as part of migration

effort. Designed and developed Medicaid Estate Recovery Program (MERP)

and other Eligibility Interfaces.

> Extracted data from SAS(Service authorization table) to flat files and

load the data to the target database.

> Oversaw unit and system tests and assisted users with acceptance testing.

> Conducted peer design and code reviews and extensive documentation of

standards, best practices, and ETL procedures.

> Conducted unit and integration testing to ensure Accuracy.

> Played role in design of scalable, reusable, and low maintenance ETL

templates.

> Developed PL/SQL triggers, stored procedures, functions, packages.

> Designed and developed Informatica Mappings to load data from Source

systems to ODS and then to Data Mart.

> Extensively used Power Center/Mart to design multiple mappings with

embedded business logic.

> Used windows Scripting and Scheduled pmcmd to interact with Informatica

Server from command mode.

> Analyzed and reviewed the software requirements, functional

specifications and design documents.

> Worked in team environment, to achieve project quality goals.

> Performed positive test, negative test and system testing.

> Documented and reported the test results.

Environments:

Oracle10g, Informatica 7.1, Informatica 8.5,Unix shell scripts, SQL,PL/SQL,

Microsoft Access, JAVA, XML., MS/Office Suite,Visio

Springs Industries, Austin TX - Data Warehouse Programmer

January 2004- December 2005

Description:

Springs Industries supplies leading retailers with a complete line of

coordinated home furnishings designed to simplify home decorating for every

consumer. This system is the central repository for all the functional area

and delivers the information to various users across Springs Industries.

Mainly this system pulls the data from various database loaded to SQL

Server data warehouse and to generate the reports using SSRS for different

SSAS Cubes. This pulls various data including Finance, Manufacturing,

Inventory, Advances Cost Accounting and Procurements.

Responsibilities:

> Requirement gathering and Business Analysis.

> Conducted cost benefit analysis of various ETL tools and

technologies.Created System design document.

> Processes to extract data from various sources such as DB2, Microsoft

Access, Flat file and Microsoft SQL Server.

> Design and created different ETL packages using SSIS from Oracle source

to Sql server as destination.

> Created SSIS Packages to import and export data from Excel, Xml and Text

files.

> Build a dimensional modeling using a stars and snowflake schema with

various dimensions.

> Oversaw unit and system tests and assisted users with acceptance testing.

> Transformed data from various data sources using OLE DB connection by

creating various SSIS packages.

> Developed complex reports using multiple data providers, user defined

objects, aggregate aware objects, charts, and synchronized queries

> Created star schema in SSAS and developed SSRS reports based on the

cubes.

> Conducted peer design and code reviews and extensive documentation of

standards, best practices, and ETL procedures.

> Transformed data from various data sources using OLE DB connection by

creating various SSIS packages.

> Creation of database, tables and procedures to update and clean the old

data.

> Played role in design of scalable, reusable, and low maintenance ETL

templates.

> Experience with Analysis services 2000/2005 and made various cubes based

on the reporting requirement.

Environments:

DB2, Microsoft Access, Microsoft SQL Server 7.0,T-SQL,

Oracle9i,SQL.PL/SQL,INFORMATICA 8, UNIX Script,MS/Office Suite, Visio.

National Informatics Center (NIC), Austin TX - Data Warehouse Analyst and

Developer

March 2002- December 2003

Description:

The objective of statistical report management is to develop the Data

Warehouse for statistical information of the state. The Project involved

extraction of data from various data sources such as Flat File,, SQL

Server, MS access 2000 and FoxPro and loaded into SQL Server. Our team is

responsible in building and maintaining interface packages' build on

informatica to transform periodic transactional feed to DSS system (Data

Warehouse).project involved extensive cleansing of dirty data, data

migration, data transformation and loading of data.

Responsibilities:

> Requirement gathering and Business Analysis.

> Analyzed the functional specs provided by the data architect and created

technical specs documents for all the mappings.

> Develop logical and physical data models that capture current

state/future state data elements and data flows using Erwin.

> Converted the data mart from Logical design to Physical design, defined

data types, Constraints, Indexes, generated Schema in the Database,

created Automated scripts, defined storage parameters for the objects in

the Database.

> Defined various facts and Dimensions in the data mart including Fact less

Facts, Aggregate and Summary facts.

> Reviewed source systems and proposed data acquisition strategy.

> Designed and Customized data models for Data Mart supporting data from

multiple sources on real time.

> Designed the Data Mart defining Entities, Attributes and relationships

between them.

> Extensively used Erwin tool.

> Created interface stored procedures used in SSIS to load/transform data.

> Developed reporting stored procedures used by application developers for

displaying reports.

> Created and schedule SSIS packages to load the data.

> Provided Knowledge Transfer to the end users and created extensive

documentation on the design, development, implementation, daily loads and

process flow of the mappings.

> Used shell scripts for automating the execution of maps.

> Designed and developed Oracle PL/SQL scripts for Data Import/Export.

> Created various UNIX Shell Scripts for scheduling various data cleansing

scripts and loading process. Maintained the batch processes using Unix

Shell Scripts.

> Designed and Deployed UNIX Shell Scripts.

> End-to-end ETL development of the Premium Module Data Mart.

> Maintained warehouse metadata, naming standards and warehouse standards

for future application development.

> Parsing high-level design spec to simple ETL coding and mapping

standards.

> Designed and developed UNIX scripts for creating, dropping tables which

are used for scheduling the jobs.

> Data Quality Analysis to determine cleansing requirements.

> Extensively used Erwin for data modeling and Dimensional Data Modeling.

> Responsible for the Dimensional Data Modeling and populating the business

rules using mappings into the Repository for Meta Data management.

> Extracted data from various departments to flat files and load the data

to the target database.

> Created and maintained several custom reports for the client using

business object.

> Generated report in Microsoft access application using visual basic

application

Environment:

Oracle, SQL server, Informatica, Business object, Erwin, Visio

National Informatics Center (NIC), Austin TX -Data Warehouse Analyst and

Developer

Jan 2001 -February 2002

Description:

.

Project was to design, develop, implement and maintain ETL components for

the sales data mart to provide analytical information. A data Mart was

built with sources including sql server, and target database is oracle.

Responsibilities:

> Interacted with Business Analyst to understand the business

requirements.

> Installed upgraded and migrated databases from MS SQL Server 2005 to

Oracle database.

> Designed ER diagrams and mapped the data into database objects.

> Involved in Normalization of the Database in OLTP.

> Involved in the analyzing and solved problems doing the Client

Application system's installing, upgrading and running stages.

> Design and created different ETL packages using SSIS from Oracle

source to Sql server as destination.

> Created new logical and physical design of database to fit new

business requirement and implemented new design into SQL Server 2005.

> Wrote SQL scripts to Insert/Update and Delete data in MS SQL database.

> Involved in table and index partitioning for performance and

Manageability.

> Identified, tested, and resolved database performance issues

(monitoring and tuning) to ensure database optimization

> Created schemas, views, stored procedures, Triggers and functions for

Data Migration. Involved in the complete life cycle of the project,

from Planning Staging and pushing the codes to production.

> Developed complex reports using multiple data providers, user defined

objects, aggregate aware objects, charts, and synchronized queries

> Prepared tests cases for Quality assurance and testing application on

consultation with Tech Lead.

> Creation of database, tables and procedures to update and clean the

old data.

> Helped the front end application developers with their queries.

> Created SSIS Packages to import and export data from Excel, Xml and

Text files.

> Performance tuning of SQL queries and stored procedures using SQL

Profiler and Index Tuning Advisor.

> Transformed data from various data sources using OLE DB connection by

creating various SSIS packages.

> Configured SQL mail Agent for sending Automatic emails on Errors.

> Monitored the overall performance of the database to recommend and

initiate actions to improve/optimize performance.

> Involved in writing different testing scripts for the testing of the

Codes.

> Created star schema in SSAS and developed SSRS reports based on the

cubes.

> Conducted unit and integration testing to ensure Accuracy.

> Generated Ranking reports using SQL Server Reporting Services for

different subjects.

.

Environment:

Microsoft SQL Server 2005 Enterprise Edition, SQL Server Integration

Services, Informatica,MS Visio,MS Excel.

Contact this candidate