Professional Summary

Expertise in proactively monitoring Database environments, and making changes to Data structures, SQL, application logic or the RDBMS system.

Hands on experience software development lifecycle development (SDLC) including designing and building tables, store procedures, schemas, ETL processes and specifications, data modeling, database maintenance.

Experience with designing and maintaining Master Data Management (MDM) processes for large and complex databases.

Proficient in developing SQL, DAX, and Python queries to Manipulate data set structures.

Experience in Data profiling, mining, formatting, cleansing, and doing QA.

Expertise in developing stored procedures’, CTE, functions, views, triggers, Slow changing dimensions, and Indexes.

Proficient in building customized columns, calculated measure using DAX script.

Experience in designing and implementing ETL Pipelines using SSIS, Azure Data Factory.

Experience in supporting Error handling, monitor triggers, parameters and ETL work.

Works independently to gather requirements, defines designs, configures, develops, tests, and debugs BI solutions.

Strong knowledge of data warehousing (EDW) methodologies and concepts of bottom up or reveres as a star schema, and snowflakes dimensional modeling.

Advanced knowledge and experience to Develop, Design, and deploy multi parameter reports, KPIs, metrics, Scorecard, Bookmarks, slicers, dashboard visualizations and schedule a report to subscribers on SSRS and Power BI standard reporting tools.

Hands on experience Configure, implement, and maintain Power BI Gateways, Power BI Embedded, API and Power BI mobile.

Experience on Applying best practices to ensure optimal performance, security, and governance on developing visualizations.

Well experienced in Revising, update, refactor, debug code, data governance and creating data dictionaries.

Proficient in documentation, creation of baseline system performance and monitor for deviation, recommending and implementing improvements to slow running queries.

Experience on configuration and monitoring of MS Azure cloud Firewall, security, Virtual machine, Server, Database and Data factories.

Experienced on change management processes /version control using TFS/Git (Agile scrum)/Azure DevOps and promoting code between environments Dev/Test/QA/Production

Detailed experience on databases backup based on SLA of company Recovery Point Objectives (RPO) and recovery time objectives (RTO).

Experience in applying Service Packs and Hot fixes and planning a database Migration strategy.

Skill Set

oRDBMS: MS SQL, PostgreSQL, oracle, Snowflake, MySQL, DB2, Access

oLanguage: T-SQL, DAX, Python, R, C#, PowerShell

oBI Tools: Power BI, SSRS, SSAS, Tableau, Cognos, Excel, SPSS, Visio.

oETL / DW Tools: SSIS, Azure Data Factory, Azure synapse, Dataflow

oCloud: Azure data lake, Azure data Factory, Azure synapse, Databricks, Office 365 suites

oDatabase Modeling tools: SqlDBM, SSMS

oVersion control: TFS and GIT (Azure DevOps)

oStatistical tools: SSAS, Excel (Pivot table), SPSS, SAS, R, STATA, Access, and Stella

oPower Automate and SharePoint.

Education

Microsoft SQL Server Administer 2012/14 (MCSA)

Master’s degree of science: 2015

Bachelor’s degree of Science2009

Professional Experience

February 2021 – present

Northwestern Mutual - Wisconsin

Senior Business intelligence Developer

Responsibilities:

Build an interactive report, KPIs, matrix, tabular and score cards dashboards, applying slicers, drills, filters,

Discover and expose data to life for customized data visualizations.

Share the visuals and embed them in an application.

Build customized Logical Measures, calculated columns, and parameters.

Access data from hundreds of supported on-premises and cloud-based sources, Azure SQL DB, Excel, and SharePoint.

Build a task of incremental and full load processing pipelines in a sequential and looping container of SSIS package.

Build a synapse pipeline to insert and transform data from data lakes and other storage servers.

Created visual studio hosting SSIS packages to import and export data from various data sources and destinations.

Applied and implemented Slow changing Dimensions, and Merge statements.

Troubleshoot data validation, script and SSIS package failure alerts based on severity levels.

Support development and production team to resolve incidents related to operation and business data quality.

Develop a stored procedure, functions, tables, and index based on business requirement.

Document procedures, developments and troubleshooting guides and data flows.

Share dashboards with the team and business partners and publish them to the web and ensure it’s always up to date with automated, incremental refreshments.

