SUMMARY

• Over 12 years of experience in SQL Server T - SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing, SQL joins, performance tuning and query optimization.
• Strong in Data warehouse concepts, dimensional star schema and snow flake schema methodologies.
• Expertise in creating reports, complex dashboards using Power BI Desktop and maintaining Power BI dashboards on server.
• Experience in connecting to different data sources like Oracle, SQL server and Microsoft Excel using Power BI.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Teradata, Sybase, Flat File and MS Access.
• Experience on Developing and Publishing Power BI reports on dashboards in Power BI Server.
• Extensively used Erwin for Logical Data Modeling, Physical Data Modeling, Forward engineering, Reverse engineering and model to model comparison.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.
• Intensive experience as a scrum master to lead and guide all the team members in all the meetings proposed by agile like pre-planning meeting, planning, daily scrum, review and retrospective meetings.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.
• Self-practiced in designing and developing Data Integration applications using Azure SQL DW, Data Lake and Data factory.

TECHNICAL SKILLS

• Microsoft SQL Server 2012/2008-R2/2008/2005
• MS SQL Server Integration Services (SSIS)
• MS SQL Server Reporting Services (SSRS)
• MS SQL Server Analysis Services (SSAS)
• T-SQL
• PL-SQL
• Erwin Data Modeler v7.0/v4.x
• MS SharePoint
• Microsoft Visual studio
• TFS
• PL/SQL
• GIT Hub
• Tortoise SVN
• Crystal Reports
• Power BI
• DAX
• Netezza
• Microsoft Access
• C#
• Visual Basic 6.0 and Microsoft Visio. Have conceptual knowledge on Azure (SQL DW
• Data Lake & Data factory).

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Lead MSBI Developer /Sr. Power BI Engineer

Responsibilities:

• Responsible for different client internal applications, participate in requirement gathering by interacting with various client business groups, walkthrough sessions and analyze them for feasibility.
• Preparation of detailed design document for various components of the project, based on the Requirements.
• Create, maintain and deploy SSAS cubes.
• Enhancing the SSAS cubes by creating calculations and measures.
• Participate in estimation of work efforts, business intake meetings for new enhancements and budget approvals.
• Prepare and publish weekly, monthly status reports to the leadership team.
• Develop enterprise ETL solutions using SQL Server integration services to extract, transform and load the data into Datawarehouse.
• Develop the Power BI reports, dashboards using visualization charts.
• Develop complex calculated measures using Data Analysis Expression Language (DAX).
• Requirement gathering for new reports from leadership team.
• Responsible for all the code deployments, change request creations and approvals.
• Testing of various functionalities of the application to ensure that those will perform the
• Desired actions as outlined in the requirement.
• Addressing all queries from business and end users related to the applications.

Tools: & Technologies:Microsoft SQL Server 2017/2012, SSIS, DAX, Power BI, TFS and GIT Hub.

Confidential, Chicago, IL

Senior MSBI Developer/Power BI Consultant

Responsibilities:

• Created Database schema, tables, writing complex stored procedures and views.
• Worked extensively on SSIS packages to transfer data between Staging database and DW.
• Worked on ELT for bulk load source files for staging into DW.
• Created data warehouse modeling with Star/snow flake schema using SQL server analysis services (SSAS).
• Created user interface web pages using .net and JavaScript.
• Created SSAS cubes and processed, deployed on server for data pre-calculated aggregations, KPI’s which can be modeled into reports accordingly.
• Created SSRS reports using OLAP/OLTP.
• Used Power BI power Pivot to develop data analysis prototype, power view and power Map to visualize reports.
• Created Roles and implemented row level security for user authentication in Power BI.
• Chart, gauge, pie chart and Tree map.
• Responsible for creating and changing the visualization in Power BI reports and Dashboards.
• Implemented SQL CLR and created windows service for SQL agent job automation.
• Received client appreciation for implementing the best approach to automate the SQL jobs.

Tools: & Technologies:Microsoft Visual Studio 2013, Microsoft SQL Server 2012/2008-R2, SSIS, SSRS, SSAS, Power BI, JavaScript, SVN and Aginity workbench for Netezza.

Confidential, Philadelphia, PA

Sr. MS SQL BI Consultant/ DWH Developer/ETL Developer

Responsibilities:

