SUMMARY

• Overall 10+ years of experience in IT and out of which 6 years of experience in MS SQL Server development, analysis, design, testing and implementation of applications, reports and databases (MS SQL Servers 2012, 2008 R2/2005/2000) in production environments.
• Extensive experience developing and implementing Microsoft SQL Server Integration Services (SSIS), SSRS (Reporting Services), SSAS (Analysis Services).
• Extensive experience in Migration of SQL 2000 DTS packages, SQL Logins, SQL Jobs & DB Objects to SQL 2005.
• Experienced in developing T - SQL complex queries, Stored Procedures, Functions, Triggers, Views, Synonyms, SSIS Packages and SQL Server Reports (SSRS).
• Experience in Migration, Extracting, Transforming and loading of data using SQL Server SSIS from Excel, DB2, Sybase, Flat file, Netezza & Oracle.
• Possesses extensive experience using Microsoft SQL Server Reporting Service (SSRS) with report authoring, report management, report delivery and report security.
• Experience in Designing, Compiling, Testing, and Scheduling and Running SSIS packages.
• Extensive experience in Extraction, Transformation, Loading and cleansing of data from multiple sources into Data warehouse using SSIS.
• Experienced in Business Data analysis, Design, Modeling and Implementation on major RDBMS (SQL Server ). Worked extensively with T-SQL Stored Procedures, Triggers and Indexes.
• Extensive experience through all the phases of Full life cycle Development including requirements gathering, technical specifications, Analysis, Design, Implementation, Testing, and operations of large-scale enterprise wide applications.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Experience in Performance Tuning of SQL Queries and stored procedures.
• Experience with design and implementation of Star Schema and Snowflake Schema Dimensional model.
• Experience in Application Development, Data Modeling, Data Cleansing, Data Conversion and Interface.
• Having good knowledge of entire phase of Software Development Life Cycle SDLC .
• Strong in Writing User Manuals, Documentation, Proposals and in preparing Technical Specifications for the projects/Products.
• Excellent communication skills, both oral and written and pleasing interpersonal skills.

TECHNICAL SKILLS

Database: MS SQL Server 2000/2005/2008 R2/2012, Oracle 10g/9i/8i & MS-Access.

Data Modeling: Star/Snow-Flake Modeling, Physical & Logical Data Modeling using Erwin/Visio

Reporting Tools: MS Reporting Services (SSRS), Crystal Reports XI/10/9.0/8.5, BO XIR2/6.X.

ETL: DTS/SSIS, Informatica 7.1.

Web: VB Script, Java Script, HTML & DHTML.

Languages: T-SQL, C, C++, C#.Net & VB.Net.

Tools: TOAD 6.5, SQL Navigator 4.1, Oracle SQL Developer, Idera & Red-Gate

Operating System: Windows Server 2003/2005, Win XP/NT, Unix.

Others: MS-Office, SSCM & Team Foundation Server etc.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore

Sr BI Developer

Responsibilities:

• Working with the Business Intelligence Team as a Sr. SQL Server Developer with Laureate.
• Working on building a financial application based on Star Topology in SQL Server & SSIS.
• Develop & Design ETL loads as per the requirement in SSIS for data warehouse.
• Develop SQL Code (Procedures / Functions / Queries) to process the data.
• Worked on different Upgrade Projects to change the existing code and ETL Packages.
• Worked on Updating Configurations and SQL Jobs for the upgrades.
• Worked on analyzing the code throughout the SQL Server and making changes as needed for upgrade projects.
• Assisted QA’s to test the functionality implemented in the code.
• Create Releases for the SQL Code and ETL Packages for the QA & Prod in SSCM.
• Prepared Technical Documents for the processes followed and implemented.
• Worked with Business Teams to understand requirements to implement.

