PROFESSIONAL SUMMARY:

• Highly motivated SQL / Power BI developer and Data Analyst with around 6+ years of IT Experience having multiple skill set and extensive working experience in Data warehousing and Business Intelligence Technologies with expertise in SQL Server Development, MSBI Stack ( SQL Server database, SSIS, SSAS, SSRS and Power BI) for building, deploying and managing applications and services through a global network of Microsoft - managed data centers.
• Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
• Experience working with different SDLC methodologies like Agile (SCRUM).
• Experience with BI tools such as Tableau, and Power BI for creating insightful data visualizations.
• Proficient in designing Tables, Normalization techniques on database Tables using T-SQL (DDL and DML)
• Excellent backend skills in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views, Indexes, Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and consistency.
• Creating complex SQL scripts using joins (inner and outer), CTE and derived table.
• Extensively worked on Designing and developing Stored Procedures, Functions, Triggers, Views, Joins and Cursors
• Experience in creating dashboards with KPI and Drill-Down Drill-Through reports using Power BI and SSRS
• Excellent knowledge on Data Analysis Expressions (DAX) for accessing data directly from tabular databases.
• Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER functions
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying, executing, configuring, scheduling and Error handling the packages in different environments.
• Experience constructing and populating Star/Snowflake schema model
• Experience developing, partitioning and processing SSAS data cubes, architecting and maintaining multidimensional and tabular cube models using MDX/DAX queries
• Experience Interacting with Business users, business analysts, and development team members to analyze and Translate business needs to technical specifications and collaborating with developers
• Experience in Database Development and Release Management Concepts, Practices and Procedures along with Performance Tuning Database Code in OLTP and OLAP environments.
• Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Good knowledge on all types of transformations available in Power BI query editor.
• Experience in Data Analysis, Data Profiling, SQL Performance Tuning & Query Optimization
• Knowledge in Python scripting, AWS and Azure.
• Used GIT and TFS as a version control System and JIRA for writing user stories.
• Used SharePoint to host SSRS and Power BI reports and for document management
• Good analytical, logical and programming skills.

TECHNICAL SKILLS:

T: SQL, XML and Python

Databases: SQL Server, SQL Azure, Amazon Redshift, MySQL and Db2

BI Tools: SSAS, SSIS, SSRS, Power BI and Tableau

Operating Systems: Windows, UNIX

Tracking Tools: JIRA, ServiceNow

CI/CD: Octopus, Visual Studio

Source Control: TFS, GitHub

Tools: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, BIDS

WORK EXPERIENCE:

Confidential, Little Rock, AR

SQL/ Power BI Developer

Responsibilities:

• Involved in the complete SDLC process by analyzing business requirements and understanding the functional workflow of information from source to destination systems.
• Involved in the requirements Gathering and Understanding the end- user business requirements and develop creative and visually effective user interfaces for Dashboards, Analytics and Reporting.
• Closely worked with SMEs to identify business-reporting needs and develop architecture to meet the requirements.
• Creating Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, and User Defined Functions to implement the business logic to capture and retrieve compliance disclosed/ Precleared activities and Triggering the Certification process
• Created clustered and non-clustered indexes to improve the query response time for UI data retrieval.
• Created and published interactive data visualization dashboards with KPIs for Compliance team to track New Hire Onboarding Requirements and Annual/Quarterly Certifications using Power BI
• Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the Compliance requirements for SEC and FINRA Audit purposes
• Performance Tuning and T-SQL query optimization for Stored Procedures used in SSIS Packages and for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server, Excel and Flat files.
• Used various Transformations in SSIS Data Flow using Fuzzy Lookups, conditional split, merge joins, lookup, derived column and sort etc and used for-loop Containers in SSIS Control flow.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Developed Tabular Model infrastructure in SSAS for various Lines of Business
• Created different interactive Dashboards using various visualizations in Power BI Desktop
• Involved in design and implementation of database schemas which efficiently and accurately render data through Power BI
• Created DAX queries in Power BI to analyze the data in different scenarios as per business requirements.
• Connecting to multiple datasets to bring all of the relevant data together in one place and create reports, dashboards, KPI’s that provide a consolidated view of different data sources.
• Published the finished dashboards, reports in Power BI Report Server and SharePoint to render for end users.
• Involved in understanding complex data structures and data models to formulate efficient read-write data strategy.
• Scheduling, creating snapshots and subscriptions for the reports using SSRS
• Troubleshooting and maintaining large (terabyte-size) clustered databases.

