Sr. Data Scientist/data Modeler Resume
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.
