We provide IT Staff Augmentation Services!

Systems Analyst Resume

2.00/5 (Submit Your Rating)

NJ

OBJECTIVE:

To obtain a Business Systems Developer/Analyst Lead position working with Business Units, Project Teams, Process Teams to ascertain initiatives relative to the improvement of Business Processes across the organization with a growing dynamic company offering potentials for technological enhancement and career advancement.

SUMMARY:

Twenty Plus Years of Business Intelligence Information Systems Development and Analysis experience working with a variety of Mainframe/Fourth Generation Languages and Relational Database Management Systems and n - tier architecture applications and a variety of platforms designing financial, sales and marketing ETL/OLAP utilizing Microsoft toolset technology for applications on various platforms in the Healthcare, Insurance, Telecommunications, Banking and Pharmaceutical industries. Excellent balance of business and technical knowledge, and outstanding analytical skills. Excellent verbal and written communication skills.

PROFESSIONAL EXPERIENCE:

Confidential,NJ

Systems Analyst

Responsibilities:

  • Responsible for reviewing clinical trial studies documents for Bayer and Merck drug trial studies and setting them for archival data storage.
  • Responsible for determining data storage format according to document format.
  • Reformatted files utilizing Adobe Acrobat 9.
  • Responsible for data format cleansing according to the particular drug study.

Environment: Windows, Microsoft, Abode Acrobat

Confidential, Tampa, Fla

BI Analyst

Responsibilities:
  • As Project Lead for The State of North Carolina Government Institutions, reviewed clients’ information needs and provided analytical reviews for Oracle, Microsoft, Cognos, and SAP platforms.
  • Responsibilities include interpret business requirements and define technical alternatives, tools, and approach for defining business requirements.
  • Responsible for Change Management guidelines.
  • Responsible for laying roadmap to facilitate project objectives for client and project paperwork deliverables.
  • Designed data marts and universes for reporting purposes utilizing Business Objects.
  • Performed desktop support duties for several agencies for the State of NC.
  • Responsible for development of Supply Chain analytical models.
  • Responsible for creation of T-SQL queries for financial query process and data maintenance.
  • Developed dashboards in Qlikview and Tableau for reporting analytics.
  • Developed DMR models for financial analytical reporting.
  • Developed, test, implemented and documented the technical solutions to address the defined business requirements.
  • Responsible for developing Oracle Financial modules for financial reporting .
  • P erformed training to end users on applications.

Environment: Windows NT, Unix, Oracle 11i, Hadoop, Oracle ERP Suite, SQL Server 2005/2008,Qlikview, Tableau, PL/SQL, SSAS, SSRS, SSIS, MDX DB2, Cognos Series 7/8/10, Business Objects XI, Crystal Reports,

 Confidential, Marietta, GA

BI Analyst (backfill position)

Responsibilities:
  • Gathered business requirements for client World Trade Center Health Fund and translated those requirements into reporting solutions for Oracle and SAP platforms.
  • Responsible for developing Oracle Financial modules for financial reporting.
  • Designed Xcelsius Dashboards for financial reporting.
  • Responsible for creation of T-SQL queries for financial query process and data maintenance.
  • Responsible for developing BI financial reports utilizing Crystal Reports.
  • Developed MDX cubes utilizing MDX.
  • Developed ETL processes of overnight data loads.
  • Developed queries to analyze financial data.

Environment: Windows NT, Unix, Oracle 11i, Oracle ERP Suite, SQL Server 2005/2008, PL/SQL, SSAS, SSRS, SSIS, MDX DB2, Cognos Series 7/8/10, Business Objects XI, Xcelsius, Crystal Reports,

Confidential, Raleigh, NC

Senior Systems Developer

