Sales Sap

MADIHA FATHIMA

Email: ***************@*****.***, Ph #: 201-***-****

www.linkedin.com/in/madiha-fathima

Work Authorization: H4 EAD, New Jersey 07601

PROFESSIONAL SUMMARY:

Eight years of IT experience in developing Reports/Dashboards and working with Business Intelligence tools for major clients in industries like Health Care, Banking & Financial, Manufacturing

Practiced Standard Software Development Methodologies like Agile, Waterfall and full Standard Life Cycle development (SDLC) to produce quality BI application solutions in efficient manner

Expertise in collaborating and working as a Business Analyst with Stakeholders at various levels and with cross-functional teams on gathering/documenting requirements, providing estimates, creating detail design specifications translating into operational reports/dashboards

Prepare operating reports and business plans for departments based on actual performance, previous budget figures, estimated revenue, expense reports and other factors

Well versed in clearly articulating information to subordinates, DBAs application teams and customers, both verbally and in writing

Participated in project management activities on assigned tasks to ensure projects stay on budget and are completed within agreed upon timeframes

Detailed practical / working knowledge of the issues / challenges associated with managing data, data quality, analysis and data warehousing and reporting

Good knowledge of Excel reporting features like charts, pivot tables, advanced formatting, and utilization in designing/reconciling banking reports

Expertise in working on Business Intelligence using Tableau Desktop 10, Power BI, SAP Business Objects, Web Intelligence, and Crystal Reports

Expertise in providing solutions on SAP BO 4.2, 4.1, 3.1 and other BI systems and applications

Proficient in Tableau development/visualization, including designing and developing reports and dashboards with large data volumes

Experienced in IFS ERP report development on Sales and manufacturing reports with Financial Reports/Dashboards

Experienced working with different data sources for report development and well versed with Data warehouse concepts and relational databases

Experience in SAP HANA views, MS Access, SQL server, and Oracle Toad

Ability to prioritize work, excellent problem-solving abilities, troubleshooting critical production issues, and Root Cause Analysis

Highly analytical and self-motivated with solid attention to detail qualities

EDUCATION:

Bachelor of Engineering in Information Science & Engineering, Visveswariah Technological University, India 2006

TECHNICAL SKILLS:

Business Intelligence Tools/Databases: SAP Business Objects 4.2, 4.1, 4.0, XI 3.1/R2, Crystal Reports 2008, XI, 2016, Webi, Launch pad, Info view, CMC, CCM, CMS, Tableau, Oracle, Sql Server, SAP HANA, MS Access

Domain Knowledge: Manufacturing and Sales, Accounting & Financial, Health Care Industry

PROFESSIONAL EXPERIENCE:

Fresenius Medical Care, NJ Nov-2019 – Present

Business Intelligence Developer

Involved in translating user requirements into functional & design specifications, communicate with report consumers to gather specifications, review designs, present drafts, and validate results on LIMS (Mckesson’s HLab)

Collaborate with Corporate management and Internal business leads, VP to understand the business needs and report them onto BI Dashboards

Prepare operating reports and business plans for departments based on actual performance, previous budget figures, estimated revenue, expense reports and other factors

Lead meetings held with management of applicable Microbiology and chemistry departments and Senior Management. Prepare agendas, PowerPoint presentations, meeting minutes, as needed

Well versed in clearly articulating information to subordinates, DBAs application teams and customers, both verbally and in writing

Help Spectra Labs to identify gaps in the current BI system and participate in creating new solutions to fill these gaps. Solve difficult problems as needed through proposing insightful, knowledgeable, effective solutions

Develop new/modify existing reports using Crystal reports, SAP BO Webi and other reporting tools and implement them as operational, system specific healthcare reports onto Symfonie Analytics, Create and/or generate on demand ad-hoc data requests, summaries and exports as part of client onboarding process and build the security as per Client requirement

