SUMMARY

• Around 7+ Years of Extensive Experience in Business Intelligence Applications Design, Development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS).
• Experience in creating/deploying Data Transformation Services (DTS), Knowledge of Integration Services (SSIS) packages, Analysis Services (SSAS) and Reporting Services (SSRS).
• Expertise in Extraction, Transformation, loading data from Oracle, DB2, AS400, Teradata, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS.
• Strong Experience in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, Joins, triggers, clustering, T - SQL, SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), relational database models, data dictionaries, and data integrity.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Expert on creating multiple kind of Power BI Reports and Dashboards.
• Created, Maintained & scheduled various reports in Power BI.
• Published Power BI reports from Power BI desktop to Power BI service.
• Created different visualization in Power BI according to the requirements.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX), power query and power Pivot.
• Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Experience in Designing, Building the Dimensions, cubes with star schema, snowflakes schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2005/2008 Analysis Services.
• Experience in creating Report Models for building Ad hoc reports using SSRS.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Generated the weekly, monthly, and quarterly reports by using SSRS, MDS.
• Excellent experience in developing complex Stored Procedures, Views and Indexed Views.
• Good knowledge in RDBMS concepts, Data warehousing concepts, & OLAP.
• Worked in OLTP & OLAP environments that include QA, Production and development, implement maintain database schema and Entity relationship diagrams from business requirements.
• Good experience in creating User Defined Functions and Triggers in observing Business Rules.
• Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Proficient in implementing surrogate key generation strategy in the Data warehouse.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business Intelligence Development Studio, SSIS, SSAS, SSRS, Data Transformation Services, Scope, Tableau, Power BI.

RDBMS: SQL Server 2008/2005/2000 , 7.0, MS-Access.

Languages: T-SQL, PL/SQL

Web Technologies: Share point, HTML, CSS, XML, JavaScript, Shell Scripting.

Data Modeling: MS Office Visio 2003/2007.

Methodologies: Logical and Physical Database Design, Star Schema, Snowflake Model, UML, Database Design and Normalization.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Senior BI Developer (SQL/MSBI/ POWER BI)

Responsibilities:

• Interacted with the business users for understanding the business requirements and the existing system
• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Created complex SQL stored procedures, Triggers, Functions, Views, Indexes in SQL Server 2016.
• Created the views in the intake-database for the MS Sales hierarchies to be use in the store procedures in staging database.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Created many complex Query's and used them in Power BI Reports directly to generate reports on the fly.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2016 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Using SSIS Package identified the Up-streams and imported the required tables into intake-database, Store Procedures are created in staging database using the intake-database tables & views.
• Checking the code into TFS (Store Procedures, Views, Tables, Schema) for the deployment process for the production environment.
• Designed and implemented SSAS Tabular Cube as the reporting layer. And Used DAX scripting to access data from Tabular Model.
• Designed and implemented Row Level Security & Roles for SSAS Tabular Model. And deployed into SQL SERVER ANALYSIS SERVER 2016.
• Created complex SSAS Cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.
• Responsible for deploying the application for the Integration, Functional and User Acceptance Testing.
• Adheres to department, organization and industry guidelines, standards, policies and procedures.
• Create reports in Power BI preview portal utilizing the SSAS Tabular Model via Analysis connector.
• Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.
• Created Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements.
• Used One Drive for storing different versions of Power BI report.
• Published Power BI Reports in the required origination's and Made Power BI Dashboards available in Web clients and mobile apps.
• Created Dashboard and the Content Pack for the originations to get the updated Power BI Reports. And added the refresh time for each tile in the dashboard.
• Used JIRA for Version Control needs, task check-ins.
• Responsible for complete maintenance and delivery of scheduled releases.

Environment: MS SQL Server 2014/2016 T-SQL, MS SQL Integration Services 2014/2016, SSAS Cubes, Power BI.

Confidential, Denver, CO

SQL/SSIS/SSAS/SSRS/ POWER BI Developer

Responsibilities:

