SUMMARY

• A IT Professional with around 10 years of extensive experience in Database Solutions and BI Solutions using Microsoft Technologies.
• Extensive experience in Data Modeling, Design, Development, Implementation & Administration of Database systems using MSSQL 2005/2008/2012/2014 /2016 for both OLTP (Batch Processing, Online Processing) & Data warehousing Systems (SSRS, SSIS, SSAS)
• Design and develop interactive dashboards with Tableau using advanced visualization techniques.
• Involved in tasks such as creating Tableau dashboard reports, working with the business team and developers, creating business intelligence reports and visualizations, and attending feedback sessions to improve reports.
• Design, build, and deploy proof of concept solutions and create advanced BI Tableau visualization.
• Collaborate with other BI Analysts and Engineers around data/table structures in order to optimize for Tableau Dashboards and other self - service needs.
• Support peers and stakeholders as a Subject Matter Expert (SME) through troubleshooting and analysis of results.
• Experience in database programming in writing Stored procedures, User Defined Data Types, Triggers, Constraints, Indexes, CTEs and Batch Scripts using T-SQL/PL-SQL
• Experience in Writing Complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related sub queries, Complex joins.
• Excellent knowledge of performance tuning in tuning stored procedures, Queries using tools like SQL Profiler, Database Tuning Advisor, Execution Plans, DMV’s and Efficient coding standards.
• Experienced in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all etc...
• 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.
• Experienced in Huge data migrations, huge data transfers, ETL processes using SSIS, DTS for Data warehouse implementation Projects involving conversion of data from heterogeneous sources like DB2, and Oracle, Sybase, Teradata.
• Extensive experience in SQL Server Analysis Services OLAP Cubes, and Data Mining.
• Designing and implementing both the front-end and back-end systems that run on AWS on par with organization compliance and security policies.
• Selecting the appropriate AWS service based on data, compute, database, or security requirements
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Experienced in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2005/2008/2012/2014 /2016 across various environments.
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell
• Created SSRS projects and reports in BIDS, sort and toggle object visibility to modified report, assigned item level permissions and site security roles, created report schedules and subscriptions.
• Expert and proficient in highly analytical & detailed reports that include drill down, drill through, parameterized (Cascading parameters), TopN, Summary, OLAP, cross tab, linked and sub reports and filters, charts in SSRS 2005/2008/2012/2014 /2016 .

TECHNICAL SKILLS

BI Tools: SSIS, SSAS, SSRS, Power BI, Tableau, Excel Macro Reporting, Business Object Webi report, Jasper Reports, Toad data point, Alteryx ETL.

Databases: SQL Server 2005/2008/2012/2014 /2016 , Oracle 10g, 11g

Operating Systems: Windows Server 2003, 2007, 2010, 2013, Windows 8/NT/XP/Professional

Application package: MS Office Suite, Visio, AWS, Azure

Languages: T-SQL, PL/SQL, C/C++

PROFESSIONAL EXPERIENCE

Confidential - Overland Park, KS

Sr. DB Analyst

Responsibilities:

• Primarily created Stored Procedures, Tables, SQL Joins and other statements to maintained referential integrity and implemented complex business logic.
• Creating and maintaining numerous T-SQL jobs that performed varying tasks including data generation, table population, status updates and the like.
• Experienced in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all etc...
• Proficient in Alteryx ETL and analytical platform using either preexisting modules or customizing applications to the current task and business rules.
• Using Tableau server versions (7.0 and 8.2) as a front-end BI tool and Microsoft SQL Server 2012/2016 as a back end database designed and developed workbooks, dashboards, global filter page, and complex parameters based calculations.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Physical & Logical Data Modeling- Relational, Multi-Dimensional Modeling Star Schema Modeling, Snow-Flake Modeling DSV diagrams, Fact and Dimensions Tables using Analysis Services.
• 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 .
• Developed VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries and linked the based module to enable automatic updates for excel workbooks.
• Worked on Using Azure Data Factory (v1 & v2), Azure storage accounts, Data Lake store, Data Lake Analytics, Logic Apps, Azure Automation Account.
• Worked with visualization tools such as Tableau in Building the Reports.
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs by Using Tableau.
• Developed cubes using Partitions added the Key Performance Indicators (KPI), partition aggregations, Perspectives, slow changing dimensions etc. and created various user roles.
• Extensive experience in Tableau Desktop workbook design, reports and dashboard design and Tableau Administration/server includes technical support, troubleshooting, user / group setup, permissions, security roles and monitoring of system usage.
• Create Excel reports and Dashboards merging data from diverse data sources.
• Collaborated with team members to streamline and continuously improve reporting solutions. Generated visualization adhoc reports using Alteryx and Excel Reporting.

Environment: MS SQL Server 2012/2016, SSIS, SSAS, Visual Studio 2013/2015, SQL Server Management Studio, Tableau, Excel Reporting, Access DB Macros, Softeon WMS processes, Azure, Alteryx

Confidential - Louisville, KY

Sr. Sql Data Developer

Responsibilities:

• Design, build, and deploy proof of concept solutions and create advanced BI Tableau visualization.
• Collaborate with other BI Analysts and Engineers around data/table structures in order to optimize for Tableau Dashboards and other self-service needs.
• Strong knowledge and experience in error handling of SSIS packages using transactions, check points (package restart ability features), break points and error logging procedures.
• Created custom Logging and Auditing framework incorporated in an SSIS package template that was used in the project' s ETL packages.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• 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 .
• Designing and implementing both the front-end and back-end systems that run on AWS on par with organization compliance and security policies.
• Experience in Writing Complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related sub queries, Complex joins.

Environment: MS SQL Server 2010/2012/2016 , SSIS, SSRS, Visual Studio 2010/2012, C#, SQL Server Profiler, Dashboard, Power BI, Azure, SQL Server Management Studio, AWS, Team Foundation Server (TFS), SQL Server Business Intelligence Development Studio (BIDS), Tableau

Confidential

Sr. SQL BI Developer

Responsibilities:

• Experience in creating master and child packages, using package configurations (SQL Server) and SSIS logging.
• Worked on creating scripts (Cache SQL) in Toad Data Point for data from IDX-GE Systems and Created Data extracts in SSIS.
• Improved the performance of SSIS packages by enabling Parallelism in the Control and Data Flows, usage of synchronous transformations.
• Highly skilled in developing OLAP cubes using SSAS 2005/2008/2012/2014 , calculating measures, measure groups and dimension members in SQL Server Analysis Services using multi-dimensional expression (MDX), mathematical formulae, and user-defined functions.
• Experience in creating master and child packages, using package configurations (SQL Server)and SSIS logging.
• 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.

Environment: MS SQL Server 2010/2012, SSIS/SSAS/SSRS, Tableau , T-SQL, Visual Studio 2010/2012, C#, SQL Server Profiler, SQL Server Management Studio, Team Foundation Server (TFS).