We provide IT Staff Augmentation Services!

Senior Business Systems Analyst Resume Profile

3.00/5 (Submit Your Rating)

PROFESSIONAL PROFILE Solutions-oriented IT Business Consultant with demonstrated success in the analysis, implementation, and management of technology systems aimed at streamlining core business operations, with specialized expertise in Business Intelligence solutions and data systems Influential planning and analysis talents, with a keen awareness of impact of database-driven technologies on industry direction and corporate growth Adept at promptly and thoroughly mastering new technologies and industry methodologies, with deep proficiency with Cognos, Tableau, Oracle, and SQL solutions Fifteen years of comprehensive Cognos experience to include all versions from Cognos 3.5 to Cognos 10.2.1 Expertise managing all stages of software development, systems implementation, and integration initiatives, from requirements definition and needs gathering to overseeing system analysis, development, implementation, and support Solid understanding of numerous business and development arenas, enabling direct and precise coordination with multidisciplinary departments as well as executive management An astute and critical mind for planning and development able to conceive, design, plan, and design stable, scalable, and secure data-driven solutions TECHNICAL SKILLS Platforms: Windows Server 2008, Mac OSX, some UNIX Tools: SQL Server/SSIS, Oracle/Toad, Cognos Metric Studio/Designer, Transformer/OLAP, Framework Manager, Configuration Manager, Cognos Planning/Contributor, Report Studio, Analysis Studio, Event Manager, Virtual View Manager, Tableau, Deltek Costpoint, Oracle Financials, Sales Force, Varicent, Photoshop, HTML, CSS, IIS.

