SUMMARY

• Around 7 years of experience in SQL and SQL - BI suite comprising of SSIS/SSAS/SSRS along with professional database design, development and maintenance of SQL SERVER.
• Proficient in using SQL SERVER and T-SQL and in creating Store procedures, Triggers, tables, User defined Functions, Views, SQL joins and performance based query writing.
• Experienced in writing complex stored procedures using dynamic SQL.
• Hands on experience with proactively monitoring the entire instances and databases for any abnormalities.
• Involved in maintaining the coding standards while implementing complex stored procedures and views.
• Experienced in standardizing processes including creating documentations for building packages to be scheduled as job and executed every day in production, migrations, upgrades, backups, restores, index maintenance, etc.
• Thorough understanding and experience in data warehouse and data mart design, star schema, snow flake schema concepts and principles.
• Good knowledge in normalizing and de-normalizing tables to maintain referential integrity by using primary and foreign keys.
• Experience in SQL query optimization techniques, debugging SQL commands
• Expert in database management techniques including backup/restore, import/export and script generation. Hands on experience working with import and export data (Dev. to QA, QA to prod.)
• Installed and configured SQL Server.
• Can work efficiently in a team and lead the team to meet the project deadlines by designing work to all team members appropriately.
• Proven ability in utilizing ETL Tools including SQL Server Integration Services (SSIS) to load data into Data warehouse from heterogeneous databases like flat files, excel, SQL server.
• Played a keen role as a member of a team in scrum meetings held every other day with team’s manager and team lead.
• Expert in creating and scheduling complex SSIS packages for transferring data from multiple sources into SQL Server, Access and Excel by using SSIS and DTS utility of SQL Server
• Proficient in creating and designing report layout, SQL Server Reporting Services (SSRS)
• Experienced in generating various reports like drill down, drill through, Sub reports, and Parameterized reports using SSRS and integrated and deployed them.

TECHNICAL SKILLS

• SQL Server 2005,2008, 2008 r2,2010,2012, 2014.
• MS SQL Server Integration Services (SSIS)
• MS SQL Server Reporting Services (SSRS)
• T-SQL
• Microsoft Visual Studio 2010,2008,2005
• Microsoft Access
• Microsoft Office (MS Word/Excel/Power Point)
• HTML
• Windows Operating System 95/98/2000/XP/7/8.1
• Microsoft Visual Source Safe
• Team foundation Server (TFS)

PROFESSIONAL EXPERIENCE

Confidential

MS SQL Server\SSIS Developer

Responsibilities:

• Solved business requirements using any technology available in the Microsoft BI stack of products including; SSIS, SQL Server Management Studio, Visual Studio, Team Foundation Server for code storage and migration
• Involved in writing different SQL queries which includes joins, Temp. Tables, SQL in built functions, expressions, variables, parameters etc.
• Used appropriately different SQL clauses like Group by, where, having, order by etc. in building queries in Sql Server Management Studio.
• Created different stored procedures according to the requirements to be used in building a new application.
• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Managed multiple SQL server
• Analyzed the production data for the failing jobs by exporting production data in development server and carrying out the relevant steps to fix the issue.
• Developed various SSIS packages using Microsoft Visual Studio 2005, 2010 and SQL Server Data Tools for Visual Studio 2013.
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Strictly adhered to data security policies and procedures.
• Used Microsoft Visual SourceSafe while developing ETL packages.
• According to the new requirement modified various stored procedures and packages running in production by carrying out appropriate data analysis and understanding the data in the database.
• Switched to various versions while creating packages using Team Foundation Server. Executed the packages in development server after deployment and then migrated to different environments respectively.
• Troubleshoot and Monitor Company databases on daily basis in Production.
• Developed and deployed SSIS end to end Packages to the Production environment.
• Repeatedly developed and ran SQL scripts to maintain data and software integrity.
• Proper understanding of use of project parameters, SSIS variables, Event handlers, various Control flow tasks, Data flow Components, Connection Managers in building SSIS packages.

Confidential, Middletown, NJ

MS SQL Server\SSRS Developer

Responsibilities:

• Generated database objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints by using T-SQL environment.
• Implemented complicated transactions for the existing tables.
• Used common table Expressions for better performance in executing commands.
• Implemented error handling mechanism and logged for all procedures.
• Created views for extracting a specific set of data in different procedures
• Generated data base diagrams for schema representation.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS-SQL Profiler.
• Implemented database management techniques that include backup/restore, import/export and generated scripts.
• Created and updated Reports to meet the requirements and changes specified by the users.
• Demonstrated strong technical skills with hands on planning, implementing and Supporting of new technologies.
• Created batch file to improve the performance of SSIS package to load data in database.
• Involved in solving the Bugs reflected by the testing team.
• Carried out performance testing on stored procedures, indexes and triggers.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Worked with Tabular reports, Chart reports, Parameterized reports, Sub-reports, Drill down reports and Drill through reports according to business requirements in time restricted environment using SQL server reporting services (SSRS) 2012.
• Worked closely with QA teams to ensure documentation, testing and proper implementation in production environment of all code changes, reports, and objects
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Developed various Charts (Pie Charts) and Graphs like Bar Chart (Side by Side, Stacked) using SSRS.

Confidential, Charlotte, NC

SQL Server/SSRS Developer

Responsibilities:

• Involved in Installing SQL Server 2012
• Carried out the back up recovery process on a regular scale and regular up gradation to RDBMS
• Maintained, tuned and trouble shoot the existing systems.
• Interacted with other technical team members to establish requirements.
• Oversee and lead a technical team. Assigned resources to projects and ensured Project deliverables and timelines are met. Responsible for day to day activities.
• Created tables, indexes and constraints.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Developed stored procedures to retrieve customer information from as required evaluating eligibility for loan requests, account status, etc.
• Involved in writing SQL statements which includes joins and functions.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases involving index creation, index removal and index modifications in tables of databases.
• Performed data analysis using SQL and Excel
• Strictly adhered to data security policies and procedures.
• Implemented complicated transactions for the existing tables.
• Implemented database management techniques that include backup/restore, import/export and generated scripts.
• Wrote store procedures to generate account statements for different types of accounts.
• Monitored performance and optimized SQL queries and indexes for maximum efficiency.
• Created and modified a number of existing stored procedures based on the changes made to some existing tables.
• Designed and deployed reports with Drill Down, Drill through, Drop Down and Parameterized reports.