Responsibilities:
  • As Project Lead at Arlington Pharmaceutical Company, reviewed clients’ information needs and provided analytical reviews.
  • Responsible for the configuration, testing and implementation of reporting needs for the CLv2 (CORE LIMS V2) implementation in a GxP environment for a Microsoft BI and COGNOS platforms.
  • Responsible for Change Management guidelines.
  • Adhered to GMP 21 CFR 210 and 211 regulations thru SDLC process.
  • Responsible for developing Oracle Financial modules for financial reporting.
  • Performed reporting analysis on sales call activity.
  • Responsible for creation of T-SQL queries for financial query process and data maintenance.
  • Designed Business Objects reports for financial reporting.
  • Designed data marts and universes for reporting purposes utilizing Business Objects.
  • Responsible for designing complex data models utilizing Erwin.
  • Responsible for Designing and implementing data warehouse utilizing ETLsolutions on Microsoft BI Stack using SSIS and building SSAS cubes with complex data (dimensions, measures, data source views).
  • Responsible for performance tuning and deploying and processing SSAS cubes.Designed MDX queries for analysis in SSAS.
  • Responsible for SQL server table and SSAS cube partitioning. Creating SSRS reports using SSAS as data source; passing parameters to drill-down reports
  • Responsible for utilizing Oracle Streams for data capture for clinical trial databases.
  • Responsible for development of Supply Chain analytical models.
  • Developed action plans and service level agreements with internal customers.  Built long-term relationships with key
  • Responsible for implementing sales call tracking reporting application.
  • Designed and implemented database design for financial and marketing applications in COGNOS. Performed SDLC system development life cycle duties for COGNOS Financial Reporting System applications. Responsible for final system testing and implementation of COGNOS applications.
  • Responsible for configuration of COGNOS Framework Manager Packages and SDK.
  • Responsible for making recommendations for utilization of COTS 3rd party tools which resulted in 50% overall system enhancement.
  • Designed complex reports utilizing SSRS.
  • Designed queries to extract data using SQL Server 2008.
  • Performed detailed analysis to fully identify customer’s systems change request.
  • Created detailed, clear and thorough specifications for all systems change requests.
  • Responsible for troubleshooting software problems.
  • Responsible for resolving network issues and end user system problems.
  • Ensured that strategies, plans and deliverables for application design were met on time.

Environment: Windows NT, Unix, Oracle 11i, ProClarity, Oracle ERP Suite, Microsoft CRM, SQL Server 2005/2008, PL/SQL, SSAS, SSPS, SSRS, SSIS, MDX, DB2, Cognos Series 7/8, Business Objects, Xcelsius, XI, Data Integrator, UNIX, MS-ACCESS 2003

Confidential, Charlotte, NC

Database Analyst

Responsibilities:
  • Responsible for maintaining an Oracle 9i database, which tracks donor donations for a relief organization. 
  • Assisted in database tuning and optimization for reporting purposes.
  • Responsible for supporting IT marketing applications.
  • Worked with Data Analysts/Modelers with mapping data from source to target systems.
  • Responsible for Change Management guidelines.
  • Developed and tested Mainframe / ETL processes, including program and systems documentation and test plans, according to established IS standards.
  • Developed and maintained CRM Marketing sytems.
  • Responsible for configuration of COGNOS Framework Manager Packages and SDK.
  • Utilized TOAD for database development.
  • Responsible for schema and data modeling development in Oracle 9i.
  • Responsible for Oracle Forms development for front end process.
  • Designed queries utilizing Oracle Discoverer 4.1 for financial reporting.
  • Responsible for creating UNIX scripts for historical data load processes.
  • Designed queries to extract data using SQL Server.
  • Responsible for database schema design and T-SQL development.
  • Designed data marts and universe structures for reporting purposes utilizing Business Objects.
  • Utilized Business Objects SDK/Enterprise for application design.
  • Utilized Crystal Xcelsius to create dashboards to reflect donor donations.
  • Utilized Business Objects/Crystal Reports to develop extensive financial reports.
  • Responsible for application of CMMI methodology techniques for IT applications.
  • Responsible for creating financial reports using COGNOS Impromptu.
  • Designed and created COGNOS Power Play cubes for OLAP reporting process.
  • Responsible for developing COGNOS Contributor datasheets for management comparison reports.
  • Responsible for building and testing of COGNOS cubes.
  • Support and troubleshoot production systems as required, optimizing performance, resolving production problems, and provided timely follow-up problem reports

