BI Cognos Candidate VAM SYSTEMS Inc
Justin Pappachan
Hi All,
Please find the details of the candidate BI Cognos Developer, Please let me know if there is a Direct Client Requirement.
Summary
· Over 10 years of professional IT experience, with over seven years in design, analysis, development, testing and implementation of various OLAP applications in client/server environment and over one and half years in enterprise-wide Cognos production support and product training
· Worked on small and large projects within the IT solution provision life cycle with strong analytical and project management skills, proficient communication, interpersonal and presentation skills. Outstanding team player
· Development experience in Data warehouse reporting with various BI tools primarily COGNOS 8.3 BI Series (Report/Query/Metric/Analysis studios) , Report net 1.2 and EP Series 7.3 components
· Developed various BI Reports, List , Charts, Repeater , Singleton, Cross Tab , Drill Through, Cubes, from a wide variety of database environments such as DB2, Oracle 9i/10g, SQL Server 2000 ,Teradata and MS Access in a diverse range of industries using SQL, Cognos Impromptu (ad-hoc), Power Play Transformer (cubes), Visualizer, Script Editor, and Impromptu Web Reports (IWR)
· Ensured that aims, goals and objectives were accomplished in accordance with outlined priorities, time limitations, and funding conditions. Proven project management and development experience
Education/Certification/Training
· Bachelor of Engineering India (1999)
· IBM Certified Cognos 8 BI Author (2009)
· Cognos Training at IBM in New York City (2008)
Skills & Knowledge Matrix
|
Business Intelligence |
ETL |
RDBMS / DBMS |
Internet/Web Tools |
|
Cognos8.3, Report Net 1.02/1.1,Cognos Series7.4/6.0 |
Informatica 5.x/6 - Power Center V 5.1/6.2, Power Mart. |
DB2, Oracle 10g/9i/8i, SQLServer2000,MSAccess 7.0/2000 |
IIS 5.0/6.0, HTML 4.0, ASP.net, Java script, VB script |
Professional Experience:
Client: Office of Payroll Administration, City of New York, NY July 2008 – Current
Project : CHRMS
Title : BI Report Writer
Description:
CHRMS delivers reporting capability to agencies throughout the City and allows response to FoIL requests. It delivers a large volume of payroll and HR related reports internally to the City and to external entities. In tune with Mayor Bloomberg’s 2007 PlanIT: Better Government through Customer Service, CHRMS is a comprehensive technology strategy for integrated, effective, standardization of the City’s reporting assets under an approachable GUI front-end.
Responsibilities:
· Created approximately 85 reports in Report Studio; parameterized canned reports with multiple queries. Efficiently developed reports with Tabular Models, Sets, Reference, and SQL
· Providing CHRMS Release II production support; Monitoring and analyzing production related issues, thereby ensuring data integrity
· Developed approximately 30 reports in response to Freedom of Information Law (FoIL) requests, and approximately 55 reports in response to other special reports for various NYC government agencies
· Preparing functional/technical specifications for design/development of CHRMS Release II reporting, and consequent reporting in Cognos BI software suite; based on user requirements, report logic and report layout
· Coordinate with all the team members, users, and the database engineering team; meeting the deadlines like production pushes, actively participating in resolving issues both technical and functional
· Gathering user requirements and converting them into deliverables such as functional specifications, and management information reports required for development of SBU centric Data Marts
· 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 Cognos reports
· Interpret SQL and accordingly restructure from various reports to tune their performance
· Govern and patrol the remedy system for the CHRMS development team; involving opening incoming tickets, tracking unassigned open tickets, updating status to ensure notifications to end users
Environment:
Cognos 8.3 BI (Cognos Connection, Frame work manager, Report Studio, Query Studio, Access Manager, DB2, Oracle 10g, Windows NT, HTML, JavaScript
Client: Office of Payroll Administration, City of New York, NY
March 2007 – June 2008
Project : CHRMS Training & Support
Title : Sr Cognos Consultant
Responsibilities:
· Studied the implemented reporting system (canned & ad-hoc) and created the training manual to assist the users attending OPA training sessions
· Assisted the OPA Training team with their training sessions in training over 1000 users for canned and ad-hoc (query Studio)reports.
· Conducted on-site, one-on-one training sessions, city-wide to over 150 users spanning across 45 agencies
· Spearheaded the effort to analyze and deconstruct over 250 legacy system (PMS) reports from multiple reporting platforms across the city to convert them into web based interactive CHRMS ad-hoc reports
· Created and transferred functional specification documents to CHRMS development team for report requirements which were outside the purview of development in Query Studio
Client: Department of Correction, City of New York, NY
August 2005 – December 2007
Project : Inmate Information System
Title : Sr BI Application Engineer/Lead
Description:
The aim of the project is to create Reports using their DB2 Database to give business users the ability to access, analyze and share information stored in the Data Ware house. Various reports were developed about Inmates and the officer’s to provide Information to directly assist the end users. Project involved developing reports using Cognos8.1, Report Net, Impromptu and creating cubes using Power Play Transformer, which helped the management to access reports and to analyze information, and to take critical decisions. Involved in the up gradation of the software from Cognos series7.0 to Report Net 1.1 and finally to Cognos 8.1
Responsibilities:
· Gathering user requirements and converting them into deliverables such as use cases, functional specifications, external interface documents and management information reports required for development of Data Marts
· Installation of Cognos Software
· Provided hands-on support in the setup of Cognos 8BI on Windows 2003 Server platform and in evaluating Cognos 8BI rollout for the enterprise
· Planned, managed and migrated Cognos environment to new Server during the enterprise server refresh process
· Conducted team sessions to discuss Migration best practices to move existing Production systems to the new Cognos 8 BI platform
· Interact with SBU managers to gather requirements, design Impromptu IQDs, and create transformer models to generate Multidimensional cubes
· Create ad-hoc reports (Impromptu IMR reports, Cube extracts, Direct SQL) and deliver results in multitude of formats as per user requirements
· Coordinate with all the team members and database engineering team, meeting the deadlines like production pushes, actively participating in resolving issues both technical and functional
· Created professional reports in Cognos 8 (Report and Query Studio), Upgrading Cognos Series 7.x reports to Cognos 8.1
· Developed Catalogs and created various List reports, Chart, Cross-Tab reports, and Drill through Reports
· Developed Impromptu Web Reports (IWR) and published on web upfront using Report Administrator
· Developed Cubes using Power Play Transformer.
· Involved in building models, packages using Framework Manger.
Environment:
Cognos 8.1 BI (Cognos Connection, Frame work manager, Report Studio, Metric Studio, Analyzer Studio, Query Studio), Access Manager, Oracle 9i, DB2,Windows NT
Client: Merrill Lynch, New York, NY April 2005 –July 2005
Project : Corporate Banking
Title : Cognos Developer
Description:
The IBK Business Intelligence data warehouse was sourced from many internal and external data elements organized for high performance reporting and analytics. This Data Warehouse helped business focus on the prospective clients, cross-selling across services and more actively managing resources for maximizing return. A number of subject areas had been brought into Data Warehouse, including revenue, client contacts; client deal fees, expense; loan and fact set data resulting in more timely access to information and creation of reports across a broad collection of related data.
Responsibilities:
· Generated various kinds of reports (List, Cross tab, Drill Through, Master Detail, Burst) with cascaded prompts
· Designed models using Impromptu Query Definition (IQD), created OLAP Cubes in Cognos Transformer, and analyzed the data using Cognos Power Play.
· Developed Impromptu Web Reports (IWR) and published on web upfront using Report Administrator.
· Extensively worked on understanding the business requirements and involved in performance tuning for Impromptu Reports.
· Extensively worked on Power play Enterprise server for Cube Deployment in Web.
Environment:
Cognos power play 7.2, Cognos Transformer 7.2, Cognos Impromptu 7.2, Cognos Upfront, MS ACCESS 6.5, Oracle 8i, Windows NT
Client: Hartford Insurance, Hartford, CT October 2004 – March 2005
Title : Cognos Developer
Description:
This project was developed for Hartford Insurance (CT) with the aim to create Reports using Oracle Data Warehousing giving business users the ability to access, analyze and share information stored in the Data Mart. Various reports were developed using Cognos to provide the foundation for management decisions, to directly assist the end users. Project involved developing reports using impromptu, creating cubes using Power Play Transformer and ReportNet, which enabled the management to access reports, analyze information, and take critical decisions. Project execution also involved upgrading software from Cognos 7.0 series to Report Net 1.1.
Responsibilities:
· Interact with managers to gather requirements, design Impromptu IQDs, and create transformer models to generate Multidimensional cubes
· Involved in building models, packages using Framework Manger and published the packages to ReportNet Server
· Created professional reports in Report Studio and ad hoc reports in Query Studio
· Modified packages to suit the business needs and to improve the performance of the reports by defining filters and adding calculations
· Designed and developed Time Based Reports like YTD, MTD and WTD financial reports for the end users
· Created list reports, crosstab reports, chart reports and reports with conditional formatting using Report Studio
· Designed models using Impromptu Query Definition (IQD), created OLAP Cubes in Cognos Transformer, and analyzed the data using Cognos PowerPlay
· Used Cognos Visualizer to create, present and distribute visual presentations of complex data for easy analysis
· Created standard filters, prompts, calculations, and conditions in catalog
· Created and maintained multiple shared catalogs using Cognos Impromptu
· Maintained the Cube Security by Category level and Dimension level
· Create detailed documentation for Powerplay Cubes, Catalogs, Powerplay Reports, and conduce training sessions for power users to maximize value and knowledge sharing. All the documents and training materials were hosted on Microsoft Sharepoint
Environment:
Cognos Report net 1.02/1.11, Cognos power play7.2, Cognos Transformer7.2, Cognos Impromptu7.2, Cognos Upfront, 6.5, Oracle 8i, Teradata, Windows NT
Client: Mattel, Los Angeles, CA July 2004 – September 2004
Project : Project Caps
Title : Cognos 7.0 Architect
Description:
This project was developed for Mattel to enable loading of financial data into Mattel’s new Oracle system. Data came from multiple Legacy Systems, which were mostly from AS400, MS Access and flat files. Comparative Financial reports were generated from Oracle Data warehouse using Cognos Impromptu and Cognos Power Play. Fiscal year ending reports were generated and PowerPlay was used to compare the performance.
Role and Responsibilities:
· Did reverse engineering in Erwin 4.0 to get the metadata for the design of catalogs
· Created zone-wise catalogs using data from heterogeneous data sources like oracle tables, flat files. Monthly reports were designed in Impromptu for account processing for each customer.
· Generated incrementally upgrading cubes from IQD’s with macros and scheduler for periodical upgrade of cubes
· Created various reports such as List reports, Cross-Tab reports, and Drill through Reports using Impromptu
· Created Snapshots to minimize data processing when the network traffic for the database is heavy
· Developed Impromptu Web Reports (IWR) and published on web upfront using Report Administrator
· Extensively worked on understanding the business requirements and involved in performance tuning of Impromptu Reports
Environment:
Cognos power play7.0, Cognos Transformer, AS400, MS ACCESS 6.5, Oracle 8i, and Windows NT
Client: Guardian Life Insurance Company, New York January 2004 – June 2004
Project : Project Eagle (IBM)
Title : Cognos 7.0 Developer
Description:
This project was developed by IBM for Guardian life Insurance company of America and Berkshire life insurance Company. The aim of the project is to give business users the ability to access, analyze and share information stored in the Data Mart. Various reports are developed using Cognos to provide the foundation for management decisions, to directly assist the end users.
Responsibilities:
· Interacted with the Business users to identify the process metrics and various key dimensions and measures
· Created Impromptu reports with different types of prompts like catalog pick list, cascading prompts etc
· Implemented security on IWR reports by adding specific user class in the Impromptu Catalogs, created and customized various cross tab reports, drill through reports, and sub-reports
· Created different visualizations for reports using different types of charts, to include data from multiple metrics. Provided user interaction by including various navigation and filtering options
· Created Multi-Dimensional cubes and generated reports using Cognos PowerPlay as per user requirements to support several process metrics
· Provide Drill-Through access from the cubes to associated Cognos query, using Cognos Architect 7.0 to build a common set of business oriented metadata from the data mart. Provided users with Cognos Queries and Cubes
· Published reports to Cognos Upfront using Server Administration tool and interacted with Cognos Administration team for scheduling of cubes and reports to refresh on a regular basis
· Created reports in HTML format for easy navigation
Environment:
Cognos Architect 7.0, Cognos Impromptu Administration 7.0, Cognos PowerPlay Transformer 7.0, Visualizer7.0, Cognos Upfront, Windows NT, SQL
Client: Brunswick Incorporated Computer Systems, (U.K.) June 1999 – March 2003
Project : Remote Data Tracker
Title : Programmer/Analyst
Description:
This project was developed by WIN IT a software development company. The system allows creation and registration of new Warehouses, provides password-based security and has a transaction engine. The application provides state management across pages with the usage of Sessions level variables. Dictionary objects are used to maintain collections of data across pages. Intrinsic objects provided by ASP: Request, Response, Application, Session and Server were fully utilized. Data Services were provided through a Component (COM), which was developed using Visual Basic
Responsibilities:
· Involved in the design of Intranet system which allows the company to coordinate Inventory Transactions across all Warehouse
· Created ASP pages using all the intrinsic object of ASP3.0 and Visual Interdev 6.0
· Used ADO object to interact with Databases
· Created COM object
· Worked on Backend with SQLSERVER
· Worked on MTS
· Designed the front end using VB6.0
· Worked on backend using SQLSERVER
Environment:
ASP.Net, Visual Interdev, Visual Basic 6.0, SQL Server 7.0, COM, IIS, Win NT
Client: Satsang Trade (India) February 1998 – May 1999
Project : Employee Management System
Title : Software Programmer/Trainee
Description:
Employee Management system consolidated the needs of the firm in terms of employee workforce. It kept the track of employee activity. It had a centralized database of all employee contact and other information.
Responsibilities:
· Involved in Understanding the Project requirements.
· Designed the front end using VB6.0
· Worked on backend using SQLSERVER
--
Best Regards
Justin Pappachan
IT Recruiter
VAM SYSTEMS INC
402 Main Street, Suite 207
Metuchen, New Jersey - 08840
Tel : 732 993 6913
Fax : 1 877 VAM FAX 3
justin.p...@vamsystems.com
DISCLAIMER: This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. The opinion expressed in the mail reflects the personal opinion of the sender and may not reflect the opinion of VAM SYSTEMS INC unless mentioned specifically so, by an authorized professional. While VAM SYSTEMS INC takes care in avoiding infection of outgoing mails by viruses or damaging external software by scanning all outgoing emails and attachments, VAM SYSTEMS INC is not responsible for any loss of data or inconvenience caused by the receiver.