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 teh entire instances and databases for any abnormalities.
• Involved in maintaining teh 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 teh team to meet teh 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, Brooklyn, NY,

Responsibilities

• Solved business requirements using any technology available in teh 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 teh 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 teh production data for teh failing jobs by exporting production data in development server and carrying out teh relevant steps to fix teh 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 teh 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 teh new requirement modified various stored procedures and packages running in production by carrying out appropriate data analysis and understanding teh data in teh database.
• Switched to various versions while creating packages using Team Foundation Server. Executed teh packages in development server after deployment and tan migrated to different environments respectively.
• Troubleshoot and Monitor Company databases on daily basis in Production.
• Developed and deployed SSIS end to end Packages to teh 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

Responsibilities

• Generated database objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints by using T-SQL environment.
• Implemented complicated transactions for teh 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 teh functionalities/deliverables in
• 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 teh requirements and changes specified by teh users.
• Demonstrated strong technical skills with hands on planning, implementing and
• Created batch file to improve teh performance of SSIS package to load data in database.
• Involved in solving teh Bugs reflected by teh testing team.
• Carried out performance testing on stored procedures, indexes and triggers.
• Optimized teh 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 ( Confidential Charts) and Graphs like Bar Chart (Side by Side, Stacked) using SSRS.

Confidential, Charlotte, NC

Responsibilities

• Involved in Installing SQL Server 2012
• Carried out teh back up recovery process on a regular scale and regular up gradation to RDBMS
• Maintained, tuned and trouble shoot teh existing systems.
• Interacted with other technical team members to establish requirements.
• Oversee and lead a technical team. Assigned resources to projects and ensured
• Created tables, indexes and constraints.
• Developed stored procedures and triggers to facilitate consistent data entry into teh 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 teh 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 teh changes made to some existing tables.
• Designed and deployed reports with Drill Down, Drill through, Drop Down and Parameterized reports.

Confidential, Wilmington, DE

Responsibilities

• Created tables, indexes and constraints.
• Performed periodical data comparison between different database environment to ensure deployment consistency and system stability.
• Designed and implemented stored procedures and triggers for automating tasks.
• Developed flowcharts for complex stored procedures.
• Automated and enhanced daily administrative tasks including database backup and
• Loaded data from various sources such as flat files to SQL Server database using SSIS package.
• Trace teh frequently called procedures/packages and pinning them to improve teh performance.
• Generated data base diagrams for schema representation.
• Implemented database management techniques that include backup/restore, import/export and generated scripts.
• Review team members code changes for logic, business rules and development standards
• Used SSIS to build high performance data integration solutions, including extraction, transformation and load (ETL) packages and also scheduled teh SSIS packages and jobs.
• Created SSIS packages to migrate slowly changing dimensions.
• Involved in improving teh performance of teh system by implementing indexes.
• Developed and executed several optimized queries in SQL.
• Developed tables, views, triggers and stored procedures using T-SQL.
• Pulled data from flat files, excel, and Access using SSIS package.
• Imported teh various files provided by teh clients into teh relational database systems.

Confidential, Warren, NJ

Responsibilities

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Involved in performance tuning of existing database objects such as stored procedures and complex stored procedures.
• Responsible for troubleshooting and problem solving of SQL development and creating back up plans.
• Work with teh QA team to ensure proper testing of all changes.
• Involved in writing SQL statements which includes joins and functions.
• Converted various SQL statements into Stored Procedures theirby reducing teh
• Optimized existing stored procedure by monitoring through Sql Profiler.
• Used common table Expressions for better performance in executing commands.
• Worked with SQL in-built functions and user defined functions which includes scalar and table valued functions.
• Implemented error handling mechanism and logged for all procedures.
• Exported or imported data from sources such as flat files using Import/Export and through SSIS
• Assist other team members with technical issues.
• Designed user defined hierarchies (parent-child hierarchies) along with attribute hierarchies.
• Involved in index tuning and query tuning to improve teh performance of teh queries.
• Normalized and de-normalized tables to maintain referential integrity by using Primary and Foreign Keys.
• Used Reporting Services to accelerate reports creation and eases collaboration and management business reporting needs.
• Supported team in resolving SQL Reporting services and T-SQL related issues.
• Proficient in creating and formatting various reports such as drill down, drill through, sub reports and parameterized reports.

Confidential,

Responsibilities

• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Maintained various databases on development environment 2005.
• Utilized SQL Server Management Studio to prepare both logical and physical aspects of new
• Wrote documentation for teh packages and scripts and job created.
• Wrote stored procedures, checking teh code for efficiency.
• Defined report layouts including parameters and wrote queries for drill down reports using SSRS 2005.
• Performed data transfers between various servers using BCP.
• Generated ad-hoc reports, Sub reports, and tabular reports using SSRS.
• Going through teh clients requirements and coming up with database design and application architecture.
• Administered, maintained, developed and recommended policies and procedures for ensuring teh security and integrity of teh company’s databases and systems.
• Designed implemented and maintained database Schema, Entity Relationship diagram, Data Modeling, Tables, User Defined Functions and Triggers, Constraints and complex SQL statements.
• Perform backup and restores on company data bases
• Facilitated consistent data entry into appropriate databases of teh bank.
• Created indexes and constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into teh database.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Designed SSRS reports and deployed to Report Server. Managed subscription of reports
• Created views to restrict access to data in a table for security.