We provide IT Staff Augmentation Services!

Ms-power Bi Architect/sql Developer Resume

SUMMARY

  • I have over 16+ years of experience Programming Databases and Data Modeling using MS - SQL, Oracle, PL/SQL, T-SQLNZ-SQL and others.
  • I have extensive experience in administration and optimization of Oracle and MS-SQL
  • BI Stack (SSIS/SSAS/SSRS) systems.
  • Use of IBM Netezza 7.0 Pure Data System HA (High Availability MPP Massive Parallel Processing) and Snowflake Cloud Data Warehousing and Hadoop DBMS and Apache Spark work with the following Data Warehouse/Visualization Tools: SiSense, SiSense Elastic Cubes, SiSense Data Visualization Tools, Tableau 9.0 Desktop, Tableau Online, MS-Power BI Desktop, MS-Power BI Designer, MS-Power BI Analysis Services, NDM Data Transmission, KPI, Domo Cloud, Cloudera, Qlik Sense Cloud, QlikView Scripts, Qlik Sense Desk Top, Pentaho, SAP HANA, Embarcadero ER Studio Data Architect version 10.0, Pearl Script in Linux for Autonomous Operation (Machine Learning)

TECHNICAL SKILLS

Languages/Tools: Visual Basic.Net, C#, ASP.NET, ADO.NET, VB Script, ASP, XML, XSLT, JAVA, JSP, Informix 4GL/ESQL/Online, C/C++, AWK, VBA, MS Visual Source Safe (VSS), Enterprise PowerBuilder 5.03/6.0/6.5/7.0/8.0 , PowerBuilder PFC, Stored Procedures, Oracle Developer 2000, Oracle Forms 6.0, Assembler, RPG II, SAP, Gupta SQL Windows/Centura, Active-X, SAP Crystal Reports, GURU ODBC, Oracle PL/SQL, PL/SQL Developer, Tuxedo, Visio 2000, Delphi 3.0/5.0, CICS, COBOL, Transact-SQL (T-SQL), SQL Triggers, UNIX Shell Scripting, MBNA SDM Training, Crystal Enterprise, SDLC, AppForge for Visual Basic 6.0, VSTO, TELNET, SHIVA Remote, PowerPoint, MS Project, XML, Patriot Officer, CISCO WebEx, GoToMeeting, BCP, CoreFTP, SAP Business Object, SAP Business Objects Universes, Pearl Script in Linux for Autonomous Operation (Machine Learning)

Web/Tools: MS-Visual Studio 2005/2008/2010/2013/2015 , AJAX,MS-Web Developer 2008, MS-Visual Interdev 2000/2005/2008 , MS Visual Studio 6.0, COM/COM+/DCOM, XML, XSLT, ASP, VSTO, ASP.NET, ADO.NET, C#, VB Script, Front Page 2000, RDO, DAO, ADO, MS Visual Studio.Net, Web Classes, PERL, Oracle Webb, DHTML, Cascading Style Sheets(CSS), ColdFusion 4.0/4.5/MX, Homesite 4.0/4.5, JavaScript, JAVA, IIS, MTS, Oracle 9iAS, Dreamweaver Ultradev, Adobe Acrobat, Macromedia Flash 4.0/5.0, Palm Web Clipping, FTP, TCP/IP, J-Run, J-Runner, PaperFree, AppForge for Palm Development, TOAD, Emc2Documentum, APACHE, TOMCAT, HTML, Photoshop, BizTalk Server 2000, Oracle Application Express (APEX), JWalk, SunGard LDRPS, Tortoise SVN Version Control Software, RedGate SQL Compare/SQL Prompt Tools, Cybermation Agents for Mainframe, Vignette Application and VCM with WebLogic Servers and Windows 2003/2008 Clusters for Web Portal Support, Team Foundation Server (TFS 2013), JIRA/GIT/Confluence tools, MS SharePoint, HP PolyServe to Management Multiple Clustered Database Servers for MS SQL Server and Oracle 11g

Databases: Oracle 7/8/8i/9i/10g/11i/12c, Oracle 10g Express (Oracle Database XE), Oracle Lite, Oracle OEM/OEM Enterprise Manager Console, MS-SQL Server 6.0/6.5/7.0/2000/2003/2005/2008 R2/2012R2/2014, Sybase 10/11, DB2, Sybase EA-Server, Informix, Access 2000/2003/2016 , MS AZURE Cloud Platform, Use of Multiple SQL’s (Oracle: PL/SQL, MS SQL Server: T-SQL, DB/2: ISQL, SQL/DS, IBM Netezza: NZ-SQL), MongoDB, NoSQL, MariaDB, Amazon Redshift Database (AWS), MS Azure Cosmos DB, HIPAA (Health Insurance Portability and Accountability Act)

