Candidates About

 

Jermaine D. Cross

PROFESSIONAL SUMMARY

I am seeking a development position in Information Technology with the focus on SQL Server Database Administration and BIDS/SSMS.  I am highly motivated with strong analytical skills and understand complex business processes. My technical skills include systems optimization, SDLC, database design and administration, database optimization, business processes improvements, customer satisfaction and employee mentoring and training. I have excellent technical writing skills which I have prepared user manuals and procedural documentation.

WORK EXPERIENCE

 

Position: Database Engineering/BI Manager                                                             6/14 to present

Senior SQL (DBA) Database Administrator/Developer/Analyst             

                       

*Company: AmTrust Financial Services – Corporate Offices

            800 Superior Avenue                                                                          Supervisor:

            Cleveland, OH 44114                                                                         Anuj Gupta

            (216) 328-6100

 

SQL Azure on Microsoft Azure – Cloud Architect & Development

 

• Support for Microsoft Azure IaaS and SQL Azure DBaaS Environments
• Cloud/On-Premises database management
• Synchronization using Data Sync toolset
• Review and document PaaS migration strategies
• Database design and development using SQL Azure, SQL Server, Microsoft Access
• Experience with Agile/Scrum and Waterfall software development methodologies
• Create linked services, datasets, pipelines and data factories per LOB

 

SQL Server Development – Data Services

 

• Reinsurance Project
  • Visual Studio 2015 - SSIS Packages/SSRS reports/SSAS cubes
  • SQL Server 2012/2014/2016
  • Excel import/export transfer to SQL Server  
  • Visio data diagrams for business process workflows
  • Manage 8 to 10 employees
  • Remote Desktop Connection for server connectivity
  • Multiple Environments – DEV, TEST and PROD
  • Advanced stored procedures including dynamic SQL
  • Administration and Security – create and assign db roles
  • Create and schedule SQL Jobs
  • Visual Studio Team Services
  • Implemented best practices for SQL script writing and package configuration

SSIS ETL – LOBs

 

• Designed complex ETL strategies to pull data from various sources like SQL Server, flat files, Excel files and Oracle databases and load into destination databases utilizing different types of transformation
• Designed high level ETL Architecture for overall data transfer from the source server to the Enterprise Services Warehouse including server names, database names, accounts, tables and direction of data flow, column mapping, data dictionary and Metadata.
• Implemented stored procedures and enforced business rules via checks and constraints
• Created new SSIS packages and implemented those packages in DEV, TEST and PROD
• Monitored SSIS packages for performance analysis and data optimization
• Implemented Master Child package model for easier maintenance, reusability and better performance
• Implemented the logging process for all SSIS packages for troubleshooting and traceability
  • Auditing and tracking package runtimes
• Involved in data profiling, identifying data quality issues thru data analysis, impact analysis and data model enhancements
• Involved in development phase scrum meetings for business analysis and requirements gathering with department managers and users
• Developed Data Mapping, Data Governance and transformation and data cleansing rules for Master Data Management Architecture involving OLTP/OLAP
• Used TFS for version control and moving code from one environment to another environment

 

SQL Server Development – Global EDI

 

• Sunset Project
  • Visual Studio 2015 – SSIS Packages
  • Build File Layouts and Data Points
  • File Monitor Import custom application tool
  • Prepare SQL scripts to run in all environments
  • ETL and data feeds/over 25 LOB’s
  • Developed, implemented and evaluated metadata and cataloging workflows and standards
  • VB.NET and C# script task coding
  • SQL Server 2014/2016
  • Performance tuning and monitoring
  • Tracking of data bottlenecks and blocking
  • SQL Server Profiler
  • Manage 6 to 8 employees
  • 600 Servers with terabytes of data
  • International client-base
  • Advanced stored procedures including catch try and raiserror messages

 

Oracle Financial ERP Cloud

 

• Financial implementation of AR, AP, GL, HR, INV and Payroll
• Analyze business needs for client objectives
• Oracle software solutions for ERP Cloud
• Increase productivity with best practices and automation of tasks
• Develop, design and implement custom reusable solutions with Oracle Products for multiple LOBs
• Added visibility and analytical capabilities for business decisions
• Financial reporting thru ad hoc analysis
• Setup and configuration of on-premise solutions
• Working knowledge of Oracle Fusion Applications Release 11 middleware development tools
  • Oracle Business Intelligence
  • Oracle Application Development Framework (ADF)
  • Oracle Identity Management
  • Oracle Access Manager
  • Oracle Cloud Adapters
  • Oracle Data Integration
  • Oracle Golden Gate Studio
  • Oracle SOA Suite

 

Microsoft Dynamics CRM (2016)

 

• System integration
  • SSIS Integration Toolkit
  • Change tracking synchronization
• Configuration, customization and administration
  • Dashboards with KPI’s
    • System and personal dashboards
  • Views and forms
    • System and personal
  • Business processes and workflows
  • Activity tasks
  • Security and administration
  • Data management and auditing
• Provide mentorship and training to other team members

 

Position: Database & Maintenance Manager                                                             9/06 to 6/14

Senior SQL (DBA) Database Administrator/Developer/Analyst             

                       

*Company: Jewish Family Services Association – Corporate Offices

            3659 South Green Road                                                                     Supervisor:

            Beachwood, OH 44122                                                                      Timothy Williams

            (216) 292-3999

                                                                                                           

Development Strategies

 

• SCRUM – holistic approach by one cross-functional team with 15 min daily meetings with incremental deliverables, steps including analyze, design, develop, test, technical communication and document
• SDLC (System Development Life Cycle) – a process to develop an information system, training and user ownership, a model or sequential methodology steps including planning, design, implementation, testing, acceptance, maintenance and disposal
• AGILE – individuals and interactions over processes, working software, customer collaboration and responding to change, software development methodology steps including iteration modeling, requirements, design, execution, testing, refactor and deployment

 

Department Interaction & Process Knowledge

 

• Finance – Electronic Reconciliation to General Ledger
• Human Resources – Importing and exporting data to and from Ceridian, employee training
• Scheduling – (Angel) Real time verification of time with schedules
• Care at Home/MRDD – Billing of RAP’s and Final Claims of skilled and unskilled episodes of Medicare and Medicaid, Referral Management
• Quadax claims processing and medical billing
• Meals on Wheels – Driver logs and meal counts with destination of clients
• Lifeline - Client tracking of primary and secondary contacts for emergencies
• Marketing – demographics for grant writing

 

SQL Server Development & SQL Server Administration/ Teradata Environment

 

• Strong leadership and analytical skills in database management, data modeling and architecture
• Lead a team of IT employees to accomplish multiple complex projects and tasks
• SQL 2000/2005/2008R2/2012R2/2014/2016 CTP
• Create complex stored procedures, triggers, views, tables and indexes
• Design and develop DTS and SSIS packages and Active Objects
• Ensure database integrity, reliability and availability of business data stored in production
• Manage database security and control access permissions and privileges
• Data replication, restore, backups, mining and warehouse
• SSAS OLAP cubes, dimensioning and hierarchies
• Create and schedule jobs
• T-SQL – utilize cursors, select, insert into and update statements
• Performance tuning, monitoring, execution and maintenance plans
• Design and implement preventative maintenance checks and services plans
• Manage buffering and distributed data
• Perform proactive review of systems performance metrics and alerts
• Trend analysis using statistical aggregation and metric rollups
• Database server usage and capacity analysis to minimize outages and performance issues
• Create Windows Failover Cluster shared on a SAN
• Disaster Recovery Plan
• Document database and server configurations

 

SQL Server Business Intelligence Development Studio

 

• Business Intelligence 2005/2008R2/2012R2
• SSIS – integration services – packages extracting and loading data
• SSAS – analysis services – OLAP cubes, data warehousing, data  mart, data mining
• SSRS – reporting services – drilldown, tabular, matrix, sub reports, cached and snapshot reports

 

