SUMMARY

• Confidential has around 10+ years of rich experience in the software industry, with diversified exposure to all aspects of software conceptualization, development, delivery, maintenance, and support.
• Confidential has strong experience in design and development of Data Warehousing, Business Intelligence, and Database software solutions implemented through Microsoft technologies using Integration Services (SSIS), Analytical Services (SSAS/OLAP CUBE), and Reporting Services (SSRS).
• Experience in Design, and development of Enterprise Data Warehouse, Data Mart, and BI Solutions using MSBI tools and technologies
• Experience in OLTP Data Modeling, Star and Snowflakes Schema Dimensional Modeling, and Building Multi - Dimensional and Tabular Model OLAP Cubes using MS Analytical Services (SSAS)
• Experience in designing and implementing Data Load processes, and delivering KPI based dashboards
• Experience in Extract, transform, and load data from heterogeneous data-sources to SQL Server DB (On-premises)
• Experience in Extract, transform, and load data from heterogeneous data-sources to MS Dynamics 365 Online Services (Cloud).
• Experience in working with Import/Export Data from various data sources including Oracle, SQL Server, Excel spreadsheets, and text files (structured, unstructured, xml)
• Experience in working with transformations such as: Lookup, Slowly Changing Dimensions, Conditional Split, Multicast, Derived Column, Merge, For Each, For Loop, Multi Cast, Sorting, Data profiling, Bulk insert, Sequence Container, Delayed validations etc. using MS Integration Services (SSIS)
• Experience in SSIS project deployment to SQL Server Integration Catalog, and File System deployment.
• Experience in SSIS project deployment to production server. Schedule SSIS packages with Jobs through SQL Server Agent using SQL script
• Experience in building Executive Dashboards and Scorecards with summary level reporting using BI tools like: Power BI, Qlikview, SSRS, Tableau, and Actuate
• Experience in building interactive dashboards with MS Power BI using DAX, and Power Query Language
• Experience in Power BI to import data from various sources such as SQL Server, Cloud services, SQL DB, Flat Files, .csv files, .xlsx files etc.
• Power BI dashboards to Power BI Service, and established on-premise Gateway connections
• Experience in SSRS with matrix and tabular reports with drill-down, and drill-through features, Ad-Hoc reports, sub reports, and summary reports for daily business operations
• Experience in SSRS reports using Fetch XML with Report Authoring Extension for Dynamics 365
• Experience in building SQL Stored Procedures, User Defined Functions, CTE, and temporary table to support the ETL operations for DB migration, and to support BI visualizations
• Experience in creating measures, hierarchies, aggregations, to support OLAP cubes in SSAS.
• PowerShell scripts to automate the process with file system-based operations (zip, unzip, i/o operations), establishing DB connections, extract, and load data to flat files (EDI)
• PowerShell scripts to run legacy data loading processes, and Windows Task Scheduler to automate the tasks
• Experience in Performance Tuning, and Query Optimization

TECHINCAL SKILLS:

ETL Tools and related technologies: SQL Server Integration Services, Analytical Services, Reporting Services, Power BI, QlikView, Tableau, Actuate

Web technologies: .NET Framework, MVC, Web Services, JavaScript, jQuery, JSP, PHP

Databases: MS SQL Server 2016/2014/2008, Oracle, DB2, MySQL

Software/tools: SQL Server Data Tools (SSDT), Visual Studio, .NET framework, Toad, SQL Developer, Erwin, JavaScript

Domains: E-commerce, supply chain management, mutual fund industry

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

Sr. Developer

Roles & Responsibilities:

• Develop database schemas, tables and dictionaries.
• Create complex functions, scripts, stored procedures and triggers to support application development.
• Develop, implement and optimize stored procedures and functions using T-SQL
• Develop procedures and scripts for data migration
• Ensure the data quality and integrity in databases
• Created partition table for very large database for good performance.
• Created and developed the stored procedures, views, and user-defined functions to support application development.
• Designing Power BI data visualizations utilizing cross tabs, maps, pie, bar and combo charts

Tools & Technologies: SQL Server, Informatica, Power BI, TFS

Confidential

DWH/BI Solution Architect

Roles & Responsibilities:

• Responsible for extracting, transforming, and loading data from Oracle DW, SQL Server, XLS and flat files to MS Dynamics 365 (CRM)
• Data Architecture, design, model, and implemented ETL operations through SSIS packages, DB tables, views, indexes, and stored procedures
• Established data loading mechanisms to MS Dynamics 365 (Online Services) through third-party Data Integration toolkit from Kingsway soft
• Import-Export Data from various data sources including Oracle, SQL Server, Excel, and text files (structured, unstructured, xml)
• Identified, managed, and corrected data quality issues with Error-out/feed-back loop mechanisms
• Wrote complex SQL queries with CTE implementation, temporary tables, stored procedures, and user defined functions to support the migration operations
• Implemented procedures for validation, reconciliation of metadata and error handling
• Deployment of SSIS project and/or individual packages to Integration Catalog on Production server
• Schedule and Automate SSIS package Jobs through SQL Server Agent using SQL script
• Written PowerShell scripts to automate the process with file system-based operations, connecting to staging database, and extracting the data to flat files (EDI)
• Developed Power BI Dashboards for tracking daily operations using DAX, Power Query Language M
• Deployment of Power BI dashboards to Power BI Service, and established on-premise Gateway connections.
• Developed SSRS reports using Report Authoring Extension for Dynamics 365 with Fetch XML query language
• Direct Import - export data with MS Dynamics 365 (CRM)

