SUMMARY

• Above 8+ years of experience in MachineLearning, Datamining wif largedatasets of Structured and Unstructureddata, DataAcquisition, DataValidation, Predictivemodeling, DataVisualization.
• Extensive experience in Text Analytics, developing different StatisticalMachineLearning, DataMining solutions to various business problems and generating datavisualizations using R, Python and Tableau.
• Designing of PhysicalDataArchitecture of New system engines.
• Hands on experience in implementing LDA, NaiveBayes and skilled in RandomForests, Decision Trees, Linear and Logistic Regression, SVM, Clustering, neuralnetworks, Principle Component Analysis and good knowledge on Recommender Systems.
• Proficient in StatisticalModeling and MachineLearning techniques (Linear, Logistics, Decision Trees, Random Forest, SVM, K - Nearest Neighbors, Bayesian, XG Boost) in Forecasting/ Predictive Analytics, Segmentation methodologies, Regression based models, Hypothesis testing, Factor analysis/ PCA, Ensembles.
• Expertise in transforming business requirements into analyticalmodels, designingalgorithms, buildingmodels, developing datamining and reportingsolutions dat scales across massive volume of structured and unstructured data.
• Developing LogicalDataArchitecture wif adherence to Enterprise Architecture.
• Strong experience in Software Development Life Cycle (SDLC) including RequirementsAnalysis, Design Specification and Testing as per Cycle in both Waterfall and Agile methodologies.
• Adept in statisticalprogramminglanguages like Rand alsoPython including BigData technologies like Hadoop, Hive.
• Skilled in using dplyr and pandas in R and python for performing Exploratory dataanalysis.
• Experience working wifdatamodeling tools like Erwin, PowerDesigner and ERStudio.
• Experience in designing starschema, Snowflakeschema forDataWarehouse, ODSarchitecture.
• Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards, Storyline on web and desktop platforms.
• Experience and Technicalproficiency in Designing,DataModelingOnlineApplications, Solution Lead for ArchitectingDataWarehouse/BusinessIntelligence Applications.
• Good understanding of TeradataSQLAssistant, Teradata Administrator anddataload/ export utilities like BTEQ, FastLoad, MultiLoad, FastExport.
• Experience wif DataAnalytics, DataReporting, Ad-hocReporting,Graphs, Scales, PivotTables and OLAP reporting.
• Highly skilled in using Hadoop (pig and Hive) for basic analysis and extraction of data in teh infrastructure to provide datasummarization.
• Highly skilled in using visualization tools like Tableau, ggplot2 and d3.js for creating dashboards.
• Worked and extracteddatafrom various database sources like Oracle, SQLServer, DB2, Regularly accessing JIRA tool and other internal issue trackers for teh Project development.
• Skilled in System Analysis, E-R/DimensionalDataModeling, DatabaseDesign and implementing RDBMS specific features.
• Knowledge of working wif Proof of Concepts (PoC’s) and gapanalysis and gathered necessary data for analysis from different sources, prepared data for dataexploration using datamunging and Teradata.
• Well experienced in Normalization&De-Normalization techniques for optimum performance in relational and dimensional database environments

TECHNICAL SKILLS

Data Modeling Tools: Erwin r9.6/9.5, ER/Studio 9.7, Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables.

Frameworks: Microsoft .Net 4.5/ 4.0/ 3.5/3.0 , Entity Framework, Bootstrap, Microsoft Azure, Swagger.

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, Fact & Dimensions tables, physical & logical data modeling, Normalization and De-normalization techniques, Kimball &Inmon Methodologies

Version Controller: TFS, Microsoft Visual SourceSafe, GIT, NUNIT, MSUNIT

Software Packages: MS-Office 2003/ 07/10/13 , MS Access, Messaging Architectures.

Operating Systems: Windows Win8/XP/NT/ 95/98/2000/2008/2012 , Android SDK.

Microsoft Technologies: PHP,Scala2,Shark2,Awk,Cascading,Cassandra,Clojure,Fortran,JavaScript,JMP,Mahout,objectiveC,QlickView,Redis,Redshifed

