business / reporting analyst
Resume:
Lekha Ranganathan *********@*****.***
SUMMARY
Around 4 years of wide experience in Telecom (Retail Sales and Commissions), Insurance and
Customer Support Service sector with focus on Business Analysis. Experience in managing
requirements from project initiation through release and exposed to all stages of software development
life cycle. Adept in identifying and solving business problems and implementing appropriate technology
solutions.
• Experienced in gathering user requirements, analyzing and preparing Project Deliverables
such as Business Requirement Document (BRD) and Functional Requirement Document
(FRD) and proposed changes for process improvement.
• Strong business analysis skills with in depth knowledge of all phases of Software
Development Life Cycle (SDLC) such as Requirement analysis, Design, Development,
Testing and Deployment.
• Skilled in Object Oriented Analysis and Design with experience in creating Use Cases, Class
Diagrams, Activity Diagrams, State Diagrams, Sequence Diagrams, Business Object,
Unified Modeling Language (UML) using MS Visio and Rational Rose to depict process
flow.
• Adept in various software development methodologies like Agile, Waterfall across the span
of various projects.
• Proficient in transforming business requirements into functional specifications, user
interface design and process flow.
• Highly proficient in working with users and stakeholders to elicit, analyze, communicate
and validate requirements using JAD and JAR sessions and expert in business
process engineering.
• Involved in maintaining Test Matrix and Traceability Matrix, performing UAT for the
application to ensure that the application meets the requirements.
• Assisted both development and testing team in preparing high level technical design
document and test plan document by analyzing the impacts.
• Exceptional understanding of Data Warehousing life cycle and strong analyst experience on
Data Warehousing applications.
• Good Experience and Understanding in various ETL Tools like Informatica and Datastage,
Reporting Tools like Datameer (A BigData Reporting Tool) and Business Objects.
• Experience in Incentive Compensation Management (ICM) Tool Callidus - Truecomp .
• Experience in writing SQL queries in querying different Data Bases.
• Good working knowledge of QA activities like Test Plan preparation, Test case
writing/review with an expertise in User Acceptance Testing (UAT) and actively participated
in Post Production Validation (PPV).
• Active participation and role in Defect Life Cycle (DLC).
• Proficient in tracing and managing requirements and Change Impact Analysis.
• Experience in Customer Relationships and Clients interactions.
• Coordinating onshore – offshore calls.
• Team player, result-oriented, fast learner, excellent communication skills with strong research
capability.
TECHNICAL SKILLS
Requirement Gathering Tools IBM Rational Team Concert, Rational Clear Quest
Modeling & Designing Tools IBM Rational Rose, MS Visio
Operating Systems Windows, UNIX
Databases Oracle, MS SQL Server.
Languages C, C++, HTML
SDLC Methodologies Agile, Waterfall
Data ware housing tools ETL-Informatica Power Center 8.x, ETL-Data stage 8.x.
Reporting tools Business Objects, crystal reports & Datameer
Testing & defect management Quality Center & IBM-Rational Team Concert
tools
PROFESSIONAL EXPERIENCE
Avaya Material Mod Management System, Avaya Global Mar 14 - Present
Business Analyst
This project has implemented a new infrastructure inculcating the new Avaya material pricing
model maintaining the historical pricing models available for business reference and meeting compliance
and regulatory requirements. The new pricing models have been efficiently designed to render
independent pricing models for government agencies and private parties.
Responsibilities:
• Agile project methodology, Involved in iteration planning, scrum calls and retrospectives.
• Business requirements analysis, identification of Inbound, Outbound systems and their
dependencies.
• Requirements gathering with Product Owners and Business SMEs, identify the product backlog.
• Conceptual, Logical and Physical Data model designs, preparation of technical design
documents.
• Facilitate Iteration Planning, Demo, Retrospectives, and coordinate with developers and testing
team.
• Analysis of Data sources and facilitated the meetings with other dependent systems.
• Target systems identification and coordinate with the development and architect team on loading
strategies.
• Preparation of S2T, Use Cases, AS-IS TO-BE and Analysis and Design documents.
• Configuration and defect management, and Involved in all the configuration management
activities.
• Validation of old and new pricing models post development on test and UAT boxes.
Environment: IBM Web sphere DataStage 8.1, Java / J2EE, UNIX Shell Scripting,
SAP, Mainframe, Erwin, SQL
Conversation Plan 3, USAA, San Antonio Dec 13 -
Feb 14
Functional / Reporting Analyst
MSR are presented with a guide to help with the conversation as well as relevant guidance during
the conversation in order to provide insight in the members life and enhance the member experience by
providing relevant offers, recommendations, advice and reminders. Conversation Plan will improve the
call effectiveness and efficiency by reducing the time it takes to research the members profile and
synthesize relevant advice and recommendations.
Responsibilities:
• Schedule RAC sessions to identify how the offers can be integrated with conversation plan.
• Analyzed Conversation Plan and Business Rules for Offers to find how they work in today's
world.
• Closely Interact with the Business Manager in identifying the Scope of the Project and
Requirements.
• Analyzing the present Application UI Design and discuss with UI designer and Business Manager
on the future UI Integration.
• Identify the stories based on the scope of the Project.
• Conducted numerous Story Writing and Pointing Sessions.
• Put all the Stories, Impediments and Tasks in RTC and tracking the burndown.
• Attended the Feedback Sessions for MSR's, where-in they provide us their feedback on the
Conversation Plan and Offers and their expectation on the look and feel as an integrated one.
• Y-Cord with the MSR to see what are all the functionalities they use often during their
conversation with the members.
• Created Reports and Dashboard using Datameer, a Hadoop Big Data reporting tool, for the
Business Support Team to help them identify the usage of the Functionalities of the Conversation
Plan 2.
Environment: Windows XP, Datameer, Portal Applications
Info Capture 2 (Scratch Pad, USAA, San Antonio July 13 -
December 13 Functional / Reporting Analyst
The new Scratchpad tool, similar to notepad, will enable MSRs to capture notes from member
conversations and associate each set of notes within a different tab that is specific to that USAA number.
Information will now systematically be transferred from one system screen to another as a drop down
selection when identified by business rules. Scratchpad recognizes address, phone number, email address,
dates, amount, Account Number, Routing transit Number, Social Security Number, Tax Identification
Number, Drivers License Number and Vehicle Identification Number. Once MSR keys this information
into Scratchpad, it available as a drop down in Portal and other systems, reducing the need to copy/paste.
Responsibilities:
• Schedule RAC sessions to identify the applications that has to be integrated with Scratch Pad
with various teams.
• Analyzed the application and identified the fields that has to integrated with Scratch Pad.
• Closely Interact with the Business Manager in identifying the Scope of the Project and
Requirements.
• Identify the stories based on the scope of the Project.
• Conducted numerous Story Writing and Pointing Sessions.
• Participate in Enterprise Requirement Gathering sessions.
• Help in the SQA and CQA Documentations.
• Put all the Stories, Impediments and Tasks in RTC and tracking the burndown.
• Assisting the Development team with their queries in the Story.
• Assisted QA team in test plan and impact analysis.
• Created Reports and Dashboard using Datameer, a reporting tool, for the Business Support
Team to help them identify the usage of the Functionalities of the Scratch Pad.
• Worked in an Internal Tool - CSI Admin which helps adding the Data Inject and Data Capture
functionality to the identified fields from various application for the field to integrate with
Scratch Pad.
• Participate in the APO Demos.
Environment: Windows XP, Datameer, Portal Applications
Push Communication and Training, USAA, San Antonio Sep 13 -
Present
Analyst Programmer
Without the UMA, Intradiem clients must manually enter and maintain all user information in the
Intradiem User Interface (UI) or import user records from a Comma Separated Value (.csv) file.
Through the UMA, Intradiem is programmatically linked to customer system(s) such as an HR Database
that contains user information. This link makes the process of sharing user data automatic, with little or
no human intervention required. This provides an automated method of building the user hierarchy
structure and user profiles within Intradiem, mapping Intradiem Permission Profiles to internal client
roles, and automating the management of attributes which will then give USAA the ability to streamline
assignments and reporting.
Responsibilities:
• Understanding existing business model and customer requirements.
• Analyzed the various subject areas in ODS database along with Business Analyst to determine the
exact business.
• Analyzed the functional specifications provided by the Data Architect and created technical
specification documents for all the jobs.
• Analyze the new change request, estimate the new change and design the same.
• Extracting data from sources like oracle, flat files and transforming them using business logic and
loading the data to the business tables.
• Created Datastage Parallel Jobs based on the requirement and placing the file in the B2B
Location.
• Extensively used processing stages like join, sort, aggregator, transformer Stages in
developing jobs.
• Querying the different tables present in different Database (oracle and Sql Server) and update it
based on the requests.
• Preparation and Execution of Unit Test Scenarios, Unit Test Cases and Unit Test Data.
• Managing Defects using Defect management tools like Rational Clear Quest and Rational
Team Concert.
Environment: Windows XP, Oracle 10g, SQL Server, Datastage 8.1 & 9.1, RTC
TradeSpectrum, Greensboro, NC Apr 12 -
Aug 12
Business Analyst
TradeSpectrum is a real time Trading Analysis Application that generates alerts for best time to
buy and sell Stocks, commodities and forex pairs. TradeSpectrum is a multi-threaded, high performance,
distributed scalable application that processes 100+ millions of calculations every 15 minutes. In addition,
TradeSpectrum provides interfaces to brokerage firms for auto trading and web interface for registered
users to manage and process alerts. The generated alerts are instantly communicated to the registered
users via emails, TS messengers and cell phones.
Responsibilities:
• Conducted the Requirement Gathering Sessions.
• Analyzing the system and drafting the AS-IS and To-BE Documents.
• Assisting in the Preparations of Technical Design Documents from the Functional Design
Documents.
• Developed UML Diagrams and flow diagrams in MS Visio based on the Business Logic.
• Knowledge on Informatica tools–Repository Manager, Designer, Workflow Manager and
Workflow Monitor.
• Involved in Data modeling and Design of star schema with DIMENSION and FACT tables.
• Extensive use of SQL commands with TOAD environment to query the Database for analyzing
the Data.
• Reviewing the Test case and Test Scenario with the Testing Team.
• Analyzing the Defect and provide feedback to the Testing team.
Environment: Windows XP, Oracle 10g, SQL, Informatica ETL (8.x), Crystal Reports,TOAD, HP
Quality Center
Comcel Comissiones, Accenture, India May 11-
Nov 11
Business Analyst
Claro Colombia (Comcel) is a Colombian telecommunications operator, owned
by Mexican group América Móvil. Claro is the largest provider of mobile phone services in the country.
The objective of the project is to build a commissions system, which calculates the payments and
incentives for both external and internal dealers for Comcel. Comcel commissiones is implemented using
Truecomp, Callidus Tool, which facilitates transforming the business into Rules . The system is built
using Informatica ETL tool, TrueComp rules engine and Crystal Reports reporting tools.
ETL will process the incoming data (Transaction and Reference Data), run a batch processing job
to calculate commissions (TrueComp Pipeline) using Rules written based on business logic, extract the
operational data (Report ETL utility) into a reporting repository (Data Mart) and produce data extracts for
end users.
Responsibilities:
• Conducted Joint Application Development (JAD) sessions and documented Business and
Functional Requirements documents.
• Carried out GAP and Risk analysis to mitigate risks.
• Responsible for preparation of Technical Design Documents from the Functional Design
Documents.
• Developed UML Diagrams and flow diagrams in MS Visio based on the Business Logic.
• Conducted numerous walk through to offshore team members on the client’s business logic.
• Assisted development team in creation of Data warehousing design, Mapping, Mapplet &
Transformations to import source and target definitions into the repository and to build mappings
based on the functional requirement
• Assisted QA team in test plan and impact analysis.
• Assisted DEV and QA team with experience of SQL queries.
• Participated in User Acceptance Testing and Manual Testing.
Environment: Windows XP, Oracle 10g, SQL, Callidus TrueComp (6.x), Informatica ETL (8.x), Crystal
Reports, IBM - Rational Team Concert.
Telcel Commissiones, Accenture, India Nov 10 -
Apr 11
Functional Analyst
The Project Telcel Comissiones is one of the very few green field projects to create a
commissions system which will have the responsibility for calculating both external and internal
commission payments for Telcel. The project was implemented using a package which is specialized in
computing commissions in various industry segments. The system was designed to process the incoming
data feeds (Data Integration), run a batch processing job to calculate commissions (TrueComp Pipeline),
extract the operational data (Report ETL) into a reporting repository (Data Mart) and produce data
extracts for downstream systems.
Responsibilities:
• Gathered requirements by using interviews, observation, JAD, brainstorming sessions, and
documents analysis.
• Preparation of Technical Design Documents from the Functional Design Documents.
• Involved in creating Business Flow Diagrams, Dataflow diagrams, UML Activity diagrams and
USE cases diagrams using MS VISIO
• Work closely with the Developers and giving walkthrough on the business logic.
• Taking the ownership of the Change Requests, Analyze and update the functional specification
document based upon the change request.
• Assisted development team to understand the ETL process using Informatica tool as per the
business logic.
• Reviewed development plans, quality assurance test plans, and user documentation to ensure
correct interpretation of original specifications
• Helped QA team to prepare test strategy, detailing test approach, data used and impacts.
• Extended support to QA team during System Integration and User Acceptance Testing phases.
Environment: Windows XP, Oracle 10g, SQL, Callidus TrueComp (6.x), Informatica ETL (8.x), Crystal Reports
Fireman's Fund Insurance, Accenture, Mumbai, India Jun 10 - Nov 10
Analyst Programmer
Fireman Fund's Insurance is an insurance firm serving individuals with a wide range of insurance
products and insurance related services. It has a wide range of Insurance Products that include Auto
Insurance, Home and Life Insurance. Claims Management System provides the technology that assists
claim professionals in administering claim practices in a timely and effective manner. The application
involved in the design and development of the Data Warehouse. The company’s data came from different
operational sources and was then loaded into the Property Data Warehouse using Datastage.
Responsibilities:
• Involved in gathering user requirements.
• Analyzed functional requirements and created use cases and process flows for the same.
• Documented the As-Is and To-Be process flows.
• Involved in documenting data flow diagrams.
• Worked with SQL queries for data manipulations.
• Extended support to DEV team in Designing jobs to extract, cleanse, and parameterize the jobs
to allow portability and flexibility during runtime, to apply business rules and logic at
transformation stage and load data into data warehouse.
• Extended support to DEV team by created jobs in Data Stage to extract from heterogeneous data
sources like Oracle, ODBC, SQL Server and Flat files.
• Assisted in developing BO universe using Data quality database which consists of assessment
results, assessment plan information and error details
• Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met.
Environment: Windows XP, Oracle 10g, SQL, Datastage 8.1,TOAD, Business objects XI R3.1
BITSD, Chennai India Jun 09 - Apr 10
Functional Analyst
The Project was done by software development department for a Telecommunication client. DNA
(Dynamic Network Analyzer) Framework collects connectivity information from each domain but
explicit information on inter-domain connectivity is not available from the Domain Management
System. Inter-Domain Digital Link and Path Manager (IDLPM) supports the inter-domain connectivity
and the end-to-end reports for all existing in-effect service IDP(s) and IDDL(s) or Circuit(s) (Inter-
domain link and paths) that traverse multiple network domains. With the capability to analyze multiple-
domain network data, IDLPM provides solutions to build up inter-domain connectivity data in the DNA
Framework database.
IDLPM provides user tools to manually join all segments of a path from multiple domains.
IDLPM can be used to tie together independent intra-domain segments of inter-domain connections.
Based on these manually established links and all associated information, this feature performs auto
discovery of inter-domain paths. Based on the connectivity information established by this feature, a
Service Provider is given the tool to manage inter-domain service (Paths) trails. As a result, a service
provider can define unique path ID across domains, obtain auto creation of low level service paths, and
manual correlation of mismatched paths.
Responsibilities:
• Interacted with business in gathering requirements and with system architect on Mapping
documents and Design process for various Sources and Targets and created use cases and
process flows for the same.
• Documented the As-Is and To-Be process.
• Evaluated data quality processes.
• Resolved data quality issues
• Developed SQL queries to extract data.
• Interacted with business and Domain Management System IT teams to create a data mapping
document which define, agree and document incoming data mapping specifications.
EDUCATIONAL QUALIFICATION
B Tech with specialization in Information Technology with Distinction (81%)
Contact this candidate