SUMMARY

• Experience using Excel (functions, pivot tables, KPI, macros etc.) to create and analyze customer needs models. Proficient in utilizing MySQL, R and Python to design and implement database schema.
• High level of expertise working with Data Warehouses, with understanding in Data Mining, Data Integration and Migration, ETL tools and creating Data Dictionary.
• Expert in writing SQL and PL/SQL queries and R scripts to manipulate data and conduct datatensive knowledge and experience in MS Excel for data extraction and manipulation to evaluate programs, analyzing trends and history in order to provide the team with business insights and findings. Support the team with ad hoc analyses and other operational.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Extensive experience in MS SQL Server 2014/2012 BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Adept and deep understanding of Python2.7 with Numpy, Pandas, Scipy, Scikit - Learn, matplotlib.
• Experiencedatamining techniques using R like clustering, market basket analysis, and PCA.
• Experience in Agile work environment; with knowledge of methodology and tools.
• Abundant background in performing business analysis like Customer behavior, Marketing Campaign, Risk Management, Project Planning, Unsecured Loan and E-business.
• Extensive experience in Text Analytics, generating data visualizations usingR,Pythonand creating dashboards using tools likeTableau.
• Extensive experience inData Visualizationincluding producing tables, graphs, listings using various procedures and tools such asTableau, Power BI.
• Rich experience in Marketing Research and Business Analytics through data mining, optimization, and decision tree etc.
• Able to convey detailed financial and technology reports to a variety of skill levels. Talent for quickly learning new information, procedures, and technologies. Exceptionally organized and able to multitask.
• Highly motivated, organized with excellent analytical and communication skills in establishing effective task priorities as a team player with result oriented attitude.
• Sufficient skills in Data Processing, Data Management, Data Quality, Data Modeling and Data Analyze.
• Data Mining and Modeling: Collected, cleansed and provided modeling and analyses of structured and structured data used for major business initiatives.
• Dashboards: Created visually impactful dashboards in Excel for data reporting by using Pivot Tables and VLOOKUP.
• Good industry knowledge, analytical & problem solving skills and ability to work well within a team as well as an individual.
• Highly creative, innovative, committed, intellectually curious, business savvy with good communication and interpersonal skills.

CORE TECHNOLOGIES:

Environments: Windows, Mac OSX

Software: MS Office (Word, Excel, Outlook, PowerPoint, Visio), Tableau, R Studio, Power BI, ERP Software, CRM Systems, SQL, Power BI, SPSS, Python(Numpy, Pandas, Matplotlib, Seaborn, Scikit-learn)Tools: SQL Server, R, Google Analytics, Salesforce

PROFESSIONAL EXPERIENCE

Confidential, NYC, New York

Senior Data Analyst

Technologies: Python, Excel, SQL Database, MS Visio, Tableau

Responsibilities:

• Utilized Python and Excel to collect and analyze economic data sets to pinpoint critical market trends; apply that information towards progressive investment plans.
• Use Numpy in Python for Numerical analysis.
• UsedPythonfor creating graphics, data exchange and business logic implementation.
• Assisted in creating and presenting informational reports for management based on SQL data.
• Application of various machine learning algorithms and statistical modeling likedecision trees, regression models, SVM, clusteringto identify Volume using scikit-learnpackage inpython.
• Used clustering techniqueK-Meansto identify outliers and to classify unlabeled data.
• Designed process maps and created detailed risk aggregation and data lineage reports for top management.
• Created Requirements Traceability Matrix to ensure all requirements defined in system are tested.
• Created views inTableauDesktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Designed and supported in Test cases, test plan creation and companion guide from development stage to production. Identified productivity and quality control improvements.
• Performed Data Cleaning usingpandasandnumpy packages inpython.
• Interacted with Business and change management teams for better understanding of the requirements
• Organized weekly Project Status and Task Review meetings, used Tableau to create PowerPoint presentations and project updates using MS Project for management review.
• Communicated with Data Quality Analysis (QA) and prepared a detailed Data Coverage document which identified the gaps in data and requirements.

Confidential, New York, NY

Data Analytics/ Python Developer

Technologies: Python, SQL Database, R programming, Tableau, Excel

Responsibilities:

