SUMMARY

• Data/BI Professional with an experience of over 7 years in design and implementation of OLTP/OLAP database, Big Data, ETL/ELT and reporting applications.
• Proficient with Java, C# programing language and SQL, PowerShell, Bash scripting language. Quick learner for any new technologies.
• Experience in profiling source systems and writing data mapping documents for the ETL/ELT process.
• Proficient with virtualization of business reporting on historical and current data.
• Hands on experience in designing reports using Power BI and Tableau.
• Excellent leadership skills combined with good team spirit which helps in completing projects on time and with great success.

TECHNICAL SKILLS

Database: Azure Data Lake, SQL Server

SDLC: Agile, Scrum, Waterfall, and Spiral

Technologies: Hadoop, Spark, ETL, REST API, MVC

Data Modeling: ER - win, MS Visio

Database Programming: T-SQL, U-SQL, Dynamic SQL, MDX, DAX, C#, JAVA

Development Tools: Visual Studio, SSDT, SSMS

Integration Tool: Azure Data Factory, X-flow, SSIS

Analysis Services: SSAS, OLAP Cubes, Tabular Model

Reporting Tools: Tableau, Power BI, Excel Power BI, SSRS

Source Control & Collaboration Tool: DevOps, Git, Team Foundation Server (TFS), SharePoint

Azure Services: Azure (IaaS, PaaS, SaaS), Azure SQL, Azure Data Warehouses, Data Factory, Azure Data Lake, Azure Storage, PowerShell

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

BI Developer/ Software Engineer

Responsibilities:

• Contributed to the whole SDLC of Big Data solutions for new released Confidential Business Application in 2019.
• Collaborated closely with PM team, frontend team and data scientist team to implement different requirements.
• Contributed in scripting bigdata U-SQL queries, CTEs, stored procedures and Map Reducer.
• Designed and Implemented processing system to meet GDPR compliance.
• Deployed and Utilized Azure Data Factory to build data pipeline and implement complex ETL strategy.
• Developed RESTful Web APIs with C#, .NET Core and .NET Framework.
• Wrote unit test and integration test in C# with dotnet test.
• Integrated and virtualized the monitoring and alerting system with data processor and web service.
• Optimized data query script performance in ETL process.
• Built the ad-hoc reports by using Power BI/ Tableau for data change events, trigger execution, web service consumption and latency.
• Built and config the project release pipeline in DevOps
• Brought up design pager and documented necessary dev notes.

Tools: & Environment: Azure Data Factory, Azure Data Lake Storage, Azure Data Lake Analytics, Cosmos, Scope, X-flow, U-SQL, T-SQL, DevOps, TFS, C#.Net, Power BI

Confidential, Wilmington, DE

SQL BI Developer

Responsibilities:

• Worked with the project team and business analysts to outline project requirements in JRD meetings.
• Created the database tables and created table and column level constraints using the suggested naming conventions for constraint keys.
• Maintained data model and synchronized it with the changes to the database.
• Contributed in scripting T-SQL queries, ranking functions, derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF), constraints & database triggers.
• Utilized T-SQL constructs such as joins, subqueries, derived tables, and views for querying data
• Developed SSIS packages to extract data from sources such as SQL Server OLTP, and Excel.
• Implemented master-child package models to improve the performance of the complex ETL strategy.
• Resolved SSIS package errors utilizing error logs, breakpoints, checkpoints, and data viewers.
• Optimized SSIS packages utilizing parallelisms, fast load options, buffer sizes, and checkpoints.
• Wrote complex business logic with C# script utilizing SSIS for different business operations during ETL process.
• Performed DML operations such as insert, update and delete utilizing C#.Net with ADO (ActiveX Data Objects).
• Successfully modified the measures, dimensions, attributes, hierarchies, measure groups and deployed the changes to the deployed cube in SSAS.
• Deployed recently introduced Power BI to create self-service BI capabilities and use tabular models.
• Utilized Power BI to create various analytical dashboards enabling end-user to make filters.
• Formulated complicated reports such as parameter-based reports, graphical reports, excel reports, drill-down chart and tabular report using SSRS.
• Administrated data driven mailing subscriptions on the SSRS reporting server.
• Created dashboard SSRS reports server projects and published SSRS reports to the reports server tabular and matrix reports with aggregator functions and expressions.
• Developed reports using SSRS using various features such as cross tab and parameterized reports as per client requirements.
• Maintained different versions of scripts, packages and reports on Team Foundation Server (TFS).

Tools: & Environment: SQL Server 2016, SSIS, SSAS, SSRS, SSMS, SSDT, T-SQL, Erwin, TFS, C#.Net, Power BI, SQL Profiler, DTA