Environment: Windows NT, Oracle 9i, SQL Server, PL/SQL, Cognos Series 7/8, Autosys, AS400, UNIX, Business Objects/Crystal Reports, Xcelsius

Confidential, Charlotte, NC

Sr. Hardware Technician

Responsibilities:
  • Responsible for reviewing schematics of computer hardware of multiple product lines of business control machines for IBM.
  • Work with design engineers to ensure that product development is done in timely matter and within budget.
  • Responsible for building of computer communications hardware from initial development phase.
  • Responsible for loading of software to ensure that products are operating properly.
  • Responsible for pretest and final testing of hardware.

Environment: Windows NT, Nortel Hardware, IBM Hardware

Confidential, Charlotte, NC

Sr. Application Developer

Responsibilities:
  • Responsibilities include interpret business requirements and define technical alternatives, tools, and approach for Equifirst Mortgage Brokerage company.
  • Designed data marts and universe structures for reporting purposes utilizing Business Objects.
  • Responsible for ownership and support of sales and marketing applications.
  • Served as lead person for all sales and marketing IT applications.
  • Developed, test, implement and documented the technical solutions to address the defined business requirements.
  • Responsible for creation of T-SQL queries for financial query process and data maintenance.
  • Performed detailed analysis to fully identify customer’s systems change request.
  • Created detailed, clear and thorough specifications for all systems change requests.
  • Worked with Data Analysts/Modelers with mapping data from source to target systems.
  • Develops and tests Mainframe / ETL processes, including program and systems documentation and test plans, according to established IS standards .
  • Responsible for backend development process.
  • Responsible for extracting large historical data sets databases into data repositories.
  • Responsible for data warehouse development utilizing Oracle Warehouse Builder.
  • Responsible for schema and data modeling development in Oracle 9i.
  • Wrote PL/SQL queries for data extractions.
  • Responsible for writing SQL to extract data from and import to DB2, Oracle & Teradata
  • Utilized MLOAD, FASTLOAD, and TPUMP utilities for Teradata.
  • Utilized Business Objects/Crystal Reports to develop extensive financial reports.
  • Designed data marts and universe structures for reporting purposes.

Environment: Windows NT, UNIX, ORACLE 9i, PL/SQL, COGNOS Series 7, SSAS, SSIS, PERL, ERWIN, DB2, BUSINESS OBJECTS, Xcelsius, SQL SERVER

Confidential, Newark, NJ

Sr. Systems Developer

Responsibilities:
  • Responsibilities include interpret business requirements and define technical alternatives, tools, and approach for JC Penney.
  • Responsible for ownership and support of sales and marketing applications.
  • Served as lead person for all sales and marketing IT applications.
  • Developed, test, implement and documented the technical solutions to address the defined business requirements.
  • Participated with the development team and IT staff as appropriate in the design of solutions.
  • Collaborated with other team members to define effort estimates, time tables and project plans.
  • Collaborated with other technical areas to integrate across tiers, platforms, and responsibilities.
  • Responsible for data loading into Staging and Star Schemas correctly for operational system.
  • Responsible for establishing and maintaining standards for data quality and data validation in the data warehouse.
  • Responsibilities included overall database and data warehouse development for a Sales Tracking System in Oracle 9.1 within an UNIX environment.
  • Performed ETL processes using DTS.
  • Responsible for development of Oracle Forms 6i and Reports 6i for operational systems
  • Wrote PL/SQL queries for data extractions.
  • Wrote Unix Shell Script procedures for data loads.
  • Created database design utilizing ERWIN.
  • Created graphical diagrams of data models utilizing Allfusion Model Navigator.
  • Created user documentation for end users and management.
  • Responsible for configuration of COGNOS Framework Manager Packages and SDK.
  • Designed and created COGNOS Power Play cubes for OLAP reporting process.
  • Responsible for creating detailed reports featuring COGNOS Visualizer.
  • Responsible for setting up ETL process using COGNOS Decision Stream.
  • Set up process of extracting sales data from mainframe environment down to data warehouse.
  • Set up tuning process of the reporting feature of the data warehouse which resulted in a 50% overall performance enhancement.
  • Performed Full Data Warehouse Development Life Cycle processes.
  • Responsible for setting access permissions and report properties within the COGNOS environment.
  • Translated business intelligence requirements into logical/physical data models.
  • Assisted in the building of custom data marts and data warehouses.
  • Designed drill down sales reports for region managers utilizing COGNOS Report Net.
  • Responsibilities included collaboration of the design and deployment of INFORMATICA data warehouse utilizing PowerCenter, PowerMart and PowerAnalyzer tool sets.
  • Responsible for creating extensive sales reports using COGNOS Impromptu.
  • Utilized Business Objects SDK/Enterprise for application design.
  • Utilized Crystal Xcelsius to create dashboards for performance reporting.
  • Utilized Business Objects/Crystal Reports to develop extensive financial reports.
  • Designed data marts and universe structures for reporting purposes utilizing Business Objects.
  • Responsible for database schema design.
  • Responsible for backend database development.
  • Designed queries to extract data using SQL Server
  • Responsible for development and customization of SQL Server databases.
  • Designed Brio/SQR reports for management reporting purposes.
  • Created reports using Oracle Developer 2000.
  • Provide weekly project management reports utilizing MS-PROJECT.

