SUMMARY

• Over 7+ years of experience on MSBI (SQL SERVER, SSIS, SSRS and SSAS).
• Has an End - to-End experience of DW (BI) Project development and ongoing support.
• Experience in upgrading MS SQL Server 2008 to MS SQL Server 2012/2014/2016.
• Experience in ad-hoc SQL server queries, Sub-queries, CTE’s (common table expressions) Table variables and physical temp tables.
• Experience with analyzing, debugging existing stored procedures, Query optimization.
• Expert in database maintenance, SQL query optimization and performance tuning using performance tools like SQL Profiler, Index Tuning Wizard Database Engine Tuning Advisor.
• Experience in data conversion and data migration using SSIS across various sources like SQL server DB, MS access and flat files.
• Experience in analyzing design, development and application using SQL server integration Services (Control flow, Data flow, Data transformation tools, error handling).
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development & Production).
• Strong hands on experience in T-SQL programming & good knowledge on RDBMS concepts.
• Experience in configuring and managing data sources, data source views, mining structures, roles and creating hierarchies with SSAS.
• Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Experience in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas and user-defined functions.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from OLTP, relational databases and OLAP cubes.
• Expert knowledge and experience in authoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).
• Proficient in Performance Tuning/Query Optimization by creating various clustered, non-clustered indexes and indexed views.
• Experience in SDLC includes Requirements Analysis, Data Analysis, Data Modeling, Object Oriented Analysis, System Integration and Software Configuration Management.
• Experience with SQL Server Reporting Services (SSRS) and generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters.
• Experience in creating various types of Complex Reports using SSRS.
• Experience in Power BI Analytics and responsible for report deliverable on a Data Warehouse project.
• Experience at building and deploying multi-valued parameterized reports using Power BI.
• Strong understanding and experience on Team Foundation Server(TFS).
• Experience in a fast-paced Agile Development Environment, Test Driven Development (TDD) and Scrum.

TECHNICAL SKILLS

Databases: SQL Server 2016/2014/2012/2008 R2/2008, Access

Database Tools: SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), ETL, VB.NET, Bulk Insert and BCP, ODBC, BIDS, ASP.NET, C#, SQLCMD.

Languages: T-SQL, MDX and XML

Reporting Tools: SQL Server Reporting Services (SSRS) and Power BI

Integration Tools & DW: SSIS and SSAS

Version Control Tools: Team Foundation Server (TFS), GitHub.Operating Systems Windows Server 2008/2012, R2

PROFESSIONAL EXPERIENCE

Confidential, Miami, FL

Sr. MSBI Developer

Responsibilities:

• Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into specifications, documenting and rolling out the deliverables.
• Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
• Creating and maintaining various database on production and development environment using SQL Server 2012/2014/2016.
• Experience in writing stored procedures and functions on numerous SQL server.
• Design and development of ETL packages to load the data into Marts implemented to perform cleansing, mapping, profiling and whole governance on a real-time process.
• Responsible for data modeling, designs and development, oversight of implementation, testing, and managing the relationship between the client and the development team.
• Extensively used different transformations such as looping, error handling, data formatting, checkpoints and email notifications in SSIS packages.
• Involved in Installation, Configuration and Deployment of Reports using SSRS.
• Involved in writing T-SQL programming to implement stored procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.
• Used various transformations in SSIS Data flow, Control flow using for loop containers and Fuzzy lookups and Implemented Event handlers and Error handling in SSIS packages.
• Designed a Data model with multiple Fact Tables and Dimensions depending on the business requirements.
• Involved in troubleshooting report performance and query optimization issues to reduce the execution timelines.
• Responsible for creating & changing the visualizations in Power BI reports and Dashboards on client requests.
• Used to connect different data sources like SQL DB (SQL Query), Tabular Model (DAX Query), web trends to Power BI and generate reports with different visualizations.
• Created reports by using Joins in multiple tables from multiples database using complex SQL queries.
• Writing multi-dimensional expression (MDX) queries to get the data from a tabular model.
• Design and development of SSAS Tabular cubes to satisfy the end user reports by creating various types of reports and dashboards in Power BI.
• Involved to analyze and map data from source systems to target operational data stores and data marts (Data warehouse).
• Customized output formats from SSRS to Excel, PDF, and CSV.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Created complicated DAX measures in the Power BI reports as per the requirements of the Business Users.
• Experience in writing T-SQL (DDL and DML) queries, Store Procedures and use them to build packages and handle slowly changing dimensions to maintain the history of the data.
• Experience in Implementing Performance testing and Load Testing.
• Worked on Identifying the slow running ad-hoc reports and came up with the performance improvements.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Built a Tabular model cube from scratch data and by multi-dimensional expression (MDX) queries fetched data to SSRS and Power BI reports.
• Experience in creating SQL data models/Queries for Power BI and Ad-hoc Reports.
• Generated daily and weekly monthly reports involving customized and on-demand reports using SSRS and involved in analyzing multi-dimensional reports in SSRS.
• Involved in complete SDLC using Agile and Scrum models.
• Experience in using issue tracking tools (e.g., JIRA, etc.).
• An enthusiastic and project-oriented team player with excellent communication, leadership skills, problem solving skills and the ability to develop creative solutions for challenging client needs.

