We provide IT Staff Augmentation Services!

Sr. Data Scientist/data Modeler Resume

3.00/5 (Submit Your Rating)

Reston, VA

SUMMARY:

  • Above 9+ years of experience as Data Scientist/Modeler wif experience in analyzing, cleaning, wrangling, coding, implementing, testing,and maintaining database solutions using Statistical solutions.
  • Experienced in employing R Programming, MATLAB, SAS, Tableau and SQL fordata cleaning,datavisualization, risk analysis and predictive analytics
  • Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards, Storyline on web and desktop platforms.
  • Good Knowledge of Big Data technologies like MapReduce, Hadoop, Spark, etc.
  • Experienced wif command - line scripting, data structures and algorithms.
  • Experienced in a data-driven environment, Leveraging analytics and large amounts of (streaming) data to drive significant business impact.
  • Worked on End to End Data Mining/Machine Learning Project Life Cycle.
  • Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards, Storyline on web and desktop platforms.
  • Worked on Statistical / Machine Learning Model building and Validation using Decision Tree, Linear & Logistic Regression, Support Vector Machine algorithms.
  • Worked on cross-functionally and support ad-hoc analysis to give a more structured shape, examine recent and historical data, identify salient trends, develop statistical models, and surface key insights
  • Experienced in Synthesize diverse, complex information to develop a compelling story wif data and insights
  • Gathering user requirements, preparing and analyzing Business Requirement Documents (BRD) System Requirement Specification.
  • Experienced in Statistical Analysis environments such as R, Python, MATLAB, SPSS or SAS and comfortable wif relational and non-relational databases
  • Experienced wif most of software deployments methodologies like Water Fall, Iteration, Agile and Rapid Application Development (RAD).
  • Good understanding of Teradata SQL Assistant, Teradata Administrator anddataload/ export utilities like BTEQ, Fast Load, Multi Load, Fast Export.
  • Worked and extracteddatafrom various database sources like Oracle, SQL Server, DB2, and Teradata.
  • Skilled in System Analysis, E-R/DimensionalDataModeling, Database Design and implementing RDBMS specific features.
  • Extensive experience on business intelligence tools such as OLAP,Data warehousing, reporting and querying tools,Datamining.
  • Experience working wifdatamodeling tools like Erwin, Power Designer and ER Studio.
  • Experienced in Ability to understand a problem statement and implement analytical solutions & techniques independently
  • Expertise in UML as a business analysis methodology for application functionality designs using Rational Rose and MS-Visio.
  • Self-Motivated wif Excellent communication skills wif a strong focus on Client oriented service and ability to work excellently as an individual and as part of a team wif minimum amount of supervision.

TECHNICAL SKILLS:

DataModeling Tools: Erwin, Rational Rose and MS Visio

Database: Oracle 12c/11g, MS Access 2010/2007, SQL Server 2016/2015, Sybase and DB2, Teradata 15/14, Hive

Big Data Tools: Hadoop, Hive, Spark, Pig, HBase, Sqoop, Flume

BI Tools: Tableau 7.0/8.2, Tableau server 8.2, Tableau Reader 8.1,SAP Business Objects, Crystal Reports

Packages: Microsoft Office 2010, Microsoft Project 2010, SAP and Microsoft Visio, Share point Portal Server

Operating Systems: Windows 8/7/XP and UNIX.

Languages: SQL, PL/SQL, ASP, Visual Basic, XML, Python, SQL, T-SQL, SQL Server, C, C++, JAVA, HTML, UNIX shell scripting, PERL, R

Applications: Toad for Oracle, Oracle SQL Developer, MS Word, MS Exce

lMS Power Point, Teradata, Designer 6i:

Methodologies: RAD, JAD, RUP, UML, System Development Life Cycle (SDLC), Waterfall Model

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Sr. Data Scientist/Data Modeler

