Data Science Engineer Resume
San Antonio, TX
SUMMARY
- Over 7+ years of working experience in IT Data Modeler and Data Analyst with high proficiency in requirement gathering and data modeling including design and technical noledge, in the field of OLTP, Data Warehousing, OLAP and ETL Environment along with quick adaptability to new technologies.
- Expert in writing SAS programs to perform ad - hoc analysis and data manipulation
- Expert in using SAS Base programming as well as SAS Enterprise Guide 4.0 to produce various reports, charts and graphs.
- Expert noledge in SDLC (Software Development Life Cycle) and was involved in all phases in projects.
- Expert in Business Intelligence solutions in Data warehousing / Decision Support Systems using ETL tools Informatics, OLAP, OLTP and Data Warehouse Reports using Business Objects, Crystal Reports.
- Collaborated Cross work stream sessions to give idea on conversion changes from ODS and Data warehouse side.
- Efficient in analyzing and documenting Business Requirement Documents (BRD) and Functional Requirement Document (FRD) along with Use Case Modeling and UML.
- Expertise in deploying OLAP tools, Views, Materialized Views and partitioning techniques for highly responsive Decision Support Systems.
- Expert in Designing Dimensional Modeling (Star Schemas, Snow flake schema) and Operational Data store (OLTP)Data Warehouse design.
- Excellent skills in database Backup, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing indexes, Defrag Tables, Replication, Linked Servers and Database Maintenance Plan.
- Created Linked Servers between SQL Servers and also to Oracle Databases.
- Good noledge in using DMVs and DMFs to finding and solving Performance Issue, Data modeling concepts.
- Documented Disaster recovery plans and participated in Disaster Recovery Drills by implementing Root Cause Analysis (RCA) for troubleshooting and resolving the issues.
- Expert in raising the Service Requests and keep tracking of requests.
- Expert in Detecting and Resolving Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor.
- Expert in creating and debugging Views, Functions, Indexes, Cursors, Stored Procedures, Triggers, optimizing code and improving Efficiency.
- Expert in migrating the DTS Packages to SSISPackages by using Package Migration Wizard.
- Data Modeling Experience including Physical and Logical data modeling using Erwin tool
- 24/7 on call production support.
- Knowledge on powershell scripting.
- Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
- Worked Extensively on ETL process using SSIS packages.
- Experience on DATA warehousing.
- Hands on experience in installing, configuring, managing and troubleshooting SQL Server.
- Experience in database development, for creating complex database queries, Indexes, Views, Stored Procedures and Triggers in SQL Server.
TECHNICAL SKILLS
Relational Databases: SQL Server 2 / R2 / 2005, MS-Access / 2007, Mysql 4/5, Oracle 9i / 10g
Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, BCP, ODBC, SQL OLEDB, DBCC, ADO, ADO.NET, Business Intelligence Studio, Crystal Reports.
Languages: C#, XML, SQL, T-SQL
Operating Systems: Windows 2012, Windows 2008R2, Windows 2003, Windows 2000 server, Win ME/NT/XP, UNIX.
PROFESSIONAL EXPERIENCE
Confidential
Data Science Engineer
Responsibilities:
- Created statistical models for the collected data, exploratory, pre-processing, in order to provide conclusions which guides for the policy making decisions.
- Worked with DBMI, SAS IT, BI team and automated 2 mature modeling and scoring process.
- Monitored study results and interpret data in a manner which provides clarity and an undeniable conclusion.
- Used SAS CI studio and SAS MO for the optimization of the campaign performance.
- Utilized Apache Spark with Python to develop and execute Big Data Analytics and Machine learning applications, executed machine learning use cases under Spark ML and Mllib.
- Handled importingdatafrom variousdatasources, performed transformations using Hive, Map Reduce, and loadeddatainto HDFS.
- Utilized Spark, Scala, Hadoop, HBase, Cassandra, MongoDB, Kafka, Spark Streaming, MLLib, Python, a broad variety of machine learning methods including classifications, regressions, dimensionally reduction etc. and Utilized the engine to increase user lifetime by 45% and triple user conversations for target categories.
- Designed and developed NLP models for sentiment analysis.
- Worked on machine learning on large sizedatausing Spark and Map Reduce.
- Build and maintain scalabledatapipelines using the Hadoop ecosystem and other open source components like Hive and HBase.
- Created Hive architecture used for real time monitoring and HBase used for reporting and worked for map reduce and query optimization for Hadoop hive and HBase architecture.
- Changed our model codes and results for smooth connection with SAS MO system and managed the testing, implementation of MO.
- Developed automation process for variable and model selection on over 5,000 core SKU's.
- Communicated detailed statistical and scientific findings to lay individuals.
- Published manuscripts in scientific journals and papers presented in various conferences.
- Delivered solutions using clustering algorithm, logistic regression, composite index analytics, decision tree and other algorithms as per requirement.
- Evaluation of models for Bias and variance problem. Evaluating models for best parameters using K folds.
- Achieved good prediction for different promotion media on various products.
Environment: Erwin9.6.4, Oracle 12c, Python, Pyspark, Spark, Spark MLLib, Tableau, ODS, PL/SQL, OLAP, OLTP, AWS, Hadoop, Map Reduce, HDFS, Python, MDM, Teradata 15, Hadoop, Spark, Cassandra, SAP, MS Excel, Flat files, Tableau, Informatica, SSIS, SSRS, AWS EC2, AWS EMR, Elastic Search.
Confidential, San Antonio TX
Data Science Analyst
Responsibilities:
- Tasked to understand the relationship between MSR performance and first year attrition
- Leveraged various statistical techniques to profile the data (Logistic, Random Forest, lasso, ridge and SVM)
- Compared data findings with business smes to understand potential findings / insights
- Identified characteristics / metrics most indicative of separation flag
- In-depth Analysis of the metric responsible for attrition.
- Used R, SQL to create Statistical algorithms involving Multivariate Regression, Linear Regression, Logistic Regression, PCA, Random forest models, Decision trees, Support Vector Machine for estimating the risks.
- Implemented HQL Scripts in creatingHivetables, loading, analyzing, merging, binning, backfilling, cleansing usinghive.
- Used R for Exploratory Data Analysis, A/B testing, Anova test and Hypothesis test to compare and identify the TEMPeffectiveness of Creative Campaigns.
- Worked on predictive and what-if analysis using R from HDFS and successfully loaded files to HDFS from Teradata, and loaded from HDFS to HIVE.
- Designed the schema, configured and deployed AWSRedshiftfor optimal storage and fast retrieval ofdata.
- Developed SQL scripts for loadingdatafrom staging area to Target tables and worked on SQL and SAS script mapping.
- Worked on Teradata SQL queries, Teradata Indexes, Utilities such as Mload, Tpump, Fast load and Fast Export.
- Developed LINUX Shell scripts by using NZSQL/NZLOAD utilities to load data from flat files to Netezzadatabase.
- Worked with cloud based technology likeRedshift, S3, AWS, EC2 Machine, etc. and extracting thedatafrom the Oracle financials and theRedshiftdatabase.
- Created Active Batch jobs to loaddatafrom distribution servers toPostgreSQLDB using *.bat files and worked on CDC schema to keep track of all transactions.
Environment: Oracle 12c, SQL Plus, Erwin 9.6, MS Visio, SAS, Source Offsite (SOS), Hive, PIG, Windows XP, AWS, QC Explorer, Share point workspace, Teradata, Oracle, Agile, PostgreSQL, Data Stage, MDM, Netezza, IBM Infosphere, SQL, PL/SQL, IBM DB2, SSIS, Power BI, AWS Redshift, Business Objects XI3.5,COBOL,SSRS, QuickData, Hadoop, MongoDB, HBase, Hive, Cassandra.
Confidential, CHARLOTTE-NC
Sr. SQL Server DBA
Responsibilities:
- Configured SQL Server Mirroring for High Availability across all production servers in SQL Server 2008 R2.
- Involved in migration of databases from SQL Server 2008 R2 to SQL Server 2012.
- Configured mirroring on SQL Server 2012 Databases.
- Involved in migration of databases from SQL Server 2008 R2 to 2012 and SQL Server
- Implemented High Availability in SQL 2012 by configuring Always On Availability groups across Windows Server Failover Clustering using Failover Clustering Instances
- Worked on pre-live BCP exercise to make sure mirroring will work after live migration.
- Implemented Log Shipping for warm backup solution for MS SQL Server databases.
- Data monitoring with IDERA tools
- Understanding and converting business requirements into functional requirements doc, review and sign off with the customer.
- Perform Impact analysis and provide optimal solutions to the Client, Business users.
- Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
- Developed and OptimizedStored Procedures, Views and User-Defined Functionsfor the Application.
- Extensively worked on Profiler, Perfmon Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
- Used DMV's to diagnose problems and monitor health of server instance.
- Rebuilding indexes with different fill factors and update statistics manually.
- Detected and Resolved Locks and Deadlocks using the Trace Flags T and Native tools like Profile and the Activity Monitor.
- Installing/administratingSQL Server Reporting Services (SSRS), creating scheduled reports and delivering via email.
- Integration of Archer using various data feeds. Performing data transformation and system integration activities
- Scheduled weekly jobs and Maintenance tasks for better performance, created the alerts with Database Mail SMTP.
- Used Quest Foglight and Quest Spotlight tools to monitor SQL Server Performance and to generate Performance reports.
- Configured Transitional Replication(Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors) and troubleshoot replication issues.
- Used SQL server Profiler to identify and analyze deadlocks.
- Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
- Created packages using SSIS to migrate data from different data sources to data warehouse.
- Perform Impact analysis and provide optimal solutions to the Client, Business users.
- Design/Build Extract Transform Load procedures in SQL Server Integration Services
- Installation, upgradation, and patch of the databases on LINUX system.
- Designed and developed SSIS Packages to import and export data from MS Excel, SQL Serverand Flat files.
- Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
- Migrated database from SQL Server 2008 R2 to SQL Server 2012.
- Worked extensively in performance tuning of databases including query tuning, server tuning.
- Created and scheduled maintenance plans for Database backups, log backups and cleanup.
- Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Assisted data migration from ODBC compliant sources (Oracle)/legacy systems to SQL Server through DTS packages and bcp utility.
Environment: MS SQL Server 2014/2012/2008 R2, SSIS, SSRS, Replication, OLAP, OLTP, AWS, Alloy and TSRM Ticketing System, SQL Litespeed console, SQL sentry Spotlight.
Confidential, Rhode Island
Sr. SQL DBA
Responsibilities:
- Installation, configuration and up gradation of SQL servers 2014 and SQL server 2012 on Windows2008 and Windows 2012 based on Enterprise Distributed Security (EDS- IBM) standards.
- Upgrade/migration of several instances and databases from SQL Server 2000 to SQL Server 2005/2008, SQL Server 2005 to SQL Server 2008/2008 R2, from SQL Server 2008/2008R2 to SQL Server 2012/2014.
- Preparing the documentation and implementing the Disaster Recovery Plans using Database Mirroring, Log shipping and Replication with different topologies for production databases.
- Involved Disaster Recovery excise and got CREDO awarded.
- Configure the Server administration in various environments - Window 2000 & 2003 with Active Directory Services (AD, DNS, DHCP).
- Migrating the Database from SQL server 2000 to SQL server2008 and from SQl server 2008 to SQL server 2012/SQL server2014 on SIT/DEV/QA/PRODUCTION region.
- Hands on experience on taking Database backup and Restore on SQL server2008/SQL server2008R2/SQL server2012/SQL server2014 from SQL server 2000/SQL server 2005.
- Migrated the DTS packages from SQL server 2005 DTS to SQL Server 2008 and above into SSIS packages incoordination.
- Configuring of SQL Server new features like Always On Availability Groups, Contained Databases, Change data capture (CDC), online index rebuilds, Central management server, Transparent Data Encryption (TDE), User-Defined server roles.
- Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
- Used multitask data pump in DTS/ETL. Assist with database transaction and security audits.
- Monitoring SQL instances and correcting issues that arise.
- Troubleshoot and problem solving of SQL related issues, including advising on customer issues.
- Discussing with Team members and understanding the issues and assisting to fix the issues.
- Attending the Production troubleshoot calls on 24*7.
- PerformingRootcauseanalysis on the production issues.
- Worked Extensively on ETL process using SSIS packages.
- Implemented User-Defined server roles in SQL Server 2012, default schemas for groups.
- Reviewing T-SQL code and maintaining coding standards in all SQL Server environments.
- Hands on configuring Tempdb with considerable Memory and Raid Levels for better performance.
- Creating and Maintaining Trace Audits for Security events.
- Involved in the meetings with Line of Business for requirements gathering and modified procedures according to the business requirements.
- Created and used Materialized views and DB links for remote instances to retrieve data from other databases.
- Involved inDBAactivities like granting, revoking privileges.
- Created and Modified existing functions and procedures based on business requirements.
- Communicating the client about project related queries.
- Setting up Connection Strings and connecting SQL Server Databases from application front.
- Involving on application migration activities from windows 2003 to windows 2012.
- Experience in understanding IISconfiguration.
- Resolved issues related to blocking, deadlocks, connectivity issues, replication issues.
- Conducting the dailyinternal team and monitoring activities.
- Attending the daily/ weekly review meeting with clients.
Environment: SQL Server 2005/2008R2/2012, T-SQL, Windows Server, HTML 4.0, JavaScript, Access.SQL Query Analyzer, BI Data Tools (SSRS, SSIS, SSAS), SCOM, Avamar Backup utility, Vormetric Encryption, Imperva secure sphere
Confidential - Houston, TX
SQL Server Database Administrator
Responsibilities:
- Ensure backups and redundancy is maintained to assure failover mechanisms.
- Proactively monitor the database systems to ensure secure services with minimum downtime.
- Troubleshoot and problem solving of SQL related issues, including advising on customer issues.
- Set up SQL server Clustering andAlwaysONtechnologies.
- Data Migration (transformations) from DB2 & Oracle to SQL Server 2008/2008R2 using SSIS, BCP and Import/export tools.
- Developing queries and various database objects like stored procedures, functions and triggers using TOAD and SSMS.
- Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
- Monitored Log shipping/Transactional Replication and troubleshooting of errors.
- Improve and maintain databases to include rollout and upgrades.
- Implement and release database changes according to agreed timescales and costs.
- Monitoring SQL instances and correcting issues that arise.
- Work with application development staff to abide by database architectures, coding standards, and quality assurance policies and procedures.
- Database monitoring with IDERA tool
- Work with Application Development Manager to create models for new database development and/or changes to existing ones.
- Install and configure relevant network components to ensure database access as well as database consistency and integrity as approved by management.
- Respond to and resolve database access and performance issues.
- Monitor database system details within the database, including SP’s and their execution time.
- Monitor, optimize and allocate physical data storage for database systems as approved by management.
- Experience with SCOM to monitor and manage critical database servers from a centralized location.
- Create, or support creation of, required reports in response to business user needs.
- Configuration of Privileges and roles to customers/users
- Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
- Used multitask data pump in DTS/ETL. Assist with database transaction and security audits.
- Develop routines for end-users to facilitate best practices for database use.
- Perform database tuning including monitoring, troubleshooting and optimizing performance of the databases.
- Setup, monitor, and resolve database mirror issues.
- Apply SQL service packs and patches.
Environment: SQL Server 2008/2008R2/2005, T-SQL, Windows Server 2003, Windows Server 2008R2.
