We provide IT Staff Augmentation Services!

Sr. Data Scientist/data Architect Resume

Nyc, NY

SUMMARY:

  • Over 8 + years of IT experience as Data Scientist, Data Architect, Data Modeler &Data Analyst in the Architecture, Design and Development.
  • Experienced in developing machine learning models for real - world problems usingR and python
  • Experience in use of statistical analysis environments such as MATLAB, SPSS or SASand comfortable with relational and non-relational databases
  • Excellent understanding of machine learning techniques and algorithms, such as k-NN, Naive Bayes, SVM, Decision Forests, etc.
  • Experience with command-line scripting, data structures and algorithms.
  • Solid Understanding of big data technologies like Hadoop, Spark, MapReduce, Pigand Hive
  • Experience with machine learning tools and libraries such as Scikit-learn, R, Sparkand Weka
  • Experience working with large, real world data big, messy, incomplete, full of errors
  • Hands-on experience with NLP, mining of structured, semi-structured, and unstructured data
  • Expertise in Database Performance Tuning using Oracle Hints, Explainplan,TKPROF, Partitioning and Indexes
  • Good understanding of machine learning algorithms, supervised and unsupervised modeling techniques
  • Experienced with Object Oriented Analysis and Design (OOAD) using UML,Rational Unified Process (RUP), Rational Rose, and Rational Clear Case.
  • Experience working with business to determine needs and explain concepts to get support for implementing solutions.
  • Experience with tools such as R Programming, visualizations, SAS, Open Sourceetc.
  • Strong experience writing stored procedures, functions, triggers, and adhoc queries using PL/SQL
  • Experience in working with business intelligence and data warehouse software, including SSAS, Pentaho, Cognos, OBIEE, QlikView, Greenplum Database, AmazonRedshift, or Azure Data Warehouse
  • Experience with data visualization tools or dashboard tools, including Tableau, D3.js, PowerBI
  • Experience with one or more reporting / dashboarding platforms (e.g. Qlikview, MicroStrategy, Business Objects)
  • Experienced in generating and documenting Metadata while designing OLTP andOLAP systems environment.
  • Experienced in developing Conceptual, Logical and Physical models using ERWIN,Sybase Power designer and Embarcadero E-R Studio.
  • Excellent understanding and working experience of industry standard methodologies like Software Development Life Cycle (SDLC), as per Rational Unified Process (RUP), Agile and Waterfall Methodologies.
  • Experienced in integration of various relational and non-relational sources such asDB2, Oracle, Netezza, SQLServer, NoSQL, COBOL, XML and Flat Files, to Netezzadatabase.
  • Extensive experienced in Normalization (1NF, 2NF, 3NF and BCNF) and De-normalization techniques for improved database performanceData Warehouse/Data Mart environments.
  • Experience in using Teradata ETL tools and utilizes such as BTEQ, MLOAD,FASTLOAD, TPT, FastExport.
  • Proficient in oracle tools and utilities such as TOAD, SQL*PLUS and SQL developer.
  • Strong expertise in Metadata, Data Quality, Master Data Management (MDM)and Data Governance.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin 9.x, Rational Rose, ER/Studio, MS Visio, SAP Power designer, Embarcadero.

Databases: MySQLServer 2016/2014/2012 , Oracle12c/11g/10g/9i,Teradata 16.0/15.1/14. x, MS Access 2010/2007, Sybase, Hive

Programming Languages: SQL, PL/SQL, UNIX shell scripting, PERL, R, Python

Operating Systems: Windows 10/8/7/xp, UNIX, MS DOS, Sun Solaris.

Reporting Tools: Crystal reports XI, Business Intelligence, SSRS, Business Objects 5.x/ 6.x, Cognos7.0/6.0, Tableau, Informatica Power Center v10/7.1/6.2, Ab - Initio,Data Stage

Project Execution Methodologies: Ralph Kimball and Bill Inmon data warehousing methodology, Rational Unified Process (RUP), Rapid Application Development (RAD), Joint Application Development (JAD)

BI Tools: Tableau, Tableau server, Tableau Reader, SAP Business Objects, OBIEE,QlikView, SAP Business Intelligence, Amazon Redshirt, or Azure Data Warehouse

Other Tools: MS-Office suite (Word, Excel, MS Project and Outlook), TOAD, BTEQ, Fast Load, Multi Load, Fast Export.

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

Sr. Data Scientist/Data Architect

