SUMMARY

• Microsoft Certified (MCSE) MSBI Lead/Developer with 13 years of experience in various Retail, al, Energy Utilities and financial,automobile industries.
• Experience in Data warehousing tools like SSIS,SSRS,SSAS
• Dimensional Modelling - Star Schema design and implementation.
• Designing and developing PowerBI reports and dashboards.
• Experience in Data Marts, Data warehousing, OLAP using the Dimensional Modeling techniques such as Star schema and Snow flake schema, Fact and Dimension Tables using Multi-Dimensional Analysis Services (SSAS).
• Experience in Data modelling for the enterprise data warehouse.
• Datamodelling using Power designer/Erwin
• Executed end-to-end data quality controls and reports.
• Understanding in cloud -Microsoft azure like Azure data lake and data bricks and azure data warehouse.
• Developed and maintained end-to-end data quality controls and reports, including new metrics and control models in accordance with business/regulatory requirements.
• Experience in framing ETL jobs and design
• Experience in Performance tuning in database level, ETL and analytical model by following approaches like Partitioning, indexing, etc.
• Experience in various software programming and record management tools.
• Experience with using of agile methodology for Project management.
• Good experience in delivering OLAP solutions by developing Confidential Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Developed Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model using Report Builder.
• Expertise in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS 2012/2008R2/2008.
• Created different types of reports such as Conditional, Drill-down, Summary and Sub reports, and formatted them and Performed unit testing at various levels.
• Defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, partition and aggregation using SQL Server Analysis Services.
• Experience in migration of SSRS reports from SQL 2005toSQL 2008.
• Experience in Microsoft APS parallel Datawarehouse(PDW) and Alteryx.
• Good experience in delivering OLAP solutions by developing Confidential Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.

TECHNICAL SKILLS

ETL tools: SSIS, Alteryx

Reporting Tools: SSRS, Crystal reports,owerBI

Programming Languages: C#, VB, VB.NET

Scripting Language: PowerShell, UNIX

Databases: SQL Server, Oracle, Netezza,APS

Utilities: Jira, Service Now, Rally

Version Control Tools: TFS, ACCUREV, GITHUB

PROFESSIONAL EXPERIENCE

Technology Consultant

Confidential, Michigan

Responsibilities:

• Elicit the new/Changed Requirements by coordinating with the business.
• Prepare and Review the Design artifact.
• Conduct Code & Functional reviews for the team.
• Identify the reusable components, Database Design.
• Participated in design sessions and provided value feedback and suggestions to improve the design.
• Datamodelling using Power designer/Erwin
• Organizational standards maintainability and documentations,
• Analyzing issues or defects encountered in production data and reporting.
• Work on to Confidential (GOTD) program with Confidential Bank and Order Confidential (OAR) applications.
• Provide Application Development and Support for database and service capabilities that permit the retention of key vehicle order management and order generation data.
• Wok with the data will be used to analyze order generation capabilities, permit the visualization of key measures, provide inventory information for unique marketing and sales customer experiences, and to identify opportunities for business and technical improvements.
• Develop and support Microsoft SQL server 2012 or later and SSIS.
• Dimensional Modelling - Star Schema design and implementation.
• Designing and developing PowerBI reports and dashboards.
• Use SQL Server Integration Services (SSIS), including Package Automation across environments, Package Configuration encryption, Logging and Error handling, Microsoft SQL Server Analytics development experience, Implementation of Relation data warehouses.
• Responsible for troubleshooting in analytics environment.
• Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Alone designed, developed and deployed the project and also developed and published the reports based on the business needs.
• Supported several projects by recreating packages, troubleshooting failures etc.
• Created SSRS Reports for reconciliation purpose.
• Worked on creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Deployed and Generated SSRS reports using the Reporting Services and Report Manager.
• Design and development of SSAS cubes.

MSBI Lead

Confidential, New jersey

Responsibilities:

• Analyze & understand the requirements.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Worked on SSAS storage and partitions, and Aggregations, calculation of queries with MDX, developing reports using MDX and SQL.
• Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment (SSAS).
• Designed Cube partitioning and incremental synchronization for SSAS cubes.
• Used various SSIS control flow tasks such as Execute SQL task, File system task, for each loop, and sequence containers, send-mail task.
• Designed reports, Graphs and deployed reports to web applications using SSRS.
• Developed Power pivot, Power View reports based on the requirements.
• Created SharePoint site and published reports on SharePoint site.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
• Worked in Microsoft azure cloud environment.
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes using dimensional modeling standards in SQL server.
• Implemented SSAS Cubes, Facts and Dimension tables to perform analysis services.
• Gathered report requirements and determined the best solution to provide the results in a Reporting Services.
• Designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Created Parameterized reports and Linked reports with thorough knowledge of reporting service.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes
• Experience in PowerBI reports.

MSBI Lead Developer

Confidential

Responsibilities:

• Coordinated and designed data flow capturing.
• Setting new protocols and their implementation for Defect Prevention in deliverables.
• Major responsibilities include getting requirements from the user, writing stored procedures for reports and developing reports using SSRS. Maintaining proper documentation of the reports for future .
• Involved in writing complex stored procedures to get data from database.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.
• Gathered business requirements from business users and clients to develop various reports.
• Migrated data from Heterogeneous data sources (Excel, Flat File and CSV file) to centralized SQL server database using SQL server integration services (SSIS) to overcome transformation constraints.
• Used various SSIS control flow tasks such as Execute SQL task, File system task, for each loop, and sequence containers, send-mail task.

Technology Analyst

Confidential

Responsibilities:

• Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment
• For accessing and translating data into understandable and usable business information using SSAS.
• Carried out Production support which involves the daily data loads and report generations.
• Fix production faults and meet the support SLA’s for fixing the production issues.
• Implemented the Error handling in the Stored Procedures and also Modified existing stored procedures according to the requirement.
• Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Technology Analyst

Confidential

Responsibilities:

• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Wrote queries for Drill down reports to get the dataset required to build the report and Created Tablix, Drill down and drill through reports, multi value parameter reports.
• Identified and included report parameters for parameterized report.
• Wrote complex SQL queries and procedures to create reports using SSRS from the relational database.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like Data Filtering, Adding Interactivity, Deploying Reports to report server using SSRS.
• Created SSRS Data Model projects using Microsoft Visual Studio and using Report Builder for report server to create reports.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
• Configured the report server and generated the report models for user interactions.
• Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.
• Developed and maintained system documentation, diagrams and flowcharts.
• Worked with project manager and technical leads for resolution of technical issues.
• Tested and analyzes each component/phase of the systems development life cycle including the requirements, design and development.
• Elicit the new/Changed Requirements by coordinating with the business.
• Identify the reusable components, Database Design.
• Prepare and Review the Design artifact.

Software Engineer

Confidential

Responsibilities:

• Developing User reports using Crystal reports
• Database Maintenance
• Developing complex stored procedures in SQL server.
• Migration of Sql server 2000 to 2005
• Project Implementation and Support
• Sustained Process Compliance throughout the Project
• Developed, deployed, and monitored SSIS Packages.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Unit testing and SIT
• Performance Tuning
• Create user guide for end user.