* * * * * o n S a n j i

Milton T. Sanji, BSc

Princeton, TX 75407

240-***-**** · ad2s1z@r.postjobfree.com

PROFESSIONAL SUMMARY

Detail-oriented and analytical professional with extensive experience in data analysis, seasoned Business Intelligence Developer with comprehensive expertise in MS Azure, Power BI, and the MSBI suite (SSIS, SSAS, SSRS). Adept in SQL Server development and data analytics, I bring a proven track record of developing robust BI solutions and data-driven insights. My proficiency in leveraging Microsoft technologies enables me to transform complex data into actionable business intelligence. Skilled in optimizing data flows, creating insightful reports, and implementing scalable BI systems, I excel in driving operational efficiency and supporting informed decision-making in dynamic business environments. My analytical acumen, combined with a strong focus on delivering user-centric solutions, positions me ideally for roles requiring deep technical expertise and strategic thinking in Business Intelligence.

• Data Analysis and

Interpretation

• SQL Proficient

• Problem-Solving Skills

• Data Visualization

Expert

• Database

Optimization Pro

• Advanced SQL Strategist

• Data Trend

Analysis

• Power BI Specialist

• Training &

Development

• Process

Improvement

• Strategic System

Planner

KEY COMPETENCIES

Advanced Data Handling: Proficient in Power BI and SQL for advanced data analysis, visualization, and database management.

Strategic Business Analysis: Deep understanding of business needs to develop aligned systems and data solutions.

Technical and Innovative Skills: Strong in DAX, SQL, and data modeling, with a focus on innovative problem-solving

Statistical Analysis: Skilled in applying statistical methods to analyze data and generate useful business reports.

Problem-Solving Skills: Ability to approach complex data-related problems systematically and derive logical conclusions.

Communication and Teamwork: Effective at translating complex data findings into clear, understandable, and actionable insights for technical and non-technical stakeholders. Analytical Problem-Solving: Adept at analyzing complex data and systems issues to find practical solutions.

Project Management: Ability to manage projects efficiently, meet deadlines, and work collaboratively in team settings.

Innovative Thinking: Aptitude for identifying opportunities for improvement and innovation in data analysis processes.

SQL and PL/SQL Knowledge: Strong command of SQL and PL/SQL for data manipulation and report generation within Oracle environments.

BI and Reporting Tools: Experience with business intelligence (BI) and reporting tools such as Oracle Business Intelligence Publisher (BI Publisher), OTBI (Oracle Transactional Business Intelligence), and other relevant Oracle reporting tools. 2 M i l t o n S a n j i

PROFESSIONAL EXPERIENCE

C0gnizant Plano, TX Sep 2020 - Present

Senior Data Analyst Manager

Developed and recommended business solutions by thoroughly analyzing requirements and constructing detailed workflow charts.

Spearheaded data quality initiatives using Azure Data Factory and Data Bricks, increasing data reliability by 30%.

Led sprint planning sessions, translating complex business needs into technical requirements, and managing product backlogs.

Authored complex SQL queries to extract, manipulate, and analyze data, decreasing retrieval time by 20%.

Delivered regular progress reports to management, addressing challenges with strategic mitigation plans.

Evaluated BI requirements and formalized design specifications, ensuring alignment with business needs.

Executed and monitored ETL deployment processes, focusing on efficiency and accuracy.

Specialized in ETL troubleshooting and performance optimization, significantly reducing processing times and improving data throughput.

Resolved QA-identified defects promptly, ensuring data quality and service continuity.

Collaborated on data management, reducing data irregularities by 15%.

Developed SQL scripts for data extraction, reducing data load time by 25%. Integrated Project Services Blue Bell, TX

SQL Database Developer

Feb 2018 - Aug 2020

Utilized advanced SQL techniques, including joins, correlated and non-correlated sub-queries, to address complex business queries involving multiple tables from different databases.

Streamlined ETL operations with SSIS, enhancing data loading speed by 25%

Utilized DAX functions for complex data analysis, optimizing report development processes.

Improved database performance through optimization techniques such as normalization, indexing, and adjusting Transaction Isolation levels, along with monitoring logs for batch process completion and script integrity.

Led team initiatives to improve Power BI report quality by incorporating diverse data sources.

Conducted comprehensive data analysis and reporting using various SSIS transformations like Data Conversion, Conditional Split, Bulk Insert, Merge, and Union All.

Successfully created data mappings between two distinct data models, enhancing data integration and consistency.

Created and managed databases and schema objects, including tables, indexes, and constraints. Established connections between various applications and the database, and authored functions, stored procedures, and triggers.

Designed and implemented stored procedures and triggers to automate tasks, boosting system efficiency and reducing manual intervention.

3 M i l t o n S a n j i

Regal HH Care Bensalem, PA

MSBI Developer

Jan 2016 - Jan 2018

Developed a wide range of advanced reporting solutions, including matrix and tabular reports with dynamic features like drill-down and drill-through, using SSRS.

Expertly created and managed various report types such as Ad-Hoc, Summary, Sub, and Drill-down Reports in SSRS, meeting diverse business reporting needs.

Implemented and maintained daily report subscriptions for users through SQL Server Reporting Services (SSRS), ensuring consistent and accurate data dissemination.

Designed and produced compelling graphical representations, including charts and dashboards in SSRS, to provide clear, insightful data visualizations.

Utilized Power BI for responsive on-demand report generation, offering agile data analysis and reporting solutions.

Orchestrated the extraction and integration of data from diverse sources like Access, Excel, and flat files into SQL Server 2008, utilizing SSIS packages.

Performed comprehensive data analysis, employing a range of SSIS transformations to ensure data quality and meaningful reporting.

Played a key role in developing and optimizing stored procedures, functions, and triggers, contributing to streamlined and automated database operations.

EDUCATION CERTIFICATION

BSc in Information Technology University of Buea AS GCE A4 Cameroon Protestant College (CPC Bali)

TECHNICAL COMPETENCIES

Software & Tools: MS Azure Power BI MSBI (SSIS, SSAS, SSRS) SQL Server Developer Data Analytics Power BI Desktop Power BI Service SQL SERVER Data Tools SQL SERVER Management Studio Oracle Enterprise Manager SQL*Plus SQL Loader Toad SOAP Oracle Fusion Cloud Data Bricks Cloud Miner Data Lake Microsoft Office Suite 365 Google Docs SharePoint Salesforce Lightning Operating Systems: Mac Microsoft Windows IOS Linux

Contact this candidate