ROHINI CLARA (Long Beach, CA)

ad3027@r.postjobfree.com

Phone#: 914-***-****

https://www.linkedin.com/in/claro-l-a683b514

SUMMARY:

Over 15+ years of IT experience in Software development life cycle: system analysis, design, development, testing and implementation of projects in Finance (Banks & Transfer Agents), Unclaimed Property & other Financial Systems; Hi-Tech Companies; Healthcare; Public Safety.

Experience as a software developer & Analyst doing SQL analysis across various Databases with good understanding of the RDBMS concepts with expertise writing SQL queries, extensively worked with MS SQL Server, MS Access, MySQL.

Involved in projects as a Business Analyst for Requirement Gathering, User Acceptance Testing, Process Mapping, Reporting and Documentation and communicated with stakeholders and upper management to provide accurate reporting and information regarding the ongoing projects and initiatives.

Familiarity with AWS, Postman, APIs Salesforce, ERP Software, SAP HANA, FICO, CPQ

Good command of MySQL, MS SQL, MS Access, Visio, Word, Excel Using Pivot tables/macros.

Business Analysis – Gap Analysis (As-Is / To-Be Analysis), Experience in conducting Joint Application Development (JAD) sessions, project meetings, reviews, walkthroughs, and customer interviews.

Analytical Skills: Data analysis on large amounts of data: facts, figures, and number crunching to see through the data and analyze it to find conclusions.

Communication Skills: Project Coordination, Present findings, or translate the data into an understandable document, write and speak clearly, easily communicating complex ideas.

Critical Thinking: Analysis by looking at the numbers, trends, and data and come to new conclusions based on the findings.

Strong Attention to Detail: Making sure data is precise & I'm vigilant in my analysis to come to correct conclusions & will run the extra mile to finish the job on time and can quickly adapt to any/aggressive environments.

Math Skills: Decent Math skills to estimate numerical data.

Hands-on configuration experience (e.g. CPQ - configure new product bundles, price rules, product rules, quote templates) Testing responsibilities included creating and modifying test cases, record and analyzing test results.

Good team-player with outstanding interpersonal and leadership skills and extremely quality conscience and pretty good communication skills to work well with clients and co-workers in one-on-one and group settings.

Quality Analysis –User Acceptance Testing (UAT), Regression test, Performance test, and Load Test Cases, Test Plans using testing tools like QTP.

Team player to work in conjunction with testers (QA), developers and other team members in validation and testing of complex project scenarios while maintaining Quality Standards of projects.

EDUCATION & TRAININGS:

Graduated with a Bachelor’s Degree from Bombay University, India - BA from G.N. Khalsa College (1993 -1998)

Completed Diploma in Computer Science from Datapro Information Technology (1995-1998)

Completed 3 months of full time training in developing Windows-Based Application with Microsoft Visual Basic.Net at the Soft Origin Technical School.

Completed Full time training in RDBMS Microsoft SQL 2000 from NIIT (2001: 6 months)

Attended & Completed in-house training on PeopleSoft – People Tools 8 at Enterprise Technology Solutions (Sept 2004 to Nov 2004)

Completed Tame Big Data to Drive Big Insight training at Stanford University of continuing Studies (Fall 2017: September - December) in Palo Alto.

Completed a total of 6 workshops/Boot Camps: Data Analytics, Project Management, Product management, etc. at the General Assembly in San Francisco.

TECHNICAL SKILLS / Operating Systems:

Windows Server 2008 R2 Windows 8/7 Enterprise DOS Windows NT/2000/2003/XP/98 UNIX

Languages:

Visual Basic 6 VBA .NET Framework Asp.Net Visual Studio.NET 2003 SQL Server 2000 HTML XML UNIX

Databases/Software Applications/Tools:

Microsoft SQL Server 200*-****-**** R2 2012 2016 SSRS SSIS MS Access MS Project/MS Visio MySQL PeopleTools7.5 SAP Hana Tableau JIRA TFS CRM Service Now Salesforce Postman

WORK EXPERIENCE:

DPS - State of Louisiana – Baton Rouge, LA 01/2020 – Till Date

(Currently WFH in Long Beach)

Business/Product Management Analyst – Office of Juvenile Justice - OTS

Working with the IT team on Business Process Re-Engineering in the Office or Juvenile Justice (OJJ).

Determine operational objectives by understanding business functions, Document requirements, define scope and objectives & evaluate output report requirements and formats.

Facilitate project related meetings with business partners & drive project related discussions to plan delivery artifacts in a timely manner.

Perform duties of a Product manager in collaborating with various departments on the Enterprise application and participate in the product development life cycle.

Interact with business stakeholders for approval workflows, following Agile Scrum Methodology.

Improve systems by understanding current practices; designing modifications.

