SUMMARY:

• Over 10+ Years of IT experience as Business Intelligence Developer and Data Analyst.
• Business Analysis, Database Designing and Development using Confidential SQL Server providing Business Intelligence solutions for Data Warehousing Applications using Confidential BI Stack.
• Worked extensively on System Analysis, Design, Development, Testing and Implementation of projects in Software Development Life Cycle.
• Experience includes thorough Domain knowledge of Health Care, Business Financial system, Manufacturing, Banking and Accounting.
• Lead both Development and Maintenance teams by coordinating with the Business stakeholders and other vendors by ensuring the deadlines are met.
• Experience in drafting the Functional and Technical specifications for a business problem.
• Excellent working Experience on SQL Server, SSIS, SSAS, SSRS, MDX, DAX, ASP.Net, C#.NET, VB.NET, MS EXCEL, CRYSTAL Reports and POWER BI.
• In Depth Knowledge in both Multidimensional(UDM/BISM) and Relational Modeling.
• Expert in writing T - SQL/PL-SQL Queries, MDX and DAX.
• Expert in building SSAS Cube and related objects Dimensions, Hierarchies, Attribute relations, KPIs, Perspectives, Aggregations, Calculations and Roles.
• Expert in implementing Currency Conversion dimensions and Translations in SSAS Cube.
• Expert in maintaining SSAS cube with Dynamic Partitioning, efficient cube processing techniques, adding dimension attributes and custom hierarchies according to the business requirement.
• Expert in improving performance of cube by using Aggregations and by implementing MDX Query Tuning techniques.
• Expert in implementing and optimizing Many-to-Many relationships in the data model for OLAP DB.
• Experience in developing data models with Power pivot, SSAS Tabular Model along with DAX.
• Experience in Architecting Data Warehouse and Extraction, Transformation, and Loading (ETL) process for complex business that gets data from various sources into Data Warehouse and designing Data Marts out of warehouse.
• In Depth Knowledge in creating Logical Data Model & Physical Data Model by understanding Business using Visio / ER Modelling tool.
• Expert in creating Indexes, Views, complex Stored Procedures, Table Partitioning’s, Functions, CLR Stored procedures, CDC, Columnar Indexes to facilitate efficient data manipulation and data consistency.
• Excellent knowledge in Creating SSIS packages with data from Excel, Flat file, Oracle, SAP systems to MS SQL Server by using SSIS Packages.
• Expert in implementing Bulk Insertions, Error Handling, Logging, Configurations, Creating Jobs, Scheduling using windows and SQL Server Agent, Notification mails (HTML - Email notifications).
• Experience in Implementing Query Optimization Techniques of T-SQL queries, In Memory concepts in SQL Server, Performance improvement of SSIS Packages, SSAS Multidimensional Cubes (processing & querying) and SSRS Reports.
• Extensive experience in Development and Deployment of Reports using SSRS. Developed Custom/Dynamic reports, Different types of Tabular, Matrix Reports, and Drill down reports, Parameterized reports, Sub reports, Subscriptions.
• Expert in writing C#.NET, VB.NET which can be used to write custom code through Script Component in SSIS and SSRS.
• Expert in designing and developing dashboards in Power BI and modelling data required for dashboard using Power query.
• Expert in configuring on On-Premises Data Gateway for Power BI on Windows Server 2012 R2.
• Expert in handling Source Control tools like Visual Source Safe (VSS); Team Foundation Server (TFS).
• Expert in using Excel functions, Macros, VBA Programming, debugging, VLOOKUP’s.
• Strong Initiative and excellent project management skills & in mentoring team members and conducting training sessions.

TECHNICAL SKILLS:

Relational Databases: SQL Server 2012, 2008/2005/2000, MS Access .

Tools: and Packages: SQL Server Management studio, SSAS, SSIS, SSRS, Confidential Visual Source Safe, ASP.NET, Visual Source Team Foundation, Power BI, Power Query, Power Pivot.

Languages: T-SQL, PL/SQL, VB.Net, C#.Net, HTML, JAVASCRIPT.

Operating Systems: Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS, Windows Server 2008.

Web Technologies: HTML, XML, XSL, JavaScript, IIS(4.0/5.0/6/0).

Application Packages: MS Office, MS Access, PowerPivot, Power View, MS Outlook ( Confidential Office Suite)

Version Control: TFS, Visual Source Safe, CC Harvest .

PROFESSIONAL EXPERIENCE:

Confidential, Irving, Texas

DW Architect

• Architecting the DW Design project.
• Understanding various Data Sources/Data Models.
• Design the Logical(ER) Model and Physical Model to achieve the desired (star) schema model.
• Design and develop ETL process for integration of data from various sources.
• Create the SSAS Multidimensional cube using star schema and creating various calculations used in the report using MDX.
• Design and develop SSRS reports to show the health of data loading into DW.
• Effective management of the Measure groups by the effective usage of partitions and aggregations.
• Tune the performance of the SQL Tables/Partitions and improve the Cube Processing time from the CUBE.
• Writing custom code using C#.Net code in some specific script tasks for SSIS packages.
• Writing custom code using VB.Net for SSRS Custom report functions.
• Created Dashboards, Reports using Power BI.
• Periodical review of the code and helping the development team in maintaining coding standards.
• Maintaining project metrics and monitoring the project performance.
• Design and Develop the Standard SSIS Template used across the project required for Data loading and Used these standard SSIS packages to extract, transform and load from various data sources to data mart and generated flat files to be sent to vendors.
• Troubleshooting or debugging using SQL Profiler for monitoring and optimization of SQL/MDX Queries.
• Using AMO library to create aggregations for each partition and managing the cube to process large dimension efficiently.
• Scheduling the packages using SQL Server agent and Windows Scheduler.
• Design and Develop Data marts tailored to specific downstream reporting purposes.
• Participated in Build (weekly/monthly) and deployment activities of all the components.
• Designed and Developed SSAS Cube from the data warehouse built.
• Involved in writing Effective MDX queries, Develop SSRS reports (Business Reports).
• Enhancing Dimension/Measure group partitions processing performance.
• Improved Performance of Relational sources using SQL Server using indexes, Table partitioning etc.
• Designed dashboard using Power BI Desktop for Forterra main LOB.
• Design, Develop and Deployment of Power BI Bubble maps and configured On-Premises Data Gateway for data refresh(scheduled) on Power BI Maps.
• Published Power BI dashboard on Mobile application.
• Published SSAS Cube over HTTPS through IIS on windows server for SAP BO reports.

