SUMMARY:

• ETL (20 Yrs) Informatica Power Center 8 & 9, Data Warehouse(20 yrs), MS SQL Server (20 yrs), SQL programming (25 yrs), Visual Basic (20yrs), VBA (20 yrs), Excel (20 yrs), Scripting (20 yrs) Strong SDLC experience (25 yrs), .Net (5 yrs), XML (10 yrs)
• Clinical Data Analysis (7yrs.) including cutoff calculation programming, LIMS design & development, and automation of assay results.
• Excellent communication skills and ability to interface with business analysts and end - users.
• Design Graphics (25yrs) involving all aspects of flow diagrams and structure charting for data modeling.
• Documentation (25yrs) includes all parts of system development including business requirements, software design, user manuals, testing and ad-hoc reporting.
• Business analysis involving identifying business needs, gap analysis and determining solutions to business problems.
• Data Modeling involving data profiling, data governess, data dictionary, data mapping, ETL.
• BI/Data Warehouse Developer (HIPAA compliance)/ Data /Business Analyst with over 25 years of diversified experience in Information Technology and a strong background in developing applications using Visual Basic, VBA, Access and Excel.
• Experience with VBA in Visual Studio with Tools for Office. Extensively involved in Frontend development in Visual Basic 6 / VBA.
• Modified and developed programs in Access, Excel, Word and Project. He has extensive knowledge of all major relational databases including SQL Server and Oracle for complex queries, stored procedures, benchmarking.
• Robitic Process Automation involving automating repeatitive presses via a graphical user interface.
• Web services using ASP.Net, analytics with DotNetNuke and automation of web services with Amazon web services.
• Used automation in VBA to transfer data between most all MS Office products.
• Experienced designing data extraction, transformation and data mapping (ETL) procedures, Data Warehousing, OLAP, and Metadata within enterprise architectures for both finance and pharmaceutical companies.
• Internet programming including automation of Microsoft Explorer (DOM), Amazon web services (AWS) and cloud computing.
• Involved in compliance issues for SOX automation, medical device audits, FDA Title 21 CFR Part 11 and Document Control.
• Sales leads automation with MS Mapi object.
• POS software for retail.
• Standards Study Data Tabulation Model (SDTM), Analysis Data Model (ADaM) for statistical programmers and clinical trials.
• Financial analysis in supporting for both sales persons and traders.
• Actively involved in reporting using Crystal Reports and MS Office products that report. Extensive use of tools for data modeling including Visio and Erwin.
• Multi-developer scenarios for programming control has been done with Polytron Version Control System.
• Experience administering SharePoint.
• Worked extensively with Excel using tools such as VLOOKUP’s, macros and pivot tables.
• Organized professional with excellent presentation, business analysis, documentation and interpersonal communication skills. This includes a full cycle development (SDLC) background including documentation, validation, data scrubbing and automated testing.

SKILLS:

LANGUAGES: VBA/VB 6, PERL, VB.Net, PL/SQL, PowerBuilder, C, Visual C++

DATABASES: SQL Server, MS Access, Sybase, Oracle, SAS

ENTERPRISE: SAP, SAS, PeopleSoft, HP, Dot NET Nuke, 365 Dynamics

ETL: Informatica PowerCenter, Oracle Loader, Sql Server Integration Services, MS Office

DESKTOP: Office 365 - Access, Excel, Visio, SharePoint, Project, PowerPoint, Outlook, Word

DESIGN: Informatica, MS Visio, Erwin, PowerPoint.

Data Formats: XML, XSLT, HTTP w/SOAP, FTP

GROUP DEV.: Polytron Version Control, MS Source Safe

REPORTS: Cognos, Crystal Reports XI, MS Office, and Business Objects.

OPERATING SYS: Windows, DOS, UNIX and VAX/VMS

MONITORS: Oracle Enterprise Manager 11g, Business Objects instance Manager

HARDWARE: Scanners, Capture cards, Robotics, PC internals, LAN & protocol analyzers, in circuit emulation (ICE), PROM burning, voice processing, and modems.

PROFESSIONAL EXPERIENCE:

Confidential, Kenilworth, NJ

Excel / Access Data Analyst / Applications

Responsibilities:

• ETL data modeling, data profiling, cleaning and mining of legacy accounts with MS Office 365 using Excel 2016.
• Data analysis with MS Access 2016 to transfer and transform Excel data SQL for legacy accounts for tax reorting.
• Reconciliation of legacy accounts for Microsoft Dynamics 365 using Excel and Access 2016.
• Erwin data modeler for new data warehouse for development for Access 2016.
• Form built applications delivered for 3rd party users with design documents and user manuals
• RPA automation of emails to manager on reconcillation failure.

Confidential, Hamilton, NJ

Informatica Data Analyst

Responsibilities:

• Majority of work is on Informatica PowerCenter tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor. Flat file profiling, data mapping and transformations include dimensions and slowly accumulating history. Debugging and analyzing log scripts.
• Utilized Informatica per-sql and post-sql
• Development work on a Data Dictionary called the Metadata Database (MS Access) which describes the tables and columns of the NJ Shared Data Warehouse (MMIS) for a library dictionary with cross-reference.
• Development work programming VBA MS Access 2010 / Oracle state studies with ad-hoc reports
• Development work on new Molina healthcare data warehouse
• Production work on NJ state data warehouse, trafficking runaway queries, reporting for MMIS shared data warehouse for NJ Dept. of Human Services
• Informatica, UNIX script, Access, Excel, Oracle (PL/SQL), Oracle Loader, Erwin, and Business Objects Web Intelligence Universe, Oracle Enterprise Manager 11g.

Confidential, Morrisville, NC

Business Analyst / Data Analyst / ETL Developer

Responsibilities:

