We provide IT Staff Augmentation Services!

Senior Ms Bi Consultant/dba (contract) Resume

2.00/5 (Submit Your Rating)

SUMMARY:

  • A wide experience in a Information Technologies software development in various fields including business and system analysis, design, development, deployment, testing, implementation and long term software support.

TECHNICAL SKILLS:

Business Analysis Methodologies, Environments, and Tools: BizTalk Server 2004/2006 Built - In Tools (Orchestration Designer, Editor, Mapper, Explorer, Business Activity Services - BAS, Business Rules Engine - BRE); BizTalk 2004/2006 Orchestration Designer for Business Analysts (Add-In for Visio 2002/2003); Service-Oriented Architecture (SOA) for Enterprise Application Integration (EAI)Systems Analysis and Design Methodologies, Environments, and Tools: Distributed System Designers in Visual Studio 2005 Team Edition for Software Architects; MS Visual Database Tools/Server Explorer for MS SQL Server and Oracle database designBusiness Intelligence (BI) Methodologies, Environments, and Tools: Business Activity Services (BAS) and Business Activity Monitoring (BAM) in BizTalk 2004/2006/2008 ; Business Intelligence Development Studio in MS SQL Server 2005/2008/2012/2016 Analysis (SSAS), Reporting (SSRS), Integration Services (SSIS), Master Data Services (MDS), Data Quality Services (DQS) and Data Transformation Services (DTS) as part of MS SQL Server 2000; MS Excel (Pivot Tables), MS Power View/Pivot, Query; MS Power BI Desktop and Service

RDBMS and Related Technologies: Client-Server; MS SQL Server /2005/2008/ 2012/2014/2016 ; SSIS, SSRS, SSAS, MDS, DQS; Oracle 10g DB; ADO.NET / ADO (including RDS), OLE DB, ODBC for data exchange with different data sources including MS SQL Server and Oracle DBs; MS Access 2.0-2013; FoxPro

Internet Related Technologies and Tools: Multi-Tier Architecture; MS IIS 5.0/6.0;

Visual Studio.NET 2002: 2013; Windows SharePoint Services 2.0/3.0 for Windows Server 2003; MS Office SharePoint Server 2007 including Business Data Catalog, MS SharePoint Server 2010/2013; ADO.NET, XML, VBScript, MS Office Professional 2000/2016, Office Web Components; Web Services; MS Office 365, MS Azure

