Power Bi Business Intelligence
Resume:
SS
PROFIL SUMMARY
More than * years of expertise in a variety of business and technical environments, with a primary focus on relational database design, development, implementation, and support, as well as data analysis, business intelligence, ETL, and data visualization using MS-SQL Server 2022/2019/2016 MSBI Technologies (SSIS, SSAS and SSRS) and Power BI.
Extensively involved in all stages of the software development life cycle (SDLC) (system analysis, design, development, testing, and implementation), as well as familiarity with Agile/Scrum and project management methodologies.
Expert-level skills in Data Mapping, Normalization, Batch jobs, Troubleshooting, Data migration, Data collation, Data cleansing, Entity Relationship Design (ERD) model, and application-oriented design.
Working knowledge of SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, and Query Execution Plans for Performance Tuning and Optimization.
Proficient in T-SQL programing and have implemented SQL Query constructs, Sub Queries, User Defined – Functions, Stored Procedures, Triggers, Views, and materialized views. Proficient in developing applications using T-SQL Programming (DDL, DML, and DCL).
Highly Experienced in SQL Server performance tuning, query optimization, Database Maintenance plans, and Database Consistency Checks using DBCC.
Highly experienced in Data modeling (till 3NF normalization level) and Dimensional modeling (using Star and Snowflake schemas)
Designed ETL workflow to load data into Staging / Landing, Data Mart / Data Warehouse databases for full, incremental, and remigration of data.
Highly experienced in Dimension modelling using star and snowflake schemas, handling Slowly changing dimension using different techniques like row hash (MD5 and SHA), Slowly changing dimension wizard and Lookup, especially in incremental load of data.
Proficient in Dimensional modeling, defining dimension attributes, hierarchies, and different types of fact tables, and measuring granularity.
Experience in designing and building the Dimensions and cubes and Deploying and Processing cubes using SQL Server Analysis Services (SSAS).
Developed SSAS Cubes (Dimensions, Hierarchies, Dimension Usage Relation Ships and Measure Groups), Also developed Cube deployment strategy through XMLA file, Processing through SSIS package and SQL Agent Job.
Experienced in generating on-demand (ad-hoc) reports for business analysis or management decisions using SQL Server Reporting Services and Report Builder.
Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs along with slicers and dicers enabling end-user to make filters.
Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
Implemented several DAX and Language M functions for various fact calculations for efficient data visualization in Power BI.
TECHNICAL SKILLS
LANGUAGES: T-SQL, PL/SQL, UNIX Shell Programming, VI Editor, Python, Java, Shell Scripting
CLOUD: Microsoft Azure – Data Factory, BLOB Storage, Data Lake and Repos
OPERATING SYSTEMS: UNIX, LINUX, Sun Solaris 5.8/5.9/5.10, Windows Server 2016,2019 and 2022
DATABASES: MS-SQL Server 2022/2019/2016, Oracle 11g/Oracle 10g, Oracle 9i, MS Access, PostgreSQL, Teradata, Snowflake
REPORTING: SQL Server Reporting Services (SSRS)
TOOLS: SQL, Erwin, TOAD, VMware, Jenkins, Explain Plan, FTP, SFTP, SCP
METHODOLOGIES: SDLC, Agile, Waterfall model
SQL SERVER TOOLS: SSMS, SQL Profiler, Query Analyzer, Enterprise Manager, Activity Monitor, Index Tuning Wizard, SQL Trace tools, SQL Agent
ETL & Data Integration Tools: SSIS, Talend, Informatica, IBM DataStage, Azure Data Factory
CI/CD & DevOps: Azure DevOps, Jenkins, Git, GitHub, Control-M
Concepts & Methodologies: Data Modeling (Star/Snowflake Schema), Normalization (up to 3NF), SDLC, Agile/Scrum, CI/CD Pipelines
WORK EXPERIENCES
SQL/BI DEVELOPER
Nurture Care - Fairfax, VA (Jan 2024 to present)
Interacted with Business Analyst, Subject Matter Experts and Stakeholders to understand the business needs and documented the complex business requirement into simpler one and automate the process by writing complex scripts and scheduling on the jobs.
Involved in requirements gathering, analysis, design, development, and implementation of various applications on MS SQL Server.
Worked on SQL server to make changes to the existing stored procedures to handle the business logic more effectively.
Incorporated predictive analysis features in dashboards using Power BI and DAX to support healthcare decision-making.
Created complex functions and stored procedures using the multi part identifiers, multi joins and T-SQL that support both OLAP and OLTP applications.
Used Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
Applied best practices in data visualization to create insightful and user-friendly reports for clinical and operational KPIs.
Developed and maintained ETL pipelines using Talend and SSIS to process Medicare claims data across multiple systems.
Migrated critical ETL workflows to Snowflake on AWS, improving performance by 30%.Implemented AWS Glue Jobs to automate large-scale ETL workflows for healthcare claims ingestion, integrating with Snowflake and S3 for scalable processing.
Built and optimized ETL pipelines using Talend, Informatica, and DataStage for Medicare claims using Azure Data Factory, AWS Glue, and GCP Dataflow.
Developed advanced Stored Procedures in T-SQL, PL/SQL, and Python for real-time dashboards in Power BI, SSRS, and MicroStrategy.
Migrated on-prem ETL processes to Snowflake and Redshift, leveraging CI/CD pipelines via Jenkins and GitHub.
Integrated MongoDB and Cassandra with Hadoop for NoSQL processing and large-scale data analytics.
Utilized ERwin and Data Modeler to implement data vault and normalized models (3NF).
Scheduled batch jobs via Autosys and developed custom monitoring scripts in Python.
Integrated MongoDB Atlas for storing semi-structured patient feedback data and performed analytics via custom-built SSIS workflows.
Developed data pipelines using Apache Airflow for orchestration of ETL tasks, enhancing reliability and failure handling across data workflows.
Integrated Python scripts with Power BI and SSIS for predictive analytics and anomaly detection.
Developed ETL package with different data sources (SQL Server, Flat Files, Excel Source files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services.
Performed SSIS tasks such as Slowly Changing Dimension, Conditional Split, Derived Column etc. which did Data Scrubbing, including data validation checks before loading data.
Used change data capture CDC to simplify ETL in data warehouse applications.
Experience in Designing and Implementing Data Warehouse applications, mainly Transformation processes using ETL tool also actively involved in Database Querying, Data Analysis, Production support.
Implemented ETL Processes such source, mapping, transformation, staging areas and created various ETL documents such as ETL Mapping documents.
Developed SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
Responsible for implementation of data viewers, Logging, error configurations for error handling the packages.
Involved with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
Involved in complete life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
Worked extensively through agile development methodology by dividing the application into iterations.
Implemented Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS/ ETL Packages.
Executed SQL conversion pre-validation and post-validation scripts to avoid data loss and to make sure that the Count, redemption amount for each source matches the data loaded in EDW.
Worked on documenting and helping the team with better ideas to enhance the existing and newly SSIS packages and also the stored procedures that are used in the packages.
Worked on generating ad hoc reports, slicing and dicing the data to make it presentable for the manager.
Worked on SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
Experience in writing parameterized queries for generating tabular reports Drill down, Drill Trough, Cascading, matrix chart, snap-shot reports Formatting report layout, sub reports, using Global Variables, Expressions, sorting the data, defining data source and subtotals for the reports using SSRS.
Used Power BI to demonstrate the team new forms of Data Visualizations and advanced reporting methods.
Experience in configuration of report server and report manager scheduling, give permission to different level of users in SQL server reporting services.
Performs System testing for all the modules and helps business in User Acceptance Testing.
Worked on generating on-demand and scheduled reports for business analysis or management decision using SQL server reporting services.
Been part of all the team meetings and added value by providing effective solutions and implementing them.
Designed advanced DAX measures in Power BI to enhance dashboard interactivity and business insights.
Environment: SQL Server 2022, Windows Server 2022, Visual Studio 2022,2019, C#, T-SQL, MDX,DAX,Language M, SSRS, SSIS, SSAS,Power BI, MS Excel, OLAP/OLTP, Azure Repo Git, SSMS, Data import and export wizard.
SQL/BI DEVELOPER
Sandy Spring Bank - Olney, MD (Nov 2021 to Dec 2023)
Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
Prototyped models for trend detection in customer behavior, integrating SQL and Power BI for predictive insights.
Interacted with Business Analyst, Subject Matter Experts and Stakeholders to understand the business needs and documented the complex business requirement into simpler one and automate the process by writing complex scripts and scheduling on the jobs.
Conducting a meeting with BSA to gathering more information on workflow for data migration and to understand new terminology for new application.
Utilized PL/SQL and Informatica for migrating financial data to a centralized Snowflake environment.
Leveraged Talend pipelines to ingest large-scale batch files from Oracle and PostgreSQL sources into Teradata.
Designed NoSQL data layer using Cassandra to support real-time customer profiling and marketing personalization.
Incorporated Oracle Data Integrator (ODI) to streamline data movement between legacy Oracle systems and Snowflake warehouse.
Used AWS Redshift Spectrum to query structured and semi-structured datasets from S3, enabling rapid financial reporting with no ETL lag.
Implemented CI/CD pipelines using Jenkins and Git for automated deployment of BI assets.
Involved in the analysis, design, development, testing, deployment, and user training of analytical and transactional reporting system.
Worked on project management including project plans and estimates, scoping and requirements through implementation, Requirement Gathering, Requirement analysis, Application environment Setup, Preparing Test Scripts, Project Status reporting, bug fixing and deployment.
Contributed to programming complex T-SQL queries and Stored Procedures for generating reports and various business logic / scenarios.
Programmed complex queries to automate data profiling process needed to define the structure of the pre-staging and staging area.
Developed and maintained stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
Created several materialized views and UDF's to be accessed by the new front-end applications.
Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
Optimized the performance of various SQL scripts, stored procedures, and triggers by using embedded UDFs, CTEs and System stored procedures.
Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler., Captured Plan information for heavy, slow-running, and poorly performing T-SQL in SQL Sentry Performance advisor to providing a record of all plan changes and optimizing query based on results.
Monitored the database server performance and if required go for tuning of the T-SQL queries, stored procedures etc. Proven ability to handle database of more than 500 GB in size.
Involved in several facets of MDM implementations including Data Profiling, Metadata acquisition and data migration
Developed new stored procedures and triggers, modified existing ones, and tuned them to achieve optimum performance using execution plans and trace files.
Responsible to monitor performance and optimize SQL queries for maximizing efficiency.
Designed, developed, deployed, and tested the ETL workflow to load data from source to staging and Data Warehouse through Microsoft ETL SSIS.
Used change tracking numbers to simplify ETL in data warehouse incremental load process.
Worked on various work flows like Data flow Task, Script Task, Execute SQL Task, Containers and File System Task.
Implemented core ETL flows using ODI, Talend, Teradata, and Oracle databases for risk and compliance reporting.
Designed highly scalable data pipelines with AWS Glue, S3, and Redshift for regulatory audits.
Built parameterized and cascading reports in SSRS, OBIEE, and MicroStrategy, using advanced T-SQL/PL-SQL logic.
Modeled star/snowflake schemas and data vault architecture using ERwin and implemented robust CI/CD with Azure DevOps.
Engineered integration between NoSQL (MongoDB/Cassandra) and core banking data for big data ingestion and fraud detection.
Designed and executed stored logic and transformations in Informatica, ODI, and .NET microservices.
Used various SSIS transformations such as conditional split, derived column for data scrubbing, including data validation, checks during staging before loading the data into the Data Warehouse.
Implemented the logging, Breakpoints, handled errors especially foreach loop and continued execution logging previous iteration error(s).
Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
Created SQL server configurations for SSIS packages and experienced in creating jobs, alerts, and SQL mail agent and schedule SSIS packages.
Worked on managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
Used various SSIS task such as conditional split, derived column, lookup which were used for data scrubbing, data validation checks during staging, before loading the data into the data warehouse.
Involved in development of Incremental Load Process using SSIS Packages and various Transformation and data cleansing activities using various Control Flow and Data Flow tasks in SSIS packages during data migration.
Designed, developed, and deployed OLAP cubes and SSIS packages to process OLAP cubes through source views having dimension and fact tables listed. Utilized XMLA file for deployment of cube.
Documenting all ETL projects and workflows by using Bi Documenter and also including supporting documents for troubleshoot for each project.
Involved in design and deployment of Report Models for generating Ad-Hoc reports as per the client requirements.
Designed dashboards/worksheets/stories in Power BI to give a better demonstration of the data for different end users.
Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports.
Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly, and quarterly Reports including current status.
Developed Power BI dashboards integrating DAX for calculating financial metrics like loan delinquency ratios and risk exposure.
Environment: SQL Server 2019 Enterprise Edition, Oracle 9i, SQL BI Suite (SSAS, SSIS - zappysys, SSRS), VB Script, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, MOSS, MS Project, MS Access & Windows Server 2019.
JR SQL/ETL DEVELOPER
Auto Club Group - Dearborn, MI (Sept 2019 to Oct 2021)
Responsibilities:
Understanding existing business model and customer requirements. Detailed study and data profiling of the underlying application systems for the sales of the different campaigns promoted.
Develop and maintain new documentation in the process of bug fixing and Enhancements to all the applications that are part of support responsibilities.
Review and provide feedback on project deliverables, Capacity Maintenance and Weekly status updates to Team and Business.
Created intuitive visualizations with slicers and drill-through capabilities to support cross-regional performance analysis.
Designed predictive models using Power BI and historical campaign data to optimize future sales initiatives.
Participate in weekly team leads meetings and provide the new strategies and ideas that are implemented as part of Practice improvement in the team.
Created robust ETL pipelines using IBM DataStage, SSIS, and Talend to move data from PostgreSQL, Oracle, and SQL Server.
Built dashboards and reports using Power BI, SSRS, and MicroStrategy, sourcing from Redshift, Snowflake, and Hadoop-based sources.
Used Java and Python to develop automation scripts and integrate IntelliMatch data for reconciliation processes.
Integrated Hadoop, AWS Glue, and GCP BigQuery for real-time marketing campaign analytics.
Designed clustered and non-clustered indexes to optimize OLTP systems, using ERwin for schema design.
Deployed and maintained jobs in Autosys, orchestrating multi-platform workflows across .NET, SQL, and Big Data systems.
Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs. Performed Performance Tuning of the Stored Procedures and Experience in trouble shooting database issues.
Used Hadoop/Hive for historical campaign data warehousing, improving query performance over 1B+ records by 40%.
Deployed MicroStrategy dashboards for executive-level reporting of regional sales and KPIs, integrated via REST APIs.
Created data models using Data Vault 2.0 methodology, ensuring agility and traceability across dynamic business entities.
Used DAX and calculated columns to create dynamic KPIs for campaign effectiveness and customer segmentation.
Built scalable ETL solutions using IBM DataStage and SSIS to integrate data from heterogeneous systems.
Applied normalization techniques (up to 3NF) during dimensional modeling to optimize OLTP-to-OLAP transformation.
Coordinated data movement across AWS and GCP for marketing data insights and cloud transformation projects.
Developed logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS
Automated SSIS Packages using SQL Server Agent Jobs and Windows Scheduler.
Scheduled and automated the packages to populate the data in the cube daily up to date for business reporting.
Extensively involved in the SSAS storage, partitions and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
Extracted and analyzed data using Power Query, PivotTables, MS Excel, Power BI and SSAS.
Designed and deployed direct and indirect customers reports for targeted segmentation of people and across different regions with Drill down approach. Also developed Drill-through reports to measure the performance detail of different distribution channels.
Created quarterly sales reports with Chart controls to measure the progress of sales every quarter for different distribution channels.
Designed and developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI.
Very Strong ability to understand and support installation/upgrades of Third-Party Software.
Knowledge of financial instruments such as making payments to the account after splitting them to the accounts based on the commission rates and the bucket levels.
Created test data and unit test cases to ensure successful data loading process.
Preparation of Root Cause Analysis document to document the failure of the nightly job, root cause, and corrective action.
Created web parts, workflows, info path forms and used SharePoint designer for master page creation.
Involved in the development of an internal portal to publish reports across organization.
Identified VP-ASP framework as most cost-effective solution for the client. Managed a team of three developers during implementation.
Worked with Offshore team for ticketing issues, Development process and Quality support for various Subject areas
Incorporated Team Foundation Server for source control, check-in, and check-out. Experience using Subversion as the source control.
Environment: MS SQL Server 2016, T-SQL, SSIS, SSAS, SSRS, C#, VB.Net, Windows Server 2016, MS Visual Studio 2013, VSTF-TFS.
Rinzee Lepcha Rai
Burke, VA 22015
******.********@*****.***
SQL / BI Developer
Contact this candidate