SUMMARY

• An experienced and highly motivated IT professional, with 10+ years of experience in analysis, architecture, design, development, testing and support of Business Intelligence products and services like MSBI (SSIS, SSRS), SQL SERVER, Data Visualization tools like Power BI Desktop, Power BI Service, Power Data Flow.
• Involved in all the stages of Software Development Life Cycle including Requirements gathering, Analysis and Design, Technical Specifications preparation, Implementation, Integration and Testing, Quality Assurance, Deployment, User Training, Performance Tuning and Production Support.
• Involved in Sprint Planning, Daily Scrums, Sprint Reviews and Retrospective Meetings, Create the Task Board and Sprint Burn down Chart at the start of every Sprint, attend all Scrum meetings and continually work with the Team and business to find and implement improvements.
• Strong SQL, developing database queries in - depth Knowledge of MS SQL Server and Stored Procedures
• Designed and developed care coordination management Analytical dashboard with various measures, KPIs and Custom Visuals metrics in Power BI.
• Expert in using Power BI DAX functions like: Time Intelligence, Filter, Date and time and others
• In-depth knowledge of connecting Power BI to different data sources like SQL server, Oracle, XL, CSV, website, folders utilizing both direct and indirect connections.
• Fluent in Power BI data modeling with appropriate cardinality relationship 1 to 1, 1 to Many.
• Utilized Star Schema & Snow Flake Schema for architecture and Row Level Security for Access control.
• Extensive experience in Power BI Service Administration, publish & share in Workspace & Apps, scheduling reports, refreshing datasets.
• Expert in creating precise and beautiful visualization using appropriate chart types, slicers, filters, drill-down, drill through and bookmarks.
• Experienced in Power BI Admin activities like creating capacities, handling workloads, resolving refresh failures, gateway configuration and upgradation, handle downtime and gateway system failures, creating apps and workspaces, user access control, creating centralized data flows, creating pipelines for all stages of deployment lifecycle (Dev, Test, Prod)
• Experienced in Creating automated workflows using Power Automate.
• Expertise in upgrading from DTS to SSIS packages, Logging, SQL Mail, Check Points, Custom Control Flow, Auditing, Variables Deploying, resolving complex issues and Error Handling in SSIS.
• Involved in Data Modeling, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling.
• Involved the Source-Target Mapping for the Dimensions and Fact Tables.
• Worked with Dimensional modeling, Data migration, Data cleansing, ETL Processes for the data warehouse.
• Technical and analytical skill with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Worked on Various SSIS components like Control Flow, Data Flow Transformations, Error Logging and Event Handlers.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Extensive knowledge of Creating User defined Project Variables, Package Variables and using System Variables for SSIS Packages and Project Configuration wizard to configure SSIS Projects.
• Created SSIS Parts (package templates) for reusability.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Creating Package Configuration to change the package properties dynamically in SSIS.
• Extensive knowledge of Creating User defined Project Variables, Package Variables and using System Variables for SSIS Packages and Project Configuration wizard to configure SSIS Projects.
• Writing complex queries using CTE (Common Table Expression) and recursive CTE.
• Excellent experience in creating Indexes, Indexed views, Column Store Index.
• Reorganizing Index for fixing internal fragmentation and Rebuilding the Index for fixing internal and external fragmentation, which will improve the query performance.
• Good experience in creating effective Functions, Stored Procedures to assist efficient data manipulation and data consistency.
• Experience in optimizing performance of various long running queries and stored procedures using SQLProfiler, Index Tuning Wizard, Windows Performance monitor and optimizing the queries.
• Monitoring of database size and disk space in production and Planning and Implementing Backup and Recovery Strategy. Good Knowledge in Full Backup, Differential Backup and Log Backup.
• Experience creating, populating and maintaining data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snowflake Schemas of Data Marts.

TECHNICAL SKILLS

BI Tools: MSBI (SSIS, SSRS), Power BI Desktop, Power BI Service. Power Automate.

Databases: SQL Server, Snowflake Datawarehouse.

Query Tools: SQL Management Studio, SQL Data Tool, Access, Teradata SQL Assistant, Rapid SQL, PL/SQL Developer. Modeling Tools MS VISIO.

ETL Tools: SQL Server Integration Services (SSIS), Azure Data Factory (ADF), Azure Databricks. Reporting Tools SSRS.

Operating Systems: Windows XP, 20 and 2010pro.

PROFESSIONAL EXPERIENCE

Confidential, West Goshen, PA

Power BI/SSIS

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications.
• Connecting to the required data sources (Tables in SQL Server and Excel files in Share Point)
• Preparing / cleaning the data by doing required data transformations, applying business logics to the data
• Integrating the data from different sources, creating a data model and use joins where required
• Designing and developing dashboard and dashboard functionalities as per the requirement
• Developed dashboard functionalities using parameters, DAX functions, Power Query, Power Pivot, Power View, etc.
• Developed all required visualizations (Charts and Tables)
• Data modelling in power bi to create a Star Schema with Facts and Dimension table
• Executing Unit testing on the data showing in dashboard visuals v/s raw data files
• Implementing row-level security on data along with an understanding of application security layer models
• Publish report to the Power BI Server premium in required workspace and schedule the data refresh
• Using ADF Copy activity moved the files from various sources to cloud data warehouse server.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse. Used SSIS to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, and xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets with different extensions.
• Created Re-useable code across the process and Extracted the data based on Client Program and Product
• Details.
• Created business logics using various SSIS task and transformations.
• Created Jobs to Move SSIS package to move the jobs from Dev to UAT and UAT to Production.
• Created SSIS Package to move the meta data between various environments like Dev, UAT, Test and Production