Responsibilities

  • Build predictive models, behavioral cohorts, funnel analysis, and interactive dashboards to gain insights on what was driving performance in terms of reach, retention, and revenue growth
  • Delivered numerous POCs dat empowered network analysis, D3.js, different GraphDBs, and MongoDB
  • Applied advanced machine learning algorithms including PCA, K-nearest neighbors, random forest, gradient boosting, neural network and xgboost to predict weights and labels of Higgs Boson wif high accuracy
  • PerformedDataAnalysis andDataProfiling using complex SQL queries on various sources systems including Oracle, Teradata.
  • Developed Python modules for machine learning & predictive analytics in Hadoop on AWS.
  • Developed spark streaming jobs using MLlib and deployed it as a PNDA app working along teh DevOps team.
  • Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
  • Designed tables and implemented teh naming conventions for Logical and PhysicalDataModels in Erwin r9.6
  • Used Reverse Engineering and Forward Engineering techniques on databases and created tables and models indatamart,datawarehouse and staging.
  • Created Mappings/workflows to extractdatafrom Excel file other databases and flat file sources and load into various Business Entities.
  • DevelopedDataMapping,DataGovernance, Transformation and cleansing rules for teh MasterData Management Architecture involving OLTP, ODS.
  • Involved in SQL queries and optimizing teh queries in Oracle10g, and Teradata.
  • Deep knowledge on collaborative filtering approach.
  • Worked Normalization and De-normalization concepts and design methodologies like Ralph Kimball and Bill Inmon approaches.
  • Documented Source to Target mappings as per teh business rules.
  • Involvement in enterprise architecture for POC's like bigdataanalytics.
  • Successfully optimized codes in Python to solve a variety of purposes indatamining and machine learning in Python.
  • Text Mining Packages under Python Programming to understand teh frequent words for each categorical rating.
  • Data Visualization using TABLEAU, ggplot2 package in Python.
  • Delivereddatascience solution for a geo Location enrichment of socialdatavia API
  • Updated Python scripts to match training data wif our database stored in AWS Cloud Search, so dat we would be able to assign

Environment: Python 3.5.2, Tableau 8.x, Erwin 9.6, Oracle 12c, Teradata 15, MDM, SAS, NLTK, SVM (Support Vector Machine), JSON, XML, MapReduce, Spark, MLlib

Confidential, Dallas, TX

Sr. Data Scientist/Data Modeler

Responsibilities

  • Designed predictive models using teh machine learning platform -H2O, Flow UI.
  • Visualized, summarized and analyzed predictions by a web interactive shiny application
  • Utilized web scraping wif R to extract information.
  • Built a K-means clustering model to investigate teh underlying factors dat effect medal standings
  • Set up Amazon AWS EC2 virtual server instances to connect AWS Redshift Database to R Studio and Shiny Server
  • Creating procedure for updating thedatafrom factory systems, through Oracle PL/SQL.
  • Worked on MasterdataManagement (MDM) Hub and interacted wif multiple stakeholders.
  • Creating and ensuring teh feasibility of teh logical and physical design models using Erwin 9.5
  • Helped developers and brand advertisers pursue data-driven marketing efforts which are relevant to their users and catered to their preferences
  • Contributed to teh team's research efforts in creating standard modeling data sets and comparing different modeling frameworks.
  • Built and fine-tuned predictive models to optimize lift in conversions using third-party digital attribution data.
  • Developed ETL processes, including stored procedures, SSIS packages, and SQL Server jobs
  • Designed and tested Predictive Algorithms using Historical Data
  • Utilized machine learning algorithms such as linear regression, multivariate regression, naive bayes, Random Forests, K-means, & KNN for data analysis.
  • As a supplementary part ofdatareview board, interacted wif teh multiple customers for teh true source of thedataand its profiling.
  • Pioneered modeling methods to connect multiple data sources together (eg. purchase and click stream data).
  • Used teh Agile Scrum methodology to build teh different phases of Software development life cycle.
  • Involved in database development by creating Oracle PL/SQL Functions, Procedures and Collections.
  • Performed SAP Data Migration by using Business Objects Data Services as teh ETL tool.
  • Gatheird and analyzed existing physical data models for in scope applications and proposed teh changes to teh data models according to teh requirements.
  • Built a webpage used by clients' creative teams to display global entertainment and consumer trends using D3 to inspire and inform advertising content.
  • Cross-trained members of other teams in SQL/R and in producing various audience profiling-related outputs.

Environment: R3.3, Erwin 9.5, PL/SQL, Tableau 8.0, Oracle 11g, SAP, HADOOP (HDFS), PIG, MYSQL, R Studio, MAHOUT, JAVA, HIVE.

Confidential - Windsor, CT

Sr. Data Architect/ Data Modeler

Responsibilities

  • Used Erwin and Normalization and De-normalization Techniques to design Logical and Physical Data Models, relational database design.
  • Involved in developing Database Design Document including data model Conceptual, Logical and Physical Models using Erwin 9.
  • Designed and implemented complex highly scalable statistical models and solutions dat comply wif security requirements
  • Design of BigDataplatform technology architecture. Teh scope includesdataintake, datastaging , datawarehousing, and high performance analytics environment.
  • Established data architecture strategy, best practices, standards, and roadmaps.
  • Involved in relational and dimensional Data Modeling for creating Logical and Physical design of teh database and ER diagrams using data modeling like Erwin.
  • Developed various QlikView Data Models by extracting and using teh data from various sources files, Excel, and Big data, Flat Files.
  • Involved in OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports using multi-dimensional models such as Star Schemas and Snowflake Schema
  • Involved in Teradata utilities (BTEQ, Fast Load, Fast Export, Multiload, and Tpump) in both Windows and Mainframe platforms.
  • Involved in designing teh data warehouse using Ralph Kimball's and Bill Inmon techniques.
  • Working on forward and reverse engineering teh DDL for teh DB2 and Teradata environments.
  • Worked in generating and documenting Metadata while designing OLTP and OLAP systems environment.
  • Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from Teradata database.
  • Designed both 3NF data models for ODS, OLTP systems and dimensional data models using Star and Snow flake Schemas.
  • Worked wif BTEQ to submit SQL statements, import and export data, and generate reports in Teradata.
  • Ability to document activities and communicate wif Data Architects as to status of Physical Data Modeling activities.

