Description :

1. Responsible for working closely with various stakeholder 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 databases, building training and knowledge management documentation.
3. Worked on the design and implementation of a company-wide application for technical documents.
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 fuel consumption and increased productivity.
5. Conducted business requirements elicitation, created detailed functional requirements, and 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

B.S. in BA

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. BA

Description :

1. Participate in JAD sessions to understand the existing and new business requirements, and documents the respective design specifications for 834 and 837 processes.
2. Interact with the users, subject matter experts (sme) and other stakeholders to acquire a better understanding about the business processes and needs.
3. Analyze 834 & 837 companion guides published by the state to document a detailed map to the facets data elements.
4. Analyze the source data coming from oracle and working with business users & developers to develop the model.
5. Review test cases and scenario documents prepared by the unit testing team and make recommendations wherever necessary.
6. Participate in daily defect meeting calls and coordinate the user-acceptance testing efforts with the business users and the sme.
7. Collaborated with cross-functional teams to streamline data collection processes, reducing reporting time by 25%.

Experience

5-7 Years

Level

Senior

Education

M.S. HI

Description :

1. Gathering data requirements for migrating the mainframe DB2 into the Hadoop data lake.
2. Define and document the solution approach for maintaining near real-time data in the hive and performing validation, executing QA scripts and submit the report.
3. Involved in creating hive tables, loading data, and writing hive queries 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 for identifying, analyzing, and interpreting trends or patterns in complex data sets and developing graphs, reports, and presentations of results.
6. Define the requirements for the strategic data interface between the Hadoop data lake platform and cross-platform components.
7. Actively participated in project phases and reported status to the director, including feasibility, requirements, development, quality assurance, implementation, and maintenance.

Experience

2-5 Years

Level

Junior

Education

B.S. Business Analytics

Description :

1. Worked with internal business clients and business leads to create functional requirement documentation.
2. Developed numerous supply chain KPI's including freight cost rate, fuel surcharge, order tracking, forecast volume, various inventory reports, and backorders.
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).
4. Developed/published online reports using Cognos to replace existing reports on freight costs, costs of goods manufacturing, 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).
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. in BA

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 a dashboard for management to gauge the 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-reports using RDL.
7. Generated various report models on views (due to security issues) and deployed them onto the production reporting server, and generated various report models and ad-hoc reports.

Experience

7-10 Years

Level

Consultant

Education

M.S. Data Analytics

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.

Experience

10+ Years

Level

Management

Education

MBA

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

M.S. Data Analytics

Description :

1. Wrote business requirements and design specifications for a system enhancement using the 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 the report.
4. Captured database data in an Excel spreadsheet (formatted data) for an extract and load process to 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 from client application to Oracle, SQL Server, db2.
7. Collaborated with cross-functional teams to streamline reporting processes, reducing report generation time by 30%.

Experience

5-7 Years

Level

Senior

Education

B.S. in Bus. Analytics

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

M.S. HI

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 developed 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. Automated data collection processes, reducing manual entry time by 50% and minimizing errors.

Experience

5-7 Years

Level

Executive

Education

B.S. in BA

Description :

1. Exporting of data from the complaint management and enterprise resource planning systems for monthly trending that includes JD Edwards, Sales Force 13, Cognos, and Oracle.
2. Generate monthly complaint trend reports, service metric dashboards as required by the 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, developing 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

B.S. in BA

Description :

1. Perform financial modeling and utilize advanced spreadsheet techniques to create insightful dashboards.
2. Collaborate with business stakeholders to design and implement QlikView solutions that meet analytical needs.
3. Analyze financial data to identify trends and provide actionable insights for decision-making.
4. Develop and maintain complex Excel models to assess cost savings and performance metrics.
5. Provide comprehensive data mappings and specifications to developers to align with business requirements.
6. Conduct in-depth analysis and interpretation of financial data for management reviews.
7. Enhance reporting processes by integrating new analytical tools and methodologies.

Experience

2-5 Years

Level

Junior

Education

B.S. Finance

Description :

1. Designed and implemented interactive dashboards in Tableau, enhancing data visualization for key performance metrics and reducing report preparation time by 20%.
2. Conducted comprehensive data analysis to identify trends, leading to actionable insights that improved client satisfaction scores by 15%.
3. Optimized data collection methodologies, enabling timely and accurate reporting on a weekly, monthly, and quarterly basis.
4. Collaborated with cross-functional teams to present analytical findings, driving strategic improvements in operations.
5. Managed data integrity through meticulous auditing processes, ensuring accuracy in reporting and decision-making.
6. Utilized advanced Excel functions for data manipulation, increasing efficiency in data handling and reporting.
7. Streamlined documentation processes, enhancing clarity and accessibility of data insights for stakeholders.

Experience

7-10 Years

Level

Senior

Education

MBA

Description :

1. Conducted comprehensive data analysis using SQL and Teradata to inform strategic decision-making.
2. Developed and documented functional requirements based on stakeholder needs and project objectives.
3. Facilitated cross-functional meetings to align project goals and address open issues during requirements reviews.
4. Acted as a liaison between business units and IT, ensuring clear communication of project statuses and challenges.
5. Utilized advanced SQL queries for detailed data analysis and reporting, driving actionable insights.
6. Created process flow diagrams to visualize current and proposed business processes, enhancing stakeholder understanding.
7. Provided training and support to end-users on data tools and reporting systems, improving overall user competency.

Experience

10+ Years

Level

Management

Education

B.S.B.A.