SUMMARY

• Mine and analyze data from company databases to drive optimization and improvement of product development, marketing techniques and business strategies
• Extensive experience in Text Analytics, developing different Statistical Machine Learning, Data Mining solutionsto various business problems and generating data visualizations using R, Python.
• Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Data Validation, Source to Target mappings, SQL Joins, Data cleansing.
• Experienced inScrum PracticeslikeUser Stories, Story Slicing, Backlog Grooming, Release Planning, Sprint Planning, Sprint ReviewandSprint Retrospective
• Coding knowledge and experience with languages such asC++ and Java
• Experience with distributed data/computing tools: Map/Reduce, Hadoop, Hive, Spark, MySQL
• Knowledge of a variety of machine learning techniques (clustering, decision tree learning, artificial neural networks, etc.) and their real - world advantages/drawbacks
• Expert knowledge of SQL and Tableau for data analysisanddata visualization
• Experienced creating and using advanced machine learning algorithms and statistics: regression, simulation, scenario analysis, modeling, clustering, decision trees, neural networks
• Experience in foundational machine learning models and concepts: regression, random forest, boosting, and deep learning.
• Expert at giving Effective Presentations & Walkthroughsof Detailed Business Requirements, Use Cases & Technical DocumentsSystem Requirements Specifications (SRS) and Workflow Diagrams.
• Strong experience inMicrosoft Access, Forms, Reports, Microsoft Excel Pivot-Tables, Graphs, Charts.
• Experience in process modeling using UML, (Use Cases, Sequence Diagrams, Activity Diagrams, Class Diagrams and Data modeling)
• Highly motivated team player withexcellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities
• Developed various QlikView Data Models by extracting and using the data from various sources files DB2, Excel, Flat Files and Bigdata
• Handled importing data from various data sources, performed transformations using Hive, Map Reduce, and loaded data into HDFS
• Project Managementexperience includes Client Management, Customer Interaction, Scope Definition, Project Planning, Change Control, Integration & Release Management.

TECHNICAL SKILLS

Analysis / Methodologies: Agile Methodology, Scrum, Kanban, Waterfall Methodology

Microsoft Tools: Microsoft Project, MS Excel, MS PowerPoint (MS Office Suite) MS SharePoint

Reporting: MS Excel, Tableau, SSAS, Qlik View, Kipfolio, Trello, Gantt

Software Tools: SQL, Python, SQL, MATLAB, Hadoop, MapReduce, JavaScript, Jira, Confluence, SAP, Salesforce Integration, Salesforce Admin, DevRally

Statistical Tools: Time Series, regression models, splines, confidence intervals, principal component analysis and Dimensionality Reduction, bootstrapping

PROFESSIONAL EXPERIENCE

Confidential, Montvale, NJ

Sr. Data Analyst / Data Scientist

Responsibilities:

• Performed data exploration and analysis of Sales and Marketing data using R in each line of business by understanding their product performance in each of their core states
• Developed data mapping documentation to establish relationships between source and target tables including transformation processes using SQL
• Mine and analyze data from company databases to drive optimization and improvement of product development, marketing techniques and business strategies
• Developed dashboards using Power BI as per management requirement
• Involved with the sales team to drive sales, track marketing campaigns, lead generations and sales using Salesforce and monthly reports to management
• Performed Database and ETL development per new requirements as well as actively involved inimproving overall system performance by optimizing slow running/resource intensive queries.
• Thoroughly studied the requirements for the different process and suggested changes that could help the business improve or standardize reporting requirements and did suggested re-engineering to the flow.
• Was involved in the creation of test cases of reports and at a step level activity and validated with the step within the team before submitting for a sign-off to stakeholders and IT team
• Validated SQL queries to filter data for reporting and Performed Data mapping and report creating steps in MS Visio
• Analyzed data from 3rd party providers: Google Analytics, Site Catalyst, Coremetrics, Adwords, Crimson Hexagon, Facebook Insights
• Good knowledge of HadoopArchitecture and various components such as HDFS, JobTracker,TaskTracker, NameNode, DataNode, SecondaryNameNode, and MapReduce concepts
• Analyzed the data collected and process maps to determine the root causes and identify opportunities for new reporting parameters and eliminating duplication of work.
• Worked with IT managers to translate business needs into system requirements and made sure that technical team in offshore understands the requirements and went of calls every week for updates.
• Documented the entire reporting process and took final sign-off from all the business heads
• Participated in client meetings, teleconferences and video conferences to keep track of projectrequirements, commitments made and the delivery thereof

Environment: Python, R, SQL, Teradata, Trello, Hadoop, SAS, MS Project, MS Visio, MS Office, MySQL, SharePoint

Confidential, Montvale, NJ

Data Analyst / Business Analyst

Responsibilities:

