| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate SUMMARY:Over thirty years of Information Technology experience in the fields of Finance, Healthcare Manufacturing, Utility, Retail and Insurance applications. As a Senior Systems Analyst, Developer and Data Analyst, my background includes experience with mainframe, middleware and server platforms. These experiences include technical design and SDLC, utilizing both Waterfall and Agile Methodologies. Mainframe experience includes an extensive background in most database technologies (IMS, DB2, IDMS and Total), online services (CICS, ADS/O, IMS/DC) and batch coding procedures. Database Services include extensive SQL Server and Oracle experience, utilizing .NET (VB, C#), Python, Microsoft s BIDS (SSIS, SSRS, SSAS), ETL Data Warehousing and Development Tools. In addition to BIDS, exposure to other data warehouse services include Teradata tools, utilities (BTEQ, Fast Load, Fast Export, etc.) and Informatica. Experience includes in support role of Database Administrators with experience in tuning, normalization and de-normalization, data modeling, data warehouse, database and table design.APPLICATION EXPERIENCE:Banking: Card Products, Customer Access Number System, Customer Data, Transaction Services, Banking Data Warehousing, Mortgage Collection. Third Party Mortgage ServicesInvestment Accounting, Portfolio Management,
Healthcare: Patient Accounting, Clinical, Pharmacy, Payment IntegrityInsurance: Long Term Disability, Medical Reporting, Actuarial and Rating, Check Writing, Preferred Provider Operation, Managed Care and Capitation, Claims and Settlement Processing.Manufacturing: Master Name Marketing, Purchasing, Invoicing, Budgeting, Vendor Inquiry, Standard Journal Entry, Plant Job Cost, Order Entry, Marketing and Sales.Financial: Portfolio Management, Bond Trading, Securities, Mortgage Investments, Amortization Early Resolution/Mortgage Collection
Retail: Vendor Item Charge System, Store Systems, GL, Freight ClearingLogistics: Equipment Control, Shipments, Assessorial, Orders and History, Supply ChainUtilities: Asset Information, Nuclear, Transformer and Meter ManagementERP: Fourth Shift 7.3, Fourth Shift 7.5, Baan 4, Baan Ln, MAPICS, MAS200
TECHNICAL:
Languages: COBOL, CICS (Command level), Microfocus Cobol, APS, FOCUS, Easytrieve Plus, IMS DB/DC, Culprit, Sequel (SQL) Sequel Plus (SQL+ - Oracle), TSQL, MySQL, PL/SQL SAS, PythonDatabases: Data Warehouse (W), DB2, Oracle, IMS (DL/1), IDMS, ADABASE/Natural, VSAMMiddleware: CIM, MQ Series
Utilities: SYNCSORT, IBM Batch Utilities (IEBGENER, IEBCOPY, etc.), IDCAMS, Xpediter, FILEAID, Endeavor, Changeman, Abend-Aid, CA7 Scheduler, Primavera, SQL Assistant, Oracle Toad, Teradata s Batch Utilities and SQL AssistantCICS: CEMT, CEDF, CECI, EXpeditier, Eyewitness, BMS, BMS Plus, MFS, Intertest
DB2: DSNUPROC, SPUFI, QMF, PLATINUM, Princeton Soft Tech, FILEAID, UtilitiesTeradata: SQL Assistant. Load Utilities, Parallel Transporter
Platforms: IBM Mainframe Series. AS/400, 8100 series (mid-range)Server Based Platforms: SQL Server 2000, 2005, 2008, 2012, 2014,2016,2019 Visual Studio 2005, 2008, 2012, 2015,2017,2019, Oracle, MS BI Stack (SSIS, SSRS, SSAS), Oracle 11.1 Toad, SQL Assistant Microsoft Professional Office Suite, Project Manager, MS Project, Publisher, MySQLAutosys, HTML, Web Development Tools, ACCESS Development, SSIS Cozyroc Suite, Crystal ReportsMethodology: Agile, Waterfall, Use Case, ETLWORK EXPERIENCE:Sunbelt Rental 10/2023-1/2024Senior SQL/BI Developer
Technical: SQL Server 2016, Azure, Visual Studio 2019, SSIS, SSRS, T-SQL, Microsoft Excel, Word Backend Engineering/Production Support Tasked with pulling JIRA tickets addressing changes, enhancements, production failures for Commissions Applications Support and Troubleshoot Application Process failures. Issues presented in Dailapplication improvements implement enhancement/corrections where applicable
Optum/Equian 5/2018-10/2023Senior SQL/BI Developer
Technical: SQL Server 2016,2019, Visual Studio 2019, SSIS, MySQL Workbench 8.0, Python, T-SQL, MySQL, Cobol II, Power BI, Easytrieve, Oracle, Microsoft Office Suite
Supporting multiple clients (Michigan, North Carolina and Florida (Blue Cross), Regence Emblem and Centene) for the purpose of building Payment Integrity Concepts Tasked with building parallel environment on the SQL Server Platform to mirror Audit Point
Designed and Created Procedures to build workable tables from CMS (MUE, Medicare)and RJ Health (Crosswalk) utilized in both the SQL and Audit Point Environments. Design Schema and Table Structures for Facets Databases (Michigan, North Carlina) Build procedures to transfer data to Franklin for Screen Scrap Processes Design, Create and Implement Comp Intel environments for Regence and Michigan clients
Collaborated with auditors to create and implement Facility Pricing application for Regence and North Carolina
Point of Contact with Optum Integration Teams for clients transitioning into the Optum environment.
Design, build and implement adjust down applications for Cambia, Michigan and Regence
Retrofit existing Optum Python Reporting System into Equian environment
Novant Health 1/2016-3/2018Senior SQL/BI Developer
Technical: SQL Server 2012, Visual Studio, SSIS, SSRS, SSAS, SSIS Cozyroc Suite, Power BI, Microsoft Office Suite, Crystal Reports, MS Project, Mainframe, IMS, DB2, Cobol II, SAS, JCL, ISPF, CICS Member of Application Rationalization Team Gather requirements with 3rd Party and Internal groups to identify and plan procedures for retirement of Server and Legacy Systems Create Cobol Programs for the purpose of extracting data from Internal Legacy Systems to populate Legacy Data Warehouse/Repository housed on SQL Server Platform
Novant Health (Continued) Responsible for creating processes to board documents into Highland OnBase Systems Design and Implementation of Data Warehouse/Repository Design Schema and Table Structures for Application Retirement Databases Create SSIS packages for loading and transferring data from applications location to App Rat server/databases Create Reporting for Application Owner to perform analysis and data validation Member of clinical conversion team responsible for onboarding clinical data into Novant EPIC system
Bank of America 9/2015-1/2016Team Leader and Senior SQL/BI Lead Developer
Technical: SQL Server 2012, Visual Studio, SSIS, SSRS, SSAS, SAS, Power BI, Microsoft Office Suite, Project Manager Lead Developer for companywide Compliance Project Manage team of 6 developers Create Project Plan and assign tasks to technical team Mentor junior level team members Create Plan to centralize testing across 77 business units Design scripts along LOBs to satisfy all phases of testing Work with Global Enterprise SMEs to design Test Scripts Manage and oversee remediation of requirements for each business unit Design and implement test database environment Analyze, Create and Review ETL packages to populate tables on test server Tuning and optimization of tablesD&W Fine Pack Corporation 5/2013-6/2015Senior SQL/Business Intelligence DeveloperTechnical: SQL Server 2005, 2008 & 2012, SSIS, SSRS, SSAS .NET Suite (C#, VB Scripts), Power BI, TSQL, MDX, Cloud, Azure, Stored Procedures, XML, Open Query Processing, Linked Server Architecture, Data Warehouse Design, Microsoft Office Suite, DBA responsibilities Supply Chain and Logistics Consolidation Project
Familiarization of facilities and their related ERPs to develop best practices for ETL boarding of data into central Data Warehouse Design and implement Frontend Processing Applications Data Modeling and Mapping (Normalized and De-Normalized environment) Table Creation and Optimization
Database Design Performance Tuning
Data Warehouse Fact and Dimension Table Design and Deployment Snowflake and Star Warehouse Methodologies Design, develop and deploy SSIS packages (ETL from 8 Facilities housed on 5 different ERP s, 3PL transmit and receive, Order, Shipment and Invoice data, 3rd Party Pricing and Rebate Data)
Develop 3rd Party Integration Procedures with regard to Logistics, Pricing, Rebates and Client Specific Discount Programs
Develop Requirements with Clients for SSRS Reports Design, develop and Deploy SSRS packages Design, develop and deploy analytical Cubes Design and Develop Order Entry add on application
Development of ETL processes and packages for transfer of data to Cloud based Azure Server Creation of Stored Procedures Creation of Dynamic SSIS Validation Packages for 3rd Party Logistics
Logistics Analysis, Design, and Process Implementation
Creation of communication link with parent company and new logistics Provider
Member of Design Team tasked with creating and executing data transfer plan
Waterfall and Agile Development MethodologiesBank of America 7/2012 4/2013Senior Developer /AnalystSystems: SBO2000Technical: SQL server 2008, PL/SQL Oracle and Functions (CASE, Date and Formatting Functions, etc.), Toad (Oracle Query Tool), XCEL and Functions (VLOOKUP, HLOOKUP, Format and Logic Functions, etc.), ACCESS, ETL, Teradata Tools and Utilities, SSIS, SSRSDatabase and SQL Development), Quality Center 11.2, Microsoft Suite 2007/2010 Develop and Map Data with Third Party Servicers for boarding into SBO200
Plan, design, and develop (SDLC) comprehensive multi-leveled balancing process for LSBO Use of advanced Oracle and Access SQL functions in design and development of Balancing System
Backup and assist management team for DOJ Regulatory New Fields Project
Develop and Manage Triangular Balancing Test Plan Mentored fellow associates with regard to functional procedures for Oracle and Access Quality Center Defect Reporting and Reconciliation
Worked in conjunction with Third Party Representatives to develop, implement and process data for the purpose of boarding mortgage loans into SBO2000
MT&L Card Product and Fulfillment Services 5/2012 9/2012Senior Developer/Fulfillment Delivery ManagerTechnical: SQL Server 2000 and 2008, DTS, SSIS, SSRS, SSAS, FTP, Visio, Visual Basic 2010, Microfocus Cobol, Microsoft XCEL and ACCESS development, Microsoft Project, Office Suite 2010
Construct, develop and publish Feasibility Study containing procedures and recommendations for the purpose of automating Card Fulfillment Process at the operations level Planning and design of procedures to process 3rd Party client data along with Statement and Credit Card Fulfillment Supervision and allocation of IT resource Hands on development of processes (FTP protocols, file trigger and automated process executions) SSIS Package Design and Implementation SSRS Reporting Packages Package Automation HLD/LLD Design Documents Test Plan and execution
Utilization of ACCESS and XCEL for data modeling and data reconciliation purposesWell Fargo 11/2011 5/2012Technical Business/Systems AnalystSystems: CDC ER Mortgage Collection Web Portal System
Technical: Vendor Tools, Daisy, JCL, DSNUPROC, Easytrieve, COBOL, Visio, Microsoft Suite Data Analysis and Reporting Business Requirement Document Development Define Government Mandates and User Requirements into Technical Specifications Review existing specification process.
Supply recommendations for streamlining and improving Technical Specifications Creation of Test Plan and Scripts for Data Validation Defect Tracking
Data Documentation Create Process Flows of Legacy and Next Generation Collection Systems
Create, test, and implement subroutines covering government mandated laws and requirements into Collections Systems Coordinating Project migration from SIT, UAT and ProductionBank of America 5/2011 9/2011Senior Technical Business/Data AnalystSystems; IAF Customer ServicesTechnical: Teradata, Banking Data Warehouse/Mart, CAB, SQL Assistant, Visio, Microsoft Suite
Business Requirement development JAD sessions with Clients creating HLD/LLD for Reporting System Coordinate validation resources with regard to Platform-to-Platform testing Creation of Test Plan and Scripts for Data Validation Hands on role to assist technical team which included coding, testing, and issues resolution
Defect Tracking and Resolution
Create, manage, and publish (SIT, UAT) production documentation for Project migration Coordinating Project migration from SIT, UAT and Production Coordinating Technical and DBA requirements Development of Control Plan and Operations Manuals with platform application developers
Wells Fargo 7/2010 4/2011Senior Systems Analyst/ConsultantSystems: Wells West Mortgage (MIDE)
Technical: CICS, COBOL, JCL, Easytrieve, NDM, Endeavor, CA7, Autosys, SQL Server 2000, 2005 and 2008, Visual DTS Create processes using JCL, Proc and NDM to send Mortgage related files to HUB server Create data defect reporting process Enhance and upgrade On line processes Work with Wells Fargo and offshore personal to ensure files are correct and map to copybooks
Gather Business Requirements for purpose of process improvements in current environment Troubleshoot possible data defects for the analysts Document current process flows and develop on call methodology for West Integration Analyze, create and publish spreadsheets to facilitate in the conversion of existing processes CA7 Scheduling, PROSE Part of on-call rotation for XM East applicationsBlue Cross/Blue Shield of South Carolina 3/2009 7/2010Senior Developer/Data Analyst/ConsultantSystems: Commercial Claims, Surrogate Claim Processing, Claims Legacy Conversion
Technical: Microfocus APS, COBOL, DB2, IMS, CICS, JCL, Easytrieve, Endeavor, Dumpmaster, Intertest, MQ SeriesResponsibilities:
Analysis of Processes
Developing and Testing new Claim Processing System for Michigan BCBS HIPAA Project Analysis Resolution of Defect Logs Use of SDLC Methodology with Project Progression Data Analysis Use of Debugging and Available Programming Tools HIPAA Project Design Analyst IMS to DB2 conversion Analysis Construct Data Model and data normalization Conversion of CICS and Batch processes from IMS to DB2 Design code and test online and Batch processes Create IMS to DB2 comparison programs Design, code and test Data Conversion processes Report and correct data discrepancies with Business Units
Wachovia/First Union 4/2000 9/2008Team Lead/Senior Developer/DesignerSystems: Transaction Services, Third Party ProcessingBusiness Analysis: Business Requirement Development, JAD sessions Gap AnalysisTechnical: CICS, DB2, COBOL, JCL, Batch utilities, Fileaid, Expediter, Project Manager, Visio, MS Office, SQL Server 2000 and 2008, DTS, SSIS, SSRSResponsibilities:
Define and gather business requirements from Third Party clients
Create Business Requirement Documents with 3rd Party Client and Relationship Managers
Collaborate with Third Party client partnerships to define and implement requirements Schedule and conduct JAD session with 3rd Party clients Perform Gap Analysis on client systems
Build and Convert DTS to SSIS Packages Convert Reporting to SSRS standards Work with senior management in building client relationships
Create programming and design specifications for programming staff Data analysis, modeling, and design of relational databases (DB2 and SQL Server Based) Creation and automation of previously manual intensive environment
Design, coding and implementation of On-line (CICS) system as part of automation process Collaborate with Business Analysts and Relationship Manager to create Test Plans for new and existing processes
Design, code, and implementation of batch processes to data files for purpose of creating credit, debit, insurance, and gift cards for third party clients
Create and pass data files to UNIX based processing systems
Build processes to create Credit Statement, Collection Letter files and Postcards formatted and used in server based Elixer processesLowes 3/99 3/00Senior Systems ConsultantSystems: Acquisition and Vendor ItemTechnical: CICS, DB2, COBOL, Expeditor, Fileaid, Princeton Soft Tech Relational Tools, DADSResponsibilities:
Analysis of existing Vendor Item System to implement acquisitions to existing design Use of Y2k tools for purpose of aging and creating test plans for system redesign
Data modeling and table design along with DBA responsibilities in conjunction with the system enhancement and new design Analysis, design, coding and implementation of new processes related to addition of new acquisitions to Vendor Item System
Part of team creating test plan as well as creating regression and integration plans for entire project team Complete responsibility for all on-line processes related to the systemSouthern Company 6/98 2/99Project ManagerSystems: Y2K ProjectTechnology: IDMS 14.0, ADS/O, Cobol II, DBIMAGE, DBEZTEST, Hiperstation, Fileaid, Fileaid Data Ager, Hourglass, Problem Tracker, MS Office, and MS Project.Responsibilities:
Lead team of 10 programmers and Business Analysts for Y2k project Responsible for determining requirements to ensure three critical systems were Y2k compliant
Creation of Project life Cycle process plans for assigned systems Closely worked with test and application leads on project team to create and upgrade methodology to certify systems as Y2k compliant Technology and application inventory, as well as creation and setup of test environment for the three applications.
Resource management and interfacing with each application expert and their management to gather environment, component, and test bed information to ensure the Y2K environment reflected Southern s production machine. Directed project team through data and application analysis, identifying remediation effort for each application.
Set up Triage and Test Metrics for the purpose of creating test plan and the ability to track testing progress.
Responsible for creation of all documentation with regard to the Conversion Solution, Test Bed and Environment setup, as well as Turnover, and Inventory reports.
Duke Power 1/98 6/98Senior Systems AnalystSystems: Y2K ProjectTechnical: CICS, DB2, Cobol II, SAS, PLI, Easytrieve, DB2, Natural, Hiperstation, Fileaid, Fileaid Data Ager, and Exchange. Responsibilities:
Responsible for test plan creation, and technical assistance for the purpose of putting the Duke Power Asset Management System through the Y2K Project Life Cycle. Identifying technical and applications inventory, analysis of all programs and interfaces Determine and define methods for remediation.
Set up metrics, triage (elimination of non-critical processes), and problem tracking methodology Set up baseline and century test environments.
DBA duties, assisting in both execution and results verification for baseline, 20th century, and 21st century testing.First Union 7/97 1/98Project Leader/Senior Programmer AnalystSystems: Brokerage and AnnuitiesTechnical: COBOL II, APS, DB2, IMS DC, XPEDITER, FILEAID, and CHGMAN, Datamover, Middleware
Responsibilities:
Led team of several IT professionals through design and development phases of brokerage system rewrite Gather and define business requirements Create specifications for batch ad online processes related to rewrite Design, code and implement batch and online programs related to process Project Liaison responsible for interface with third party vendor for brokerage services
Create test plan and develop test metrics for progress trackingWORK EXPERIENCE SUMMARY 1997 AND PRIORSenior Systems AnalystClients:Policy Management Systems, Uniroyal Chemical, Cigna, Travelers, Aetna, Sikorsky Aircraft, Pratt and Whitney Aircraft, BI-LO, Blue Cross/Blue Shield, Sea-Land (CSX)Systems:Marketing, Engineering, Claim Processing, Order Entry, Portfolio Management, Investment Accounting, Medical Claim Processing and Reporting, Life Insurance, Property Casualty, Long Term Disability, Actuarial, Mortgage and Real Estate Investments, Risk ManagementSoftware: COBOL, CICS, BMS, Assembler, DB2, IDMS, IMS, MQ Series, SAS, FOCUS, PL/1, ADABAS Natural, XPEDITER, File-Aid, Princeton SQL Tools
|