OLAP Cubes – Business Finance Projects

·         Demographics (Grant Writing & Marketing)

o   Dimensions – Age Bracket, City, Ethnicity

o   Measure – Date

·         Meal Deliveries (Scheduling)

o   Dimensions – Drivers, Zip Code

o   Measure – # of Meals

·         Medicare/Medicaid Revenue (Billing Reconciliation)

o   Dimensions – Client, Insurance Type

o   Measure – Amount Billed, Amount Paid

 

 

 

SQL Azure

 

• SQL Server Data Tools/SQL Server Data Sync
• Windows Azure Management Console/Portal
• High Availability in the Cloud
• Database creation on virtual servers
• Configuration with allowable IP addresses
• Visual Studio 2013 project migration

 

IBM Z/OS Mainframe Development and Database Administration

 

• Responsible for systems programming support for Z/OS, CICS, DB2, VTAM, security and storage administration
• Responsible for all aspects of systems programming support for 45+ DB2 subsystems running in a large Data Sharing Monoplex, Sysplex and Parallel Sysplex environments
• Isolated CICS and DB2 transaction bottlenecks using TMON/CICS. TMON/DB2, CICS PA DB2 PM and SMF data analysis
• Utilized modeling tools (Best/1, PerfMon) to forecast resource requirements and justify hardware upgrades to meet business service levels ad future workload needs
• Presented workload trends and growth forecasts to upper management using Excel charts/graphs and PowerPoint presentations within high volume production systems
• Supported TCP/IP, including SMTP and FTP

 

MySQL Sever Development and Database Administration

 

• MySQL 4.x/5.x
• Performance tuning, query optimization and client server connectivity
• Expertise snapshot, import/export and db optimization
• Installation and configuration on Windows environments
• Designed databases for referential integrity and involved in logical design planning
• Performance tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor
• Created data extracts as part of data analysis and exchanged with internal staff
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master
• Managing database clustering
• Documented all servers and databases
• Developed stored procedures, triggers in MySQL for lowering traffic between servers and clients
• Administration and management of the entire development, QA and production environment

 

VB.Net & ASP.Net

 

• Visual Studio 2008/2010/2013
• Create data connectors, datasets and classes
• Design forms and relational diagrams
• Build queries using ADO.Net and LINQ to SQL
• Develop modules, methods and functions
• Error handling and debugging and utilizing conventional naming schemes
• If statements and select case statements
• Deployment and updating using MSI packaging for .NET applications
• Access Client Distribution via network per application per cpu

Microsoft Access/Excel/VBA

 

• Office 2003/2007/2010/365
• Create forms, queries, reports, macros and modules
• Advanced functions written in VBA code
• Utilization of pass thru queries to execute stored procedures
• ODBC connectivity to SQL Server
• Creating charts and pivot tables
• Advanced formulas, functions and formatting techniques
• Using workbook templates, linking spreadsheets and data validation

 

SharePoint

 

• SharePoint 2003/2007/2010/2013
• Setup user rights, permissions and list items
• Configure document library settings and utilization of web parts
• Creating and managing sites and hierarchy
• Document and meeting workspaces
• Surveys and discussion boards

 

Languages

Visual Basic, ASP.NET, VB.NET, XML, VBA, SQL, T-SQL, PL-SQL, VBScript, JavaScript, HTML, PHP

 

Software

InfoPath 2003, SharePoint Services 2003/2007, SharePoint Portal Server 2003, iMacros, HIPAATalk, CodeCharge 4.3 Studio, Angel, Case Complete, .NET 2003/2005/2008/2010, .NET Framework, BizTalk2009, Net Beans 6.7, IIS 6.0/7.0, Active Directory, LDAP, Web Services, ASP.NET, C#

Custom Applications

(CAH) Care At Home

(MRDD) Mental Retardation and Developmental Disabilities

