SUMMARY

• A highly proficient Power Bi / ETL Developer / DBA with over 5 years of experience in ETL packages, design, development, stored procedures, data warehouse, Business Intelligence, SSIS/, T - SQL, MS SQL Server 2017/2016/2014/ 2012 and extensive experience in working with Agile methodology.
• Strong experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation.
• Experience in coordinating with users in gathering source data files, defining data elements, business rules, data, and process flow documentation, prepare High level and Low-level design documents.
• Experience with software development life cycle (SDLC), Agile Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Hands on experience in monitoring SQL Server Performance tuning in SQL Server 2012/2014/2016/2017 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Knowledge of Relational Database Management systems.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization.
• Install and Configure SQL Server 2005, 2008, 2008R2 on Virtual Machines.
• Expert in designing ETL data flows using creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Can-Do, Will-Do Attitude, Problem solving, Self-directed, Ability to learn new tools and use them
• Proficient in SQL Server and T- SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.
• Experience in Object Oriented Analysis concept implementation, design and programming technical skills.
• Extensive Experience Develop visual reports, dashboards and KPI scorecards using Power BI desktop.

TECHNICAL SKILLS

Data Modeling: Star & Snow- flakes schema, Fact & Dimension Table, Power Bi

Reporting: Crystal Report, SSRS, Power Bi

DBATools: SQL, PL/SQL, T-SQL

Office Tools: MS Word, Power Point, Excel, Access, Publisher

Operating Systems: Windows Server 2000/2003/XP/NT/98/Vista, 7,8,10, Mac

Databases: SQL Server Management Studio (SSMS), SSIS, SSRS, SSAS

Languages: T-SQL,SQL

PROFESSIONAL EXPERIENCE

Confidential, Seattle, Washington

SQL Server SSIS, PowerBi/Developer

Responsibilities:

• Involved in performance monitoring, tuning and capacity planning.
• Create practical logical & physical model
• Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
• Translated business requirements into BI application designs and solutions.
• Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Work under an Agile development process
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.
• Created and maintained data flow diagrams for existing and future ETL processes.
• Created Parameterized Queries, generated Tabular reports, sub reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports
• Publishing PDF Reports obtained from Report Server on to SharePoint Portal
• Responsible for implementation of data viewers, Logging, error configurations for error handling the packages. Involved in complete life cycle in creating SSIS packages, building, deploying, and executing the packages in both the environments (Development and Production).
• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
• Developed highly optimized stored procedures, functions, and database views to implement the business logic and created clustered and non-clustered indexes

Environment: SQL Server 2017/2016/2014/ , SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), SQL Server Analysis Services (SSAS), Microsoft Visual studio 2010, IIS, VB.Net, Erwin

Confidential, Annapolis, MD

SQL/ Power BI Developer

Responsibilities:

• Collaborated with senior management, subject matter experts, and IT teams to define business requirements
• Transformed business requirements into functional and nonfunctional requirements.
• Created complex stored procedures to perform various tasks including, but not limited to: index maintenance, data profiling, metadata searches, and loading of the data mart.
• Designed, developed, and tested the ETL strategy to populate data from multiple source systems.
• Implemented SSIS packages to perform ETL data messaging operations (data profiling, cleansing, and verification).
• Designed incremental loads to populate the data mart with checksum and timestamp techniques.
• Created master-child packages to consolidate data from data sources into SQL server with execute package tasks, enabling modular programming.
• Implemented package configurations on development, test, and production environments utilizing parameters.
• Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
• Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema.
• Created SSAS cubes with KPIs and aggregation for the front-end analysis team.
• Utilized multi-dimensional and tabular model in analysis services to pull and generate reports directly from in-memory from back-end relational data sources.
• Designed SSRS reports for in depth business analyses.
• Designed expressions to calculate, group, filter, parameterize, and format report contents.
• Generated score cards with executive summary dashboards to display performance monitoring measures with Tableau.
• Delivered on-demand reports in multiple rendering formats with standard and data driven subscriptions.
• 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.
• Generated ad-hoc reports in Excel Power Pivot and sheared 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.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.
• Provisioned VMs with SQL Server on cloud utilizing Microsoft Azure and setting up communication with the help of endpoints.
• Migrated enterprise database to Microsoft Azure with Redgate and azure data factory.
• Helped to develop backup and recovery strategy for databases on virtualization platform utilizing Microsoft Azure.
• Perform thorough unit testing on all relevant platforms to ensure proper implementation.
• Designed SSAS Cube and developed MDX queries for Analysis.
• Using Team foundation server (TFS) for managing source code changes.
• Involving in developing test cases for Unit Testing.

Environment: SQL Server 2012, T-SQL, SSMS, Excel, SSIS, SSAS, SSRS, Power BI, DTA, SQL Profiler, MS Azure, Data Factory, master Scrum certificate, Visual Studio.