Francisco Guevara
Senior Business Analyst at Cognizant Consulting France- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Cognizant Consulting France
-
France
-
Business Consulting and Services
-
1 - 100 Employee
-
Senior Business Analyst
-
May 2022 - Present
New York, NY
-
-
-
Napoleon IT
-
United States
-
Information Technology & Services
-
100 - 200 Employee
-
Business and data analyst
-
Dec 2018 - Present
NY, NY • Gather requirements from external clients for their current projects. Review, analyse and validate requirements with key external stakeholders. Provide updated reports to stakeholders. • Participate in daily scrum meetings and sprint planning. Size projects based on past projects and experiences. • Create use User stories, cases and test cases. Track task progress. Resolve obstacles. • Develop SQL queries for pulling data from the databases. Use data analysis skills for furthering… Show more • Gather requirements from external clients for their current projects. Review, analyse and validate requirements with key external stakeholders. Provide updated reports to stakeholders. • Participate in daily scrum meetings and sprint planning. Size projects based on past projects and experiences. • Create use User stories, cases and test cases. Track task progress. Resolve obstacles. • Develop SQL queries for pulling data from the databases. Use data analysis skills for furthering data analysis. • Interact with developers on the status of projects and assist in clarifying any issues. • Work closely with the software development teams and product management for test requirements clarifications to ensure effective testing procedures. • Facilitate meetings. make presentations. • Use, office 365, Visio, Tableau, wireframing, SQL, server and SQL Postgres, Jira, Testrail. Show less
-
-
-
-
Business & Data Intelligence Analyst
-
Jul 2018 - Oct 2018
Remote Hired thru InterPros Consulting Company to work for Innova CareHealth, a Fort Lee, NJ based company in the Health environment in Puerto Rico, providing Medicare Advantage and prescription plans. The position is 100% remote, working from my house and with frequent travel to San Juan, Puerto Rico. Gathered and tracked requirements for reports across the enterprise. Created and developed different types of reports for the company, including financial, claims, and… Show more Hired thru InterPros Consulting Company to work for Innova CareHealth, a Fort Lee, NJ based company in the Health environment in Puerto Rico, providing Medicare Advantage and prescription plans. The position is 100% remote, working from my house and with frequent travel to San Juan, Puerto Rico. Gathered and tracked requirements for reports across the enterprise. Created and developed different types of reports for the company, including financial, claims, and utilization. Utilized Excel, Tableau, and Birst Business Intelligence tools. Queried databases using SQL, connected the SQL outputs into Tableau so that I could develop reports views of the data. Show less
-
-
-
Cognizant
-
United States
-
IT Services and IT Consulting
-
700 & Above Employee
-
Hands on Training Program
-
Mar 2018 - Jun 2018
Bronx, NY Cognizant Consulting Data Engineering Training Program / Per Scholas - Bronx, NY 03/2018 to 06/2018 Attended a structured, fulltime hands on, training enhancement program on data engineering emphasizing in programming, project management, business analysis, agile methodologies, shell scripting, SQL queries, java programing, Hadoop ecosystem, data analysis and visualizations, tableau, data warehousing, business intelligence, and… Show more Cognizant Consulting Data Engineering Training Program / Per Scholas - Bronx, NY 03/2018 to 06/2018 Attended a structured, fulltime hands on, training enhancement program on data engineering emphasizing in programming, project management, business analysis, agile methodologies, shell scripting, SQL queries, java programing, Hadoop ecosystem, data analysis and visualizations, tableau, data warehousing, business intelligence, and decision making strategies. Show less
-
-
-
-
Senior Busines Analyst
-
Mar 2017 - Dec 2017
New York City - Remote Position Apex Systems for United Health Care Ins. Co. Senior Business Analyst - Project Based Contract 03/2017 to Present Contracted thru Apex Systems Inc., which handles my payroll and benefits. This project is 100% remote, working from my house. Currently United Healthcare is migrating data, and creating a brand-new Data-Lake for future management… Show more Apex Systems for United Health Care Ins. Co. Senior Business Analyst - Project Based Contract 03/2017 to Present Contracted thru Apex Systems Inc., which handles my payroll and benefits. This project is 100% remote, working from my house. Currently United Healthcare is migrating data, and creating a brand-new Data-Lake for future management of its data management. It is currently creating this new system for all of its companies across the country. Work with healthcare data, processes, and systems behaviors. Manage the daily activities of the Claims, Finance and Service Providers domains but currently mainly work in the Claims Domain. Work under an Agile environment with daily scrum meetings, sprints, sprints reviews, backlog grooming, and CA Agile software for task tracking. Gather, review, analyze, and validate data elements requirements for existing and new Claims, Provider, and Finance reports. Meet with stake holders on a daily basis in order to review, analyze, and validate data requirements. Create meeting notes with next steps, distribute, and follow up on open items until conclusions are reached. Facilitate daily scrum meetings, and assume roles of the Scrum Master and the Product Owner whenever it is required. Investigate existing databases in order to produce accurate database mapping to be presented to the database and developers teams. Pull database elements by utilizing SQL commands. Utilize Tableau for big data views and reporting. Show less
-
-
-
SE2, LLC
-
United States
-
IT Services and IT Consulting
-
300 - 400 Employee
-
Business Systems Analyst
-
May 2016 - Dec 2016
Bridgewater, NJ Se2 is third party company that offers software and process based solutions to insurance companies in the administration of life insurance and annuities products. Company is based in Topeka, KS and in Bridgewater, NJ. I was in the Bridgewater office and also telecommuted. Worked under an Agile environment with daily scrum meetings, sprints, sprints reviews, backlog grooming, and Jira software for task tracking. Utilized MS project. Subject matter expert on the Annuity/Insurance/Finance… Show more Se2 is third party company that offers software and process based solutions to insurance companies in the administration of life insurance and annuities products. Company is based in Topeka, KS and in Bridgewater, NJ. I was in the Bridgewater office and also telecommuted. Worked under an Agile environment with daily scrum meetings, sprints, sprints reviews, backlog grooming, and Jira software for task tracking. Utilized MS project. Subject matter expert on the Annuity/Insurance/Finance industry. Worked on new systems implementations, systems enhancements, and fixed and Ad Hoc reporting for both life and annuity products. -Provided technical, product support, and advice to the client relationship managers, service managers, and/or operations officers on business processes and systems issues in both run mode and development of new processes/support. -Became a key resources advisor and was available to support new clients through process block conversions. -Responsible for facilitating the flow of ideas and information between departments. Used MS Visio as a Flow Charting tool. Estimated implementation costs and efforts. Wrote user stories, definitions of user acceptance tests and definitions of done. -Gathered requirements, working with the Designer/Developer for setting tasks during Scrum. -Review new requests projects for feasibility and time execution estimates. Good communication skills - Good people skills Verbal/Written. -Completed research and provided analysis as needed to support Management in decision-making. -Developed and executed proposed business and technical solutions. -Developed business requirements for the business/technology solutions that allowed the client and internal customer departments to become more efficient and effective. -Documented flows and procedures for Performance Quality as a result of implementations, while ensuring quality of solutions delivered (leading UAT). Show less
-
-
-
Lighthouse Guild
-
United States
-
Hospitals and Health Care
-
100 - 200 Employee
-
Medicare Data Analyst
-
Feb 2015 - Sep 2015
New york, NY Light House GuildNet , NY NY Medicare Data Analyst 04/2015 to Present Perform a variety of tasks that support the Medicare Services Department, including developing, monitoring, and analyzing data regarding GuildNet’s health insurance plan’s population, services, and other business needs, along with clinical indicators, while working on different projects to support program operations. Work… Show more Light House GuildNet , NY NY Medicare Data Analyst 04/2015 to Present Perform a variety of tasks that support the Medicare Services Department, including developing, monitoring, and analyzing data regarding GuildNet’s health insurance plan’s population, services, and other business needs, along with clinical indicators, while working on different projects to support program operations. Work collaboratively with the Medicare Services team to implement processes to support Guildnet Medicare policies, procedures, regulations, and contract changes. Work on projects to support day to day implementation and resolution of issues that arise from the integration of business processes, between partners, vendors, and Guildnet. Define reports, data needs, and evaluate results for routine monitoring of scheduled reports for both state and federal agencies. Perform membership enrollment reconciliations using MS Excel, Access, and other in-house databases. Analyze report results, trending, perform data drill down when required, and prepare written reports for Senior Management reviews. Create, design, and update database records. Define issues for special ad hoc reports/data files. Conduct audits and documents findings. Perform other duties as necessary. Responsible for maintaining the privacy of patient and clients protected health information. Work alongside with enrollment & billing, claims, finance, member services, business transformation, medical management, information systems, and other functional areas in order to ensure day to day plan operations. Show less
-
-
-
-
Individual Benefits Specialist & Sales
-
Sep 2014 - Mar 2015
Texarkana, Arkansas Broad-Path HealthCare Solutions (Blue Cross Blue Shield of Arkansas-Texarkana, AR – (Temporary Position) Individual Benefits Specialist & Sales 10/2014 to 02/2015 & 09/2013 to 04/2014 - Contracted thru Broad-Path Healthcare Solutions, Tucson, AZ. Trained with ARBCBS in their Corporate Home Office in Little Rock, AR in their individual and group healthcare insurance products and systems. Team leader for the Regional office of two other consultant agents in Affordable Care Act, (ACA), and… Show more Broad-Path HealthCare Solutions (Blue Cross Blue Shield of Arkansas-Texarkana, AR – (Temporary Position) Individual Benefits Specialist & Sales 10/2014 to 02/2015 & 09/2013 to 04/2014 - Contracted thru Broad-Path Healthcare Solutions, Tucson, AZ. Trained with ARBCBS in their Corporate Home Office in Little Rock, AR in their individual and group healthcare insurance products and systems. Team leader for the Regional office of two other consultant agents in Affordable Care Act, (ACA), and Medicare markets. Sold the company’s health insurance products to the under 65 and over 65 markets, including private insurance, affordable care act, Medicaid, Medicare, and prescription drug plans. Worked in the group side with renewals, maintenance, and training new enrollees on how to manage their accounts. Made group benefits presentations for both English and Spanish populations. Created and translated marketing materials. Worked in a customer service, call center environment where phone calls, appointments, and walk-ins were attended on a daily basis. Met with existing and new customers in order to determine which was their best health insurance option and enrolled them into the new plans, whether it was through the new expanded Medicaid program, through the federal marketplace, through the off-marketplace, and Medicare including Medicare advantage and supplemental plans and prescription drug plans. Created, designed, and updated database records. Furnished rates to small and large group employers, managed census data, and monitored new enrollments into these groups. Show less
-
-
-
-
Sales & Marketing
-
Sep 2013 - Apr 2014
Texarkana, Arkansas Broad-Path Health Solutions (Blue Cross Blue Shield of Arkansas-Texarkana, AR –Temporary Position. 09/2013 to 04/2014 Contracted trough Broad-Path Healthcare Solutions, Tucson, AZ. Trained with ARBCBS in their Home office in Little Rock, AR in their healthcare insurance products and systems. -Sold the company’s health insurance products to the under 65 and over 65 markets, including private insurance… Show more Broad-Path Health Solutions (Blue Cross Blue Shield of Arkansas-Texarkana, AR –Temporary Position. 09/2013 to 04/2014 Contracted trough Broad-Path Healthcare Solutions, Tucson, AZ. Trained with ARBCBS in their Home office in Little Rock, AR in their healthcare insurance products and systems. -Sold the company’s health insurance products to the under 65 and over 65 markets, including private insurance, affordable care act, Medicaid, Medicare, and prescription drug plans. -Worked in a customer service, call center environment where phone calls, appointments, and walk-ins were attended on a daily basis. -Met with existing and new customers in order to determine which was their best health insurance option for them and enrolled them into the new plans, whether it was through the new expanded Medicaid program, through the federal marketplace, through the off-marketplace, and Medicare including Medicare advantage and supplemental plans and prescription drug plans. Show less
-
-
-
-
Bilingual Medicare TeleSales
-
Aug 2012 - Dec 2012
New York City, NY Trained with United Health Care Insurance Company on their Medicare products and computer systems in order to sale via telephone for the Open Enrollment Period of 2012. Hired as a bilingual agent, servicing and selling in both English and Spanish lines. -Sold via telephone Medicare products to senior citizens and disabled citizens. -Analyzed current client’s plans vs. UHC’s products and made verbal presentations. -Participated in both the English and Spanish incoming lines and sold… Show more Trained with United Health Care Insurance Company on their Medicare products and computer systems in order to sale via telephone for the Open Enrollment Period of 2012. Hired as a bilingual agent, servicing and selling in both English and Spanish lines. -Sold via telephone Medicare products to senior citizens and disabled citizens. -Analyzed current client’s plans vs. UHC’s products and made verbal presentations. -Participated in both the English and Spanish incoming lines and sold Medicare Products.Closing ratio was 80%. -Was trained in both UHC’s systems and Medicare line of products including Medicare Advantage plans, Prescription Drug plans, Special Needs plans, and Supplemental Plans. -Met all United Health Care’s certifications in order to speak with callers in a call center environment. -Health licensed in 28 states including Florida and Texas (large Hispanic markets). Show less
-
-
-
-
Financial Analyst - Life Insurance Pricing Analyst
-
Feb 2009 - Apr 2012
Hackensack. NJ RAI insurance group managed a private equity fund that contained high face amount life insurance policies purchased as settlements and premium financing loans originated through RAI as the lender. I was the Life Insurance subject matter expert and loan documentation expediter. -Created financial reports in order to provide views of the financial status of the portfolio, including balance sheets, P & L reports, and expense reports. -Created expense budgets with variances, forecasts, and… Show more RAI insurance group managed a private equity fund that contained high face amount life insurance policies purchased as settlements and premium financing loans originated through RAI as the lender. I was the Life Insurance subject matter expert and loan documentation expediter. -Created financial reports in order to provide views of the financial status of the portfolio, including balance sheets, P & L reports, and expense reports. -Created expense budgets with variances, forecasts, and what if scenarios on potential acquisitions and sales. -Designed and implemented Excel templates for analyzing at a micro level the potential performance of each component of the portfolio including sinking funds, amortization, sales returns analysis, and future asset valuation. -Created data presentations by using Excel and Power Point, based on financial, numerical, and statistical concepts. -Expanded and enhanced the existing CRM system with the objective to meet the company’s need in order to track and maintained current pertinent data of each component by setting data criteria and relationships of data. -Served as point of contact during the portfolio’s yearend financial audit. Show less
-
-
-
-
Financial Analyst
-
Sep 2006 - Oct 2008
New York City Area Indigo was involved in the brokerage of standard longevity based wrapped products, (life insurance) to institutional investors, including Hedge Funds, and Pension Fund Management companies both in the USA and Europe. I was the company’s first employee in August, 2006. Due to financial crisis and the lack of investment capital in 20008, Indigo Capital closed in December, 2008. -Created internal processes in order to operate in a more cost effective and efficiently manner -Developed and… Show more Indigo was involved in the brokerage of standard longevity based wrapped products, (life insurance) to institutional investors, including Hedge Funds, and Pension Fund Management companies both in the USA and Europe. I was the company’s first employee in August, 2006. Due to financial crisis and the lack of investment capital in 20008, Indigo Capital closed in December, 2008. -Created internal processes in order to operate in a more cost effective and efficiently manner -Developed and maintained the company’s financial ledgers in order to track expenses and income. -Managed budgets in order to acquire the company’s physical assets, including office supplies and computer hardware and software. -Designed on paper a database for life insurance policies to be sold to institutional investors which was implemented in Microsoft Access. It quickly became the heart of the daily operations was used to maintain case data, track case activities, create reports, and analyze current and potential profitability. -Trained new employees as they were hired in procedures and concepts of life insurance, equities, bonds, mutual funds, and other financial instruments and their respective software applications. -Maintained an updated portfolio of cases to be bid. Total average death benefit was $400 million to $500 million. Show less
-
-
-
-
Life Insurance Product Specialist
-
Mar 2005 - Jun 2006
New York City Area -Provided case design consultation and sales strategies on new business and in-force cases to the entire field sales force, including agents, brokers and their administrative staff, which resulted in higher monthly production by 3%. -Showed agents how to analyze competition situations at a per company level and at a per product type level. -Trained agents in asset allocation of different financial instruments including, equities, mutual funds, bonds and money market… Show more -Provided case design consultation and sales strategies on new business and in-force cases to the entire field sales force, including agents, brokers and their administrative staff, which resulted in higher monthly production by 3%. -Showed agents how to analyze competition situations at a per company level and at a per product type level. -Trained agents in asset allocation of different financial instruments including, equities, mutual funds, bonds and money market instruments. -Created conservation strategies and talked to agent and clients regarding these issues. -Furnished information on the company’s portfolio of products, their features and product riders to the sales force. -Conducted on line weekly training seminars via webex for new and experienced agents on products and the illustration system. Designed courses and published the monthly training calendar to FSRs. -Trained the sales force on how to use the company’s product illustration system. -Participated in departmental projects, including the complete redesign and update of the company’s 2006 life product and training guide. A 250 page book guide. Show less
-
-
-
-
Life Insurance Case Design and Client Services
-
Sep 1999 - Feb 2005
New York City Area Kornriech NIA is an insurance brokerage firm; serving affluent clients by providing all line of insurance services. I worked in their exclusive life insurance department assisting client meet their financial objectives through financial planning and life insurance. -Created life insurance product illustrations and proposals for new business and existing in-force policies for existing and or potential new clients. -Researched life insurance products for client suitability… Show more Kornriech NIA is an insurance brokerage firm; serving affluent clients by providing all line of insurance services. I worked in their exclusive life insurance department assisting client meet their financial objectives through financial planning and life insurance. -Created life insurance product illustrations and proposals for new business and existing in-force policies for existing and or potential new clients. -Researched life insurance products for client suitability purposes. -Reviewed current life insurance portfolios and created recommendations. -Created schedules of insurance and equity reports for clients. -Developed investment risk profiles for clients by using risk tolerance surveys and software programs. -Monitored the performance of underlying mutual funds investments in variable universal life insurance policies and created performance reports. -Communicated with clients via telephone or mail the status of their life insurance portfolios. -Implemented and managed a new client policy services desk, administering the day-to-day operations for life insurance policies and disability income policies. -Coordinated information and processes with insurance carriers and clientele. -Created internal monthly production reports including commission accounting reports. -Maintained clientele database and created reports as needed. -Created more efficient business processes in order to save time and labor. -Kornreich NIA is a member of the “M” financial services network of top insurance producers and insurance companies. Show less
-
-
Education
-
Western Governors University
Master of Science - MS, Data Analytics -
Villanova University
Professional Certificate, Business Analysis -
The Graduate Center, City University of New York
BS, International Marketing and Computer Systems -
Baruch College
Bachelor of Science (BS), CIS -
Borough of Manhattan Community College
Associate of Applied Science