SUMMARY:

• 6 years of experience in Data modeling, database design, Programming, Development and Implementation of Client - Server Applications & Database systems using MS SQL Server 2012/2008R2/2008.
• Involved in all phases of Software Development Life Cycle (SDLC), database design, RDBMS, data warehousing, data modeling concepts and software quality management.
• Involved in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Exclusively used T-SQL Programming using DDL, DML, DCL commands for various business applications.
• Good knowledge in Data Modeling, Database Design, SQL Scripting, Development and Implementation of Client-Server & Business Intelligence (SSIS, SSAS, SSRS) applications.
• Good experience in Data Extraction, Transforming and Loading (ETL) using SSIS and Upgrade DTS packages to SQL Server Integration Services (SSIS).
• Expert in creating SSRS, SSIS packages to manage SQL Server databases and SQL Server objects between instances of SQL Server.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Have a very good idea in designing complex reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Have knowledge of designing, developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports and MS Excel spreadsheets.
• Expert in generating Drilldown reports, Parameterized reports, Linked reports, Ad-Hoc reports, Sub reports and filters, charts in SSRS 2005/2008/2012.
• Proficiency in creating several types of reports such as Cross-Tab, Drill-down, Top N, OLAP and Sub reports, and formatting them using both SSRS 2005/2008.
• Troubleshoot performance issues and bottlenecks using Performance Monitor and Profiler for monitoring dead locks and long running queries and Configured database mail to send messages when jobs failed in SQL Server 2005.
• Ability to quickly adapt and learn, work in-groups as well as independently with minimum supervision.
• Excellent communication skills highly motivated and result oriented professional.

TECHNICAL SKILLS:

RDBMS: MSSQL Server 2012, 2008R2, 2008.

Database Utilities: Enterprise Manager, SQL Server Management Studio, BI Development, Visual Studio, Configuration Manager, SQL Server Profiler, SQL Query Analyzer, SQL Server Agent.

ETL andBI Tools: Data Transformation Services (DTS), SSIS, Import/ export wizard, SSRS, Crystal Reports

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook.

Management Tools:: Team Foundation Suite (TFS), Microsoft Office Communicator, Teamsity, Gitlab, JIRA, OctopusDeploy, Ignite, Mainsite.

Languages: T-SQL, PL/SQL, MS SQL, C/C++.

Architecture: Relational DBMS, Client-Server Architecture, OLAP and OLTP

Operating Systems: Windows 2008/2007/2003/2000, XP, Vista, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Team Lead (SQL/SSIS/SSRS).

Responsibilities:

• Worked in FFS (Farmers Financial Services) Project.
• Worked in Migration from MS access to SQL Server, Data gathering and importing into SQL Server.
• Identified and understood the requirements of the clients with respect to the database administration system that needed to be developed.
• Responsible for building new data sets and data structures as required to support business financial needs, and for managing the distribution, replication, and archival of data.
• Created and provided data analysis solutions using Microsoft Access.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2012.
• Built and maintained SSIS Packages to import and export the data from various data sources based on the design data models.
• Gathered the data packages to integrate date in SQL server 2012 from MS Access in SSIS.
• Worked on various tasks and transformations like Execute SQL Task, DFT, Execute Package Task, and Conditional split, Script Component, Row Count, Unpivot, Merge and Lookup while loading the data into Destination.
• Scheduled SSIS Packages as Jobs using SQL Server Agent.
• Responsible for Database and Log backups & Restoration, backup strategies and scheduling backups.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup and Recovery.
• Using SSRS delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Migrated reports from Access to SQL server 2012 in SSIS/SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Generated Sub-Reports, Drill down reports, Drill through reports, Parameterized reports using SSRS and created several types of reports like chart, tabled, matrix and linked reports and maintained accurate and complete documentation for all packages.
• Reviewed the performance tuning of the slow running queries and stored procedures.
• Wrote various Stored Procedures, T-SQL queries and used them to build packages.
• Changed the Data Capture in SQL server 2012.
• Created database objects like tables, views, stored procedures as required.
• Worked on Clustered and Non-Clustered index to improve the access of data within the database.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.

Environment: MS SQL Server 2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Excel, MS Visio, Windows 8/7, C#, VB Script., Talend, Visual studio 2010, MS Access

Confidential, Nashville, TN

SQL Developer.

Responsibilities:

