SUMMARY:

• 10+ years of experience in the analysis, design, development, implementation, testing, and maintenance of application systems in the Client Server application environments, worked as a SQL Server Developer.
• Experience in using SSIS tools like Import and Export Wizard, Package deployment in SQL Server.
• Skilled in Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Integration Services (SSIS) 2005, 2008 R2 & 2012.
• Experience in developing of custom WCF web services, dialog based workflows, plug - ins and integrating custom web pages into CRM.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Handled Team size of 4 to 5 members in development project.
• Data Migration done from MS Access to SQL Server database and SQL Server 2000 to 2005.
• Five years of PERL script writing in multiple development projects.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, drill through, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Report Model and Sub Reports
• Implemented project activities for HL7 interfaces and data extracts.
• Expertise in writing T-SQL Queries, CTE, sub-queries and complex joins for generating Stored Procedures, User-defined Functions, Views and Cursors.
• Maintaining timesheet one in a week for all team members. Regularly updating status worksheet on daily basis with reference to the task assigned to each associate.
• Has very strong background experience in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands
• Experience in loading different format of files into SQL database using BCP/Bulk Insert commands.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Excellent verbal/written communication skills and having the ability to work in a fast paced environment. Good team player and can work independently. Helped the database developers on technical issues.
• Migrated data from SQL Server 2000 to 2005 and 2008 to 2012.
• Experience in creating jobs, Alerts, SQL Mail Agent, Database Mails and Scheduled DTS and SSIS Packages.
• Worked as SQL DBA. I am Proficient in prioritizing and completing projects and assigned tasks to time, budget, schedule, yet flexible to multitask when necessary.
• SQL Server 2012 configuration and cluster installation.
• Having Experience in Retail, Banking, Insurance and Pharmaceutical domain.

TECHNICAL SKILLS:

Database: MS SQL-Server 2000 / 2005 / 2008 /2012 / 2014, MS Access 2000/ 2007, Sybase 12.5, Application DBA activities.

ETL Tools: SSIS

Reporting Tool: SSRS and Segate Crystal Reports 11.0

Analysis Services: SSAS, MDX and DAX queries.

Programming Languages: SQL, T-SQL, VB, VB.NET, C#.NET, Excel / VBA

Web Technologies: HTML, JavaScript, XML

Version control tool: VSS, MKS Integrity, VTFS

Office Tools: MS Access, MS Excel, MS Word

Operating System: Windows NT/ 2000/9x/XP/7/Vista/8; UNIX

PROFESSIONAL EXPERIENCE:

Confidential,NJ

SQL Server Developer

• Attending Daily stand up call with team and reporting about the work status to development project leader every day.
• IES Project: Writing stored procedures, queries and views to support Client Server application reports.
• Working with Team Leader and Team members for the new work items assigned to me in TFS.
• Fixing the Helpdesk tickets coming from end clients and end users.
• Reporting to director about the work status every Monday with updated timesheet.
• Working with Team for delivering the project IES version 3.0 release.
• Working with Team MF Billing Support project. Writing configuration files based on the requirement given by business analyst.
• Monitoring Daily Batch files posting from local server into FTP for MedFlow Billing project

Confidential, Boston, MA

SQL Developer

• Creating stored procedures in SQL Server, to apply business rules and load into destination tables and sending email notifications.
• Understanding the requirements by working with SME. Analyzing department applications, evaluating existing systems and designing proposed systems.
• Done Unit Testing of the developed code in DEV environment.
• Created Design documentation for better understanding of technical flow of the s/w program.
• Done Performance tuning and Code review in Dev, QA environments.
• Creating SSIS packages and deploying them into SQL Server environment 2014.
• Data migration done from 2008 into 2014 in different environments like DEV, QA.
• Worked in different phases of SDLC of this development project.
• Written complex T-SQL queries in Query Window for extracting data from tables
• Deployed developed code in QA and UAT environments for testing purpose.
• Maintenance of Clarification documents from customer in share drive.
• Maintained of different versions of software code in TFS.
• Loading data from 25 different clients and applying the business rules into the loaded data.
• Creating JIRA tickets to update the status on regular development works.
• Worked on MYSQL coding for data loading into database tables.

Technical Environment: SQL Server 2014/ SSIS - MS Visual Studio 2012/ JIRA / TFS

Confidential, Charleston, WV

• Written stored procedures, to apply business rules and load into destination tables and sending email notifications.
• Worked closely with Client side SME for understanding the requirements and get the clarifications done.
• Maintained different versions of software code in TFS.
• Created SSIS packages, SSRS reports in DEV and done Unit testing for the different possible test cases. Tested the packages and reports in QA environment. Worked on SSDT Data Tool 2012.
• Working on day to day production issues and alerts and maintenance activities.
• Daily status update to project manager regarding deliverables and status on day to day development items.
• Written complex T-SQL queries in SQL Server query window.
• Maintaining the documentation about, design document, unit test case document in share drive.
• Connected with status calls on regular basis to update the status of deliverables to Project Manager.

Technical Environment: SQL Server 2014 / SSIS / SSRS - MS Visual Studio 2012/ TFS

Confidential, KY

Developer / Lead