• Identified the key business Metrics and determined business needs to document the business, functional and data requirements.
• Building Dashboards around early member behavior, outlining key KPIs around Engagement, Usage Churn, Behavioral Churn, content consumption breadth and depth, device usage and feature usage.
• Utilize Python, Excel VBA to examine and analyze detailed test data, develop tools, ensuring successful integration ofnew modeling system
• Designed and implemented database schema on MySQL to account for data assertion.
• Communicating with clients to understand and document the business objectives
• Created independent libraries inPythonwhich can be used by multiple projects which have common functionalities.
• Installed numerouspythonpackages using pip and easy install.
• Use SQL to access different database, and pull different dataset from various conditions
• Use Python packages such as Pandas, Numpy, Seaborn to analyze customer’s purchase behavior.
• Analyze data across multiple segments and provide strategic recommendations based on the project objectives including trends, alumni/member engagement, campaign performance, marketing mix informed by the data
• Responsible for the proper documentation and validation of programs/macros/procedures to produce the standardized data displays.
• Designed extensive dashboards, process map and created detailed reports about accounts, payment history, FICO scores and debt burden for the top management using Business Objects.

Confidential, Jersey City, NJ

Data Analyst/Data Modeler

Technologies: Python, CA Erwin 7.0, VISIO, MS-Office, SQL Architect, SharePoint

Responsibilities:

• Interact with Business System Analysts and Software Developers to transform business requirements and application requirements into appropriate data model solutions
• Create and maintain database models and scripts that create, modify or delete database objects.
• Actively involved in creating Physical and Logical models using Erwin.
• Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Synonyms, Database triggers, Stored Procedures) in thedatamodel.
• Validated and updated the appropriate Logical Data Models to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change.
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle and Teradata as per business requirements using Erwin.
• Created SQL tables with referential integrity and developed queries using Pl/SQL Developer.
• Involved withDataProfiling activities for new sources before creating new subject areas in warehouse.
• Involved in testing the database for queries that were generated and handled the performance issues effectively.
• Prepared High Level Logical Data Models and BRD's (Business Requirement Documents)
• Performed analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.
• Coordinated with DBA on data base build and table normalizations and de-normalizations

Confidential, Pine Brook, New Jersey

Data Analyst

Technologies: Python, Excel, SQL Database, Tableau, CRM

Responsibilities:

• Coordinate with Sales Operations and Finance in planning, executing and delivering account hierarchies that meet the team’s yearly goals of completeness and accuracy.
• Collect data on consumers, competitors and market place and consolidate information into actionable items, reports and presentations.
• Involved in using Excel and Python to analyze large datasets in which to translate into reports for insight and recommendations for the Sales Team.
• Assist the marketing team in build out of Google Analytics with integrations around publishers, spend, and data warehouse data.
• Works closely with the IT team and outside technology companies to enhance CRM database and troubleshoot problems; supports new technological integration projects.
• Run SQL queries and output result set to Excel for various analyses.
• Utilized standardPythonmodules such as csv for development.
• Manage technical aspects of key marketing systems (marketing automation, CRM) used to generate, distribute, and report on leads and customers.
• Try to normalize the data in SQL to remove redundant data and ensure data dependent.
• Analysis includes data quality, company structures and business, metrics reporting and data enrichment. Make decisions based on data review and/or web research and company policies.
• Create and maintain key metric reports on marketing and sales activities to assess effectiveness and business impact.
• Assist the report/visualization developers and statistical modelers in filtering, tagging, joining, parsing, and normalizing data sets for use in reports & analytical models.
• Support customer hierarchy data management team with review, validation, and build activities to support global Sales organization.
• Use Tableau to make visual report to make the engineering and marketing team more easy to understand.

Confidential

Market Data Analyst

Technologies: SQL Database, Tableau, Excel, VBA, Python, Visio

Responsibilities:

• Acquire, update, maintain and process financial data using various internal systems and proprietary company software.
• Participate in time-sensitive projects, and collaborate with our global colleagues to deliver new initiatives.
• Partner closely with internal departments such as Sales, Analytics, News and Engineering
• Worked closely with stakeholders to determine the priority of specific requirements based on their value to the business.
• Designed and implemented database schema on MS SQL Platform using Visio tools.
• Use SQL to access different database, and pull different dataset from various conditions.
• Created various types of data visualizations usingPythonandTableau.
• Monitoring and tracking process performance using analytics tools likeTableaudashboard.
• Used Expert level understanding of different databases in combinations forDataextraction and loading, joiningdataextracted from different databases and loading to a specific database.