Environment: SQL Server 2016, Power BI, SSIS, SSAS, SSRS, T-SQL, MS SQL Query Analyzer, SQL Profile, TFS, Visual Studio 2015, Octopus, ServiceNow.

Confidential, MA

SQL/BI Developer

Responsibilities:

• Actively involved in writing complex SQL Queries, Stored Procedures, Views, Triggers, Cursors, Joins, Constrains, DDL, DML and User defined Functions
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
• Used various SSIS tasks such as conditional split, Derived column which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Created Sub-Reports, Drilldown-Reports, Summary and Parameterization Reports in SSRS.
• Used Power BI Desktop to connect various data sources like Azure, SQL Server, SAP HANA and worked with different visualizations and created dashboards.
• Used various Data Visualizations with Power BI and published reports to Power BI Services and Premium.
• Worked on adding tiles to the dash boards, images to the dashboards using Power BI services.
• Wrote T-SQL (DDL and DML) queries, Store Procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
• Created different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, etc.
• Created indexed views and appropriate indexes to reduce the running time for complex queries.
• Scheduled the packages to keep extracting the data from OLTP at specific time intervals.
• Implemented Event Handlers and Error Handling in SSIS packages
• Used SQL Server Agent for scheduling jobs and alerts.

Environment: SQL Server 2016, Windows 2007 Server, SSIS, SSAS, SSRS, BIDS, Visual Studio 2007, TFS.

Confidential, Windsor, Connecticut

MSBI Developer

Responsibilities:

• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created numerous efficient stored Procedures to perform data cleansing and loading tasks when data is loaded into the staging area.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make the package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, cleaned and Standardized Data meeting the business standards using Fuzzy/exact lookups using SSIS tasks.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created different Power Pivot reports as per the client requirement.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from a huge dataset using SQL Server 2008 Analysis Services (SSAS).
• Worked on Filtered Views, views and Base table integration between different Source systems.
• Used Visual Studio 2008 as Source Control, to maintain drop location to test, all docs and scripts.
• With the help of TFS, managed repositories, build processes, testing infrastructure and lab deployment while easily collaborating and reporting status.
• Scheduled the Packages in SQL Server Agent on a daily/weekly/monthly basis.
• Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.
• Interacted with vendors, developers and customers to manage the business requirements.

Environment: Windows Server/XP, SQL Server 2008/2005, SQL Integration Services (SSIS), SQL Reporting (SSRS), Business Intelligence Studio, SQL Analysis Services (SSAS), Visual Studio 2008/2005, OLE DB, TFS, SQL Server Agent, SharePoint, HTML.

Confidential

SQL/BI Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.
• Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries.
• Wrote efficient stored procedures for the optimal performance of the system
• Used various transformation tasks to create ETL packages for data conversion using SSIS.
• Created SSAS cubes with multiple fact measure groups, and multiple Dimension hierarchies based on the OLAP reporting needs.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Implemented logging for SSIS packages to track number of records processed, error messages and execution time at easy task level in SSIS packages
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.

Environment: SQL Server 2014, SSIS, SSRS, SSAS, BIDS, Visual Studio, Windows 2007 and GitHub.

Confidential

SQL Server Developer/Administrator

Responsibilities:

• Involved in the entire System study, analysis and Design.
• Installation, configuration of MS SQL Server 2005 for development and testing purpose
• Involved in developing database objects such as triggers, constraints, indexes and views.
• Used T-SQL to build dynamic stored procedures.
• Managed Database files, transaction log and estimated space requirements.
• Responsible for developing automation of maintenance jobs, tuning SQL Server locks and indexes configurations, administering SQL Server security.
• Designed and implemented several complex reports and administration modules.
• Created DTS package to schedule the jobs for batch processing.
• Involved in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities.
• Involved implementing Disaster Recovery for minimal downtime using different types of database backups, restore, and replication.

Environment: Server 2005 Enterprise Edition, T-SQL, Enterprise manager, MS Office and Windows 2003.