• Setup DBA Maintenance Database and Maintenance Plan for Backup, Database Integrity & Index Maintenance.
• Creating SSIS packages and executing stored procedures, to load the files into destination tables and sending email notifications. Worked on SSDT Data Tool 2012.
• Implemented project activities for HL7 interfaces and data extracts.
• Creating SSRS reports and deploying them into SQL Server to generate real-time reports as per requirement.
• Manage a team of database developers to support the Business Intelligence and data services needs of the enterprise.
• Data Migration done from SQL Server database and SQL Server 2008 to 2012.
• Created Store Procedures, Functions for retrieval and update of data in the database.
• Working on day to day production issues and alerts and maintenance activities
• Maintaining project related documents in TFS, Checkout the latest versions and performing the relevant changes into the latest version, and finally checking in the modified version of code into TFS.
• Identifies database requirements by working with SME’s, application architects and development team; analyzing department applications, evaluating existing systems and designing proposed systems.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Made changes in Front end GUI application level programming changes. Added combo box, new item in the list.
• Worked on SSIS Architecture design, SSIS transformations. Whole responsibility for all the deliverables.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Worked on Database design documentations, mapping the fields between the tables.
• Worked on SQL Server Database design and written queries for Data Cleansing.
• Maintenance of scheduled SQL jobs. Performance tuning & code review.

Technical Environment: MS SQL Server 2008/2012/2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) TFS 2012, Visual Studio 2013, ASP.Net, C#, .net. Data warehouse.

Confidential,IL

Developer / Lead

• Lead team on Business Intelligence
• Interacting with the Business users for getting the necessary requirements and inputs.
• Generated SSRS reports using MS Visual Studio 2013 into CSV and pdf files.
• Working closely with offshore team to track the regular work assigned to each associate. Attending regular offshore standup calls and meeting with clients to update the status about each task.
• Migrated data from SQL Server 2008 to 2012.
• Maintaining timesheet once in a week for all team members. Regularly updating status worksheet on daily basis with reference to the task assigned to each associate.
• Creating SSIS packages and executing stored procedures, to load the files into destination tables and sending email notifications.
• Extracted data from different flat files, MS Excel, MS Access and transformed the data based on user requirement and loaded data into target database, by scheduling the jobs
• Written complex T-SQL queries in Teradata Server
• Prepared test cases and executed for different scenarios to test the code in Teradata in UAT and DEV environments.
• Creating reports using SQL SSRS 2008.
• Written MDX and DAX queries in DW environment.

Technical Environment: MS SQL Server 2008/2012/2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) TFS 2012, Visual Studio 2013

Confidential

SQL Server/ BI Developer / Leader

• Understanding the requirement from different specification documents and maintaining track of clarifications from customers.
• Creating SSIS packages for executing stored procedures, to load the files into destination tables.
• Deployed SSIS packages in to SQL Server and executed the same packages on scheduled basis.
• Created Power View Reports using the Tabular SSAS models in Excel 2010 and 2012.
• Developed, created and managed complex stored procedures and UDF in SQL Server 2008
• Maintaining timesheet one in a week for all team members. Regularly updating status worksheet on daily basis with reference to the task assigned to each associate.
• Migrated data from SQL Server 2008 to 2012.
• Prepared ETL design document which consists of the database structure, change data capture, Error handling, restart and refresh strategies
• Designed and developed the web interfaces and web services for an enterprise system.
• Analyzed trends in latest technologies and methodologies of web development and design.
• Written MDX and DAX queries in DW environment.
• Written complex T-SQL queries in Teradata Server
• PERL script writing on development projects.
• Implemented Tableau mobile dashboards via Tableau mobile application.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Technical Environment: MS SQL Server 2008/2008 R2, SQL Server Integration Services (SSIS).

Confidential

SQL/ SSIS Developer

• Design and develop Integration Services solution in MS Business Intelligence Development Studio.
• Develop custom T-SQL stored procedures to perform ETL operations.
• Created Visual Basic macro Application for maintaining the attendance of employees in the project module. Attendance is calculated based on the working hours each one spent in project.
• UNIX script writing and PERL script writing for data loading.

Technical Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services 2008

Confidential

VB/ VBA / SQL Developer

• Application Developer. Handled all Visual Basic6.0 and Visual Basic applications extracting report from backend using automations (Excel Macros)
• HKCOA is the application delivered successfully which will allow operations to do the change of address and account details of customer.
• Data Migration done from MS Access to SQL Server database.
• Modified existing code changes in VB script editor and deployed the Dll’s in Dev and QA environments to make the changes active.
• PERL script writing on development projects.

Technical Environment: SQL Server 2008 R2, MS Visual Basic 6.0, Microsoft Office 2003-07, VB Dot Net

Confidential

SQL Server/SSIS/SSRS Developer

• Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Generated various reports Tabular reports, Sub Reports.
• Maintaining latest Delivered objects using VSS.

Technical Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services 2005(SSRS).

Confidential

MS SQL Server / VBA Developer

• Wrote T-SQL queries, Store Procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
• Using Dynamic Management Views to finding out long running queries.
• Backup and Recovery plans for Field office and Headquarters database servers

Technical Environment: Windows XP, Microsoft SQL Server 2000, VB.NET 2.0, MS SQL Integrated Services