SUMMARY

• Over 8 years of experience in SQL Administration, Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2000/2005/2008/ R2/2012 Denali for both OLTP & Data warehousing(SSIS,SSAS,SSRS) applications in various business domains.
• Strong T-SQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions and User defined data types.
• Involved in relational data modeling and multi-dimensional modeling using Denormalization, Fact tables, Dimension tables, Star schema for OLAP systems.
• Expert in SSIS script transformations using C# Script and scheduling complex SSIS Packages for transferring data automatically from multiple data sources to SQL server.
• Strong experience in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS).
• Strong knowledge of Data Warehousing methodologies and concepts, including star and snowflake schemas, ETL processes, dimensional modeling and reporting tools.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Performed daily tasks including backup and restore usingtools likeSQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Experience working in Waterfall and Agile development methodologies.
• Self-Motivated with Excellent communication skills with a strong focus on Client oriented service and ability to work excellently as an individual and also as part of a team with minimum amount of supervision.
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Have good experience with partitioned schemas, partitioned tables and indexes, creating Filegroups using SQL Server 2005/2008/2012.
• Experience in creating maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics

TECHNICAL SKILLS

Databases: MS SQL Server (Denali/2008R 2/2005/2000/2012 ), ORACLE 10g/9i, Cassandra

Database Tools: MS SQL Server 2008R2/2005/2000, MS-Access, SSIS, DTS, SSAS, BIDS And Erwin

Development skills: SQL, PL/SQL, SSIS/SSRS/SSAS, C#, HTML, Angular JS, CQL

Languages: VB Script, T-SQL, HTML, XML, ASP, Java Script, Vulcan, C and C++

Operating Systems: Windows 98/NT/2000/XP, 2003 Servers, UNIX.

Tools/Methodologies: SQL SERVER MANAGEMENT STUDIO(SSMS), BIDS, SQL SERVER DATA TOOL(SSDL),MS Visio, Erwin, MS Project, SQL Profiler, Visual studio, GIT, REDGATE.

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, WI

Senior MS BI Developer

Responsibilities:

• Dealt with various internal teams of cyber security department for understanding the each business user’s requirement.
• Designed various SSIS packages for load the data into Data Warehouse from different sources like flat files, excel documents.
• Managed Package Configurations in SQL Server along with environment variable configuration to efficiently deploy Unit Tested Packages from Test/Development Environment to Production Environment.
• Designed logical data model for a data Warehouse that accumulates and share the data among various internal team in IRM team.
• Developed Stored Procedures in T-SQL that were invoked to load Dimensions and Fact tables and also for Error handling during the ETL process.
• Involved in Automating the SSIS Packages using Auto-Sys.
• Created various Tabular, drill down, Cross Tab type Operational level reports for various teams in financial and cyber security teams using SSRS.
• Created datasets using stored procedures and reports using multi value parameters
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Created sub reports, bar charts and matrix reports and Published reports as PDF formats.
• Created Various Executive level management reports using SSRS.
• Designed and created a Dashboard for Information Risk Management team.
• Created Charts and Dashboards in Microsoft excel, using SSAS tabular model as source.
• Designed MDX expressions/queries for accessing cubes; involved in query structuring and performance optimization.
• Created and managed schema objects such as tables, views, cursors, indexes, procedures dynamically for any tables, triggers and maintained Referential Integrity.
• Optimized the performance of various SQL stored procedures using SQL profiler to improve the latency of reports pushed daily to management.
• Reviewed the existing stored procedures and improved efficiency by critically evaluating the code.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Created multidimensional cubes using the SQL Server Analysis Services.
• Created Calculated Members in the cube for additional functionality.

Environment: SQL server 2012, Visual Studio 2010 shell, SQL server management studio, Auto-sys, MS excel 2013, MS Access 2013, .NET 3.0 Framework, Sharepoint server 2010.

Confidential, Austin, Texas

MS SQL Developer (SSIS, SSAS, SSRS)/DBA

Responsibilities:

• Involved in gathering Requirements from the Business and worked as a part of Data Modeling Process.
• Continues Interaction with the business for the Data delivery and Data quality.
• Performed ETL (SSIS) from various data sources like Data warehouse, Oracle, Excel, CSV, Text files and various client servers.
• Monitored space usage, and adjust database as needed.
• Monitored/created backup operations, and schedules manual backups as needed.
• Developed various Stored Procedures and implemented different business logics, Filters to pull required data from sources.
• Rebuilding indexes for the migrated tables and improved the table retrieving process by performance tuning
• Maintain SQL Server Login administration, Backups and recovery plans.
• Develop/Deploy SSIS packages in SQL Server 2008/R2.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Maintained Database performance/tuning by using various optimizing tools such as Performance Monitor, SQL Profiler and Other Red Gate Tools.
• Performed various deployments and releases using REDGATE tools.
• Immensely worked on Stored Procedures, Functions, Index’s and monitoring the Performance of all the Databases.
• Established and enforced all database standards
• Work with OPS to resolve production issues.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom 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).
• Every third to fourth week, be on-call and support any database related issue (24x7).

