PROFESSIONAL SUMMARY:

• Microsoft Business Intelligence and Data warehousing Specialist
• 12 + years of experience on Data warehouse and Business Intelligence with MS SQL server development across Investment Banking, Private Banking, US Mortgage, Telecom and Automobile Industry domains.
• Expert in creating Power pivots, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries.
• Experience in implementing user based subject selection (Role based security) in Power Views, Power Pivots and SSRS using DAX, MDX and SQL queries
• Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Expert in writing SSIS package to transfer data between OLTP and OLAP
• Expert in creating in SQL Server Analysis Services (SSAS) OLAP Cubes. Implemented Snow Flakes Schema and Star Schema.
• Expert in writing SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregates, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from heterogeneous sources (Oracle, SQL Server, MSAccess, Flat Files etc.) to data warehouse.
• Proficient in working with Big Data JSON format with SSIS packages for data transformations.
• Extensive experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures, functions, and triggers.
• Extensive experience in PL/SQL and ETL scripting and query optimization
• Conducted Oracle database and SQL code tuning to improve performance of the application, used Bulk binds, in - line queries, Dynamic SQL, Analytics and Sub-query etc.
• Experienced on database management activities such as scrubbing, metadata index and table creation.
• Big Data Analytics using Tableau (Create charts, graphs, infographics, dashboards, interactive graphics, and other types of data visualizations that are innovative, striking, and that convey the most important aspects of data).
• Working knowledge on Mainframe, Java, Python.
• Experience with Hadoop (HDFS, SPARK, SQOOP, HIVE & PIG)
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skills.

TECHNICAL SKILLS:

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, SQL BIDS, DTS, SSIS, SSRS, SSAS

Database: MS SQL Server 2016/2012/2008/2005/2000, Oracle, MS-Access

Language: T-SQL,MDX,DAX, C#, VisualBasic, VBA, PL/SQL · ETL Tools SQL Server Integration Services(SSIS),DTS

Reporting Tools: Power BI, SSRS, Tableau, Crystal ReportsRewards & Recognition

EXPERIENCE:

Senior ETL Developer

Confidential, New York

Responsibilities:

• Creating Azure Datasets, Pipelines and ADF for Data warehouse and Data Mart.
• Design andmonitor construction of an enterprise data warehouse, working with a team ofengineers.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x) reports.
• Analyse anomalies and create an action plan for data remediation
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Created dynamic SSAS cube partitioning for customized data as per client's requirement.
• Implemented complex calculations in tabular model using DAX.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Helped to develop backup and recovery strategy for databases on virtualization platform utilizing Microsoft Azure.

Senior ETL Developer

Confidential, Dublin (OH)

Responsibilities:

• Design andmonitor construction of an enterprise data warehouse, working with a team ofengineers.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x) reports.
• Analyse anomalies and create an action plan for data remediation
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Created dynamic SSAS cube partitioning for customized data as per client's requirement.
• Implemented complex calculations in tabular model using DAX.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Helped to develop backup and recovery strategy for databases on virtualization platform utilizing Microsoft Azure.
• Created SSRS reports using MDX queries for reporting financial matrices.
• Data Cleaning: Implement business logics to clean data as per system requirements.
• Create custom SSIS Custom logging by capturing various events using vb.net in Script Task editor.
• Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects
• Performed Unit Testing, Integration Testing and Performance Testing.
• Converted existing BO reports to tableau dashboards
• Developed Tableau visualizations and dashboards using Tableau Desktop
• Implemented complex calculations in tabular model using DAX.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• 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.

Senior ETL Developer

Confidential, Chicago (IL)

Responsibilities:

• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Created dynamic SSAS cube partitioning for customized data as per client's requirement.
• Implemented complex calculations in tabular model using DAX.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Consolidated multiple Tableau workbooks into single workbook for NT group single source Tableau report central
• Cleaning and Blending multiple data sources to allow for different views on application data in a single dashboard
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Created materialized view to increase the performance in data warehousing environment
• Tuned SQL queries and performed code debugging using TOAD
• Data migration, load source data and parse the XML file accordingly using Hadoop and load them into HIVE for data analytics.
• Helped to develop backup and recovery strategy for databases on virtualization platform utilizing Microsoft Azure.

Senior ETL Developer

Confidential, McLean (VA)

Responsibilities:

• Transformed business requirements into functional and non-functional requirements.
• Created complex stored procedures to perform various tasks including, but not limited to: index maintenance, data profiling, metadata searches, and loading of the data mart.
• Designed, developed, and tested the ETL strategy to populate data from multiple source systems.
• Implemented SSIS packages to perform ETL data messaging operations (data profiling, cleansing, and verification).
• Designed incremental loads to populate the data mart with checksum and timestamp techniques.
• Implemented package configurations on development, test, and production environments utilizing parameters.
• Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
• Created SSAS cubes with KPIs and aggregation for the front-end analysis team.
• 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.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

Senior ETL Developer

Confidential

Responsibilities:

• Designed SSIS packages for uploading historical and daily transactional data
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Implemented complex calculations in tabular model using DAX.
• Wrote MDX expressions to create name sets and calculated members.
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Created dynamic SSAS cube partitioning for customized data as per client's requirement.
• Implemented complex calculations in tabular model using DAX.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Designed SSAS Cube and developed MDX queries for Analysis.

Senior ETL Developer

Confidential

Responsibilities:

• Created SSIS package for automating dynamic cube partitioning by using C# code.
• Designed and created cube for FY15-16 reporting.
• Created dynamic cube partitioning for last 2 years data as per current date.
• Created SSRS reports using MDX queries for reporting financial matrices.
• Create custom SSIS Custom logging by capturing various events using vb.net in Script Task editor.

BI Architect

Confidential

Responsibilities:

• Responsible for managing SQL and BI development requirements for Onsite and Offshore Polaris team.
• Built Power BI dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Worked on projects with Eversheds team on SSAS, SSIS and Big Data requirements for various clients.
• Created SSIS packages for uploading historical and daily files with the following work flow.
• Upload csv files to staging table: Iterate through the defined base folder including subfolders to upload all input csv files.
• Used Bulk Collect feature to improve performance.
• Tuned SQL queries and performed code debugging using TOAD
• Created reports for various clients using MDX for data extraction and SSIS for excel reports generation.

Senior ETL Developer

Confidential

Responsibilities:

• Created SSIS packages for uploading historical and daily files with the following work flow
• Upload csv files to staging table: Iterate through the defined base folder including subfolders to upload all input csv files.
• Master Table Entry: Update the Master tables with any new values existing in the input files for various category ID's such as Product, Trader, Trade, Source etc.
• Data Cleaning: Implement business logics to clean data as per system requirements.
• Upload Staging to Main table: Upload stating table to main tables and use all master tables to update the main tables.
• Create custom SSIS Custom logging by capturing various events using vb.net in Script Task editor.
• Senior ETL Developer, Royal Bank of Scotland - Mumbai
• Working on architecture, database design and enhancements for RBS private banking data warehouse.
• Created KPI Objects in line with Requirement Docs.
• Wrote MDX expressions to create name sets and calculated members.
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Responsible for all ETL operations including client feeds, warehouse loads, and data extraction.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes

Business Intelligence Developer

Confidential

Responsibilities:

• Create prototype SQL Server 2005 Analysis Services (SSAS) cubes using the Unified Dimensional Model (UDM).
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Created KPI Objects in line with Requirement Docs.
• Wrote MDX expressions to create name sets and calculated members.
• Assist in analysis/reporting of data collected from our security tools with direction on interpreting what is detected and observed.
• Create and update SSIS jobs on Autosys in UAT, DEV and Production environment.
• Monitoring SSIS jobs on Autosys. Investigating the cause and fix for any job failure.
• Implemented SSIS data, created maintenance procedures and provided data integrity strategies.
• Liaised between management and users to help define requirements and facilitate work flow.
• Interfaced with internal customers to define and improve support procedures and capabilities through s, communications, and documentations acros projects and future system upgrades.
• Collaborating with global teams in UK, USA and Singapore for monitoring, maintaining and creating SSIS packages.

Senior Developer

Confidential

Responsibilities:

• Responsible for all ETL operations within the Finance department including client feeds, warehouse loads, and data extraction.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Using MDX created calculated members for customized calculated measures.
• Analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes.
• Documented all database objects, procedures, views, functions & packages for future s.
• Performed all QA testing and match results for different environments.
• Created Indexes (Clustered & Non-Clustered) to reduce data retrieval time.
• Created Triggers to implement business control.
• Fine-tuned SQL queries to improve query performance and to reduce runtime.
• Write Adhoc queries for Business analysts to extract required daily data.
• Create Custom Logging in SSIS packages.
• Weekly Update the Dimension and Fact tables through SSIS Packages and Updated the cube in SSAS.
• Audited database user’s audits using SQL profiler and costumed stored procedures\packages.
• Created Report Snapshots to improve the performance of SSRS.
• Developed expressions to calculate values at run time in SSRS 2005.
• Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS).

SQL BI Developer

Confidential

Responsibilities:

• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Developed Stored Procedures, Functions (UDF), Views & Triggers to enforce the business rules.
• Created Indexes (Clustered & Non-Clustered) to reduce data retrieval time.
• Created Triggers to implement business control.
• Fine-tuned SQL queries to improve query performance and to reduce runtime.
• Automated backup (Full & Differential) processes for disaster management.
• Ran DBCC consistency checks, and fixing data corruption in application databases.
• Reorganized database structures as needed, automate procedures at regular intervals.
• Created and maintained all types of Backups and recovery strategies and set up jobs.
• Set up Profiler Traces, Analyze and replay Profiler Traces for Performance and long running queries.
• Optimized long running Stored Procedures & queries for effective data retrieval.
• Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files etc.
• Developed SSIS packages to produce details and summarized reports on daily basis.
• Created SSIS packages using Conditional Split, Data Conversion, Fuzzy Logic and C#. several weekly, monthly, quarterly, yearly, parametric, drilldown and chart reports using SQL Server Reporting Services (SSRS).
• Built ad-hoc reports using SQL Server Reporting Services (SSRS), Excel.

SQL Server Developer/A nalyst

Confidential

Responsibilities:

• Responsible for quick response of SQL statement and connectivity from frontend application to the database servers.
• Created Clustered, Non-Clustered Indexes and constraints to the frequently used tables in application.
• Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Created SSIS packages to load data from Oracle to SQL Server using various transformations in SSIS.
• Generated parameterized/Drilldown, Drill Through & Cascaded reports using SSRS and Crystal Reports.
• Involved in the performance tuning and DB optimization of T-SQL queries.
• Created database segmentation and also designed the index and implemented partitioning.
• Set up database backup and recovery strategies. Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.