PROFESSIONAL SUMMARY:

• Around 8 years of professional experience in IT industry working in software analysis, database design, development using Microsoft technologies like SQL server 2 /08 R2, SSIS, SSRS, SSAS.
• Hands - on experience in all phases of SDLC (software development life cycle) involving Requirement analysis, Software design, development, implementation, testing, maintenance.
• Experience with T-SQL in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
• Involved in the development and implementation the full suite of Data Warehouse solutions: Data Warehouses and Data Marts, Cubes and ETL processes.
• Good knowledge of Database Administration operations like Backup, Restore and excellent knowledge in Transact-SQL (DDL, DML, DCL).
• Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Able to creatively stretch the capability of Tableau to customize and develop creatively stunning and dynamic visualizations.
• Hands on experience in dealing with Relational Database Management Systems, including Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors, Normalization.
• Experience writing T-SQL scripts, dynamic SQL, creating indexed views, cursors, indexes, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Expertise in creating Cell Level Security in cubes using SSAS.
• Experience with Data Visualization tools such as Tableau, Power BI etc
• Worked on Power BI Desktop by extracting data from different sources by writing queries according to business needs in query editor.
• Developed Dashboard Visualizations, cross tables, Bar charts, Waterfall, Tree map and complex reports which involves custom Controls and Custom Expressions using bars, lines and pies, maps, scatter plots, Gantts, bubbles, histograms, bullets, heat maps and highlight tables
• Expert in creating and developing Power BI Dashboards in to rich look.
• Worked with Financial companies for application related pricing and security applications.
• Experience in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Implemented Snow Flakes Schema and Star Schema.
• Created calculated measures in tabular model using DAX Queries according to end user requests and reporting needs.
• Involved in quantitative and qualitative analyses, custom models and ad hoc reports to effectively monitor performance, trends and opportunities across all channels
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies using SSAS.
• Experience with Enterprise Data Warehouse environments, including experience with database design, modeling, administration and optimization.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Experience using recent versions of Microsoft Visual Studio 2012/2014/2014.
• Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies in SSAS.
• Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modelling.
• Developed Reports using efficient data retrieval techniques.
• Experience in Tuning SQL queries and T-SQL queries, MDX & improving the performance of the queries.
• Published Power BI reports from Power BI desktop to Power BI service.
• Experience in developing, maintaining and supporting operational reports, dashboards and scorecards using Microsoft Power BI.
• Proficient in designing and developing cubes using SQL Server Analysis Services (SSAS) and leveraging the advanced BI functionality of SQL Server.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2008/2, MS Access, Oracle 9i/10g.

Tools: SQL Server Management studio, Enterprise Manager, Profiler, ETL, Visual Studio .NET, SQL Azure.

BI Tools: (SSRS), (SSIS), (SSAS), Power BI, Tableau, ETL

T: SQL, PL/SQL, C#, Java (J2EE), VB scripts, MDX, DAX, Oracle, UNIX Shell Script.

Web Technologies: XML, XPath, HTML, XSLT, JavaScript, IIS.

Data Modeling Tools: Erwin tool, Microsoft Visio

Application Packages: MS Office Suite, MS Outlook, Microsoft Office SharePoint Server (MOSS)

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Power BI/MSBI Developer

Responsibilities:

• Actively participated in gathering business requirements to implement functional and technical specifications.
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers.
• Understanding the business requirements, analyzing source system, source files, setting up the goals for implementing the new client.
• Created the Logical, Physical model and ETL Mapping Documents based on Business logic.
• Extracted data from Oracle, DB2, AS400, SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
• Configured the SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment.
• Developed SSIS ETL Packages& also modified packages into different environment (Development, Testing & Production), as ongoing requirement changes
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Dimension and Fact table design and cubes for KPI, Defining hierarchies and rollups.
• Identified Dimensions and Facts, Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation.
• Enhance SSIS packages to perform dynamic functionalities from static configuration and changed many of the packages by using C# coding for generic usage within the organization.
• Created & modified SSRS reports (2012 & 2016) depend on the requirement on the priority basis from the DW & BW bug tracker applications.
• Worked on the performance and high priority critical issues to meet deadlines for SSIS package execution and for SSRS reports rendering.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Target.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Created Advanced Reporting Services Programming Using the Reporting Services Web Service.
• Creating, Modifying SSAS Measures, Dimensions Attribute relationships and Hierarchies.
• Designed SSAS Cubes, Named Calculations for Dimensions.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Worked on developing Power BI reports and dashboards from multiple sources.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Created DAX calculated columns in Power pivot worksheets to extract, import and join data that coming from different sources.
• Defined data sets with joins and sub-queries for complex queries involving multiple tables in Power BI.
• Used different types of visualizations Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.
• Created calculated fields and parameters along with the appropriate filters and plotted the measures on the respective graphs using Microsoft Power BI data visualization tools.
• Created dashboards and data visualization using Power BI desktop.
• Published reports and dashboards to the Power BI . Shared the dashboards among multiple users in the group.
• Published dashboard, reports to online Power BI could service for the use of report consumers.
• Created Development and Production support documents.
• Used Subversion for centralized storage within the Data Warehouse department.

Environment: Power BI, MS SQL Server 2016, SSIS, SSRS, SSAS, T-SQL, Power BI, Visual Studio 2016/2015, MS Office, Oracle 10g/ 9i, SQL Profiler, Excel and Access

