Business Intelligence Analyst Resume

SUMMARY

Highly motivated Business Intelligence Developer with 10+ years of experience in Database/Reports Design, Development, Implementation, Test and Production environments for various business applications.
Qualified PMP with s ubstantial experience managing multiple projects (impact analyses, data analyses, leading meetings, gathering requirements, assigning tasks, development, QA, and deployment.

AREAS OF EXPERTISE

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Analyst

Responsibilities:

Work closely with Sales, & Marketing departments to build sales and financial reports using SQL and Power BI.
Utilize MS Power platform and MS serverless technologies to streamline and automate everyday business processes like Safety feedback application which stream data from the manufacturing warehouse and alert managers based on certain indicators in real - time.
Work with the Purchasing department to develop supply chain solutions using SQL, AWS Forecast and Power BI.
Plan, design and develop enterprise-wide BI solutions from the ground up.
Install and configure Enterprise Power BI services, SSRS and MS gateway.
Monthly presentations and training to the end users about the reports and their changes.
Participate in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
Transform complex business logic into Database design and maintaining it by using Python and SQL objects like Stored Procedures, User Defined Functions, and other SQL server objects.

Confidential

Senior BI Developer

Responsibilities:

Designed, maintained, and enhanced reports and dashboards using Power BI and SSRS.
Created SSRS reports (Parameterized, Linked, Snapshot, Cached, Ad hoc, Click-through, Drill down, Drill through, Subreports)
Designed, created, and developed numerous SSIS packages to download/upload data
Performed technical analysis for encounter data reporting requests from internal and external applications.
Provided support to internal and external data integration to ensure data interchange meets technical expectations and criteria.
Ensured the validity of all encounter data processing and accuracy of all reporting produced.

Confidential

BI Developer

Responsibilities:

Developed, tested, debugged, monitored, and offered support to the nightly SSIS ETL process.
Project lead for the OCR project (gather requirements, Impact analyses, data analyses, data mapping, development, and testing).
Automated the OCR reporting process.
Designed, developed, and deployed reports and dashboards in MS SQL server environment using SSRS.
Design, develop, test, tune and deploy databases solutions including but not limited to stored procedures, views, and functions.
Modify the existing SSIS packages to meet requirements.
Fine-tuned SSRS reports, SPs, and other database objects.
Created, modified, deployed, and scheduled SSRS reports.
Provided documentation for all kinds of reports and SSIS packages.

Confidential

Sr. SQL Server Developer

Responsibilities:

Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse and Data Mart databases.
Modified the existing SSIS packages to meet requirements.
Fine-tune SSRS reports, SPs, and other database objects.
Create, modify, deploy and schedule SSRS reports.
Provide documentation for all kinds of reports and SSIS packages.
Participate in designing a standard SSIS Template to organize the ETL process for the entire team.