Tools & Technologies: SQL Server, Microsoft Power BI, Microsoft Dynamics 365, SQL Server Data Tools for SSIS and SSRS, T-SQL, Power View, MS Excel, VBA in Excel

Confidential

DWH/BI Solution Architect

Roles & Responsibilities:

• Led offshore development team from India and owned all the client deliverables (code, documents, project plans, etc.)
• Involved in all the project phases Impact analysis, Design, Implementation, Reviews, and Testing
• Analyze data for source/target mappings, created SQL scripts for data processing and automations.
• Modeling DWH database involving Logical & Physical DB Design activities
• Designed and developed Star Schema dimension, and fact tables to support data warehouse requirements for the Sales and Marketing Dashboards
• Building SSAS CUBES for analytical reporting using Excel Power Pivots
• PowerShell scripts to run legacy data loading processes, and Windows Task Scheduler to automate the tasks
• BCP utility for bulk Import - Export of the data
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Involved in support, monitoring, and tuning of QlikView Dashboards
• Developed documentation, for both business and technical staff related to the data warehouse/reporting platform

Tools & Technologies: SQL Server 2012, SSIS, T-SQL, QlikView

Confidential

DWH BI Tech Lead

Roles & Responsibilities:

• Involved in understanding business requirements and creating high-level/low technical solution design and specifications for the same
• Created SSIS/ETL Packages and jobs to perform filtering operations and import the data on daily basis from the Oracle DB to SQL server
• Implemented and Developed SSAS Cube, Facts and Dimension tables to perform analysis
• Analyze data for source/target mappings, created T-SQL scripts for data processing and automations.
• Developed, documented, and validated complex business rules vital for data transformation.
• Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS in Visual Studio
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS)
• Organized data from a data warehouse into multidimensional cube with MS Analysis Services to allow the execution of sophisticated reports and complex queries. Coordinated with team of Developers in implementing ETL processes, eliminating data inconsistencies, integrating data from various sources, and performance tuning of ETL processes.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server • Created tabular, matrix, chart, drill down reports, parametric, cascaded reports and dashboards and score cards report (SSRS) according to business requirement
• Worked from onshore and offshore location to support project’s global delivery model

Tools & Technologies: SQL Server 2008, Oracle, PL/SQL, io (SSRS), SSIS, T-SQL, MS Excel.

Confidential

Solution Architect

Roles & Responsibilities:

• Implement Geo Analytics and Geospatial Analysis to provide comprehensive mapping capabilities and expose hidden geographic relationships.
• Create reports and visualizations by interacting with big data sets and finding patterns in the data.
• Migrate existing QlikView Applications (Qvw) to QlikSense (Qvf) applications and resolve challenges faced during this process.
• Implement security with section access and application access with Data load scripts in QlikView.
• Develop load scripts in QlikView to connect to Salesforce data source and write various data management queries.
• Working with QVD data files in QlikView.

Tools & Technologies: QlikView, QlikSense, Qlik Management Console, Qlik Geo Analytics, SQL server.

Confidential

MSBI Sr. Developer

Responsibilities:

• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Developed SQL server stored procedures, tuned SQL queries (using indexes).
• Created and maintained SQL objects like Tables, Constraints, User defined Functions, Indexes, Views, Stored Procedures and SQL scripts, T-SQL queries for developer applications.
• Wrote new stored procedures for new system and optimized old store procedures and functions on production server. Improved data load performance by analyzing database design and query plans.
• Optimized long running stored procedures and queries for effective data retrieval.
• Developed SSIS packages & Modified existing packages based on change requests and prepared Technical Documents for SSIS packages.
• Optimized SSIS packages by tuning SQL scripts in sources, using non-blocking transformations and managing data flow buffer sizes.
• Created complex T-SQL statements using SQL joins, sub queries and common table expressions (CTE’s) including recursive CTE’s.
• Generated reports using SSRS. Identified the Data Source and defined them to build the Data Source Views.

Tools & Technologies: SQL Server 2008, SSIS, SSAS, SSRS, T-SQL.

Confidential, TX

Project Lead

Responsibilities:

• Understanding and Analyzing requirements for ETL processes
• Feasibility analysis for converting existing ETL code to Stored Procedures
• Designing Data Extraction processes from heterogeneous sources to load DWH Database
• ETL work assessment and performance review
• Gathering and analyzing business requirements, and translating them into technical specifications / SRS document
• Recommending Hardware / Software for the Data Warehouse Project
• Developing Informatica mappings, and data extracting through different sources.
• Understanding Data Extraction from OLTP systems to DWH database
• Designing ETL processes for data loading and OLAP strategies for data retrieval

Tools & Technologies: Oracle, Informatica, PL-SQL, Stored Procedure, SQL Server 2005

Confidential

Project Lead

Roles & Responsibilities:

• Gathering and analyzing business requirements, and translating them into technical specifications, and preparing detailed specifications document
• Understanding Data Extraction from OLTP systems to DWH database
• Identified and resolved data quality issues with Data Profiler
• Modeling DWH database involving Logical & Physical DB Design activities
• Designing and implementing the Physical Database Data Model
• Designing and Developing ETL process strategies involving audit process & logging
• Coordinating team of developers in implementing ETL processes, report design and implementation, eliminating data inconsistencies, integrating data from various sources and performance tuning of ETL processes
• Designing ETL processes for data loading and OLAP strategies for data retrieval

Tools & Technologies: SQL Server 2005, SSIS, SSRS, SQL script, SQL Stored Procedures