Data Analyst/data Scientist Resume
Columbus, OH
SUMMARY
- Delivery focused, dynamic, problem solver with 10 years of experience.
- Certified Machine Learning professional from Andrew Ng at Stanford.
- Expertise in Predictive Analytics, CNNs, deep learning and image classification.
- Passion for Data Analytics and Visualization with strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management, Data Governance, Data steward and Configuration Management
- Proven track record of achieving project milestones in technology and IT industry as Project Manager (Scrum Master), Sr. Consultant, Product Lead, Sr. System Engineer.
- Strong experience in Data Modeling with expertise in creating Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling.
- Proficient in Hadoop, Spark, Map-Reduce.
- Experience in programming for generating graphs, data listings and tables using data steps, procedures, SQL andSASmacros
- Primary experience in using Teradata utilities like SQL Assistant, BTEQ, MLOAD, FLOAD, TPUMP.
- Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.
- Proven track record in Agile Scrum and Waterfall SDLC methodologies.
- Managed executive level communications, identified KPIs, and created projec dashboards, reports, newsletters and project status updates for senior management and projects teams.
- Predictive Analytics, Time Series Analysis, Logistic, Multinomial Regression
- Data Cleansing, Data Analysis, data visualization, data modelling, data loading using stat tools, R and Excel
- ETL processing, Data Warehousing, Big Data, EMR, Amazon Redshift
- Forecast Model, Supervised, Unsupervised Machine Learning algorithms, Classification CNNs using Tensorflow, Python, Matlab
- Exceptional documentation and analytical skills, strong problem-solving skills
- Creating optimization model using Excel Solver and R.
TECHNICAL SKILLS
Business/Functional Experience: Financial Services & Products, Insurance, Banking, IT Consulting, Manufacturing
PM Tools and Methodologies: JIRA, MS Project, MS SharePoint, MS Office (Word, Excel, Visio, PowerPoint), PMBOK, PMI
Analytical & Visualization Tools: StatTool, Excel, R Studio, Python, XMLMiner, Risk Solver, Tableau (Proficient)
Databases: Oracle, DB2, NoSQL, RDMS, JSON
Domains: B2B e-Commerce, Web/Digital, Telematics, Cloud CRM (Salesforce), Organizational Change Management
Technical Skill Set: ETL (Informatica), VBA, Java, JSP, HTML5, XML, JMS, Mainframe, .NET Framework, PL/SQL, API Management, SOAP, RESTful API, SAML, OAUTH, Distributed Systems, Micro services, Web services
Version control: Git, SVN
Wireframe mockup tools: Balsamiq, Vector, Gimp
PROFESSIONAL EXPERIENCE
Confidential, Columbus, OH
Data Analyst/Data Scientist
Responsibilities:
- Created multidimensional dashboard using Chicago traffic dataset to recognize patterns in traffic snarls in Chicago using R Studio.
- Sliced and cleansed the data to run regressions and time series analysis for the traffic times and locations.
- Used plotly, maps, ggplot, dplyr and other packages in R to make heatmaps showcasing patterns.
- Worked on creation of Image Classification model using Transfer Learning and Python.
- Led the launch of a mobile application on iOS & Android platform.
- Drove product roadmap including PRDs for dashboard delivery.
- Effectively translated the requirements in PRD to Epics, User stories and tasks using Basecamp.
- Performed sprint planning for three features and a beta release.
- Conducted daily standups for tracking and resolving logistics, project management, and technical issues.
Confidential, Columbus, OH
Data Consultant
Responsibilities:
- Consultative engagement for implementation of reporting dashboard for $3.5m sales data for vendor assessment & relationship management.
- Used excel to import data from multiple sources and introduced authentication functionality and user roles in dashboard.
- Created different graphs and pareto charts for exceptional data visualizations.
- Attended multiple meetings with strategy team and business development reps to get and finalize BRDs
- Presented the demo for final project deliverables to CTO, CIO, EVP executives and reps from finance, sales departments
- Created product prototype for the excel spreadsheet based to get buy in for the different business use cases.
- Created excel macros to automate data porting from multiple sources
Confidential
PRODUCT ANALYST (SCRUM MASTER)
Responsibilities:
- Owned product delivery with a 13-member team for ~$4m business opportunity
- Designed a predictive modelling tool using excel for churn for the insurers (customers) in response to a marketing program.
- Analyzed data from two different insurance data bases to come up with batch report using SAS.
- Monitor story cards, epics, product backlogs, sprint report, burndown, and velocity charts for the ongoing projects in JIRA.
- Conducted interviews to on board a team of 8 data analysts at the client site.
- Managed multiple sprints for product delivery for clients in UK(capita), S.Africa (Liberty), BirlaSunlife (India) and ANZ (Australia)
- Performed status reviews, change requests, obtained required approvals to keep project in scope.
Confidential
Sr. CONSULTANT
Responsibilities:
- Initiated a $1.4m SGD cost reduction and performance improvement proposal with a working prototype impacting 2M users
- Led the team of 5 System Analysts and 8 Program Analysts to support project delivery in Central Payment Processing (CPP) department at CPF - Ministry of Manpower garnering a lot of media attention
- Developed the DW ETL scripts using BTEQ, Stored Procedures, Macros in Teradata
- Development of scripts for loading the data into the base tables of EDW using Fast Load, MultiLoad and BTEQ utilities of Teradata
- Led/Managed requirements gathering, Web Interface Design (Wireframes), development effort in file load/unload jobs, Content Development and complete testing - unit, system, integration, regression & UAT with detailed test plans, use cases, test scenarios and master test strategy
- Triage planning/prioritizing, PRDs and QA for UAT.
- Worked on transferring the data files to vendor through SFTP & FTP process.
- Managed the ETL process for database migration (zOS to Oracle DB).
Confidential, Kansas, MO
PRODUCT ENGINEER
Responsibilities:
- Minimized error rate by 90% in a new process capability and published the process to be used in a global delivery model.
- Coordinated between multiple vendors, defined KPIs for batch processes resulting in efficient reporting to multiple VPs.
- Created Performance tuning SPs for database loading jobs
- Resolved database Binding issues on day today basis while executing functional JOBs in Mainframe-Java architecture
- Onshore and offshore coordinator for data cycle processing team
- Provided daily reports on the batch systems cycles in multiple UAT/Dev/System test environments using data visualization.
- Take monthly calls from business stakeholders for external clients’ dependent on outputs from wMA system including VP level Executives from Cognizant, TCS and Infosys.
Confidential
Sr. SOFTWARE ENGINEER
Responsibilities:
- Led the enterprise data management project to provide Data/Information to all Enterprise Applications within Confidential .
- Performed the ETL process for database migration (zOS to Oracle DB) with zero defect implementation and 7/7 customer feedback
- Established a workable schedule, overcame client resource hurdles, and obtained full commitments from business executives.
- Ensured post-implementation operational efficiency and enhancement & production support.
- Identified and determined data dependency, schema, and models of the DB, communicated to the team.
- Managed team resources and handled request estimation, technical design, software development and client coordination for enterprise data changes.
- Mentored new team members through knowledge transition sessions; ensured mapping & updating of competencies for the team.
- Authored standard operating procedures, which decreased the turn-around resolution time by 30%.
- Enhanced middleware that reduced the cost of maintenance by 40%, resulting in a repeat business worth $2M.