Web Technologies: Windows API, Web Services, Web API (RESTFUL) HTML5, XHTML, CSS3, AJAX, XML, XAML,MSMQ, Silverlight, Kendo UI.

DWH / BI Tools: Microsoft Power BI, Tableau, SSIS, SSRS, SSAS, Business Intelligence Development Studio (BIDS), Visual Studio, Crystal Reports, Informatica 6.1.

Programming Languages: C#, VB.NET (VB6), VBScript, OOPS, Data structures, Matlab,Algorithms, Python, R, Java, Java Script, SQL, J2EE, C, C++ and XML.

Development Tools: R x 30, SQL x 27, Python x 22, Hadoop x 19, SAS x 18, Java x15, Hive x 13, Mat lab x 12, R Studio,SAS, MSOffice,Visual Studio 2010

Big Data Tools: Hadoop 2.7.2, Hive, Spark2.1.1, Pig, HBase, Sqoop, Flume

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Data Scientist

Responsibilities:

• As an Architect design conceptual, logical and physical models using Erwin and build datamarts using hybrid Inmon and Kimball DW methodologies.
• Worked closely wif business, datagovernance, SMEs and vendors to define data requirements.
• Worked wif data investigation, discovery and mapping tools to scan every single data record from many sources.
• Perform data integrity checks, data cleaning, exploratory analysis and feature engineer using R 3.4.0.
• Designed teh prototype of theDatamart and documented possible outcome from it for end-user.
• Involved in business process modeling using UML
• Visualize data in R using various packages like ggplot2 and various regression techniques
• Developed and maintaineddatadictionary to create metadata reports for technical and business purpose.
• Created SQLtables wif referential integrity and developed queries using SQL, SQL*PLUS and PL/SQL
• Experience in maintaining database architecture and metadata dat support teh EnterpriseDatawarehouse.
• Design, coding, unit testing of ETL package source marts and subject marts using Informatica ETL processes for Oracledatabase.
• Developed various QlikView Data Models by extracting and using teh 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.
• Interaction wif Business Analyst, SMEs and other Data Architects to understand Business needs and functionality for various project solutions
• Researched, evaluated, architected, and deployed new tools, frameworks, and patterns to built sustainable Big Data platforms for teh clients
• Identifying and executing process improvements, hands-on in various technologies such as Oracle, Informatica, BusinessObjects.
• Designed both 3NF data models for ODS, OLTP systems and dimensionaldatamodels using Star and SnowflakeSchemas.

Environment: r9.0, Informatica 9.0, ODS, R, OLTP, Oracle 10g, Hive, OLAP, DB2, Metadata, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro. Hadoop, PL/SQL, etc.

Confidential, Des Moines, IA

Data Scientist

Responsibilities:

• Worked as aDataModeler/Analyst to generateDataModels using Erwin and developed relational database system.
• Analyzed teh business requirements of teh project by studying teh Business Requirement Specification document.
• Extensively worked on DataModeling tools ErwinDataModeler to design teh datamodels.
• Designedmapping to process teh incremental changes dat exists in teh source table. Whenever source data elements were missing in source tables, these were modified/added in consistency wif third normal form based OLTP source database.
• Designed tables and implemented teh naming conventions for Logical and PhysicalData Models in Erwin 7.0.
• Provide expertise and recommendations for physicaldatabasedesign,architecture, testing, performance tuning and implementation.
• Designedlogical and physical data models for multiple OLTP and Analytic applications.
• Extensively used teh Erwin design tool &Erwin model manager to create and maintain teh DataMart.
• Designed teh physical model for implementing teh model into oracle9i physicaldatabase.
• Involved wif DataAnalysis primarily Identifying DataSets, SourceData, Source Meta Data, Data Definitions and Data Formats
• Performance tuning of teh database, which includes indexes, and optimizing SQL statements, monitoring teh server.
• Wrote simple and advanced SQLqueries and scripts to create standard and adhoc reports for senior managers.
• Collaborated thedatamapping document from source to target and thedataquality assessments for teh sourcedata.
• Used Expert level understanding of different databases in combinations for Data extraction and loading, joiningdata extracted from different databases and loading to a specific database.
• Co-ordinate wif various business users, stakeholders and SME to get Functional expertise, design and business test scenarios review, UAT participation and validation of financial data.
• Worked very close wifDataArchitectsand DBA team to implementdatamodel changes in database in all environments.
• Created PL/SQL packages and DatabaseTriggers and developed user procedures and prepared user manuals for teh new programs.
• Performed performance improvement of teh existingDatawarehouse applications to increase efficiency of teh existing system.
• Designed and developed UseCase, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio.

