PROFESSIONAL SUMMARY:

• Over 7 years of Experience in Data Warehousing and Business Intelligence applications design, development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Data Transformation Services (DTS).
• StrongCommunication & Managementskills wifExcellent Role playing capabilities.
• Expert in working wif the Business Intelligence Development Studio (BIDS), which includes SSIS, SSAS and SSRS.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Expert in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2008/2008R2/2012/2014 wif expertise on data normalization.
• Design, Develop and Deploy Microsoft Power BI reports.
• Good hands - on working experience wif using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Replication, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Experience inBI DevelopmentandDeploymentofDTS, SSISpackages from MS-Access, Excel, and Oracle.
• Proficient in OLTP, OLAP and Data warehousing Design concepts.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• DesigningandDeployment of Reportsfor the End-User requests usingWeb Interface & SSRS.
• Experience in generating Drill through and Drill down reports wif Drop down menu option, sorting the data, defining subtotals in SSRS.
• Generated reports using SSRS, Excel (Pivot) dat could be used to send information to diverse group of users.
• Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Solid understanding of RDBMS database concepts and Experience in writing complex stored procedures, functions, Indexed views and triggers for data consistency and manipulation.
• Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
• Expert in implementing and planning Server Security and autantication, Database Normalization, designing and creating Indexes, Develop Queries and T-SQL Scripts in MS SQL.
• Skilled in Query Optimization, Performance tuning, and providing database security by creating users, permissions, and role-based access to data.
• Experienced in programming tasks-Stored Procedures, Triggers, and CursorsusingSQL Server 2012/2014wifT-SQL.
• Experienced in SDLC life cycle forDesign, DevelopmentandStagingphases of the projects wif support of Data-Flow, Process Models, E-R Diagrams.
• Experience in providingLogging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience working wifAgile, Scrum methodologies and complete Software Development Life Cycle (SDLC).
• Worked wif a team of business analysts, data architects, application developers, ETL developers and testers.
• Strong experience in mentoring wif team members, documentation and 24/7 on call production support.
• Excellent Problem Solving Skills, Communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.

TECHNICAL SKILLS

Operating Systems: Win 2000/2003/2008/2012, VMWare

Database Tools: Profiler, Management Studio, PerfMon, Query Analyzer, BIDS, SSDT, SSIS, SSRS

Web Technologies: HTML, CSS, JavaScript, .Net

GUI Tools: Visual Studio 2005/2008, 2013 and 2015

Languages: C++, C#, .Net, ASP.Net, TSQL, XML, XSQL, PowerShell, CMD Shell

Databases: Paradox, SQL Server 2008 to 2016

Third Party Tools: Red gate and Litespeed, CA, Remedy, HP, Sibel

Applications: Share Point

PROFESSIONAL EXPERIENCE:

SQL BI Developer

Confidential, Austin

Responsibilities:

• Involved in requirement gathering, analysis, design, development and deployment.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.
• Created various database objects such as tables, indexes and views based on the requirement.
• Designed and developed SSIS Packages to pull data from Access, Excel and Flat files to SQL server 2008.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked wif users in training and support and also have experience in incremental data loading.
• Developed ETL mappings to transfer data from some of the Access, Flat files.
• Developed, deployed and monitored SSIS Packages.
• Created packages in SSIS wif Error handling.
• Worked wif different methods of logging in SSIS.
• Rebuilding the indexes at regular intervals for better performance
• Monitored and modified Performance using execution plans and index tuning
• Involved in performance tuning and query optimization using indexing (Clustered, Non Clustered indexes) Tables
• Wrote and debugged Stored Procedures and (DDL /DML)Triggers, Functions as per client requirements
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Creating SQL Server Agent Jobs and scheduling them TEMPeffectively to populate the tables on a daily basis.
• Involved in SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and Stored Procedures.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Used various SSIS Tasks such as Conditional Split, Derived Column, which did data scrubbing, including 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 Views to reduce database complexities for the end users.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad hoc reports using MS Reporting services
• Created SSRS Parametrized SSRS Reports using SSAS Cubes as Shared Data Sources to make the Reports run faster for larger data sets
• Created SSIS Packages to Export data to tables from SSAS Cubes using MDX Queries and Tasks in SSIS Packages.
• Created Tabular Views from the views in SQL Server data base.
• Ensured best practices are applied and integrity of data is maintained through security and documentation

