SUMMARY

• A self - motivated with proven leadership skills involving managing, developing and motivating teams to achieve their objectives. Goal oriented and dedicated to maintaining high quality standards.
• Over 7+ years of experience in software development life cycle (SDLC) including Requirements gathering, Analysis, Design, Development, Enhancement and Maintenance.
• Strong technical knowledge in MS SQL Server 2012/2008 R2/2008/2005 development including Microsoft Integration, Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Strong in writing and tuning complex SQL complex queries, stored procedures, views, and constraints, triggers using inner and outer joins, unions, and SQL Statements for various applications in different environments.
• Extensive knowledge in performing DML and DDL operations.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Strong experience in T-SQL, Query Analyzer, SQL agent jobs and SSIS packages.
• Extensive use of Execution plan and SQL profiler for performance tuning.
• Experience in ETL (Extraction, Transformation and Loading) using SQL Server Integrated Services (SSIS) from various Data sources.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and SQL Server Integration Services (SSIS) ( 2005/2008/2012 ).
• Strong experience in SQL Server Reporting Services (SSRS) 2005/2008/2012 .
• Created, designed and deployed Tabular, Matrix, Chart, Drill-down and Ad-Hoc reports on the report server.
• Experience in developing Cubes (SSAS) and managing cube process.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Top N, Summary, Form, OLAP and Sub reports, and formatting reports.
• Involved in DBA activities such as backups, restores, replication etc.
• Experience in client/server connectivity, Query Optimization, Performance Tuning and Database Consistency Checks using DBCC commands.
• Monitoring of Database Growth. High availability systems and disaster recovery experience.
• Experienced in defining Data Sources for creating data source views.
• Experience in using native data monitoring tools.
• Highly motivated and result oriented professional with strong technical, interpersonal and communication skills.
• Experience on Team Foundation Server (TFS) to maintain the web application portal for reporting services
• Experience in using agile methodology and worked as a part of the Scrum development team.

TECHNICAL SKILLS:

RDBMS: SQL Server Business Intelligence Studio, SQL Server 2005/2008/2012 ,SSIS, SSRS, Visual Studio, Visual basic 5.0/6.0, Enterprise Manager, SQL Profiler, Query Analyzer, Export & Import, Replication, TFS, Tableau,T-SQL, HTML, PL/SQL, C programming

SQL SERVER: Oracle 10g/11g, MS-Access 2003/2008

PROFESSIONAL EXPERIENCE:

Confidential - Phoenix, AZ

Sr. SQL Business Intelligence Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Designed ER diagrams (Physical and Logical models using Erwin) and mapped the data into database objects.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Performed source/target analysis of data structures & content.
• Converted crystal reports to SQL Server reports using Reporting Services.
• Published ad-hoc reports and dashboards on WEB.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduled SSIS Packages.
• Used Merge in development, test and production for changing the referenced data.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Created package configuration using environment variables.
• Configured and maintained Report Manager and Report Server for SSRS.
• Used Team Foundation Server to maintain the web application and interface and for reporting services.
• Worked on Visual studio TFS for requirements gathering and testing.
• Created Sub-Reports, Drilldown-Reports, Drill through Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query.
• Used data compression techniques for Back Up.
• Worked on custom reports using Microsoft Dynamics
• Performed Documentation for all kinds of reports and SSIS packages.
• Used Agile methodology and a part of Scrum development team
• Performed CDC and Change tracking on OLTP systems.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.

Environment: SQL Server 2012/2008/2005 , SSDT (SSIS, SSRS, SSAS), SSMS, MS Access, Windows 2008 Server

Confidential, Charlotte, NC

SQL BI ETL Developer

Responsibilities:

• Worked extensively on installation, upgrade and configuration of MS SQL Server 2005/2008 database servers.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Worked with business/functional analysts to determine reports and analytical requirements.
• Created Reports with latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc.
• Documented Report Models and Report Templates for other Team Members.
• Created Prototypes by some complex reports and validated from the production.
• Developed Use Case Documents and Technical Documentation for some reports to Hand-off to the Offshore Development Team.
• Categorized reports into batch reports and on demand reports and scheduled it according to that.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Read business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on the requirements.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Used excel sheet, flat files, CSV files to generate Tableau ad - hoc reports.
• Hands on experience by working on Microsoft dynamics and created reports based on the customer requirements.
• Worked in an agile environment.
• Developed complex queries, stored procedures, views, and constraints, triggers using inner and outer joins, unions, and SQL Statements for various applications in different environments.
• Worked on Database space management, performance monitoring and alert management.
• Worked with business analysts and testers to manage the data as a part of data modeling.
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL.
• Experienced in loading data from the legacy systems into MS SQL server 2005 using SSIS packages.
• Worked on Team Foundation Server (TFS) to maintain the web application portal for reporting services
• Created user variables, property expressions, script task in SSIS.
• Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.

Environment: SQL Server 2012/2008, BIDS, Visual Studio 2003, Tableau Desktop 8.1, Tableau Server, SSIS, T-SQL, UNIX, Shell scripts, Oracle 10g.

Confidential - Franklin, TN.

SQL Server Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Implemented normalization techniques on different databases.
• Involved in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Created automated stored procedures for day end operations using SQL Server agent.
• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Worked with SSIS for transferring and reviewing data from heterogeneous sources like (Oracle, Excel, CSV, flat file, XML, Text Format Data).
• Worked on the data of vendors who sells devices to the company.
• Expertise in designing Data Flow task and Work Flow task on SSIS.
• Involved in Maintenance and Deployment of SSIS Packages.
• Worked and maintained the data of customers or subscribers who buys the products from the organization.
• Worked on .net framework and CLR versions to create instances
• Monitored and modified Performance using execution plans and Index Tuning.
• Generated multiple Enterprise reports (SSRS) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using SSRS.
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Used Query Analyzer, Index Wizard, DB Engine Tuning and SQL Profiler for performance tuning.

Environment: Windows 2003 Server/XP, SQL Server 2008/2005,SQL Reporting, Business Intelligence Studio, Visual Studio 2005, ADO.Net, OLE DB, DTS Package, SSIS

Confidential

MS SSRS/SQL BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Develop and support OLAP, star schemas, cubes and analysis.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Converted crystal reports to SQL Server reports using Reporting Services.
• Published reports and dashboards on WEB.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created Calculated Measures and Dimension Members using MDX, Mathematical formulas and User Defined Functions.
• Used Merge in development, test and production for changing the referenced data.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query.
• Performed Documentation for all kinds of reports and SSIS packages.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: Windows 2003 Server/XP, IIS7, SQL Server 2008/2005, SQL Reporting, Business Intelligence Studio, Visual Studio 2005, ADO.Net, SSIS.

Confidential

SQL Server Developer

Responsibilities:

• Created stored procedures, scripts, views in Oracle database design and create SQL database, tables, indexes, and views.
• Used DTS for data population from different sources and create DTS packages for data conversions and load data from flat files or excel files.
• Created and used stored procedures for database transactions in SQL Server.
• Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing, data backups, fine tune complex SQL queries and stored procedures to increase performance.
• Worked as a developer in creating complex stored procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, instances, linked servers and indexes.
• Extensively used enterprise manager, query analyzer, and SQL Server profiler to create custom and standard reports using crystal reports and also involved in database capacity plan.

Environment: MS SQL Server 2008/2005, SSIS, SSRS, DTS, SQL Management Studio, and SQL Server Business Intelligence tools, Windows 2003, SQL Server Query Analyzer, SQL Profiler, and Crystal Reports.