Confidential, Dallas, TX

BI Developer

Responsibilities:

• Participated with the design architect and business analyst to outline business requirements in JRD meetings.
• Successfully performed dimensional modeling with Erwin and designed and built relational OLAP.
• Created SQL scripts to analyze historical data and extracted required data to support management decisions.
• Enforced business rules by creating constraints in both the production and relational data warehouse.
• Created SISS packages to extract, transform, and load data from OLTP servers to the OLAP database.
• Implemented slowly changing transformations with SSIS to maintain historical data in the OLAP.
• Created SSIS packages to perform data cleansing using various transformations in SSIS.
• Utilized event handlers in SSIS packages to handle run-time errors in SSIS packages.
• Deployed SSIS packages to the production server with parameters in the SSISDB catalog.
• Designed SSAS cubes with KPIs, aggregation, calculated members, and partitions for reporting
• Scheduled data refresh on Tableau server for weekly and monthly increments based on business change to ensure that the views and dashboards displayed the changed data accurately.
• Used data blending, filters, actions, and hierarchies feature in Tableau.
• Designed SSRS reports such as drill-down, drill-through, sub, and parameterized reports.
• Scheduled report deliveries to multiple users utilizing subscriptions.
• Administered the report server to enable saved reports browsing within native mode.
• Utilized Team Foundation Server (TFS) for the version control and project co-ordination.

Tools: & Environment: SQL Server 2012, Erwin, SSDT, SSIS, SSAS, SSRS, Tableau, T-SQL, Erwin, MS Excel, TFS, DTA

Confidential, Plymouth Meeting, PA

BI DWH Developer

Responsibilities:

• Gathered system specification requirements for the project through JAD sessions.
• Developed logical/physical dimensional models of the data mart with Erwin.
• Designed OLAP database utilizing star schema structure.
• Created stored procedures, views, and UDFs to automate data entry by a front-end application.
• Designed custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Developed ETL process using SSIS packages to extract, transform and load data per requirements.
• Implemented event handlers, loggings, and row redirect to resolve errors in SSIS packages.
• Deployed SSIS packages to the production server with parameters for dynamic execution.
• Developed master-child stored procedures to automate executions with reduced complexity.
• Built OLAP cubes with multiple fact, dimensions, hierarchies, and calculations using SSAS.
• Created drill through, drill down, linked, sub, and parameterized reports for enhanced analysis
• Formatted reports with parameters and embedded functions with expressions.
• Deployed reports to the report server in native mode and SharePoint integrated mode.

Tools: & Environment: SQL Server 2012, T-SQL, SSIS, SSAS, SSRS, SSDT, SQL Profiler, Erwin, DTA, Windows Server

Confidential, Aberdeen, WA

ETL SSIS Developer

Responsibilities:

• Outlined functional requirements by collaborating with development team in JAD sessions.
• Created logical model and defined various constraints utilizing ER-Win for data mart.
• Participated in all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Created, developed, and deployed database objects such as stored procedures, triggers, indexes, views, and UDFs.
• Formed a partition scheme and function to improve the performance of queries and availability of data.
• Designed the ETL process to pull and populate data from OLTP sources to the data mart.
• Implemented package configurations such as XML files and environment variables to improve compatibility.
• Created aggregations and user-defined hierarchies for SSAS cubes and KPIs.
• Created various reports such as drilldown and drill through with the reporting services.
• Created a multitude of reports and dashboards with SSRS.

Tools: & Environment: SQL Server 2008 R2, T-SQL, SSIS, SSRS, BIDS, SQL Profiler, MS Visual Studio, Erwin, MS Excel, TFS)

Confidential, Enumclaw, WA

SQL Developer

Responsibilities:

• Participated in JAD meetings and defined functional requirements to design the data migration process.
• Performed dimensional modeling with Erwin along with designing and building relational data mart.
• Optimized the performance of queries with modifications to the existing index system and the reconstruction of indexes.
• Implemented transactions with multiple isolation levels and locks technique to avoid dirty reads and deadlocks.
• Executed data profiling, cleansing, validation, and verification with SSIS tasks and SQL stored procedures.
• Created a multitude of database objects in T-SQL.
• Developed database objects such as stored procedures, triggers, cursors, indexes, functions, and views.
• Interfaced with business analysts and developers to identify requirements and design the reporting application
• Successfully created variety of reports using SSRS.

Tools: & Environment: SQL Server 2008, T-SQL, SSMS, BIDS, SSRS, SQL Profiler, DTA, Windows Server, TFS)