Define project requirements by identifying project milestones, phases and elements

Maintain user confidence and Create suggestions for improvements to processes.

Construct process workflows. Test APIs using Postman to validate outcome of results.

Create Functional Test plan, Test Cases and conduct testing on UAT.

Support and validate Data analytics related work of OJJ team as part of peer review.

Update backlogs and create detailed stories for upcoming Sprints and Sprint planning (JIRA)

Prepare technical reports by collecting, analyzing and summarizing information used from daily, weekly and monthly reviews and analysis.

Scan Health Plan - Long Beach, CA 10/2018 – 12/2019

Technical Business Analyst

Reliable, proactive and quick learner with great communication skills and Agile SCRUM experience participating in agile cadences providing routine update on the work completed, effectively communicating project expectations to project team members and stakeholders in a timely and clear fashion with appropriate project documentation.

Hands-on configuration of Custom fields, forms, objects, Dashboard/Report building, process mapping, Processes and workflows and other areas of improvement within current systems to improve efficiency for business users.

Evaluated Business Requirements, led user requirement sessions focused on as-is v/s MedHOK processes documenting detailed requirements, business processes and solution designs.

Prepare Business & Functional Requirements Documents, Test cases to define and document project scope, goals, deliverables to support business while collaborating with management /stakeholders.

Facilitate meetings with Business users, technical team and Quality Assurance teams for test plans developed as listed in FDD specifications to test and validate results per success criteria.

As a Technical BA with Software Engineer expertise, used MS SQL to write SQL queries to extract data to Capture User Requirements, review SSRS reports, created User Stories/ Screen Mock ups, process flows and Mock-up dashboards using Tableau. Work with database objects on current Data Architecture to conduct thorough Data analysis on the Data Warehouse side by review of changes to reference meta-data specifications and provide Regulatory SME input to data standards, data quality, and data modeling teams.

Other duties include administrative, support rollout activities like documentation and ensured training needs are met for new or existing applications, coaching new team members and leadership roles that make Scrum development/delivery possible (like remove obstacles that may impact the delivery of the product).

Facilitate internal/external communications for task coordination, progress tracking/reporting, dependency management using project management tracking tools such as MS Project, Visio, JIRA, TFS to capture business requirements & Progress, MS Visio to documents process flows.

Pondera Solutions / DVBE Tech Group - Sacramento, CA 12/2017 – 09/2018

Salesforce Business Analyst

Worked for the DHCS (Department of Health California State) on the Medi-Cal Program Integrity Data Analytics team at Pondera Solutions.

Performed Data Analysis and QA on the LexisNexis data to support FDaaS (Fraud Detection as a Service).

Delegated user permissions to control user to create Lightning Components and server-side controllers to meet the business requirements.

Continuously supported the FDaaS to enhanced and improve solution that leverages additional third-party data sources such as individual and business public records, licensure data, criminal history, etc., which may indicate an increased Medi-Cal program integrity risk.

Provide support for operations and migration services to tailor the availability and delivery of Cloud computing services based on business and technical requirements.

Operational Analysis and Validation of dataset returned from third party vendors (Lexis Nexis/Appriss/ThomsonReuters/etc) to investigate frequency of populated fields, comparison of data requested (in SOW) vs data returned, assess usefulness of data.

Conducted comparison of data provided vs. other data sources, quality checks of data returned

Ran batch ETL processes.

Worked with clients to support the design and development of Salesforce solutions to leverage a true 360-degree view of each and every customer with Marketing Cloud.

Attended onsite meetings as a Business Data Analyst & resource dedicated to report information gathering for the DHCS .

Sutter Health - Sacramento, CA 05/2017 – 11/2017

Salesforce Business Analyst

Design, Create, verify/validate routine reports on the NGO & Gift processing requests.

Created reports on Salesforce and maintain Access databases used for Philanthropy reporting.

Create & maintain tools used by business operations so Finance can pull data on demand for further analysis. Played an active role in gathering, analyzing, and writing business requirements and documenting the same in the proper format for different projects.

Processed external files from Clients using ETL process.

Collected and documented business processes as well as business rules that use Salesforce Lightning UI, created Components and Apps in salesforce lightning.

Engaged with Business Users & Stakeholders to document business needs and requirements and suggested recommendations during implementations.

Conducted JAD sessions between the end users and the development team.

Automated regular process on MS Access, tracking issues, and documenting changes accordingly.

Medtronic - Carlsbad, CA 11/2016 - 04/2017

Data Analyst

Conducted testing as required by developing team using SQL queries

Generate T-SQL and Access queries, charts and perform analysis of complaint data.

Provide backup support for other CTS administrators.

Provide backup support for the corporate monthly metric report

Involved in documentation of Data Mapping and ETL specifications for Data warehouse.