Perform Production release and validate, Prepare Release notes and share with QA team to perform post production release validation on Service Now

Individual contributor in performing full stack report development activities from support to development to implementation

Working on Optimizing the performance of BI systems, improve report performance, analyze the server logs and debug report timeout issues

Working knowledge of regulatory and quality standards (State Laws, HIPAA)

Experience building Tableau dashboards to show insights of different lab operations, dashboards, and facility-level detailed reports for relational managers, directors, and the vice president

Strong experience developing, testing, and delivering complete visualization solutions on tableau

Ability to adapt in changing environments, root cause analysis/solve problems, and develop solutions with project specific documentation

Mistras Group, NJ Mar 2019 – Oct 2019

Business Reporting Analyst

Managed and administered IFS BI solutions in multiple environments – Development, Test and Production

Analyzed business requirements and developed BI solutions like reports, SQL scripts using SQL, PL/SQL on Oracle TOAD, Ms Access as per reporting needs

Participated and contributed to internal and/or external client workshops/meetings to gather, understand, and document client's project goals, workflows, complex business needs, gaps, and opportunities

Conducted Business Analysis efforts for Mistras projects and initiatives. Determined how changing business needs will affect the system, product, and process. Described the business need and potential solution in terms that both business and IFS technical teams can understand

Understand the IFS system architecture and functionality and assessed the feasibility of client requests and applied the features of the IFS and Operational Crystal reporting as applicable

Participated in project management activities on assigned tasks to ensure projects stay on budget and are completed within agreed upon timeframes. Escalated budget and/or change of scope variances as appropriate

Involved in report development using Crystal Reports 8.5 on IFS ERP 9, expertise on building/updating Quick Report (Report Designer) and Order report

Configured, tested, deployed, and maintained IFS reports SQL scripts provide on the go resolutions/work around for production issues and document fixes for future references/internal audits

Good Understanding of IFS modules like Procurement, Finance, Sales, CRM, Engineering, Supply Chain Management, HR Payroll modules

Provided solutions to customized reports on crystal adhering IFS limitations during development and implementation on application

Worked closely with IFS implementation and Infrastructure team to maintain, upgrade, and optimize IFS systems performance - database server (Oracle, Access) and application servers, troubleshoot and debug IFS system errors

Successful Go Live implementations and built customized BI solutions on IFS 9 for various Mistras locations in USA, Canada, and Germany with language specific reports

Maintained BI user security - roles, permissions, and profiles

Worked on Custom Objects (Events/Trigger, Menu, Fields, Information Cards), IFS Lobbies, and Report rules

Developed and Optimized PL-SQL queries on Oracle, monitored explain plan and performance tuned the queries to make reports run faster and accurate

Involved in Performance Tuning – Optimizing the functions and procedures which were reported to have low performance. This was done by finding the cost and execution path using EXPLAIN PLAN

Created PandL, Margin, Trail Balance, Cash Statement, customized PO’s, Invoice, and various sales reports

Environment: IFS ERP, Crystal Reports, Oracle Toad, Ms Access, Sales, Manufacturing, and financial reporting

Honeywell Aerospace, India Oct 2013 - Jul 2015

BI Consultant

Designed and developed dashboards using SAP Web-I 4 on Launch pad. Most of the reports are based out charts & graphs like bar chart, Column chart (side by side, stacked), line graphs, pie -charts etc. by using chart expert of Webi

As a key SAP BO consultant, lead a team of four developers in the designing of Webi reports, universes, and Xcelsius. Successfully implemented interactive dashboards which were appreciated by clients

Interacted with client during all phases right from requirement gathering, designing, implementing reports on the business users platform

Performed SQL tuning of queries using various tools like EXPLAIN PLAN, SQL*TRACE, AUTOTRACE. Optimized the queries for better performance

Conducted meetings with users to get the requirement correctly and finished the tasks within the time frame

