PROFESSIONAL SUMMARY:

• Over 9 Years of experience in the areas of financial reporting, budgeting, forecasting and analysis, SQL queries.
• Team - Player with motivation and ability to work independently, Worked closely with the Business Analysts and Data Analysts and Functional Design Teams
• Expert in Data Analysis, Design, Development, Implementation, and Testing utilizing data conversions, Extraction Transformation Loading and SQL server
• Knowledge of python packages such as Pandas, NumPy, and Matplotlib etc.
• Knowledge of Microsoft Azure services such as Azure Data Factory (ADF), Azure Synapse Analytics, Databricks, Cognitive Search, Power platform, and Blob storage.
• Experienced in analyzing BI needs, interpreting business requirements, and translating them to reports/dashboards. Written python scripts for data mining, and analysis
• Sound knowledge in writing complex SQL queries
• Efficient storyteller and created appealing, goal-oriented dashboards in Power BI for target audience.
• Designed insightful Visualizations and Interactive Dashboards both in Power BI and Tableau environments.
• Superior analytical skills; good Excel skills and good eye for detail

TECHNICAL SKILLS:

Software: Python, PL/SQL, R, Data visualization (Tableau and power BI), Pyspark, Azure and advanced excel

Framework/Technologies: Azure data brick, Machine learning

Storage: MySQL, Azure, ETL

Transferable skills: Critical Thinking, Team Player, Problem-Solving, Integrity, Negotiation and Persuasion, Presentation Skills.

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst

Responsibilities:

• Created ad-hoc SQL queries to profile data from DB2 and SQL Server database frameworks using joins, data base associations, and transformation rules.
• Used data analysis tools to approve business rules and identify poor quality missing data in existing data.
• Involved in converting Hive/SQL queries into transformations using Python
• Used Python scripts to update the content in database and manipulate files.
• Created Machine Learning Models, such as LASSO regression, that accurately predict patient risk outcome.
• Extract Transform and Load data from Source Systems to Azure Data Storage services by using a combination of Azure Data Factory, Spark SQL, T-SQL, and U-SQL Azure Data Lake Analytics.
• Written SQL queries, PL/SQL Packages, Stored Procedures, Functions, Triggers, and done Performance Analysis, Partitioning, Indexing, and Aggregating Tables as needed.
• Expertise in developing PL/SQL Stored Procedures, Packages, Functions, Triggers, Indexes, PowerShell scripting, Performance Tuning.

Confidential

Data analyst

Responsibilities:

• Extract Transform and Load data from Source Systems to Azure Data Storage services by using a combination of Azure Data Factory, SparkSQL, T-SQL, and U-SQL Azure Data Lake Analytics.
• Created appealing, goal-oriented dashboards in Power BI for target audience.
• Created new objects: PL/SQL procedures, functions, and packages for data population and manipulation as per user requirements.
• Developed time-based and event-based triggers for ADF pipelines.
• Worked on Data modeling and developed PL/SQL programs based on the requirement
• Used various sources to pull data intoPower BIsuch as SQL Server, SAP.
• Wrote standard and complex SQL Queries to perform data validation to make sure test results matched back to expected resultsbased on business requirements.
• Create, modify, and troubleshoot SQL queries, stored procedures, and jobs.
• Worked on Power BI and prepared dashboards to make it more attractive and explored data in a variety of ways and across multiple visualizations using Power BI.
• Prepared Budgets ($50 million USD) and running forecasts.
• Created ad-hoc SQL queries to profile data from DB2 and SQL Server database frameworks using joins, data base associations, and transformation rules.
• Developed monthly variance reports highlighting significant variances in actuals and forecasts.
• Reviewed and allocated operating center cost ($50 million) to various countries based on man-hours, turnover etc.
• Developed comprehensive financial reports by collecting, formatting, and studying key data points.
• Collaborated with the accounting department to study and reconcile various accounts. Achieved 100% clearance of old and unreconciled accounts.

Confidential

Data analyst

Responsibilities:

• Wrote several SQL Scripts such as finding tables that have Identity Columns, finding tables that do not have primary key.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• As part of data analysis tasks, reverse engineered models and deleted unneeded tables/columns from SQL server databases.
• Used data analysis tools to approve business rules and identify poor quality missing data in existing data.
• Related to data analysis, specifically identifying data sets, source data, source meta data, data definitions, and data formats.
• Produced timely and accurate financial and progress reports and submitted for consideration during key decision-making process.
• Created 3 years Budgets ($60 million) and competitor analysis.
• Led and supervised internal, statutory, regulatory audit and tax compliance requirements and met 100% of deadlines for completing and implementing audit recommendations.
• Implemented withholding tax and met 100% of deadline for tax payments and filing returns.
• Reduced bad debts by $10 million through analysis and recommendations endorsed by management.
• Saved $300+K cost to company by developing in-house IFRS 9 model using analytical and statistical skills to overcome statutory reporting challenge.
• Saved company $50K in annual costs by reducing turnaround time 30% through new and accounting protocols.

Confidential

Senior officer

Responsibilities:

• Analyzed the deviation between actual & budget results, Monthly / quarterly and yearly and communicated findings to stakeholders.
• Enhanced overall efficiency of organization by $100K annually through implementing better systems and procedures.
• Effectively analyze, investigate, and report variances of actual results to budget, forecast and prior periods
• Worked with investment firms and private investors providing due diligence, and underwriting functions for the acquisition and management of portfolios.
• Reviewed customers financial needs and recommend appropriate solutions to help achieve goals.
• Found unique solutions for clients to have access to funding for business and personal projects through lending channels.
• Manage multiple client accounts and maintain effective communication with stakeholders
• Identify important data insights and generate reports using business intelligence software
• Formulated Power BI scorecards utilizing stack bars, bar graphs, geographical maps, KPIs, gauges to help in analysis of data insights.
• Analyze large amounts of data effectively and accurately
• Ensure data integrity and accuracy in all reporting and budgeting/forecasting
• Identify opportunities and recommend improvements for reporting efficiencies
• Partner with finance to manage financial planning and forecasting processes
• Managed the preparation of projected financial statements, computation of total income & tax liability of companies, partnership firms, trust, and individuals under the provisions of Income Tax Act, 1961
• Conducted Tax Audits for different organizations while complying with statutory provisions
• Generated the following reports: