SUMMARY:

Expertise in Application Development and Data Management with the creation of business requirements, technical requirements, and functional specifications. Expert in Information Architecture, Business Intelligence solutions, and Project Management with the purpose of defining new enterprise solutions. Solid analytical and problem solving skills. Excellent communication skills necessary to build strong relationships with Stakeholders necessary to identify, define, and document business challenges and opportunities.

PROFESSIONAL EXPERIENCE:

Confidential, Newton, MA

Database Design Analyst

Responsibilities:

• Performed Data Mapping and Data Profiling by analyzing BRD/TRD user requirements for reports, forms, queries, and data extraction to obtain a comprehensive understanding of the business requirements.
• Documented data profiles to drive data modeling and source to target mappings
• Defined new business and data definitions
• Collaborated with analysts, architects and developers
• Created data mappings, transformation logic(for logical and physical models) to support implementation and ongoing maintenance of the operational data stores and warehouses.

IT Environment: SQL Server, Oracle, SQL Developer, Agile Project Management

Confidential, Boston, MA

Senior IT Business Analyst / Data Analyst

Responsibilities:

• Develop product awareness of the National Commercial Lines Administration system, becoming an SME.
• Interacting with Business Units: Underwriting and Claims to understand business use cases for the purpose of defining the data integration between the two systems.
• Creation of Data Modeling documents of both systems along with product assessment of the Commercial Lines for gap analysis between the Business Requirements for the application and what was actually delivered and seek from the Stakeholders either approval of acceptance or changes they want to see.
• Leading a team of IT Business Analysts
• Created functional documentation of the Commercial Lines Administration system that details the process flow to create a policy primarily targeting the selection of coverages and the mapping of data between the Commercial Lines and Personal Lines systems.
• Creation of training documents and coordination of training sessions for the Business Units
• Coordinating requirements for Java & PL/SQL developers including the use of Business Rules, Technical Rules and Translation tables.
• Serve as a Solutions Architect as defects or unexpected software changes are introduced with each new release of the Commercial Lines Administration application is implemented.
• 2013 Recipient of the “Award in Excellence” from Confidential as nominated by my peers from the National Commercial Lines project.
• Supported Personal Lines systems for TRONWEB development/roll - out
• Developed a Data Dictionary for use to develop Business Requirements and Test Plans
• Develop knowledge of TRONWEB processes (Web application)

IT Environment: Cover-All, Oracle 10g, SQL Developer, Microsoft Visio, Agile Project Management

Confidential, Westborough, MA

Senior Data Architect/Data Analyst

Responsibilities:

• Integration of business architecture solutions to other enterprise software packages
• Mentor enterprise business teams building complex reporting and analytics utilizing COGNOS 8 as the reporting platform
• Started re-design of ETL processes to use DATASTAGE instead of ORACLE PL/SQL and include new enterprise businesses requirements.

Confidential

Project Leader

Responsibilities:

• Expansion of the Domestic Transportation Data Warehouse in an ORACLE 10g environment
• Conduct business reviews of new data sources and their impact on current reporting
• Coordinate migration from Cognos 7 to Cognos 8
• Re-design data model based on new enterprise business requirements incorporating the original Star-Schema into a SnowFlake-Schema.
• Modify ETL process to include modified data model and apply rule changes
• Validate regression testing variances for enterprise business teams
• Migration to a new windows server and middleware application (ESKER) for the fax application that uses Crystal Reports as the backbone for report formatting
• Converted process by which carrier and vendor faxes are created and sent
• Partnered with ESKER team developing new forms and processes
• Direct migration from a transactional database to an analytical data warehouse
• Conduct interviews with enterprise business teams to understand business requirements
• Design data warehouse data models based on the Star-Schema methodology
• Establish data mart documentation standards for the use of developing complex reporting and analytics based on business requirements
• Design and build the ETL process utilizing PL/SQL
• Validate regression testing variances for enterprise business teams
• Assist in migration from Crystal Reports to COGNOS 7 for reporting purposes.
• Mentored various levels of enterprise business users in the use of COGNOS 7

Senior Technical Analyst

Confidential

Responsibilities:

• Responsible for planning and implementation of interfaces between multiple enterprise divisions within TJX as part of the enterprise system migration from a manual process logistics system to a system packaged software application, MANUGISTICS in an ORACLE 9i environment.
• Design use for faxing vendor and carrier communications
• Design & Build on-line user interface for Freight Payment Department to facilitate data entry of carrier invoicing
• Lead application development team for several software upgrades of the MANUGISTICS application maintaining data integrity
• Support Crystal Reports development.
• Coordinated efforts between U.S. development team and offshore development teams

IT Environment: UNIX server, MANUGISTICS, Oracle 10g, EMBARCADERO Rapid SQL, Toad, JDA MANUGISTICS 7.5 Client & Web Apps, COGNOS 8, ESKER Fax Processing, Crystal Reports, PL/SQL, VB6, UNIX vi editor, Datastage, Microsoft Project, PowerPoint, Microsoft Visio

Confidential, Boston, MA

Lead Systems Analyst

Responsibilities:

• Partnered with Share Value Business team defining year-end initiatives, expansion and enhancements
• Generated and distributed monthly reports to external clients including use of Intranet distribution
• Consulted by other enterprise business groups to assist in cost effectiveness to perform business modifications in-house or to out-source

IT Environment: DB2, SQL, MAINFRAME, Cobol II

Confidential, Andover, MA

Project Control Officer

Responsibilities:

• Created and implemented project plan for scheduling work that had been back logged
• Facilitated efforts between U.S. systems development teams and offshore development teams

Project Leader

Confidential

Responsibilities:

• Implemented application modifications to the Claims system necessary for Year2000 processing
• Utilized a suite of VIASOFT products to create Resource Estimations (ANALYZER), Coding Modifications (SmartEdit) and Unit Testing (SmartTest) to aid in the development of file conversion routines
• 1998 Recipient of the “Above and Beyond Award” for individual recognition

IT Environment: DB2, SQL, MAINFRAME, Cobol II

Confidential, Boston, MA

Consultant

Responsibilities:

• Gathered Business Requirements for system upgrades and enhancements
• Direct interface with the financial business department for coordination of Year-end reporting
• Document data flow of Year-end processing and identifying risks and providing technical solutions to correct process weaknesses to streamline and shortened Year-end processing time

IT Environment: MAINFRAME, Cobol II, AS400, RPG ile

Confidential, Portsmouth, NH

Senior Programmer/Analyst

Responsibilities:

• Direct interface with other IT Systems Groups to define and load metadata into a DB2 environment for the Coordination of the ETL process to ensure data integrity while monitoring and identifying system optimization for multiple department feeds
• Recipient of the following acknowledgements

Confidential

Programmer/Analyst

Responsibilities:

• Support Application Development Teams with business & technical solutions
• Evaluated TELON upgrades prior to Application Development roll-out by creating an automated process to evaluate cause and affect of TELON software upgrades reducing the conversion time by up to 3+ months
• Guest Speaker at the Confidential, Scottsdale, AZ. “Successful Strategies for Upgrading between TELON Releases.”

Application Programmer

Confidential

Responsibilities:

• Followed life cycle methodologies for application changes involving business requirement gathering, creation of technical specification documents and performing regression testing

IT Environment: DB2, SQL, MAINFRAME, Cobol II, C, JCL, ISPF, Assembler, Telon, PL/1