PROFESSIONAL EXPERIENCE Confidential Senior Business Systems Analyst Developing rapid-prototype or proof-of-concept reporting solutions and demonstrating those solutions to customers familiarity with all capabilities of the IBM Cognos product suite. Support of the full report development life cycle, including Working with internal stakeholders to gather and document business analytics requirements including: data, layout, and delivery requirements. Creating data modeling solutions to support business analytics requirements. Building dashboard-style reports combining list, cross-tabular, and chart displays to give executives an at-a-glance look at the results of the company. Documenting the design of reports and tracing the design solution to the initial requirement. Building and maintaining Cognos Metrics Models and Metrics Reports Installing/configuring IBM Cognos products using Cognos Configuration and Cognos Administration to set up a fully functional instance of the Cognos BI platform Administering Cognos Content using Cognos Administration including applying enterprise security to Cognos Content by utilizing the enterprise authentication provider Active Directory Troubleshoot report development issues by querying the report source data directly using Enterprise database tools. Facilitate Technical exchanges between IT groups to ensure delivery of high quality work products. Confidential Systems Analyst V Design and development of a Best in Class decision support system used by the Business Services business unit for key metrics reporting, planning and forecasting and pervasive analysis. Creating carrying out design/development strategies around visual, guided and right-sized analytics that the entire organization can utilize, using current and emerging technologies like Cognos, TM1 and Tableau. Works closely with others within and beyond the business unit in order to empower/train others while continuing to strengthen the analytic framework. Design and develop solutions to provide key metric analysis tools to user community using Tableau, Tableau Server, TM1 Cognos reporting. Work with data infrastructure team to refine and improve source data. Work within Netezza Oracle database environments to consolidate and shape data for analysis. Work directly with financial analysts and various other departments to educate, train and empower others to grow their analytical skill set and to communicate key findings/metrics. Support existing end-user tools and reporting metrics. Key Projects: Cognos relaunch Phase I and II - designed, built update Cognos Reporting cube and presented new reports to replace older set up. Varicent implementation - traceability matrix, project management. Confidential Senior Consultant Customer resource for applications using Business Intelligence solutions. Key Projects: Contracted to upgrade Production and Development Cognos Planning models, Metric Studio Scorecards and Framework Manager Packages with BI reports, Composite Server from 8.3 to 8.4.1. Designed and implemented the appropriate infrastructure to support the enterprise. Installed and configured Cognos components on Windows Server 2003 R2 64 bit operating system with Virtual Machines for the Client tools. Contracted to develop a pilot scorecard application using Metric Studio and Metric Designer. Gathered KPI requirements, gave demonstrations on scorecard capabilities such as the use of Strategies, Metric types, Scores, Qualifiers, Projects, Actions. Designed and developed website solution for security firm which included functionality for online Marketing and HR recruiting. Recruited to manage and document the selection process of a new ERP system at NPCC. Developed a Digital Dashboard for unstructured data analysis using Clarabridge data mining applications. Harvested data from various newsgroups, blogs and call center data to store in an Oracle 10g database. Created classification and semantic extraction SQL scripts along with various troubleshooting ETL scripts for data import into the reporting and analysis schema used for Cognos 8 Framework Manager. Created and published Cognos Packages, dashboards and reports in Framework Manager, Analysis Studio and Report Studio demonstrating online market sentiment, keyword count and chatting frequency with drill down and drill through capabilities. Cognos lead for data migration project from Cognos 7 to Cognos 8 at Lockheed Martin. Created VDD's for the remote relocation and replication of the existing series 6 and 7 mixed operating system UNIX, Windows multi-tier environment. Installation and configuration Instructions included for Transformer, Access Manager, Impromptu Web Reports, Upfront, and Report Net. Confidential Senior BI Consultant Served as the key resource in the selection services and development of sophisticated, Web-based business intelligence BI applications such as Corporate Radar, Business Objects, MicroStrategy and Cognos. Coordinated full project life cycle, from needs assessment and proof-of-concept, to principle development and testing, through implementation and end-user training. Recommended Best Practices for Materialized Views to improve performance and integrated security. Orchestrated national-level rollouts, including vendor coordination and end-user support. Provided technical issue resolution throughout implementation for key deliverables, interfacing with multiple clients to ensure highest levels of satisfaction. Key Projects: Lead the development and implementation of a Best Practice approach to an advanced, automated Integrated Library System ILS . Confidential Senior Business Application Developer Drove the development, implementation, and management of a company-wide reporting system. Collaborated extensively with the Oracle development team and finance department to analyze needs, define requirements, and design architecture for Oracle Financials and Cognos system. Conducted comprehensive analysis of data relationships, defined performance metrics, and advocated SQL performance tuning to increase information flow. Prepared and delivered thorough individual and classroom-based technical training to users at all proficiency levels. Worked with Cognos versions 6 to 7. Selected, implemented and managed Deltek GovWin CRM system. Established Integration with Contracts, Business Development and Deltek Costpoint Financial systems. Designed presentation and reporting roll up for all division VPs. Key Projects Achievements: CRM Initiative: Selected by company President and Vice President to manage the research, selection, and implementation of a business development solution in a multiyear CRM initiative designed to streamline and optimize sales pipeline. Spearheaded training, hardware/server configuration, and software installation, with special emphasis on ensuring organization-wide usage and data consistency. Consulted between departments and organizational levels to ensure full functionality of all reporting and data-entry features. Spearheaded implementation of fully integrated security solution, establishing Cognos and LDAP for Web-based delivery of secure data. Achieved significant cost reduction through automation of numerous reporting functions, as well as increase in reporting accuracy. Personally designed, developed, and implemented Cognos reporting solution across all business arenas. Confidential Education Specialist Facilitated classroom-based instruction on all product offerings to Fortune 1000 clients throughout US and Canada. Provided education in PowerPlay, Cognos Query, Visualizer, and additional OLAP data mining solutions. Worked with Cognos versions 3.5, 5 and 6. Key Achievements: Achieved top ranking in revenue and productivity among instructors, generating more than 700,000 in revenue from Eastern region, while averaging 18 billing days per month. Consistently received unsolicited positive feedback rating from key customers. Confidential Database Developer Performed design, development, configuration, administration, and support of a database management system, fully integrating all small business operations including ordering, shipping, invoicing, banking, and inventory procedures.

We'd love your feedback!