Python Developer

Sai Teja

Dallas, TX

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

Contact: 469-***-****

PROFESSIONAL SUMMARY

Around 7 years of experience as a Data Analyst, Data Science & Data Engineer Capable in all periods of the Software Development Lifecycle (SDLC).

Expert involvement in Data Modeling and Data Analysis as a Proficient in social event business prerequisites and taking care of necessities the board.

Experience with Statistical Analysis, Data Mining and Machine Learning Skills using R, Python and SQL.

Excellent capacity to comprehend business needs and information to create start to finish business arrangements.

Professional working experience in Machine Learning algorithms such as Linear Regression, Logistic Regression, Random Forests, Decision Trees, K-Means Clustering and Association Rules.

Experienced in structuring the Conceptual, Logical and Physical information displaying utilizing Erwin r7.3, Power Designer 12.0 and ER Studio Data displaying instruments.

Good in framework investigation, ER Dimensional Modeling, Database structure and executing RDBMS explicit highlights.

Experiences in Machine learning, data mining, structured and un-structured data analysis, and image data analysis, including feature extraction, pattern recognition, algorithm development, text mining, computer simulation, data modeling, databases design, model evaluation and deployment.

Data Driven and highly analytical with working knowledge and statistical model approaches and methodologies (Clustering, Regression analysis, Hypothesis testing, Decision trees, Machine learning), rules and ever evolving regulatory environment.

Proficient in recognizing Star Schema and SnowFlake Schema and ODS design for modeling Information stockroom in Relational, Dimensional and multidimensional model.

Strong Data Modeling background utilizing ER chart, Dimensional information demonstrating, Star Schema demonstrating, Snow-piece displaying utilizing apparatuses like Erwin, Visio.

Well versed in Forward and Reverse Engineering standards.

Experience with different RDBMS like Oracle 9i/10g/11g, SQL Server 2005/2008, DB2 UDB, Teradata.

Extensive involvement being developed of T-SQL, Oracle PL/SQL Scripts, Stored Procedures and Triggers for business rationale execution.

Experience in designing stunning visualizations using Tableausoftware and publishing and presenting dashboards, Storyline on web and desktop platforms.

Develop dashboards and reports that adhere to the visualization best practices and communicate a story

Competent communicator and confident presenter to report analytics findings to members of senior management.

Assisted in requirements definition, project scoping, timeline management, and results documentation to ensure professional relationship management

Creative in putting together projections for a variety of scenarios to assist departmental experts in making future decisions regarding the organization’s growth.

TECHNICAL SKILLS

Database: MySQL, Oracle, MariaDB, HeidiSQL, BigQuery

Methodology: Agile/ SCRUM framework, and Waterfall.

Analytics Technologies and Packages: Microsoft Excel (Lookup, Pivot, macros), RDBMS, HeidiSQL, Oracle Database, SQL Server, Google Analytics, R &Python

Data Visualization: Tableau, PowerBI, MS Excel

Certification: Project Management Certification Program (SDCE, Pursuing).

Statistical Skills: Data Analysis, Business Analysis, Agile methodology, Project Management, RP Implementation, Requirement Gathering & Machine Learning, SPSS

Tools: MS Word, MS PowerPoint, MS Project 2016, MS Visio, MS Excel, Google Analytics, Balsamiq, JIRA

PROFESSIONAL EXPERIENCE

CVS Health, Irving, TX Dec 2019 to Present

Senior Data Analyst/ Data Engineer

Roles and Responsibility

Extracted, manipulated and analysed health care and retail data using Teradata from multiple sources to derive and visualize actionable insights for decision making.

Conducted analysis to measure financial and clinical impacts and outcomes of programs and interventions using descriptive statistics, correlation tests, linear/logistic regression and ANOVA

Built dynamic dashboards using Tableau to track patient adherence and other user-centred metrics.

Created forecasts using ARIMA models to track performance of the Operations team for budget forecasting/variance analysis.

Designed summary data layers by integrating and manipulating data from disparate sources to support planned analyses, using SAS and SQL.

Tailored descriptive analytic solutions to the specific client needs and formulated recommendations to operations team based on findings

Gathered and analyzed business requirements, interacted with various business users, project leaders, developers and took part in identifying different data sources.

Involved with Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.

Generated new data mapping documentations and redefined the proper requirements in detail.

Performing the role of Tableau site admin for 3 of our sites.

Environment: Teradata SQL, SAS, Oracle SQL, T-SQL, Tableau, Python, Jira, Agile, TOAD, Sharepoint, Google Bigquery

Express Scripts, Franklin Lakes, NJ May 2019 to Dec 2019

Senior Data Analyst/ Data Engineer

Roles and Responsibility

