Data Analyst Engineer

NAVEEN YERRAGUDI

Address: **** ********** ****** *****: **********@*****.***

Scarborough, ON – M1W1S8 Phone: 519-***-****

Profile Summary

Business Data Analyst with over 5 years of industry wide experience understanding of Business Requirement elicitation techniques, Business Requirements Gathering, Data Analysis and Business Process Modeling

Strong experience on Data analysis and Data profiling using complex SQL on various sources systems including Oracle and Teradata

Adept at preparing Business requirements documents (BRDs), Functional requirements documents(FRDs), defining project plans and delivering project reports

Lead and worked with teams to examine and solve business problems by accurately analyzing the needs of clients and helping them achieve improved quality and value for their customers.

In depth knowledge of RUP’s Iterative Software Development Life Cycle (SDLC) process, Agile Software Development and Waterfall models

Experience in writing complex SQL queries involving multiple tables, inner and outer joins, and stored procedures.

SAS certified programmer with strong experience in PC SAS and SAS EG involving - SAS/BASE, SAS/MACROS, SAS /SQL, SAS/Access

Experience in Extraction, Transforming and Loading (ETL), creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.

Proficient in developing advanced statistical models and data mining on high dimensional data in Python and SAS.

Expertized in discovering and applying insights from massive data sets of structured, semi-structured and unstructured data.

TECHNICAL SKILLS

Programming/ Scripting : SAS, C++, Python, R, SQL, MS Access, Shell

Data Analysis Tools : Tableau, PC SAS, SAS EG, HYPERION, IBM COGNOS, Teradata, Informatica, SQL server, PIG, MS Toad, Excel

Operating System : LINUX, MS Windows, MAC OS

Database/ Environment : SQL Server, IBM DB2, Oracle, HADOOP, APACHE SPARK

WORK EXPERIENCE

SICL America Inc

Aug 2018 – May 2019

EQUINIX, IT Business System Analyst

Worked in collaboration with shipment providers, Data Analytics teams and SMEs to operationalize API shipment model to predict customer list.

Data cleansed and manipulated data sets to gather insights, patterns and present findings in easy to complex format.

Drive meetings with Business, gather requirements, develop Functional Design Documents

Manage End to end life cycle of the project, conduct UAT, work cross functionally between multiple user groups and IT groups

Develop and implement new products and programs, business and information technology systems, procedures and organizational changes aimed to maximize profit, and reduce costs efficiently

Maintain dashboards for the Service group key performance indicators and provides quarterly status updates to the management team.

Furthering the capabilities of the company’s analytical and forecasting tools to meet users’ needs and enhance decision-making.

Automated tasks using Powershell/ UNIX shell scripts and work between multiple environments like Linux and Windows reducing turnaround time.

Open Systems Technologies

Feb 2018 – Jun 2018

CIGNA Healthcare, Business Data Analyst

Build proof of concept and Prototype by creating CPC box to setup hadoop cluster, Kerberos, Spark and Scala/Python for analytics needs

Automate tasks using Powershell/ UNIX shell scripts and work between multiple environments like Linux and Windows

Used Advance SAS/ Python programming for advanced analytics and reporting

Design tool using R Studio (R Shiny) to provide visualization of daily data loads and key parameters

Prototype and build scenario-based analysis on big data platforms for prospective needs and scalability

Write functional and non-functional requirements, actively participate in system design reviews, reviewing test evidence, and participating in status meetings

Reverse engineer existing reporting solutions in order to document technical requirements to support the migration of those tools to the new reporting platforms

Write the business and technical specifications and test the data to ensure data quality

Conduct requirement traceability to ensure that major requirements are addressed and that solutions are incorporated into the business and system workflow

Rang Technologies, Hartford

Apr 2016 – Jan 2018

CIGNA Healthcare, Business Data Analyst

Work across teams including CIMA ER, CIMA Analytics, and CIMA BE to deliver study specific reports, create Current and Future State Analysis

Performed Requirement Gathering & Analysis by actively soliciting, analyzing and negotiating customer requirements and prepared the requirements specification document

Prepare technical reports by collecting, analyzing, and summarizing information and trends

Identification of data elements needed for new reports, enhancements to existing reports, and appropriate data sources through data flow documentation

Document test scenarios, review test evidence and complete business acceptance testing

Schedule Ingestion jobs for daily/weekly upstream and downstream files from outreach program into Hadoop cluster using SAS

Convert and test current SAS jobs to Python 3.6 for efficiency and prospective use of available ML libraries

Assisted in developing analytic reports and dashboards using Tableau and self-service reports in COGNOS

Developed new or modified existing SAS programs to load data from the source and create random samples for Audit

Fusion Plus, Edison, NJ

Sep 2015 – Dec 2015

Business Analyst

Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.

Defined Key Performance Indicator metrics to create scorecards.

Involved in creating report models and applying row level security filters for report model.

Coordinated with front-end for implementing logic in stored procedures and functions.

Experienced in writing complex SQL Queries, Stored Procedures, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes

Created test cases and implemented SQL queries for QA testing and report / data validation

Data mapping of legacy systems to newer systems and testing data to analyze impact on current process

HCL Technologies, Chennai, India July 2011 – April 2013

Analyst, Member Technical staff

Value engineer the telecom product by identifying the parts that can developed cost effective and design new ideas for the parts.

Perform tolerance stack-up analysis of designed parts ensuring quality according to product requirement document of client.

Work with cross functional teams to understand design specifications, analysis, recommendations and product prototyping.

Prepare supporting documents and templates for design, cost evaluation and quality analysis.

Document changes and maintain effective communication with project teams across all departments to increase productivity

EDUCATION

Rutgers, The State University of New Jersey Dec 2015

Masters of Science in Mathematical finance

Vellore Institute of Technology University, India May 2011

Bachelors of Engineering

COURSEWORK

Data Mining, Numerical Analysis, Computational Finance, Time Series Analysis, Applied Mathematics, Programming Finance,

Econometrics

ACADEMIC PROJECTS AND CASE STUDIES

Comparison of Learning Algorithm Performance (R Studio, MS Excel) Aug 2015 – Dec 2015

Forecasting of Corporate Yield Curve (R Studio, SAS, MS Excel) Mar 2015 – May 2015

Comparison of numerical schemes in Pricing Finite Maturity European Style Put option (C++, MS Excel) Feb 2015 – May 2015

Contact this candidate