Senior Financial System Analyst Resume
SUMMARY:
I have been specializing in data analysis, modeling and database system implementation for over 15 years with a strong working knowledge of traditional transaction-based (OLTP) systems. I have extensive knowledge of data modeling techniques and CASE tools for Entity Relationship (IE) modeling on a Windows Operating System. My expertise includes: Data analysis and modeling, requirements business rules analysis, database coding, implementation, data collection, analysis, and reporting from a variety of sources including mainframe files, and vendor extracts.
TECHNOLOGIES:
Oracle Designer, Visual Basic 6.0, Crystal Reports, MySQL 4.1/5.0, Oracle 11g PL/SQL, SQL, CA Erwin 7.3.2, SQL Navigator, Excel VBA, Toad for Oracle, Rapid SQL,Perl V and Microsoft Office.
EXPERIENCE:
Confidential. Charlotte, NC 9/2009 - Present
Senior Financial System Analyst
As a Financial Data System Analyst, I am responsible for creating and maintaining Enterprise Reports. All reports are created using Excel 2007 and Share point. This was accomplished by using SQL and creating views to extract data from various databases. Automated all cost journal entries into PeopleSoft. This was accomplished by developing a data mart. Extracting data from various ACN\'s Oracle corporate databases. This data mart was created in Oracle 11g which represented monthly customers, service providers and the costs charged by vendors to ACN. Used Erwin 7.3 to create the logical and physical models for the cost data mart along with all supporting tables, indexes and store procedures.
Confidential Charlotte, NC 10/2008 - 4/2009
Data Modeler (Consultant)
Performed data analysis to determine information requirements. Analyzed data models to ascertain functionality. Assisted with development and ongoing maintenance of data modeling environment. Participated in development of data warehouses/marts models on Netezza and Oracle platform. Worked with application developers to map process models to data models. Performed logical and physical OLAP/OLTP schema designs. Developed capacity plans for new and existing system in CA Erwin. Achieved reuse of existing structures and models.
Confidential Winston-Salem, NC7/2007 - 4/2008
Lead Data Modeler
Lead database modeler for a major mortgage insurance project by applying Oracle 10g theory of database modeling using Oracle designer. Assisted with development and ongoing maintenance of data modeling environment. Created logical business models and transformed into a physical data model instances. Maintained all Oracle corporate databases, data dictionaries and schemas.
Confidential New York City, New York 6/2006 - 7/2007
Data Manager
Managed the computer operations for a worldwide home textile company. Developed reporting solutions using crystal reports for Finance department. Manually resolve items that cannot be resolved via automation in a timely manner. Establish data improvements of the data loading process creating scripts in Perl V. Developed strategy for production data loading and data mapping creating scripts in PERL, which loaded data into MySQL 5.0. Created databases using MySQL 5.0. Created schema s, tables, triggers, indexes, views and sequence generators. Created backup and recovery plans using MySQL administrator. Support Data Mining/Data Access needs (e.g. MySQL SQL queries/data extracts, information on data availability and database design, information on data validation results). Streamline the Company\'s management reporting process by developing Excel VBA applications. Worked with management to define/refine data quality standards, requirements, and validations.
Confidential Far Rockaway, New York 4/2004 - 4/2006
Data Manager
Managed seven technologists who support all data entry and requests from management. Improved clinical data collection and reporting of information by designing, coding and managing several projects that included: Emergency Tracing Project: gathered the requirements model the database (logical and physical) and coded the User Screens. Created a database in MySQL 4.1 and user screens in Visual Basic 6.0. Dietary Order Project: gathered the requirements, model the database (logical and physical). Database designed and implemented in MySQL 4.1. Infection Control Project: gathered the requirements wrote the specifications and model the database (logical and physical). Database designed and implemented in MySQL 4.1
Confidential New York, New York 2/1999 - 4/2003
Information Technology Manager for the Transplant Department
Managed six technologists who support all data entry and reporting requests for management. Created several relational databases for clinical, research, pathology, tissue bank and a survey programs. Designed all logical and physical data models using IE methodologies. Coded applications using Visual Basic 6.0, Apex Db Grid Pro, MS-SQL 7.0 and Crystal 8.5. Developed all business rules and implemented them in Oracle 8 by writing constraints, indexes, triggers, and stored procedures in PL/SQL.
EDUCATION:
Professional Certification - Application Programming
Bachelor\'s Degree - Accounting and Economics
TRAINING:
- Oracle Training - Data Modeling and Design 9/1997
- AIX Version 4 Basic Unix 1/2000
- AIX Version 4 System Administration 3/2000
- Korn Shell programming 6/2000
- PERL V Programming 7/2000
- IBM Data Modeling Workshop 10/2000 - 4/2003