Assisted with various Analytic projects (i.e. data mapping, validation, database table assessments, etc.).

Conducted project related presentations and provided reports to the higher management.

Played an active role in gathering, analyzing, and writing business requirements documents.

Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly

Prepared and updated BRD & FRD (Functional Requirements Document) as and when requested by the PM.

Applied Materials - Santa Clara, CA 05/2016 - 10/2016

Data and Business Analyst

Demonstrated Program Manager’s role in medium projects from collecting requirements to presenting Mock-Ups, preparing project schedules and working together with Scrum Master to ensure deliverables within each sprint is successful.

As a Project Coordinator, collaborated with offshore teams to ensure requirements were reflected

& coordinated multi-organizational projects

Responsible for updating the issue tracking and project management application, JIRA for BIM Services. Learning Agile methodology used by JIRA.

Managed and facilitated requirements gathering sessions with business and IT stakeholders resulting in moderated, orderly, and efficient meeting to Identify and define concise, cohesive, and comprehensive Business Requirements Documents.

Created sequence/process flows, Mock-ups and use cases documenting functional (FRDs) and system requirements (SRDs) & define business metrics so the team starts development phase ahead of schedule.

Data mining included: Execute data queries, Ad hoc analysis to compile data across multiple data sources in support of BI reporting needs, research the root cause then communicate the resulting insights with clarity for necessary actions on next steps, created Tableau dashboards to monitor & validate data for POC.

DOH State of New York - Albany, NY 09/2015 - 04/2016

Business Analyst

Gathering, analyzing, and writing business requirements and documenting business processes as well as business rules in the proper format for different projects.

Translated business needs into FSDs and SRDs but communicated to business on a non-technical level.

Entering defects in Quality center to generate reports using IBM SPSS.

Briefly used IBM Cognos 10.2.1: developing reports, analysis, access to report studio.

Used Oracle SQL developer to run monthly data files for the users.

Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the organization plans and conducted JAD sessions between the end users and the development team.

PALO ALTO NETWORKS, Inc. - Santa Clara, CA 08/2014 - 08/2015

Sr. Data/Business Analyst (Teams: DQ/On-Off boarding /FICO/SAP) & DBA (Team: IAD)

Executed database queries of business processes against sensitive data to support customer needs using MySQL/Access/Salesforce/SAP Hana & Data Services.

As an Application Support analyst worked on incoming Service-Now tickets & was responsible to support, identify & triage incoming tickets appropriately.

Determine which business processes must be followed depending upon the request of tickets/Incidents.

Logging and tracking day to day issues per ticketing then document and communicate support issues clearly to our internal/external customers both on Business Intelligence and System side.

Worked with a team for guidance/support to provide any needed administrative & Data Quality support.

Created & executed various ad-hoc queries for data analysis across databases on production server.

Pro-actively collected datasets from various business stakeholders and manage the data.

Performed Data Analysis to identify gaps & anomalies within the Data Set for the Data Quality team, SAP Hana Business Intelligence Team, Revenue Reconciliation & the On-boarding/Off-Boarding teams since December 2014 using MySQL/Access/SAP Hana.

As a Business Analyst & Project Coordinator on the On-Boarding/Off-Boarding process interacted with business stakeholders for approval workflows, following Agile Scrum Methodology & updating necessary tracking system to ensure that project status is maintained with complete accuracy & coordinated those with HR/Facilities/Security teams. Participated in planning and testing of HRIS version updates.

Communicated issues to my Project Managers on critical issues & status before creating/ distributing correspondence relevant to the business teams & OO project team.

Worked closely with PMs/Developers on tracking/reporting while supporting the PAS system to define scope and requirements for system changes to be implemented by IT.

Collaborated with Client Services team to ensure the collected information is sufficient for the Active Directory migration and provided data entry to support management ensuring accurate tracking & status of data collection.

Worked on Data Services by creating jobs per ad-hoc requests from the SAP Hana team.

Analyzed huge datasets for Waterfall comparison & Prepared Revenue reconciliation reports to support the Revenue Reconciliation project (FICO team) on a BI-weekly basis from Jan – Aug 2015.

VENIO LLC D/B/A KEANE - NYC, NY 10/2009 - 08/2014

(Asset/Wealth Management – for Banks, Brokerages, Transfer Agents & Mutual Funds)

SQL Developer & Business/ Data Analyst - Production Support

Load data from various Financial clients (Banks, TA, etc) using ETL process. Loading form various data sources (MS Excel, MS Access and SQL Server, CSV, Flat Files etc.) into target database by performing different kinds of transformations using SQL Server Agent to automate the SSIS 2012/2008r2 package execution. Tested and managed the SSIS 2012 packages for fay to day processing of external files from Clients, using ETL & Legacy DTS to transfer data between servers in SQL Server 2000/2005/2008/2008 R2/2012.

