PROFESSIONAL SUMMARY:

• Possess 6 + years of professional experience in Data warehouse full lifecycle developer and data analyst in various domains such as Banking, Health and Finance
• Having extensive experience in Software Development life - cycle (SDLC) while implementing system designing, data modeling, application development, maintenance and support by using Agile and waterfall methodologies
• Excellent experience on ETL Process for large scale data warehouse development (SSIS), developing Multi/Tabular dimensional cubes using SQL Server Analysis Services (SSAS), developing/rendering reports by using Reporting Services (SSRS) and Power - BI.
• Having Good experience in C# and Vb.net for automation of SSIS Packages and custom coding in SSRS reports.
• Having Good experience on MDX, DAX and M-query writing in Power query.
• Integrated Custom Visuals based on business requirements using Power BI Desktop.
• Experience in designing Star schema, Snowflake Schema and Dimensional modeling.
• Having good experience on Normalization and De-Normalization techniques
• Expertise in Working with various RDBMS like Oracle, SQL Server, DB2 and Teradata.
• Extensive experience in development of T-SQL and PL/SQL Scripts for business logic implementation by using FSD and TSD
• Extensive experience in dealing with Relational Database Management Systems (RDBMS) while developing and implementation of CDC Changes, Stored Procedures, Functions, Joins, Indexes, Views, Data Import/Export, Triggers and Cursors.
• Experience in Query Optimization and Performance tuning while working with Execution Planning and SQL Server Profiler as to monitor the SQL Server for deadlocks, long running queries and tune the same to improve performance.
• Responsible for implementation of Meta data viewers, SSIS Custom Loggings and Checkpoints, Event handlers in the packages.
• Expertise in Using Conformed, Role-Played, Junk, De generated, Parent-Child and Slowly Changing Dimensions
• Excellent experience on creating Calculated Measure and Analyzing MDX Queries
• Experience in creating Role based Security and Row level Security in cubes using SSAS.
• Expertise in developing SSAS dynamic Partitions with SSIS, and designing Aggregations.
• Having Extensive experience on various SSRS reports development such as Drilldown, Drill through, Sub reports, Parameterized, Cascading, Linked, URL and ad-hoc reports
• Having extensive experience on SSRS report deployments, Data driven Subscriptions and Job scheduling and maintenance.
• Having experience on SharePoint 2013 while deploying SSRS and Power-BI Reports.
• Worked on Report Server and Publisher, to manage user access, schedule refreshing of documents, mount completed applications.
• Working SQL Server 2017 with Azure Data Factory Functionality.
• Created PDF push reports and setup email distribution on Power BI Publisher.
• Reviewed Power BI error logs and provided production support.
• Performance tuning of dashboards was carried out to limit the response time to well Calculation and defining server sizing for optimal performance of Power BI dashboards.
• Delivered advanced/complex reporting solutions such as Dashboards and Standardized reporting using Power BI.

TECHNICALL SKILLS:

Languages: SQL20082017, T SQL, VB.Net, C#, MDX, DAX

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

Web Development skills: HTML, XML, JSON

Version Controls: TFS, SVN,VSTS

Defect Tracking Tools: HP ALM, JIRA

Document Management: SharePoint

MS Applications: MS Excel, MS Visio, MS Project, MS PowerPoint

Operating Systems: MS DOS, Linux, MS Windows

PROFESSIONAL EXPERIENCE:

Confidential, Elizabethtown, KY

Sr. BI Consultant

Responsibilities:

• Developed Cubes in both Tabular model and Multidimensional model with Star Schema.
• Involved in the business requirements understanding, expectations and needs of the systems developed in iteration fashion.
• Developed Tabular dimensional cube and tabular data models and Power-BI data models
• Designed and developed Data modeling for Power view reports in Direct/In-Memory mode.
• Developing Perspectives and partitions in tabular dimensional cubes for various users.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs and case proceedings along with slicers and dicers enabling end-user to make filters.
• Writing Power query and modifying R scripts while creating Power BI Dashboards
• Publishing, Configuring and scheduling Power BI Desktop reports into report server.
• Working on Azure Sql databases and azure functions to fulfill business requirements.
• Developed multiple dashboards, analytical reports, KPI’s, Score Cards and interactive reports based on business requirements using Power BI Desktop models with calculated measures in DAX.
• Created Fact Less Fact tables and degenerated dimensions to meet Business logic in SSAS cubes. Designed data warehouse Dimension/Fact tables for Insurance, Policy and Commodity calculation.
• Analyzed FSD, developed TSD with Data Dictionary writing Operational guide.
• Increased the performance while implementing Proactive caching with MOLAP.
• Gathered good experience on Incremental load while implementing through KPI’s.
• Developed MDX and DAX queries to get calculated measures by using time intelligence
• OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Wrote MDX queries using various Mdx functions to implement Calculated Measures.
• Developed calculated members, measures and Named Queries in SSAS.
• Developed Various DAX formulas to get calculated measures in to develop data models.
• Processing Cubes by using SSIS ETL frame work Custom Packages and Xmla scripts.
• To Process SSAS cubes, designed and developed various SSIS packages with Custom Check points, Event Handlers Custom loggings in task and package level and Package Configurations.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions. Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor,SQLProfilers, Activity Monitor.
• Migration of SQL server from 2016 version to 2017 version to implement functionality.

