Data Sql Server

SAI MAGULURI

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

*** ***

**36

SUMMARY:

. Around 12 years of experience as a Data Analyst and Business Analyst

in client/server, web & database applications.

. Interact with business users to gather requirements & document the

same.

. Write Technical Documents, Training manuals and Test Cases for UAT.

. Knowledge of SQL Server, DTS, Data Validations, Data Mapping, Data

Modeling and Data Migrations.

. Experience using Data Analysis tools like Grand Central with SQL, BST

Enterprise, Back=Office, Cransoft (Cranberry), BOA Data Staging

Warehouse, Data Governance, and Crystal Reports.

. Exposure to Project Management, Project Planning, and Co-ordination.

TECHNICAL SKILLS:

Web Development: .NET, ASP, VBScript, Visual Interdev, VBA, JavaScript,

Bobby, Dream weaver, Visual Studio, VSS, Documentum,

Optech(Optical Image Technology

-Workflow/DocumentManagement), Clearcase.

Project MS Project, Igraphix, Visio 2000, and Sybase Power

Management: Designer 9

Database: MS Access, SQL, Oracle, DB2, Grand Central, Armor,

Salesforce, Erwin, Documentum, Model N, Mercury testing

tools.

Reporting: Cognos, Impromptu, Excel 2000, Access 2000, and Crystal

Reports

Operating Windows 95/98/NT/2000.

Systems:

Servers: Windows NT/2000, IIS, & BST Enterprise Server, Grand

Central.

PROFESSIOAL EXPERIENCE:

Delaware Investments 06/09- Current

Macquarie Funds Group

Technical Business Analyst

. Write Business requirements Documents to separate the Data from

Delaware Investments.

. Check the Databases and remove the Lincoln Financials data from

Delaware Investments which is to be migrated to Macquarie Systems.

. Identify the reports that belong to Delaware Investments and Checkin

into Optech System, an Optical Image Technology (Repository to store

Reports in the form of Optical Images).

. Coordinate among other data architechts to check Data patterns, errors

and duplicates and resolve issues.

ABB (OSA), OH.

02/08 - 05/09

Lead Data Quality Analyst

Responsibilities:

. Lead Programmers to remove duplicates, address incomplete data and

missing fields to data owners to ensure Data Quality for data

Migration.

. Create several Views and Queries in SQL Server and register them in

Cransoft and work with Data architechts to check errors and

duplicates.

. Analyze and modify existing rules and reports based on the Control

Sheets and Business requirements and document the process.

. Write Test Cases, error reports and escalate errors to other team

members

SAP AMERICA (SAP Global Markets), NYC.

12/07 - 02/08 Business Analyst

Responsibilities:

Write Technical Design documents for Data Quality testing and reporting.

Work with the BI analysts and analyze the web clickstream and statistical

data as well as tele data for campaign effectiveness reporting.

Liaison between the business side and Database team during data uploads and

driving it through the development stage.

Write Traceability Matrix to ensure requirements through each stage of the

requirements gathering process.

ROHM and HAAS (SAP IT), PA.

01/07 - 12/07

DataAnalyst

Responsibilities:

Gather requirements and document data elements and data definitions spread

across the network.

Check and import Material Master Data and Pricing Data into Exel and Data

Staging Warehouse (DSW) by DTS Packages and Views in SQL Server and

register them in Back Office Cranberry for Data analysis.

Create several Views and Queries in SQL Server Generate, test and modify

error Reports and Information Reports.

AIR PRODUCTS AND CHEMICALS, PA.

07/06 - 12/06

Data Analyst

Responsibilities:

Document & validate Global Data Definitions using existing documents.

Gather requirements from various Data providers in different countries and

ensure data is delivered in required format, at scheduled time.

Help extract data from the source system into BW system by BDC scripts.

Download Data from SAP into Excel/Flat files using different SAP

transactions like SE16, SE30, etc. and transfer it to SQL Server by DTS.

BRISTOL MYERS SQUIBB CO., NJ.

05/05 - 07/06

Business Data Analyst

Responsibilities:

Analyze Customer Historical Data, Customer Orders and Price History of the

Products to be converted from SAP and Model N to SQL Server.

Extract and analyse customer and pricing data and document the process.

Check data mapping and DTS Packages in BOA Data Staging Warehouse.

Gather Requirements & Write technical design documents for the project.

Write SQL procedures operating on the Data Stage Warehouse to extract,

transform or export data between the source and target systems/data sets.

CITIGROUP, NYC. 08/04 - 04/06

Senior Business Data Analyst

Responsibilities:

Consolidate the data spread accross the network into Data Dictionaries.

Work with data architects to migrate data from Excel forms and Application

and Business Compliance Questionnaires to SQL Server database.

Assist building Data Models and Process Reengineering using Erwin.

Create tables, views, and list boxes so users can view and customize ad-hoc

reports in SOLAR and support Crystal Reports user-training sessions.

Work on flow charts & Data Models with Power Designer, Erwin & Visio.

KLING, PA. 08/03 - 08/04

Data Analyst

Responsibilities:

Write Tax reports with BST Accounting Software and Crystal Reports.

Develop, maintain and support an ASP-based intranet application to support

the daily activity of the firm.

Identify and gather requirements for a data warehouse team to extract

business intelligence Data for Sales and Marketing Application.

Import data dumped from the Mainframe COBOL VAX System to Excel and Export

to SQL Server byDTS and ActiveX scripts.

BANK ONE, DE.

05/01-07/03

Data Analyst/Business Analyst

Responsibilities:

Write Project schedules, deliverables and timelines with MS Project.

Organize meetings with the Users, Database Architects, Programmers and

higher Management to check the Status and discuss various issues.

Analyse data and assist the developers in redesigning the website for

disabled users with according to FDA and ADA-Compliant standards using

Adobe Photoshop, Dream weaver, Bobby, and other tools.

STATE AND FEDERAL INC, DC.

03/98 - 05/01

Data Analyst

Responsibilities:

Develop user interface using ASP for an insurance claims application to

capture individuals' contact information to conduct surveys.

Gather and analyse data and generate SQL Queries to check Data errors.

Write Excel/VBA scripts to automate data import and Data manipulation.

VZ India, India.

Developer

Responsibilities:

Collect data into Excel and create tables in SQL Server for the VB project

Develop a menu driven Sales Application using Visual Basic and SQL Server.

EDUCATION:

Post Graduate Diploma in IT - University of Madras.

Mphil.(PreDoctorate) - University of Madras.

M.A./English - University of Madras.

B.A - Accounting, Gulbarga University.

Contact this candidate