SUMMARY

• Over 7 years of strong experience in the Database Design, development and deployment of large - scale enterprise applications.
• Extensive experience and in depth working noledge in various SQL Server tools and IDE to work wif Database, reporting and business intelligence based applications like SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio and Query Analyzer.
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, and strong understanding of BI application design and development principles.
• Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Excellent noledge in RDBMS concepts and constructs along wif Object creation such as Database, Tables, Normalization, User Defined Functions, SPROC, Views, Cursors and Triggers.
• Hands on Experience in writing complex stored procedures, Indexed Views and also creating and Updating tables for Data consistency and Data manipulation by executing DBCC commands.
• Experience in creating SSIS packages, DTS Migration and Metadata Management. Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Automated manual process wif SSIS packages for import, export and bulk insert data wif transformations from various data sources.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Good exposure or noledge working on C#, VB.NET framework.
• Extensive noledge of addressing Performance Issues and query tuning, Index tuning, Data Profiling and other database related activities.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through and Cascading reports using SSRS.
• Expertise in Writing Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• Extensive experience in using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.)
• Experience in Database Backup, Recovery and Disaster Recovery Procedures.
• Expertise in Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, Tableau Server and Reports, and MS Excel spreadsheets and Power Pivot.
• Used Tableau to visually analyze data and create concise and actionable dashboards.
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Flexible, enthusiastic and project oriented wif excellent communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

RDBMS: MSSQL Server 2014, 2012, 2008, 2005, MS ACCESS 2010, 2007, 2003

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

ETL Tools: Data Transformation Services (DTS), SSIS, Import/ Export wizard, Bulk Insert

BI Tools: SSRS, SSAS, Crystal Reports, BIRT, Tableau 7/8

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

Management Tools: SharePoint, Team Foundation Suite (TFS), Microsoft Office Communicator

Languages: MS SQL, T-SQL, PL/SQL, MDX, C#, VB.Net, HTML, XML

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

OS: Windows 2010/2008/2003 Servers, XP, Vista, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Virginia Beach, VA

MS SQL Developer

Responsibilities:

• Gathered business requirements and migrated all databases from SBI’s four servers to one new server on the Amerigroup domain.
• All SQL Server Agent Jobs were migrated to Tidal Enterprise Scheduler.
• Creating Database objects - Tables, Views and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Created SSIS packages to extract data and to schedule Jobs in Tidal Scheduler to call the packages.
• Performing query plans and making sure each and every query is using appropriate useful Indexes.
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity.
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk me/O, SQL Queries, other etc.
• Optimized the performance of queries wif modification in T-SQL queries, normalized tables, established joins and created indexes.
• Designed, Developed and Deployed packages in SQL server environment using SSIS-2012. Using Visual studio 2012.
• Wrote T-SQL queries, Stored Procedures and used them to build SSIS packages.
• Created Regulatory and Internal Reports based on the requirement specifications using SQL Server Reporting services (SSRS).
• Used SSIS to load data from various sources into on SQL Server 2014 database and created packages.
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Used C# and vb.net to create script tasks in SSIS packages.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Provided data modeling and mapping for other architects on the team to support their solutions.
• Created automation for writing back comments from a power pivot/excel services report to SQL server.
• Developing on-demand and scheduled reports for business analysis or management decision using SSRS.
• Used SSIS to load data from various sources into on SQL Server 2014 database and created package.
• Scheduled Backups and performed Restore operations for system test data.

Environment: MS SQL Server Management Studio 2012/2008/2005 , MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Cisco Tidal Scheduler, C#, VB.Net, TSQL, Microsoft Visual Source Safe.

Confidential, Alpharetta, GA

SQL BI Consultant

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Analyzed and designed software and database solutions.
• Involved in performance tuning using indexing (Clustered Index, Non Clustered Index) tables.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Worked on Functions, Triggers and Exception handling using T-SQL, maintaining Database using SQL.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages.
• Hands on experience working wif SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created different Power Pivot reports as per the client requirement.
• Worked on a web-based dynamic product registration and tracking system linked through ODBC to corporate DBMS.
• Expertise of data modeling in star and snowflake; Source to target mapping experience using ETL tool in agile software development methodology (SCRUM) and following SDLC guidelines and standards.
• Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
• Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.
• Created backup scripts to take periodic backups for the content on Tableau server.
• Worked wif Business Analysts, Developers and customers to resolve and escalate project issues.
• Gathered the business system requirements and act as a SME for the system and business and created status reports.
• Worked closely wif the team in meeting the deadlines pertaining to design and development deliverables.

Environment: MS SQL Server 2012/2008/2005 , SSRS, SSIS, SSAS, ASP.Net, TSQL, Tableau, Visual Studio 2008, Oracle, Erwin.

Confidential, Sacramento, CA

SQL BI Developer

Responsibilities:

• Generated database monitoring and data validation reports inSQL Server Reporting Service (SSRS).
• Designed dynamicSSIS Packagesto transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL andDTS/SSIS.
• DeployedSSISpackages and Reports to Production Servers.
• Involved in creation of Data warehouse Cubes inSQL Server Analysis Service (SSAS).
• Worked on Migration of packages from DTS usingSQL Server Integration Service (SSIS).
• Performing DBA functions, installing, configuring and supporting database systems.
• Implementing Business logic by using T-SQL (DDL, DML) and User Defined Functions (UDF).
• Reported all events and requirements through established reporting mechanisms inSSRS.
• Reviewed and developeddata models and database designswif development teams
• Generated test data andtested databaseto meet the functionalities deliverables in the project documentation and specifications.
• Designed and developed OLAP using MS SQL ServerAnalysis Services (SSAS).
• Configured replication servers and transactional replication between production & standby server for disaster recovery.
• Creating and Maintaining User role groups and granting the privileges to users and Groups and maintaining security up to date.

Environment: MS SQL Server 2005, SSRS, SSIS, SSAS,C#,ASP.NET, VB.NET, OLAP, Erwin 7.0, DTS/SSIS, BIDS.

Confidential, Orlando, FL

SQL Developer

Responsibilities:

• Created Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Performed query plans and making sure each and every query is using appropriate useful Indexes.
• Created and Modified T-SQL Stored Procedures/Triggers for validating the integrity.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) wif proficiency in using Report Designer as well as Report Builder.
• Extensive experience in multidimensional data modeling, such as star schemas, snowflakes, denormalized models, handling slow-changing dimensions/attributes.
• Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.
• Scheduled Backups and performed Restore operations for system test data.

Environment: MS SQL Server Management Studio 2008/2005, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe.

Confidential

Programmer Analyst

Responsibilities:

• Maintained system monitoring jobs and provided high availability support.
• Participated in Database Architecture and data modeling design.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Involved in performing database Backup and Recovery.
• Worked on Documentation using MS word.
• Wrote the stored procedures, checking the code for efficiency wif routine backups and restoration. Data transfers between various servers using BCP.

Environment: SQL Server Management Studio, SSRS, Query Analyzer, MS-word, Enterprise Manager, Import and Export, SQL Profiler.