Application Analyst/Business Analyst
3+ Years of experience as a Business Analyst with Banking (Mortgage) and Insurance domains. Capable of building and maintaining strong relations with stakeholders, and successful in attaining client satisfaction.
ISO 9000: Lean Manufacturing Certification
SPSS (Statistical Package for the Social Sciences)- Project on “Obesity in India”. Determined Statistical Analysis on Obesity; Study and analysis of the factors that cause obesity (age, gender, height, weight, diet, eating habits, etc.)
Agile, Hybrid (Agile & waterfall)
Requirement Gathering/Document Creation
MS Office (Excel, Word, Outlook, PowerPoint, OneNote)
Unified Modeling Language
MS Office, SharePoint
Lotus Notes, Outlook, SameTime, Slack, SharePoint
SPSS, Tableau 10.0, SSRS
St. Francis College for Women
Bachelors in Science (Mathematics, Statistics, Retail Management, Computer Science)
The University of Findlay
MBA (Operations Management)
The University of Findlay
Relationship Marketing: Different Strokes for different folks
Researched the Difference between first time buyers and second time buyers
How to deal with first time and second time buyers
why is it important to segregate customers and deal accordingly?
presentation at “Symposium for scholarship and creativity-2016” and “Minds @ work: Students research conference -2016”
Relationship Marketing through Ethics
Importance of keeping a continued relationship with customers
Consequences of unethical behavior
How ethics play a major role in retention
Paper Presentation at “IABPAD” (International Academy of Business and Public Administration Discipline) Conference, Orlando, FL
Great American Insurance Company April 2017 – current
Application Analyst/ Business Analyst
Project Description: We have over 97 Financial reports which required testing due to upgradation. There are two parallel projects which are interlinked.
Project1: Upgradation of BillingCenter7 to BillingCenter9
Project2: Upgradation of SSRS 2008 to SSRS 2016
•Involved from initial phases of the project
•Created user stores on rally and assigned tasks to relevant team leads
•Acted as a scribe for all the agile meetings
•Planned sprints and designed project roadmap
•Helped senior business analyst in gathering the requirements for the development of BC9 User interface
•Worked on validating and developing the BillingCenter reports
•Extracted SQL queries from RDL using Oxygen
•Executed SQL scripts to extract data
•Validated RDL for accuracy and consistency
•Developed customized reports and optimized execution
•Automated various manual steps of report generation and parameterized scripts
•Various field/attribute modifications are designed and validated both in RDL and Views
•Changed field names in views and RDLs using eclipse and deployed them in GIT master
•Cleaned and streamlined the SSRS reports.
•Created monthly snapshots periodically to generate archives for data validation purposes
•Executed multiple customized jobs in UC4 for archived report data accuracy
•Compared billing center 7 reports against billing center 9 to validate end to end accuracy
•Gathered report requirements from business and customized them
•Job Shadowed Accounts Payable and Receivable team's process in order to automate their current manual process
•Documented account payable's AS-IS process and drafted TO-BE - Walked them through the process after the automation and provided them with relevant documentation.
•Created MACROS to reduce work-time spent on repetitive tasks and increased productivity
•Experienced in creating utilities to reduce simple manual tedious jobs
Environments: Rally, MS SQL server, SQL, SSRS, Eclipse, GIT, Diffex Engine, Oxygen XML editor, UC4, Visio
Teknuance Oct 2017 – March 2018
•Performed GAP Analysis on the requirements, identified the gaps using outcome analysis, and documented the GAP Analysis report.
•Involved in preparing the initial Wireframes for front end GUI interface.
•Model detailed design of the system using UML diagrams including Sequence Diagrams, Activity Diagrams and Data Flow diagrams using Smart Draw.
•Responsible for analyzing project goals, breaking down what needs to be created and attempting to engage users so that definite requirements can be defined.
•Drafted Test Plan and Test Cases for testing the functionality of the application.
•Queried tables to compare the results against the requirements.
•Participated in User Acceptance Testing (UAT), regression, black box and system testing.
•Strong knowledge of metadata organization, data cleansing, data profiling, and data modeling techniques including Star Schema and Snowflake Schema.
•Performed data analysis using Tableau.
•Used calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau. Involved in creating dashboards by extracting data from different sources. Worked with large volumes of datasets and loading delimited files into tableau.
•Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
•Creating and managing skills matrix to capture the expertise of resources.
•Executed SQL statements to extract data from the tables to validate data flow.
•Solid analytical skills with the ability to collect, organize, and disseminate significant amounts of information with attention to detail and accuracy
•Identify, analyze, and interpret trends or patterns in complex data sets
•Filter and "clean" data by reviewing computer reports, printouts, and performance indicators to locate and correct data problems.
•Participated in User Acceptance Testing (UAT), Smoke tests, regression, black box and system testing.
Environment: MS Visio, Rally, Windows, Java, MS Office (MS Word, MS Excel, MS PowerPoint, SharePoint), SQL Server, Tableau
HSBC- Hyderabad, India Aug 2013 - Dec 2014
Mortgage Analyst/ Business Analyst
•Solved issues related to customer’s pre-mortgage application and post funds release
•Custodian for customer’s property
•Obtained redemption amounts from banks when customers relocated
•Served both personal and business customers in United Kingdom
•Maintained good quality of work and got appreciations from solicitors
•Assisted the team in management reports and maintained an error free year
•Adhered to compliance procedure; maintained confidential information: Customer mortgage details, Account information, Loan information etc.,
•Facilitated procedural daily update to the UK business area.
•Build business process modeling diagrams for mortgage loan origination.
•Created AS-IS model and performed GAP analysis to include automation of mortgage loan origination process.
•Identify stakeholders and consult with appropriate partners to effectively design solutions for non-functional, security and reporting requirements.
•Gathered business requirements through interviews, surveys, prototyping and worked with team to identify gaps and defects.
•Working knowledge on Relational Database and created reports for higher management.
•Experience on Rules Harmony and Data Quality Platform tool. Basic understanding of ETL concepts in Informatica tool.
•Good understanding of dimensions of data quality.
•Generated reports on production server using SSRS.
•Assisted in modeling UI wireframes, Mock-ups and Documenting the end-user's workflow and business processes.
•Involved in UAT testing; Created Business Scenarios and Test plans for UAT testing.
•Conduct walk through of Business Analyst artifacts and acquire customer sign off on requirements
•Familiar with Anti-Money Laundering (AML)
Environment: MS Visio, JIRA, JAVA, BPMN, Agile & Waterfall, SQL Server, SSRS, SSIS