SHIRISHA GUDURU

314-***-**** ac12qf@r.postjobfree.com

SKILLS & EXPERTISE

Self-Starter and a fast learner with excellent research and analytical skills along with effective communication and presentation skills.

Adept in gathering, understanding and analyzing requirements by performing Gap, Risk, Impact and feasibility analysis.

Excellent documentation skills with diagrammatic representations using with Use Case Diagrams, Activity/Flow, State, Entity, Swim Lanes diagrams using MS Visio.

Knowledge in all phases of Software Development Life Cycle (SDLC) such as Waterfall, Rational Unified Process (RUP), and Agile (Scrum) Methodologies.

Experience of working in a fast-paced, results oriented environment and proven track record of achieving success within deadlines.

Proficient in Agile principles and expert in all the Scrum ceremonies and artifacts.

Advanced skills in Excel (Formulas, VLOOKUP, HLOOKUP, Pivot tables, Macros).

Great grasp of SQL and familiarity with XML and HTML.

Well versed in the rules and regulations for the Health Insurance Portability and Accountability Act (HIPAA), HMO, PPO, Affordable Care Act (ACA), EOB, COB and Medicare/Medicaid programs.

Knowledge of provider programs, claim processing and adjudication, Pre-Authorization and medical terminology and crosswalk from ICD-9 to ICD-10.

TECHNICAL SKILLS

Project Methodologies

Agile (Scrum), Waterfall, Rational Unified Process (RUP)

Business Modeling Tools

MS Visio, Balsamiq, OmniGraffle

Tools

JIRA, HP ALM, Rally

Data Visualization tools

Tableau, Power BI

Databases

MS SQL Server, Oracle and DB2

Business Applications

Microsoft Office Suite, MS Visio, MS Project, SharePoint

EDUCATION

San Diego State University, San Diego, CA (2014-2016)

Masters in Electrical & Computer Engineering

PROFESSIONAL EXPERIENCE

University, SDSU Office of Alumni Engagement April 2016 – December 2016

Alumni Engagement Officer

Participate in meetings with the Business, gather requirements, and document the needs and objectives.

Maintained a strong understanding of the university programs as well as specific initiatives of various colleges in the university.

Engaged in brainstorming sessions, one-on-one meetings with the team, leads and managers planning to achieve targets and attain maximum results.

Maintain/change established policies and procedures, document them and provide inputs on the templates for emails to be sent out to our prospects.

Worked on the Smart Call application and reported bugs and enhancements for UI, user navigation and functionality.

Maintained Understanding of the Business rules and provided recommendations in enhancing the outreach through feedback from Alumni interaction.

Divide alumni into various categories for efficiency and effectiveness in fund raising.

Gathered feedback by designing forms, surveys and questionnaires.

Participate in meetings with the Deans of various colleges and understand their goals for that fiscal year and devise procedures accordingly.

Analyzed, derived insights on the data of alumni response patterns and devised strategies accordingly.

Assisted in training new recruits, and in providing feedback.

Communicated with Alumni, built rapport and conveyed the importance of giving back to SDSU.

Excelled in being a part of a fun, competitive, passionate team about supporting the university.

ACADEMIC EXPERIENCE

The main objective of the project was to keep customer attrition in check by utilizing the customer churn rate KPI. The target was to perform customer value analysis along with customer churn predictions which will help marketing programs target more specific groups of customers and help the company in its customer relationship management.

Responsibilities:

Worked extensively with Data Preparation. Performed Data wrangling before the load, fix data in Excel, Cleaning and De-duplicating the data from various sources which is in different formats.

Data manipulations in Excel to set the foundation and to ensure Data consistency.

Data Formatting, Data Cleaning, Filtering and Sorting in Excel and handled different data types.

Performed Transformations on Data- Format Revision, Filtering, and Aggregating etc., to maintain Data Quality.

Looked for anomalies and used SQL Server Integration Services (SSIS) to upload data into the SQL Server Database.

Created Data mapping documents with the Source, Destination and Transformation Logic.

Created data flows and upload data into SSIS by automating the error handling through Conditional Splits and filtering out the bad records.

Worked with SQL in uploading data in SQL management Studio and used Wildcards, Regular Expressions, Joins and other DDL, DML Queries in SQL.

Handled errors and perform additional Quality Assurance checks for Zip code, Birthday etc., using SQL Programming.

Performed the ETL process- Data Extraction, Data Transformation and Loading process of the collected data.

Create visualizations from the insights derived using Tableau and present using PowerPoint.

Contact this candidate