Extensively used WebI features like report filters, Merge dimensions, drilling, Element Linking, Input Controls

Helping client on ad-hoc reporting, validating data in production systems contributing to the decision making

Experience on SAP BO security setup in CMC, access levels across users/groups. Upgraded universe and reports from 3.1 to 4.1 using upgrade management tool, Information Design Tool, and fixed issues

Performed various BO admin tasks on CMC (SAP BO 4.1) like Creating/Administrating Users & Groups, designated their Roles, & Access Levels for applications and folders. Scheduled reports for various business users, migrating universes, dashboards, reports to repository

UBS Banking and Financial, India Jan 2013 - Sep 2013

Business Intelligence Developer

Migrated various reports from actuate tool to SAP BI 4.0 using Crystal Enterprise and Webi

Involved in design and development of reports from scratch using Web Intelligence on Launch pad and Crystal Reports Enterprise 4.0

Developed required universes and derived tables for the DB procedures using Information Design tool (IDT) with appropriate prompts/filters

Acquired good understanding of the actuate tool for migrating reports w. r. t functionality and technical difficulties

Responsible of developing reports and delivering to QA, SQA teams along with the documents required for the project.

Developed report specific Technical specification document (TSD) and checklists for delivering the reports

Hands on experience on Oracle DB using Toad for developing functions to the procedures used in actuate reports.

McKesson Pharmacy Systems, India Sep 2010- Dec 2012

Business Intelligence Consultant & Reporting SME

Involved in communicating with Client on Business Requirements and functionalities of Application along with providing estimates for reporting needs

Rewarded as SME by client for having acquired thorough understanding of the business/McKesson Healthcare pharmacy application with technical expertise

Reported requirement analysis, template design, development, implementation and troubleshooting stored procedures based on Enterprise Rx application reports with Crystal reports 2008, Business Objects 3.1 and Jasper Reporting tools

Expertise in Root Cause Analysis (RCA), resolving prod issues/bugs using JIRA and provided complete details to end users on functionalities and database, documentation

Well versed using SVN Tortoise and VSS and create/version control BIAR files

Took responsibility on Troubleshooting and diagnose complex technical work, tuning of the reports and fixing the defects.

Worked on already existing reports to optimize and troubleshoot problems that occurred due to new business requirements.

Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces

Involved in performance tuning (SQL, PL/SQL) of func/stored proc using oracle tools Explain Plan, auto trace

Provided On Call Support and provide quick fixes after reports are deployed to production

Conducted discussions with Business Analysts (BAs) and end users to create several test scenarios for running the reports

IDMsys Health Care Information System, India Dec 2007- Jun 2010

Reports Developer

Developed Crystal Reports technical solutions for business requirements for IDMSys Healthcare application using Sage ERP SDK

Analyzed the client requirement and designed the weekly/monthly and MIS Reports in Crystal Reports related to Hospital Billing Management and Stock Management with designing the interface for same in VB forms.

Coordinated meetings with business users and development teams to gather System requirements and data requirements

Created/designed Crystal Report 8.5, XI using SQL Server for IDMsys HIS and Financial Modules

Created various financial reports for financial accounting modules like General Ledger, Accounts Payable and Accounts Receivable

Modified existing reports according to the user's requirement and exported reports to PDF format

Designed various VB forms for reports interfacing and integrated them on IDMsys HIS ERP using

Built complex queries in SQL, create views, and report off them in Crystal Reports

Modified the existing report if there was a change in the client’s requirements

Built complex reports using multiple sub reports, conditional suppression formulas, complicated formulae, Drill-down, Dynamic grouping, Cross-Tab, graphical charts, aging reports

Used VSS for version control of reports

Developed Cash and Bank Reconciliation Statements with Accounting Data by Vendor, Customer and GL Ledger Monthly Report, etc.

AWARDS AND HONORS:

Spot and Outstanding Contribution Awards from NTT Data, India

Contact this candidate