SUMMARY PROFILE

Experienced Business Systems Analyst / Data Analyst / MS Office Developer. Specializing in MS Office Automation and User Interface development. Highly skilled in transforming raw data into valuable information Created solutions for Fortune 500 corporations for more than 15 Years. MS Access / Excel / Office VBA Developer with 15 years experience in developing applications, creating complex dynamic SQL queries, MS Access and MS Excel Macros user forms, Access and Excel application conversion to 2007 and 2010 formats. Have excellent analytical and reporting skills, technology passionate, coupled with creativity and vision for improving processes and problem solving skills. Experienced developing interactive reports from multiple data sources. Ability to extract data from all types of data sources, transform, cleanse and create load files ETL Operations . Earned a reputation for technical leadership, high quality on-time work. Positive interpersonal relations and known for being a proactive team player who builds solid working relations with internal and external customers. As a systems engineer I am committed on identifying, developing, and coordinating process improvements using standard systems engineering methods. Fluent in two European Languages,

PROFESSIONAL EXPERIENCE

Confidential

Roles: Senior Data Analyst, Reporting Analyst, Data Transformation and Migration Tools Developer.

Confidential

create source files for IBM Cognos TM1 Enterprise Planning System. Responsible for collaborating with IT Data Architecture partners to ensure data is consistent and accurate. Create functional requirements, source-to-target data map data dictionary, process diagrams and gap analysis documents for seamless transition from legacy to Enterprise System. Develop ETL tool to automate data transformation and load file creation. Run daily data loads using proprietary tools. Generate on-demand Ad Hoc reports for managers and team members. Responsible for prompt resolution of data quality issues. Develop and maintain Microsoft Access databases used for purchase orders, payments and resource management and expense tracking.

Confidential

Roles: Data Analyst, Reporting Application Developer, Reporting Analyst

Confidential

Objective: Develop Asset Sales Reporting Application for Non-Technical users.

Responsible for identifying data for Government and National account contracts, equipment leases. Develop robust multi-user reporting application for non-technical users. Create numerous backend databases. Automate monthly data refresh, including unzipping data files via VBA code for all backend databases eliminating the need to relink tables in the reporting application. Create multi-tab Excel reports using automation from the reporting application. Automate text file unzipping, renaming and importing in one operation. Create Schema.ini files. Write SQL and VBA code to search large data set 2 million records for based on user defined criteria, using 6 user selectable search methods. Respond to many report requests from internal and external customers in timely manner. Document application design and code create user help documents provide user training.

Confidential

Roles: Business Systems Analyst BSA .

Confidential

Responsible for creating Data Dictionary and ER Diagrams for existing Databases Create custom tools for file conversions, Extract data from legacy databases, perform data manipulation, data cleansing and data transformation. Create load files for SQL Database. Write SQL Server scripts for data quality and validation.Linked Access databases to SharePoint 2010.

Roles: Data Analyst, Database Developer.

Confidential

Responsible for managing and architecting several UPI audit research databases, used for tracking unclaimed properties and locating beneficiaries. Import data files created by Admin systems, create Excel research spreadsheets. Responsible for automating the import and export of hundreds of Excel research spreadsheets into databases Cycle Runs . Create input files for third party SSDI and SSN verification tools. Create complex queries for Metrics and Status Reports. Create, encrypt and transmit file batches to Audit organizations appointed by 40 states via secure FTP applications.

Roles: Microsoft Access / Excel Developer, Data Analyst.

Confidential

Responsible for developing a Project Management Database application, Developing automated Dashboard, Score Card reporting tool.

Confidential

Roles: MS Access, MS Excel Developer / Data Analyst.

Confidential

Responsible for the following: Interview users gather requirements for proposed changes of an existing HR reporting application. Modify back-end database to needs of the HR department. Create new archive database, move old data to the archive back-end database. Create new report criteria selection user interface in front-end application to facilitate additional filtering capabilities. Enhance front-end data entry screens. Develop new MS Excel and MS Word report templates. Modify application to run on mixed Operating Systems with a variety of computers. Write automation code to report out in various report formats. Add new lookup tables and data. Provide installation and user training assistance to staff.

