We provide IT Staff Augmentation Services!

Bi/dba/architect Resume

SUMMARY:

  • 10+ years solid Architect/BI/DBA experience with SDLC, ITIL, Agile, Scrum, Six Sigma …
  • MCTS certificate on Business Intelligence - SSIS/SSRS/SSAS and MCTS on Windows/Active Directory;
  • Oracle certified SQL Expert; Oracle certified Database Associate; Oracle 9i, 10g,11g, RCA; PMP
  • Master degree in Computer Science (Thesis: Data & database research) (+Business Admin Minor), USA
  • Extensive experience in multidimensional data modeling, such as star schemas, snowflakes, normalized and de-normalized models, handling "slow-changing" dimensions/attributes
  • Skills on DB conceptual/logical and physical data modeling(3NF) with SSMS, Erwin, ER/Studio, Visio
  • Solid skills on data sourcing & data mapping, ETL/ELT, migration with Informatica/SSIS/Erwin/ER/Studio
  • Strong experience on RDBMS Database design/development/administration, forward engineering /reverse engineering, Normalization/Denormalization, Data Warehouse/Mart, Dimensional, Logical and Physical Design, object alteration, Bulk Insert, backup/restore/recovery, Storage Capacity Planning/SAN and database patch/service pack updates;
  • Skills on Data/Database, ETL/ELT, HL7, HIPAA, Clinical/Healthcare systems, Insurance systems
  • Experience with Autosys/Control M job, Full Text Search, stored procedure, function, trigger, table, view, index, PowerShell, .Net & SQL, performance tuning/optimization, schema changes and data/DB migration
  • Experience of high availability(HA) solutions including log shipping, replication, SQL Always-on Availability Group (AG), database mirroring & SQL failover clustering (up to 6 nodes), clouds, Oracle RAC
  • Experience with BI, Data Visualization/Analysis/reporting(SSIS/SSAS/SSRS), DB2, Oracle, Aurora, MySQL, Hadoop, Big data, Access, IaaS, PaaS, SaaS, AWS, GCP, Azure Cloud, DMS, Tableau, PolyBase, NoSQL, Data Warehouse/Mart, space management, DR, ETL, BCP, Informatica, Erwin
  • Strong presentation, communication, troubleshooting, problem-solving, teamwork and interpersonal skills
  • Experience of working in Global Delivery (Onsite - Nearshore - Offshore) Model
  • 24X7 production on-call support rotation experience

IT SKILLS/KNOWLEDGE:

  • Informatica, Erwin, ER Studio, Crystal, AWS, Azure Cloud, DMS, PolyBase, Big data, Hadoop, Hive, Spark, Pig, Apache, Tableau, Couchbase, mongoDB, MapReduce, Google BQ/Big Query, NoSQL, Proc SQL,N1QL, XQuery, SAS, MS Project, Visio, Visual Studio.NET, Red Gate, Idera, LiteSpeed, Scom, Hyper-V, VMware, HPSM, Oracle CRM, IBM SM, Allscripts/Eclipsys, SCM, Cerner, Spotlight, IIS, VSS, PPT, UML, SAP, TFS, PVCS, Biztalk, SharePoint, Exchange, ERP, TTCN, MATLAB, HL7, Access, Excel
  • SQL Server 2017/2016/2014/2012/2008 R 2/2005/2000/7.0 ,Oracle9i/10g/11g,MySQL,Sybase, DB2, PostgreSQL, Aurora
  • TSQL, PL/SQL, MS.NET, C#, C/C++/ VC++, VB, VBA, Java, HTML, XML, ASP, JSP, JavaScript, Perl, R
  • HTTP, TCP/IP, FTP, Named Pipes (NP), Shared Memory (SM), VIA
  • Windows Server 2014/2012/2008/ 2003/2000 Advanced Server/2000 Server/Windows 2000 Professional/Windows NT 4.0 Server/Windows10/8/XP, UNIX (Sun Solaris, AIX)/ Linux

EXPERIENCE:

BI/DBA/Architect

Confidential

Responsibilities:

  • Oracle certified SQL Expert; Oracle certified Database Associate; Oracle 9i, 10g,11g, RCA; PMP
  • Master degree in Computer Science (Thesis: Data & database research) (+Business Admin Minor), USA
  • Extensive experience in multidimensional data modeling, such as star schemas, snowflakes, normalized and de-normalized models, handling "slow-changing" dimensions/attributes
  • Skills on DB conceptual/logical and physical data modeling(3NF) with SSMS, Erwin, ER/Studio, Visio
  • Solid skills on data sourcing & data mapping, ETL/ELT, migration with Informatica/SSIS/Erwin/ER/Studio
  • Strong experience on RDBMS Database design/development/administration, forward engineering /reverse engineering, Normalization/Denormalization, Data Warehouse/Mart, Dimensional, Logical and Physical Design, object alteration, Bulk Insert, backup/restore/recovery, Storage Capacity Planning/SAN and database patch/service pack updates;
  • Skills on Data/Database, ETL/ELT, HL7, HIPAA, Clinical/Healthcare systems, Insurance systems
  • Experience with Autosys/Control M job, Full Text Search, stored procedure, function, trigger, table, view, index, PowerShell, .Net & SQL, performance tuning/optimization, schema changes and data/DB migration
  • Experience of high availability(HA) solutions including log shipping, replication, SQL Always-on Availability Group (AG), database mirroring & SQL failover clustering (up to 6 nodes), clouds, Oracle RAC
  • Experience with BI, Data Visualization/Analysis/reporting(SSIS/SSAS/SSRS), DB2, Oracle, Aurora, MySQL, Hadoop, Big data, Access, IaaS, PaaS, SaaS, AWS, GCP, Azure Cloud, DMS, Tableau, PolyBase, NoSQL, Data Warehouse/Mart, space management, DR, ETL, BCP, Informatica, Erwin

Hire Now