• Analyzed and designed software and database solutions.
• Worked on CMSDE Audit project.
• Worked on Reconciliation of Inbound/Outbound files project. This includes 837/999 process flows with trading partners TMHP, Block vision, Tenncare, ILCP files.
• Worked on Complex Stored Procedures to load the date to Staging Tables and extract the data to text files.
• Responsible to delivering 837 files to Texas, Tennessee, Illinois without fail.
• Developed packages for Reconciliation of Outbound files project to allow any file format and to load the data in SQL Tables as Historical Tables.
• Running jobs for delegate entities like claims, DMR, Dismissals, SOD, EOD tables.
• Developed Rollout and Rollback scripts to move to other Environments and attached to CR(change request).
• Deployed to QA/UAT/prod successfully.
• Experienced in Visual source safe latest version
• Used SQL Profiler and Query Analyzer to optimize ETL package queries and stored procedures.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Created DTS packages to copy tables, schemas and views and to extract data from Excel and SharePoint using SQL Server and SSIS.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures.
• Created Database Maintenance Planner for improving the performance.
• Conversion/Migration of SQL Server 2008 to SQL Server 2012
• Used various script tasks, look up transformations, control flow tasks like FTP, bulk insert task, transfer job task etc. and different data flow tasks using T- SQL and Visual Basic (VB) scripts
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Configured Reporting Services in SQL Server 2012.
• Created and scheduled SSIS packages to pull data from SQL Server database and export the data to various data sources like excel spreadsheets, flat file etc. and vice versa.
• Worked on performance tuning of SSIS packages using error handling, event handling, re-running of failed SSIS packages using checkpoints
• Monitoring SSIS packages of SQL Agent Jobs success / failure history.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2012.
• Migrated Objects (Stored Procedures, Views, Tables) from SharePoint, SQL and Excel to SQL.
• Responsible for database backups, data replication, encryption and database security.

Environment: MS SQL Server Management Studio 2012/2008R2, Query Analyzer, SQL Profiler, Microsoft Visual Source Safe, MS SQL Server Integration Services (SSIS)MS SQL Server Reporting Services (SSRS), MS Office 2007.

Confidential, Seattle, WA

SQL/SSRS Developer-Application Support.

Responsibilities:

• Works directly with internal business and technical teams (database and applications support) as well as outside technology service providers to identify the system integration requirements.
• Conducts detailed technical analysis of source and target system SQL Server database architectures and data models.
• Monitor data update and file trouble shooting, involve relevant stakeholders and escalate in timely fashion
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations
• Created various database objects such as tables, indexes and views based on the requirement.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Works on SSRS Reporting to Develop and analyzes technical reports from data warehouse as a part of Enterprise Reporting.
• Developed tabular, matrix, chart, Drill-down, parameterized and cascading reports (SSRS).
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed Custom/Conditional formatting reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Promoted RDLs to Reporting Service Server (SSRS). And adding data Driven subscriptions to generate the reports and drop in specified locations without fail.
• Supports the Database server workflow to generate the data without fail.
• Ensure that all timelines of loading/validation data are met.
• Troubleshoot, optimize, and fine tune ETL processes.
• Understanding the report design Requirements and Constraints.
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity.
• Developing and maintaining ETL jobs for the Data Warehouse using SQL Server Agent.
• Involved in Agile scrum meetings, updating the tasks based on the user stories in the Jira.
• Oversees the programming, testing and implementation of the system integration strategy.

Environment: MS SQL Server Management Studio 2012/2008R2, Query Analyzer, SQL ProfilerMicrosoft Visual Source Safe, MS SQL Server Integration Services (SSIS), Teamsity, GitlabMS SQL Server Reporting Services (SSRS), MS Office 2007, JIRA, OctopusDeploy, Ignite, Mainsite.

Confidential, TX

SSIS/SSRS Developer.

Responsibilities:

• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Wrote efficient store procedures for the optimal performance of the system.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Responsible for creating and modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Generated custom and parameterized report using SSRS.
• Configuration and Deployment of all the reports (RDL, RDS) across various SDLC environments.
• Actively involved in deploying complex SSRS Reports involving sub reports, Matrix/Tabular reports, Charts and Graphs.
• Responsible for creating datasets using T-SQL and stored procedures.
• Created several packages in SSIS and scheduled the packages to keep extracting the data from OLTP at specific time intervals.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Used SQL Server Agent for scheduling jobs and alerts.
• Performed Query optimization & Performance Tuning.
• Optimize queries using SQL profiler and Database engine tuning advisor.

Environment: SQL Server 2008 Enterprise Edition, SSIS /SSRS 2008, C#, T-SQL, VisualStudio.net, XML, MS Excel, MS Access, Visual Studio 2008.

Confidential,

SQL Developer

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2000, MS Access.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Maintained client relationship by communicating the daily status and weekly status of the project.
• Designed and implemented the Logical and Physical model of the database.
• Planned, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Developed complex T-SQL code for the application.
• Installed and maintained MS SQL Server 2000.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Implemented fine-tuning of database objects and server to ensure efficient data retrieve
• Environment: MS SQL Server 2000, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Windows 2000 Server.