Confidential, Dallas, TX

Power BI/MSBI Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Provided valuable suggestions to users in terms of database design and new application implementation to overcome existing performance and reliability issues.
• Created report schedules and subscriptions. Created data driven subscriptions, reports that run on demand, cached the Reports, Snapshot of the Reports. Deployed reports both to the SharePoint server, IIS Server, Integrated SharePoint server with Report Server.
• Performance tuned long running lengthy SSRS reports and optimized rendering time by 10 times of the actual time.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Embedded Power BI reports on SharePoint portal page and also managed access of reports and data for individual users using Roles.
• Used Microsoft Power BI to Build and maintain the reports and dashboards. Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports.
• Used Microsoft Power BI to Build and maintain the reports and dashboards.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Responsible for creating datasets using T-SQL and Stored Procedures and involved in Data visualization.
• Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.
• Provided 24X7 production support to ensure timely and error free delivery of reports.
• Created the SSIS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Extensively used T-SQL in creating and altering stored procedures, functions, views, indexes, user profiles, relational Database models, data dictionaries, and data integrity.
• Writing reports using Microsoft Reporting Services (SSRS)
• Created jobs, alerts to run SSIS packages periodically. Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
• Designed, built and tested SSAS Cubes on SQL Server 2008.
• Created Excel workbooks to enable Cube (SSAS) access for business users.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into the data warehouse.
• Retired SSIS 2008 server and upgraded all existing SSIS 2008 jobs to SSIS 2012.
• Developed, designed and deployed matrix and tabular reports with drill-down and drill-through features using SSRS.

Environment: MS SQL Server 2014/2012, Transact-SQL, SQL Server Integration Services (SSIS), Power BI, SQL Server Reporting Services (SSRS), Power BI, SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS), MS-Excel.

Confidential, OH

Power BI Developer

Responsibilities:

• Involved with Data Architects in designing New Data Model, EDW (Data Warehouse) and OLAP Data Model.
• Created SSIS Packages to load Data from Existing Data Model to new Data Model and Data Ware House.
• Involved in designing complex packages moving data from various servers and environments using SSIS.
• Performance tuning the SSIS Packages by understanding the Data Flow Buffers and by designing for parallelism.
• Involved in loading Dimensions and Facts in newly built data ware house which also involved in Type 1 and Type 2 slowly changing dimensions using SSIS.
• Deploying SSIS Packages on respective server and effectively using configuration files for using same packages on other environments.
• Scheduling the SSIS packages by creating a Job using SQL Agent in SSMS.
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.. .
• Worked with various transformations like Lookup, Fuzz Lookup, Merge, Sort, Multicast, Conditional Split, Loop Containers, Execute SQL Task and lot more using SSIS.
• Designed SSRS Reports on the newly developed ERM Model for financial data users.
• Involved in Performance tuning the SQL Server Queries used in SSRS Report and also used Report Snapshots for better performance.
• Created user groups in Report Manager for limited access to the end users in SSRS.
• Closely worked with Data Quality team and Data Architects to identify bugs in the new Data Models and automated the Data Quality process which involved lot of T-SQL programming like Functions, User Defined Functions, Stored Procedures and Views.
• Involved in fixing the bugs in new Data Model and also Data Warehouse worked very closely with Data Architects.
• Gathered all requirements from Business Analysts and documented whole process of Data Flow and Data Analysis process from all the source systems.
• Used Microsoft At unity adapters for Teradata and Oracle for optimal performance.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2012.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Involved in ETL architecture enhancements to increase the performance using query optimizer
• Implemented Event Handlers and Error Handling in SSIS packages.
• Scheduled Automatic refresh and scheduling refresh in power BIservice.
• Wrote calculated columns, Measures query’s in power BI desktop to show good data analysis techniques.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Created and monitored Control-M jobs for SSIS packages
• Wrote SQL Loader scripts to load data into the SQL Server database from excel spreadsheets.
• Used views, procedures and functions process staged data and loaded the final tables. Created tables, added columns to existing tables.
• Wrote many adhoc queries for testing the old verses new architecture data to determine if the new system could meet the requirement of minimal loan failure.

Environment: T-SQL, MS SQL Server 2008, BIDS, Management Studio (SSMS), ETL, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), OLAP, Cubes, Data-warehousing, Windows 2008.

Confidential, VA

MS SQL BI Developer

Responsibilities:

• Participated in gathering User Requirements and System Specifications.
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic to generate different market claims for different types of accounts.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.
• Migrated DTS packages to SSIS packages and modified the packages with new features of SQL SSIS.
• Creating, managing, and supporting various ETL for claims data Integrations.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Performed data analysis using SQL Reporting, prepared datasets supporting development of data products.
• Responsible for creating and changing the visualizations in Power BI reports and hierarchies using Bar charts and Pie charts according to the client requests.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosstabs and chart.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Extensive use of Data Analysis Expressions (DAX) expressions in tabular models as per business requirements.
• Developed a Executive level dashboards using Tableau 9.0.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS).

Environment: Microsoft SQL Server 2012/2008, MS Access, BIDS, SSDT, HTML, Visual Studio 2008/2010,TSQL, Power Shell, Power BI, SQL Profiler, Team Foundation Server (TFS).