Data Analyst

Summary:

Dynamic data analyst with over fifteen years of Information Services experience seeking an opportunity to work in an ambitious and fast growing environment where my analytical, strong leadership abilities and organizational communication/writing skills will be of great value in achieving the company's missions and goals

Skills:

Administration of Oracle on Unix/Linux environments, Oracle 11g RAC, Access, MS Office, Performance monitoring and tuning skills, Unix shell scripting, IBM 390/370, IBM PC, COBOL II, MVS/JCL, SQL, MySQL, Platinum, DB2 Connect, DB Utilities, File Aid Batch/DB2, DB2, Stored Procedures, IMS, REXX, CICS, VSAM, Endeavor, Xpediter, Intertest TSO/ISPF, SPUFI, BMC, Visio, C , Java, Visual Basic Architect Pro, Crystal Reports.

PROFESSIONAL EXPERIENCE:

Confidential

• Was involved in manipulating, cleansing processing complex data and files using Excel, Access and SQL.
• Analyzed raw data, drew conclusions developed recommendations.
• Was responsible for loading, extracting and validation of client data to ensure the quality, validity and accuracy of content.
• Related customer data from multiple internal and external source systems into a central, consolidated company-wide customer database in a timely manner. Offered input to improve customer data processing, and informed team lead about company hierarchy issues during staff meetings.
• Worked within a team of Data Analysts, to analyze, review, update, edit, clean, translate, and ensure accuracy of customer data.
• Wrote T-SQL scripts to manipulate data for data loads and extracts.
• Involved in report writing and business process development.
• Administrated database processes to identify presence of errors and technical flaws.

Confidential

JPMSL Project

• Performed project planning and management.
• Developed data analytical databases from complex financial source data.
• Cooperated closely with IT experts, project engineers and subject matter experts in planning and developing analytical methods for data collection, data variables, storage, analysis, statistics and presentations.
• Was involved in reporting statistical findings to work colleagues and senior managers.
• Investigated day-to-day activities to prevent errors and malfunctions.
• Generated monthly reports on miscalculations.
• Morcom Pending Report Project
• Was responsible for leading software testing, troubleshooting, and implementation.
• Performed daily system checks, data entry, data auditing, creating data reports monitoring all data for accuracy.
• Designed, developed and implemented new functionalities.
• Collected, collated and carried out complex data analysis in support of management customer requests.
• Advised on the suitability of methodologies and suggesting improvements.
• Carried out specified data processing and statistical techniques and supplied qualitative and quantitative data to colleagues clients.
• Used Informatica to extract, transform load source data from transaction systems.

Confidential

HR system

• Designed, coded, tested and implemented Stored Procedures which were both scheduled to run at a certain time and triggered by a web application on demand. The procedures transferred data between HRHUB and NYCAPS via a result set or parameters.
• Designed, coded, tested and implemented all necessary BATCH elements for both daily ESI and weekly RECON NYCAPS processes.
• Regularly interacted with users and generated ad hoc reports upon request.

Confidential

Payroll system

• Was heavily involved in Employee Project modifying, designing, testing and implementing CICS modules and screens. The goal was to provide additional criteria employee number besides just the SS alone to inquiry and update employee data.
• Was working on NYCAPS New York City Automated Personal System conversion project doing the following:
• Designing, developing, testing and implementing.
• Modifying corresponding PROCs accordingly.
• Modifying BATCH and ONLINE modules using DB2 tables rather than VSAM files.
• In addition, created ad hoc reports based on user requests on Mainframe OS and then transferred them onto PC in Excel format.
• Prepared production procedures, code modules, provided post-implementation production support and resolved various issues.
• All applications were written in COBOL-II, CICS and DB2.

Confidential

• Designed, analyzed, tested, implemented and supported Name Address Archive System NAAS intended to purge irrelevant data from the Name Address database. Various Platinum DB2 utilities were used in addition to BATCH COBOL/DB2 applications in order to handle the purge process. A necessary backup and restart/recovery processes were designed. In addition, a 24/7 on-call support and trouble shooting were provided when necessary to handle initial implementation stages.
• Worked with Technical Support area during migration to a new OS/390 CICS Transaction Server. Was responsible for generating test scripts to test for any differences between CICS 4.1 and Transaction Server, working with Production users during the test stages,
• Designed and implemented backup/restore procedures of VSAM and DB2 files during Transaction Server testing.
• Designed, analyzed and implemented PCH.COM system to allow users to register and use PCH.COM. Batch database updates processes were designed in addition to restart/recovery processes.