SUMMARY:

• Confidential is a motivated and results - driven BI developer with a proven track record in Business Intelligence (BI) with over 5 years of experience with MS Excel and PowerBI for data visualizations. In his current position, Confidential is responsible for writing reports, extracting and cleansing data from a variety of relational databases, writing and optimizing SQL queries, and then creating dashboards in PowerBI and Tableau. In his addition to his expertise in these BI tools, Confidential is also an Excel power user, including VLookups, pivot tables, and macros. Additionally, Confidential has been able to automate reports using Power Automate. Confidential has mostly worked with SQL Server databases, with exposure to Oracle as well. Confidential is available for a new project immediately.
• Highly organized and result-oriented Data Reporting Analyst/BI Analyst with a 5 years’ experience in Data Reporting and Developing Visual Basics for Applications (VBA) in Access & Excel for Various Domains such as finance, Insurance and Social Services.
• Extensive professional experience in design, development, implementation and support of mission-critical Business Intelligence (BI) applications
• Proficient in MS Office Suite, Visual Basic, MS Access, Microsoft Query and SQL Server Database.
• Created PowerBI reports in pivot charts, graph and other visualization format to analyze trends
• Experience in data manipulation using ODBC, DAO ADO Objects in MS Access VB6
• Worked on small and large-scale projects. Believe in teamwork
• Solid background in Table/query design, report design, and automation utilizing VB modules
• Knowledge of Relational databases that includes the design of multiple tables, assign permissions, set up constraints, triggers, etc.
• Advanced knowledge of generating reports from SQL server in MS Excel connection using VBA
• Proven background translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze, and deploy programs for finance industry.
• Experience in understanding industry level databases and writing complex SQL queries for optimized reports
• Understanding of Microsoft access Database
• Experience in Data Analysis and manipulation of complex data set for business need
• Experience in writing SQL to generate queries in Database for exporting purpose
• Proven experience in writing SQL queries, experience in data analysis involving data cleaning, data visualization and statistical analysis, analyzing results and effectively communicate findings to the stakeholders.
• Ability to interact and work with internal & external stakeholders/vendors/clients at all levels.
• Self-aware, reflective and able to learn from mistakes, with an ability to learn quickly while on the job

TECHNICAL EXPERIENCE:

Programming Languages: VBA, SQL, DAX, R, T-SQL

Tools: & Software/Databases: MS-Access 2.0/97/2000/XP/ 2002/2003/2007, SQL Server 2000 MS (Access, Excel, Word, PowerPoint), Microsoft SQL Server 2012, SQL Queries Optimization, Oracle SQL Developer/SQL Plus VLOOKUP, Pivot table, Macros, PowerBI, Tableau

PRFESSIONAL EXPERIENCE

Confidential, Princeton New Jersey

Power BI Developer

Responsibilities:

• Participated in requirements meetings and data mapping sessions to understand business needs. Documented requirements in Business Requirement Documents
• Integrated Custom Visuals based on business requirements using Power BI desktop
• Developed complex calculated measures using Data Analysis Expression language (DAX)
• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports
• Created Workspace and content packs for business users to view the developed reports
• Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week
• Worked on all types of transformations that are available in Power bi query editor
• Installed and configured Enterprise gateway and Personal gateway in Power bi service

Confidential Newark, New Jersey

Power BI Developer

Responsibilities:

• Published Power BI Reports and Made Power BI Dashboards available in Web clients and mobile apps
• Used Power BI Dax and Power Query language as interface for intuitive graphical design.
• Building dynamic dashboards from Power BI desktop and publish to Power BI web.
• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.
• Used Power BI to utilize SQL connections to create dashboard for different users.
• Created Gateway connection from Power BI cloud to SQL and SharePoint.

Confidential, LAREDO Texas

Data Reporting Analyst/ BI Analy

Responsibilities:

• Wrote VBA to create automation for file transfer process
• Wrote VBA codes to refresh reports weekly
• Developed pivot reports in Excel as per business needs
• Created appropriate Vlookup functions for Reporting needs
• Wrote VBA codes for automated transferring of data between spreadsheets and workbooks
• Automated Importing of data to Access and SQL Server from flat files and Excel spread sheets
• Manual review and correction of numerous errors and gaps for dataset using Data Analysis Expressions
• Created PowerBI reports in pivot charts, graph and other visualization format to Analyze trends
• Worked with the Business users to understand what reports were critical, non-critical and not needed.
• Environment: MS Access (VBA), MS Excel (VBA), PowerBI, SQL Server, Visual Basics for Application, Tableau, T-SQL

Confidential, Somerset NJ

Junior Reporting Analyst/ BI Analyst

Responsibilities:

• Created MS Access database to collect data systems in order to provide lists, status reports and management overview reports
• Created Dynamic Charts/Graphs in MS Excel and MS Access using VBA
• Created Power BI reports in pivot charts, graph and other visualization format to Analyze trends
• Created Queries, Reports and Forms in MS Access using VBA
• Created VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
• Created Excel PowerBI Analysis and reports using VLOOKUP, Pivot tables and complex DAX languages
• Downloaded and Prepared sample financial analysis data in excel format for student's practice.
• Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas
• Manually modified the SQL in Report Studio to tune and/or to write complicated reports
• Wrote SQL's to implement report specific queries in reporting.
• Environment: MS Access (VBA), MS Excel (VBA), PowerBI, SQL Server, Visual Basic

Confidential, Nigeria

Junior Reporting Analyst/BI Analyst

Responsibilities:

• Created Data entry Forms using VBA
• Created Graphs for Spread Sheets and MS Access Reports.
• Created PowerBI Dashboards to present critical company data in a single report
• Created Pivot Tables to view summarized Spread Sheet Data
• Imported data from pre-existing text files and excel spreadsheets
• Generated the necessary PowerBI reports and information to litigate tax appeals for properties.
• Documented weekly meetings with internal and external Stakeholders
• Processed property’s annual Income and expense statement requests from Municipals across the country.
• Environment: MS Access (VBA), MS Excel (VBA), PowerBI, SQL Server, Visual Basic