PROFESSIONAL PROFILE

Experience Application Systems Analyst with 5+ years of industry experience in IT product development and management by identifying business needs, and determining solutions to business problems for complex software projects including system development, business process improvement in Government, Retail (Starbucks) and E-Commerce sectors.

Extensive experience with full Software Development Life Cycle (SDLC) and project life cycle including Feasibility Analysis, Requirements planning and Management, Application Design and Development, Testing, Implementation and Post-Implementation Validation, and Solution Assessment. Documenting and creating Test Plans, Test Objectives and Test Cases. Also involved in maintaining Test Matrix and Traceability Matrix.

Experience with emerging technologies like neural network-based Machine Learning methods to create Artificially Intelligent (AI) algorithms for Cognitive and Predictive Analytics.

Experience with various methodologies such as Waterfall methodology, Agile and Joint Application Design (JAD).

Strong experience in Data Analysis, Data Mapping, Data Validation and documenting business and technical metadata.

Expertise in writing complex SQL queries DDL and DML and test scripts for data validation, backend testing, data profiling and data analysis.

Experienced in creating views and stored procedures to automate processes.

Good understanding of Microsoft Azure SQL server database, Azure pipelines, Triggers.

Experienced in creating reports using RDLC using Visual Studio and SSRS.

Good experience with migrating from legacy Access to SQL Server.

Experienced in business writing skills and technical writing skills in developing Business Case, Scope Document, Business Requirements Document (BRD), Functional Requirements Document (FRD), Non Functional Requirements Documents (NFRD), Use Case Scenarios, Test Plans, Test Cases, AS-IS and TO-BE workflows.

Extensive experience with Business Process Modeling (BPM).

Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, and Presentation Skills.

Excellent analytical and problem solving skills with focus on WHY of the problem. Adept at identifying true business needs.

TECHNICAL SKILLS

Operating Systems

Windows (7,8,10,2000, XP)

Programming Languages

C, C++, C# (.Net, MVC), SQL, JavaScript, HTML, XML

Software’s

Visual Studio, MS Office, SSMS, MS Access

Web Technology

HTML 4.0/5.0, CSS, XML, Java Script, jQuery

Data Modelling Tools

Visio 2010 / Visio 2013, Lucid chart

Reporting Tools

RDLC, SSRS, MS Access, Tableau

Other Tools

Jira, Cherwell, Team Foundation Server

WORK EXPERIENCE

West Advanced Technologies, Inc.

Client: California Department of Public Health, Sacramento CA Feb 2018 – Till Date

Role: SQL Server Systems Analyst

Worked for Food and Drug Branch, Radiological Health Branch and Accounting Branch customers of California Department of Public Health. Key role player in helping California Department of public health labor module to GO- Live with Fi$Cal. Worked on upgrading legacy systems into SQL server and upgrading legacy systems to Access 2016 and higher versions. Also, worked on upgrading FDB Licensing application to web application and created reports using RDLC tool and SSRS.

Responsibilities:

Supports Fi$Cal, Food and Drug Branch and Radiological Health Branch databases divisions of CDPH and assist section chiefs.

Conduct interview sessions with stakeholders and Subject Matter Experts (SMEs) to understand current business practice and their interactions with the current system.

Analyze real business problem and provide solution to support their requirements and recommend software upgrades for users existing applications as per their new requests to support CDPH Business.

Traced Project progress using Team Foundation Server. Created User stories, bugs, added estimates to incidents in production and new development and generate project progress report from TFS.

Documented FDB database application systems business process and technical documentation and training manuals for CDPH customers and new hires.

Worked on moving data from legacy MS Access databases .accdb and .mdb to SQL Server 2017.

Created SQL scripts to clean data from existing database applications.

Import flat files into SQL server and update existing live production data.

Worked on Public Request Act Statistic Reports for State of California Governor’s office.

Worked on creating reports using RDLC tool in Visual studio and SSRS.

Analyzed PRA Annual requests created by customers in the past and created views and stored procedures to capture data for the users.

Worked with server team and users and documented standard procedure to launch FDB Applications using Xenapps.

Create data dictionaries that specify data input/output formats; present the data dictionary to Project Tech Lead for approval.

Develop, test, and implement a secure multi-user friendly data entry and data acquisition environment using MS Access VBA, MS EXCEL for Applications and SQL for the Accounting division of California Department of Public Health.