create and implement a role for Row Level Security (RLS) and Monitored permissions on report and dataset to read, share and build.

resolve dataset and dataflow refresh, credential, and gateway connection incident related issue.

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise and cloud / API data sources.

Design, review, test and verify Packages, datasets, reports, and dashboards on development, UAT pipelines before exposed to Production.

Manage Data synchronization on deployment process of Development, testing and production pipelines.

Merge and append multiple files and folders to format and cleanup and set it up for report.

Set up dataset, develop data models by applying star schema and or snowflake schema.

Develop logical Dax script to create measures and calculated columns to satisfy business needs.

Develop SQL codes to create procedures, triggers, index, views, and tables which support the data analysis and reporting process.

Testing, validating, and certifying datasets for report visualizations and dashboards.

Work on opened issue and sprint-based assignments on Jira confluences

I am working on incident tickets to mitigate and resolve issues on service now.

Prepare workflow documents.

Publish and share reports for subscribers and apply Row level security based on definitions.

Work with clients and teams on sprint planning and define story points for planned tasks in specified iteration path.

February 2020 – January 2021

Clements Worldwide - Washington DC

Sr.BI Developer/Data analyst

Responsibilities

Develop and maintain documentation (external and within SQL code) of the system configuration, procedures, item configuration.

Create objects like views, Tables, procedures, and functions to prepare a data set from different relational data sources.

Apply DAX function to create calculated measures (like aggregate function), computed column, and to create new categories from existing data set to meet client requirements.

Documenting processes related to database design, configuration, and performance.

Design and implement effective database solutions and models to store and retrieve company data.

Examine and identify database structural necessities by evaluating client operations, applications, and programming.

Develop interactive reports, dashboards, applying slicers, drills, filters, KPIs and score cards.

Apply row a row level security, configure Power BI workspace properties.

Extract data from various sources such as APIs, HIVE tables and other structured and unstructured data sources to process and store big data ensuring data accuracy, consistency, and security.

Use Query editor to cleanup and reformat and transform incoming data source for better analysis and visualization.

Designed and developed data models for the Reporting data warehouse snowflake schema.

Develop ad hoc queries, stored procedures, functions, and views to capture new logical data sets.

Develop Python and SQL queries to format and manipulate source and destination data storing structures.

Develop usage matrix and Paginated report using report builder.

Configure and manage Gateways, embedded codes, tenant objects, users, and applications.

Work on gathering clients Requirement.

Work on data cleansing formatting, transforming, merge and appends using Power BI Query editor (ETL) and SQL Scripts from backend SQL Server Side.

Develop ETL data flow/packages using Talend Task factory.

Discover row data from different sources like SSAS cube, Power BI data sets, Database, excel, flat file, and websites.

January 2018 – January 2020

ITnova

Database Specialist

Responsibilities

Responsible for maintaining the integrity of the databases, reviewing, and implementing designs/data model, Develop ETL/Reporting Data warehouse, resolving performance issues and establishing best practices. Design, Develop and deploy to replicate Legacy reporting to SSRS Paginated reports and Power BI Dashboards.

Develop, Design, and deploy multi parameter reports, dashboards visualizations and schedule a report delivery to subscribers using SSRS and Power BI.

Apply DAX function to create calculated measures (like aggregate function), computed column, and to create new categories from existing data set to meet client requirements.

Use Query editor to cleanup and reformat and transform incoming data source for better analysis and visualization.

Designed and developed data models for the Reporting data warehouse snowflake schema.

Develop ad hoc queries, stored procedures, functions, and views.

Develop and support an ETL process for data warehouse structures that support the reporting and data analytic systems.

Evaluate collected Data based on ED-FI data standard system like EIS, DIS, FIS from different locations.

Develop bulk insert procedures with firing triggers.

Work with the team on database modeling and designing schemas for transactional and data warehouse system database.

Configure and Implement Change Data Capture and Change Data Tracking.

Monitor and troubleshoot system performance, including optimization and tuning of data loads to promote optimal performance, maximize availability and minimize data latency.

Configure, implement, and maintain Power BI Gateways, Power BI Embedded, and API

Ensure SQL products or release upgrade /hot fix takes place with minimal impact Administers all SQL database objects, including tables, clusters, indexes, views, sequences, packages, and procedures.

