SUMMARY:

• Highly motivated and experienced professional with proven technical and problem solving skills to design, code and maintain a wide range of Client/Server applications. Strong analytical capability and skilled at analyzing and translating complex business tasks into solid system design. Demonstrated success working in mission critical operations and support environments. 5 years experience in architecting and implementing business intelligence solutions in both Oracle and Microsoft environments. Reputation for high - quality work, reliable solutions, and commitment to user satisfaction.

TECHNICAL SKILLS:

Programming: MS Visual Basic, VBA, MS Visual InterDev, VB Script, Java ScriptPerl Script, Unix Shell Scripts, C++, DataStage7.5.2, Business Objects/Crystal Enterprise 8.5, 9.0, 10, Crystal Reports, OLAP, Report scheduling, Professional Active Reports, MS Visual SourceSafe, Wise Installation System, DAO, RDO, ADO, ActiveX, OLE, HTML, DHTML, ASP, COM/DCOM, SQL, PL/SQL, Sharepoint

Databases: Oracle 8i, 9i, 10g, DB2, MS SQL Server 2005, MS SQL Server 2008 R2, MS SQL Server 2012, SSIS, SSRS, MS Access, ODBC, Sybase, PL SQL, T-SQL

Software: EAGLE PACE, PORTIA, CRD, DataStage 7.5.2, ETL Tools Informatica 5.x/6.x/7.x/8.x/9.1, Informatica Power Exchange, Quality Stage, MS Word, MS Excel, Microsoft Project 98, AutoSys ACE, ControlM, Heroix, IBM InfoSphere QualityStage Module for Geolocator Version 2.0.1

PROFESSIONAL EXPERIENCE:

Confidential

Eagle Systems Analyst

Responsibilities:

• Strong technical experience working on Eagle Suite including STAR and PACEand related tools.
• Design, develop and code review using Oracle, PL/SQL
• Experience writing simple to complex SQL for data analysis, data mining and ad hoc queries
• Worked closely with the Program Management Office (PMO), business users, QA, developers, and other technology professionals to ensure that project deliverables are completed efficiently and on time.

Confidential

Eagle Investment Consultant

Responsibilities:

• Developing and testing Interfaces that import and export data from/to Eagle PACE.
• Participate in studying client requirements and current business processes for any PACE system process enhancements, including new system functionality, version upgrades, and reporting requirements
• Working with the investment divisions and / or Quality Assurance to ensure plans for each of the enhancements are executed and that the final deliverables are accepted in a timely fashion.
• Assist with the testing and implementation of the Eagle PACE system including creating test plans and testing with QA teams. Coordinate User Acceptance Testing (UAT).
• Expertise in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading using Datastage
• Strong experience in loading and maintaining Data Warehouses and Data Marts using DataStage ETL processes.

Confidential, Boston, MA

Application Specialist - Hosted Services

Responsibilities:

• Provide support to Confidential customer base. Perform system implementations and upgrades, support ASP solutions, ad hoc reporting with Confidential, ensure systems are effectively monitored and maintained and provide technical resource for customer support enquiries.
• Perform business analysis and gather requirements around the operational support of Confidential ’s hosted offering.
• A solid understanding of trading and portfolio management.
• Knowledge of securities markets and the business and technical challenges facing investment managers, broker/dealers, ECNs, exchanges and other trading participants related to straight-through processing and trade connectivity.
• Install client custom code, Confidential applications, data load interfaces, toolkits, SSIS, SQL Agent jobs, etc.
• Test custom code prior to deploying into client’s User-Acceptance and/or Production environments.
• Document custom-developed code and create install/user instructions.
• Assist with the on-going maintenance of customizations available in the hosted environment as new core releases are made.
• Participate in the monitoring of SQL jobs, DR testing, and on-call duties when competency is achieved.
• Assist Confidential Client Services with 2nd level support related to infrastructure and operational issues.

Confidential, Smithfiled, RI

Principal System-Analyst

Responsibilities:

• Demonstrate expertise in data integration, data and ETL architecture, data modeling and database design; data warehousing design and development, extensive PL SQL usage and Datastage ETL tool.
• Responsible for PMR, QIR and Plan Accounting reports data readiness on monthly and quarterly basis and insure the reports generated and sent to business and clients on time.
• Demonstrate experience delivering production systems across a range of application domains and vendor platforms.
• Experience in Informatica mapping specification documentation, tuning mappings to increase performance, proficient in using Informatica Server Manager to create and schedule workflows and expertise in ControlM scheduling.
• Provide application support and data quality support to monthly and quarterly reporting cycles.
• Provide detailed analysis on production issues or system defects.
• Assist in translating business requirements to systems solutions.
• Participate in application migrations/installation.
• Respond to customer service requests and provide production support coverage, on a rotational basis (12x7), consistent with service level agreements.
• Interact with other Fidelity systems organizations to support upstream and downstream dependencies.
• Experience in all phases of Software Development Life Cycle (SDLC) like Requirement Capturing, Data Modeling and Designing, Developing, Testing, Quality Assurance, Implementing, Documenting and User for various business applications.
• Work with quality assurance group to provide details of fixes or enhancements in order to build appropriate test cases.
• Assists in the planning and the conducting of user acceptance testing.
• Deep understanding of agile software development processes.