Environment: MS Visual Studio 2015, Power BI, SSAS (Tabular), SQL Server Management Studio 2016/2014, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Team Foundation Server(TFS), ASP.NET, VB.NET, C#, JIRA, GitHub.

MSBI Developer

Responsibilities:

• Experienced in design, development, unit testing, integration, debugging and implementation and production support, client interaction and understanding business applications.
• Designed ETL processes for extracting, transforming and loading of OLTP data into a central data warehouse. Integrated new systems with existing data warehouse structure and refined system performance and functionality.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Responsible for building reports in Power BI from the Scratch.
• Migrated old data from MS Access and Excel into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio (BIDS).
• Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.
• Created visualization reports and dashboards using Power BI desktop and published them to the Power BI Service.
• Worked with DAX/MDX queries in building expressions for various business calculations.
• Worked on Views, cursors, CTE’s, schemas, permissions and performance issues with client/server database design.
• Created and Modified SQL Joins, Sub-queries and T-SQL code to implement Business rules.
• Optimized the performance of T-SQL queries, established joins and created clustered/non-clustered indexes wherever necessary.
• Develop SSIS packages to extract, transform and load data into plan data marts.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and Developed, monitored and deployed SSIS packages.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Aggregator, Multicast and Lookup.
• Involved in performance tuning SQL statement and Query optimization and performed SQL queries extensively to test the data warehouse.
• By using Power BI Desktop Connected to various Data sources, working with different visualizations and Worked on importing custom visualizations.
• Strong experience in design and construction of data marts, data views and data mining. Experience in Building Multi-Dimensional Cubes, Data modeling, and OLAP Cubes using SSAS.
• Responsible for enhancement of database performance using database performance and tuning optimization tools and techniques.
• Created various Tabular and Matrix Reports using SSRS.
• Experience in developing SSIS packages to bring data from Claims databases to data warehouse tables.
• Created Maintained and scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuration of SSIS packages.
• Worked in Building Tabular Models using SSAS.
• Developed SSIS packages using various transformations like Lookup, Pivot, Derived column, Conditional split, Aggregate, Sort, Row Sampling, Union, Merge, Multicast.
• Created simple and complex SSRS reports like map reports, charts, indicators, secondary axes, custom coding etc.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Used Power BI for developing reports, KPI's, charts and data marts for the organization and departments.
• Involved in managing the data and creating new entities and attributes using the Master data services (MDS).
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Generated custom and parameterized reports using SSRS.
• Responsible for building Power BI Dashboards for 3M Digital Marketing team using Tabular and Multi-Dimensional Models.
• Developed training documents, helps with assignment of duties based on technical fit and assists in training new associates.

Environment: Microsoft SQL Server 2008R2/2012, Visual Studio 2008/2012, Data Virtualization, SSIS, SSRS, SSAS, Power BI, T-SQL, Agile, Scrum, Team Foundation Server(TFS), ASP.NET, VB.NET, SQL Analyzer and Enterprise Manager and SQL Agent.

Confidential, NY

Sr. SQL/Business Intelligence (BI) Developer

