SUMMARY

• Highly qualified Business Intelligence Developer focused on translating complex requirements to easy - to-use reports. Specializing in MSBI (SSIS, SSRS, and SSAS), SQL, Power BI and QlikView .Detail-oriented and systemic with excellent follow through and a superior work ethic .Ready to bring 9+ years of related experience to a new challenging role.
• Having good experience in designing the packages using various tasks such as Control Flow (Execute SQL task, For each loop Containers, Data Flow task, File System) and transformations such as Aggregate, Sort, Lookup, Merge join, Multicast, Conditional split, Derived column etc.
• Having Good Experience in deploying the SSIS Package by Created the Integration Services Catalog (SSISDB) and creating the Environmental variables and mapping with project parameters and configuring to the project.
• Worked on SSAS Cubes, Dimensions, Hierarchies, and Involved in Analyzing, Designing, building and testing of OLAP cubes in SSAS
• Having working knowledge in designing and developing partitions, Aggregations and Dimension usage and Optimization in SSAS
• Created SQL scripts for automation like backup creation and deletion after certain periods and data loading from staging tables to OLAP tables
• Experience in Creating the Partition Switch-in, Switch-out Logic to speed up loading and archiving of data by using partition switching for large set of datasets.
• Strong understanding of Azure Cloud Environment and its concepts.
• Involved in data migration activity and migrated the on-premises SQL Server data to managed instance of SQL Server and SSIS packages, SSAS cubes from one server to another server in Azure.
• Majorly involved in creating the Data Pipelines in Azure Data Factory to get the data from multiple sources and dumping it into Azure BLOB Storage.
• Expertise in designing, deploying, and developing various types of QlikView reports such as drill down, drill through, cascading parameterized and sub reports to the network users.
• Worked on the Power BI (Desktop and Service) reports & dashboards with SQL Server/Tabular SSAS sources
• Highly proficient in using SQL for developing Stored Procedures, Tables, Views, User Functions, User profiles, Relational Database Models and data Integrity, SQL joins and query writing.
• Having work experience on agile methodology and TFS Configuration Manager.
• Involved in sprint planning, Epic prioritize, distribution and worked as a scrum master
• Good Working experience in designing STAR, SNOWFLAKE Schemas, database modeling.
• Strong knowledge and exposure to creating Jobs, Alerts, SQL Mail Agent and scheduled SSIS Packages.
• Involved in SQL Query and SSIS package performance tuning and query optimization.
• Good Experience in SDLC and having Domain Experience in Insurance, Retail and HR Domain

TECHNICAL SKILLS

• SQL Server Integration Services (SSIS)
• MS SQL
• SQL Server Analysis Services(SSAS)
• JIRA
• MSBI
• TFS
• Power BI
• GIT
• Azure Data factory(ADF)
• Visual Studio
• Qlikview
• Azure Dev ops
• Tableau
• Service now
• Agile methodology

PROFESSIONAL EXPERIENCE

Sr. BI Specialist

Confidential - Bridgewater, NJ

Responsibilities:

• Acted as a Scrum Master in facilitating all planning and scrum meetings and worked with the Product Owner to resolve any impediments.
• Created epics, features, stories, and tasks and worked with the resources to estimate all future tasks.
• Used Version One for epic, feature, user stories, defect management and time tracking.
• Used agile methodology and participated in product backlog creation, PI Planning, Sprint planning and demo, PI end-to-end demo and Daily scrum calls.
• Participated in meetings with business to go over the business/technical specification documents and discuss all report issues.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Created the partition logic in SSIS package to load the huge count tables.
• Designing and developing SSIS packages using different transformations like Conditional Split, Multicast, and Union all, Merge, Merge join, Derived column.
• Monitoring SSIS jobs and rectifying errors if any failure occurs.
• Created SSAS Tabular Models on OLAP and built Pivot Table templates for the end users.
• Implemented the partition logic in Tabular Model table to improve the Performance.
• Deployed the SSIS Package into Integration Service catalog (PROD, UAT and DEV) and configured the Project solution with Environment variable.
• Deployed the Tabular Model cubes into Analysis Services server and Processed the Cube with all types of Process modes.
• Created the SSIS packages to Process the SSAS tabular Model cube by taking the backup of tabular Model Cube.
• Responsible for Tabular model deployment, Refresh, Data Load monitoring, maintain server scale up and down when performing data loads on Azure Managed instance
• Created multiple reports in Power BI and published them directly to the Hub so that the users can access them directly.
• Setup a process to trigger Power BI report’s refresh immediately after the database reloads are completed dynamically. This setup drastically reduced the end-to-end reload time of all the Power BI reports and prevented any data discrepancy issues.
• Conducted training sessions for new and power users.

Sr. BI Developer (SSIS, SSAS, Power BI & SQL Developer)

Confidential

Responsibilities:

