SUMMARY

• Around 7 years of experience with SQL and MSBI. Good exposure with all star schemas, snow flake schema, data modeling and work with different data warehouse projects.
• Proficient in SQL Server, developing complex store procedures, views, efficient triggers , required functions , creating indexes .
• Good in creating Sub - Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Experience across entire MSBI products including SQL, SSIS, SSAS, SSRS and PowerBI.
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS).Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files.
• Expert in Creating, configuring and Fine-tuning SSIS packages, SSRS reports and T-SQL queries using tools like SQL profiler Monitoring tool..
• Experience in creating jobs, alerts, SQL mail agent, and schedules for SSIS Packages in SQL Server Agent.
• Excellent experience in Designing, Maintaining and tuning various RDBMS like T-SQL &MS SQL Server and MS Access databases.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and data Integrity, SQL joins and query Writing.
• Strong experience in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
• Involved in Query Optimization and Performance Tuning using SQL Profiler.
• Involved in performing Unit Test, Regression Test, Functional Test, integration Test, Stored Procedure Performance Test, on Test server and preparing combined Developer Training document along with waterfall, Spiral and Agile methods with full SDLC (Software Development Life Cycle).
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Extensively worked on creating data source and data source views and developed SSAS Cubes , dimensions, Measures, KPI’s and Deployed SSAS objects using SQL Server Analysis Services(SSAS) .
• Build, published customized interactive reports and dashboards, report scheduling using PowerBI.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in PowerBI.
• Developed Tableau visualizations and dashboards using PowerBI Desktop.
• Good exposure with creating reports like Table report, sub report, Matrix report, Chart Report, Pie charts, Drill Down, Drill-through, Ad hoc reports and Cascading reports using SQL server reporting services(SSRS).
• Worked on ad hoc requests for information from systems and assists with configuration of reports in a timely, efficient, and accurate manner.
• Developed in-depth understanding of underlying data, data structures, and business uses to ensure reports meet client needs.
• Worked with DBA’S monitored daily jobs for all environments and resolved the bugs if job fails.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. Result-oriented with a desire to learn client's business requirements.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

Languages: C/C++, C#. NET, T-SQL, My SQL, HTML, CSS, JAVA Script, XML

Operating Systems: Windows Server 2000, Windows Server 2003, Windows XP, Windows 2008, Unix.

Databases: MS-SQL Server, MS Access.

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS), DTS

Reporting Tools: SSRS, SSAS, Power BI, Crystal Report, Excel reporting

DB Utilities and design tools: SQL Server Management Utility, Query Analyzer, SSAS Cubes, MDX scripting.

Application Software: Visual Studio, MS Office, MS Visio.

Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE

SQL/BI Developer

Confidential, Arlington, MA

Responsibilities:

• Used SSIS with special focus on creating Extract Transform Load (ETL) packages that process data into data warehouse and cubes.
• Created different transformations like data Conversions, lookups, derived column transformations etc, for data cleansing to remove unnecessary columns, eliminate redundant, inconsistent data and unnecessary Data like removing empty rows using SSIS.
• Created SSIS containers to loop through file collections to load and process customer data and deployed SSIS package to end user.
• Created SSIS package in which records were loaded daily, also from other data resources such as Excel, Access, flat file, and XML to create and maintain a centralized data warehouse.
• Migrated data from Oracle, Excel, flat files, MS Access to MS SQL server using DTS and SSIS.
• Used FTP task, ETL Script task, lookup transformation and Data flow task to load staging databases in SSIS.
• Created cubes in star and snowflake schemas, applied partitions, aggregations on it, used MDX to retrieve data using SSAS.
• Designed and implemented fact and dimension tables and OLAP cubes using dimensional modeling in SQL server analysis services (SSAS).
• Created sub report, On-demand, custom Ad-hoc reports using SSRS.
• Designed and developed report layout including parameterized report, drill down, and drill through reports in SSRS.
• Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS.
• Design and code high quality database solutions within a fast paced monthly release cycle.
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• Strong knowledge of using functions, and expressions in SSRS.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Created cube structure for the analysis of business condition and for creation of report using SSAS.
• Created drill down and sub reports from SSAS cubes that can be browsed on web.
• Worked on with Report Manager, Report Builder and Reporting Security and Reporting Services Configuration manager.
• Communicate and defend design, requirements, feature set, functionality, usability and limitations of subsystem to team and/or development lead or manager.