(SNAP) Skilled Nursing Assessment Program – UB-92, UB-04, ICD-9, 485

(RMS) Referral Management System

(CARF) Commission on Accreditation of Rehabilitation Facilities

(MUI) Monthly Unusual Incident

(ERN) Electronic Remittance Notices

(HDM) Home Delivered Meals

(TSS) Time Sheet System

(BVR) Bureau of Vocational Rehabilitation

(CATS) Control Access for Triggering Stored Procedures

(MEMS) Managers Employee Management System

(DEAP) Demographic Enrollment Analysis and Planning

(PEP) Parent Education Program

(ETC) Employee Training Compliance

(CCI) Cost Center Interchange

(HLR) Help Line Responder

(HSUB) Holocaust Subsidy

(MCP) Monthly Capitation Payments

 

Web Based Applications

Ascentia Pass Notes

Time Capture System

Europa Cafe

Angel IVR – Interactive Voice Response

 

Intranet Custom Applications

IT Project Request, Purchase Order Request, Help Desk Ticket System

 

Application Packages Utilized

Vividcare Care at Home/Vividcare MRDD

MAS90/200

Prod Echo

HAVEN 7.1/8.0/8.1/10.1/10.2/10.3/10.4/

HelpSTAR 2010

PPS Plus Software – Coding & OASIS support and HHRG scoring, Case-Mix

 

Government Text Files

·         835 Healthcare Claim Payment Advice

·         837 Healthcare Claim Institutional

·         997 Functional Acknowledgement

·         HL7 Health Level Seven

 

Position: Senior SQL/Oracle (DBA) Database Administrator/Developer/Analyst 9/04 to 9/06    

*Company: Rockwell Automation – Technical Support Center (Manpower Technical)

6680 Beta Drive                                                                                  Supervisor:

Mayfield Heights, OH 44143                                                             Robert Rodriguez, Scott Owen

440-646-7900                                                                                      rodriguez@ra.rockwell.com

Clarify and RSSS

 

• Developed and designed
• QA testing.  Lead the team in defining QA processes and test planning standards
• Provided support to proprietary software

 

SQL Server 2000/2005

 

• Complex stored procedures including cursors and advanced T-SQL statements
• Creation and conversion DTS/SSIS packages
• Performance tuning & maintenance plans
• Backups and Recovery
• Database administration and configuration

 

Oracle 8i/9i

 

• Performance planning
• System architecture
• Data Modeling
• Workload testing
• Automated database maintenance tasks
• Monitoring and Improving application performance

Microsoft Access XP

 

• Designed and developed
• Phone Directory application
• More efficient way for the call agents when transferring calls to other support engineers
• Support and trouble-shoot

 

RS Products

 

• RSLinx
• RSView ME/SE
• RSView Studio
• RSLogix 5/500/5000
• RSSQL
• RSBizWare
• Historian

 

Activations

 

• Factory Talk Activation Server and Client

 

Pico Controller

 

• Pico Soft support and programming
• Used DSN’s: OLE DB and ODBC connectivity to databases
• SQL Server 2000/2005

 

Position: SQL (DBA) Database Administrator/Technical Support Specialist         9/03 to 9/04

*Company: University Hospitals of Cleveland - Lowman Building (Bell Tech Logix)

            11100 Euclid Avenue                                                                         Supervisor:

            Cleveland, OH 44106                                                                         Matt Stuttin

Database Administration – SQL Server 2000

 

• Maintain SQL 2000 databases
• Create stored procedures
• Data replication
• Performance Tuning
• DTS Packages
• Maintain MS Access 2000 databases
• Convert Excel spreadsheets from accounting to access databases
• Create tables, forms and reports

 

Help Desk Support

 

• Action Request System
• Update securities, privileges and user rights
• Configure and map drivers of shared folders
• Update pcs with new McAfee Virus Scan 7.0 and SP3
• Setup and add printers to network
• Log data and comments in Remedy AR system
• Setup Data Card printer through coax interface and preset controllers

 

Imaging