Business Data Analyst Resume Samples

Description :

1. Responsible for working closely with various stakeholders groups to build business requirements and functional design documents.
2. Writing the QA and UAT test scripts and coordinating the end to end system testing, mapping the business processes, designing the data bases, building training and knowledge management documentation.
3. Worked on the design and implementation of a company-wide application for technical documents. The system put together 140 technical documents under one umbrella.
4. The application allowed the pilot, flight attendant, and maintenance documents to be deployed on iPhones and ipads instead of paper, causing a huge reduction in the fuel consumption and increased productivity.
5. Conducted business requirements elicitation, created detailed functional requirements, worked on the RFP questions and selection.
6. Managed the daily scrum meetings, defined the user scripts and managed the product backlog using the agile methodology.
7. Facilitated the communication between various functional teams and the vendor to determine the application problems, remediation approaches, and the implementation path.

Experience

10+ Years

Level

Consultant

Education

M.S

Description :

1. Scheduled and conducted joint application development (JAD) sessions with stakeholders to gather business and data requirements for the Alabama state centralized eligibility and enrollment software.
2. Analyzed Medicaid and center for Medicare and Medicaid (cms) required skip patterns and created screen mock-ups in order to design and develop forms for a recipient eligibility website.
3. Used team foundation server (TFS) feature level requirements to create relevant user stories and develop acceptance criteria for product backlog items (PBI).
4. Worked closely with the Medicaid claims provider representatives to develop and validate test scenarios for user acceptance testing (UAT).
5. Identified and analyzed cross functional requirements for cross agency system and data integration.
6. Facilitated efforts for cross team synchronization in preparation for the data migration process.
7. Examined data on both mainframe systems and relational databases to produce a system field level gap analysis.

Experience

2-5 Years

Level

Junior

Education

B.S

Description :

1. CSP project is undertaken to bring all the current and new health plus's medicaid business standards into single standard facets platform.
2. Participate in JAD sessions to understand the existing and new business requirements, and documents the respective design specifications for 834 and 837 processes.
3. Interact with the users, subject matter experts (sme) and other stakeholders to acquire a better understanding about the business processes and needs.
4. Analyze 834 & 837 companion guides published by the state to document a detailed map to the facets data elements.
5. Analyze the source data coming from oracle and working with business users & developers to develop the model.
6. Review test cases and scenario documents prepared by the unit testing team and make recommendations wherever necessary.
7. Participate in daily defect meeting calls and coordinate the user-acceptance testing efforts with the business users and the sme.

Experience

5-7 Years

Level

Senior

Education

MBA

Description :

1. As a Lead Business Data Analyst gathering data requirements for migrating mainframe DB2 into Hadoop data lake.
2. Define and document the solution approach for maintaining near real time data in the hive and performing validation, execute QA scripts and submit the report.
3. Involved in creating hive tables, loading data and writing hive query for internal ad-hoc reporting requirements.
4. Analyze and evaluate data/information gathered from multiple sources and reconcile/address conflicts or business issues.
5. Responsible to identify, analyze, and interpret trends or patterns in complex data sets and develop graphs, reports, and presentations of results.
6. Define the requirements for the strategic data interface between Hadoop data lake platform and cross platform components.
7. Actively participated in project phases and report status to the director, including feasibility, requirements, development, quality assurance, implementation, and maintenance.

Experience

2-5 Years

Level

Junior

Education

B.E

Description :

1. Worked with internal business clients and business leads to create functional requirement documentation. Interfaced with internal and external stakeholders to understand tool, promotion, and process enhancements.
2. Developed numerous supply chain KPI's including freight cost rate, fuel surcharge, order tracking, forecast volume, various inventory reports, backorders, internal customer service report etc using Cognos, bo, ms access and excel, Visio.
3. Perform data mining activities of gathering and compiling data to make a thorough analysis of data integrity issues with respect to the data provided by lsps(logistics service providers), and to extract the relevant information for metrics reporting and KPI measurements.
4. Developed/published online reports using Cognos to replace existing bo reports on freight costs, costs of goods mfg, savings on goods delivered Air vs. Sea, thus increasing web visibility to our data warehouse and allowing for more informed decision making by managers and senior executives.
5. Designed and developed a series of complex business intelligence solutions via business objects(designer, desktop intelligence, and web intelligence) and Cognos 8 reporting system and tools using best business practices guidelines.
6. Interacted with clients to understand the reporting needs, evaluated requirements, designed, developed and implemented reporting using Cognos and business objects. Provided ad-hoc reporting support.
7. Created different KPI dashboards in report studio using a combination of the list, crosstab, graph and map reports.

