Data Analyst

Sadhana Reddy

Application Analyst/Business Analyst

Email: ************.******@*****.***

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.

Certifications/Projects:

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.)

Technical Skills:

Project Methodology

Agile, Hybrid (Agile & waterfall)

BPM Tools

MS Visio

Wireframing Tools

Balsamiq

Requirement Gathering/Document Creation

MS Office (Excel, Word, Outlook, PowerPoint, OneNote)

System Designing

Unified Modeling Language

Content Management

MS Office, SharePoint

Tracking Tools

JIRA, Rally

Internal Communication

Lotus Notes, Outlook, SameTime, Slack, SharePoint

Statistical Tools

SPSS, Tableau 10.0, SSRS

Version Control

GIT

Development Workspace

Eclipse

Job Schedular

UC4

College

Course

Place

St. Francis College for Women

Bachelors in Science (Mathematics, Statistics, Retail Management, Computer Science)

Hyderabad, India

The University of Findlay

MBA (Operations Management)

Findlay, Ohio

The University of Findlay

Student Assistant

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

Professional Experience

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

Responsibilities:

•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

Project Analyst

Responsibilities:

•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

Responsibilities:

•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

Contact this candidate