Environment: MS SQL Server 2008/R2,BI,REDGATE, Visual studio, .net, BMC Workflow, GIT Repo, C#, Cassandra, XML, SQL Profiler, Nagios, ARIC, ERWIN, Version One, Agile Methodology.

Confidential, Columbia, MD

MS SQL Developer(SSIS/SSRS)/DBA

Responsibilities:

• Developed various T-SQL queries, Stored Procedures for data retrieval, maintenance and testing.
• Developed various SSIS packages for managing current and historical data using various transformations.
• Developed complex SSRS reports involving Sub Reports.
• Design and implement Mater Data Services (MDS).
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code
• Automated the Batch Processing and Version Validation.
• Created and published various Business rules to validate master data to ensure Data Accuracy and completeness.
• Involved in updating the servers from 2008R2 to DENALI (CTP3) version.
• Coordinated with platform hosting vendor(s) DBAs to ensure proper support maintenance, and tuning of various databases
• Monitored space usage, and adjust database as needed.
• Monitored backup operations, and schedules manual backups as needed.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to various data Sources like Excel Spreadsheets, Flat File etc and vice versa.
• Used various control flow tasks like For Loop, Execute package/SQL tasks, Script task, send mail task etc. and different data flow tasks.
• Worked on SSIS script task, look up transformations, persistent lookups and data flow tasks using T-SQL and Visual Basic (VB) scripts.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints Integral part of the Warehouse team for the Design, Development and functioning of cube.
• Developed the performance of the server and creating new reporting jobs according the clients need.
• Developed star schema’s and snow flake schema for various clients in AMS.
• Worked in Production environment and resolved the tickets in time to deliver the requirements.
• Directed resource/capacity planning for systems/databases by monitoring databases, checkpoints, and back-ups.

Environment: MS SQL Server 2008R2/DENALI, SSIS, SSAS, MDS, VULCAN, EXCEL, Visual Studio, TFS.

Confidential, Findlay, Ohio

MS SQL Server Application DBA,SSIS/SSAS

Responsibilities:

• Involved in SDLC and dynamically supported business users for given requirements.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Created database maintenance plan for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Developed various database objects such as Tables, Indexes and Constraints based on the requirement.
• Expertise in creating SSIS packages to clean and load data to data warehouse.
• Created packages to transfer data between OLTP and OLAP database using Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to load underlying data into the tables from various sources.
• Create logging for ETL load at package and task level to log number of records processed by each package and task in a package using SSIS.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Created Dimensions with the cube wizard and also individually and Deployed Cubes to the production server.
• Rebuilding / Monitoring the indexes at regular intervals for better performance
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases

Environment: MS SQL Server 2005/2008, SSIS, SSAS, SSRS, EXCEL, Flat File Source, SQL Profiler.

Confidential, Santa Clara, California.

MS SQL Server Developer(SSIS,SSRS)/DBA.

Responsibilities:

• Created T- SQL queries for Data retrieval, Monitored performance and Optimized SQL queries for maximum efficiency.
• Created and modified Stored Procedures as per the business logic.
• Created Views and other database objects like tables and indexes as per design needs and for security reasons.
• Gathered Requirements from the end user and involved in developing logical model and implementing requirements in SQL Server 2005.
• Designed SSIS packages to pull data from different data sources to database.
• Good experience in working with control flow and work flow tasks like Containers, Precedence Constraints, Execute SQL task in SSIS.
• Transformed the data using different transformations like Aggregate, split, join, merge, Fuzzy lookup of SSIS.
• Transformed the data using different SSIS transformations like Aggregate, split, join, merge, derived column, Multicast, term extraction and data conversion of SQL Server Integration Services (SSIS).
• Created logging for ETL load at package and task level to log number of records processed by each package and task in a package using SSIS.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005 that maintained data.
• Involved in the complete data warehouse development life cycle.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access.
• Defined report layouts for formatting the report design as per the need and even defined Datasets for report generation.
• Wrote queries for drill down reports to get the dataset required to build the report.
• Formatted the reports using Global variables and expressions.
• Maintained data integrity by performing validation checks. Optimized queries tuned and monitored server performance.

Environment: MS SQL Server 2005, SSIS, SSRS, SSAS, T-SQL, Windows XP.

Confidential 

SQL Server Developer/DBA

Responsibilities:

• Created and developed the stored procedures, triggers to handle complex business rules, Historical data and audit analysis.
• Conducted database management, performance measurement and tuning for new and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution.
• Created and administered multiple development, training and production databases.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL clustering, quality assurance including database consistency check.
• Responsible for creating standards and operating procedures to maintain all databases.
• Worked with development teams in the design of physical databases and in modification.
• Responsible for database security of the operational and developmental application system databases.
• Expertise in dealing with the data on Property and Causality insurances.

Environment: MS SQL Server 2000, T-SQL, SQL Server Enterprise Manager, SQL Profiler, ExcelData Import, DBMS, C.