SUMMARY

• Over 10 years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, SQL SERVER, Azure SQL Cloud and all 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.
• Experience indesigning, developing, and deployingBusiness Intelligence solutions usingSSIS,SSRS, SSAS, Power BI
• 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 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.
• 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.
• Involved in migration of legacy data by creating various SSIS packages.
• Hands on experience in installing, configuring, managing, monitoring, and troubleshooting SQL Server ( 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 Azure Data 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.
• Designed and developedmatrix and tabular reportswithdrill-down, drill-throughusingSSRS.
• Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports Involved in Logical and Physical Design of the Database using Erwin tool.
• Auto-generated analysis reports using SQL Server, ACCESS, Business Objects, and Crystal Reports and Excel pivot tables.
• Experienced in using global variables, expressions, and functions for the reports.
• Experienced with development and implementing of new emerging Microsoft-related technologies like PowerApps and Flow.
• Good Working experience in designing STAR, SNOWFLAKE Schemas, database modeling, logical and physical database design using Erwin and Knowledge of how the Kimball approach has been implemented in the Microsoft BI tool.
• Strong working knowledge on the data analysis using SQL Server 2012/2014/2016.
• Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Experience in writing MDX queries and in developing OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS and Report Builder 3.0.
• Extensively worked on system analysis, design, development, testing, and implementation of projects and capable of handling responsibilities independently as well as a proactive team member.
• Strong knowledge and exposure to creating Jobs, Alerts, SQL Mail Agent and scheduled SSIS Packages.
• Involved in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor, and Index Tuning Wizard

TECHNICAL SKILLS

RDBMS/DBMS: MS SQL Server 2016/2014/2012 , MS Azure SQL Cloud, MySQL, IBM DB2, Teradata, Oracle11g/10g/9i/8i, and MS Access

Database Technologies/Tools: SQL Server Entreprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP, Azure Data Factory, Azure Data Lake, MS Visio, IBM DB2, Teradata, ER Studio

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

Operating Systems: Windows XP, Windows Vista, Windows 7, Windows 10, Ubuntu, Linux, MacOS

Programming Languages: T-SQL, DAX, PL/SQL, HTML, C#, .Net, Python, R, C++, Java, Java script, CSS, Windows Scripts, Windows Power Shell

Design Technologies/Tools: MS Visio, Erwin, Rational Rose

Data Warehouse / Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio 2016/2013/2010 , SSAS, Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012 / Visual Studio Shell

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

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.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
• Work with Business User in Understanding the Rules and do the Data Conditioning
• Created database objects such as Tables, Views, Stored Procedures, Triggers, Indexes and functions.
• Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.
• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Implemented complex business logic with Store procedures, User Defined Functions, Views and wrote T-SQL batches with CTE (Common Table Expressions) for recursive operations.
• Involved in modifying the Existing Data warehouse and add new Data Points for Data Analysis
• Use ETL to implement the slowly changing Transformation, to maintain Historical Data in the Data warehouse.
• Implementation of MDM/MDS for Vendor Management.
• Utilized advanced features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Designed a number of SSIS packages for data transfer between flat files, XML, Sales Force, Oracle, MYSQL and SQL Server using different transformations like Lookup, Derived Column, Merge Join, Fuzzy Lookup, Script Component etc.
• Strong development skills withAzure Data Lake,Azure Data Factory, SQL Data Warehouse, Azure Blob, Azure Storage Explorer
• Experience managingBig Dataplatform deployed inAzure Cloud
• Implemented Copy activity, CustomAzure Data FactoryPipeline Activities for On-cloud ETL processing.
• Experience in Integrating Power BI App with Azure Active Directory Groups and Office 365 group to implement Row level Security.
• Created SSIS Templates for developing SSIS Packages, Implemented SQL Server configurations and error handling in SSIS Packages.
• Migration of MS Access Database to SQL Server
• Involved in deploying SSIS Packages to production from different environments and scheduling and administrating SSIS Packages, wrote best practices for deploying SSIS Package to Production.
• Designed the usage summary, performance, Audit/Log, Job Status, and detailed reports for ETL users in SSRS.
• Involved in gathering requirements for EDW and designed the work flow diagrams and wrote the best practices and naming standards.
• Involved in designing ODS and EDW databases.
• Involved in testing the SQL Scripts for report development, Tableau reports,
• Designed the Dimensions and facts using Star Schema
• Involved in implementation of Master Data Services through Data Quality Services, Designed the SSIS packages move the data between MDS and EDW.
• Built compelling, interactive dashboards in Tableau that answer key business questions
• Designed SSIS Packages to cleanse, remove duplicates and matching data through Data Quality Services.
• Created SSAS Cubes with multiple dimensions, measures and hierarchies based on OLAP reporting needs.
• Worked on Cube partitions and Aggregations according to the requirements.
• Worked on KPI’s and actions. Used large data sets to address business issues
• Developed SQL in Azure-SQL, Snowflake Technologies, Troubleshooted SQL Queries against multiple data sources

Environment: SQL Server 2016 and 2012 Enterprise Edition, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Crystal Reports, SharePoint 2007, C#, TSQL, ODBC, Excel, Access, Windows 2000/XP

Confidential, Dayton, MD

MS SQL Server 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 created clustered and non-clustered indexes.
• Involved in performance monitoring, tuning and capacity planning.
• 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 2012 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 2008.
• Performed data profiling/analysis activities that helped to establish, modify, and maintain a data model.
• Writes and executes ETL code, primarily complex SQL/NoSQL script, but with a strong ability to leverage other technologies.
• Analyzes and validates existing routines and communicates impacts. Assists with data transformation, manipulation, and presentation to users.
• Works with Business Analysts, Business Intelligence Developers, Infrastructure Architects, and key business users to review, design, and develop data models and ETL processes.
• In depth knowledge of source data & business requirements which helped to create helpful data models for Azure Synapse Data Warehouse & Azure Analysis Services.
• Used Erwin tool to design data models for Data Warehouse
• Created SSRS reports which contain Drop-Down Parameters, Multi-Valued Parameters, Debugging Parameter Issues, Matrix Reports and Charts.
• Developed various operational Drill-through, Drill-down and linked reports using SSRS 2008R2.
• Migrated all the reports from SSRS 2008R2 to SSRS 2012 and maintained all the updated versions in TFS.
• Used Execution Plan, SQL Profiler to trace the slow running queries and tried to Optimize SQL queries to improve performance and availability.
• Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized report, ad-Hoc and parameterized reports by using SSRS, Oracle Grid, HPPM
• Leveraged Snowflake to make several layers of company data available for reporting, Data Science, analytics.
• Enforced corporate data security and privacy standards in the Snowflake environment
• Focused on the efficient usage of Snowflake across the company both in terms of total costs as well as performance

Environment: SQL Server 2012 and 2016 Version, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, MS SQL Server DTS, SSIS, SSAS, ASP.NET, C#.NET, SSRS 2005/2008/2012 , MS SQL Server Analysis Services (SSAS), VBA and VB Script.

Confidential, San Francisco, CA

Power BI Developer

Responsibilities:

• Involved in designing of Datamart using Star Schema.
• Created Views, Stored Procedures and scripted Sub Queries using T-SQL involving multiple numbers of tables.
• Developed highly complex SSIS packages using various Tasks, Containers and Data transformation
• Used configuration files, to migrate SSIS packages from development stage to quality analysis (testing) without having to reconfigure the packages.
• Created SSIS packages to extract data from multiple flat files, CSV, Excel and XML files and scheduled jobs to call the packages.
• Managed Package Configurations in XML Files to efficiently Promote Unit Tested Packages to Live Environment from Development Environment.
• Built Complex Stored Procedures for writing SSIS Package Logs into Physical Database.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled jobs for executing the stored SSIS packages, which were developed to update the database on daily/weekly/monthly basis.
• Involved in creating script of the entire database.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Extract, Transform and Load the Data from various Sources to Database and Vice Versa.
• Involved in importing and exporting data from MS Excel and other OLEDB sources into SQL Server using SSIS.
• Developed SSIS Packages to populate Datamart from various types of source files (EXCEL, Access, Flat files, CSVs, OLEDB Sources).
• Involved in using Script Control flow task to find the last written time of the file.
• Involved in creating SSIS Package Configuration using variables and SQL Server.
• Created Master Package to call other packages and Processing Cube using SSIS.
• Deployed SSIS packages using File System Deployment.
• Maintained & Created Cubes using SSAS.
• Involved in creating Named Queries in Data Source View, creating new Dimensions,
• Modifying Dimensions to add new Hierarchies and other stuffs in SSAS.
• Involved in adding Calculated Measures, KPI’S and Partitions.
• Created ROLAP and MOLAP SSAS Cubes based on requirement.
• Deploying OLAP Cubes.
• Involved in editing already existing reports by adding parameters, adding new groups and changing underneath data source (Stored Procs).
• Created many Drills-Through, Drill-Down and Linked Reports.
• Created reports which can handle input parameters from users and reports which can handle dynamic coloring of cells/data as per values.
• Involved in Deploying Reports to the report manager in both prod and dev servers.
• Deployed reports using both BIDS and Report Manager.

Environment: MS SQL Server2008, 2012 and 2014 TSQL, Oracle 10g, PL/SQL, TOAD, TSQL, Mainframes, C#. NET, VB.NET, Windows Sever 2008/2010/2012 , SQL Server Management Studio, SQL Profiler, Query Analyzer, Erwin 7.0

Confidential, Sunnyvale, CA

MS SQL Server Developer/SSRS Developer

Responsibilities:

• Involved in gathering business requirements.
• Gathered and documented business requirements, Security requirements, Enterprise Data Sources and External Data Feeds.
• Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Designed and developedSSIS Packages (.dtsx files)to import and export data fromMS Excel, SQL Server 2008 and Flat files.
• Worked with Claims Processing systems data files on monthly basis and then loaded the data files using SSIS Packages into facets.
• Worked with various kinds of Facets reports for Member, Provider Relations using SSRS and published these reports.
• Built reports for Member Enrollment information, Enrollment summary and related claim status using SSRS.
• Worked on different kinds ofTransformationsinSSISand processed Loads into Staging/ODS areas.
• Worked on migrating Legacy DTS Packages (ETL) to the new SQL Server Integration Services (SSIS)2005.
• Designed Complex SSIS packages interfacing SQL with Oracle 10g.
• Installation and configuration of SQL Server Reporting Services (SSRS) 2008.
• Designed and developed various complex reports such asDrilldown, Drill Through and Cross
• TabbedusingMS Reporting Services.
• Involved in designingParameterized Reportsandcascaded Parameterized Reports
• Developed and hosted Report Models to facilitate ad-hoc reporting for end clients.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Created reports using stored procedure and involved in scheduling, creating snapshots and subscriptions for the reports (SSRS 2008).
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.

Environment: TSQL, SQL Server 2008R2/2012, Crystal Reports 9.0, Windows 2000 Server, MS Access 2000, Oracle, VB.Net 2003, Erwin Data Modeler.