PROFESSIONAL SUMMARY:

• Over 9+ years of professional experience in SQL Server database development, extensively worked in OLTP, OLAP environment & development databases as a Developer/ Database Administrator in different domains including HealthCare, Retail, Insurance and Financial services.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Extensive experience in implementing High availability and Disaster Recovery solutions like Replication (Snapshot and Transaction
• Log shipping, clustering and mirroring on physical and virtual machines.
• Extensively worked on Active - Active and Active-Passive Clustering.
• Implemented new features in MS SQL Server 2012 like Always on HADR in prod and non prod environments.
• Configured Always-On with synchronous and asynchronous secondary replicas.
• Implemented In place and Side by Side Migration of MS SQL SERVER … to 2008 R2 and 2008R2 to 2012
• Experience in developing T-SQL (DDL, DML, and DCL) statements.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Experience using SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Experience in using the DMVS, DMFS, SP PROC's, INFORMATION SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis.
• Expert in Data Integrity, Performance Tuning, Query Optimization
• Expert level skills in Objects creation such as Table, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing.
• Extensive experience with SQL Server and T-SQL in constructing tables, triggers, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Hands on experience in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to assist efficient data manipulation and data consistency.
• Well versed in Normalization/ Renormalization techniques for optimum performance in relational and dimensional database environments.
• Hands on Experience in using tools like Dynamic Management Views, Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for Monitoring and Tuning SQL Server Performance.
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.
• Developed, monitored and deployed SSIS packages.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created Cross-Tab, Drill-down, Drill-through, Tablix, and Sub-Report using RDL.
• Experienced on target BI tool for data discovery and self service business analytics
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) 2012/ 2008R2/ 2008/2005
• Developing reports on SSRS on SQL Server (2000/2005/2008 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experienced of the most advanced applications used in database modeling and management
• Skilled in developing a positive workflow through excellent communication and coordination with the coworkers
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.
• Strong Experience in Report Development, Modeling (Relational, DMR) and Dash Board Report in Performance Point, Targit.
• Experience of fixed income products and financial statements.
• Have work experience of Franchise fees AR, Sales and financial statements data.
• Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational database such as Oracle and DB2.
• Excellent interpersonal communication, problem solving, documentation and business analytical skills with an ability to adapt new technology quickly and a strong team player.

TECHNICAL SKILLS:

• MS SQL Server 2012/2008R2/2008/2005
• Azure
• Cosmos
• Reporting Services (SSRS) 2012/2008R2/2008/2005
• Integration Services (SSIS) 2012/2008R2/2008/2005
• Analysis Services (SSAS) 2012/2008R2/2008/2005
• JIRA
• TFS
• SVN SAS statistical
• Power Pivot
• Performance Point
• Cognos
• Crystal Reports 8.0/8.5/9/10/Xi
• Crystal Enterprise Xi
• Business Object Xi r2
• MSI and MST files
• W2K8/SQL2K8
• DTS
• T-SQL
• PL/SQL
• Business Intelligence Development Studio (BIDS)
• SSID
• DAX
• MDX
• Database Engine Tuning Wizard
• MS Visio
• Erwin 3.x/4.x/7.x
• ER-Designer
• TOAD
• Oracle 9i/10g/11g
• C
• C++
• .Net Framework
• IIS6, 7
• ASP.Net
• VBA
• HTML
• XML
• CSS
• Visual Source Safe
• Data stage
• Remote Desktop
• Confidential Office Suite Outlook
• Windows 10/8.1/7/2000/95/ NT/XP/Vista

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

MS SQL Server Developer/ Data Modeler /SQL Report Developer

Responsibilities:

• Work with Project manager and Team lead to understand the existing system. creating complex Stored procedures, editing existing stored procedure.
• Involved in creating index, views and table, Databases.
• Involved database design, Schema creation based on the business logic to boost performance.
• Involved in script library creation, editing and commenting based on conventional standards.
• Involved in data extraction using cosmos and DDL tools.
• Analyzing and data validating for checking freshness and data completeness.
• Expertise in creating packages, cleansing, and data transformation from data source to data destination.
• Expertise in SCD,CDC, incremental loads, DQS, etc.
• Involved Creating SSIS package task for job creation.
• Involved in creating Scope Script and Pipe line for importing CSV SS file from stream.
• Involved in Package execution and schedule for task automation.
• Using Power BI and Power view for data visualization.
• Expertise in creating Report using SSRS, Crystal Report, Tableau, Power BI.
• Experienced in Creating cascading, tabular and matrix report using SSRS.
• Experienced in Creating score card, parameterized report to creating filter getting data based on parameter.
• Expertise in Creating Tabular, Matrix, Cascading, Drilldown and Drill thru repot or data analysis and business decision.
• Experienced in creating subscription in SSRS for report delivery.
• Experienced in SVN, TFS, Source Tree, GIT for source control team collaboration.
• Involved creating Report using Power, Power view to make business analysis and forecasting.

Tools: & Technologies: SQL Server 2016, SSIS 2016, SSRS 2016, SQL Server 2014, SSIS 2014, SSRS 2014,SQL Server 2012, SSIS 2012, SSRS 2012, T-SQL, Visual studio 2010, Visual studio 2012, Visual studio 2015 Data Analyzer, Azure, Excel, SQL Profiler, DDL, Power View, Power BI, TFS, Source Tree, COSMOS, Scope Script, JSON, XML,C#,ASP.NET,VB.NET,VBA

Confidential, Philadelphia, PA

Database Administrator/ SSRS developer

Responsibilities:

• Work with project manager and SQL Architect to understand the existing system.
• Creating Database Backup strategy (Full backup, Differential backup and Transaction log back up) and disaster recovery procedure.
• Installs Server 2012on new servers with service packs.
• Support and troubleshoot very large databases (VLDB).
• Extensively worked on Snapshot and Transactional Replication
• Created database objects like tables, view, store procedures, functions, triggers using SQL server.
• Gathered functional requirements and Business requirements and written the technical specifications for building the Enterprise Integrated Data warehouse.
• Optimization of queries by looking at Execution Plan for better tuning of the database.
• Developed numerous ad-hoc reports using SSRS for day to day financial reporting.
• Generated custom and parameterized reports using SSRS.
• Worked on BI tools SSRS, Crystal report, Micro strategy for creating well versed plashed looking reports.
• Extensive experience in implementing High availability and Disaster Recovery solutions like Replication (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Implemented new features in MS SQL Server 2012 like Always on HADR in prod and non prod environments.
• Configured Always-On with synchronous and asynchronous secondary
• Experienced of creating Standard and data driven subscription for report delivery.
• Used SQL Server Agent for scheduling jobs and alerts.
• Provided technical guidance and support to end-users by developing documentations required.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Assisted with various ad hoc query requests.
• Convert existing access database process in SQL Server.
• Reviewed Cube with End user and changing the cube and documentation according to their requirements.
• Involved in installing and configuration of VMware.
• Create Tabular and Matrix reports for business analysis and decision making.
• Schedule on demand delivery of weekly, only and quarterly base reports
• Expertise in creating scorecards, report template and report dashboard.
• Create drilldown, drill thru, linked report for further analysis of business activities
• Expertise of creating standard and data driven subscription for report delivery
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Created scorecards, parameterized linked report, dashboard to provide insight the overall activity for business decision.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Successfully extracted data from flat files/excel files, applied complex transformation and finally loading to SQL Server data warehouse on monthly basis.
• Worked closely with developers, end users in designing and creating the Enterprise Integrated Data warehouse.
• Used SSIS transformations such as Lookup, Fuzzy Look Ups, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Provided back-end support for functional testing, performance testing and provided testing evidence.
• Modifying the existing ones to accommodate the business logic. Scheduling jobs on SQL server agent.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from different SQL Server Databases and Excel files, apply business logic, load in table and create view for end users.
• Used SVN for repository and maintaining versions.
• Used Index Tuning Wizard, SQL Profiler and SQL trace for Performance Tuning.
• Performed Database Refresh tasks from production to Development and Staging Servers.
• Involved in Technical decisions for Business requirement, Interaction with Development team, Capacity planning.
• Provided scripts to project manager for production implementation of data warehouse and several other database objects.
• Work with project manager to create data dictionary for end-user.

Tools: & Technologies: SQL Server SQL 2016/ 2014/2012/2008, SSIS 2014/2012/2008, SSRS 2014/2012/2008, T-SQL, PL/SQL, Visual studio 2008/2010, Data Analyzer, MS Access, Excel, SQL Profiler, Tableau Desktop 8.2/8.1/7, Tableau Server 8.2/7, Micro strategy, MS Access, Erwin v7.2, SVN, Toad, Attunity, Jira, Windows Server 2008/2003/2000

Confidential, Newark NJ

Database Administrator/ Developer

Responsibilities:

• Work with Database Administrator and SQL Architect to understand the existing system.
• Administering SQL Server security by Creating User Logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Creating Database Backup strategy (Full backup, Differential backup and Transaction log back up) and disaster recovery procedures
• Implementing SQL server high availability tools like Replication, Log shipping, and database mirroring.
• Simplify deployment and management of high availability requirements using integrated configuration and monitoring tools.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Successfully extracted data from flat files/excel files, applied complex transformation and finally loading to SQL Server data warehouse on monthly basis.
• Created database objects like tables, view, store procedures, functions, triggers using SQL server.
• Gathered functional requirements and Business requirements and written the technical specifications for building the Enterprise Integrated Data warehouse.
• Worked closely with developers, end users in designing and creating the Enterprise Integrated Data warehouse.
• Optimization of queries by looking at Execution Plan for better tuning of the database.
• Install and configure SQL Server Troubleshooting Performance issues and database issues.
• Extensively worked on setting up Always On Availability Groups on a Multi-subnet failover network. Worked with the Windows team to configure Windows Failover Cluster on which the Always-On setup was done.
• Install and configure latest Service Packs/Hot Fixes on SQL 2008R2, 2012 and 2014 servers.
• Design and implement comprehensive Backup Plan and Disaster Recovery strategies.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Maintain the database consistency by checking with DBCC Utilities at regular intervals.
• Use Resource Governor to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Design and develop SSIS packages using different control flow tasks, data flow task and data transformations.
• Maintain Active/ passive and Active/ Active cluster environment with Virtual Machines using Hyper V.
• Create and maintain Transactional, and Merge Replication environments.
• Implement Database mirroring. Configured Principal, witness and mirror on the 2008R2 SQL Servers.
• Used DMVS, DMFS, SP PROCS for the instant analysis.
• Developed numerous ad-hoc reports using SSRS for day to day financial reporting.
• Generated custom and parameterized reports using SSRS.
• Hands on experience on BI tools Crystal report, Congos for creating well versed plashed looking reports
• Experienced of creating Standard and data driven subscription for report delivery.
• Used SQL Server Agent for scheduling jobs and alerts.
• Provided technical guidance and support to end-users by developing documentations required.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Assisted with various ad hoc query requests.
• Extensively used SSIS transformations such as Lookup, Fuzzy Look Ups, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Work with Business analysts to create data dictionary for end-user.

Tools: & Technologies: SQL Server 2012/2008, SSIS 2012/2008, SSRS 2012/2008, T-SQL, Visual studio 2008/2010, Data Comparison, MS Access, Excel, SQL Profiler, Tableau, Micro strategy, MS Access, Erwin v7.2, Windows Server 2000

Confidential

MS SQL Server Developer/SSRS/SSIS Developer

Responsibilities:

• Expertise in creating physical and logical structure of the new data warehouse (SQL database) and process work flow by using ERWIN.
• Created several tables, views and stored procedures using SQL Server.
• Developed several SSIS packages and data flow tasks by using SSIS.
• Extracted data from different sources and stored in to SQL Staging tables in BI Staging database.
• Successfully extracted data from staging to ODS, applying complex transformation and finally loading to DSS after creating Dimensional and Fact tables.
• Strong experience Creating SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems (SQL Server) and scheduled Jobs to call the packages and Stored Procedures.
• Created different data points and pulling those using SSIS package.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Merge, Multicasting, Conditional Split, Derived column.
• Wrote T-SQL queries, Store Procedures and used them to build packages and reports.
• Developing several behavioral reports and data points creating complex SQL queries and stored procedures using SSRS 2012, Excel 2010.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Created all the SSRS report using Cube as data source. Responsible for the creation and the maintenance of Analysis Services objects such as cubes, dimensions and MDX queries. Used
• MDX queries for pre calculated measures.
• Created report Model on SSAS Cubes as well as changing default configuration on existing Cubes.
• Success several Ad-hoc reports by using MS Excel and automate some of these Ad-hoc reports based upon business demand.
• Hands on experience in creating several SSIS schedule tasks and monitor those tasks regularly.
• Analyzed the error output and error log of an automated process in case of failure of the process.
• Developed high level daily summary report and monthly business summary report (Monthly Management Report) and distributed these reports across different business units.

Tools: & Technologies: SQL Server 2012, SSIS 2012, SSRS 2012, T-SQL, Visual studio 2010, Data Analyzer, MS Access, Excel, SQL Profiler, MS Access, TOAD Data Modeler, Windows Server 2008R2

Confidential, Austin, TX

Database Administrator /Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using SSRS 2008R2.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2008R2.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.
• Responsible for the Performance tuning of the SQL Commands and the troubleshooting of the technical problems in SQL Server 2008R2 with the use of the SQL Profiler, Execution Plan, and Database Engine Tuning Wizard.
• Established backup and recovery of SQL server 2008R2 by using SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Experience of fixed income products and financial statements.
• Have work experience of Franchise fees AR, Sales and financial statements data.
• Used Team Foundation Server (TFS) for version control, source control and reporting.

Tools: & Technologies: SQL Server 2008R2, SSIS 2008R2, SSRS 2008R2, Oracle 9i/10g, Team Foundation Server(TFS), T-SQL, Visual studio 2007, Data Analyzer, MS Access, Excel, SQL Profiler, MS Access, Erwin v7.2, Windows 2008 Server

Confidential, Cincinnati, OHIO

Database Administrator/ Developer

Responsibilities:

• Wrote optimized SQL queries to access source data from RDBMS, and provided reports according to the requirements.
• Involved creating users and login to assign privileged.
• Involved in Database creation, tables, views, etc.
• Experienced in high availability and recovery.
• Involved in doing backup, log shipping for HA purpose.
• Maintain the database consistency by checking with DBCC Utilities at regular intervals.
• Use Resource Governor to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2008.
• Involved created Database Maintenance Plan for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Modified existing databases by adding/removing tables there by altering referential integrity, primary key constraints and relationships according to requirements.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries.
• Implement Database mirroring. Configured Principal, witness and mirror on the 2008R2 SQL Servers.
• Used DMVS, DMFS, SP PROCS for the instant analysis.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for data conversion using Data Conversion Transformation.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension Wizard.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Created data driven subscriptions for different users using Report Manager.

Tools: & Technologies: MS SQL Server 2008, SSIS 2008, SSRS 2008, Optimization, Calculated members and actions, Data warehousing, Parent child dimensions, Attribute Hierarchies.

Confidential, Pittsburgh, PA

MS SQL Server/SSRS/SSIS Developer

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the new system.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Wrote Stored Procedures and triggers to capture inserted, deleted and updated data from OLTP systems.
• Generated complex stored procedures and functions for better performance and flexibility.
• Created indexes for the quick retrieval of the data from the database.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute PackageTask etc. to generate underlying data for the reports and to export data from Excel Spreadsheets, Text file, MS Access and CSV files.
• Deployed the packages on staging and production.
• Created SSIS packages for data Importing, Cleansing and Parsing. Extracted, cleaned and validated data from XML file into database using XML source.
• Set SQL Server configurations for SSIS packages and configured logging including windows event log and XML logging.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Experience of fixed income products and financial statements.
• Have work experience of Franchise fees AR, Sales and financial statements data.
• Creating Annual financial reports for stock holders and end users.
• Importing finical data for further business fore casting and creating summarized report
• Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.
• Created linked, unlinked and on-demand sub Reports.
• Understood the various complex reporting requirements of company and created web reports using Reporting Services.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Tools: & Technologies: MS SQL Server 2005, Business Intelligence Development Studio (SSRS & SSIS) 2005, TFS, MS Office Access 2003, Excel, Erwin4.0 and Visio, Windows server 2003R2

Confidential

SQL Server Developer/SSIS/SSRS Developer/ Database Administrator

Responsibilities:

• Involved for database installation, configuration and database maintenance.
• Designed and Created databases, tables, views, stored procedures and triggers.
• Created groups, roles, users and assigning access privileges to users.
• Monitored and scheduled existing/new jobs on production environment.
• Optimizing Database Queries for performance enhancements and Writing T-SQL Views and triggers. Worked to tune the SQL queries using SQL Profiler.
• Highly responsible for scheduling and delivery of jobs using SQL server Agent. Performed T-SQL tuning by using Database engine tuning adviser and execution plans.
• Migrated data from SAS environment to SQL Server 2005 with SSIS 2005.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Reviewed ETL jobs developed by other teams and made sure they followed the standards.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
• Developed optimal stored procedures and queries to create data sets for reports.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Played a Content Manager role on report server.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.

Tools: & Technologies: MS SQL Server 2005, Windows 2003 Server, T-SQL, SSIS 2005, SSRS 2005, ASP .Net, VB.net, C#