Environment:SQL Server 2008, SQL Server 2012, SQL Server 2014, DTS, SSIS, Import/Export tools, SQL Server Agent, MS Access, T-SQL.

SSIS/SSRS Developer

Confidential, Dallas, TX

Responsibilities:

• Participated in gathering User Requirements and System Specifications.
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.
• Migrated DTS packages to SSIS packages and modified the packages wif new features of SQL SSIS.
• Designed ETL packages dealing wif different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Created Dimensions and cubes wif star schema using SQL Server Analysis Services (SSAS).
• Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and chart.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: SQL Server 2008, SQL Server 2012, DTS, SSIS, SSRS, T-SQL, Excel, Windows NT

SQL Developer/SSIS/SSRS

Confidential, Plano, TX

Responsibilities:

• Participated in gathering User Requirements and System Specifications.
• Design, develop and deliver services analytics materials including back-end development of analytics services, SQL Reporting, delivery of automated reports & Power BI reports customization
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.
• Migrated DTS packages to SSIS packages and modified the packages wif new features of SQL SSIS.
• Designed ETL packages dealing wif different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Used Tableau 8.2 and Power BI for creating Dashboards over the database system.
• Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and chart.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: SQL Server 2008, SQL Server 2012, DTS, SSIS, SSRS, T-SQL, Excel, Tableau, Power BI, Windows NT.

SQL Developer/SSIS/SSRS

Confidential, Mount Laurel, NJ

Responsibilities:

• Created DTS packages to copy tables, schemas, views and to extract data from Excel using SSIS.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Used BCP command line utility to replicate a database.
• Worked on designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server.
• Worked on migrating some of the DTS packages in to SSIS.
• Used Recompile and wif option query hints to avoid parameter sniffing problems.
• Improved query performance by adding covered indexes, adding file groups.
• Creating and managing schema objects such as tables, views, joins, clusters, indexes, functions, procedures, triggers & maintaining Referential Integrity.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Developed reports using SSRS and Crystal reports. Used table control, matrix control for cross tab reports.
• Created standard Reports and Cross Tab Reports and Drill Through reports.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the subscription reports wif the subscription report wizard.
• Created different chart reports halped in analyzing performance counters using SSRS.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Import Data from MS-Access Database and XML to SQL Server Database.

Environment: MS SQL Server 2008/2008 R2, T-SQL, DTS, SSIS, SSRS, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Server BIDS, MS- Visual Studio.

SQL Server Developer

Confidential

Responsibilities:

• Installed, Configured and MaintainedSQLServer2005 in multiple database environments, namely development, QA and Staging.
• Applied Service Packs assisted Infrastructure Engineering team to install and configureSQLServer2008 in a Clustered (Failover) Environment.
• Upgraded toSQLServer2008 and guiding the development and application team to fully utilizeSQL Server2008 enhancements.
• Created Merge Replication between different data centers.
• Resolved issues; designed and managed database security.
• Monitored Databases for Dead Lock, Capturing long runningSQLqueries, used HINTS for fine-tuning SQLstatements dat better result in efficientSQLstatements processing.
• UsedSQLServerProfiler to monitor theserverby running traces on various events like User connections, stored procedure execution time etc.
• Evaluated the Database Performance of Index tuning wif using Database Engine
• Tuning Advisor to resolve Performance issues.
• Setup and configuredSQLServerfor other business functions.
• Index Data Management to determine Defragmentation level; whether to Update Statistics or Rebuild Indexes.
• Monitored viaSQLmodules like Idera Diagnostic manager, Tivoli etc. for performance issues like excessive locking, table scans, deadlocks, fragmentation and other bottlenecks.
• Responsible forSQLServertuning and performance evaluation and optimization and utilized new features likeSQLDynamic Management Views for the same.
• Also responsible for Query Performance tuning and Optimization.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting Ad hoc reporting.
• Worked closely wif development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
• The SSIS packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast, and Data Conversion.

Environment: MS SQL Server 2005, 2000 Windows 2003 Server, Visual Studio 2005, ASP.Net 4.0/3.5, SSMS, Profiler, PerfMon, Team Track, Jeera etc.,