Database Administrator & BI Lead Resume

SUMMARY

Expertise in Database Design & Development, Installation, migration, Configuration, replication, capacity planning, backup and recovery strategies.
Experience in High Availability (MIRRORING, LOGSHIPPING, REPLICATION, CLUSTERING, ALLWAYSON AVAILABILITY GROUP) with virtualization technologies (VMware, Hyper - V, Xen).
Developed competencies in Web Analytics, Target Marketing, Social Media Marketing, and Sentimental Analysis & Opinion Mining for Customer Analytics Product.
Development of complex business intelligence reports with dashboards, drill-down, lookup and aggregation capabilities (PowerPivot, PowerView & PowerMap: PowerBI), MDS (Master Data Services).
Machine Learning, supervised and unsupervised: - Forecasting, Classification, Data/Text Mining, NLP, Decision Trees, Adaptive Decision Algorithms, Random Forest, Search Algorithms, Neural Networks, Deep Learning Algorithms.
Development of machine learning algorithms for credit acceptance (support vector machines, random forest, lasso penalization, …)
Assessment of the predictive power of unstructured data through text mining techniques
Big Data: Moving Larger Dataset into Hadoop, Kafka Streaming with Yarn and Zookeeper, Processing with Amazon Elastic Map Reduce.
Working on various Open source software platforms like Caffe, TensorFlow, Theano, NumPy, SciPy, Google APIs.

TECHNICAL SKILLS

Relational Database: SQL Server 2008/R2/2014/2016; Oracle 10g, 11g; MYSQL 5.7; POSTRGRES 9.3; DB-2 & Sybase

Big Data: Hadoop stack (Hadoop MR, Hdfs, Pig, Hive, Hbase, Sqoop), NOSQL ( MongoDB, Cassandra), SPARK 2.0, HDINSIGHT(MS)

Analytics: MSBI: SSAS, R - Language, Python, Tableau, Machine Learning, Tensorflow, Azure AI Service ( Cognitive / ML / Bot )

Scripting Language: T-SQL,PL/SQL, PYTHON ( 3.6), SCALA, Powershell(5.0), Java script, HTML, XML, JSON.

CLOUD: MS-AZURE, Google Cloud Platform.

Web skill: C#.Net, WCF, WPF, ASP.Net, Java (WildFly & LifeRay).

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator & BI Lead

Responsibilities:

Administrator and Team Account Focal.
Performance Tuning / Security /Maintenance
Running advanced statistical analyses identifying trends, and exploring opportunities with the aim of generating actionable insights
Developing predictive models that address business needs and measuring performance of these models to ensure business improvements.
Areas of expertise include Probabilistic Graphical Models, Non-parametric Modelling, Scaling Bayesian inference algorithms and applications involving probabilistic models.

Confidential

Database Administrator & BI Lead

Responsibilities:

Confidential

Database Administrator & BI Lead

Responsibilities:

Creating, executing, debugging, problem analysis & troubleshooting stored procedures, functions, triggers, and creating solutions.
24x7 Production Support, customer interactions
Maintaining SQL active/active and active/passive clusters
Bulk Insert, and BCP.
Performance tuning and query optimization, SQL Profiler, Dashboard, and the DMVs.
Work closely with the Infrastructure Management teams (storage, network, UNIX, backup)
Administered the 60 GB “hub” databases used in customer care, authorization and claims management. Was production support DBA Participate in on-call support rotations
Tuned the databases resulting in a 10% performance boost (20% is excellent).
Administered and provided production DBA support to the several databases of Financial Data Warehouse.
PowerQuery / PowerPivot/Powerview/PowerMap, Report Builder for Data Analytics and Reporting.

Confidential

Database Administrator & BI Lead

Responsibilities: