SUMMARY:

• Around 8+ years of experience in IT industry as SQL Server Developer with specialized skills in SSIS, SSAS and SSRS.
• Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T - SQL Programming using DDL, DML commands for various business applications.
• Expert at developing ETL interfaces using SSIS, Data marts/cubes using SSAS and enterprise reports using SSRS utilizing latest versions (2008/2012) & features.
• Data modeling experience focusing on high-activity, normalized transaction systems (OLTP), highly-usable de normalized reporting systems (OLAP) as well as staging areas and data marts.
• Good experience and understanding of database design, relational integrity constraints, OLAP, OLTP and Normalizations.
• Involved in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, Table Variables and Stored Procedures.
• Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS, Import, Export Data, Bulk Insert.
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, DrillDown, Drill-Through, Multi-valued parameters etc.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Worked extensively on Power BI and created Reports/Dashboards using various type of Slicers and different Visualizations like Bar Charts, Line Charts, Graphs, and Pie Charts to make it more attractive and explored data in a Variety of ways and across multiple visualizations using Power BI.
• Created sub-reports, drill down reports, summary reports, parameterized reports, and ad-hoc reports using Power BI.
• Wrote Calculated Columns, Measures, and Queries in Power BI desktop to show good data analysis techniques.
• Ability to work on multiple tasks in a fast-paced environment independently and in a team, mentor to other team members to follow same techniques and standards.

TECHNICAL SKILLS:

Languages: HTML, CSS, JS, PHP, T: SQL, PL/SQL

Operating Systems: Windows7, Windows8/8.1, Windows10

SQL Server Tools: SQL Server Management Studio, Microsoft Visual Studio

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)

ETL Tools: SQL Server Integration Service

OLAP Tools: SSAS, MS Excel

Reporting Tools: SSRS, Power BI, Tableau

Data bases: SQL Server 2017/2012/2008

Business Tools: Word, Excel, PowerPoint, Outlook, Visio

PROFESSIONAL EXPERIENCE:

Confidential, Morrisville, NC

MSBI Developer

Responsibilities:

• Responsible for Managing BI Environment which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Created joins and sub-queries for complex queries involving multiple tables.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Used various SSIS tasks such as data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and Derived column so on which includes data validation checks during Staging, before loading the data into the Data warehouse.
• Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, Sort, Merge join, script component.
• Responsible for implementation of Data viewers, SSIS Logging, Error configurations for Error handling, Try Catch Blocks in the packages.
• Responsible for Performance Tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions and Functions, Sorting the data and Subtotals for the reports using SSRS.
• Extensively used Calculations, Variables, Break Points, Drill, and Slice and Dice for generating reports.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Developed various Charts (Pie Charts) and Graphs like Bar Chart (Side by Side, Stacked) using SSRS.
• Extract dataset from different data source including SQL Server, excel and flat file prepare datasets for Power BI.
• Implemented Power BI gateway different source to matching analysis criteria and further modeling for Power Pivot and Power View.
• Worked with both live and import data in to Power BI for creating reports.
• Managed relationship between tables in Power BI using star schema.

Environment: Erwin, SQL Server 2012/2014, Microsoft Visual Studio 2013/2012, MS Server Integration services, SSRS (MS server Reporting Services), Power BI Desktop, PowerPivot,, MS SSAS, T-SQL, Window 2012 Server, Oracle 9i/10g/11g.

Confidential, Memphis, TN

SQL/SSIS/ SSRS

Responsibilities:

• Generated Custom ETL scripts using SSIS 2012 and unit test SSIS load processes for performance check.
• Involved in Performance Tuning of queries by interpreting execution plan and SQL profiler.
• Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Scheduled daily maintenance plans for data received from multiple sources at different times during the day.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Performed checkpoints/reviews on designs and code being created by the other Data Integration developers.
• Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS.
• Created and deployed ad hoc reports, drill down reports as required.
• Developed dashboards with Power BI which display key KPIs for business analysis and decision making.
• Expertise in writing complex DAX functions inPower BI and Power Pivot.
• Created reports in Power BI desktop preview portal utilizing the SSAS Tabular via Analysis connector.

