SUMMARY:

• Over 8 years of IT experience in Analysis, Design, Implementation and Administration of Business Intelligence Solutions with Microsoft SQL Server 2016/2012/2008 with various business domains like Financial, Banking sector, Retail order management
• Experience in SDLC methodologies & Agile/Waterfall project methodologies in Analysis, Design, Development, Testing and Implementation of client - server based applications.
• Excellent T-SQL Development Skills to write Complex Queries involving Multiple Tables, great ability to Develop and Maintain Stored Procedures, Triggers, User Defined Functions, Views
• Experience in writing complex SQL queries involving Inner and Outer joins, Temp Tables, Global Temp Tables, Derived Columns and Experienced in working on ANSI (ANSI-American National Standards Institute )
• Worked on all Components of Power BI like Power Query, Power Pivot, Power view, Power Map
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Knowledge on Azure Data Lake (ADL) Storage and Azure Data Lake (ADL) Analytics.
• Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI
• Created Content Packs and configured Personal Gateway using Power BI Service
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Excellent Analytical, Problem-solving Skills, and Communication Skills, a Motivated Team-player with Excellent Inter-Personal Skills
• Well versed with Tuning SQL Queries & Stored Procedures to improve performance
• Extensive experience in T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS and Data Warehousing
• Extensive experience in SQL Server Integration Services (SSIS) and Reporting Services (SSRS) and experience creating Drill-down and Drill-through Reports, writing Expressions in SSRS and Fine-tuning Reports
• Expert in creating Simple to Parameterized Dynamic Reports and Complex Reports including Tabular Reports, Matrix Reports, Charts, Graphs, and Sub-reports using SSRS in Business Intelligence Development Studio (BIDS)/Data Tools
• Experience in Creation, Configuration, Development, and Deployment on various servers of Reports using SSRS
• Expertise in Extract, Transform and Load (ETL) using SQL Server Integration Services (SSIS) Packages for integrating data using OLEDB connection from varied sources by using multiple transformations including Data Conversion, Conditional Split, Bulk Insert, Merge and Union All
• Experience in Dimensional Data Modeling and Cube Development, Designing of STAR, SNOW FLAKE Schemas, Partition, Aggregation and Optimization using SSAS
• Expert in designing Crystal reports, Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012/2014 ) and Excel Pivot
• Created SSRS projects and reports in BIDS, sort and toggle object visibility to modified report, assigned item level permissions and site security roles, created report schedules and subscriptions.
• Extensive experience in SQL Server Analysis Services (SSAS) Tabular Model.
• Highly skilled in developing OLAP cubes using SSAS 2005/2008/2012/2014 , calculating measures, measure groups and dimension members in SQL Server Analysis Services using multi-dimensional expression (MDX), mathematical formulae, and user-defined functions
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Physical & Logical Data Modeling- Relational, Multi-Dimensional Modeling Star Schema Modeling, Snow-Flake Modeling DSV diagrams, Fact and Dimensions Tables using Analysis Services.

TECHNICAL SKILLS:

Databases Tools: Business Intelligence Development Studio, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service, SQL Server Management Studio

ETL Tools: DTS Data Transformation Services Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Report, Tableau PowerBI

Database: SQL Server 2011, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, MS Access, ORACLE 10g/11g, My SQL

Programming: SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, MS Access, ORACLE 10g/11g, My SQL, T-SQL, PL-SQL, C

Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation), CSS

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

Other Tools: MS WORD, MS EXCEL, MS VISIO, MS Power Point, OLAP & OLTP

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, TX

SQL BI Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Worked on all Components of Power BI like Power Query, Power Pivot, Power view, Power Map
• Extract the data sets from various data sources like Excel, SQL Server, SQL Server Analysis Services (SSAS) and Oracle TOAD.
• Applied various transformations like Change Type, Append and Merge queries on data sets in Power Query
• Identified the relationship between data sets in Modelling phase
• Created different kinds of visualizations like Bar charts, Line chart, Gauge charts, Funnel charts, KPI’s and slicers in Power BI Desktop
• Created APPS in Power BI Service gave access permissions and Published to my APP Workspace
• Created and Modified Content Packs using Power BI Service
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).