Environment: SSIS, SSAS, SSRS, Power-BI, C#, MS Excel, Tableau, Microsoft SQL Server-2017 MS Visio, MS PowerPoint, Jira and SVN

Confidential, McLean VA

SQL Analyst

Responsibilities:

• Involved in gathering requirements from the business users and created the Functional Specifications, Technical Specs, Design documents and Approach documents.
• Created SSIS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel, Flat Files and Oracle databases.
• Designed and Developed Complex SSIS packages for auditing Interfaces using SQL Server Integration Services.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Key participant in gathering user requirements along with business analyst and analyzed the requirements for developing Conceptual model.
• Conducted Design reviews and analyzed the DW project database requirements from the users in terms of the tables which will be most useful.
• Extensively worked with SSIS framework to develop to load Historical/Incremental.
• Provided analysis and worked with developers in database design and table structure, indexes, views, stored procedures and planned the SSIS data flow.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Worked on all SDLC methodologies most importantly Agile Methodology.
• Wrote PL/SQL Stored Procedures, Functions, Views, Packages and Triggers to implement business rules into the application.
• Redefined many attributes and relationships in the Reverse Engineering Model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Developed and deployed Various ad-hoc reports as per business requirements
• Worked with the implementation team to ensure a smooth transition from the Design to the Implementation Phase.

Environment: SSIS, SSRS, SSAS, Erwin, UNIX, SQL*Loader, DB2, Oracle 10g, PL/SQL C#, Crystal Reports, TFS, SharePoint, MS Office

Confidential

SQL BI Developer

Responsibilities:

• Worked on Collection of requirements and implementation of designing documentation
• Wrote Stored Procedures, Functions, Views including with Temporary tables based on TSD and FSD
• Designed and developed various SSIS packages with script component with Custom Check points, Event Handlers Custom loggings for task and package level and created XML Package Configurations
• Experience in Performance Tuning in SSIS packages by using Row,Block and Unblock Transformations.
• Developed Historical/Incremental of SSIS Packages with SCD2 concept of Star Schema
• Gathered good knowledge on Incremental load of SCD2 with the implementation of KPI’s.
• Created Packaging structures with CR’s in TFS and deployed into server boxes by using batch scripts for Quick batch deployments.
• Implemented Historical and Delta load changes as per requirements.
• SSIS packages(ISPAC) Deployments and Job schedules in Sql 2012 and maintenance
• Integrated with main front end application with respective Schedules.
• Developed Pointing Time Tables and Recon Modeling.
• Developed Hub’s Links and Satellites by using TSD
• Created Packaging structures with CR’s in TFS and deployed into server boxes by using batch scripts
• Implemented Parallel Processing to fetch the data loading and creating user files
• Developed History and Delta changes as per instruction files.
• Managing Zipped files through SFTP client and unzipping encrypted files.
• Extracting Updated Files and loading into staging to dimension tables.
• Updating fields accordingly incremental loading and Historical Loading
• Worked on SSRS reports creation and deployments with data driven Subscriptions.
• Converted SQL queries into MDX queries to pull data from SSRS.
• Worked on SSRS tickets closing with functional changes.
• Developed Self-service Dashboard by using Power-Pivot, Power - View and Power Query.

Environment: SQL Server 2012/2008 R2, Business Intelligence Studio (SSAS, SSIS, SSRS), MDX, Oracle 10g, ProClarity, MS Excel.

Confidential

Associate SQL Developer

Responsibilities:

• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Generated database monitoring and data validation reports in ProClarity and SQL Server Reporting Service (SSRS).
• Deployed and maintenance SSIS packages through File system and MSDB and scheduling jobs by using configuration files.
• Upgraded databases from SQL Server 2000 to SQL Server 2005.
• Migrated data using ETL Tool in SSIS R2.
• Maintained system monitoring jobs and provide high availability support.
• Created partition table for very large database for good performance.
• Participated Databases Architecture and data modeling design.
• Performing DBA functions, installing, configuring and supporting database systems.
• Fully supported change management procedures.
• Reviewed and developed data models and database designs with development teams
• Wrote store procedures for job automations. Created dynamic user functions.
• Developed Database in SQL Server which includes Designing Database, creating Tables in accordance with Normalization concept
• Designed and developed OLAP using MS SQL Server Analysis Services.
• Involved in converting SQL Server 2005 data using SSIS.
• Designed and developed MS SQL Server Reporting Services(SSRS) under SQL Server 2000 and SQL Server 2005
• Creating Packages on SSIS by using different data Transformations like Derived Column, Lookup, Conditional Split, Merge Join, Sort and Execute SQL Task to load data into Database.

Environment: MS-SQL 2005 and 2008 R2, Sybase, Teradata, SSIS, SSRS, SSAS, C# and TFS.