Experience

10+ Years

Level

Management

Education

B.S.E.E

Description :

1. Generate reports of transactions using sql server reporting services (ssrs).
2. Designed and developed reports to be used in the comprehensive annual financial report (cafr).
3. Designed dashboard for management to gauge performance of various departments at a glance.
4. Built effective queries for high-performance reporting and rendered them to html, xml, pdf and excel formats using reporting services (ssrs).
5. Generated parameterized/drilldown reports using sql server reporting services (ssrs) 2008.
6. Created drill-through, drill-down, linked reports and sub-report using rdl.
7. Generated various report models on views (due to security issues) and deployed them on to the production reporting server and generated various report models and ad-hoc reports.

Experience

7-10 Years

Level

Consultant

Education

B.S.E.E

Description :

1. Created the product backlog and roadmap based upon the company vision provided by the strategic goals and client needs. Worked closely with the engineering department to ensure that the product vision is accomplished through delivering prioritized user stories.
2. Developed and owned the product strategy and roadmap for the web-based portal.
3. Managed the complete product lifecycle from requirements gathering to prioritization to product release.
4. Gathered product requirements from internal and external customers to create detailed business and functional requirements.
5. Worked closely with the engineering team to deliver new product features, enhancements, and critical defect fixes.
6. Presented product strategies, roadmaps, and solutions to external and internal stakeholders.
7. Utilized sql queries to perform data mining on real estate data from sql server and created dashboards and reports in tableau to provide to the senior management and advised them on trends and emerging enterprise data management and business analytics technologies and strategies.

Experience

10+ Years

Level

Management

Education

M.S

Description :

1. Working as analyst/data scientist on various projects to analyze and report insurance systems data.
2. Responsible for gathering business and technical requirements, source system analysis, gap analysis, data profiling, requirements documentation for ETL development and report development.
3. Responsibilities involve performing UAT testing & report testing. Attending data model walkthroughs and providing feedback to assist modeling, architecture, ETL team on daily basis.
4. Walkthrough of requirements mapping document and impact analysis with respect to any changes in the ETL process.
5. Monitor project progress by tracking activity, resolving issues, publishing progress reports and recommending actions.
6. Collect, analyze, and summarize information and trends to create technical reports.
7. Analyze requirements and document functional and business user requirements to assist in the design of applications.

Experience

10+ Years

Level

Management

Education

B.E

Description :

1. Wrote business requirement and design specification for a system enhancement using requisite pro document template.
2. Document the system flow for the scheduling functionality enhancement in Visio.
3. Reviews reports to determine basic characteristics, such as origin and report flow, format, frequency, distribution and purpose or function of report.
4. Captured database data in an excel spreadsheet (formatted data) for an extract and load process to be import data from one application to another application.
5. Worked closely with the business to align needs with the technical team to ensure all SDLC phases and project compliance were met for the Siemens Teamcenter upgrade.
6. Provided data mapping, user interface specifications and processing logic per business requirements to the developers.
7. Provided data mapping from client application to oracle, sql server, db2.

Experience

5-7 Years

Level

Senior

Education

B.E

Description :

1. Configuration of testing scenarios to validate new systems design and release.
2. Responsible for testing system configuration and validation of business requirements.
3. Maintain internal database for daily error report and perform data clean-up.
4. Monitor and oversight sanctions for physician medical license with michigan department bureau health.
5. Participate on various workgroups for data compliance and improvement.
6. Provided guidance and furnished solutions to program manager, project managers, and technical lead on documentation procedures and development.
7. Creation and distribution of daily, weekly, monthly and quarterly reports, including provider reports, quarterly ppg/pmg reports, kpi and dashboard reports. Heavy ad-hoc reporting.