Data Warehousing: MS SSIS, SSRS SSAS, MDX, MS-SQL Analysis Services, IMPROMPTU, Cognos QUIZ, Oracle Discoverer 3i/4i/9iAS RELEASE 2, Rational Rose, BRIO, Computer Associates -Erwin 7/9.0, Visio 2013, Informatica PowerCenter, ERD Diagrams, IBM Netezza 7.0 Pure Data System HA (High Availability MPP Massive Parallel Processing), SAS, Aginity Workbench for Netezza 4.1, Netezza Administrator, Informatica Workflows, FISERV, Fiserv InformEnt PowerShare Information Manager/InformEnt Knowledge Share Administrator, Nautilus Client and Pivot Tables, SAS, Tableau 9.0 Desktop, Tableau Online, MS-Power BI Desktop, MS-Power BI Designer, MS-Power BI Analysis Services, MS Power BI DAX, NDM Data Transmission, KPI, SiSense, SiSense Elastic Cubes, SiSense Data Visualization Tools, Domo Cloud, Cloudera, Qlik Sense Cloud, QlikView Scripts, Qlik Sense Desk Top, Pentaho, SAP Business Objects Data Services (BODS) Embarcadero ER Studio Data Architect version 10.0, Pearl Script in Linux for Autonomous Operation (Machine Learning), Snowflake Cloud Data Warehousing, Hadoop, Apache Spark, SAP HANA, SAP Crystal Reports, PostgreSQL

Environment: s: SUSE Linux 9.0, UNIX, SCO XENIX, HP/UX, Client Server, AIX, SUN SOLARIS, Data Warehousing, MS/ XP, MS VISTA, Windows 7, MS AZURE Cloud Services, Oracle VM Virtual Box, IBM Netezza Pure Data Systems 7.0, Citrix Xen Desktop Virtual Environment, Amazon Web Services (AWS Cloud Environment), LDAP, SolarWinds DPA for Virtual Environments, Linux

PROFESSIONAL EXPERIENCE

Confidential

MS-Power BI Architect/SQL Developer

Responsibilities:

  • Blackbaud Systems
  • MS SQL Server 2012, Tableau 9.0 Desktop, PaaS/SaaS
  • MS Azure Database, MS Azure Cosmo DBA/MS Azure Data Lake/Warehouse environments
  • MS C# Language for writing code to Update the MS Azure Cloud Databases
  • MS SQL Stored Procedures, DAX Programming of Forms
  • SSIS Data Loading into MS Azure Database Lake/Warehouse Environment
  • Training staff of how to create Stored Procedures and Power BI Reports/Dashboards
  • Training the staff of how to use the Power BI Systems

Confidential

SSRS Reports Developer/SQL Developer

Responsibilities:

  • Strong experience developing and using SQL Server Reporting Services (SSRS) reports using SSRS development tool (based on Visual Studio), code behind SSRS reports and Data Models, and associated SQL query creation.
  • Use of JD Edwards Systems using an IBM AS400 System Data Source
  • Use of MS SQL Server for Development of (Stored Procedures, Queries, Views, Etc.)
  • Understanding of Windows Security Principles.
  • Good writing skills to help in writing specifications and testing documentation.
  • Familiarity with regulated with environment and related validation testing requirements is helpful (such as GxP Manufacturing), but not required.

Confidential

Data Modeler/Data Analyst/Reports Developer

Responsibilities:

  • IntApp Flow Training for Data Visualization. Will upgrade and migrate all Business Survey Processes to Workday systems
  • Creating Documentation for all Systems Data Flows for conversion to Visio Data flows.
  • Use of the following Technologies:
  • MS BI Stack SSIS, SSRS, MS SQL Reports Server, MS SQL Server 2016, MS Visual Studio 2016, MS Visio 2016 Professional, Workday systems conversions
  • MS T-SQL, MS ACCESS, MS T-SQL Stored Procedures, MS SQL Triggers
  • IntApp Flow Data Visualization Tools
  • Performs other job-related duties as required.
  • Scrum/Agile Environment

Hire Now