Created database objects such as tables, views, stored procedures, Triggers etc. for Analysis.

Conducted analysis per detailed specifications using SQL to perform on-line and batch testing of interface design and production support, especially for disaster recovery testing.

Worked on CRM Software and in-house workflow management tools & creating rules.

Designed over 20 reports to help quickly identify potential fraud and data errors resulting in 1M in saved revenue. Improved report function and automation cutting the processing time by over 40%

Ensured different internal & external systems exchanged data according to the specification on the data mapping document to transform data from EDW to SQL Server & load data to fact tables.

Created Hive Tables & loaded data into HDFS using AWS (Amazon Web Service) for a test run.

Performed SQL Backup and Restore tasks on Various SQL Servers.

Supported marketing teams with marketing systems for Audit & to automate exceptions reports, & Weekly Reports and sent to specified users groups.

Deployed Reports for Internal, Departmental & Executive Reporting using SQL Server Reporting Services 2012/2008r2 maintaining on report Manager and Reporting Server.

Was the Lead Contact since 2009 at the Semi-Annual External Audit on site visits at the NY location. Performed walkthroughs with External Auditors for SSAE 16 II Audit of reporting on the system for purposes of complying with internal control over financial reporting. Successfully completed the type II level examination & type I confirming steps to evaluate the operating effectiveness of the controls for six consecutive calendar months.

Incorporated Financial reconciliation for various Corporate & Mutual Fund Issuers with our TA clients.

Fund Merger/Corporate Action analysis for client within our portfolio as it relates to Inventory.

Create/run various Ad-Hoc projects and queries for our Executive Management Board using on SQL/Access per requirements. Created Macros for Overlays & reports using efficient data retrieval techniques with successful testing.

Participated in discussions & review meetings on application creation to understand the requirements and provide the back-end functionality for the applications to provide input into Business Requirements and Technical Design Documents.

Troubleshooting & Supporting Operations with the existing MSCRM Application used internally. Provided advanced data source view mostly for data quality analysis and business analysis utilizing these data warehouses, Client/Server application development and implementation.

Involved in Migration process (NY process to PA process), interacting with the team for Testing, coordinating, Documenting & training on the existing NY processes. Travelled to PA to Train Data Analysts/ Business Analysts / Relationship Managers for the above on some tools & processes.

EQUISEARCH, Inc. - White Plains, NY 07/2006 - 09/2009

(Asset/Wealth Management – for Banks, Brokerages, Transfer Agents & Mutual Funds)

Software Developer

Created the initial ETL packages to integrate financial data on an ongoing basis for processing external files received from Financial Clients using this ETL process.

Define & design data sourcing to build the data source views and flows for data mining.

Created Tables, Indexes, Stored Procedures, Functions, Triggers and DTS Packages to transfer data between servers in a SQL Server 2000/2005 environment, performing analysis.

Used SQL Server Agent to automate the SSIS 2008r2 package execution. Tested and managed the SSIS packages, reviewed developer SQL code to ensure adherence to client standards and general best coding practices.

Created Test plans, Test case, and Test scripts to test systems for data corruption, SQL errors and documented such bugs.

Identified and added report parameters using SSRS 2008r2 to create reports based on the Business & Client requirements.

Supported marketing teams with marketing systems & maintained the CR (change Request) of the company.

Involved in the on-site Audit and did walkthroughs with the External Auditors for the SAS 70 (Type II) Audit in 2007 & 2008.

Coordinating with the IT teams of Various Transfer Agents in order to understand the business needs and setting up objects accordingly.

Trouble shooting & Supporting Equisearch Users with the Equisearch Services Internal Application. Worked closely with Accounting, Sales & Research departments to determine business rules for a smooth flow of business as usual.

BERLITZ INTERNATIONAL - Princeton, NJ 04/2006 - 06/2006

Software Developer

Berlitz International is a company that works as a source needed for effective language instruction, whether for business or personal enrichment.

Involved in the Designing & Development using C# interface for LDAP database using Novell Netware & .Net technology with the Onsite/Offshore model, developing the site using Microsoft Content Management 2001

Developed Scripts for replicating the data from Sybase Database to SQL Server Database.

Performed SQL Backup and Restore tasks on Various SQL Servers.

NON-US WORK EXPERIENCE

PRUDENTIAL (PPMS) UK. India. Aug 2005 - Feb 2006

Software Developer & Tester

ORREX TRANSPORT PVT LTD. Jun 2005 - Jul 2005

Programmer Analyst

PRUDENTIAL (PPMS) UK. India. Oct 2004 - May 2005

Jr. System Administrator

VMCI. India. Dec 2001 to Dec 2003

Developer / Training & Documentation Specialist

Contact this candidate