SUMMARY

• Specialized in Business Analyst with demonstrated experience in Healthcare Insurance, Retail and services industry, competent in streamlining business operations, designing process improvement methodologies and identifying business growth opportunities.
• Good knowledge in SFDC business process and hands on testing experience on Leads, Contact, Accounts, Role hierarchy, Profile, opportunities, Reports and Dashboards.
• Good Experience in Workflow triggers, emails and approvals.
• Good experience in Sales Cloud, Marketing cloud and Service clouds.
• Expert in Healthcare Business model, Sales Cloud and Service clouds.
• Experienced in ETL/Data warehouse testing in SQL, Teradata, Informatica, BI Reports.
• Experienced in Datagap analysis, Database layout, Data definitions, Data Cleansing, Data Migration, and Data Manipulation.
• Experienced in System Testing, Regression, UAT and Production checkout.
• Have very good experience working in onsite/offshore model, worked as an onsite coordinator and lead a team.
• Strong knowledge in usage of VPN, ALM, Rational CWinSCP, CVS, Rally Agile Central, Putty, Visio.
• Extensive experience in Agile projects and more knowledge of Scrum principles and methodologies.
• Involved in PI planning, Road map, sprint planning.
• Strong analytical skills with ability to quickly understand client’s business needs.
• Strong knowledge on the process and migrating data from a third party vendor application.
• Working knowledge on XML Technologies.
• Well acquainted with SDLC and STLC.
• Proactive to issues, taking ownership of the work assigned, and having quick self - learning skills in learning new technologies on the fly.

TECHNICAL SKILLS

• Salesforce, Facets, QTP, CITS, SQL, SSIS, Power BI, Python, Tableau, Java, Html, CSS, JavaScript, VBA (Macros).
• Database Management, HP ALM, QTP, Agile Rally, Jira, Bugzilla, Rational CQ, Visio.
• Advanced Excel, SSRS, Informatica, Teradata, Visual Studio, MySQL Workbench, SQL Server Management Studio.

PROFESSIONAL EXPERIENCE

Business Analyst

Confidential

Responsibilities:

• Works in Member,Provider, PBM and Clinical domain.
• Conducted requirements elicitation meetings with the business to collect functional and non-functional requirements relating to client's Salesforce technology enhancement and initiatives.
• Worked towards preparation of requirements management plan, business and functional requirement documents.
• Created BRD for outlining new custom objects, assigned fields, designed page layouts, custom tabs and components.
• Created and outlined the organization hierarchy and created profiles, roles accordingly in Salesforce; worked on visibility and security settings around them as required by the business.
• Create BRD for Members, Reports, Risk start and rules, live data visualizations reports to inform business partners of trends, current metrics, and projected goals.
• Create database layout design, Data definitions and requirement document.
• Work with cross functional groups including directors, product managers, data architects and engineers to help optimize, build and implement scalable solutions for operational efficiencies.
• Support QA testing, Regression, UAT and production checkout.
• Co-ordinate with offshore team for requirement clarification, metric collections, preparing weekly and monthly reports
• End-To-End functional testing.
• Working on data migration from third party vendor application.
• Working on Data Cleansing, Data Migration, and Data Manipulation.

Technologies Used: SQL Developer, SSRS, XML, CVS, Rally Agile Central, Putty, Visio.

Business Analyst

Confidential

Responsibilities:

• Works with Business and POs create BRD document.
• Create BRDs for Salesforce Admin, Testing - Leads, Contact, Accounts, Role hierarchy, Profile, opportunities, Reports and Dashboards.
• Prepared test strategy and plan, estimation, test script, test execution for functional testing.
• Leading & helping team for the queries raised, prepared weekly/monthly reports for management team.
• Support QA testing, Regression, UAT and production checkout.
• Automated test scripts, execute, and validate logs.
• Prepared ETL test queries for given transformation logics.
• Strategized functionalities and communicated recommendations to the stakeholders on solution upgrades and process improvements.

Technologies Used: SQL Developer, SSIS, CITS Automation tool, Rally Agile Central.

Business Analyst

Confidential

Responsibilities:

• Works in Member and Clinical domain.
• Works with Business and POs to understand their rules and logics on 834 file and provide functional BRD document.
• Works in 834 file testing, Member and Plan domain related functional testing.
• Support QA testing, production checkout and UAT testing.
• Prepared test strategy and plan, estimation, test script, test execution for functional testing.
• Prepared ETL test queries for given transformation logics.
• Worked in Data cleansing and data Manipulation.
• Co-ordinate with offshore team for requirement clarification, metric collections, preparing weekly and monthly reports
• End-to-End functional testing

Technologies Used: SQL Developer, SSIS, CVS, Rally Agile Central, Putty, Visio.