System Business Architect Consultant Resume
Plymouth Meeting, PA
SUMMARY:
Highly motivated and result - oriented professional with exceptional leadership skills, solid skills in systems development, user support, technical troubleshooting, quality assurance, problem solving, documentation, and strong background in the development and implementation of high-impact solutions that will meet and exceed your company goals and objectives is seeking challenging opportunities as a business and system analyst.
TECHNICAL EXPERIENCE AND PROFICIENCY:
Impromptu Administrator, COGNOS Impromptu, Crystal Report, COGNOS ReportNet, Data Warehouse, System Analysis and Design, Relational Data Modeling, Data Warehousing, Unified Modeling Language (UML), User Acceptance Testing (UAT)/Quality Assurance (QA)/Stress Testing, Database Management, SCADA.
COMPUTER EXPERIENCE:
HARDWARE: PC, Macintosh
OPERATING SYSTEMS: Windows NT, Windows 2000, Windows XP, Mac Os, UNIX, OpenVMS.
NETWORK: Ethernet, Token Ring, LAN, WAN, TCP/IP, FTP.
SOFTWARE: MS Office, Access, Visual Basic 6.0, Oracle DBMS, SQL Server 2000, COGNOS Impromptu, COGNOS Report Net, Crystal Report V9 and V10, Visio, Rational Rose, SCDRAW.
LANGUAGES: Active Server Page, Visual Basic, VBA, SQL, T-SQL, PL/SQL, Java Script, C, UNIX, Digital Command Procedural Language.
EMPLOYMENT EXPERIENCE:
Confidential, Plymouth Meeting, PA
System Business Architect Consultant
Responsibilities:
- Formulates and defines systems scope and objectives based on both user needs and a good understanding of applicable business systems and requirements.
- Devises or modifies procedures to solve complex problems considering equipment capacity and limitations, operating time, and form of desired results.
- Includes analysis of business and user needs, documentation of requirements, and translation into proper system requirement specifications.
- Work closely with developers on coding/testing. Serve as a subject matter expert on in house systems.
- Guides and advises less-experienced Business Systems Analysts.
Confidential, Blue Bell, PA
Information Technology Consultant
Responsibilities:
- Develop COGNOS ReportNet Reports based on requirement specifications, Modify/Analyze/Validate report results, Interact/Cooperate with team members to resolve technical Issues (data integrity, populating views)
- Participates in the testing process through test review
- Consult with client to perform UAT testing
- Participate in requirements gathering with client (Centocor)
- Create front-end Dashboard with report links, Modify/Publish existing FrameWork packages
- Participate in COGNOS V8 evaluation session with COGNOS for several clients.
Confidential, Philadelphia, PA
Senior Manager of Reporting Systems
Responsibilities:
- Create/Maintain/Update “Reporting Dashboards”
- Create T-SQL procedures to extract data from operational databases for reporting purposes, Inventory/Purchase software and end users’ licenses
- Support SQL Server 2000 operational databases, Develop/Enhance ASP applications
- Involved in evaluating and standardizing company’s Business Intelligence tool,
- Perform logical design to develop a Data Warehouse, Manage and support existing interfaces and processes using complex analytical skills to ensure proper information flow
- Modified program sequence and/or codes as needed, Worked with Human Resource representative on staffing IT employment programs: including recruitment activities, application processing, candidate screening, Interviewing
- Provide technical support to director with regard to the university’s online hiring process,
- Manage vendors in “smart-sourcing” relationships where BBBS and the vendor collaborated in an effort to balance timing/cost/expertise
- Involved with other organizational initiatives.
Confidential, Philadelphia, PA
Senior Analyst
Responsibilities:
- Support two Energy Management Systems, Perform/Compile database switches, Update circuit displays, Respond to terminal/remote servers’ emergencies
- Engage with technical staff and clients to gather project requirements for analysis, design, development, testing, and implementation
- Develop programs to enhance Relational Data Storage services
- Work with project managers to document and control project scope
- Maintain ongoing communications with other departments.
Confidential
Internal IT/ Data Warehouse/ COGNOS BI tools consultant/System Analyst
Responsibilities:
- Develop/Maintain ASP web applications, Design data modeling diagrams,
- Design/Develop relational databases and reports using COGNOS Impromptu and COGNOS Impromptu Web Report, Create/Modify application reports that enable profitable and strategic business decisions throughout the company
- Develops/Troubleshoot/Modify applications, reports in accordance with project plans and specifications
- Provide production COGNOS IWR administration support for the reporting and analytical environment; including: troubleshooting, new user setup, security, training, performance monitoring, design specifications, metadata documentation
- Work with application developers and computer operations to support testing and production reporting environments; including: daily administration, batch processing, environment migration, Work as data modeler to improve data mart models
- Serve as a technical expert on in-house business intelligence/reporting tool solutions
- Perform data manipulation, auditing, cleansing, Implement business rules, Assure the integrity, accuracy of the corporate data
- Contribute/Assist to development/operations of Customer Data Warehouse daily activities, business initiatives, Encourage positive change and support continuous improvement in the organization.
Confidential
Application Development
Responsibilities:
- Participate in IT Strategic Planning assessment, Utilize Access, Visual Basic to develop databases and automate manual processes
- Analyze/Specify/Validate the business needs of project stakeholders; including: interviewing stakeholders and gathering and compiling user requirements to convey to development teams throughout the software lifecycle, Involved in Server Inventory budgeting/Cost Analysis
- Implement propriety software at satellite locations, Interact with Department VP/Directors
- Propose innovative solutions that resolved workflow problems, Assist in creating business/marketing plans.
Confidential, Philadelphia, PA
Office Administrative Assistant
Responsibilities:
- Tutor/Encourage freshmen to achieve their potential,
- Served as a mentor and met regularly and consistently with assigned student
- Provide administrative support: for file management, coordination of special mailings
- Facilitate/Participate in group work shops regularly
- Provide support and encouragement to motivate students to achieve their best, Facilitate various training
- Assist/Contribute to various development events
- Develop Access application to track students’ financial aid packages
- Develop web applications to track students’ academic activities.