• Migrating on premise SQL server database to the Azure Managed instance in Azure Cloud.
• Responsible for creating the data pipelines to get the data from SQL on-premise source and Loading it into blob storage.
• Migrated the application from one server to another server for SSIS, Tabular Models.
• Creating SQL tables, Stored Procedures, Views, and Jobs etc.
• Responsible for gathering requirements from onsite and converting the business requirements into technical code by developing ETL using SSIS.
• Providing Production Support and enhancements to the existing Data warehouse.
• Responsible for Tabular model deployment and Refresh in Azure.
• Data Load monitoring maintain server scale up and down when performing data loads and troubleshooting data discrepancy and missing data issues.
• Designing and developing Reports and Dashboards using Power BI Desktop according to Business requirement.
• Created reports in Power BI and publishing them to online services and end users.
• Created dashboard on Power BI services and publishing them to Data modeling using query editor in Power BI desktop tool.
• Used multiple Visualization in power BI (Table, Matrix, Bar, Card, Gauge, Slicers visualizations).
• Restricted data for users using Row level security and User filters.
• Understanding business requirement and designing Azure Data Factory Pipelines, Azure Analysis Services Models.
• Responsible for Tabular model deployment, Refresh, Data Load monitoring, maintain server scale up and down when performing data loads on Azure Managed instance.
• Migrated on premise SQL server database to the Azure Managed instance in Azure Cloud.
• Implemented the partition logic in Tabular Model table to improve the Performance.
• Deployed the SSIS Package into Integration Service catalog (PROD, UAT and DEV) and configured the Project solution with Environment variable.
• Deployed the Tabular Model cubes into Analysis Services server and Processed the Cube with all types of Process modes.
• Provided Training sessions & technical guidance to the Leadership on navigation and understanding reports and dashboards.

BI Developer (SSIS, SSAS, SSRS, Power BI & SQL Developer)

Confidential

Responsibilities:

• Involved in designing and creating ETL’s to process the Skills and Specialization data received through Rebar service Bus.
• Modified existing ETL’s, QlikView reports and DB objects in order to accommodate Specialization Changes.
• Software Development Life cycle experience - worked on agile methodology.
• Acted as Downstream POC to resolve other team queries and issues.
• Migrated code across development, testing and production environments.
• ETL deployments through Octopus.
• Worked on the Power BI reports & dashboards with SQL Server/Tabular SSAS sources.
• Used multiple visualization in power BI (Table, Matrix, Bar, Card, Gauge, Slicers visualizations).
• Worked on DMV queries and created the Power Bi Report with DMV Quires to analysis the tabular Model Memory Consumption.
• Migrating on premise SQL server database to the Azure Managed instance in Azure Cloud.
• Providing Production Support and enhancements to the existing Data warehouse.
• Responsible for Tabular model deployment and Refresh in Azure.
• Implemented the partition logic in Tabular Model table to improve the Performance.
• Responsible for gathering requirements from onsite and converting the business requirements into technical code by developing ETL using SSIS.
• Created SQL tables, Stored Procedures, Views, and Jobs etc.
• Deployed the SSIS Package into Integration Service catalog (PROD, UAT and DEV) and configured the Project solution with Environment variable.
• Involved in documentation, development, testing and deployment of the enhancements.

BI Developer (SSIS, SSAS, SSRS, Power BI & SQL Developer)

Confidential

Responsibilities:

• Understand business requirements in BI context and design data models to transform raw data into meaningful insights.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying, and executing the packages in both the environments (Development and Production).
• Developed, deployed, and monitored SSIS Packages for new ETL Processes.
• Involved in creating and deployment tabular models.
• Worked on Excel dashboard and deployed based on business requirements.

BI Developer (SSIS, SSAS, SSRS, Power BI, QlikView & SQL Developer)

Confidential

Responsibilities:

• Created the partition logic in SSIS package to load the huge count tables.
• Deployed the SSIS Package into Integration Service catalog (PROD, UAT and DEV) and configured the Project solution with Environment variable.
• Implemented the partition logic in Tabular Model table to improve the Performance.
• Deployed the Tabular Model cubes into Analysis Services server and Processed the Cube with all types of Process modes.
• Loaded Data into Qlikview application from different QVDs excel files, database and external files.
• Hands on experiences in creating new charts like (Bar charts, Pivots, Straight Table, Gauge chart ETC).
• Experience in optimizing applications by using QVD’s.
• Experienced in migrating the different reports (like Excel dashboards, SSRS reports, tableau reports) into Qlikview reports.
• Hands on experiences in production, stage deployments, requirement gathering from client and estimations.
• Manage daily Qlikview jobs that update QVD files and Dashboards and Managing data gathering, cleansing and maintenance.
• Migrated QlikView reports to Power BI reports.
• Security log/on permissions(Using Section Access)

Jr. BI Developer (SSIS, SSAS, SSRS, QlikView & SQL Developer)

Confidential

Responsibilities:

• Involving controlling the packages by using control flow components like sequential containers, for loop containers, for each loop containers.
• Used transformations like derived column, conditional split, aggregate, lookup, sort, data conversion to aggregating, filtering, sorting and joining the business data into data mart.
• Worked on different levels of package like control flow, dataflow, event handlers etc.
• Scheduling the Packages using SQL Server Jobs.
• Creating data driven subscription reports by using Report Builder in SSRS.
• Designed Different Types of reports like Drilldown, Drill Through, Sub Reports and Parameterized Reports.
• Developing of Different Reports like Table, Matrix, Charts... in different levels.
• Involving Deployment of SSAS Cubes, SSIS packages, SSRS reports and jobs from development to production.
• Loaded Data into Qlikview application from different QVDs excel files, database and external files.
• Developed Complex Queries in T-SQL, Stored Procedures, Views and Triggers.
• Extensively used joins, sub Queries and nested query in SQL.
• Given customer requirements, determine an appropriate solution to meet the customer needs.
• Describe the circumstances under which different load strategies should be used.
• Explain the circumstances under which QVD files and/or n-tiered data architectures should be recommended.