Environment: Power BI, SSIS, SQL SERVER & AZURE.

Confidential, Redwood Shores, CA

Power BI/SSIS/SQL SERVER DEVELOPER

Responsibilities:

• Created around 700 SSIS packages for Import, Aggregation and Extract process
• Developed DPE (Data Process Engine) Packages for executing the packages depending on Business day.
• Created dependency between Import to Aggregation and Aggregation to extract packages.
• Developed scripts for validating the source file availability for all Import packages.
• Created file transfer process for coping source files in to Input folder and sending extract files to end users.
• Created Error login mechanism to log the Exception logs, Error logs, Package execution status logs and Process completion logs.
• Have created Data integrity package for extracting last 6 months’ data trend, which is used for trend analysis by BAU team.
• Analyzing the data and created Data modeling, Data Marts as per the requirement.
• Loaded hierarchical data structures and created different level of details.
• Loaded data order date wise, which is used to create the reports Weekly, Monthly, Quarterly and Yearly level.
• Lead multiple teams for new initiatives, enhancements, and support of BI in Corporate Office of Technology.
• Interacted with business stakeholders to understand their requirements, analyzing the available data to build Power BI Dashboards. Configuring the Gateways for On-Premises data access.
• Created DAX Queries to generated computed columns in Power BI.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• Explore data in a Variety of ways and across multiple visualizations using Power BI Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services. Published reports and dashboards using Power BI.
• Elements like Containers, Execute SQL Task, Execute Package Task, File System Task and Send Mail Task etc.
• Scheduling and Monitoring the ETL packages for Daily load in SQL Server Job Agent.
• Debugging and Validating the Data flows and Control Flows
• To Develop Exception Handling process for each SSIS Package.
• Implemented Performance Tuning at various levels.
• Design and development of database scripts and procedures.
• Implemented checkpoint configuration, package configuration in packages for better reusability.
• Created manual test cases for SSIS testing.
• Involved in UNIT testing.
• Compared RIS output data with FERMAT output data and compared dollar value columns, Number of columns, Compared data format of each column.
• Development of different types of SSRS reports like Drill down, sub report, link report, pivots, charts, tabular. Extract the data from SQL Server and applied Business Logic then load into the target tables.
• Avoid Blank pages when we export the report to PDF format by changing the properties of can grow to avoid report control to grow more than the define report layout, etc.

Environment: SSIS, SQL SERVER, Power BI

Confidential, New York, NY

MSBI DEVELOPER

Responsibilities:

• Transformed data from various data sources using Flat file, Excel, ADO .net and OLE DB connection by creating various SSIS Packages.
• Created packages in SSIS Designer using Control Flow Tasks and Data Flow Transformations to implement Business Rules.
• Creating the Mappings using Data Flow Transformations such as the Sort, Derived Column, Conditional Split, SCD, Pivot and Lookup etc.
• Using Control Flow, elements like Containers, Execute SQL Task, Execute Package Task, File System Task and Send Mail Task etc.
• Scheduling and Monitoring the ETL packages for Daily load in SQL Server Job Agent.
• Debugging and Validating the Data flows and Control Flows
• To Develop Exception Handling process for each SSIS Package.
• Implemented Performance Tuning at various levels.
• Design and development of database scripts and procedures.
• Implemented checkpoint configuration, package configuration in packages for better reusability.
• Created manual test cases for SSIS testing.
• Involved in UNIT testing.
• Compared RIS output data with FERMAT output data and compared dollar value columns, Number of columns, Compared data format of each column.
• Development of different types of SSRS reports like Drill down, sub report, link report, pivots, charts, tabular. Extract the data from SQL Server and applied Business Logic then load into the target tables.
• Avoid Blank pages when we export the report to PDF format by changing the properties of can grow to avoid report control to grow more than the define report layout, etc.

Environment: SQL SERVER 2008 R2, SSIS 2008 R2, SSRS 2008 R2.

Confidential

MSBI DEVELOPER

Responsibilities:

• Transformed data from various data sources using Flat file, Excel, ADO .net and OLE DB connection by creating various SSIS Packages.
• Created packages in SSIS Designer using Control Flow Tasks and Data Flow Transformations to implement Business Rules.
• Creating the Mappings using Data Flow Transformations such as the Sort, Derived Column, Conditional Split, SCD, Pivot and Lookup etc.
• Using Control Flow, elements like Containers, Execute SQL Task, Execute Package Task, File System Task and Send Mail Task etc.
• Scheduling and Monitoring the ETL packages for Daily load in SQL Server Job Agent.
• Debugging and Validating the Data flows and Control Flows
• To Develop Exception Handling process for each SSIS Package.
• Implemented Performance Tuning at various levels.
• Design and development of database scripts and procedures.
• Implemented checkpoint configuration, package configuration in packages for better reusability.
• Created manual test cases for SSIS testing.
• Involved in UNIT testing.
• Compared RIS output data with FERMAT output data and compared dollar value columns, Number of columns, Compared data format of each column.
• Development of different types of SSRS reports like Drill down, sub report, link report, pivots, charts, tabular. Extract the data from SQL Server and applied Business Logic then load into the target tables.
• Avoid Blank pages when we export the report to PDF format by changing the properties of can grow to avoid report control to grow more than the define report layout, etc.

Environment: SQL SERVER 2008 R2, SSIS 2008 R2, SSRS 2008 R2.