Environment: MS SQL Server, SSRS, SSIS, SSAS, T-SQL, MS-Excel, XML, Windows XP/10.

SQL BI Developer

Confidential, Boston, MA

Responsibilities:

• Gathered requirements from business users and developed SQL stored procedures and SSRS Reports.
• Created several SSRS reports like drill down, drill through and sub reports.
• Imported and created relation between different data sources and between multiple tables using Pivot table.
• Performed Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems as well as managed the subscription of the reports.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different Databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• 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.
• Created logins, users and configuring permissions and assigning roles to users.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL Queries for improved performance and availability.
• Created and documented the mapping of the database objects from source to target database.
• Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.
• Generated reports using report Builder3.0 that could be used to send information to diverse group of users, clients, and managers.
• Generated power reports in Excel 2013 for the users to as per user requirements along with BA.

Environment: SSIS/SQL, ERWIN 8 Data modeling tool, XML Schema, FTP, BIDS, Visual Studio.

SQL/BI Developer

Confidential, Louisville, KY

Responsibilities:

• Responsible for Installation, Configuration and Administration of SQL Server
• Involved in interacting with business analyst for gathering requirements and developed T-SQL code and SSIS Packages accordingly.
• Translated functional requirements into Technical specifications and Developed Stored Procedures and Complex SQL Queries.
• Developed SSIS Packages using lookup transformation, file system task, and for each loop container.
• Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, and Derived column, etc.
• Working knowledge on relational databases like SQL Server 2012/2008 R2/2005, T-SQL.
• Responsible for timely communication of production issues with the respective stake holders.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, and Bulk Insert.
• Used Query Analyzer to optimize SQL Queries.
• Created reports with Analysis Services Cube as the data source using SQL Server 2008 Reporting Services.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server 2012/2014 Analysis Services (SSIS) and Reporting service (SSRS).
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.

Environment: SQL Server Data Tools 2014/2012, SQL SERVER 2014/2012, SQL Server Integration Services (SSIS), SQL SERVER Reporting Services (SSRS), Power Pivot in MS Office Excel.

MSBI Developer

Confidential

Responsibilities:

• Translated functional requirements into Technical specifications and Developed Stored Procedures and Complex SQL Queries.
• Responsible for timely communication of production issues with the respective stake holders.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, and Bulk Insert.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Created Dimensions with the cube wizard and also individually.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Created reports with Analysis Services Cube as the data source using SQL Server 2005/2008 Reporting Services.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created Reports from Web Services and used MDX on Cubes in SSIS to create reports in SSRS.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.

Environment: SQL Server Data Tools, SQL Server Integration Services (SSIS), SQL SERVER Reporting Services (SSRS).

SQL Developer

Confidential

Responsibilities:

• Worked with Business Analysts and Data Architects in analyzing business requirements, specifications and business requirement documents in order to define the optimal solution and identify responsibilities for delivering solutions for data loading and maintenance
• Analyzed the business requirements and database architecture (Erwin), translated them into functional specification and built a Workload Report Application to summarize employees’ workload Upgrade Accounting, Human Resources Databases, Performing tuning activities
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in different environments.
• Created high level design of SSIS (ETL) Packages for integrating data from heterogeneous sources like flat file, CSV file, XML file by using Multiple Transformations provided by SSIS such as Aggregate, Slowly Changing Dimensions, Sort, Merge, Derived Column, Conditional Split, Lookup, Data Conversion and Union all.
• Involved in daily, bi-weekly, semi-monthly, monthly, annual batch loads (Full & Incremental) into staging and ODS area, troubleshooting load issues and errors using SSIS.
• Developed and created new database objects including tables, views, triggers, stored procedures, user defined functions, complex SQL Queries, clustered and non-clustered indexes to implement the business logic.
• Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.
• Created reports using Global Variables, Expressions and Functions using SSRS.
• Designed and delivered dynamic reporting solutions using SSRS.
• Extensively created SSRS reports such as Drilldown, Drill through, Matrix, Sub Reports, linked reports, Ad hoc reports as well as interactive reports and automated SSRS reports as per business user requirements and same has been configured in the Production Environment.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.

Environment: SQL Server 2008 R2, SSRS, T-SQL, MS-Excel, Windows NT/XP, MS SQL Reporting Services