Environment: MS SQL Server 2008/2012, MS SQL Server BIDS (SSIS, SSRS & SSAS), Oracle SQL Developer, SSCM, (C#.Net, VB.Net, ASP.Net), MS-Office Suite 2010, Share Point, Cognos, Tableau, Red-Gate, Windows 2003 Server.

Confidential, MD

Sr. SQL Server / BI Developer

Responsibilities:

• Working in the Rebuild Development Team as a Sr. SQL Server Developer with Merkle.
• Worked on Migrating code from IBM Netezza to SQL Server 2012, Stored Procedures & Functions.
• Worked on Optimizing new SQL 2012 code converted from IBM Netezza by adding Keys & Indexes.
• Worked on the Migration of DTS packages from SQL 2000 to SSIS 2012. Also working on creating new packages for ETL in SQL 2012.
• Trouble-shooting SSIS packages and worked on optimizing them for better performance.
• Deployed Packages to SQL 2012 to run in different environments Dev, QA & Prod using the new 2012 functionality.
• Updated ActiveX scripts and VB Scripts written in DTS 2000 to SSIS 2012.
• Created Utility packages for File operations, which encapsulates particular logic for different clients to handle the files residing in the file system.
• Created procedures in IBM Netezza for Reporting purpose.
• Assisted QA's in testing with the code developed.
• Participated in Scrum, daily stand-up meetings and give demo on new functionality developed in SSIS 2012 packages.
• Managed Code and burned down tasks in SVN on daily basis.
• Prepared Technical Documents for the processes implemented.

Environment: MS SQL Server 2000/2012, MS SQL Server BIDS (SSIS, SSRS), Netezza, DTS-XChange, MS Visual Studio 2008/2010 (C#.Net, VB.Net, ASP.Net), SVN, MS-Office Suite 2010, Share Point, Erwin, Red-Gate, Windows 2008 R2 Server.

Confidential, MD

Sr. SQL Server / BI Developer

Responsibilities:

• Working as part of Development Team in one of the main product of Confidential .
• Written complex T-SQL queries, stored procedures and additional application functionality. Optimized the performance of queries with modification in SQL queries, eliminated redundant and inconsistent code, established joins and created indexes wherever necessary.
• Developed stored procedures and integrated them to the front end application.
• Worked on stored procedures to fine tune the performance.
• Optimized SQL Queries & Indexes for better performance.
• Written configuration Scripts for the backend processes to integrate them to the Front End.
• Created reports using SQL Server 2008 (SSRS) and integrated them to the Web Front End.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats using SQL Server Reporting Services SSRS.
• Implemented mechanisms to get the proper Error Messages in case SSRS Reports fail to run.
• Trouble-shooting SSRS Reports and optimized them for better performance.
• Deployed Reports to the Dev / QA / Prod environments.
• Developed SSIS Packages to archive data which runs dynamically on multiple servers based on the configuration.
• Developed SSIS Package to Load data from production servers to QA & Dev environment.
• Trouble-shooting SSIS Packages in case of failure.
• Worked on testing code developed by other developers in the team.
• Assisted QA’s to test the functionality implemented in the code.
• Managed Code and Burned down tasks in TFS on daily basis for the monthly sprints.
• Participated in Scrum, Grooming, Retrospective and Daily stand-up Meetings for the Development.
• Prepared Technical Documents for the processes followed and implemented.
• Worked with Business & Operation Teams to understand requirements to implement.

Environment: MS SQL Server 2005/2008 R2, MS SQL Server BIDS (SSIS, SSRS & SSAS), MS Visual Studio 2005/2008 (C#.Net, VB.Net, ASP.Net), Team Foundation Server 2008/2010/2012 , MS-Office Suite 2010, Share Point, Erwin, Red-Gate, Windows 2003 Server.

Confidential, MD

SQL Server / BI Developer

Responsibilities:

• Worked in Production Support on 24x7 bases for supporting different applications in the production environment.
• Developed SSIS Packages for tracking issues in our environment, which generates reports for the issues reported on monthly and weekly basis.
• Developed SSIS Packages for loading and processing data on the processing servers and load it back to the customer server.
• Optimized SSIS Packages for better performance for the analytical server.
• Wrote the ETL scripts to load the data into database from source files. Experienced in error handling and troubleshooting the scripts in failure to load.
• Worked on several issues in the production department and fixed them in the allotted time.
• Worked on Performance Tuning of the Stored Procedures, Indexes and SQL Queries.
• Worked on Trouble-shooting for the ETL loads for daily, weekly & monthly data loads.
• Created database objects like stored procedures, triggers, views and functions using T-SQL for various needs and requirements.
• Worked in DB Monitoring to check the health of the Production Servers and for other issues like Deadlocks, Blocking, IO Bottlenecks, Memory Bottlenecks, Slow running queries etc.
• Setting up strategic plan for database monitoring of the system for various database using tools like SQL Profiler and Perfmon.
• Troubleshooting & Monitoring SQL Agent jobs in the production.
• Configuring Performance Counters related to I/O, Memory & CPU for troubleshooting.
• Used SSRS to create ad-hoc reports and involved in analyzing reports in SSRS.
• Responsible for sending weekly status reports for our team to the manager.
• Involved in the DB Team Meetings for the Production Environment.
• Worked in analyzing data for different trends in the business.
• Prepared Technical Documents for the utilities built for our team.

Environment: MS SQL Server 2005/2008 R2, MS SQL Server BIDS (SSIS, SSRS & SSAS), MS Visual Studio 2005/2008 (C#.Net, VB.Net, ASP.Net), Informatica 8, MS-Office Suite 2010, Share Point, Erwin, Windows 2003 Server.

Confidential, MD

SQL Server / BI Developer

Responsibilities:

• Involved in requirement gathering for the business requirements.
• Prepared Technical Documents for the Developed applications.
• Reverse Engineered and migrated an application from Rhapsody to SQL Server SSIS, which gets data from SQL Server database and sends it in particular format to the client. Used CozyRoc Components (SFTP / Unzip / Script++) to send data on Secured FTP.
• Wrote complex T-SQL queries, stored procedures and triggers to build specific logics as well checking constraints, referential integrity, and provide additional application functionality. Optimized the performance of queries with modification in T-SQL queries, eliminated redundant and inconsistent data, established joins and created indexes wherever necessary.
• Developed an ETL Application in SSIS, which has 50 packages in it and it has features like Notifications, Error Handling & Recording of Bad Rows and various File System Tasks.
• Automated SSIS Packages with the help of SQL Jobs to run on scheduled time.
• Experience in designing, testing, scheduling and running ETL processes in SSIS.
• Used MS-Visio for Data-Modeling to design dimension & fact tables for the data warehouse.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS).
• Created Reports using SSRS 2008 for the Business, which uses Data Driven Subscription to send Fax & Emails to the clients for notifications.
• Created, scheduled & deployed reports in SSRS like Master Reports, Parameterized Reports & Drill-Down Reports using SQL Server Reporting Services SSRS.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Used Idera for monitoring multiple Servers.
• Used Red-Gate for taking back-ups & for comparing different versions of databases on multiple servers.
• Created, trouble-shooted & Scheduled SQL Jobs for various activities on the servers.
• Performance: Fixed issues on receiving Notifications from Idera for Index Fragmentation, Disk Space or CPU Utilization for the different servers.
• Involved in the Team Discussions for Development, Maintenance & Performance Tuning of the Database.
• Provided On Call 24x7 Support on rotations for the DB Support Team.

Environment: MS SQL Server 2000/2005/2008 R2 (SSIS/SSRS/SSAS), MS SQL Server BIDS, MS Visual Studio 2005/2008 (C#.Net, VB.Net, ASP.Net), MS-Visio, Team Foundation Server, Idera, Red-Gate, MS-Office Suite 2010, Query Builder, Share Point, Java, Windows XP.

Confidential, NJ

SQL Server / BI Developer

Responsibilities:

• Involved in Requirement gathering from the users according to the business requirements.
• Prepared Detailed Design Documents from the Functional Specifications.
• Created, Configured & Migrated Database, DTS-Packages, SQL-Logins & SQL-Jobs from SQL 2000 to SSIS SQL 2005.
• Have written & updated T-SQL Stored Procedures according to the business requirement & automated them with SQL Jobs.
• Written complex statements using joins, sub queries and correlated sub queries.
• Developed Database Triggers to enforce Data integrity and for Auditing purpose.
• Developed Packages in SSIS for extracting, transforming, cleansing and loading data to targets.
• Designed and Maintained SSIS Packages for Importing Data from Oracle to SQL Server.
• Experience in designing, testing, scheduling and running ETL processes in SSIS & Informatica.
• Running Workflows & editing Mappings in Informatica for loading data.
• Responsible for transferring the data using SSIS packages for monthly releases.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Created reports using SQL Server 2005 (SSRS) and integrated into the web front end.
• Created on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Wrote complex T-SQL stored procedures, Functions and Triggers to carry out various tasks.
• Created Linked Servers & Database connection to access data from Oracle & Sybase.
• Created SQL Logins as per the requirement for Database access.
• Granting or Revoking Database Access Permissions for Logins as per the requirement.
• Created, trouble-shoot & Scheduled SQL Jobs for various activities in the server.

Environment: MS SQL Server 2000/2005/2008 (SSIS/SSRS/SSAS), MS SQL Server BIDS, MS Visual Studio 2005 (C#.Net, VB.Net, ASP.Net), Oracle 10g, Informatica, MS-Office Suite, XML, Query Builder, Micro-Strategy, Java, Windows XP, Windows 2003 Server.

Confidential, NV

SQL Server / BI Developer

Responsibilities:

• Involved as a key team member for Requirement gathering from the users according to the business requirements during the design phase and interaction with the client.
• Extensively involved in preparing Detailed Technical Documents from the Functional Specifications.
• Running the T-SQL Scripts against Databases on the QA Servers or Staging Servers.
• Wrote complex T-SQL stored procedures, Functions and Triggers to carry out various tasks.
• Installation of Microsoft SQL Server 2000 and 2005 on New Production and test servers with Security updates.
• Identified the Data Sources and defined them to build the Data Source Views. Developed Query for generating drill down reports in SSRS.
• Identified and worked with parameters for parameterized reports.
• Used Report Manager to subscribe, maintain & set security permissions to the reports in SSRS.
• Used Microsoft BIDS to create Matrix Reports, Parameterized Reports, Drill-Down Reports & Ad-hoc Reports and involved in analyzing multi-dimensional reports in SSRS.
• Published SSRS reports in PDF, Excel, and CSV formats.
• Developed Packages in SSIS for extracting, transforming, integrating, cleansing and loading data to targets.
• Responsible for loading the data using SSIS packages to Fact & Dimension tables.
• Written complex statements using joins, sub queries and correlated sub queries.
• Have done On Call Support for the Production Environment if there are any Database issues.

Environment: MS SQL Server 2000/2005 (SSRS/SSIS/SSAS), MS SQL Server BIDS, MS Visual Studio 2005 (C#.Net, V.Net, ASP.Net), Microsoft Office Suite, XML, Query Builder, Crystal Reports XI, Java, Windows XP, Windows 2003 Server.

Confidential

Programmer

Responsibilities:

• Involved in the Requirement gathering from the users for the designing and development of the system at the client side.
• Involved in the designing & creation of the database in Oracle.
• Write stored procedures and triggers for the database.
• Extensively involved in the designing of VB Forms and writing code for the same.
• Developed a Tracking Information Module for tracking jobs in the production, jobs received and jobs sent back after completion.
• Developed ActiveX components for the system.
• Extensively involved in the testing & debugging of the application.
• Installed the application on client side and trained users to use the application.
• Involved in maintaining various modules of Data processing applications, billing system and designing forms for customized data Keying features.

Environment: VB 6.0, Oracle9i, MS Office Suite, Crystal Reports, Windows Server 2000.

Confidential

Programmer/Analyst

Responsibilities:

• Requirement analysis, designing and Development of prototype system.
• Prepared questionnaires for collecting the information about the implementations of signaling system at various places and their requirements.
• During the time of Analysis personally visited various sites for study and analysis of the domain specific issues and acquired sufficient knowledge.
• Prepared design documents, schedules and prototype system.
• Developed Component objects for the Lay out Editor for recreating the domino panel layouts using ActiveX controls.
• Developed COM components for fault logics used in Lay out Editor.
• Developed a mimic generator in VB6, which generates online and offline mimic of the train movements. This aims at interpreting the raw data of events from database using ADO.
• Active participant in the Installation, commissioning and Support teams for the initial few systems for on-site testing of fault logics.
• Conducted Orientation course for the customers which are quite new to the usage of computers.
• Prepared various technical documents, following the ISO standards also key member in User’s manual preparation team.
• Participated in customer feedback programs and version up-gradation.

Environment: VB 6.0, VBScript, Crystal Report, Java & Oracle8i.