Confidential

Roles: Programmer - MS Access, Excel, Word Developer, Data Analyst, Reports Developer.

Confidential

Responsible for developing a multi-user MS Access secure database application with VBA to be used by HR Analysts, Managers and Staff globally, for maintaining critical HR information, such as Role Changes, Employee Performance Improvement Plans, Investigations, Etc. Responsible for creating report templates in MS Word, MS Excel, adding functionality for one button reporting in various report formats. Responsible for migrating historical data from various sources and formats, user training and documentation.

Confidential

Roles: Programmer SAP Master Data Conversion Transformation Database Developer, Data Team Confidential

As a member of the Data Team, played integral role in Master and Transactional Data Object Conversion and Data Cleansing, resulting in a huge success of merging the North American and the European SAP into a single Instance of SAP. Responsible for data conversions like Unit of Measure UOM , Bill of Material BOM Purchase Order PO , data transformation to SAP specification, data cleansing, creating and modifying Data Object Model Documents DOMD , creating modifying Conversion Design Document CDD , documenting data transformation and business rules, developing data transformation databases, write VBA code to automate importing and exporting all types files, write SQL queries, create load files applying conversion and business rules, create data validation reports from Access data to Excel multi-tab workbooks. Managing and resolving data transformation defects using Mercury Test Director. Participate in team building, working closely with SAP Users, Business Analysts, Consultants and offshore teams.

Confidential

Confidential

Data Analyst, Reports Developer.

• Responsible for developing a multi-user MS Access reporting application with VBA to be used by the HR department, to automate complex statistical reports as a pilot application with the intent of Global Rollout..
• The reporting application is to replace current time consuming manual reporting, to eliminate data entry errors, to improve accuracy and consistency Responsibilities include analyzing and importing PeopleSoft and BrassRing data in different formats into the MS Access application. Transform data into statistical reports in MS Excel format complete with charts and graphs. Provide support to users and management. Additional responsibilities developing Excel Templates, writing macros to automate data analysis, end-user training and documentation.

Additional Technical Support Confidential

Confidential

Excel Developer, Reports Developer, Data Quality Analyst

Responsible developing a multi-user MS Access Reporting database application to be used to generate data reconciliation reports from a production billing database application. Develop complex dynamic queries, data quality reports to identify data inconsistencies, analyze, research and compare historical and imported data. Create business forecast reports to support managers and sales teams. Enhance existing Ms Access applications, automate import and export of data between various applications. Provide support for multi user application users. Design MS Excel report templates and develop VBA code to automate MS Access to MS Excel report generation. Provide analysis and programming project support in preparation for the upcoming Sarbanes Oxley audits.

Confidential

Confidential

Database Developer

Responsible for developing an Ms Access Workflow Tracking Database Application with VBA for scheduling projects and employees. Populate database with live data. Develop queries for various reports and forms. Create user guide and documentation.

Confidential

Confidential

Microsoft Excel, Access Developer - Solutions Architect

Confidential

Responsible for test script Automation tools creation, test results consolidation, reports generation data cleansing and extraction from various disconnected systems i.e. SQL Servers and Oracle Databases and Lotus Notes databases. Create data mining applications. Systems Integration test execution. Create custom views in Lotus Notes databases. Create Excel intelligent test script templates used by on-shore, off-shore test teams, Excel and Word report templates and develop data extraction solutions, Creating Access, Excel applications to be used as Automation Servers to populate test script templates and database tables. Write Excel Macros, Access Functions and Subroutines. Support off-shore QA testing and development teams. Configure IBM Rational TestManager test environment. Importing, developing and executing manual test scripts in Rational TestManager. Recommend Enterprise-wide test tool improvements and customization. Test Engineer role responsibilities also include coaching business users in test script authoring and one-on-one tool use training. Authoring and executing wireless test scripts in Siebel environment. Group involvement in test plan and requirements reviews.

Confidential

Systems Engineer - Tools Developer Global Mailing Systems Division