Gathered and analyzed business requirements, interacted with various business users, project leaders, developers and also took part in identifying different data sources.

Involved with Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.

Generated new data mapping documentations and redefined the proper requirements in detail.

Involved with Data Analysis primarily Identifying Da ta Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.

Involved in creating charts and graphs of the data from different data sources by using Matplotlib and SciPy libraries in python.

Performed data imputation using Scikit-learn package in Python.

Visualizing the data with the help of box plots and scatter plots to understand the distribution of data using Tableau, Python libraries.

Involved in exhaustive documentation for technical phase of the project and training materials for all data management functions

Conducted major stakeholder interviews involving SME’s, Business Analysts and other stakeholders

Analyze customer data in Python using Matplotlib, Seaborn to track correlations in customer behavior, define user segments to implement process and product improvements.

Strong knowledge of statistical methods (regression, hypothesis testing, randomized experiment), data structures and data infrastructure.

Proficient in statistical Modeling techniques (Linear, and Logistics) in Forecasting/Predictive Analytics, Segmentation methodologies, Regression- based models, Hypothesis testing.

Identified and compiled common business terms for the new system that become central part of communication among project stakeholders to avoid ambiguity to determine the requirements.

Created action plans to track identified open issues and action items related to the project

Prepared analytical and status reports and updated the project plan as required

Environment: PowerPoint, MS Visio, MS Excel, MySQL, T-SQL, Tableau, Python, Jira, MS Access

Wipro Limited, India Dec 2015 to Jul 2018

Data Analyst/ Data Engineer

Roles and Responsibility

Performed preliminary data analysis on gathered data into organized form with data integrity checks, anomaly detection and feature engineering with Python and R libraries.

Created tableau visualizations and dashboards that helped upper management make informed decisions to monitor KPIs and growth of customer loyalty program.

Created dashboards in Tableau to identify trends and relationships in key metrics such as Sales Per Square foot and Retail Conversion Rate

Migrated 5 Private Banking Applications from Investment Bank to Wealth Management Americas. The components migrated are batch scripts, Autosys, SVN, Sybase database, Informatica.

Converted data into insights by predicting and modeling future outcomes.

Utilizing MS SQL, Tableau, and other dashboard tools for data intelligence and analysis.

Collected and analyzed data on established and prospective customers, competitors, and marketing channels and sources.

Prepared reports that interpret customer behavior, market opportunities and conditions, market results, trends, and investment level

Solved client's analytics problems and effectively communicating results and methodologies

Developed segmentation, propensity, and look-alike modeling of individuals across known, identified and anonymous audiences

Used Statistical techniques for hypothesis testing to validate the data.

Managed the planning and development of design and procedures for metric report.

Optimized data collection and procedure to generate reports weekly, monthly and on quarterly basis.

Used advanced MS excel to create Pivot table and Pivot reports.

Investigate and conduct studies on the forecasts and demand, and capital of products.

Worked with applications like R and Python to develop neural network algorithms, cluster analysis.

Environment: MS Excel, SQL, MS vision, MS PowerPoint, Tableau

Symbiosys Technologies, India Jun 2015 to Dec 2015

Data Analyst

Roles and Responsibility

Evaluated and preprocessed raw information to present and explain information in an accessible way (e.g. budgeting reports)

Teaming with all stakeholders to build 'as-is' and 'to-be' business process flow documentation using Microsoft Visio, as well as conduct gap/deficiency identification and analysis, including cross functional members

Worked on Requirement Traceability Matrix (RTM) for traceability of requirements

Worked in all phases of project life cycle and in different SDLC methodologies such as Waterfall and Agile.

HealthCare management experience in projects involving the customization, design, development, implementation, and testing of automated systems to support the Medical Management Information System (MMIS) as well as day-to-day business operations

Supporting all the documents with UML Diagrams such as Use Case Diagrams, Class Diagrams, Activity Diagrams, Data Flow Diagrams, Sequence Diagrams, Process Flows (Business and System) using UML modeling tools such as MS Visio and Rational Rose

Organized many Joint Application Development (JAD) sessions and Joint Requirement Planning sessions (JRP), walkthrough, Interviews, Workshops and Rapid Application Development (RAD) sessions with end-user/clients/stakeholders and the IT group

Developed reports interactive dashboards and internal procedures.

Supported multiple internal levels of management in the evaluation of initiatives.

Maximized effectiveness of analysis programming and reporting.

Prepared executive level presentations for management and clients.

Environment: MS Excel, SQL, MS Visio 8, MS PowerPoint, MS Office

EDUCATION

Master of Data Analytics, Bowling Green State University

Bachelor in Computer Science and Engineering, Andhra University, India

Contact this candidate