RATULA CHOUDHURI

***** ****** **

FARMINGTON HILLS

m143fx@r.postjobfree.com

248-***-****(cell)

1

OBJECTIVE

Fourteen years of Information Technology experience with 7 plus years of Business/System Analysis developing Business Processes and System Solutions and being the liaison between the business units, technology teams and support teams within Automotive, Chemical, Retail and Health Care industries.

EMPLOYMENT HISTORY

July 2010 - Current Business Analyst/Data Analyst, Business Analytics Team, Individual Business Unit, Wellness Care and Management Solutions, Blue Cross Blue Shield, Michigan

April 2008 – June 2009 Business Analyst, Aetna Connecticut, Hartford

July 2006 – February 2008 Data Analyst, Container and Pallet Services, Livonia

Jan 2001 – March 2006 Developer/Business Analyst Accenture, Southfield

June 1998 – June 2000 Developer /System Analyst Ford Motor, Livonia

Aug 1997 – June 1998 Systems Analyst Ford, Southfield

PROFFESSIONAL EXPERIENCE (Reverse Chronological Order)

July 2010 - Current (Blue Cross Blue Shield, Southfield, Michigan)

Platform: SQl Server 2000, MS-Access, MS-Excel, MS- PowerPoint, HDMS customer online Reporting Tool, IIFP, CPODS, NPROD, Disease management, Case management data.

Elicit requirements using interviews, document analysis, business process descriptions, data analysis, task and workflow analysis.

Critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high level information into details and distinguish user requests from the underlying true needs.

RATULA CHOUDHURI

29161 WILTON DR

FARMINGTON HILLS

m143fx@r.postjobfree.com

248-***-****(cell)

2

Created Customer reports in MS- Access, Excel and HDMS customer reporting tool.

Systems analysis and problem solving relating to data, types of data, and relationships among data elements within a business system or IT system, trend analysis and creating reports for the government and executives in their decision making process.

Documenting the types and structure of the business data, understanding and identifying patterns and correlations among the various data points, mapping and tracing data from system to system in order to solve a given business problem.

Worked on creating Membership/Claims reports for different service categories such as inpatient, outpatient, professional, pharmacy in SQL Server and MS- Access.

Worked on Provider analysis, Claimants Analysis, Episodes Analysis and Membership reports.

Worked on Expense summary reports.

Presented a AUTO paper on Predetermination to the Analytics Team for a Brown Bag Session.

Worked on the release of the Pilot software tool called Insuramatic for the Individual Business Unit Team. My role was to design the “engine” behind the tool required to calculate certain business outcomes. I worked with an actuarial firm to build the engine’s components. The actuarial firm had the data they need for all products except health. I had to provide the BCBSM health (including Rx) data they need. This data was moved into Access database, manipulated per the actuarial firm’s guidance, and exported into their Excel table via SQL.

Worked in documention of Business Use cases, Business Project plan, Business Process Flows, other Vendors deliverables, System Requirement Specification, Data Model and Testing guidelines and techniques.

Worked in documenting Requirements traceability matrix from the Business Use cases.

Worked on User acceptance testing throughout the system development life cycle phase.

Created UAT Test plan, UAT Test Case and Defect log for the UAT tester,

Getting Sign-off for each test verifying the system meets the stated acceptance criteria.

Worked in helping the project manager to develop Business templates, Business project plan templates, Business Test case templates and Business Requirement Traceability Matrix templates.

RATULA CHOUDHURI

29161 WILTON DR

FARMINGTON HILLS

m143fx@r.postjobfree.com

248-***-****(cell)

3

Coordinated meetings with different project leads in maintaining schedules and timelines.

Worked on designing SharePoint Forms using InfoPath.

Heavily involved with Unit testing, Integration testing, System testing, User Acceptance testing and Release Testing throughout the system development Life cycle.

Worked in mostly in agile methodology environment.

Worked doing Data migration and Data validation from claims, membership and pharmacy data from large text files, excel files and access databases to SQL Server.

July 2009 - April 2010

Career Enhancement Training. Finished ITIL certification and career enhancement courses.

April 2008 - June 2009

Aetna, Connecticut

Platform: Java /J2EE, XML, Struts 1.1, SQL Server 2000, Windows 2000, Requisite Pro 7.0,

Business Analyst – Claims Processing System and Individual Product System

Developed prototype of new information processing application.

Helped collect functional requirements and prepared business requirement documents using Rational Requisite Pro.

Strategize implementation of RUP effort throughout SDLC.

Followed UML based methods using Rational Rose to develop use cases and activity diagrams;

Assisted developers in creating sequence diagrams and collaboration diagrams.

Proactively communicate and collaborate with external customers and internal customers to analyze information needs and functional requirements and deliver the following artifacts as needed, Functional Requirement document, Business requirement document, Use Cases, Requirements Traceability Matrix, Screen mockups, Requirements test cases and Non-Functional Requirement documents.

Serve as conduit between the customer community and the software development team through which requirements flow.

Developed Use Cases, workflow, screen mock ups, and conversion requirements.