• Responsible for providing key Systems Engineering support to the latest generation mailing systems utilizing the iButton technology, as well as global postal submissions. Assumed the role of Systems Test Engineer within Systems Engineering with accountability for development and modification of test tools and requirements authoring and linking. Additional responsibilities included execution of multi-phase testing including system level HW/SW Integration and evaluation of electro-mechanical and software components.
• Created new document requirements control and management system. Shortened time to market, improved postal authority confidence and accelerated submission process, led to increased revenues
• Created VBA application to diagnose Mailing system configuration problems.
• Played key role in providing engineering document authoring and foreign language translation support. Reduced time for acceptance and programming.
• Created links between functional requirements and test plans and user requirements for traceability using Dynamic Object Oriented Requirements System DOORS .
• Created private views and queries in Rational Tools Suite for reporting.
• Developed software application using VBA to automate Systems Integration test results verification for Systems Integration test team. Created centralized test reports, achieved 20 time saving, while improving department effectiveness.
• Created VBA application to conduct special data analysis to troubleshoot delivery confirmation batch uploads, improved customer satisfaction and capability to plan and adjust server loads.
• Spearheaded numerous technical researches, processed and presented information to engineering and marketing staff. Resulted in accurate mailing system configuration for global market and improved sales.
• Recycled and reconfigured test meters for international market. Reduced inventory of test meters
• Executed HW/SW Integration, Performance, Functional, Regression, OS software and Postal Rates download tests. Performed software uploads and iButton programming.
• Authored, modified System Integration test cases and test scripts, significantly improved testers capabilities.
• Developed a configuration verification and data mining application with intuitive user interface. Automated verification of Postage Meter configurations from SQL Server logs.

Product Support Engineer, Diagnostic Tools Developer - Confidential

• Accountable for supporting Technical Operations in various capacities, including technical leadership and engineering support for two mission critical Internet Postage Products. Responsibilities included software testing, qualifying, recruiting customers and coordinating Beta Test programs and one-on-one and group training for team and contracted support teams.
• Recognized by management for providing critical 3rd level support for ClickStamp and ClickStamp Online Internet Postage Products. Work included key on site trouble shooting and support issues.
• Developed multi-user Call Center database application with extensive management reports. Implemented database maintenance and automatic back-up strategy. Significantly improved ability to track customer information calls.
• Authored step-by-step trouble-shooting procedural documents, including training and high level support to 3rd parties for Knowledge Base to be used by customers as self-help and call center staff.
• Selected as technical liaison and Subject Matter Expert in developing a Case Based Reasoning Systems CBR and diagnostic tools with Inference Corporation.

TECHNICAL PROFIENCIES AND FAMILIARITIES

• Software Development Skills:
• Develop rich client desktop database and reporting applications from concept to Implementation SDLC with focus on user's need, scalability, reliability, supportability and security. Database Development Data Modeling. Microsoft Office 97,2000,2003,2007,2010 Development.
• Programming Languages:
• COBOL, RPG, VB Script, VB, MS Excel Macro Programming, Visual Basic for Application VBA , Structured Query Language SQL , T-SQL, Microsoft Office Automation and Application Development, MS Visio, VB.NET, RPG, Oracle Scripts, SQL Plus, PL/SQL, Database Conversion and Migration, ADO.Net, Crystal Reports, HTML, Lotus Notes database programming language.
• Software App. and Tools:
• TeleLogic's Dynamic Object Oriented Requirements System DOORS , Rational ClearQuest, ClearCase, TestManager, Mercury TestDirector, MS Access, MS Excel, SQL Server 2005,2008 R2, 2014, Power Point, MS Project, Lotus Notes, Lotus 123, Hitachi E10A Emulator, PhSim, PCT proprietary tools and Simulators. Siebel CRM , In-Touch Developed in Lotus Notes , SharePoint 2010

PROFESSIONAL DEVELOPMENT

• Completed numerous company sponsored training courses i.e.: How to develop manual test cases with IBM's TestManager, How to handle difficult people, How to write better engineering requirements TeleLogic and other DOORS training courses and many more
• Database Development courses using Oracle, at Norwalk Technical Community College.
• Currently enrolled in an Oracle Database Development Certification Program.