SUMMARY

• 8+ years of experience in Data warehousing using SQL Server 2014/2012/2008 R2, SSIS, SSRS and Oracle fusion middleware.
• Worked on all phases of data warehouse and middleware development lifecycle, from gathering requirements to testing, implementation, and support.
• Proficient in the ER - Data Modeler, for the designing of Conceptual Design, Logical Design, and Physical Design and setting up the database model
• Good knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Proficient in applying transformation rules - Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.
• Experienced in Developing Power BI Reports and Dashboards from multiple data sources.
• Implemented Row-Level Security using Power BI to grant the access and filter the data based on the user that is logged in.
• Proficient in generating reports using SQL Server Reporting Services (SSRS).
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler
• Experience in creating ad-hoc reports by using Report Builder in SSRS.
• Experience on writing the Stored Procedures, Functions and Views.
• Expertise in Oracle Service Oriented Architecture (SOA) Fusion middleware with a strong focus on Oracle Service Bus

TECHNICAL SKILLS

RDBMS: SQL Server 2014/2012/2008 R2

ETL Tools: SSIS (SQL Server Integration services)

Reporting Tool: SSRS (SQL Server Reporting Service)

Cube/Data Visualization: Power BI

IDE/Tools: SQL Server Management Studio, BIDS, SQL Server Profiler, Eclipse, soapUI, Microsoft office, MS Visio

Domain: Telecom

Management Tool: Scrummage app, Microsoft Project Plan (MPP)

Signavio (Business Process Management software): Collaboration diagram, Process architecture, UML Diagram, BPMN 2.0 diagrams, Choreography diagram, Swim lane diagram

Oracle Fusion Middleware: Oracle SOA Suite 10g/11g/12c, OSB 10g /11g/12c, Mediator, Weblogic Server

PROFESSIONAL EXPERIENCE

Sr. MSBI/Power BI Developer

Confidential, Redmond WA

Responsibilities:

• Designed and developed SSIS packages to extract data from the transactional and/or operational databases, transformed the data according to analytical / reporting business needs, and loaded the data into a data warehouse or data mart.
• Strong experience in error handling, debugging, testing and error logging for SSIS
• Designed, developed and deployed reports, sub-reports, drill down reports, and drill through reports and parameterized reports and adding new features to the reports in MS SQL Server environment using SSRS.
• Possess technical skills in defining Source and target metadata definitions for Source to Target mapping specification.
• Proficient in Data Warehouse concepts, OLTP, OLAP, Star Schema, Snow flake Schema, Fact and Dimension tables.
• Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
• Import data from different data source to create Power BI reports and dashboards
• Developed custom calculated measures using DAX in Power BI to satisfy business needs.
• Developed multiple dashboards, analytical reports, KPIs, and interactive reports based on business requirements using Power BI.
• Expertise in installing, maintaining and troubleshooting the Personal and On-Premise Gateway
• Created data visualizations using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals).
• Created complex Custom Views using SQL Developer to create data sets for Power BI dashboards.
• Proficient in creating joins for queries involving multiple tables.
• Proficient with T-SQL to create Tables, Views and Stored Procedures
• Proficient in Normalization and De-Normalization of existing tables for faster query retrieval.
• Worked with subject matter experts (SME’s) and project team to identify, define, collate, document and communicate the data migration requirements.
• Experience in Designing Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.

Project Lead

Confidential

Responsibilities:

• Proficient in preparing project plan for design & build phase.
• Worked across multiple functional projects to understand data usage and implications for data migration.
• Expertise in application of the Star and Snowflaking model to retain de-normalized data or to normalize the data for some relations in the schema.
• Integrate the Power BI Dashboards for restricted view with key stakeholders.
• Populated all the dashboards using Power BI Calculated measures and SQL Queries.
• Extensive use of DAX (Data Analysis Expressions) functions in creating Power BI dashboards and reports.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), Views to support Power BI
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering and deploying reports to Power BI.
• Creating powerful calculations, key metrics, and key performance indicators (KPIs).
• Creating relationships between different tables from different data sources.
• Proficient in source system data analysis in order to manage source to target data mapping.
• Designed and Implemented the SSIS package to load the data from source to staging and Datawarehouse.
• Excellent knowledge in designing and developing Power BI visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Flexible and versatile to adapt any new environment with a strong desire to keep pace with latest technologies and can work as an individual or as a team
• Effective in working independently and collaboratively in teams and responsible for coordination between onsite and offshore teams in various projects.

Lead Developer

Confidential

Responsibilities:

• Designed, Developed and scheduled SSIS packages to load the data form OLTP source system to data staging environment and then to data warehouse environment.
• Expertise in validating the data between source and target systems.
• Proficient in creating Stored Procedures, tables, and views and SQL joins.
• Excellent report creation skills using Microsoft SQL Server 2012 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created traceability mapping document and design document which consists of the business requirements with source to target with ETL and Fusion transformation logic.
• Scheduling SSIS packages to create jobs for daily ETL operations.
• Code review of the OSB flows with error handling
• Helping team in analyzing and fixing system integration testing defects.

Middleware Developer

Confidential

Responsibilities:

• Designed, developed code on OSB with added responsibilities of preparing System test cases.
• Code Integration of OSB & BPEL and performing integrated testing of the components
• Unit testing and system testing of OSB and BPEL services developed as part of the project.
• Creation and review of the interface documents and Service specification documents.
• Providing SIT and Production Support
• Strong knowledge in preparing failed order document for L3 support team which helped them in completing failed orders by utilities present in OSB and BPEL console.