SUMMARY

• Over 6 Years of IT experience as an MS SQL Developer, involved in Requirement Gathering, analysis, Design, Development, Unit Testing, Production Deployment and Support.
• Use different strategies of database development to meet teh client functional requirement.
• Support teh users of application with using multiple SQL and MS SQL techniques.
• Used MS SQL Tables, Cursors to process huge volumes of data and used bulk collect for mass update as performance improvement process.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization and Data Modeling.
• Extensive knowledge in T - SQL queries (DDL and DML) for developing complex Stored Procedures, Batch Scripts, Triggers, Tables, Views, Relational Database models and Data integrity, and SQL joins.
• Testing interfaces validate teh data, format to meet teh vendor specifications.
• Adept at developing Interfaces, creating queries, retrieving teh data from database and executing and performing queries on teh dataset and get reports
• Experience in writing SQL queries and optimizing teh queries in Microsoft SQL Server.
• Extensive experience in writing Dynamic sql, sub queries, SQL, MS SQL stored procedures, functions and additional Knowledge in Triggers and Cursors.
• Excellent in working on SSIS, SSAS, SSRS, OLAP, OLTP, Reporting and Analytics, Data Cleansing, Data Scrubbing, Data Migration and writing T- SQL.
• Retrieving data from a Power Pivot workbook dat contains teh data behind PivotTables and Pivot Charts
• Experience in creating jobs, alerts and scheduling DTS/SSIS packages in SQL Server Agent on daily/weekly/monthly basis.
• 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).
• Experience in creating MDX query in SSAS cube for various calculated members, KPI, Actions, Aggregation, Perspectives and various actions such as drill through, reporting etc.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services
• Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Expert in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions
• Strong business, communications, team building, presentation and time management skills.

TECHNICAL SKILLS

Languages: C, C#, .NET, SQL and T-SQL

BI Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Power BI, Data Transformation Services (DTS), Visio, Erwin

Databases: SQL Server 2014,2012, 2008 R2, MS Access 2010/2007, Oracle 11g/10g

DEV/Reporting Tools: TFS, Tortoise SVN, TOAD, SQL Developer, Jira, Rally, Active Batch

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

PROFESSIONAL EXPERIENCE

SQL Developer

Confidential, Memphis, TN

Responsibilities:

• Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
• Formulated and documented ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations and expressions.
• Designed and implemented SSIS packages to migrate data from heterogeneous data sources to staging database and load teh data to data warehouse or data marts.
• Excellent report creation skills using Microsoft SQL Server 2014 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder
• Created T- SQL queries, complex Stored Procedures, User-defined Functions, designing and implementing of Database Triggers (DDL, DML), Views and designing and implementing Indexes.
• Experience in monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Worked with subject matter experts (SME's) and project team to identify, define, collate, document and communicate teh data migration requirements
• Strong Experience in Azure based Power BI to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and share dashboards based on reports in power BI desktop
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to teh decision makers for strategic planning.
• Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.
• Migrated enterprise database to Microsoft Azure with Redgate and azure data factory.
• Generated occasional reports in view of teh factual investigation of teh information utilizing SQL server Reporting services (SSRS)
• Provisioned VMs with SQL Server on cloud utilizing Microsoft Azure and setting up communication with teh help of endpoints.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing teh performance of teh databases.
• Work with end to end business, IT developers, QA team, DBAs, and systems support personnel in elevating and automating successful code to production.

Environment: s: Windows server 2003, IIS 6.0, MS SQL Server- 2014/2012/2010/2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T- SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel

SQL Developer

Confidential, Brecksville

Responsibilities:

• Prepared teh complete data mapping for all teh migrated jobs using SSIS
• Responsible for creating and designing SSIS package
• Designed Extraction Transformation and Loading (ETL) process using SSIS to extract data from flat files, excel files and SQL server database
• Based on business requirement, developed teh Complex SQL queries with Joins and T- SQL, Stored procedure, Views, Trigger to implementing teh business rules and transformations
• Use different control flow control like for each loop container, sequence container, execute SQL task, send email task
• Use package configuration to migrate SSIS package from one environment to other
• Improved teh performance of teh SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing teh indexes.
• Perform tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Use event handing to send e-mail on error events at teh time of transformation
• Use login feature for analysis purpose
• Added intelligent system in SSIS to identify actual change and new change in dimension
• Backing up master & system databases and restoring them.
• Developed Stored Procedures and Functions to implement necessary business logic for interface and reports.
• Involved in testing and debugging stored procedures.
• Designed, built and tested SSAS Cubes on SQL Server.
• Created Excel workbooks to enable Cube (SSAS) access for business users.
• Handling tickets for Database deployments into QA, Staging and Production Environments
• Generated multiple Enterprise Reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as Group-By, Drill-Down, Drill-Through, Sub-Reports, Navigation Reports (Hyperlink), etc.

Environment: SQL Server 2014/2012/2008 , SSIS, T- SQL, SSMS, C# scripting, Business Intelligence Development Studio (BIDS), Excel 2010, SharePoint 2013, TFS, Visual Studio 2013/2008, Code Collaborator Client,ETL, Service Now.

SQL Developer

Confidential

Responsibilities:

• Assisted in building teh ETL source to Target specification documents by understanding teh business requirements
• Converted teh PL/ SQL Procedures to Informatica mappings and at teh same time created procedures in teh database level for optimum performance of teh mappings.
• Implement performance tuning on a variety of Informatica maps to improve their throughput.
• Created DTS packages to copy tables, schemas, views and to extract data from Excel using SSIS.
• Expertise in creating Report Models for building Ad hoc reports using SSRS.
• Developed Triggers to raise events on executing insert, delete and update stored procedures.
• Optimized existing stored procedures to achieve improved performance.
• Optimized teh T-SQL query performance with modifications in TSQL queries, removing unnecessary columns, establishing necessary joins.
• Developed advanced correlated and un-correlated sub-queries in T- SQL to develop complex reports.
• Developed Cross-Tabbed and Sub-Reports in SSRS.
• Generated occasional reports in view of teh factual investigation of teh information utilizing SQL Server Reporting Services (SSRS)
• Extensive experience in Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Migrated and recreated existing dimensions and cubes using star schema on 2005 server to achieve teh efficiency of SSAS.
• Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports. Expertise in Report writer
• Used Look up, Pivot, Merge Join, Union all, Derived Column, Conditional Split, and Aggregate transformation to manipulate data in SSIS package data flow.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Maintained teh physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler
• Performed day-to-day Database Maintenance tasks including Database Monitoring, Backups, Space, and Resource Utilization

Environment: MS SQL Server 2000 Enterprise Edition, Enterprise manager, MS Access 2000 & Windows NT platform, Reporting Services, DTS, Business Objects 4.0/6.5, Windows Active Directory