SUMMARY

• Dynamic, results - driven professional offering outstanding BI success with more TEMPthan 10 years of IT experience, majority spent in design, analysis, development and implementation of multiple OLAP applications in client/server environments
• Functioned in roles of Project Manager, BI Architect, Project Tech. Lead, Sr. Developer, Business Analyst, Project Liaison, and QA Lead. Proven ability to interface with varietal resources, manage cross-functional teams, and lead R&D efforts
• Strong experience in data warehouse reporting, principally COGNOS (7, 8, 10) BI Series, TM1 v 9.4.1, ReportNet 1.2 and EP Series 7.x components. Knowledgeable experience in competing BI tools like Business Objects, and SAS
• Developed diverse Reports, OLAP Cubes, Dashboard reports, and Charts in multiple database environments, stretching across various industries, using ReportNet, Power Play Transformer, Impromptu Web Reports, and Impromptu
• Extensive experience in Relational Database Systems like TERADATA, Oracle, DB2, and SQL Server. Proficient in web-enabled, three-tier, and client/server computing environments; database and report development experience with SQL
• Led and conducted joint application design sessions for requirements gathering, analysis and design of the system; high degree of proficiency in specification assembly and conversion into deliverables such as use cases, functional requirements, external interface documentation, and management information reports for SBU data marts

TECHNICAL SKILLS

Operating Systems: Microsoft Windows (XP, NT, 2000), Unix, MS-DOS

BI Tools: COGNOS 10.1,COGNOS 8BI (Framework Manager, Business Insight, Business Insight Advanced, Query Studio, Analysis Studio, Report Studio, COGNOS Connection), COGNOS TM1, COGNOS ReportNet 1.1, COGNOS EP Series 7.3 (Transformer, Access Manager, Impromptu, Upfront, PowerPlay Enterprise Server), Business Objects.

Web Servers: IIS 6.0, Tomcat 4.1.x

Languages: SQL, PL/SQL, Visual Basic 6.0, Visual C++ 6.0, Java Script, VB Script, HTML, and XML

Databases: TERADATA 13.10, Oracle 8i/9i/10g/11g, Microsoft SQL Server, Microsoft Access, DB2

Technologies: Data Warehousing, OLAP/EIS

PROFESSIONAL EXPERIENCE

Confidential, Lansdale, PA

Segment BI Lead/ Sr. Technical Analyst

Responsibilities:

• Currently functioning as BI Lead for PBC Federal (Federal Supply Schedule) and GP DRM (Discount Reallocation Management) segments.
• Managing two on-site business analysts, one on-site developer/QA resource, and two off-shore developer resources; coordinating weekly meetings with ModelN and PBC work streams for UI data mapping and gap analysis.
• Responsible for functional requirement (FRS), technical requirement (TRS), compliance and SDLC documentation for reporting; developed business requirement document (BRD) template to be used across segments for QA and UAT conformity and incident reporting.
• Responsible for design and development of report prototypes using Report Studio, Analysis Studio, Query Studio; prototyping dashboards, sample adhoc queries, and pre-set (canned) reports; leveraging Cognos 10 to maximum potential.
• Performing data imports of metadata from multiple data sources (ModelN Performance Impact DB, CCAS DB) to build a PBC/GP contracting model and publishing subject-oriented packages in Framework Manager.
• Tasks also include design strategies for reports transition from Business Object to Cognos 10; extensive work with ETL team and data architect to provide optimal reporting performance.

Environment: COGNOS 10 BI (COGNOS Connection, Framework Manager, Analysis Studio, Report Studio, Query Studio, Business Insight, Business Insight Advanced ), Teradata 13.10, Oracle 11g, ModelN, Business Objects, Subversion

Confidential, South Brunswick, NJ

BI Application Developer/ Architect

Responsibilities:

• Developed the Ad Salesperson Sales Dashboard (ADSD ‘Scoreboard’) for sales personnel application across the DJAS organization via Cognos Dashboard, Content and Utility portlets. ADSD is developed on top of the data warehouse with sources from E2 (Print), Dashboard (Digital), MACTIVE (Verticals), XCRM, Customer Hub, Contract Hub and Salesforce.com.
• Developed and deployed Ad Sales Vice President Sales Dashboard (ADSVP ‘Scoreboard’) for regional vice presidents; dashboard incorporated reports designed in Report Studio, Analysis Studio. Reports represented revenue, goals, and overall performance for commission based incentives.
• Designed ADSD and ADSVP with global filtering capability in Cognos connection, incorporating appropriate channel access for parameter values, drill up and drill down, and report-based drill through capabilities.
• Dashboard complexities included integrating ‘freeze-pane’ (using classes and style sheets), export to various output platforms (PDF, XLSX, etc.) using Java scripting, and floating columns in crosstab and list reports.
• Re-engineered Excel-based reports in Report Studio against the Ad Pulse database; seven pipeline and territorial reports that have global span with optimal performance, batch and real-time.
• Designed and developed reports in COGNOS 10, preparing for compatibility migration from 8.4.1BI.
• Other roles include coordinating with the database team in setting up the required Materialized views, Aggregated and De-Normalized tables as per reporting and analytical requirements; synchronizing with the ETL team in defining the ETL logic for reporting table loads and in setting up the timely schema refreshes for the reporting schemas.