• Worked on gathering business requirements from end users, developing and maintaining Power BI Reports.
• Collaborate with cross-functional teams to help end users navigate the data and reporting to solve business problems.
• Developed SQL scripts to load data into enterprise data warehouse (EDW).
• Capture business objectives and processes and design and develop a comprehensive application and solution.
• Generated reports from OLTP and OLAP databases.
• Designed and developed tabular models and multidimensional models using SSAS based on the insights provided by the business users.
• Designed dimensions and hierarchies in SSAS cubes based on star schema from Data warehouse.
• Interacted with business users and analyzed the user requirements and built reporting solutions such as relational database reports, OLAP reporting, and dashboards.
• Worked on developing Power BI reports and dashboards from multiple sources.
• Created dashboards and data visualization using Power BI desktop.
• Published reports and dashboards to Power BI Service through Office 365 integration.
• Created data marts and load data into dimension and fact tables by creating SSIS packages.
• Worked closely with application teams and be responsible for database query design.
• Developed and supported SSIS ETL packages to perform data loads from distinct types of source files to SQL server database.
• Handled incremental data load into staging and ODS databases.
• Performed SQL code review on new procedures and report queries created by consulting team.
• Used performance monitor and SQL profiler to optimize the SQL queries and enhance the performance of the database.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying, and executing the packages in both the environments (Development and Production).
• Troubleshooted and resolved the issues with existing ETL process.
• Provided documentation for the new SSIS packages and procedures.

Environment: MS SQL Server T-SQL, MS SQL Integration Services, SSAS Cubes, Power BI.

Confidential, Boston, MA

SQL/MSBI/ POWER BI Developer

Responsibilities:

• Participated in requirements gathering, planning, analysis and designing based on business requirements.
• Involved in migrating SSIS 2008 packages to 2012.
• Created SSIS packages to extract, transform and load data from heterogenous sources including OLEDB sources, Excel, flat files into data warehouses.
• Created complex SSIS packages to enable error handling using control flow and data flow elements and configured packages with dynamic checkpoints to allow re-running from point of failure.
• Implemented SSIS tasks such as conditional split, derived columns for data scrubbing and data validation checks during staging before data is loaded into warehouses.
• Created stored procedures to transform data from enterprise data warehouse to data marts to build dimensions and load data into fact tables.
• Involved in developing and extending OLAP cubes, dimensions and data source views using SSAS.
• Designed various reports containing visualizations and analytical data on SSAS cubes using SSRS and Excel pivot tables.
• Created Ad-Hoc and SSRS reports with sub-reports, expressions and queries through report builders.
• Extensively used SSRS to generate matrix, drilldown, drill through, sub-reports, charts and parameterized reports.
• Involved in creating SSAS partitions, aggregations, query calculations and developing reports using MDX and SQL.
• Created several T-SQL queries, stored procedures, triggers, views and indexes on various database objects to maintain and modify databases.
• Involved in creating complex SQL queries including T-SQL joins to enable efficient data retrieval.
• Created SQL server agent jobs for the existing packages and scheduled them to run on a timely basis.
• Managed administrative tasks including user logins, user accounts, granting roles and permissions.

Environment: MS SQL Server T-SQL, MS SQL Integration Services 2008/2012, SSAS Cubes.

Confidential

SQL Server BI Developer

Responsibilities:

• Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
• Created reports by retrieving the data from cube using MDX reports.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed MDX queries to retrieve data from SSAS cubes.
• Designed high level ETL architecture for overall data transfer from OLTP to OLAP with the help of SSIS.
• Performed operations like Data reconciliation, validation and error handling after extracting data into SQL Server.
• Set package configuration in SSIS to redirect path from test environment to production environment.
• Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.
• Lead the development of automated DTS/SSIS packages to extract, transfer, load and convert data from various.
• Prepared the complete data mapping and Report Definitions for the project which involved around 33 reports.
• Worked on Huge Data Transfers from & to SQL Server Database. Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
• Created reports by retrieving the data from cube using MDX reports.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed MDX queries to retrieve data from SSAS cubes.
• Designed high level ETL architecture for overall data transfer from OLTP to OLAP with the help of SSIS.
• Performed operations like Data reconciliation, validation and error handling after extracting data into SQL Server.
• Set package configuration in SSIS to redirect path from test environment to production environment.
• Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.
• Lead the development of automated DTS/SSIS packages to extract, transfer, load and convert data from various.
• Prepared the complete data mapping and Report Definitions for the project which involved around 33 reports.
• Worked on Huge Data Transfers from & to SQL Server Databases using SSIS and used configuration files and Environment variables for production deployment.
• Created necessary steps to enhance user response time by improving queries and their index selections to minimize IO and eliminate table scans.
• Enhancing the SSIS Packages and deploying from development server to production server.

Environment: MS SQL Server T-SQL, MS SQL Integration Services, SSAS Cubes.