Environment: SQL Server 2008/2012 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Share Point, OLTP, OLAP.

Confidential, Houston, TX

BI Developer (ETL, SSIS, SSAS)

Responsibilities:

• Worked with Business Analysts in gathering requirements and translating them to technical specifications.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Worked on Full life cycle development (SDLC) of the project involving in all stages of development.
• Worked in Agile Methodology to efficiently deliver the project on time.
• Created SSIS packages for Uploading of different formats of files (Excel, Access) and databases (SQL server) into the SQL Server database using SQL Server Integration Services (SSIS).
• Written complex T-SQL queries and created Stored Procedures, Triggers, functions and Views.
• Optimized certain large fill stored procedures that would run daily, monthly, and quarterly, along with date time and other parameters using Common Table Expressions (CTEs) and complex joins.
• Tested for database corruption in our production databases and fixed applicable pagination errors using the DBCC commands.
• Enforced Security requirements using triggers to prevent unauthorized access to the database.
• Created logins and maintained user permissions appropriately.
• Restricted data for particular users using Row level security and User filters.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Designed and developed efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Involved creating detailed documentation for the migration, creation of data warehouse and all other tasks.
• Monitored activity across all servers for any blocked processes, failed jobs or failed reports.
• Handled the backing up and restoring of databases across servers.
• Created report models for the ad-hoc reporting of the end users using Report Builder
• Deployed SSRS reports in share point for web-based access for multiple end users
• Documented all the migration process documents for future reference.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

Environment: MS SQL Server 2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services(SSAS), Visual Studio 2014, T-SQL, MS Access.

Confidential

SQL Server Developer/BI Developer

Responsibilities:

• Created database objects like Functions, Packages, Indexes and Views using T-SQL in SQL Server 2008.
• Wrote store procedures to generate account statements for different types of accounts.
• Created DDL/DML triggers in SQL Server 2005/2008.
• Maintained database performance by normalization, indexing, collecting statistics so on.
• Generated DDL scripts for database schema and created all other database objects.
• Involved in upgrading the instance of development environment of SQL Server 2008 to SQL Server 2008 R2.
• Designing/ Implementing Backup policies for databases.
• Designed, developed and maintained the reports
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Retrieved data from cubes and generated OLAP reports using SSRS
• Collected requirement and generated stylish reports using SSRS
• Designed data models and generated Entity-Relationship diagram (ERD) using Erwin
• Modified database structures as directed by developers for test/development environments and assist with coding, design and performance tuning.

Environment: SQL Server 2008, Microsoft Visual Studio 2008, SSRS, Erwin 4.1/7.1, Oracle 9g.

Confidential

SQL Developer

Responsibilities:

• Developed T-SQL Queries, Triggers, Functions and Stored Procedures.
• Used SQL Analyzer and Profiler analyzing the SQL statements and procedures.
• Created Schema Objects such as tables, views, maintained referential integrity and granted roles to the Users.
• Created views to restrict access to data in a table for security.
• Experience in building and maintaining Data marts. Created roles for using the cubes.
• Interacted with Team in Analysis, Design and Develop database using ER Diagram.
• Involved in Design, Development and testing of the system.
• Created many Ad-Hoc Reports, Summary Reports, Tabular Reports, Matrix Reports using SSRS.
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using Report Definition Language (RDL).
• Responsible for developing automation of maintenance jobs, tuning SQL Server locks and indexes configurations, administering SQL Server security.
• Created DTS package to schedule the jobs for batch processing.
• Involved in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities.
• Involved implementing Disaster Recovery for minimal downtime using different types of database backups, restore, and replication.
• Wrote User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Worked on Documentation using MS word.

Environment: MS SQL Server 2008R2/2008, MS SQL Server Management Studio (SSMS), Visual Studio, SQL Server Reporting Services (SSRS), MS Excel, T-SQL.