• Understanding and implementation of text mining concepts, graph processing and semi structured andunstructured data processing. Used predictive modeling to increase and optimize customer experiences, revenue generation, ad targeting and other business outcomes
• Conducted meetings with business teams to on-board new scorecards on existing platform
• Expert at performing technical analysis and lead analysis of complex business systems to create logical requirements and functionality specifications needed to provide solutions to complex business problems and determine present and future business performance
• Performed data visualization with Tableau 10 and generate dashboards to present the findings.
• Determined customer satisfaction and help enhance customer experience using NLP.
• Assisted project managers on project planning, managing timelines and schedules to deliver timely results.
• Held strategic meetings with senior management to discuss how to accelerate project timelines.
• Involved extensively in all the phases of SDLC using Agile (SCRUM) methodology including identification of business needs and constraints, collecting requirements, working closely with developers and testers.
• Provided input and insight of project plan management and monitored progress against plan through Share point
• Assisted team with making appropriate commitments through story selection, task definition; drive sprint planning and estimation; Organize and facilitate project planning, daily stand-up meetings, reviews, retrospectives, sprint and release planning, demos and other Scrum-related meeting
• Responsible for project management documentation including project plans, meeting minutes and action items.
• Presented weekly status reports and presentations to the senior leadership team telling them about the progress of deliverables each week.

Environment: Jira, Confluence, Tableau, Qlickview, Trello, DevRally, MS Project, MS Visio, MS Office, MySQL, Rational ClearQuest, Rational Requisite Pro, SharePoint.

Confidential, Houston,TX

Data Scientist / Data Analyst

Responsibilities:

• Work on Text Analytics, NaïveBayes, Sentiment analysis, creating word clouds and retrieving data fromTwitter and other social networking platforms
• Implemented big data processing applications to collect, clean and normalization large volumes of opendata using Hadoop ecosystems such as PIG, HIVE, and HBase
• Integrate R into Micro Strategy to expose metrics determined by more sophisticated and detailed modelsthan natively available in the tool and communicated with users to build an understanding of the business process.
• Worked on different data formats such as JSON, XML and performed machinelearningalgorithms in
• Python and resolved customer issues and recommended solutions for improvement
• Created and presented weekly analysis report to management which helped in developing strategies for identifying the sales targets within the mortgage and financial industry
• CreatedDataQuality Scripts using SQL and Hive to validate successfuldataload and quality of thedata. Createdseveral types ofdatavisualizations usingPythonand Tableau
• Designed and developed analytics, machine learning models, and visualizations toprovide insights, from prototyping to production deployment and productrecommendation and allocation planning
• Focused on customer segmentation based on machine learning and statistical modeling effortincluding buildingpredictive models and generatesdataproducts to support customer segmentation
• Application of various machine learning algorithms and statistical modeling like decision trees, regression models, neural networks, SVM, clustering to identify Volume using package in Python
• Developed a pricing model for various product & services bundled offering to optimize and predict the gross margin

Environment: R/R studio, SAS, Python, Hive, Hadoop, MS Excel, MS SQL Server, Power BI, Tableau, T-SQL, ETL, MS Access, XML, JSON, MS

Confidential, Atlanta - GA

Business Systems Analyst

Responsibilities:

• Responsible for identifying stakeholders that own and work on the assigned applications.
• Responsible for conducting Kickoffs of the assigned applications into the Systems Retirement program.
• Responsible for gathering User and Business requirements through JAR sessions and Technical Elaboration Sessions after identifying the correct stakeholders related to assigned applications.
• Implemented Metadata Repository, Maintaining Data Quality, Data Cleanup procedures,
• Transformations, Data Standards, Data Governance program, Scripts, Stored Procedures, triggers and execution of test plans.
• Participated in walkthroughs and team meetings to discuss the issues arising out of requirement gathering or testing.
• Responsible for meeting tight deadlines and working through eminent issues to meet those deadlines.
• Responsible for submitting Change Request (CR) to change the status of an application on a program level
• Responsible for creating and understanding Visio diagrams to reflect the workflows and interdependence to other applications.
• Assist Project Managers in completing weekly Status Reports (CSRs) as well as creating project plans on MS Project.
• Worked closely with Database Analysts, Technical Analysts, Infrastructure Business Alignment Teams and Business Alignment Teams to gather database information and verify record and source codes to be archived or purged.

Environment: MS Visio, SharePoint, MS Word, MS Excel, MS PowerPoint, MS Project, MS Office Outlook, MS Office Calendar, Adobe Connect, Paint, SQL.

Confidential

Data Scientist / Data Analyst

Responsibilities:

• Planned and conducted the requirements gathering sessions with the business team to collect the business processes, security and service level requirements.
• Extracted, discussed, and refined business requirements during JAD sessions.
• Prepared various artifacts such as use cases, workflow diagrams, business process models, and functional requirement specifications (FRS) by interacting with end users, development personnel, project team and the subject matter experts.
• Prepared requirement traceability matrices and managed all components of the business requirements & UAT testing phase of the development lifecycle.
• Involved in preparing project plans and identifying the major milestones of the project.
• Assisted QA testing in formulating test plans, reviewed them for appropriate test coverage and managed the change request documentation.
• Effectively analyzed audience: Translated technical ideas into words that the intended audience would understand.
• Effectively managed the requirements and requirement change requests during various phases of the project life.
• Developed and maintained the issue/defect matrix and provided the status reports to senior management.
• Involved in the creation of Project status reports as well as requirement traceability matrices.