Creates new SQL databases as required, enforces, and maintains database constraints to ensure integrity of the SQL database.

Troubleshoot all problems regarding SQL databases, applications, and development tools.

Secure securable object on server and database scopes and make sure the list minimum privilege is granted for a login and user.

Consults with users to determine database needs; implement new databases and modify existing databases based on user requirements.

Investigate complex database issues and provide solutions to technical leadership effectively interface with database team members,

Configure ODBC connection for analytical software’s.

Develop a disaster recovery plan based to meet SLA based on RTO and RTO.

Planned and set up a disaster recovery plan as part of the maintenance plan for critical database integrity and consistency checkup and the backup and restore strategies.

Configure and develop version control on TFS Scrum agile reside on DevOps Azure directory to monitor life cycle of multiple projects.

Replicate Legacy COBOL reports to SSRS reports, Document the process and make knowledge transfer.

Configure an automatic job for backups, report subscribers and data flow packages to refresh database.

Data profiling and Documentation.

Redesigning exited database to enforce referential integrity and modeling a reporting data warehouse.

Monitored Resources availability, Database, and log files size.

Implementing performance monitoring and optimization by creating Index and rebuilding poor queries to resolve high waiting time, locking, and blocking between concurrent transactions.

Reorganize and rebuild database to enforce key referential integrity inside the database to enhance validation and accuracy of data.

Develop and update technical, System Design and Maintenance documentation.

December 2015 – December 2017

Saytech Consultancy -Maryland

BI Developer/DBA

Responsibilities

Responsible for maintaining existing database, SSIS and SSRS catalogs ETL/Reporting Data warehouse, resolving performance issues and establishing best practices. Design, Develop and deploy to replicate Legacy reporting to SSRS Paginated reports and Power BI Dashboards.

Leading and Supporting the BI team on creating SSIS packages to import and export data from various data sources and destinations.

Scheduled SQL agent jobs to inspect and automate different database related activities including backup, monitoring database health, disk space, backup verification, alerts, operators, and SSIS packages.

Checking each database’s availability and accessibility by both logging in via user application as well as running quires on daily base in addition ensuring control and integrity for concurrent users.

Evaluate existing and or create new parametrized and non-parametrized SSRS report.

Configure Email and shared drive subscriptions, linked reports, and pin reports to power bi Dashboard.

Designed, reviewed, and created primary objects like views, indexes, stored procedures, functions, and triggers based on logical design models, user requirements and physical constraints.

Upgrading instance and Migrating Importing and exporting databases.

Evaluating existing database applications to migrate as well to improve the functioning on the platform.

Implementing Pre-migration, migration and post-migration on test server and deploying on production server.

Documenting installation, monitoring procedures, security policies, configuration changes, migration procedures, deployment procedures and best practices.

Enhanced performance by creating and monitoring an integrated maintenance plan automated task; backup, shrink database, update statistics, rebuild index, reorganize index, maintenance cleanup, history cleanup and notify operator tasks on various tables.

Resolving Database Failures, Physical Server Failures and SQL Server Service Failures.

Implementing performance monitoring and alert messages via native tools and third-party tools.

Ensuring SQL Server log shipping, mirroring and replication databases are operating as planned.

Participating in various medium to large scale projects on implementations, managing projects from business requirements analysis.

2009 – 2015

EIAR

Researcher/Data Analyst/Developer

Responsibilities

Responsible for the day-to-day operations and troubleshooting database system.

upgrading SQL databases developing reports, visualization, and data warehouse data load process.

Build Simple and complex ETL process to load multiple excel based file sheet/tabs.to enumerate and loop over folders and automate incremental data load.

Data requirement gathering management, cleanup, Data mapping.

Statical regression, trend, distribution, and other related Data analysis.

Prepare customized Excel, R studio, SPSS and SSRS reports and share them with subscribers.

Maintain database backups and check restorability on regular schedules.

Database migration to different environments

Secure, audit and monitor database securable for user/login based on permission.

Implement and configure Log shipping and windows clustering as a disaster recovery and high availability solution.

Performance tuning poorly design queries using execution plan analyzer, tuning advisory to track missing index and

partitioning.

Contact this candidate