Confidential, PA

Team Lead

• Lead the team in Requirements gathering architected the design, coding and testing.
• Providing the effort estimates for the projects and Preparing BRD, FRD and TDD documents.
• Responsible for initiating the meetings with business stakeholders in understanding the source systems and analyzing the data feeds for integration.
• Designed the Logical Data Model & Physical Data Model using ER tool.
• Periodical review of the code and helping the development team in maintaining coding standards.
• Maintaining project metrics and monitoring the project performance.
• Design and Develop the Standard SSIS Template used across the project required for Data loading and Used these standard SSIS packages to extract, transform and load from various data sources to data mart and generated flat files to be sent to vendors.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL code.
• Scheduling of the packages using SQL Server agent.
• Design and Develop Data marts tailored to specific downstream.
• Design, Develop and Deployment Cube using SSAS.
• Participated in Build and deployment activities of all the components.
• Involved in writing MDX queries, Develop SSRS reports.
• Enhancing Dimension processing performance and Partition Processing Performance.
• Improved Performance of Relational sources using SQL Server using indexes, Table partitioning etc.
• Mentoring and taking application/technical sessions to juniors in the team.
• Data modelling for Power BI reports.
• Designed, Developed and Published Power BI Reports, Power BI Dashboard - POC.

Confidential, Redmond, WA

Senior BI Developer

• Created and tuned complex SQL Queries, stored procedures, views, tables and database objects as per the Design on TDD
• Extensively worked on designing reports using SQL Server Reporting Services (SSRS).
• Involved in Designing, Development and Deploying of all objects related to Cube using SSAS.
• Coordinated with business users and implemented OEM Cube enhancements and performance tuning related to cube processing.
• Created Partitions in SQL Server & OEM Cube to improve performance.
• Involved in creating Dimensional model.
• Writing MDX queries for Querying and Calculation purposes etc.
• Involved in Enhancing Dimension processing performance and Partition Processing Performance.
• Improved Performance of Relational sources like SQL Server using indexes, Table partitioning etc.
• Composed of test strategies (which support/enhance the development methodology), test cases and test results

Confidential, Redmond, WA

Senior BI Developer

• Involved in Requirement gathering, Designing, and Development of Factory (Distribution) database.
• Involved in Acquisition of data from various data sources to Staging database and integration.
• Involved in designing, development and deploying of all objects related to Cube using SSAS.
• Designed and developed SSRS Reports using SSAS cube as source.
• Responsible for the developing of Stored Procedures, SQL Jobs.
• Improving performance of SQL queries using indexes, Table partitioning etc.
• Involved in Performance tuning of CUBE processing and MDX Queries.
• Created SSIS packages to transfer data between OLTP and OLAP databases
• Co-coordinating with all the dependent application teams during the implementation window.

Confidential, Cincinnati, OH

BI Developer

• Involved in requirement gathering, designing, and development of database.
• Migration of historical data into the database using SSIS.
• Responsible for the designing of SQL queries, Stored Procedures and Scripts.
• Designing and developing of business reports using SSRS.

Confidential

Developer

• Involved in requirement gathering, designing, and development of data warehouse environment.
• Responsible for designing of Dimensions, Measure groups, KPIs, Partitions.
• Involved in writing MDX queries.
• Responsible for the designing of SQL queries, Stored Procedures and Scripts. Performed major aspects of database administration, including data modeling, backups restore, Log shipping
• Providing consultation on SQL Server to our development teams.
• Developed mappings that incorporated logic needed to handle inserts and updates to the existing targets.
• Did Macro programming for excel in reports
• Composed of test strategies (which support/enhance the development methodology), test cases and test results
• Updating cubes like dimension hierarchies and loading the latest data in fact tables and optimizing the performance cubes.

Confidential

Developer

• Understanding Requirements of Administrative module in the project.
• Designing & creating relational database objects.
• Develop reports using Crystal Reports and SSRS.
• Responsible for the designing of SQL queries and Stored Procedures.
• Supporting application programmers in the testing of database applications.
• Designing of HTML forms.
• Deploying and maintaining the application.
• Customization of the application for the use of various departments like Finance, MIS, Communications, HR.

Confidential

Developer

• Involved in Enhancements and Maintenance of the project, Database.
• Involved in writing client side validations using JavaScript.
• Used ADO.Net to access the data from database application.
• Involved in Writing SQL queries and Stored Procedures.
• Integrated the third party tool for generating dynamic PDF reports.
• I was Involved in the development of Financial Mission module.
• Develop reports using CRYSTAL Reports and integrate in Application.