Responsibilities:

  • Designed predictive models using the machine learning platform - H2O, Flow UI.
  • Worked on integrating h2o with Cisco's native data management and analytics platform-PNDA for the SP-Optimization team.
  • Developed spark streaming jobs using MLlib and deployed it as a PNDA app working along the DevOps team.
  • Worked on AWS S3 buckets and intra cluster file transfer between PNDA and s3 securely.
  • Analyzed auction mechanism for real-time bidding advertisement market place and built yield management tools.
  • Compiled data from various sources to perform complex analysis for actionable results.
  • Utilized machine learning algorithms such as linear regression, multivariate regression, naive bayes, Random Forests, K-means, & KNN for data analysis.
  • Developed MapReduce/Spark Python modules for machine learning & predictive analytics in Hadoop on AWS.
  • Implemented a Python-based distributed random forest via Python streaming.
  • Pipelined (ingest/clean/munge/transform) data for feature extraction toward downstream classification.
  • Measured Efficiency of Hadoop/Hive environment ensuring SLA
  • Worked with (Tableau) Report Writers to Test, Validate Data Integrity of Reports
  • Captured Modeling requirements from Senior Stakeholders to Bench functional requirements for SAS/ R Python
  • Analyze source systems for data acquisition architect data feathering logic across different source systems.
  • Designed and tested Predictive Algorithms using Historical Data worked with middleware tools like tibco business works and tibco iprocess will be desired.
  • Designed logical and physical data models of medium to high complexity, according to company standards.
  • Communicated strategies and process around data modeling and data architecture to cross functional groups.
  • Specifies overall Data Architecture for all areas and domains of the enterprise, including Data Acquisition, ODS, MDM, Data Warehouse, Data Provisioning, ETLand BI.
  • Developed Python driven Data Lake (SQL Server, Archer, Oracle, etc)
  • Created reports with Crystal Reports and scheduled to run on a daily basis.
  • Done data migration from an RDBMS to a NoSQL database, and gives the whole picture for datadeployed in various data systems.
  • Coordinated with Data Architects and Data Modelers to create new schemas and view in Netezza for to improve reports execution time, worked on creating optimized DataMart reports.
  • Used the Agile Scrum methodology to build the different phases of Software development life cycle.
  • Gathered and analyzed existing physical data models for in scope applications and proposed the changes to the data models according to the requirements.
  • Involved in database development by creating Oracle PL/SQL Functions, Procedures and Collections.

Environment: R, SAS, Python, Hadoop, Hive, Pig,Netezza, Map Reduce, Spark, Mongodb, MDM, PL/SQL,oracle 12c,AWS, Sql Server 2015, Nosql

Confidential, Baltimore, MD

Sr. Data Scientist/Data Architect

Responsibilities:

  • Worked on enhancements on PIG Scripts to include more Topics and creation of Pig UDFs to process User Cookies Data.
  • Developed POC in Spark to Query the dataset.
  • Performed data cleaning and data preparation tasks to convert data into a meaningful data set using R
  • Built analytics engine in R with machine learning for classifications and regression analyses.
  • Gathered and translated business requirements into technical specifications for in - house business intelligence(BI) tool.
  • Applied statistical modelling techniques on the queried datasets such as regression analysis and curve fitting techniques.
  • Identify the behavior and patterns in the data and visualize it through trend lines, box plots, bar charts.
  • Identified explanatory and response variables, computed collinearity and variance of the datasets.
  • Worked on Data Ingestion using Sqoop from Oracle to HDFS.
  • Worked with datasets collected from educational institutions and did cluster analysis and semantic grouping using k means algorithm.
  • Implemented supervised learning algorithms such as Neural networks, SVM, Decision trees and Na ve Bayes for advanced text analytics.
  • Advanced Text analytics using Deep learning techniques such as convolution neural networks to determine the sentiment of texts.
  • Interact with ETL Architects, Developers, DBDs and DBAs on how the model works and be able to make enhancements based on new and future requirements.
  • Communicate strategies and process around data modeling and data architecture to cross functional groups.
  • Developed ETL processes, including stored procedures, SSIS packages, and SQLServer jobs
  • Performed SAP Data Migration by using Business Objects Data Services as the ETL tool.
  • Developed PL/SQL triggers on master tables for automatic creation of primary keys and foreign keys.
  • Determine the tracking necessary to enable analytics of our products and features by working closely with product and engineering partners Key
  • Created SQL scripts and analyzed the data in MS Access/Excel and Worked on SQLand SAS script mapping.
  • Defined the overall EDW data architecture which may include EDW platform, ETLtools and processes, ODS, data marts and data modeling tools
  • Collaborate with Data Management, Business Intelligence team, stakeholders and team members to define, design, build, test, deploy and support a full datawarehouse environment
  • Responsible for leading the architectural development of metadata and reporting framework
  • Performed Database testing (Data Warehouse / ETL) on ETL applications validating the data in Sources (SAP, Oracle) Targets (EDW)
  • Involved in Designing the DB2 process to Extract translates and load data fromOLTP Oracle database system to Teradata data warehouse.