Interfaced with SMEs to prepare BPR documents for ongoing projects.

RATULA CHOUDHURI

29161 WILTON DR

FARMINGTON HILLS

m143fx@r.postjobfree.com

248-***-****(cell)

4

Prepared business process models, used Visio to create use case diagrams.

Interaction with business to understand the client requirements.

Define testing objectives and verify requirements are testable.

Worked with Professional Claims (Primary Care Providers), Electronic claims and Paper Claims, Single Line Claims and Multi Line claims. Familiarity with Original Claims versus Adjustment processing, Pended Claims, Provider processing (In Network, Out of network), Pro-Rate Processing (Deductibles, Out of Pocket), Reimbursements. (Basics: Authorizations/Referrals/Notifications), EOB (Explanation of Benefits), Eligibility concepts.

RATULA CHOUDHURI

29161 WILTON DR

FARMINGTON HILLS

m143fx@r.postjobfree.com

248-***-****(cell)

5

July 2006 – Feb 2008 Livonia, MI

Container and Pallet Services

Platform: Java application using Tomcat 5.5.9 and Oracle database

Business Analyst – Container Tracking System and Barcodes scanning system

Responsible for coordinating the contracts and work effort of hardware and application vendor

Teams supporting CAPSTRAC (existing system) and working in tandem with finance on Contractual work.

Worked with detail Data analysis. Actively involved with Batch processing programs.

Responsible for working with the Business and IT vendors on driving out the gaps in the existing System and defining the requirements for a new system.

Carried out JAD sessions for the existing system before gathering requirements through Interviews, surveys and researching the prototypes available.

As a Business Analyst, assisted the Project manager on the Scope and objectives of the project.

Project and worked with the development team to redesign the existing application.

Worked with Waterfall Methodology.

Define testing objectives and verify requirements are testable.

January 2001 – March 2006 Southfield, MI

Accenture- DOW Chemical Company, Midland

Platform: Visual Basic 6.0, C++ using Oracle Databases 7.3. Oracle Forms and Reports

Business Analyst/Developer - Dow Agro sciences Application DAS_STARS (Study Tracking and Reporting System)

Animal Study Tracking and reporting System.

No Longer with Dow –Site Security Project

Epidemiology Project

Responsible for analyzing business processes. Work closely with customers to identify new

Business needs and the costs and benefits of implementing a solution.

Extensively interacted with the SMEs at Dow and Stakeholders to get a better understanding of the client business process.

RATULA CHOUDHURI

29161 WILTON DR

FARMINGTON HILLS

m143fx@r.postjobfree.com

248-***-****(cell)

6

Coordinated JAD Sessions between the Business Partners and the Project Team.

Extensive use of PL/SQL scripts Created and worked on PL/SQL Program units such as Functions, Procedures and Packages

Building Test Scripts for the ongoing Enhancements of the application.

Actively involved in Peer reviewing and SQA reviewing processes for QA.

June 1997 – June 2000

FORD MOTOR Company.

Platform: ORACLE V7.3, VB5 and Crystal Reports on WINDOWS/NT

System Analyst/Developer - Safety Training and Tracking System.

Requisition Reporting System.

Budget Reporting System (BPR)

Designing, Developing and maintaining the system.

Regularly Trained Plant supervisors how to use the system for plant related data.

Preparation of test data and the performance of unit and system testing.

RATULA CHOUDHURI

29161 WILTON DR

FARMINGTON HILLS

m143fx@r.postjobfree.com

248-***-****(cell)

7

EDUCATION

PGDCA ( Post Graduate Diploma in Computer Applications, INDIA)

Bachelors in Accounting, INDIA

Career enhancement courses from Oakland Community college, Oracle Corporation and New Horizons

CERTIFICATIONS

ITIL V3 Foundation Certificate.

SKILLS

Business Model Tools:

Rational Rose, Rational requisite Pro, Clear Case, Clear Quest, PVCS

Industry Standards: HIPAA, SOX, CFR 21 Parts 11, CFR 21 Parts 820, ISO, Six Sigma, CMM.

Batch processing software: Shell scripts, SSH, Python, Cron. Scheduler.

Methodologies:

SDLC, PDM, Agile, Rational Unified Process (RUP)

Management Tools:

MS-Visio, MS-Project, Word, Excel, Power point

Testing/Reporting Tools:

Win Runner 7.5, Test Director 7.6, Crystal Reports, Oracle Reports, Customer Reporting Tool (HDMS)

Languages & Scripts:

Visual Basic, PL/SQL, C++, Visual C++, JCL, Batch Delivery vehicle, OMDV (Delivery vehicle), UNIX

Software Tools:

MS Office tools, ABC flow charter, SQL Plus, SQL Navigator,

Serena Version XLNT,

Designer/2000 (CASE tool),PROCOMM PLUS using VNC viewer, Enterprise

Operating Systems: WINDOWS XP/NT/ 3.1/ 95, DOS, UNIX,

SUN SOLARIS

RDBMS: ORACLE 9.1/8.1,7.3, SQL SERVER 2000-2005,MS-ACCESS

Contact this candidate