• Worked in T-SQL to create Tables, Function and Stored Procedures, View, sub-query, correlated sub-query, complex Stored Procedures and ad-hoc TSQL statement
• Performance monitored and tuned TSQL queries using SQL Profiler and database engine tuning advisor
• Created SSIS packages to transfer data between Staging database and DW.
• Worked with the ETL architect and lead to ensure ETL developers have the required data schema and metadata information and participate in knowledge transfer with the goal to remove any knowledge gaps that might exist.
• Implemented logical and physical data model for AML OLAP reporting schema using Erwin Data Modeler.
• Using SDLC method document all SSIS packages and Stored procedure.
• Creating Change requests for Production deployment.
• Team Foundation server task management.
• Monitoring the Database Users, roles and Active Directory groups and permissions.

Tools: & Technologies:Microsoft Visual Studio 2013, Microsoft SQL Server 2012/2008-R2/2008, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Erwin Data Modeler v7.0/v4.x, MS SharePoint and TFS.

Confidential, St. Louis, MO

Senior MS SQL BI Developer/SSIS/Database Architect.

Responsibilities:

• Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Designed and developed Data Models using Power Designer and also responsible for Forward and Reverse Engineering of data models.
• Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into 4 Weeks "sprints."
• Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views, Index.
• Created and updated stored procedures and functions to meet the requirements and changes specified by the users.
• Worked on performance tuning of T-SQL scripts.
• Highly responsible for scheduling and delivery of jobs using SQL Server Agent.
• Formulated and documented the ETL (SSIS) process design based on business requirements and system specifications with strong ETL (SSIS) design skills, including source to target mappings, transformations, look ups, aggregations, and expressions.
• Extracted data using SSIS 2012 from Oracle and Excel Files.

Tools: & Technologies:Microsoft SQL Server 2012, Microsoft SQL Server 2008 R2, MS SQL Server Integration Services, SQL Profiler, Power Designer, MS SQL Server Reporting Services, MS SQL Server Analysis Services, Microsoft Visual Studio 2010.

Confidential, Dallas, TX

MS SQL Server/SSRIS Developer/Crystal Reports Developer

Responsibilities:

• Worked in T-SQL to create Tables, Function and Stored Procedures, View, sub-query, correlated sub-query, complex Stored Procedures and ad-hoc TSQL statement
• Performance monitored and tuned TSQL queries using SQL Profiler and database engine tuning advisor
• Designing development, implementing and maintenance Crystal and Investran reports using Investran reports wizard.
• Contributing to documentation, group knowledge sharing and best practices initiatives.
• Designed and developed the staging databases and loaded from source to staging and from staging to the destination tables applying different transformations.
• Utilized several transformations like Lookup, Fuzzy lookup for implementing the transformation logic in the packages.
• Coordinate with team members and cross-functional team members, both onshore and offshore for solutions and development tasks on projects.
• Configured the report viewing security for various users Confidential various levels using Report Manager.

Tools: & Technologies:Microsoft SQL Server 2005, MS SQL Server Integration Services, MS SQL Server Reporting Services, Crystal reports XI and Investran Report wizard.

Confidential, Dallas, TX

MS SQL Server Developer/SSRS Developer/Crystal Reports

Responsibilities:

• Developed reports using efficient data retrieval techniques and tested the reports.
• Created Cross-Tab, Drill-down and Sub-Report using SSRS 2008.
• Responsible for stylish Report Layouts and Deployed the Reports using SSRS 2008.
• Identified and worked with Parameters using complex expressions for parameterized reports and managed report subscription in SSRS 2008.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Wrote Complex Stored Procedures, Triggers, Views and Queries.
• Writing standard and complex t-SQL queries to perform data validation and graph validation to make sure test results matched back to expected result base on business requirements.
• Used execution plan, SQL profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Created various DB objects like indexes, Constraints, views etc.

Tools: & Technologies:MS SQL Server 2008, Crystal Reports XI, SSIS, T-SQL, MS Visual Studio 2008.

Confidential

MS SQL Server/Crystal Report Developer

Responsibilities:

• Worked as an end to end developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Developed various T-SQL stored procedures, functions and packages.
• Designed all the Module User interface using the VB.Net and Accpac Interface.

Tools: & Technologies:MS SQL Server 2005, T-SQL, VB.Net, Crystal Reports and Sage Accpac.