SUMMARY

• Over 14 years of IT experience in Design, Analysis, Development, Modeling, Implementation
• Over 6 years of SQL Development and lead Testing of Decision Support Systems using MSBI SQL Server 2000, 2005, 2008 and 2012.
• Expertise in working with various industry verticals like Finance, Health Care, Insurance and Retail.
• Experienced in Creating, Configuring and Fine - tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2008 and MS SQL Server 2005 respectively.
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.
• Experienced in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.
• Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2005/2008 (SSRS).
• Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008/2005.
• Experienced in Developing and Extending MS SQL Server Analysis Services 2008 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects.
• Adept in defining referenced relationships and calculated members in SSAS.
• Strong experience in Stored Procedure, Formulated Stored Procedure/TSQL coding, Performance Tuning and Query Optimization.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.
• Expert in using tools such as Bulk Copy (BCP) and Data Transformation Services (DTS).
• Extensive knowledge in developing and implementing Disaster Recovery Model, and Replication Models.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.
• Experience with entire software development lifecycle (SDLC) model. C# Application/Reporting development
• Excellent communication skills, experience with client interaction, providing technical support and knowledge transfer.
• Also expert in handling offshore and onsite resources and leading the team to achieve the project goals.
• Expert in Mainframe technologies, COBOL, DB2, IMSDB/IMSDC, JCL and VSAM technologies

TECHNICAL SKILLS

• MS SQL Server 2012/2008/2005/2000
• WinSQL
• Visual studio 2010/2008/2005/2003
• Windows Server 8/7/Vista/2003
• SSAS (MS SQL Server Analysis Services)
• SSIS (MS SQL Server Integrated Service)
• SSRS (MS SQL Report Services)
• BCP
• Crystal Reports
• ProClarity
• MDX
• MS Access
• HTML
• DHTML
• ASP
• C#
• .Net
• VBScript
• JavaScript
• FrontPage
• MS Visio
• Erwin
• Visual Source Safe
• HTML
• MS Office
• UML
• JQuery

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

MSBI SQL Server Lead

Responsibilities:

• Main role in creating database objects like tables, Store Procedure, Views and triggers.
• Modifications on Store Procedure and Crystal Reports as per client enhanced requirement.
• Analyzing the requirement and business rules to design reports.
• Modify and fine tuning existing Store Procedure and query to bring down execution time.
• Unit testing the report output on basis of business rules.
• Releasing objects to test server and production server.
• Verifying data on production and test after release on test and production server.
• Responsibility to do code review, and suggest and support programmer to optimize performance of query and store procedure.
• Scheduling jobs to set an automatic process. Supporting DBA in daily activities.
• Testing Store Procedure created by programmer in compare with defined business rules.
• Development and maintaining application in C#.
• Actively involved in discussion for design document.
• Monitoring Schedule jobs and determine in case of failure.

Environment: MS SQL Server 2005, SQL, T-SQL, PL/SQL, DTS, SSIS, and SSRS, Crystal Report, MKS, VSS, 2000/XP OS.

Confidential, Jersey City, NJ

Programmer Analyst

Responsibilities:

• Created database objects such as tables, stored procedures, triggers, constraints, indexes and views
• Tested and optimized the stored procedures and triggers to be used in production
• Performed backup and restoration, database maintenance, user security management
• Involved in creating jobs for automation, tuning database for performance, setting up automatic e-mail for notification
• Involved in analyzing and designing disaster recovery / replication strategies
• Managed Windows NT Server logins, files permissions, and Share permissions

Environment: MS SQL Server 2005, SQL, T-SQL, PL/SQL, SSIS, and SSRS, VSS, 2000/XP OS.

Confidential

Project Lead

Responsibilities:

• Project planning and management
• Developing Release Schedules for the applications
• Status Reporting to Customer
• Client Relationship Management
• Proposal writing
• Estimating efforts
• Preparing the Statement of Work orders
• Training and Mentoring of the team members
• Visual Basic 5.0, MS SQL Server 2000, COBOL and DB2, J2EE

Environment: MS SQL Server 2005, SQL, T-SQL, PL/SQL, SSIS, and SSRS, VSS, 2000/XP OS, Visual Basic 5.0, MS SQL Server 2000, COBOL and DB2, J2EE

Confidential, Irving TX

Responsibilities:

• Analyze the Technical Design Document.
• Plan and develop proposed enhancements.
• Monitor performance and functionality throughout the implementation process.
• Regression testing & System testing.
• Conducting peer review for other components.

Environment: VSCobol II, UNIX, MS SQL Server 2000, COBOL and DB2

Confidential, Seattle, WA

Developer

Responsibilities:

• Analyze the Technical Design Document.
• Plan and develop proposed enhancements.
• Monitor performance and functionality throughout the implementation process.
• Coding and Review.
• Regression testing & System testing.
• Conducting peer review for other components.
• Providing on-call support to the system and solving any production
• Problems/Abends

Environment: VSCobol II, IMSDB/DC and DB2

Confidential

Program Developer

Responsibilities:

• Analyze the Technical Design Document.
• Plan and develop proposed enhancements.
• Monitor performance and functionality throughout the implementation process.
• Coding and Review.
• Regression testing & System testing.
• Conducting peer review for other components.
• Providing on-call support to the system and solving any production issues
• Problems/Abends

Environment: OS/390, COBOL, DB2

Confidential

Programmer

Responsibilities:

• Enhancements
• Production Tickets
• Production Support
• Environment Support and Up gradation
• File Maintenance

Environment: Visual Basic 5.0, MS SQL Server 2000, COBOL and DB2

Confidential

Team member

Responsibilities:

• Coding of programs, Code walk Through, Unit testing and Integration Testing

Environment: COBOL, DB2, CICS, VSAM