Data Warehouse Analyst / Etl Developer / Report Analysis Resume
Hamilton, NJ
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)
- 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.
- 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.
- 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.
TECHNICAL SKILLS:
LANGUAGES: VBA/VB 6, PERL, VB.Net, PL/SQL, PowerBuilder, C, Visual C++
DATABASES: SQL Server, MS Access, Sybase, Oracle, SAS
ENTERPRISE: SAP, Cognos, PeopleSoft, HP, Dot NET Nuke
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: 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, Hamilton, NJ
Data Warehouse Analyst / ETL Developer / Report Analysis
Responsibilities:-
Majority of work is on Informatica PowerCenter tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor. Workflows include dimensions and slowly accumulating history
- 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 on with MS Access 2010 / Oracle state studies with ad-hoc reports
- Development work on new Confidential 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, Access, Excel, Oracle (PL/SQL), Oracle Loader, and Business Objects Web Intelligence Universe, Oracle Enterprise Manager 11g.
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.
- SQL Server Maintenance Studio 2008 with Import Export Program
- Use of Erwin for structure charting and process flow
- 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 and VBA for reporting.
Confidential, Bridgewater, N.J
Sr. Database Developer / Business Analyst
Responsibilities:
-
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.
- .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, Newark, NJ
Business/ETL Data Analyst
Responsibilities:
-
BA of financial pricing models, reconciliation, process flow and gap analysis for forecasting expenses using Access, ETL analysis and SharePoint.
- Standardization of excel spreadsheets between managers automate imports to a database for ETL.
Confidential, Times Square, N.Y
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.
Confidential, Wall St, N.Y
Sr. Data Warehouse Developer / Business/Data Analyst
Responsibilities:
-
Worked on company’s Confidential ASP website Meta tags and search optimization.
- Developed web analytics from SQL Server 2000 created by Confidential 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, N.J
POS Developer / Business Analyst
Responsibilities:
-
Coding in Visual Basic 6, VBA and testing on a Citrix environment.
- 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.
Confidential, New York, N.Y
Sr. VBA / Business Analyst
Responsibilities:
-
Identified, documented and assisted with hospital automation (diagnosis to billing).
- Coding in Visual Basic 6 / VBA. ETL with MS Access with linking & export to SQL Server.
- Upgrading to an ASP web page for a new platform and automating Outlook email via IE 6.
Confidential, Edison, N.J
BA Developer
Responsibilities:
-
Designed developed a LIMS system for testing of reagents used for the Hemochron product line (Coumadin) that replaced a SQL LIMS system. Used Crystal Reports.
- Business analysis with structure charts, flow diagrams, and complete documentation.
- Front GUI forms in Visual Basic 6 and the databases were Access, SAS and SQL Server 2000.
- Design of VB LIMS using external test templates for tests to be created / edited by lab techs.
- LIMS used the FDA chap 21 CFR, Part 11 for recording of electronic signatures and timestamps.
Confidential, Piscataway, NJ
Software Developer/ C++ / VB
Responsibilities:
-
Research and development for DNA research.
- Designed and developed a LIMS system for a DNA sequencing & assay sampling company.
- Created a LIMS for DNA assay sampling and clinical trials for Cystic Fibrosis and organ donor matching.
- Used Access / Oracle 8 as a data logger. Used VB GUI with a COM interface to a C++ application.
- Helped validate a C++ application. Bar coding to track sampling with Label Matrix through VB6.
- Created bar graphs through Access and exported a web page in HTML for customers.
- Used automation in VB to extract data from SAS to Excel into a LIMS system and XML.
- Created a reference database table for charting Nucleotide Sequences in Excel.
- Created custom bar graphs for comparison of samples using the MS Chart object and custom code.
- Use of PDMA, 21 CFR Part 11, and system validation
Confidential, Oakland, N.J
Business/Data Analyst
Responsibilities:
-
Designed and developed a web portal between I.E. and Lucent. Web pages were developed using Access 2000, Visual Interdev, and Visual Basic 6.0.
- Automated sales leads using Salesforce and VBA Mapi object to push out emails.