Objective

To obtain a position as a Senior SQL Server Database Programmer / Data Analyst / BI / Report Developer utilizing my technical skills, education and experience.

Work Summary

Ï 5+ years of Data Analysis, BI (SSIS), Report Development and Microsoft Sql Server DBA experience
Ï 7+ years of Database Programming – T-Sql, Index, SP and Trigger Programming
Ï 12+ years of IT Programming (Microsoft Technologies) /System Analysis experience
Ï Expert knowledge of Microsoft Technology Programing, Data Analysis, Reports Development in Client Server and Web Technologies using Crystal Report & SSRS
Ï Excellent Server Management skills including code deployment and maintenance using SCOM.
Ï Excellent troubleshooting and communication skills with Project Execution skills.

Dates of Employment: December 2011 – April 2012
Company/Client: Confidential,TX
Project / Location: Confidential,Richardson, TX
Job Title: Sr. Software Engineer - SQL Server Data Analyst

• Compare different source data by mapping and delivering data analysis risk reports (Using Red-Gate, TSQL)
• Writing, Running SQL Queries/Downloading and uploading data between Teradata and SQL server using SSIS.

Dates of Employment: October 2005 – December 2011
Company: Confidential,
Project / Location: Confidential,Overland park, KS
Job Title: Sr. Programmer Analyst - SQL Server Developer & BI

• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Excellent T-SQL Programming skills. Maintaining coding standards across the board in all SQL Server environments. Experience in query optimization & performance tuning.
• Developed different reports per flood business requirements
• Extensively worked and had good knowledge on Integration and Reporting Services and good experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2005
• Having good experience in ETL using SSIS, SSAS and SSRS Reporting.
• Experience in data dictionary software packages uses to ensure data integrity and security.
• Strong experience in Database authentication modes, creation of users, configuring permissions and assigning roles to users. Experience in installation and configuration of MS SQL Server 2000/05 for Flood Insurance.
• Experience in Query Optimization, Tuning of Stored Procedures, and Performance Tuning.
• Has good knowledge in SDLC and experience in an operation environment providing support involving coordination with release management and change management.
• Experience in recovering corrupted data and eliminates data redundancy..
• Good Experience in SCOM 2007 R2 - Deployment, Configuration and using SCOM for Monitor ASP.NET Application, Monitor Network Devices, Monitoring VMware Servers and Monitoring Non-Windows Devices.
• Strong experience in performing database consistency checks, planning and scheduling Backup, Restore and Recovery procedures.
• Successfully migrated SQL Server 2000 servers to 2005, including Replication.
• Extensively worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
• Used SQL Profiler, Execution Plan and Performance Monitor
• Experience in Database Mirroring, Database Snapshot and Isolation Levels.
• Experience in Replication – Snapshot, Merge and Transactional.
• Very good understanding in SDLC (Systems Development Life Cycle) with development in .Net technologies

Flood Reports System

• Created new Reporting Systems using SQL Server 2005 Reporting Services, Report Viewer controls in VS.Net.
• Modularized and designed a reporting system which can be enhanced and developed independent of the current Flood System.
• Development and Maintenance in existing Crystal Reports using Crystal Report 10.

Production Support

• Web/Web Farm, Batch and Citrix server configuration and maintenance (using SCOM).
• Lead team in Production Batch Supports by automating batches, problem solving and mentoring with experience gained all these years in batch support.

Dates of Employment: April 2005 – October 2005
Company: Confidential,
Location: Baltimore, MD
Job Title: Senior Consultant – Database Programming and Report Development

• Developed highly complex and customized reports for Federal Govt. by using Crystal Reports/SSRS for Mid-Atlantic Career Consortium Project.
• Involved in SQL Server database administration and maintenance activities along with Database Programming.
• Provides estimates to complete a desired modification; analyze the client’s requirements and suggested and developed the best possible reports keeping in the mind the cost and the feasibility with DLLR’s unique architecture with PDF export facility.
• Environment: Crystal Reports 10, Crystal Enterprise Server, SSRS, ASP, XML, XSL, MTS, IIS and .Net Tech using ASP.Net and ADO.Net with SQL Server 2000 Installation, configuration and maintenance of Windows 2000/NT 4.0, FORTE and SQL 6.5 servers