Environment: Windows NT, UNIX, COGNOS Series 7, BRIO, TERADATA, BUSINESS OBJECTS, INFORMATICA, ERWIN, MODEL NAVIGATOR, ORACLE 9i, POLYANALYST, MS-PROJECT, NCR SERVER, SQL SERVER

Confidential,NC

Database Administrator - (Consultant)

Responsibilities:
  • For IBM Corporation, responsible for Database Administration on the IBM-Microsoft Royalty Payment project, allowing IBM to pay Microsoft royalties for Microsoft software installed on IBM equipment on multiple platforms.
  • Created functional design specifications.
  • Responsible for ownership and support of sales and marketing applications.
  • Assisted in preparation and execution of testing activities.
  • Responsible for creating MS-ACCESS applications for Royalty Payment Tracking applications.
  • Responsible for web application development.
  • Coordinated tracking and monitored development of application design.
  • Supported development of training materials and participated in training activities.
  • Responsible for solving network issues and moving legacy data across multiple platforms via FTP.
  • Worked with business units to gather functional business requirements, develop process and application design.
  • Responsible for designing COGNOS cubes for OLAP reporting purposes.
  • Designed and customized COGNOS Series 7 query reports for financial reporting purposes.
  • Responsible for setting access permissions and report properties within the COGNOS environment.
  • Set up ETL process using COGNOS Decision Stream.
  • Performed Full Data Warehouse Development Life Cycle processes.
  • Set up scripts for the extraction process to data warehouse.
  • Created extensive royalty payment reports using COGNOS Power Play, COGNOS Impromptu, and COGNOS IWR.
  • Created and developed custom data marts and data warehouses.
  • Developed design recommendations that provided a 50% overall system improvement.
  • Created database design for worldwide COA Tracking System utilizing MS Access within a SQL Server environment.
  • Performed maintenance of Access databases; made enhancements to VBA Code.
  • Responsibilities included overall database development for Royalty Payment database project in Oracle 8.1 within an UNIX environment.
  • Responsible for data normalization and physical and logical design of databases.
  • Performed data modeling activities utilizing Erwin for database design.
  • Ensured that strategies, plans and deliverables for application design were met on time.
  • Performed for data extractions from DB2 UDB from data warehouse utilizing SAP BW for reporting purposes.
  • Responsible for planning and designing of layout of DB2 UDB databases, defined scheduled maintenance procedures.
  • Responsible for database schema design in SQL Server.
  • Designed queries to extract data using SQL Server.
  • Responsible for upgrades to DB2 UDB databases, worked closely with vendors to coordinate software upgrades.
  • Responsible for establishing reorganization, backup and recovery procedures of DB2 UDB databases.
  • Designed dataflow, data feeds processes for sites to adhere to, and for creating process for uploading of data feeds into databases.
  • Design Excel spreadsheets for reporting purposes.
  • Performed weekly reviews with worldwide sites to ensure data integrity.
  • Ran weekly reports for management review.
  • Created worldwide templates for site locations to input data in.