Environment: SQL Server 2012 Enterprise Edition, T-SQL, SSIS, SSAS, Power BI

Confidential, Dallas, TX

SQL Developer

Responsibilities:

• Involved in SDLC of the project from requirements gathering from Business users to perform technical design, development and testing.
• Worked extensively in writing and debugging complex stored procedures, views, triggers and user-defined functions
• Designed the Data warehouse and done the mappings from Source to the Target tables.
• Worked extensively on SSIS packages to implement the data load strategy
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Proven Power BI development experience with desktop and Pro versions. Familiarity with DirectQuery functionality within Power BI
• Development of Microsoft Power BI dashboards and dashboard templates
• Provide analytical, complex and specialized client service analysis using PowerBI dashboards
• Experience developing and supporting Microsoft BI and reporting capabilities (PowerPivot, PowerBI, PowerView, SQL Server Reporting Services) Experience implementing enterprise software solutions
• Deployed SSIS packages into various Environments (Development, Test and PROD) using Deployment Utility.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent
• Formatted/Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse
• Identified the dimension, fact tables and designed the Data-Mart using Star schema
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2012 Analysis Services.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access
• Worked with SQL queries using MS Access for data manipulations
• Wrote T-SQL queries, Stored Procedures and used them to build packages
• Responsible for Import and export data from various data sources like SQL Server Databases, Flat Files, MS Access, MS Excel and other OLE DB providers achieved through Importing and Export Wizard in SSIS
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2012
• Developed complex T SQL code for Customer Imports and other interfaces for the PAT and Portal.
• Created and Maintained various database in MS Access to track activities and progress.
• Involved in Dimensional Data Modeling and Cube partitioning in SSAS
• Generated multi parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports; thus making them user friendly.
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS.
• Created and Maintained various database in MS Access to track activities and progress.
• Worked on several complex drilldown, parameterized reports and on reports that call sub reports using SSRS.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs.
• Optimized the queries by creating various clustered, non-clustered indexes and indexed views
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Provided daily support to the user team as well as technical team for system wide tasks including monitoring, alerting and problem resolution
• Involved in testing, bug fixing and documenting the work for the project Confidential each and every phase

Environment: MS SQL Server 2012/2008/R2, DTS, PowerBI, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio(BIDS), T-SQL, MS-Access, SQL Server Query Analyzer, ETL, Erwin, Red Gate SQL Source Control.

Confidential, Dallas, TX

MSBI Developer

Responsibilities:

• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Successfully migrated data from CRM Saratoga to Pivotal component using SSIS.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2012 using SSIS.
• Created different kinds of visualizations like Bar charts, Line chart, Gauge charts, Funnel charts, KPI’s and slicers in Power BI Desktop
• Created various reports in Power BI desktop and published to the Power BI Service
• Created and when required, modified already existing stored procedures, triggers, views, indexes.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Created SSIS packages to retrieve data from Legacy sources, retrieve user data from the Flat files on monthly and weekly basis, File Transfer from one location to the other using FTP task.
• Used Kimball methodology to create data warehouse using SSIS
• Worked on Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Report Design.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Designed Dashboards using web Focus
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2008 R2.

Environment: MS SQL Server 2008R2/2012, SQL server Reporting Services 2008R2, Power BI, SSIS, SSAS, PL/SQL, VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, TFS, CRM Saratoga and Pivotal.

Confidential, Alden, NY

SQL BI Developer (T-Sql/SSRS/SSIS)

Responsibilities:

• Developed data model based on the BA’s and the reporting Team using SSAS, SSRS.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Building UAT and Test environments using Production backups.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data.
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
• Maintained production OLAP cubes, wrote MDX queries to generate reports using SQL Server 2008 Reporting Services (SSRS).
• Migrated DTS objects to SQL Server Integrated Services environment, migrated data from SAS environment to SQL Server 2008 via SQL Server Integrated Services
• Querying and manipulating multidimensional cube data through MDX Scripting.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Analyze historical trends, identify issues and analyze root cause on ProClarity Dashboard.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Wrote store procedures to generate account statements for different types of accounts
• Involved in migration of SSRS from SQL 2005 to SQL 2008
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005/2008 R2/2012 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, MS Access, Oracle 9i, Sybase.