Languages & Development Environments: Visual Studio .NET 2005 Team Edition for Software Architects / Visual Studio Team Edition for Database Professionals / Microsoft Test Manger/ Visual Studio 6.0-2015; Team Foundation Server; Visual SourceSafe; VB.NET, .NET Framework 1.1/ 2.0/3.0/ 4.0, SQL (including such dialects as Transact-SQL and PL/SQL), MDX, XML, BizTalk Server 2004/2006 Development Environment and Tools (Editor, Mapper, Orchestration Designer, Explorer, BAS, BAM, BRE, C#); Visual Basic for Applications (VBA), VBScript, Mercury Quick Test Pro, COBOL, FORTRAN, PL1

Operating systems and Related Tools: MS Azure, Windows Server Enterprise, Windows 2000 Advanced Server, Windows 2000/XP Professional, Windows Vista Ultimate, Windows NT Server 3.5-4.0, Windows 95/98/Me, Windows 3.x, MS DOS; Virtual PC 2007; Virtual Server 2005 R2; Hyper-V, Windows Mobile 2003/5/6/7, Unix, MS Azure

Networks: TCP/IP, IPX/SPX, NetBEUI; heterogeneous networks (Windows, Unix, Novell Netware)

PROFESSIONAL EXPERIENCE:

Senior MS BI Consultant/DBA (Contract)

Confidential

Responsibilities:

  • Day to day support of SQL Server servers (Dev, QA, Prod), DBs, and SharePoint Servers. Monitoring, upgrades, deployments. SharePoint BI sites management. Migration SQL Server .
  • Data analysis and design of DW solution for Parks, Forestry and Recreation Department using MS SQL Server 2012/2014/2016 including SSIS with MDS and DQS, SSRS, SSAS. Design, load and support SCD 2 type dimensions.
  • Implementing Master Data Management Solution for maintenance of several Dimensions and mapping tables using MDS and Excel MDS Add-in.
  • Inferred Dimension Members support within MDS and SSIS. Setup MDS models deployment processes. Reports design using MS Power View, Query and Pivot.
  • SharePoint BI functionality. Microsoft Test Manager integrated with Team Foundation Server implementation for SSIS/SSRS solutions development. Power BI with Azure reporting. DWH Modelling using Erwin Data Modeler.
  • Migration of on-promise SQL DW to Azure by moving existent VMs to cloud (IaaS). Provisioned the Azure-SSIS Integration Runtime in Azure Data Factory. Migration of Ferry DW from on-promise to the cloud Azure SQL DB (DBaaS). Redesigned SSIS ETL solution in Azure Data Factory.

MS Azure Architect/Developer (Contract)

Confidential

Responsibilities:

  • Confidential is Canada's largest direct online-only mattress store. Designed Azure SQL DB (DBaaS). Integrated Shopify online store with Azure DB using Azure Data Factory.
  • Deployed SQL 2017 VM in Azure, Blob Storage and Automation Account.
  • Implemented a system that integrated Confidential SQL DB, Shopify (3-d party e-commerce web application), ERP system (3-d party ERP solution), ESI, UPS (Shipping company). Designed several reports (Power BI, SSRS and Excel) helping to identify discrepancies in orders shiping.
  • Deployed Azure Data Storage account for data integration. Deployed framework for implementing “learning machine” solutions for advertisements/sales performance predictive analysis.
  • Developed MS Power BI and SSRS 2017 shipping cost analysis and projection reports. Day-to-day Azure environment support and administration. Azure subscription cost analysis and optimization.
  • Migration from Profit Key ERP system to Epicor. ProfitKey reports changes and development. Day to day SQL server and DB applications support and maintenance.
  • SQL DBs performance turning. Share Point Server installation, configuration, and administering.

Senior MS BI Consultant (Contract)

Confidential

Responsibilities:

  • Data warehouse modeling and ETL SSIS development on EDW project.
  • Integration of Guidewire application with insurance EDW.
  • Very complex transformation of XML type SQL columns.
  • SSRS Reports development with SSAS and SQL DB data sources.
  • Policy, Claim and Billing Center reports development.
  • Day-to-day solution support in Dev, QA and Production environments.

Senior MS BI Consultant (Contract)

Confidential

Responsibilities:

  • Business analysis, design and development BI Solution for Toronto Central LHIN using SQL Server 2012, SSAS, SSIS, SSRS, Master Data Services, Data Quality Services.
  • Deployment solution into the production environment.
  • Day-to-day support ETL jobs, OLAP and SQL DDBs.
  • Designed ETL processes using SSIS 2012. Modeled DW database. Analyzed and implemented mapping business rules for loads data from very complex source files to the target fact and dimension tables.
  • Implemented data cleansing rules using SQL Data Quality Services.
  • Developed cubes, ETLs, reports, dashboards for 311 project using SQL 2008 R2 (SSIS, SSRS, SSAS).
  • Designed and maintained reports deployment to production SharePoint 2010 environment.
  • Support and maintenance the solution in the production. SSIS packages and SQL DB performance turning.

Senior Database Consultant (Contract)

Confidential

Responsibilities:

  • Designed and developed Liability Risk Metric Database solution using SQL Server 2012 (SSRS, SSIS, SSAS).
  • Automated actuaries day-to-day work replacing Excel/MS Access manipulation with centralized database solution integrated with 3-rd party actuary application Alfa Millennium and MS SharePoint.
  • Deployed MS Office 365 Midsize Business cloud solution. Deployed MS Azure Platform.
  • Migration of on-promises infrastructure to the cloud.
  • Day-to-day SQL Servers and DBs maintenance support.
  • Designed and implemented a disaster - recovery strategy for SQL solution with DB mirroring.

Senior BI Consultant (Contract)

Confidential

Responsibilities:

  • Recently built Anti Money Laundry Data Mart analysis.
  • Complex SSIS packages change and design new packages extracted data from Norkom OLTP (DB2) database and loaded data into BI DB.
  • Implementing change requests related to changes in SSRS reports, SSIS packages, SSAS and SQL databases

Senior BI Consultant (Contract)

Confidential

Responsibilities:

  • Designed and implemented data mart solution using SQL Server 2012. Integrated ADS DMS (Dealer Management System) with new database solution.
  • Designed and build a database that collected data from DMS.
  • Designed number of SSIS packages loaded measure and dimension tables. Designed and build SSAS cube for financial analysis.
  • Designed and implemented several SSRS and Excel reports.
  • Modeled DB using Erwin Data Modeler.

Senior BI Consultant (Contract)

Confidential

Responsibilities:

  • Designed and built SSAS database included multidimensional cubes, dimensions, measures, calculated members for BI reporting solution using SQL 2008 R2 SSAS.
  • Designed and deployed number of SSRS reports using SSAS data source. MDX queries. PivotTable Excel reports with SSAS cube sources. Designed and deployed SharePoint reporting dashboards.
  • SQL Server 2008 R2 new production database application performance problems analysis and turning. Queries and stored procedures changes recommendations.
  • SQL Server Profiler and Database Engine Turning Adviser utilization.
  • DMV utilization. Indexes analysis and changes. Troubleshooting of various database issues. Increased database availability by implementing database mirroring. Disaster recovery testing.

Senior BI ETL developer/DBA (Part-time Contract)

Confidential

Responsibilities:

  • Design and implementation of several daily ETL processes using SSIS and SSRS services of SQL Server 2008 R2.
  • Parsing and loading data from multiple heterogeneous sources such as XML and CSV documents, Active Directory and other SQL Server tables into SQL tables supporting MS SharePoint application (School Bundle Solution). Developing deployment packages for a production environment.
  • Day-to-day SQL Servers and Databases support in a production, QA and dev. environments.
  • A production SQL Server performance turning. Server optimization and DB indexes analysis and turning. Troubleshooting disaster recovery plan. Implementing MS failover clustering.
  • IBM TRIRIGA application support and performance improvement. SQL Server 2008 R2 production database performance problems analysis and turning.
  • Queries and stored procedures changes recommendations. SQL Maintenance Plans design and optimization.
  • SQL Server Profiler and Database Engine Turning Adviser utilization. DMV utilization. Indexes analysis and changes.
  • Troubleshooting of various database issues. Configuring SQL Server Reporting Services for SharePoint Integrated Mode.
  • Design of various ad-hoc reports, subscriptions, reports delivery via e-mail and to SharePoint libraries. “On-call” support. Analysis of business queries of TRIRIGA Service Desk users and prepared the recommendations how to formulate these queries with the best performance.

Senior BI ETL developer/Database Analyst (Contract)

Confidential

Responsibilities:

  • Recently built Insurance corporate data warehouse analysis. Complex SSIS packages changes and design new packages on corporate data warehouse project.
  • Implemented type 2 of Slow Changing Dimension (SCD task and MERGE command in SQL Server 2008).
  • Design and implementation of re-conciliation processes using SSIS and SSRS tools. ETL processes performance tuning. DB Data model support by Erwin Data Modeler.
  • Providing ongoing support of BDirect (Internet Banking), American Airline and British Airways Credit Card s manager, PayPlus and some other applications.
  • Troubleshooting of application bugs and designing post-error recovery procedures in production environment. Database analysis using MS VB, MS Access, SSRS. Complicated SQL queries development.
  • Support and changes of several legacy MS Access and VB 6 bank applications.
  • Migration BDirect application to new hardware from SQL Server 2000 to SQL Server 2008. Migration of DTS 2000 packages to SSIS by installing Run-time and Design-time Support for SQL Server 2000 DTS Packages. Re-design ETLs written on VB 6 and DTS in SSIS.
  • Deployed MS SQL Server 2008 on Windows Server 2008 Hyper-V. Created MOSS 2007 portal (Report Center) with SSRS 2008 in integrated mode and SSIS for day-to-day support about 10 lines of business applications (LOB) using Dashboards with KPI and Reporting Services Web parts.
  • Deployed SharePoint Server 2010 in developer environment and migration existent Report Center sites from MOSS 2007 environment to SharePoint 2010.
  • 3 legacy systems including a core banking system migration from (mainframe and SQL Server 2000 DB) to F-Cube (Oracle 10g DB) using SQL 2008 SSIS and SSRS (reporting) within two countries (Bermuda and Cayman). Oracle DB administering.
  • Increased database availability by implementing SQL Log shipping, DB mirroring and SQL failover clustering.

SQL Server DBA/Developer (Contract)

Confidential

Responsibilities:

  • Provided ongoing support of more then 20 SQL 2005 Servers SP2 in Production, QA and Testing Environments. Long Stay Assessment Software (LSAS) and Common Intake Assessment Tools (CIAT) applications support. Integration of LSAS, CIAT and Assessment Data Store Application (ADS). Data analysis and reports development using SSRS 2005, MS Access, MS Excel (including Pivot Tables).
  • Specific day-to-day tasks include, but are not limited to the following: Perform and document service operations processes and procedures including improving operational practices, organizing and implementing SQL applications upgrades, database maintenance and other daily database and server related tasks.
  • Consulted local architects in using MS .NET Servers (SQL Server 2005 including SSAS, SSRS and SSIS, BizTalk Server 2004/06 including HL7 accelerator) in EAI (Enterprise Application Integration) projects.
  • Architecture, design, and proof-of-concept implementations of several applications using SQL Server 2005 (incl. SSIS), Visual Studio 2005, BizTalk 2004/2006.
  • Configuration of SQL failover environment using SQL 2005 DB Mirroring technology.
  • Pattern architecture and design for integration of CIAT and LSAS applications using SSIS, Service Broker components of SQL Server 2005 and BizTalk 2004/2006.
  • Deployment, configuring and administering of corporate Share Point Services 3.0 and Sites.
  • Design and support of various reports using SQL Server 2005 Reporting Services.
  • Consulting in SharePoint technologies related the client’s intranet transition from WSS 2.0 to WSS 3.0 / MOSS2007. Design multiple windows workflow (WF) using Share Point Designer in WSS 3.0 such as Approval Processes, User Request for special application maintenance.
  • Deploying MOSS2007 (including Business Data Catalog) on Windows Server 2003 and 2008. Web Application Design using Windows Office Live Premium. Evaluating MS SQL Server 2008 Katmai CTP.
  • Upgrade SQL Server 2000 application (LSAS) to SQL Server 2005. Using Upgrade Adviser for Microsoft SQL Server 2005.

Solution Architect/DBA/Developer

Confidential

Responsibilities:

  • Provided outsource service for DoubleClick Inc. (NASDAQ: DCLK, the leading provider of solutions for marketers, advertising agencies and web publishers)
  • I developed and supported the solution for the following DoubleClick's clients:
  • Barnes And Noble, AOL, Staples, Pepsi-Cola, P&G, Orbitz, J.CREW, Brylane, L.L.Bean, Omaha Steaks, Cahners Business Lists, Weight Watchers, Grolier Inc, WebMD, Buy.com
  • Prototype solution for Barnes And Noble (MS Access, VBA, SQL Server 2000 DTS, SQL Server and DTS Objects).
  • .NET Pilot version for Barnes And Noble. The project included:
  • Abuse Report Project included the solution developed using Excel 2000 Pivot Table and Form, SQL Server 2000 (2 servers, 2 databases)
  • File Retrieval Application (FRA) developed for AOl and Orbitz (Retrieves data from FTP in different formats (flat files with variable number of fields and field names from predefined profiles); Parses header matching it with the profile retrieved from a dynamically defined production server/database (accept/reject report and notification, and rejected file on FTP); If file accepted then transferring the file to dynamically created SQL Server table based on the header and the profile, then applying predefined set of business rules to the table for cleaning, validation, correction. Data hygiene report and rejected records on the FTP; Import from the table to the production server

We'd love your feedback!