Project Sql Server

Rakesh R Pai

*** ***** ****, ***# **, Lyndhurst, NJ 07071

Cell: 201-***-****

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

Professional Summary:

. Nearly 5 years of work experience in Object Oriented Design, Modeling,

Programming and testing in .NET, COBOL, DB2, SQL and SSIS.

. Experience in all phases of software development life cycle.

. Excellent knowledge in RDBMS concepts and constructs along with

Database Objects creation such as Tables, User Defined Data Types,

Indexes, Stored Procedures, Views, User Defined Functions, Cursors and

Triggers.

. Extensive experience in writing Transact-SQL (DDL/DML) & DB2 queries.

. Expert in writing Data Cleansing, Data Scrubbing and Data Migration

methods.

. Experience in creating SSIS packages. Experience in DTS Migration and

Metadata Management. Migrating DTS packages to SSIS, Package Migration

Wizard, and Storage Management.

. Expert in Extraction, Transforming and Loading (ETL) data flows using

SSIS; creating mappings/workflows to extract data from SQL Server and

File sources and load into various Business Entities.

. Experience in Error and Event Handling: Precedence Constraints, Break

Points, Check Points, Logging.

. Proficient in implementing all transformations available on the SSIS

toolbox.

. Excellent knowledge of using variables and expressions in packages.

. Experience in writing VB scripts in script component task.

. Extensive knowledge in MS Excel which includes use of all the

functions, formulas to simplify the complex requirements.

. Hands on experience in reporting using MS Excel and MS Access.

. Extensive knowledge in automating MS Excel and MS Access reports using

Macros.

. Strong industry experience in complete project life cycle: Analysis,

Design, Development, Implementation as a Mainframe Developer.

. Extensive knowledge and experience in COBOL, CICS, JCL, SQL, DB2,

VSAM, FILE-AID, TSO/ISPF, CA7 (Scheduler), ACR tool, CHANGEMAN,

INFOMAN, SPUFI, IBM UTILITIES.

. Hands on experience in .NET Coding & Testing.

. Worked on development/staging/production environments and used team

foundation server/visual source safe for version controls and

communication's well as defining Actions, translations and

perspectives.

. Strong analytical skills with ability to quickly understand client's

business needs.

. Involved in meetings to gather information and requirements from the

clients.

. Research-oriented, motivated, proactive, self-starter with strong

technical, analytical and interpersonal skills.

. Extremely motivated, able to work smoothly even under pressure, meet

deadlines in advance, ready to accept new challenges and adapt quickly

to new technologies.

Technical Skills:

. RDBMS/DBMS: SQL Server 2008/2005/2000, SQL Server 7.0, 8.0, 9.0, MS

Access, SQL Plus and Db2.

. Database Tools: SQL Server Management Studio, SQL Server Profiler, SQL

Server Business Intelligence Development Studio, Visual Studio .NET

2005 & 2008, SQL Server Enterprise Manager, T-SQL, Data

Transformation Services (DTS), ODBC, Teradata, I-Series and DB

visualizer.

. ETL Tools: Data Transformation Services (DTS), SQL Server Integration

services (SSIS).

. Reporting Tools: Crystal Reports, SQL Server Reporting Services, MS

Excel and MS Access.

. IDE Tools: SQL Server BI Development Studio (BIDS), MS Visual Studio

2008/2005.

. .Net Frameworks: .Net Frameworks 1.0/2.0/3.0/3.5.

. Version Control: Visual SourceSafe (VSS).

. Mainframe Related: COBOL, JCL, ISPF, VSAM, IDCAMS, SPUFI and

DB2UTILITIES.

. Others Tools: Visual Explain, Citrix Meta Frame Access, HP Quality

Center, SPIRA for defect tracking, Remedy for Incident Management, MS

OFFICE.

. Operating System/Servers: Windows 9x/Windows 2000/Windows NT/ Windows

Server 2003/Windows XP, Vista, 7, MVS OS.

Professional Experience:

Company: INFOSYS LTD.

September 2008 till date.

Current Role: Technical Analyst.

Client: Ralph Lauren, Lyndhurst, NJ

September 2011 to till date.

Role: Technical Analyst.

Project: Data Migration.

This project involves development and maintenance of the RL Admin

Application which helps the Ralph Lauren users to view, update and edit

details pertaining to various stores that are already present and also for

new stores that will be opened in various locations. This offers a one stop

location where the logged in user can view data related to each and every

store and make modifications as required and also send for approvals for

the updates. The upgrade of the application requires data to be migrated

from old system to new system. The migration process includes requirement

gathering, data analysis, data cleansing and processing of complex data

structure to be implemented into new application.

Responsibilities:

. Involved in design, development and testing phases of project.

. Involved in architectural meetings. Created Architecture diagrams, and

Flow Charts using Microsoft Visio.

. Participated in the data model as to the relationship with the

application.

. Sole responsibility of entire data migration project.

. Handling of data using Excel.

. Created SSIS packages to clean and load data to data warehouse.

. Created SSIS Packages using Pivot Transformation, Fuzzy lookup,

Derived Columns, Condition Split, Term extraction, Aggregate, Execute

SQL Task, Data Flow Task, Execute Package Task etc. to generate

underlying data for the reports and to export cleaned data from Excel

Spreadsheets, Text file, MS Access and CSV files to data warehouse.

. Created database objects like Tables, Indexes, Stored Procedures,

Views, User Defined Functions, Cursors and Triggers.

. Created complex queries to automate data profiling process needed to

define the structure of the pre staging and staging area.

. Created complex DB2 queries to validate the data loaded.

. Created reports to show the success & failure rate of data migration.

Client: Infosys Internal Project.

June 2011 to August 2011.

Role: Senior System Engineer.

Project: HR Application.

This project includes development of the application used for HR's across

the organization. The manual tasks performed by the HR's were automated

which saved plenty of effort across the organization. The application

includes different level of security and access parameters because of

confidential data.

Responsibilities:

. Involved in design, development and testing phases of project.

. Involved in meetings with HR's across the organization to understand

the requirement and discuss the strategy. Created procedure to check

some of the rules at the backend at the time of entering data.

. Created Design document, test cases, database structures, tables,

views, stored procedures and server setups.

. Involved in coding & testing of the application using visual basic in

Visual Studio .NET 2008.

. Created batch jobs which will alert the HR's based on specific

condition.

. Involved in creation of high security layer in the application to safe

guard the confidential data of the Company as well as its Employees.

Client: Meijer Inc.

March 2009 to June 2011.

Role: Senior System Engineer.

Project: MEISLBSF.

This project involves maintenance and reporting of clients applications.

Budget for each store is estimated, based on this the labor is generated.

Labor is allotted to each store on weekly bases. Employee timings are

captured to determine the pay and to improve forecasting. Reports are also

generated for the required area for business analysis.

Responsibilities:

. Involved in requirement analysis, detailed design, low level design, test

activities in COBOL, CICS and DB2.

. Primary contact person for Labor Scheduling and monitoring the job

system.

. Managing Remedy tickets, scheduling and tracking it to closure.

. Experience in leading a module, working with clients to gather

requirements, scheduling/allocating/monitoring work among the team and

being responsible for the successful delivery of the entire project/sub-

project(s)

. Involved in automation of numerous report using Macros in MS Excel and MS

Access.

. Only person involved in reporting module of the project.

. Worked on production support and production fixes.

Key Achievements:

. Rising Star award for excellent contribution and support to the Meijer

Project.

. Excellence award for delivering the HR application on time by HR head of

RETAIL unit in Infosys.

. Client Superstar by senior management of Ralph Lauren for contribution

and support to data migration project.

. Single handedly achieving 100% success on data migration project at Ralph

Lauren.

Education:

. Bachelor of Engineering in Electronics & Communication from VTU

University, India.

. Extensive Training in .Net & Mainframe Technology.

Contact this candidate