Create reports and ad-hoc queries as per users request for the Accounting division of CDPH.

Maintain constant direct communication with accounting chief officer, managers, and Administrative accounting analyst in-person, phone, email, and scheduled meetings to determine the specific needs of the database.

Automation of macros and modules, for data extraction and reports.

Import/Export of data from various sources in various formats, creating stored procedures, triggers, and conditional formatting while migrating MS Access backend to SQL Server.

Set up user roles for users to secure confidential information about employees.

Designed testing specifications and user manuals. Document every aspect of system as a reference for future maintenance and upgrades.

Resolve data, technical, user error issues under extremely tight deadlines and critical circumstances.

Used Cherwell Tool to accomplish sprint work and defect tracking.

Loyalty Methods INC Jan 2016 – Jan 2018

Client: Southwest Airlines and Starbucks, Dallas TX

Role: SQL Reporting Data Analyst

Perform product development for client Starbucks’ rewards management system. Integrate and build Starbucks’ POS systems with the existing mobile apps for iOS and Android platforms. Provide metrics to Starbucks to improve on Net Promoter Score (NPS). Additionally, work on a pilot project on Machine Learning by assisting in creating business and system rules for the neural network to learn and predict customer shopping and purchasing trends to promote long term loyalty for customers. Implement gains from this project for all Loyalty Methods clients (including Southwest Airlines and others)

Responsibilities:

Create Sprint backlog and prioritize product features by working with the Product Owner.

Create and document end to end functional design for the rewards functionality by working with IT partners.

Create User Stories, Acceptance Criteria and Product Vision documents.

Work with development and QA to rapidly iterate new functionalities.

Facilitate JAD/Scrum sessions to come up with technical solutions for sprint backlog at hand.

Work with BI and IT development to come up with database design to store and retrieve data for the rewards program.

Design develop and implementing SSRS reporting for Business Intelligence and Operational Reporting for the enterprise.

Maintain internal SSRS dashboard reports for immediate management, business analysts and direct clients.

Monitor batch jobs deployed using SSIS.

Work as a part of Database Management team to ensure data security and best practice adherence for all corporate data.

Provide product demonstrations to client (Starbucks).

Assist Starbucks in UAT.

Assist in establishing deep learning Neural Network by creating business and system rules to enable machine learning algorithms to create Artificially Intelligent (AI) Predictive/Cognitive Analytics based engine.

Own the product from end to end. Take responsibility and champion client cause in IT group.

Create AS IS – TO BE (Current State and Future State) business and functional use cases and process flows.

Develop Test Plans to assist QA and UAT teams in testing the functionality.

Apprise executive leadership on project progress and conduct user walk through of the system functionality.

Work independently to manage, prioritize, and respond to changing deadlines.

Virtusa Consulting, Hyderabad, India Dec 2014 – Aug 2016

Role: Jr. Data Analyst

Worked on Analysis, Design, Implementation and Support of E-commerce workflow for JUSTDIAL company.

Responsibilities:

Acted as a liaison between technology and business users.

Analyzed current business process of organization and came up with prototypes to get approvals from client.

Created Use-Cases after accessing scope of the project and understanding the business processes

Designed use cases and sequence diagrams using Rational Rose.

Prepared use case documents and utilized MS Visio to create UML diagrams including use case, activity, and class diagrams to extract business process flows and workflows, thereby assisting development and quality assurance teams in understanding the requirements

Developed data flow diagrams, illustrating the flow of data from the Legacy systems into the Application Database Tables, along with checkpoints for testing / verification.

Created requirements analysis and design phase artifacts using Team Foundation Server.

Worked on writing SQL queries to refactor legacy queries to meet new business requirements.

Create batch jobs using windows task scheduler.

Create metrics using Tableau to generate NPS for business users.

Create views and stored procedures to automate business processes.

Created queries and reports to analyze the customers' data based on the various criteria for business management.

QUALIFICATIONS

University of Central Missouri, Warrensburg, MO

Jawaharlal Nehru Technological University, Hyderabad, India

CERTIFICATIONS

Agile at Work: Planning with User Stories by Project Management Institute

Agile Project Management Foundations by Project Management Institute

Microsoft SQL Server 2016 Certification (70-761) by Udemy

SQL SERVER MICROSOFT DATABASE SSRS SSMS RDLC REPORTING

Contact this candidate