Experience

7-10 Years

Level

Management

Education

MBA

Description :

1. Redesigned business processes by building several ms access databases to help automate manual processes, meet legal requirements, and track data.
2. Performed analysis of current system and data, gathered business requirements through interviews, and develop solutions and recommendations for a new database with additional functionality.
3. Wrote user manuals, technical manuals, flowcharts; designed reports and provided user training.
4. Provided a stable access database to track records, create new records, edit info & provide reports.
5. Collect, analyze, and report data from various internal systems with the end goal of a renewal quote to the customer.
6. Provided user interface specifications and processing logic per business requirements to the developers.
7. Provide data mappings (source to target), user interface specifications, processing logic as per business requirements to the developer.

Experience

5-7 Years

Level

Executive

Education

B.S.B.M

Description :

1. Exporting of data from complaint management and enterprise resource planning systems for monthly trending that include JD Edwards, sales force 13, Cognos and Oracle.
2. Generate monthly complaint trend reports, service metric dashboards as required by product platform.
3. Evaluate the statistical methods and procedures the finance and sales teams used to obtain data to ensure validity, applicability, efficiency, and accuracy.
4. Conduct statistical analyses and data mining to uncover trends, predict future events and assess the merits of various courses of action and present the results and recommendations in a graphical format to stakeholders that enable data driven decisions.
5. Review and present cost analysis reports on a monthly and quarterly basis to finance, sustaining and manufacturing teams.
6. Analyzing data trends develop performance measurements and scorecards while providing results in both numeric and graphical formats daily to ensure that the client's goals are on track.
7. Respond to new requests including understanding the customer objectives and processes, reviewing and refining requirements, and communicating estimated timeline for completion.

Experience

5-7 Years

Level

Senior

Education

C.G.A

Description :

1. Focus On Financial Modeling and the use of advanced formulas in Spreadsheets, Qlikview Designer to create Dashboards.
2. Extensive Knowledge Of MSP, LALP, I Clear, Fafs, Lps Desktop, VendorScape, LivIvolt, F/Laws Applications.
3. Responsible for collaborating with business stakeholders to build QlikView solutions.
4. Designed and developed analytics and reporting solutions using QlikView.
5. Use of complex excel formulas for analyzing cost savings, reporting on performance metrics and data integrity.
6. Provide data mappings (source to target), user interface specifications, processing logic as per business requirements to the developer.
7. Analyze and interpret financial data for use in management reviews and decisions.

Experience

2-5 Years

Level

Junior

Education

B.B.A

Description :

1. Created visually impactful dashboards in Excel for data reporting by using pivot tables and VLOOKUP. Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information hence reduces the manual report creation time by 20%.
2. Compile interactive reports indicating outliers within users servicing the message feature and created visually impactful dashboards for technical assistance process of the HIPAA compliant application.
3. Using Tableau to ideate data and measured business performance periodically and improvising the experience by 15%.
4. Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information.
5. Optimized data collection procedure and generated reports on a weekly, monthly and quarterly basis.
6. Presented findings and data to the team to improve strategies and operations.
7. Data entry, data auditing, creating data reports and monitoring all data for accuracy.

Experience

7-10 Years

Level

Senior

Education

M.S

Description :

1. To assess the strategic objectives for projects related to subscriber marketing & management, develop, define and document functional requirements and present solutions to both business and development teams.
2. Document functional requirements based on the requirements outlined by the business.
3. Conduct data analysis using SQL & teradata to assist in the development of the solution.
4. Communicate, present and facilitate meetings with sxm business and it personnel.
5. Highlight and flag open issues, dependencies and assumptions during business requirements review meetings.
6. Act as a liaison between the business and development teams communicating project status and issues regarding development and implementation.
7. Use advanced sql queries for analysis and research for specific requirements and solutions.

Experience

10+ Years

Level

Management

Education

B.S