Environment: Erwin r7.5, DB2, Hadoop,, ODS, SQL Assistant, MS Visio, Spark,, UNIX, Flat files, ETL, PL/SQL, Metadata, OLAP, OLTP

Confidential - Dover, NH

Sr. Data Analyst/Data Modeler

Responsibilities

  • Involved wif Teradata utilities like Fastload, BTEQ, Multiload and Teradata SQL Assistant.
  • Create Conceptual, Logical and Physical datamodels and maintain teh model versions in Model Manager using Erwin for further enhancements.
  • Developed PL/SQL scripts to validate and loaddatainto interface tablesInvolved in maintainingdataintegrity between Oracle and SQL databases
  • Developed a Conceptual model using Erwin based on requirements analysis.
  • Used forward engineering to generate DDL from teh PhysicalDataModel and handed it to teh DBA
  • Designed STAR schema for teh detaileddatamarts and plandatamarts consisting of confirmed dimensions.
  • Exhaustively collected business and technical Metadata.
  • Developed thedatawarehouse model wif multipledatamarts wif conformed dimensions for teh proposed central model of teh Project.
  • Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in teh form of Entity Relationships and elicit more information.
  • Extensively used MS Access to pull thedatafrom variousdatabases and integrate thedata.
  • Designed teh Logical Model into Dimensional Model using Star Schema and Snowflake Schema.
  • Worked wif Excel Pivot tables.
  • Used Erwin for creating tables using Forward Engineering
  • Analyzed thedatafrom teh sources, designed thedatamodels and tan generated scripts to create necessary tables and corresponding records for DBAs using Informatica.
  • Comprehensive knowledge and experience in process improvement, normalization/denormalization,dataextraction,datacleansing,datamanipulation
  • Created, documented and maintained logical and physical database models in compliance wif enterprise standards and maintained corporate Metadata definitions for enterprisedatastores wifin a Metadata repository.

Environment: Erwin R7.0, MS Visio, Oracle 11g, Oracle Designer, Teradata, Oracle SQL developer 2008, PL/SQL, Flat

Confidential

Data Analyst/Data Modeler

Responsibilities:

  • Gatheird and translated business requirements, worked wif teh BusinessAnalystand DBA for requirements gathering, business analysis, and testing and project coordination.
  • Interacted wif business users to clarify on business logic required for thedatamodels.
  • Used reverse engineering for a wide variety of relational DBMS, including MS Access and Teradata to connect to existing database.
  • Generated DDL (Data Definition Language) scripts using Erwin and supported teh DBA in Physical Implementation of data Models.
  • Designeddatamodel, analyzeddatafor online transactional processing (OLTP) and Online Analytical Processing (OLAP) systems
  • Used Sybase Power Designer in designing thedatamodel.
  • Cleansed, extracted and analyzed businessdataon daily basis and prepared ad-hoc analytical reports using Excel and T-SQL
  • Analyzed OLTP source systems and OperationalDataStore and research teh tables/entities required for teh project.
  • Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio
  • Tuning all database via indexing of tables, MS SQL Server 2005 configuration parameters and stored procedures SQL code optimization.
  • Developed PL/SQL packages, stored procedures, functions, alerts for ensuring teh warehousedata integrity checks and shell scripts to balance thedatabetween source and target tables after each ETL process
  • CreatedDataMigration and Cleansing rules for teh Integration Architecture (OLTP, ODS, DW).
  • Experience working in a formal Software Development, agile environment
  • Handled performance requirements for databases in OLTP and OLAP models.
  • Hands on experience using query tools like SQL Developer, PL/SQL developer, Teradata SQL Assistant.
  • Conducted meetings wif business and development teams fordatavalidation and end-to-enddata mapping.

Environment: Sybase Power Designer, Teradata, SQL Server 2005, OOD, OLAP, OLTP, ODS,, PL/SQL, XML, Visio, ClearQuest.

We'd love your feedback!