Confidential, Westwood, MA

Sr.Programmer-Analyst

Responsibilities:

• Documented the business and end-user requirements for Data Delivery Services projects.
• Prepared conceptual and logical data models in support of Data Delivery Services projects.
• Developed a data warehouse or data mart involving design and development of operational processes to populate and maintain it. ETL Programming
• Building data models, capturing metadata, specifying ETL, and data quality evaluation and improvement.
• Identified data accountability, controls and access levels.
• Conducted data audits to evaluate the quality and integrity of the data using IBM WebSphere QualityStage and IBM WebSphere DataStage, part of the IBM WebSphere Integration Suite and an Oracle9i instance.
• Proficient in server side programming like Procedures, Functions, Materialized views, Database Triggers, Packages using PL/SQL and SQL.
• Worked extensively with SQL Loader using control files for data ware housing and data loading into oracle database tables.
• Supported the development of analytic applications including Crystal, Enterprise.
• Supported the development and implementation of major database applications.
• Contributed to the alignment of technical recommendations with business objectives by understanding the strategies and objectives of supported business units within Confidential .

Confidential, Burlington, MA

Application Analyst

Responsibilities:

• Managed Charles River IMS production systems for multiple clients as part of the Charles River Hosting, Application Service Provider (ASP), and Remote Management Services (RMS) service offerings.
• Working closely with Clients, provided expert level remote management, administration and support for Client production CR IMS solutions, including:
• Client assistance in optimal use of the system
• User administration/privileges
• Parameter configuration changes
• System availability
• Application and database performance tuning
• Daily operational processing monitoring and support
• CR IMS and database software patches
• CR IMS version upgrades
• Assistance with problem support and resolution
• Business Continuity/Disaster Recovery assistance
• Worked to smoothly transition new Hosting, ASP, and RMS Clients to production operation.
• Partnered with vendors to deliver a tightly integrated, seamless service to Charles River Clients.
• Participated in the development and on-going refinement, enhancement and continuous process improvement for Hosting, ASP, and RMS services.
• Played an integral role in the investigation, implementation, and operation of 3rd party tools to enhance/improve, automate, and streamline the delivery of Hosting, ASP, and RMS services.
• Ensured proper integration of CRD into current data environment, as well as intraday and nightly production cycles.
• Provided expertise during the analysis phase on existing CRD environment, applications, and business needs.
• Contributed to coding, including writing custom importers and exporters into and out of CRD.
• Documented system cycles and processes and trained support staff.
• Supported staff development and knowledge sharing.
• Provided technical expertise and development direction of project.
• Performed additional tasks including setting project schedules, reporting to stakeholders, ensuring company standards.
• Played important role in the major upgrade (Version 7.2.3.7 to Version 8.1.3)

Confidential, Boston, MA

Senior System Analyst

Responsibilities:

• Provided maintenance, troubleshooting, enhancements and support for Investment Administration and Operation, Mutual Fund Administration, Corporate Finance and Legal/Compliance.
• Responsible for several core vendor systems such as: Eagle Pace - A Data Warehouse, PORTIA - Accounting system, CTI Examiner - Company’s Pre-Clearance System.
• Played an integral role in implementation of Web-based Pre-Clearance System allowing employees to pre-clear personal trades for compliance purposes. Performed data analysis, data migration from the existing system into new system. Created Securities, Account Trades, Orders and Corporate Actions feeds from Data Warehouse into Pre-Clearance system. Wrote custom stored procedures to call from within the ‘master’ procedure to meet business needs.
• Played significant role in the automation of the Mutual Funds Performance Measurement process, large conversion project from a manual processing into PACE
• Interacted with other IS team members and various business units in defining and developing complete computer based solutions using Visual Basic, Access, SQL Server.
• Provided problem-solving services for end users.
• Provided ongoing systems administrations, design and implementation, and technical documentation.
• Responsible for monitoring data feeds from SSB to PACE
• Responsible for writing uploaders and exporters to import/export data to/from PACE.
• Wrote multiple Pace Advanced Reports.
• Created stored procedures, views, to implement Business rules.
• Participate in Eagle PACE and PORTIA Upgrade.

Confidential, Boston, MA

Senior Programmer Analyst

Responsibilities:

• As a member of Information Technology Department team participated in the major automation company initiatives.
• Utilized VISUAL BASIC 5.0 to design and implement new development MPF Project
• Collateral system to support company financial processes include business reporting system.
• Developed data access layer using ADO technology and MS SQL Server Transact SQL.
• Year 2000 testing. Maintain duplicate of Bank's computer system. Researched errors to determine cause.