**Geethanjali Pennagaram Saarangan**

Bothell, WA 98012  |  612-860-8060  |   [geethanjalips@hotmail.com](mailto:geethanjalips@hotmail.com)

**Data Analyst**

Results-driven Senior IT Professional with eight years of experience developing data management and analysis projects and solutions. Oversee all aspects of project implementation, including deploying, testing, validating, and troubleshooting complex modules. Project leader who leverages technical proficiency and strong work ethic to motivate teams to exceed project requirements. Logical problem solver who remains calm and focused in high-stress situations.

**Core Competencies**

Strategic IT Planning & Execution |Software & Enterprise Data Management |Database/Warehouse Architectures

Application Development | Data Modeling | Data Mart Designs | Agile Methodology | Scrum Master | ETL Processes

Data Collection | Data Mining & Analysis | Quality Assurance | Statistical Techniques | Technical Reporting

OOPS Concepts | Programming & Coding | Query Development & Optimization | Software & ERP Change Management

Techno-Functional & Business Analysis | Client Relations | Team Leader & Trainer | Cross-functional Collaboration

**Select Technical Skills**

**Domains:**         Healthcare, PeopleSoft HRMS 9.0, Banking

**Languages:       ** SQL, PLSQL, MySQL, R studio, SAS, PeopleCode, Java J2EE, JavaScript, HTML, XML, SQR, JSP, jQuery, CSS

**Databases:       ** Oracle 11g, SQL Server, DB2

**Tools:**         Sybase PowerDesigner, Toad, AQT, SQL Server Management Studio 2008, SQL Developer, SAS, SQL, Informatica PowerDesigner, Informatica Workflow Manager, Server Integration Services 2008, Verity, People Tools 8.49, Application Designer, AutoSys, EditPlus, Exam Diff, Coolgen, Eclipse, CICS, JCL, VSAM, Rapid Miner, Minitab, Microsoft Office, Query Surge

**Functional Knowledge:         ** Healthcare Membership, Claims, Risk Adjustment, and Reinsurance Data Feeds; PeopleSoft HRMS Talent Acquisition Management & Candidate Gateway; VURV Recruitment Model

**Large Data:**         Hadoop, Hive, Pig, Amazon Redshift

**Education**

Johns Hopkins University, Coursera         2017

**Data Science Specialization**

_Coursework: Data Scientist's toolbox, R Programming, Getting & Cleaning data, Exploratory data Analysis, Reproducible Research, Statistical Inference, Regression Models, Practical M__achine Learning, Developing data Products, Data Science Capstone Project._

University of St. Thomas, Saint Paul, MN         2013

**Master of Science in Software Management, GPA: 3.9/4.0**

_Project: Used Hive in Hadoop platform to create sales data tables for fictional company; transformed/cleansed data using Pig._

Anna University, Tamil Nadu, India        2008

**Bachelor of Engineering in**  **Electronics & Communication Engineering**

**Professional Experience**

**Ciber Inc.** , Greenwood Village, CO        Mar 2014 – Feb 2016

**Senior Data Analyst, Medica Health Plans**

- Developed reports and process for data validations of risk adjustment and reinsurance data feed projects.
- Attended weekly Center for Medical Services user group calls, gathering required information for data feed projects.
- Improved data quality and reduced issues by leading data architects in proactive analysis for sources and target data derivations and identifying data scenarios.
- Analyzed legacy SAS code to identify transformations and source elements for migrating to new system.
- Collaborated with cross-functional and business teams to gather and validate requirements for vendor feeds.
- Developed PL\SQL Code to automatically refresh and generate data validation reports
- Streamlined documenting efforts and reduced project managers' time spent on Agile artifacts 50% by setting up tasks on Version One and developing Agile templates.

**Geethanjali Pennagaram Saarangan       **         **Page Two**

612-860-8060                [geethanjalips@hotmail.com](mailto:geethanjalips@hotmail.com)

**Professional Experience (Continued)**

- Directed three members of quality assurance team in validating data for complex and newly designed ETL processes.
- Developed scripts to refresh development database with most recent production data for improved analysis and reporting.
- Managed developers in testing development database applications with real and most current data to identify and implement solution to resolve testing defects/issues.
- Developed an SQL framework for a complex SQL problem, standardizing the framework that can be enhanced for developers, analysts, and architects for future projects.
- Aided in redesigning and validating restatement process.
- Worked in Agile-oriented data warehouse projects and as Scrum Master on Agile projects.
- Trained three quality assurance analysts on new data mart validation process and various data feed validations.
- Received Award of Excellence from client team for project success, on-time reports, and decision reviews.

**Dahl Consulting** , Little Canada, MN        Sep 2013 – Mar 2014

**Senior Data Analyst, Medica Health Plans**

- Analyzed source and target elements to integrate legacy system data into newly designed data mart.
- Assessed production issues and identified causal reasons (data/source to target mapping).
- Validated data of complex and newly designed ETL processes for quality assurance.
- Collected data usage statistics from databases for optimization analysis and decision making.
- Developed new code and modified existing code to access needed data within two-week timeline.
- Resolved data issues with little metadata information, applying knowledge of business.

**Medica Health Plans** , Minnetonka, MN        Oct 2012 – Sep 2013

**Data Analyst, Intern**

- Assisted quality assurance team in validating data of complex and newly designed ETL processes.
- Developed scripts to refresh development database with the most recent two years of production data.
- Supported developers in testing development database applications with real and most current data for better testing and prompt resolution of issues.
- Analyzed data models for relation between tables in the database for an optimized subset of production data.

**University of St. Thomas** , Minneapolis, MN        Jul 2012 – Oct 2012

**Software Developer, Graduate Assistant**

- Worked with and mentored by the Director of Technology of the College of Applied Professional Studies.
- Tested and validated applications to specifications and logged issues.
- Prepared test plans and cases for improved outcomes and results.
- Improved college's new website user satisfaction scores from 3.0/5.0 to 4.5/5.0 by resolving 75% of backlog issues.

**Computer Science Corporation** , Chennai, India        Jun 2008 – Dec 2010

**Techno-Functional Consultant / Software Engineer** (Jan 2009 – Dec 2010)

- Gathered and conducted high-level analysis of requirements and proposed functionality changes.
- Transitioned archive data from legacy VURV recruitment system (SQL server) to PeopleSoft HRMS. Generated project data reports and user-friendly PeopleSoft pages for recruiters. Recognized by client and senior leadership for completing one month ahead of schedule with limited resources.
- Provided proactive responses and resolutions for technical and functional tickets in advance of the service level agreement time raised by users.
- Volunteered and accepted bottom-line responsibilities and process initiatives to reduce ticket flow by implementing an analyzed bug fixture and migrating components to production.
- Interacted with global clients, onsite coordinators, and directors throughout the U.K., Germany, Japan, and Brazil to resolve functional and project issues and queries.
- Prepared mass inserts, updated statements, and supported data warehousing team in creating database views for needed information in the environment.

**Application Developer** (Jun 2008 – Jan 2009)

- Developed high-level design (HLD) and designed application prototype from requirements.
- Created applications and resolved issues with Java applications reported during system and user acceptance testing.
- Prepared test plans, migrated code to production with zero issues, and conducted unit tests.
- Deployed code from development environment to system testing environment.