Environment: SQL Server 2008R2/2005 Enterprise, SSRS, SSIS, Crystal Reports, Windows Enterprise Server 2000, DTS, SQL Profiler, and Query Analyzer.

Confidential, New Jersey

Data Scientist

Responsibilities:

• Coded R functions to interface wif CaffeDeepLearning Framework
• Working in AmazonWebServices cloud computing environment
• Worked wif several R packages including knitr, dplyr, SparkR, CausalInfer, spacetime.
• Implemented end-to-end systems for DataAnalytics, DataAutomation and integrated wif custom visualization tools using R,Mahout, Hadoop and MongoDB.
• Gathering all teh data dat is required from multiple data sources and creating datasets dat will be used in analysis.
• Performed Exploratory DataAnalysis and DataVisualizations using R, andTableau.
• Perform a proper EDA, Univariate and bi-variate analysis to understand teh intrinsic TEMPeffect/combined TEMPeffects.
• Worked wifDatagovernance,Dataquality,datalineage,Dataarchitectto design various models and processes.
• Independently coded new programs and designed Tables to load and test teh program TEMPeffectively for teh given POC's using wif BigData/Hadoop.
• Designeddatamodels anddataflow diagrams using Erwin and MSVisio.
• As an Architect implemented MDM hub to provide clean, consistent data for a SOA implementation.
• Developed, Implemented & Maintained teh Conceptual, Logical&PhysicalDataModels using Erwin for Forward/ReverseEngineered Databases.
• EstablishedDataarchitecture strategy, best practices, standards, and roadmaps.
• Lead teh development and presentation of a dataanalytics data-hub prototype wif teh halp of teh other members of teh emerging solutions team
• Performed datacleaning and imputation of missing values using R.
• Worked wif Hadoop eco system covering HDFS, HBase, YARN and MapReduce
• Take up ad-hoc requests based on different departments and locations
• Used Hive to store teh data and perform datacleaning steps for huge datasets.
• Created dash boards and visualization on regular basis using ggplot2 and Tableau
• Creating customized business reports and sharing insights to teh management
• Worked wif BTEQ to submit SQL statements, import and export data, and generate reports in Teradata.
• Interacted wif teh other departments to understand and identify dataneeds and requirements and work wif other members of teh ITorganization to deliver data visualization and reportingsolutions to address those needs.

Environment: Erwin r9.0, Informatica 9.0, ODS, OLTP, Oracle 10g, Hive, OLAP, DB2, Metadata, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro. Hadoop, PL/SQL, etc..

Confidential, Indianapolis, IN

Data Analyst

Responsibilities:

• Supported MapReduce Programs running on teh cluster.
• Evaluated business requirements and prepared detailed specifications dat follow project guidelines required to develop written programs.
• Configured Hadoop cluster wif Namenode and slaves and formatted HDFS.
• Used Oozieworkflow engine to run multiple Hive and Pig jobs.
• Performed Map Reduce Programs those are running on teh cluster.
• Developed multiple MapReduce jobs in java for data cleaning and preprocessing.
• Analyzed teh partitioned and bucketed data and compute various metrics for reporting.
• Involved in loading data from RDBMS and web logs into HDFS using SqoopandFlume.
• Worked on loading teh data from MySQL to HBase where necessary using Sqoop.
• Developed Hive queries for Analysis across different banners.
• Extracted data from Twitter using Java and Twitter API. Parsed JSON formatted twitter data and uploaded to database.
• Launching Amazon EC2 Cloud Instances using Amazon Images (Linux/ Ubuntu) and Configuring launched instances wif respect to specific applications.
• Exported teh result set from Hive to MySQL using Sqoop after processing teh data.
• Analyzed teh data by performing Hive queries and running Pig scripts to study customer behavior.
• Has hands on experience working on Sequence files, AVRO, HAR file formats and compression.
• Used Hive to partition and bucket data.
• Experience in writing MapReduce programs wif Java API to cleanse Structured and unstructured data.
• Wrote Pig Scripts to perform ETL procedures on teh data in HDFS.
• Created HBase tables to store various data formats of data coming from different portfolios.
• Worked on improving performance of existing Pig and Hive Queries.