Environment: COGNOS 8.4.1 and COGNOS 10 BI (COGNOS Connection, Framework Manager, Analysis Studio, Report Studio, Query Studio, PowerPlay Transformer), DB2, Toad, Oracle 11g.

Confidential, New York City, NY

PTR Project Manager/ CT Sr. Application Developer

Responsibilities:

• Actively involved in Data Warehouse project to merge five reporting systems, across four City agencies, under a singular umbrella reporting system, with single sign-on implementation. Lead on Functional Requirements Specifications (FRS) review by facilitating the implementation of process and/or technology improvements and developing supporting SOPs/WIs/Integration Guidelines.
• Developed and deployed ‘Solitary Outlook’ (SO) dashboards citywide by leveraging Cognos portals in combining entity based data from Pension Investments (PI), Health Deduction Plans (HDP), and Payroll Finance (PF); the cumulative rolled up into the Oversight View (OV), which provides the NYC oversight stakeholders’ a bird’s-eye view and the ability to better monitor the City’s overall financial health.
• Developed and deployed more TEMPthan 170 canned reports to various NYC oversight government agencies such as Office of Management Budget (OMB), Office of the Mayor, Office of the Comptroller, and Office of Labor Relations (OLR); performed all roles from business analyst, to report development, QA, and training.
• Project manager for PTR (Payroll Transition) reporting implementation; managed 3 developers and 2 testers, designed and developed the COGNOS Model (Framework Manager), gatheird report specifications, developed (Report Studio), and released 73 canned production reports over a nine month period.
• Duties include expediting Freedom of Information Law (FoIL) requests for City news agencies; 241 reports over a three year period, at an efficient average of sixty per year.
• Project Tech. Lead for CT (CityTime) PHASE 2 reporting implementation; creating schedules, directing developers, actively participating in resolving issues both technical and functional.
• Developed Dynamic Reports, and dashboard views from Worksheets and Cube views using different functions (DNEXT, DFRST and ELCOMP); Created associated data source/cube in Cognos 8 portal and configured connection to the Power Cube, and published cubes and reports on Web for forecasting events.

Environment: COGNOS 8.3 & 8.4 BI (COGNOS Connection, Framework Manager, Analysis Studio, Report Studio, Query Studio), TM1 9.4.1, Access Manager, DB2, IBM DB2 UBD for OS/390, Oracle 10g and Windows NT, HTML, JavaScript

Confidential, New York City, NY

Sr. ReportNet Developer /Business Analyst

Responsibilities:

• Performed archetype modeling in ReportNet; integration from NOMAD reporting methodology to COGNOS ReportNet web report format in DB2 database environment.
• Responsible for design and development of CHRMS (PMS) PHASE 1 and PHASE 2 reporting infrastructure, inclusive of data modeling, requirements gathering, reports development, and QA; developed packages for Canned and AdHoc reporting environments.
• Developed more TEMPthan 200 BI Reports using layout containers such as Lists, Charts, Repeater, and Cross Tab format; efficiently developed reports with Tabular Models, Sets, Reference, and SQL.
• Competent implementation of standard filters(detail and summary), prompts (standard and generated), report layout calculations, query calculations, calculated measures, HTML items, java scripts, and conditional blocks in reports to enhance visual interactivity and operability of reports.
• Accountable for design and development of a system for training CHRMS users on CHRMS COGNOS reporting; created training manuals, conducted training sessions and overall demonstrated use of CHRMS COGNOS to business users.

Environment: COGNOS 7.1 and 8.0 BI (COGNOS Connection, Framework Manager, Report Studio, Query Studio), Access Manager, DB2, IBM DB2 UBD for OS/390, Oracle 9i and Windows NT, HTML, JavaScript

Confidential, St. Louis, MO

COGNOS ReportNet Developer

Responsibilities:

• Developed the Quarterly Sales Variance Analysis (QSVA) reporting infrastructure.
• Prepared functional/technical schematics for creation/development of query subjects in Framework Manager, and consequent reporting in Query Studio and Report Studio, based on user requirements, report logic and report layout.
• Involved in the design, development and implementation of PowerPlay cubes; developed roll-out cubes using PowerPlay Transformer for the respective cube model, utilized Impromptu for the reports and, IQD for the web enabled.
• Published Impromptu reports set to Upfront portal for Impromptu Web Report (IWR) users, created NewsBoxes and maintained user access through Access Manager; mapped required user classes and applied appropriate access security in IWR reports.
• Provide IWR production support; monitored and analyzed production related issues, ensured data integrity.

Environment: COGNOS 7.1 BI - Impromptu Administration, Upfront, Impromptu Web Reports, Framework Manager, ReportNet, Access Manager; Oracle 9i Distributed Sales/Production Application DB

Confidential, Huntington, WV

BI Analyst

Responsibilities:

• Responsible for development of Inventory Control (IC) reporting infrastructure.
• Developed Integrated Division Inventory Control catalogs based on departmental production requirements using Impromptu.
• Implemented Governors settings to limit retrieval of large text items, to limit the number of records, to control the number of rows a user can retrieve, to limit the number of tables a user can retrieve in a report, and to limit the query execution time for different User Classes.
• Duties included creation of standard filters, prompts, calculations, and conditions in catalog for optimal report viewing. Additionally, created monthly reports in the form of List reports, Cross-Tab reports and Drill Sequence reports based on user requirements.
• Developed Impromptu Web Reports (IWR) and published on web Upfront using Report Administrator.
• Created QA context, workflow, information, and business rule models; Use Case and Object Models during the analysis using Rational tools.
• Actively interacted with different business groups to perform Gap analysis to identify the deficiencies in the system by comparing the actual objectives with the system objectives desired.
• Originated, designed, and accomplished a system for training Managers throughout Line Maintenance, and Production; involved actively in training sessions and demonstrated use of reporting tool to end-users.

Environment: Impromptu 7.1, Access Manager, and COGNOS Server Administration, Rational Rose, Oracle 8i

Confidential, Ft. Lauderdale, FL

COGNOS PowerPlay/ Data Mart Developer

Responsibilities:

• Responsible for design, analysis and implementation of business reporting infrastructure using Cognos BI & EPS 7.1.
• Performed gathering user requirements, dimensional modeling methods; executed ETL process by designing and developing queries for extraction, creating stored procedures and batch scripts for the process.
• Proficient in the Data Warehouse and Data Mart implementations using star and snowflake schema data modeling techniques.
• Installed and configured Impromptu Client, PowerPlay, Upfront, and Access Manager; setup involved ODBC connectivity for SQL SVR database.
• Duties included creation and maintenance of multiple shared catalogs in Impromptu, across the division; optimized Catalogs via Table Weighting and Governors.
• Created Snapshots to minimize data processing load, consequently regulating network traffic.
• Involved in the design, development and implementation of PowerPlay cubes; worked on the cube model and IQD's.
• Prepared BI dashboards using Cognos Visualizer; Modeled Cubes and reports were made accessible via dashboards for efficient managerial decision making.
• Composed detailed documentation of the BI reporting infrastructure using productivity tools, MS Office/Visio.

Environment: PowerPlay, PowerPlay Enterprise Server, PowerPlay Transformer, Impromptu Administration, Impromptu Web Reports, ODBC, Sql Server 7.0 (NT) and, MS Office/Visio

Confidential, Chantilly, VA

Aerospace Systems Engineer/Marketing Support

Responsibilities:

• Responsible for all new product development of V2D2, next generation aircraft simulator DCSD; data storage and collection device. Generated orders worth over $1.23 million.
• Duties include coordinating with both Hardware and Software Engineering personnel, and researching video frame grabber technologies such as MPEG and MJPEG compression techniques, for product in corporation.
• Developed Voice Video Digital Data (V2D2) system for TAB Express Int’l, for flight sensory data capture, and analysis; defined and designed the system architecture, integrating data collection sensors, and video/audio capabilities; product generated $110K-$140K in revenue per unit sold, achieved 16.2% of annual sales quota.
• Conducted on-site customer installation of the Computer Assisted Performance Analysis (CAPAS); integrated aviation/maritime simulators with the CAPAS for data acquisition and analysis.
• Directed formation of E-based capabilities, including web site, E-sales, E-customer service, and E-billing/payment. Identified marketing initiatives through customer research; developed targeting and segmentation plans.
• Represented the marketing department on a cross-functional team responsible for optimizing product procurement and production processes.
• Designed the CAPAS user manuals strategically incorporating key products and core competencies.

Environment: MS Office/Visio. MATLAB, SPSS, Visual Basic, Visual C++