We provide IT Staff Augmentation Services!

Sr.system-analyst Resume

3.00/5 (Submit Your Rating)

Ma, UsA

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 skills and proven ability to analyze and translate complex business tasks into solid system design. Proven ability to work in a mission critical operations and support environment. 5 years experience architect and implementing business intelligence solutions in Oracle and Microsoft enviroment.

SKILLS:

Programming: MS Visual Basic, MS Visual InterDev, VB Script, Java Script,
Perl Script, C++, DataStage7.5.2, Business Objects/Crystal Enterprise 8.5, 9.0, 10, Crystal Reports, Report scheduling, Professional
Active Reports, MS Visual SourceSafe, Wise Installation System, DAO, RDO, ADO, ActiveX, OLE, HTML, DHTML, ASP, COM/DCOM, SQL, PL/SQL
Databases:MS SQL Server , Oracle 8i, 9i, MS Access, ODBC, Sybase
Software:EAGLE PACE, PORTIA, DataStage 7.5.2, MS Word, MS Excel, MS Front Page, Microsoft Project 98, AutoSys ACE,
Heroix, IBM InfoSphere QualityStage Module for Geolocator Version 2.0.1
Operating Systems:XP Professional, Windows Vista, Windows 7

EXPERIENCE:

Aug.,-06- Present,Confidential, Sr.System-Analyst, Westwood, MA

  • Documents the business and end-user requirements for Data Delivery Services projects.
  • Prepares conceptual and logical data models in support of Data Delivery Services projects.
  • Developing a data warehouse or data mart involves design of the data warehouse and development of operational processes to populate and maintain it. ELF Programming
  • Identifies data accountability, controls and access levels.
  • Conducts data audits to evaluate the quality and integrity of the data.
  • Materialized views, Stored procedures, Index organized tables, Collectios, Dynamic SQL.
  • Supports the development of analytic applications including Crystal, Enterprise.
  • Supports the development and implementation of major database applications.
  • Contributes to the alignment of technical recommendations with business objectives by understanding the strategies and objectives of supported business units within NSTAR.

Arp.,-05- Aug.-06,Confidential, Application Analyst Burlington, MA

  • Responsible for all the aspects of managing production Charles River IMS 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, provide 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
  • Working to smoothly transition new Hosting, ASP, and RMS Clients to production operation.
  • Working with vendors as partners to deliver a tightly integrated, seamless service to Charles River Clients.
  • Participate in the development and on-going refinement, enhancement and continuous process improvement for Hosting, ASP, and RMS services.
  • Serve as 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.
  • Ensure proper integration of CRD into current data environment, as well as intraday and nightly production cycles.
  • Provide expertise during the analysis phase on existing CRD environment, applications, and business needs.
  • Contribute to coding, including writing custom importers and exporters into and out of CRD.
  • Document system cycles and processes and trained support staff.
  • Support staff development and knowledge sharing.
  • Provide technical expertise and development direction of project.
  • Additional tasks included 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)

Sep., 00-Jan.,05 ,Confidential, Senior System Analyst Boston, MA

  • Provide 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, 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. A large conversion project from a manual processing into PACE
  • Interact with other IS team members and various business units in defining and developing complete computer based solutions using Visual Basic, Access, SQL Server.
  • Provide problem-solving services for end users.
  • Provide 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.


June, 99-Sep., Confidential, Senior Programmer Analyst Boston, MA

  • As a member of Information Technology Department team participatedin the major automation company initiatives.
  • Utilized VISUAL BASIC 5.0 to design and implementation of newdevelopment MPF Project
  • Responsible for business analysis, design and implementation of
  • Collateral system to support company financial processes includebusiness reporting system.
  • Developed data access layer using ADO technology and MS SQL ServerTransact SQL.
  • Year 2000 testing. Maintain duplicate of Bank\'s computer system.Researched errors to determine cause.

March, 98-Jan.,99 , Confidential, Software Engineer Brooklyn, NY

  • Developed the Sales Order Management System. The purpose of this application is to support all phases of purchase and sales process. Application provides all contracts information, summarizes data by products, customers, or vendors, and prepares necessary documentation. Primary responsibilities included coding, designing and implementing of front-end components.
  • Participated in the development of The Inventory Control Application for midsize Distribution Company. Coded application components.
  • Participated in the development of Accounts Tracking and Reporting System for a financial institution. Designed and coded program for finding discrepancy in company’s database.
  • Technologies: Visual Basic 5.0, Oracle 8.0, MS SQL Server 6.5, MS Access 7.0, DAO 2.0, RDO 2.0, Crystal Report 4.6.

EDUCATION:

Confidential, University
MET CS 331
Introduction to Object- Oriented Programming with C++

Confidential,University
MET CS 201
Introduction to Computer Science with C++

Confidential,University Corporate Education Center
1013 Mastering Microsoft Visual Basic 6 Development

Confidential,Group, Inc
SQL Server 7.0 Administration
Advanced Crystal Report 7.0

Confidential,Computer School
Advanced Client/Server Application Development Program.

Confidential, Engineering University
Master Degree in Economics

We'd love your feedback!