Confidential, Southlake, TX

MS SSRS/SQL BI Developer

Responsibilities:

• Worked extensively on installation, upgrade and configuration of MS SQL Server 2005/2008 databases servers.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Worked with business/functional analysts to determine reports and analytical requirements.
• Created Reports with latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc.
• Documented Report Models and Report Templates for other Team Members.
• Created Prototypes of some complex reports and validated from the production.
• Developed Use Case Documents and Technical Documentation for some reports to Hand-off to the Offshore Development Team.
• Categorized reports into batch reports and on demand reports and scheduled it according to that.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Hands on experience with working on Microsoft dynamics and created reports based on the customer requirements.
• Worked in Agile environment
• Developed complex queries, stored procedures, views, and constraints, triggers using inner and outer joins, unions, and SQL Statements for various applications in different environments.
• Worked on Database space management, performance monitoring and alert management.
• Worked with business analysts and testers to manage the data as a part of data modelling
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL.
• Experienced in loading data from the legacy systems into MS SQL server 2005 using SSIS packages.
• Worked on Team Foundation Server (TFS) to maintain the web application portal for reporting services
• Created user variables, property expressions, script task in SSIS.
• Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.
• Business Objects: Responsible for Coordinating with Application Developers in the integration and utilization of Crystal Tools in the development of applications.
• Modify report content and export reports in multiple formats based on user input in Crystal
• Hands on experience with Business Objects life cycle implementations.

Environment: SQL Server 2005/2000, Business Intelligence Tool 2005, Visual Studio 2003, DTS/SSIS, T-SQL, Unix, Shell scripts, Oracle 10g.

Confidential, Charlotte NC

SQL Server Developer/SQL Server DBA

Responsibilities:

• Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Worked with SQL queries using MS Access for data manipulations.
• Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
• Involved in the development of custom stored procedures, functions, triggers, SQL, T-SQL.
• Worked on advanced dimension Design and Cube design.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.

Environment: SQL Server 20 (2003, 64-bit edition of SQL server 2000), DTS, Crystal Reports, Microsoft Business Intelligence Development Studio, T-SQL, MS-Access, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, SSAS, ERWIN.

Confidential

.Net and SQL Developer

Responsibilities:

• Involved in gathering of all the requirements for the project. Implemented the SDLC concept.
• Used Rational Rose for UML diagrams and ER diagrams.
• Developed a web application using C#.net and ASP.net.
• Created user controls for login pages and also used validation controls.
• Provided authorization to control user access to application features.
• ADO.net data accessing using stored procedures.
• Created tables and wrote stored procedures using SQL Server 2000.
• Developed web services and consumed them in the project.
• Created Reports and designed graphical representation of analyzed data.
• Designed screen shots for the frontend users and also handled the backend.
• Involved in checking of coding standards and code review for application code.
• Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Access, MS Excel and Flat Files and Oracle databases.
• Designed and developed Complex SSIS packages for auditing using SQL SERVER 2005 Integration Services (SSIS).
• Developed reports in SQL Server Reporting Services.
• Validated and modified the data using different Data Flow Transformations like Send Mail, Web Services, File System Task, Conditional Split, Lookup, Term Extraction, Pivot, Multi-Cast, Derived Column, Audit, and Data Conversion etc.
• Worked with different Control Flow elements like for Loop Container, For each Loop Container etc.
• Involved in Maintenance and Deployment of SSIS Packages.
• Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
• Created Complex Stored Procedures and automated them using SQL Server Agent.
• Created Triggers (Instead of and After) for Auditing Purpose.
• Created Views and Indexed Views for the Performance Tuning.
• Performed validations in Excel by creating pivot tables.
• Prepared detailed documentation for the business requirements.

Environment: C#.net, ASP.net, Rational Rose, Crystal Reports, Web Services, ADO.net. SQL Server 2008, DTS, SSIS, SSRS, SQL Server OLAP 2008, Reporting Services 2008, T-SQL, MS Access, Windows 2003 Server.