Environment: Python, R, SAP, Oracle, OLAP, OLTP, PL/SQL,Hadoop, Hive, Pig, SQl Server 2015,Sqoop, Spark

Confidential, San Francisco, CA

Sr. Data Scientist/Data Architect

Responsibilities:

  • Developed Apache Hadoop components like HDFS, Map Reduce, HiveQL, HBase,Pig, Sqoop, Ozzie, Mahout, Cassandra, Mongo db, Big Data and Big Data Analytics.
  • Worked on the development of Data Warehouse, Business Intelligence architecture that involves data integration and the conversion of data from multiple sources and platforms.
  • Developed statistical models using software such as R and SPSS
  • Sorted and identified patterns and clusters of facts with the use of data analytical software such as SPSS, R Languages
  • Follow the Type 2 - dimension methodology to accommodate designing and maintaining for history data
  • Implementing Apache Spark, Hadoop and Spark-R packages to provision big data analytics
  • Used Maven extensively for building jar files of Map Reduce programs and deployed to Cluster.
  • Used Spark for test data analytics using MLLib and Analyzed the performance to identify bottlenecks.
  • Used supervised learning techniques such as classifiers and neural networks to identify patters in these data sets.
  • Developed core Data Science models
  • Worked & merged Data in multiple formats/sources (CSV, fetch from SQLServer/SAP HANA etc.)
  • Identified risk features and they were combined to form groups with Bayesian predictors depending on the patterns in which they indicate fraudulent activity.
  • Worked on Linux shell scripts for business process and loading data from different interfaces to HDFS.
  • Build an in-depth understanding of the business domains and available data assets, and perform exploratory statistics on diverse datasets.
  • Collaborate with engineering team to transfer the business understanding, productize the model and validate output with business users.
  • Maintained meta data (data definitions of table structures) and version controlling for the data model.
  • Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
  • Work with software engineers to put predictive models in production
  • Built Cloud architecture on Amazon AWS.
  • Responsible for the development of target data architecture, design principles, quality control, and data standards for the organization
  • Worked with DBA to create Best-Fit Physical Data Model from the logical Data Model using Forward Engineering in Erwin.
  • Determine data reduction methodologies for dealing with noisy data (correlation matrix, principal components analysis, clustering), missing values, and outliers
  • Setup Hadoop cluster using EC2 (Elastic Map Reduce) on managed Hadoop Frame Work.
  • Used S3 Bucket to store the jar's, input datasets and used DynamoDB to store the processed output from the input data set

Environment: R, HDFS, Map Reduce, HiveQL, HBase, Pig, Sqoop, Ozzie, Mahout, Cassendra, Mongo db, Linux Shell Script, Dynamo DB, SAP, HANA, Amazon AWS, Millib

Confidential, Tampa, FL

Sr. Data Analyst/Data Modeler

Responsibilites:

  • Responsible to determine the fundamental organization of the system and the various components that consists the system and the principles guiding its design and evolution.
  • Involved in requirements gathering procedures along with the business analysts.
  • Translated requirements into sustainable and scalable conceptual and logical data models.
  • Developed, delivered and validated the logical and physical data models through collaboration with team leads, SMEs, business users, and other team members using ERwin 4.0
  • Used star/snowflake schemas in creating dimensional models.
  • Designed, built, and maintained enterprise conceptual, logical, and physical multidimensional data models and data - marts that adhere to department standards, policies, procedures, and industry best practices.
  • Created documentation as needed to support data architecture.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects.
  • Maintained warehouse metadata, naming standards and warehouse standards.
  • Used the Ab Initio to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
  • Assisted Lead Data Management Architect in the development of the best option for entry of business terms and definitions and maintained the metadata in the proper way to the business.
  • Responsible for loading and distribution of data sets into database table across various servers. Automated data loads, transfers and data validation procedures.
  • Assisted Business analysts with Teradata Utilities
  • Used Teradata Utilities (BTEQ, Multiload, and Fast Load) to maintain the database.
  • Performed ad-hoc queries by using SQL, PL/SQL, MS Access, MS excel and UNIX to meet business Analysts needs.
  • Developed test plans and assisted in System Integration Testing (SIT).
  • Documentation involved design docs, sop, mapping specifications and process flowcharts etc.
  • Involved in quality assurance to ensure quality, validity and accuracy of data across the servers.

Environment: ERwin 4.0, SQL, PL/SQL, MS Office (Word, Power Point, Access, Excel, Outlook), Lotus notes, Oracle 9i, SQL Server 2005, Business Objects, Informatica.

Hire Now