RAMYA
. Seven years of IT Experience working in Publishing and Insurance
sectors as a Business System Analyst.
. Skilled in Business Requirement Gathering, Business Process Flow,
Technical Specification documents.
. Performed Business Process Modeling and Business Analysis employing
SDLC, RUP process life cycles.
. Identified, developed and documented Detailed Business Requirements
(DBR), Functional Requirements Specifications (FRS), System Design
Specifications (SDS), Software Requirement Specifications (SRS),
Disaster Recovery Documents, and Business Continuity Plan (BCP).
. Created use case, activity, logical, component & deployment views to
model Business Process Flows and Workflows.
. Conducted User Acceptance Tests (UAT), SWOT analysis, GAP analysis and
Object Oriented analysis.
. Provided Object Oriented Analysis using State Transition Diagrams,
Flow Charts to facilitate Joint Application Design (JAD) & Rapid
Action Development (RAD) teams function better.
. Created Use Cases, Sequence Diagrams, Activity Diagrams, AS-IS &TO-BE
models for GAP analysis and Class Diagrams as per UML using Visio and
Enterprise Architecture - Sparx Tools.
. Knowledge of RUP, Scrum, AGILE methodologies and Project life cycles.
. Assisted with SQL, PL/SQL and Oracle 9i, 10g concepts, features for
Database Management.
. Knowledge in web tools as DreamWeaver, JBuilder, JSP, HTML and ASP.NET
to develop interactive web pages.
. Work done in conjunction with testers, trainers, developers and
validation team to ensure project quality standards.
. Team player and self-starter with good communication skills and
ability to work independently and as part of a team.
2 TECHNICAL SKILLS:
Tools- MS Visio, MS Project, MS Outlook, MS Word, UML, Enterprise
Architecture (EA Sparx)
Methodologies-Rational Unified Process, AGILE, Scrum, SDLC Methodologies
Software used- Lexis Nexis, DataQuick, Millenium, Issue View, SystemView,
MMSSTV, Matlab
3 TECHNICAL ENVIRONMENTS:
Operating Systems- MS-DOS, Microsoft Windows NT/ XP/ 2003 /2000
RDBMS- Oracle 8/9i/10.2g concepts and MS Access 2003, MS Excel 2003
Languages- SQL, PL/SQL, JAVA, C, ASP.Net, JSP, HTML, XML, DreamWeaver,
JBuilder
4 PROFESSIONAL EXPERIENCE
BLUE CROSS & BLUE SHIELD OF NEBRASKA, OMAHA, NE
OCT 2008 - PRESENT BUSINESS TECHNICAL ANALYST
. BLUE SQUARE 3.2, 4.0, 4.1, 4.2 Releases
. CoreLink Migration
. ICI - Quoting, Enrollment, Underwriting & Membership Automation
. Radiology Management
. Macess Release
. Health Care Reform - Pre Existing Conditions Exclusions
Blue Square, a product provided by BCBS Association, Chicago to the Blue
Plans to facilitate Inter-Plan business processes in real time. It
streamlines the claims processing by enabling plans to exchange attachments
electronically. This product is released phase wise with multitude
functionalities in each release. As part of this project, BCBSNE integrates
its existing Inter Plan Teleprocessing Systems and Claims Processing
Systems with Blue Square. CoreLink Project is a massive transition of the
entire company to a new company - CoreLink, in merger with other Blue Cross
Blue Shield Plans. Individual Case Installation (ICI) Automation is the
integration with third party tool to automate of processes for BCBSNE
products purchase and enrollment. Radiology Management involves
establishment of external review repository that holds daily database
updates for validations incase a provider refers member for a radiology
examination. Pre Ex Conditions Exclusion is a Health Care Reform Provision
that relates t o the policy changes and underlying system and processing
changes for Underwriting, Membership, Claims and Sales Business areas of
BCBSNE.
RESPONSIBILITIES:
. Facilitate meetings to gather business requirements for 3.2, 4.0, 4.1
& 4.2 releases of the Blue Square, ICI Automation, Radiology
Management, Health Care Reform and CoreLink projects
. Documented Detailed Business Requirements for each release, Health
Care Reform provisions and CoreLink, ICI integrations and reviewed for
sign offs from the business stakeholders and the technical project
delivery teams.
. Drafted Functional Specification documents that maps the business
functionalities to the system components and process activities for
SDLC projects.
. Written Sprint Stories in Scrum projects and managed Agile Time &
Points as per story priorities and level of effort.
. Conducted team stand ups for Agile Sprints and tracked the progress
using Burn Up and Burn Down charts.
. Documented Use Cases and Context Diagrams (AS-IS) for the message life
cycles for different actors and validated them with the Business &
Technical teams of Claims adjudication and processing systems.
. Designed Process Flows (TO-BE) and UML diagram for the different Blue
Square Message types based on Business Rules for Plan as HOME and Plan
as HOST using MS Visio and the BPMN tool - Enterprise Architecture
Sparx.
. Worked with Membership, Medical Underwriting Services team and
Individual Case Installation teams to gather details and documented
requirements, health questionnaire, guided selling procedures,
processes for Brokers, Agents, Individual online users for ICI and
Health Care Reform Provision.
. Participated in sales forcasting sessions with sales teams to identify
the ICI web UI enhancements for improving sales.
. Worked with ETL team in Data Analysis and creation of data models for
Member files, Provider files and Claims information that is to be
exchanged between the external data warehouse and internal data
warehouse for Radiology Management.
. Built screen mockups and prototypes for application usage as per
guidelines and business rules.
. Gathered requirements for reporting and created layouts for open
inventory, productivity and aging reports.
. Assisted in System Specifications documentation using EA Sparx that
demonstrated the technical implementations of functions for different
services such as Enterprise Content Management Service, Enterprise
Integration Service, Plan Integration Service, and Subscriber Look up
Service & Provider Look up Service.
. Supported effectively the Business and IT as a liaison through all the
phases of the SDLC of the applications.
. Followed up and documented the post production issues and changes and
included in the Lessons Learnt document.
. Documented Business Continuity Plan with alternatives and
contingencies processes for different failure situations.
. Drafted Disaster Recovery Document with procedures and timelines for
recovery and normal re-functioning of the application hardware,
software systems and services post disaster.
. Worked with Quality Assurance Team for developing test scenarios, test
strategy, test plan and conducted Global Certification tests.
. Worked with Front End and Training teams in performing UAT and
assisted with training, production support for Blue Square, CoreLink,
Macess, Health Care Reform and ICI projects.
.
2 Environment: Database on Mainframe, IBM Web Sphere - Network Deployment
on Sun Solaris, IBM MQ - Queue Manager on Windows 2003, DB2 Connect,.Net,
SQL, UML, MS Visio, MS Word, MS Excel, EA Sparx, Scrum, SDLC
GROW NETWORK/ Mc GRAW HILL, NEW YORK CITY, NY
FEB 2008 - OCT 2008 BUSINESS SYSTEM ANALYST
. PLATFORM
. PRINT MANIFESTS
Platform is workflow system for the PLP product. The MyGuide Personal
Learning Program (PLP) is GROW's marquee individualized instructional
content product. Using state assessment data as a measure of student
proficiency against learning standards, MyGuide provides educators with
tools, strategies, and instructional material targeting individual
students, student groups based on performance bands, and entire classrooms.
A significant subsystem in Print section of the Workflow is the Print
Manifest system that comprises manifests for print vendors and internal use
to verify printed material and contents of all packages shipped for a given
project.
RESPONSIBILITIES:
. Gathered requirements from Product Team, Order Management Team, Client
Services and Development Team.
. Prepared Agenda, Meeting minutes, Visio representations, Detailed
Business Requirements, Technical Specifications.
. Understood the product life cycle and designed, drafted the Business
Process Flow documents, Visio representations for operations that
included Order Management, Configuration generation, Data Upload and
Validation, Production Pipeline execution, QA smoke tests, Print
Fulfillment and Web Deployment.
. Drafted documentation for Order Management processes and different
notifications during the order life cycle to internal teams via
IssueView. Designed IssueView statuses and components.
. Worked with the development team to create Configuration file.
Gathered requirements for file naming conventions, directory locations
and file formats of Configuration bases for all Markets and drafted
process for the Order Configuration generation from Market
Configuration and XLS to XML file formats conversions.
. Worked with the Data Upload Tool (DUT) Team on the student assessment,
address data life cycle and drafted process for the DUT interactions
with the Account Manager, Client and the production pipeline. Gathered
details on the account creation, login parameters and data transfer
across the environments.
. Documented the production pipeline execution process and automation
pre-conditions including the exception and failure workflows.
. Drafted the steps for Production output validations and smoke tests
for deployment and fulfillment.
. Worked with the Print team for defining print vendor selection process
and print output transfer rules. Gathered requirements for Print
fulfillment process of output file ripping, finishing and shipping.
Documented approach for Reprints and Order version controls.
. Worked with engineers and architects, on-site and off-shore to
establish interactions between production pipeline and PLS website for
thorough deployment of the feed files.
. Coordinated with sub-systems of Finance, EPIC (Editorial), Client
Services, and Training and Development teams and identified their
dependencies and functional roles on the order execution life cycle.
. Identified integration points for sub-processes of PDF versions of
Study Guides and Comprehensive Guides, FPA calculation, Display
strings generation and Content Mapping process.
. Created flow diagrams and logical data models for the entire workflow
comprising the multiple dependent systems and subsystems.
. Evaluated the existing TerraNova Grow product automation procedures
and workflow tool used to verify technology and components re-
usability.
. Studied other Grow products such as Parent Network and ISRs to verify
common processes so as to come up with a Shelf - product agnostic
approach based on the PLP Platform application.
. Assisted Project manager and coordinated operations and
implementations among all the various teams of PLP application
including the off-shore WIPRO team.
. Facilitate meetings to gather business rules from Grow Print Team,
Grow Print Vendors, and Grow Cross-Product groups.
. Conduct RAD sessions with Infrastructure Architects, Development Team
for understanding and documenting technical feasibilities, constraints
and implementation timelines.
. Documented detailed Business Requirements for Print Manifests that
include Address Manifest, Summary Manifest, Data Stream Manifest (per
stream & all), Fulfillment Manifest (Vendor & all) and Box Label
Manifest.
. Documented Functional Requirements for Print Manifests infrastructure
that relate to file splitting at Vendor, Document count and size
levels.
. Structured Early and Late manifests and prototypes as per the
requirements of the different Print Vendors used by Grow and to
synchronize with the Print Vendor software systems.
. Designed stream wise prototypes and samples for all the Print
Manifests in .xls, .csv and .html formats and annotated to the
business requirements.
. Incorporated actual and estimated Impression counts and prints
parameters for duplex and simplex cases of 8.5 x 11 and 11 x 17 print
streams.
. Studied the Collation Requirements of multiple products to identify
the stream and
. Created Visio representations for stream-wise Print Data Flow at the
Print Vendor and component-wise completed Printed Product.
. Documented the Grow Print process that presented the different
activities, entities involved such as Drop units, Package Units,
Assembly Units, Document Units, Machine configurations for multiple
File sets and File parts.
. Worked with QA team to help build test cases and scenarios for
different Grow products, different Vendors and different Markets and
Products.
3 Environment:
Notifications - IssueView; Configurations - XML, XLS; Database -Oracle
10.2g (Linux on RHEL 4 )
Content -Epic/Oracle IFS ;Web - CSS, JAVA scripts, Flash (Tutorials), WSL
10, XHTML, JSP, JSF, Seam 1.2, Hibernate, EJB 3, JDBC; Print -Python ETL,
PL/SQL, Grow Collation Scripts, DOPE, XSL.fo
Documentation - UML, MS Visio, MS Word, MS Excel; Methodology - SDLC
BLUE CROSS & BLUE SHIELD, DES MOINES, IA
JAN 2007 - JAN 2008 BUSINESS SYSTEM
ANALYST
. BLUE SQUARE 3.0
Blue2, a product provided by BCBS Association, Chicago to the Blue Plans to
facilitate Inter-Plan business processes in real time. It streamlines the
claims processing by enabling plans to exchange attachments electronically.
Specific functionalities to Confirm Attachment Transmission, Export
Messages, Receive Attachments, Send Attachments, and View Attachments
involved development and integration of Blue2 dependent front end, back end
systems of Compass & KoVIS.
RESPONSIBILITIES:
. Conducted Joint Application Design (JAD) & Rapid Action Development
(RAD) sessions to gather details from Business Unit, Technical Team
and prepare Agenda, meeting minutes.
. Understood the Business Process and documented the Detailed Business
Requirements that included Indexing, storing of Inbound attachments,
Retrieval of the Outbound, Integration tool requirements, Security,
Reporting and Misrouted Attachment Procedures.
. Reviewed DBRs with the Business Unit and the E-Business Team for sign
offs and drafted the Decision Document with changes based on the TPGn
(Technical planning & governance) decisions.
. Documented the Technical Specifications for WAS installations, MQ Set
up, Network, Firewall configurations, DB2 Connect configurations, LDAP
Specifications, Database procedures, Security Implementations,
Compass, KoVIS builds.
. Designed detailed work flows of Attachments 1 through 5 - inbound and
outbound involving multi system operations for the Business unit and
the Imaging unit using MS Visio.
. Designed Security procedures flow for the application within multiple
systems to enable single sign on and application access based
different data roles, privileges in WAS, LDAP, KoVIS, Compass and
Database.
. Drafted data requirements and system interface use cases, identified
data sources in the DataMart.
. Created data flow diagrams and logical data models for the To-Be
system based on the new integration system.
. Designed technical flows for WAS - MQ interaction, WAS architecture,
MQ Architecture, Compass Operational flows for each attachment type
and Swim lane representations for all the dependent systems.
. Developed test cases involving positive, negative testing for each DBR
with the testing team and performed peer reviews, reviews with the
Business Unit.
. Developed the Test Plan with the testing team for Test and Integration
phase, Pre- Prod phase and Production Phase.
. Worked with the concerned business staff in identifying required Test
data and obtained demo HIPPA compliant data for testing.
. Assisted Project manager and the entire Technical team explaining
Business Operations and implementations for Blue2 project application.
4 Environment: Database on Mainframe, IBM Web Sphere - Network Deployment
on Sun Solaris, IBM MQ - Queue Manager on Windows 2003, DB2 Connect, Java,
SOAP, SQL, UML, MS Visio, MS Word, MS Excel
CLEVELAND STATE UNIVERSITY, CLEVELAND, OH
AUG 2005 - DEC 2006
ALUMNI AFFAIRS & ADVANCEMENT SERVICES
PROSPECT RESEARCH & MANAGEMENT ANALYST
The Office of Alumni Affairs is responsible for planning, developing and
implementing a comprehensive alumni relations and student alumni program
for the University, including strategic planning, fiscal management and
program development in support of the University's strategic advancement
goals. Advancement services focuses on performing research and analysis of
high end alumni financial data across continental US to identify potential
prospects for contributing to comprehensive alumni giving programs for the
University.
. Extracted potential prospect details from the databases using
applications such as Millennium, Lexis Nexis, Wealth Engine and
Dataquick for specific demographic locations.
. Performed research on the extracts and generated excel reports to
analyze and identify prospects for Alumni funding programs.
. Assisted in designing and maintaining databases to track alumni
contributions and analyze evaluation funding data.
. Maintained confidential files and worked on their upgradation on the
University database systems.
. Updated Excel and Word worksheets of the databases for alumni events
within and outside campus.
. Managed the migration of old files, records of the deceased alumni to
the appropriate internal systems.
. Assisted program director with event planning, office tasks, writing
letters and invoices, accounts payable, taking notes during meetings.
. Conducted and planned alumni sessions, being responsible for all
general updates on the alumni affairs internal website pertaining to
fund raiser activities.
Environment: Lexis Nexis, DataQuick, Millenium, SQL, DreamWeaver, HTML, MS
Visio, MS Word, MS Excel
NATIONAL INSTITUTE OF AMATEUR RADIO, INDIA DEC
2003 - AUG 2005
RESEARCH ANALYST
. DIGITAL INTERFACE FOR VISUAL COMMUNICATION
National Institute of Amateur Radio is an organization promoting ham radio
and its operations for wireless radio communications. Its prime focus lies
in Natural Disaster Management using amateur television or radio based
communication. The organization was the backbone for the entire
communication network in the Tsunami effects and has displayed effective
disaster management at the time of catastrophe. This project involved the
modeling of an interface in the application for wireless transmission of
pictures to transceivers located at distance using MMSSTV software.
RESPONSIBILITIES:
. Interacted and worked with the Design Team for analysis and modeling
of the transmission interface in between a system and a transceiver.
. Hardware realization of a digital interface between a SSB rig and a PC
Sound card at transmission and reception ends to enable wireless
picture transmission.
. Analysis of Slow Scan Television technique and usage of MMSSTV
software for translating fixed image to audio tones by converting the
color and brightness variations and vice versa at reception.
. Analysis of techniques to design basic low cost economic models of
digital equipment primarily to be used in case of any kind of
emergency - natural or manmade calamities.
. Designed and documented functional, technical specifications of the
interface for wireless picture transmission.
. Tested the interface, trained users and volunteers on the application
usage and created powerpoints to demonstrate the capabilities of the
application over long distances.
Environment: MMSSTV, Matlab, MS Word, MS Powerpoint
1 EDUCATION:
Masters of Science in Electrical and Electronics Engineering
Cleveland State University, Cleveland, Ohio, USA
Bachelor of Technology in Electronics and Communication Engineering
Jawaharlal Nehru Technology University, Hyderabad, India
2 REFERENCES:
Available upon request