We provide IT Staff Augmentation Services!

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:

  • Optimizing distributed Transactions and Locks
  • Enterprise Policy Management / Centralized Management
  • Data Quality and Master Data Service Design and Implementation
  • Group Policy and Active Directory object management

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:

  • PRO-ACTIVE MONITORING
  • MAINTENANCE/ADMINISTRATION
  • DATABASE/EBS PERFORMANCE TUNING
  • PATCH INSTALLATION
  • DAILY SUPPORT TO APPLICATION SUPPORT TEAM
  • CODING & SYSTEM REPORT
  • CLONING, MIGRATION, SCRIPTING, PERFORMANCE ENHANCEMENT
  • ADHOC BACKUPS AND RESTORATION REQUESTS
  • DEVELOPED MORE THAN FIVE THOUSAND(PROCEDURES, TRIGGERS, VIEWS, FUNCTIONS)

Hire Now