Dates of Employment: October 2004 – March 2005
Company: Confidential,
Project / Location: Confidential,Hopewell, NJ
Job Title: Business analyst / Tech Lead

• Played business analyst, Tech lead roles, collected requirements from business, analysis design including detailed design document preparation with proto type design.
• Supporting offshore teams, functional and system testing by using Rational Robot automated testing tool and delivery of those test scripts. Worked with offshore model and implemented successfully.
• Developed Portfolio Management Reporting reports for MLIM.
• Environment: Crystal Reports, MS Project and Rational Robot and SQL Server 2000

Dates of Employment: March 2004 – September 2004
Company: Confidential,
Location: Confidential,Plainsboro, NJ
Job Title: Team and Tech Lead

• As a Team Lead: Risk Enhancement project involved enhancements to the existing application with the addition of Risk Module. This included a web based interface for maintaining counterparty and the related data regarding its group, credit rating, and capital and risk information.
• The project also involved implementing a reports module (pdf reports) for current and historic dates. Automatic daily pdf reports are created through batch jobs in UNIX.
• Certain jobs were created in PERL for storing historic prices, exchange rates and loan related information. These run at specified time intervals.
• Full responsibility from requirement analysis to development. Lead a 4 member technical during the development of this application with onsite-offshore model
• Client/Onsite Business Analyst- interaction, process implementation and documentations in various stages of the project with on-time successful quality development.

Dates of Employment: January 2004 – March 2004
Company: Confidential,
Project / Location: Confidential,Hopewell, NJ
Job Title: Senior Analyst

• Merrill Lynch Investment Managers (MLIM) has implemented MOSP (Middle Office Strategic Platform) for supporting their middle office business process
• Analysis and Design including Use case preparation and Unit Test Plan preparation with Development.
• CMM documentation for IT our project SDLC

Dates of Employment: March 2003 – December 2003
Company: Confidential,
Location: Confidential,Baltimore, MD / Development at Chennai, India
Job Title: Senior Analyst

• Module Lead in Development group in Java Technology Web Programming for TRowePrice.
• Worked for CitiBank Singapore – Java we programming in this period in the same project group
• Project planning and tracking using MS Project 2000 and Reports preparation for CMM

.
Dates of Employment: October 2002 – February 2003
Company: Confidential,
Project / Location: Confidential,Chennai, India
Job Title: Senior Analyst / Team Lead

• Requirement collection, Analysis, Effort Estimation, Working Prototype Development in Crystal Report.
• Team Management with Effective Client Interaction with Testing Management
• Technical support to Team Members in ASP, VB/JavaScript, COM, MTS, Crystal Report 8.0 and Oracle

Dates of Employment: August 2000 – October 2002
Company: Confidential,
Location: Chennai, India
Job Title: System Analyst / Project Lead

• Project Lead for Enterprise HealthCare Solution VB product with SQL Server with 5 member team
• Requirement Collection, Design, Estimate, Schedule Preparation/Task Assignment and Development

Dates of Employment: July 1998 – August 2000
Company: Confidential,
Location: Chennai, India

Education
Master of Business Administration (Systems)
Bachelor of Engineer (Electrical and Electronics Engineering)

Certifications

Ï Java Certified Professional (JCP) - 2000
Ï Microsoft Certified Solution Developer (MCSD) – 2000
Ï Microsoft Certified Application Developer for .Net (MCAD) -2003

Technical Summary
Languages: Java 1.2, HTML, XML, VB, PERL, C#, VB and JavaScript
Software: SSRS, SSIS, Crystal Reports 8.5/10, CF, Install Shield and BizTalk Server 2000
Technologies: ASP, XSLT, IIS, ADO, ASP.NET, VB.NET, WPF, WCF and J2EE
Operating Systems: Windows 95/98/2000/03/08/XP, Win NT 4.0/2003, UNIX
Tools: Red Gate, Rational Robot, Star Team 4.0, VB 6.0, IBM WSAD 5.0, Toad, SVN, MS Visio, MS VISUAL STUDIO, MS Project, SSRS and Micro Strategy.
Databases: SQL Server 7.0/2000/2005/2008 R2, Oracle 8.x/9.x/10g, and IBM DB2
ETL Tool: Informatica 5.1, Oracle Apps, SSIS.