Environment: Windows NT, AS400, DB2 UDB, BRIO/SQR, SAP, LOTUS NOTES, ERWIN, OS390, UNIX, SQL SERVER, VBA, MICROSOFT ACCESS 2000, ORACLE 8i, COGNOS

Confidential, Huntersville, NC

Systems Analyst

Responsibilities:
  • Performed analytical reviews of Cost Accounting System for the NC Department of Health and Human Services.
  • Gathered user requirements, developed functional specifications, and developed documentation.
  • Designed data entry screens for cost accounting system in Access 97. Modified existing data screens for overall enhanced functionality.
  • Responsible for designing Oracle databases for clinical trial studies
  • Performed baseline testing for system verification.
  • Modified reports for enhanced reporting purposes.
  • Designed queries to extract ICD-9 data using SQL Server.
  • Performed database maintenance on Accounting System.
  • Converted Access databases from 2.0 to Access 97.
  • Modified VBA code on applications for better functionality within the overall Cost Accounting System.

Environment: Windows NT, OS390, ORACLE, SQL SERVER, MICROSOFT ACCESS 2.0/97

Confidential,NC

Sr. Systems Analyst

Responsibilities:
  • As the Sr. Systems Analyst and Database Analyst, worked with multi-phased projects involving significant changes to the Raleigh United States Postal Service Center's computer systems for maintenance, enhancements and millennium compliance changes. Successfully implemented initiatives critical to the Raleigh USPS business objectives.
  • Gathered user requirements, developed functional specifications, and developed documentation.
  • Ensured that strategies, plans and deliverables for application design were met on time.
  • Evaluated system interfaces for impacts to existing systems for Y2K problems.
  • Performed project management duties.
  • Coordinated tracking and monitored development of application design.
  • Performed helpdesk duties for USPS sites statewide.
  • Developed design recommendations that provided systems improvements.
  • Performed maintenance and tuning of Oracle 8i databases.
  • Responsible for planning and designing layout of DB2 UDB databases from testing to deployment
  • Responsible for web application development.
  • Responsible for designing process and systems flow design for mainframe applications.
  • Developed assessments on LEGACY applications for Y2K compliance in a TSO/ISPF environment. Performed analysis on applications for potential Y2K problems. Developed conversion and project plans using Microsoft Project and performed code remediation on all Legacy Focus/Cobol applications.
  • Performed SDLC system development life cycle process on Focus applications.
  • Rewrote Postal Service Financial Reporting System PSFR Focus application.
  • Upgraded Focus applications from version 6.8 to 7.08.
  • Developed maintenance plan for existing applications.
  • Created data dictionary for client server applications.
  • Assist technical writers in creating system documentation.
  • Wrote enhanced functionality code utilizing VBA for Access applications for SQL Server databases.
  • Responsible for designing and customization of COGNOS Series 6 query reports for financial reporting purposes.
  • Responsible for setting access permissions and report properties within the COGNOS environment.
  • Responsible for creating extensive financial reports using SQL Server.
  • Responsible for extensive cube creation utilizing SQL Server and COGNOS Power Play.
  • Designed online data entry screens in Access97. Designed adhoc reports in Crystal Reports 8.5. Remediated Access applications for Y2K compliance. Performed Access application conversions from version 2.0 to Access 97.
  • Created test scripts and performed baseline and unit testing of applications.
  • Provided weekly status reports.
  • Designed system and data flowcharts in Visio.

Environment: Windows NT, MS SOFTWARE, Mainframe, FOCUS, COBOL, ASP, COBOL II, DB2, JCL, Procedures, HTML, JAVA, ACCESS, VB, VBA, EDI, ORACLE 8i, ENDEVOR, REMEDY, INFOMAN, SQL SERVER, COGNOS, JD Edwards Business Intelligence, CRYSTAL REPORTS CLIST

We'd love your feedback!