• Production work on Dodd Frank regulation, CCAR and tax requirements on customers
• VBA development with Access, Excel. Oracle (PL/SQL), Informatica and Business Objects Web Intelligence Universe

Confidential, Newark, NJ

Sr. Data Warehouse Developer / Data Analyst

Responsibilities:

• Automated internet downloading (DOM), Powershell, Amazon web services (AWS) and Access DB storage with
• VBA for Order Reports from Amazon Seller Central (Cloud Computing) with business analysis

Confidential, Purchase, NY

Sr. ETL Developer / Report Analyst

Responsibilities:

• Automation of compliance with MS Access using VBA reading in Word documents, creating Excel output using profiling, ETL, Data Warehousing, OLAP, Metadata for card services.
• Created reports for clients.

Confidential, Warren, NJ

Sr. ETL Developer / Data Analyst / Business Analyst

Responsibilities:

• MS Project 2010 VBA data analysis on task rollup completion calculations using Access, Excel, Word and SharePoint Automation with Issues & Risks in Global Information Security and reporting.

Confidential, Cleveland, OH

Sr. ETL Developer/ Business Analyst

Responsibilities:

• VBA Excel Development for their proprietary accounting audit program EAGLe (Excel program) and added data access to multiple servers. Cubes were used for rollup data. Tool was used for located fraulent accounts.
• SQL Server Maintenance Studio 2008 with Import Export Program
• Sql Server SSIS for Importing Data
• Use of Erwin for structure charting and process flow with Sql Server SSIS for ETL.
• Business analysis and completed documentation. Creation of pivot tables using VBA.
• VBA code using Office 2010 to create ad hoc reporting using Excel.

Confidential, Springfield, NJ

Sr. BI Developer / Business Analyst

Responsibilities:

• VBA Word / Excel / Access Development for all template FDA Regulatory requirements
• SharePoint development and setup
• Business analysis of compliance for documentation between two merging companies
• VBA macro creation, edit and debugging.
• Data scrubbing with SAS, SQL, Informatica and VBA for tax reporting.

Confidential, Bridgewater, NJ

Sr. Database Developer / Business Analyst

Responsibilities:

• Visual Basic 6, Access, Excel 2010 VBA, Visual Studio, SAP and SQL Server 2008, Toad.
• VB6 executable front end and Access backend VBA programming for retail store inventories and transfer of POS data to SAP Retail Systems using XML formatted data.
• VB6 Package & Deployment Wizard with Excel 2010.
• ASP .Net VB programming for data migration to SAP (Sybase) using SQLAnywhere 9.
• Design documentation with business analysis including structure charts, data modeling, process flow diagrams, reporting and daily work log.

Confidential, New York, NY

Sr. Database Developer / Business Analyst

Responsibilities:

• Access, Excel 2007 VBA, Oracle 10g (PL/SQL) and Sql Server 2005, Toad, Citrix, Lotus Notes.
• VBA automation of reconciliation of British funding audit tool, SharePoint and compliance reporting.

Confidential, Jersey City, NJ

Sr. Data Warehouse Developer / Business Analyst

Responsibilities:

• Access, Excel 2007 VBA, Oracle 10g and Sql Server 2005, Toad.
• VBA automation of Independence Employee System for tracking of employee security holdings vs.
• Confidential client securities for conflict of interest using VSTO and XML.
• For Sarbanes Oxley act and SEC rules.
• Oracle Loader ETL work for MCA and SOX automation

Confidential, Newark, NJ

Business/ETL Data Analyst

Responsibilities:

• MS Access, Excel 03, XP, 07, 10
• BA of financial pricing models, reconciliation, process flow and gap analysis for forecasting expenses using VBA Access, ETL analysis and SharePoint.
• Standardization of excel spreadsheets between managers automate imports to a database for ETL.

Confidential, NY, NY

Sr. Data Warehouse Developer

Responsibilities:

• Visual Studio 2008, 2010 / Access, Excel, Outlook 03, XP, 07, 10/ SQL Server 05, 08, 08 R2
• Business analysis of modeling data, sources of data, reconciliation issues, XML, and process flow of the data for Software Development Life Cycle (SDLC)
• All code was written to provide city and state revenue for federal taxes.

Confidential, Pleasantville, NY

Sr. Data Warehouse Developer / Business Analyst

Responsibilities:

• Used VBA in MS Office to Automat a dashboard for financial reporting A/P, A/R, Compliance, Admissions, Discharges, and New Hires for tracking and state tax auditing.
• Salesforce programming

Confidential, NY

Sr. ETL BI Developer / Business Analyst

Responsibilities:

• Reconciliation for Fixed-Income / Securities using VBA with MS Access, SQL Server and Oracle (PL/SQL)

Confidential, Times Square, NY

Sr. Developer / Business Data Analyst

Responsibilities:

• Designed Crystal Reports 10 for reports creation from Visual Studio with SharePoint
• Developed VB6 & Excel with VSTO from specs for system, regression, performance, and user acceptance with SharePoint.
• ETL work using Excel for importing data.

Confidential, Wall St, NY

Sr. Data Warehouse Developer / Business/Data Analyst

Responsibilities:

• Worked on company’s DOTNETNUKE ASP website Meta tags and search optimization.
• Developed web analytics from SQL Server 2000 created by DOTNETNUKE package.
• Created Exchange Users from Excel using VBA and Macros. Data analysis using Crystal Reports
• Created automated uploading routines to FTP for Geocoding (GIS) of data using XML.

Confidential, Bridgewater, NJ

POS Developer / Business Analyst

Responsibilities:

• Coding in Visual Basic 6, VBA and testing on a Citrix environment.
• RPA Writing VB.Net to record manual testing for playback and recording for automated validation.
• Imported from AS400 and Oracle 9 with PL/SQL and Citrix.