SUMMARY

• Over 6 years of solid experiences in design, development and support in Microsoft SQL Server 2008R 2/2012/2014/2016 , T - SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) ETL process.
• Solid skills in designing and implementing data warehouses and data marts using components of Kimball dimensional modeling methodology such as Slowly Changing Dimensions (SCD), Conformed Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc.
• Experienced in developing high performance data integration solutions with SSIS, including extraction, transformation, and load (ETL) packages for data warehousing.
• In-depth knowledge of complex T-SQL. Power user of advanced SQL queries with multi-table joins, group functions, sub-queries, set operations and functions.
• Expertise in creating and optimizing T-SQL stored procedures using indexes, UDFs, joins, error handling, views as well as with use of execution plan, SQL profiler and Extended Events.
• Involved in business requirements gathering from end users and converting them into functional requirements and creating documentations, design and development on those requirements.
• Solid skills in creating indexes, views, complex triggers, effective functions and stored procedures to facilitate efficient data manipulation and data consistency.
• Great understanding of delivery modes that compliment business polices and needs such as pull delivery, push delivery of reports using Standard/Data Driven Subscriptions in SSRS.
• Experienced in writing parameterized queries for generating Tabular and Matrix reports, Parameterized and Cascading reports, Drill Down, Drill Through, Lists, Subreports, formatting report layout using Expressions and Functions, Sorting the data, defining data sources and subtotals for the reports using SSRS.
• Designed and developed a variety of dashboards and reports using Power BI, Tableau and SSRS
• Sufficient skills of monitoring and optimizing system performance by optimizing SQL queries
• Solid knowledge and experience of Agile/Scrum software development life cycle and project management methodology.
• Results-driven with ability to take initiatives and meet deadlines in a fast-paced changing environment; Strong analytical and communication skills with the enthusiasm to learn new technologies.

TECHNICAL SKILLS

• S QL, T-SQL, PL/SQL, DAX, XML, C/C++/C#, PowerShell
• MS SQL Server 2008R 2/2012/2014/2016 , MySQL 5.x, Oracle 11g/12c
• SSIS/SSRS/SSAS, Power BI, Tableau, Visual Studio 2010/2012/2013 , SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), SQL Server Data Tools (SSDT), SharePoint
• Agile/Scrum, Rally, JIRA, Git, Subversion
• Windows 2008/2008R2/2012/2012R2, CentOS Linux

PROFESSIONAL EXPERIENCE

QL/SSIS/SSRS Developer

Confidential

Responsibilities:

• Partner with data and business analysts to refine the business requirements that must be met for building and maintaining data warehouses/marts built on Microsoft SQL Server 2012.
• Design, create and regularly tune physical database objects (tables, views, indexes) in MS SQL Server 2014 to support normalized and dimensional models.
• Work as a primary T-SQL developer in creating complex stored procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Provide day to day support of data warehouse and troubleshooting of existing process and procedures.
• Transfer data from various data sources/business systems including MS Excel, MS Access, Flat Files, Oracle etc. to SQL Server using SSIS various features such as SCD, Multicast, Conditional Split, Derived Column, Union All, Merge, Merge Join, Lookup, Cache, Fuzzy Lookup, Data Conversion.
• Design and develop a variety of dashboards and reports using Power BI, Tableau and SSRS
• Troubleshoot SSIS packages using Logging and Event Handler
• Deploy SSIS to different environments using project deployment mode
• Configure SQL Server maintenance plans to automatically back up SQL Server databases, optimize index and update statistics
• Use SQL Server Profiler to trace long running queries for optimizing databases.

Confidential, Phoenix, az

SQL Developer

Responsibilities:

• Worked as the key role in maintaining and enhancing key back office financial applications originally developed using SQL Server2012.
• Utilized the Agile/Scrum software development principles and experiences to develop within the full life-cycle of the mission critical production application.
• Gathered and analyzed technical information and created clear, readable documents, in the form of user manuals, end-user training materials, reports.
• Investigated application anomalies to determine root cause. Resolved data issues using SSIS per business needs. Performed ad hoc queries as needed. Developed and maintained general and online program reports.
• Assisted application developers in designing program enhancements, database backup and recovery. Performed performance monitoring on database.
• Created tables, indexes, views, complex triggers, effective functions and stored procedures to facilitate efficient data manipulation and data consistency.
• Identified and analyzed expensive T-SQL stored procedures by using the SQL Profiler, Extended Events, SQL analyzer, created the necessary indexes and SQL hints to improve query performance.
• Performed user acceptance testing of new changes before production release. Ensure program/data integrity.
• Maintained and enhanced the existing data warehouse and reports; developed dashboards and reports using SSRS that meet provided specifications.
• Scheduled and managed daily, weekly, monthly sales and operational reports based on the business requirements.
• Performed quality checks on reports to ensure exceptional quality; monitored jobs and transfer queues to ensure they were functioning as expected.
• Created technical documentations, performed detailed code reviews, and created automated build and deployment scripts.

Confidential, Waren, NJ

BI Developer

Responsibilities:

• Involved in gathering requirements, performing source system analysis and development of ETL jobs to migrate data from the source to the target Data Warehouse.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and stored procedures.
• Transformed data from MS SQL Server 2008R2 to MS SQL Server 2012 using OLE DB connection by creating various SSIS packages.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Deployed SSIS using package/project deployment modes
• Created Drill Down, Drill Through, Parameterized reports, Subreports using SSRS.
• Deployed and managed reports using Report Manager, delivered reports to different vendors, clients and managers.
• Recreated indexes, optimized queries, memory management to improve performance.
• A SSAS and SSRS. Installed latest SQL server / Windows server service packs on all SQL servers. ssisted in production of OLAP cubes, wrote T-SQL queries to produce reports using