Melissa Clement Email & Phone Number

Boston, Ma, Us

Boston, Ma, Us

Responsible for the designing, coding, testing, and implementation of a high-profile, strategic, multi-phased Catastrophe Modeling data project within scope and on time. Proactive compliance with security, data, and production control standards. Creation of all documentation for data flow diagrams and related notes, data mappings, data model, data dictionary, test plans, and implementation plans.Design and development of ETL processes using Informatica and UNIX scripts.Maintenance of SAS programs for creating Control Reports used by the business.Mentoring the development of several junior team members. Conducting code reviews and ensuring all standards are being adhered to.Responsible for the IT support for multiple Catastrophe Modeling software vendor application tools. Responsible for the installation and maintenance on a pre-determined schedule with the coordinated effort of multiple business teams as new versions are made available.Coordinate Infrastructure departments, as needed, for application upgrades.Software/Technologies Used: MS SQL Server, DB2, Teradata, Informatica, ERwin, MS SQL Server Management Studio, AIR, RMS, Remetrica, SAS, Mantis Bug Tracker, and CVS

Boston, Ma, Us

Responsible for creating and maintaining the data model for a large reinsurance reporting project.Designed a reusable database post-load Audit session in Informatica.Developed ETL processes using Informatica and UNIX scripts.Created Autosys scripts for the Informatica sessions.Created SAS Information Maps to be used with SAS Web Report Studio.Software/Technologies Used: DB2, Teradata, Informatica, Rapid SQL, ERwin, IBM's Rational Application Developer, Teradata SQL Assistant, SAS, UNIX, Autosys, Mantis Bug Tracker, and CVS

Boston, Ma, Us

Developed, supported, and administered a financial planning and forecasting application. Gathered, documented, and prioritized business requirements, change requests, and bug fixes.Created and updated database models using ERwinDeveloped DB2 & Teradata SQL queries, table creation scripts, triggers, inserts, and updates. Created ETL processes using Informatica, UNIX scripts, and Autosys.Clearly communicated progress and issues to team members, business clients, and management.Coordinated Infrastructure departments, as needed, for application upgrades.Software/Technologies Used: Hyperion Planning, Hyperion Essbase, DB2, Teradata, Informatica, Rapid SQL, ERwin, IBM's Rational Application Developer, Autosys, UNIX scripts, Mantis Bug Tracker, and CVS

Implemented and tested the user interface for distributed web-based software that monitors system performance. Used Java 2 Platform, JFC Swing components, JSP, HTML, JavaScript, XML, XSL, third party Java APi's and SQL. Collaborated on project designs and specifications. Wrote customized Swing classes for some of the components and adhered to company colors for the look and feel scheme.Designed and implemented JSP pages to optimize getting and displaying data on the screen. Wrote Java applets to be used in the web based UI.Implemented the XSL transform technology for HTML based screens. Worked with XML files that were used to display data or deliver other information to the UI. Software/Technologies Used: ClearCase, Visual SlickEdit, SilverStream application/webserver, Jetty webserver, and TeamTrack

Developed, tested, and implemented a 3-tier client/server object-oriented software system using Java, CORBA, and Oracle. Used proprietary components for screen layout. Responsible for implementing and testing Business Analyst screen designs.