SUMMARY

• 5+ years of IT experience in the Analysis, design, development and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, SQL SERVER, Azure SQL Cloud andall MSBI tools including Power BI.
• Self - Motivated and possess the ability for critical thinking, analysis, good interpersonal, time management, multi-tasking, and communication skills. Ability to work effectively as a team member and individually.
• Strong written, verbal communication, and presentation skills.
• Pragmatic thinker, able to balance user requirements while delivering excellent technical solutions.
• Hands on experience in MS SQL Server 2016, 2014, 2012 with Business Intelligence in SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP
• Experience in Handling Heterogeneous data sources, databases Oracle, IBM DB2, Teradata, and XML files using SSIS.
• Experience in designing, developing, and deploying Business Intelligence solutions using SSIS, SSRS, SSAS&Power BI.
• Experience in data migration between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Strong experience in design, development, and deployment of the SSIS packages and SSRS reports using SQL Server DATA Tools 2012/2014/2016.
• Expert knowledge in SQL Server Package Configuration technique to make Dynamic configurations for SSIS packages and Project deployment model in SQL Server 2012/2014/16.
• In-depth understanding in client requirement Analysis, Logical design, development, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2016, 2014, 2012, DTS, SSIS, SSAS and SSRS.
• Hands on experience with SQL programming and Transact-SQL in creating tables, Stored Procedures, triggers, cursors, user-defined functions, views, indexes, user profiles, relational database models, and Complex Queries in MS SQL Server.
• Experience inwritingComplexSQLQueriesinvolving multiple tableswith innerandouter joins.
• Experience in tuning the reports that include modifying,testing the required TSQL and MDX queries using DMV's and creating the necessary environment for Deployment.
• Experience inOLTP/OLAPenvironment andData Warehouse.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler, and SQL Server Debugger.
• Involved in migration of legacy data by creating various SSIS packages.
• Hands on experience in installing, configuring, managing, monitoring, and troubleshooting SQLServer (2016/2014/2012 ).
• Experience working on POC to migrate existing on-premises BI platform to Azure Cloud.
• Experience working on Azure cloud in spinning of new resources under resource group.
• Experience working on AzureData factory to load the data from on premise to Azure Data Lake.
• Involved in configuring Integration Runtime (IR) to move the data from on premise to cloud.
• Experience Working on PowerShell scripts to automate the creation of resources and resource group.
• Experience working with Azure Data Warehouse, created TSQL code to use Polybase external tables to load data from ADL to ADW.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, and Reports on SSAS Cube using MDX, Drill-down, Drill-through, and Cascading reports using SSRS and Power BI.
• Expert in creating Power pivots, power query, Power views, and SSRS reports using tabular model (DAX), Cubes (MDX), and SQL queries.

TECHNICAL SKILLS

RDBMS/DBMS: MS SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 , MySQL, Oracle 11g/10g/9i/8i, and MS Access 2003/2000/97

Database/Tools: SQLServer, Microsoft Management Console, SQL, T-SQL, OLTP, BCP, SSIS, OLAP, Microsoft Visio, Jira, Lucidchart, Data Transformation Services (DTS) &ERD Plus.

Reporting Tools: Power BI, SQL Server Reporting Services, Tableau, Excel.

Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, Windows 7

Data WarehouseBusiness Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio 2013/2010/2008 , SSAS.

PROFESSIONAL EXPERIENCE

Confidential - Miami, FL

Power BI Developer

Responsibilities:

• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Cross training market leading BI tools such as Power BI.
• Worked on a POC using the Power BI API.
• Modified Existing Datasets in Power BI using JSON. create an application in the Power BI Developer’s portal. This app will provide us with a reusable Client ID and a Client Secret key, using which we can generate the embed token required for the REST API.
• Used ETL methodologies and best practices to create SSIS ETL Packages. Followed and enhanced programming and naming standards.
• Used various data cleaning techniques using SSIS Components.
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell.
• Created C# applications to load data from Azure storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads.
• Used C# Script task and components to do a custom load using SSIS Packages.
• The access token is the value that we need to use while calling the Power BI REST API.
• Create SSIS Packages to migrate data from / to Azure Cloud (Azure SQL Database), Azure Blob Storage.
• Addressed and remediated security vulnerability findings in PowerApps.
• Implemented Qlik Sense connections to data sources, particularly Cloud data warehouses such as Snowflake, Redshift, Google Cloud SQL, and Azure SQL.
• Experience in designing Star, Snowflakes schemas and database modeling using Erwin tool.
• Download & upload data from Hadoop HDFS & Azure HDInsight through SSIS.
• Responsible for leading the strategy and development of technical and reporting solutions needed to provide an effective and efficient data and analysis solution that can support and transform the business.
• Used Performance Point Server to create reports, scorecards, and dashboards.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Common Table Expressions, sub-queries, correlated sub-queries, window functions and complex join logic to apply business rules.
• Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.
• Used SSIS Pull data from Amazon S3 Source and updated data in Amazon S3 Destination.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Expert in creating Star schema cubes using SSAS.
• Extensively worked on OLAP cubes using SSAS and Created and Managed OLAP Cubes using SSAS.

Environment: MS SQL Server 2016/2014, MS SQL Azure Cloud, Azure Data Factory, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Salesforce, Intacct, Power BI Desktop, Power BI Service, Data Gateway, DAX, T SQL, MS Excel.

Confidential - Plano, TX

MSBI/Power BI Developer

Responsibilities:

• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or Power BI.
• Setting up Power BI Environment, creating app workspaces, publishing apps and setting up Power BI Gateway.
• Designed Analytical Dashboards, Paginated Reports, MS Azure SQL Server and experience in creating, delivering and supporting enterprise scale data warehouse solutions across standard cloud platforms.
• Used bookmarks feature which enables the ease to jump to respective report tabs with one click.
• Imported custom themes and page backgrounds for rich visual effects.
• Performed end to end testing on the reports and packages developed to ensure data quality is met.
• Integrated Power BI Reports and dashboards into PowerApps.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Created drill down and drill through report to go to details and child report within power bi based on hierarchy.
• Create views and aggregate data sets within Cloud data warehouses such as Snowflake & Redshift.
• Utilized Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing and data massaging.
• Creating and managing schema objects such as Tables, Views, Indexes, and referential integrity depending on user requirements.
• Develop and deploy SSIS packages, configuration files, and scheduled jobs to run the packages to generate data in CSV files.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R2, Salesforce and Intacct.
• Created many calculated columns and measures using DAX inPowerBIbased on report requirements.
• Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.
• Developing and maintaining/modifying complex T-SQLqueries, stored procedures and SSIS packages to load the data into warehouse.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created, Maintained & scheduled various reports inPowerBIlike Tabular Reports.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Designed and built-up high performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Responsible for debug, performance checks and performed index tuning and query optimization.
• Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.
• Designed and created OLAP cubes on data warehouse.
• Designed a partitioning strategy to refresh cubes effectively.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Environment: MS SQL Server 2016/2014, MS SQL Azure Cloud, Azure Data Factory, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Power BI Desktop, Power BI Service, Data Gateway, DAX, T SQL, MS Excel, Excess, Windows 10/ 8.

Confidential

SQL Developer

Responsibilities:

• 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 also created clustered and non-clustered indexes.
• Involved in performance monitoring, tuning and capacity planning.
• 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.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Created and maintained data flow diagrams for existing and future ETL processes.
• Designed, deployed, and maintained complex canned reports using SQL Server 2014 Reporting Services (SSRS).
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.
• 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 using SSRS.
• Created SSRS reports which contain Drop-Down Parameters, Multi-Valued Parameters, Debugging Parameter Issues, Matrix Reports and Charts.
• Converted all the reports form SSRS 2008R2 to SSRS 2012 and maintained all the updated versions in TFS.

Environment: Windows server 2014, SharePoint, TFS,SSIS, SSRS, T-SQL, DTS, SQL Profiler,Crystal Reports, OLAP, OLTP, Performance Point Sever.