Responsibilities:

• Interacting with business users to gather information about transactional database and data warehouse database to generate reports as per report migration requirement.
• Created several database objects like tables, stored procedures, views, functions, index and triggers in T-SQL based upon the functional specifications.
• Designed the business requirement collection approach based on the project scope and SDLC Methodology.
• Have worked extensively on identifying facts and dimension tables.
• Deployed the SSIS Packages and created jobs for efficient running of the packages.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Extensively involved in debugging/troubleshooting and fixing the code scripts.
• Created SSIS packages for performing ETL operations to transform data from OLTP to OLAP systems.
• Involved with ETL team in fixing complex data modeling issues like slowly changing dimensions and designing physical schema model.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuration of SSIS packages.
• Generated reports using Global Variables, Expressions and Functions using SSRS.
• Creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Developed and maintained sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Monitoring and resolving Data warehouse ETL Production issues.
• Developed many Tablix Reports, Tabular Reports, Matrix Reports, Drill Down Reports and Charts using SQL Server Reporting Services (SSRS).
• Created complex stored procedures/functions and used them in SSRS directly to generate ad-hoc reports.

Environment: MS SQL Server 2005/2008R2/2010, SSIS, SSRS, Business Intelligence Development Studio 2012, Teradata, Microsoft Visual Studio, ASP.NET, Team Foundation Server(TFS), C#, MS Excel.

Confidential

SQL Server Developer

Responsibilities:

• Created new Databases, tables, established relationship among tables in a database.
• Created stored procedures & functions to support efficient data storage and manipulation.
• Responsible for creating datasets using T-SQL and Stored Procedures and also involved in Data visualization.
• Responsible for developing technical specifications from business requirements.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services.
• Responsible for SQL Server Reporting Services Planning, training, support and Administration in Development, Test and Production Environments.
• Created and Scheduled DTS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Involved in Performance Tuning of queries by interpreting execution plan and SQLprofiler.
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Designed and developed matrix, tabular and parametric reports using SSRS.
• Responsible for performance tuning and optimization ofSQLqueries and indexes.
• Worked on Performance Tuning/Query optimization, execution plans, trace flags and SQL Profiler.
• Created SSIS packages to clean and load data into data warehouse.
• Designing Data Marts using different multidimensional modeling techniques such as Star Schema and Snowflake Schema, Fact and Dimensional tables, Logical and Physical data modeling.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic.
• Created Report-Models for ad-hoc reporting and analysis.
• Developed Query for generating drill down reports in SSRS.
• Generated reports and deployed them on server using SQL Server Reporting Services (SSRS) to generate daily, weekly, monthly and quarterly Reports including status.
• Developed the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.

Environment: Microsoft SQL Server 2005/2008 R2/2010, SSIS, SSRS, Business Intelligence Development Studio (BIDS), Visual Studio, Team Foundation Server(TFS), ASP.NET.

Confidential

Jr. SQL Server Developer

Responsibilities:

• Participated in Requirement gathering and analysis.
• Created new Databases, tables, established relationship among tables in a database.
• Created Complex SQL queries, common table expressions (CTEs), stored procedures, functions, views, user defined functions (UDF).
• Performed T-SQL tuning and optimization of queries that take longer execution time using MS SQL Profiler, Indexes and Execution plans in MS SQL Server 2008.
• Adept in developing and debugging Stored Procedures, User-defined Functions (UDFs), Triggers, Indexes, Constraints, Transactions, and Queries using Transact-SQL (T-SQL).
• Created trace in SQL Profiler for Performance tuning on stored procedures and Scripts.
• Implementing SQL Server Indexing and Query optimization using Indexes.
• Created ETL SSIS packages both design and code to process data to target databases.
• Worked in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS.
• Developed Stored Procedures that sends auto mail to the clients using web service DB mail.
• Designed and developed MS SQL Server Stored Procedures using T-SQL statements from scratch.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Created SSIS packages to extract, transfer and load data into the data warehouse on a daily basis.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using SSRS Reports.

Environment: Microsoft SQL Server 2008 R2, DTS/SSIS/SSRS, T-SQL, OLAP, Windows Server 2007.