Environment: SQL/Server, Oracle 9i, MS-Office, Teradata, Informatica, ER Studio, XML, Business Objects.

Confidential

Data Analyst/Data Modeler

Responsibilities:

• Deployed GUI pages by using JSP, JSTL, HTML, DHTML, XHTML, CSS, JavaScript, AJAX
• Configured teh project on WebSphere 6.1 application servers
• Implemented teh online application by using Core Java, Jdbc, JSP, Servlets and EJB 1.1, Web Services, SOAP, WSDL
• Communicated wif other Health Care info by using Web Services wif teh halp of SOAP, WSDL JAX-RPC
• Used Singleton, factory design pattern, DAO Design Patterns based on teh application requirements
• Used SAX and DOM parsers to parse teh raw XML documents
• Used RAD as Development IDE for web applications.
• Preparing and executing Unit test cases
• Used Log4J logging framework to write Log messages wif various levels.
• Involved in fixing bugs and minor enhancements for teh front-end modules.
• Implemented Microsoft Visio and Rational Rose for designing teh Use Case Diagrams, Class model, Sequence diagrams, and Activity diagrams for SDLC process of teh application
• Doing functional and technical reviews
• Maintenance in teh testing team for System testing/Integration/UAT
• Guaranteeing quality in teh deliverables.
• Conducted Design reviews and Technical reviews wif other project stakeholders.
• Was a part of teh complete life cycle of teh project from teh requirements to teh production support
• Created test plan documents for all back-end database modules
• Implemented teh project in Linux environment.

Environment: R 3.0, Erwin 9.5, Tableau 8.0, MDM, QlikView, MLLib, PL/SQL, HDFS, Teradata 14.1, JSON, HADOOP (HDFS), MapReduce, PIG, Spark, R Studio, MAHOUT, JAVA, HIVE, AWS.

Confidential

Data Analyst

Responsibilities:

• Analyze business information requirements and model class diagrams and/or conceptual domain models.
• Gather & Review Customer Information Requirements for OLAP and building teh data mart.
• Performed document analysis involving creation of Use Cases and Use Case narrations using Microsoft Visio, in order to present teh efficiency of teh gathered requirements.
• Calculated and analyzed claims data for provider incentive and supplemental benefit analysis using Microsoft Access and Oracle SQL.
• Analyzed business process workflows and assisted in teh development of ETL procedures for mapping data from source to target systems.
• Worked wif BTEQ to submit SQL statements, import and export data, and generate reports in Terra-data.
• Responsible for defining teh key identifiers for each mapping/interface
• Responsible for defining teh functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests wif teh requestor and coordinate wif teh development and testing team.
• Coordinated meetings wif vendors to define requirements and system interaction agreement documentation between client and vendor system.
• Generate weekly and monthly asset inventory reports.
• Coordinate wif teh business users in providing appropriate, TEMPeffective and efficient way to design teh new reporting needs based on teh user wif teh existing functionality
• Managed teh project requirements, documents and use cases by IBM Rational RequisitePro.
• Assisted in building an Integrated Logical Data Design, propose physical database design for building teh data mart.
• Document all data mapping and transformation processes in teh Functional Design documents based on teh business requirements.

Environment: SQL Server 2008R2/2005 Enterprise, SSRS, SSIS, Crystal Reports, Windows Enterprise Server 2000, DTS, SQL Profiler, and Query Analyzer.