Sr. Cognos Developer / Architect Resume
TX
SUMMARY
- 11 years of strong experience in IT industry, with a wide range of experience in Development, Administration of SQL Server databases, Business Intelligence Stack (SSRS, SSIS, SSAS), Data Warehouses.
- Versatile, working in roles as: Cognos Architect, Technical Lead, System Administrator, Senior Cognos Developer and Business Analyst. At times, performing more than one of these roles in the same job
- Expertise in Cognos BI suite (Query Studio, Report Studio, Analysis Studio, Event Studio, Metric Studio, Cognos Connection, Cognos Configuration), Framework Manager, Power Play Transformer, Power Play client.
- Extensive experience in Cognos 11.0.x Cloud Analytics.
- Worked on Cognos cloud server for faster access to application and centralized administration. Administration experience in Cognos 11.x, 10.x and applied data level and user level security for Framework Manager Packages, reports.
- Leads the BI and Data Services practice, establishing strategy and resource road map.
- Over 5 years of extensive experience in Tableau 9.x/8.x/7.x of Desktop, Server, Public, Mobile.
- Manage hiring, training and retention plans.
- Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
- Worked as a QlikView Technical Consultant for a wide variety of business applications.
- Proficient in design and development of various dashboards, reports utilizing advanced Tableau Visualizations like Waterfall Charts, Funnel Charts, Donut Charts, Pareto Charts, Dual Axis, Blended Axes and also basic visualizations like Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Geo Maps ( Filled and Symbol).
- Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization using Tableau SDK architecture.
- 5+ years of strong experience in developing TM1 applications using Architect, Contributor, Perspectives and Turbo Integrator.
- Development of Turbo Integrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.
- Maintenance of TM1 users, roles and security, Import the data from ODBC and Text files using TM1 Turbo integrator.
- Experienced in Data Warehousing technologies, ETL tools/technologies, OLTP, OLAP tools/technologies, T-SQL development, Microsoft Services, documenting, coding, modifying, testing and implementing business technology solutions using MS SQL Server 6.5/7.0/2000/2005/2008 (Yukon), Sybase ASE, DB2
- Experience in creating databases, schemas, tables, views, stored procedures, triggers database structures for data warehousing using SQL Server Database, Sybase Database
- Experience in creating different Ad Hoc reports like drill down, drill through, parameterized, charts etc using SQL Server Reporting Service (SSRS).
- Experience in creating tables, extracting and transforming data from different tables, Databases and Servers to specific Servers using Data Transformation Services (DTS) and SQL Server Integration Service (SSIS).
- Experience in Data warehousing that involves collecting, consolidating and organizing data for reporting and analysis with tools such as SQL Server Analysis Services (SSAS), Online Analytical Processing (OLAP) and data mining tools for providing support to Online Transaction Processing System (OLTP) database.
- Experience in Extraction Transformations and Loading (ETL) tools like Data Transformation Services (DTS), Bulk Insert, and BCP for OLTP and DSS (Data Mart/Data Warehouse) environment.
- Excellent knowledge in Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
- Expertise in BI/Data Warehousing concepts, designs, Tableau SDK architecture and project implementations.
- Experience in using DTS to import data from flat files or an OLE DB data source into SQL Server and export data from SQL Server to an OLE DB data destination like spreadsheet.
- Experienced working with large sets of data (60 million rows), Multidimensional data sets in a Data warehouse/Data Store supporting Data Mart.
- Prepared different P & C (properties and casualties) Data sets and worked on different P & C data models.
- Experience with Database Backup, Restoration and Disaster Recovery Procedures.
- Extensive knowledge of Relational Database Management Systems.
- Working knowledge of Design, Data Modeling, Data loads, Database Integration/Conversions, Performance tuning, Optimization and Logical and Physical Database Design using ERWIN Tool.
- Experience in using version control software like VSS, TFS and PVCS.
- Experience in creating Charts, Pateros using the .Net language in Chart Directory.
- Experience in creating web applications using ASP.NET Maker.
- Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating Databases/File groups/Files/Transaction logs.
- Well experienced on BCP, DTS packages, Jobs and linked servers for MS SQL SERVER/Oracle/ Sybase databases.
- Excellent in customer interaction regarding requirement gathering and Customer Support.
- Expertise in OLTP/OLAP system study, developing models and publishing packages using different schema concepts. Involved in Installation & Configuration of Cognos.
- Good experience in reviewing Business Requirement Specifications, Software Requirement Specifications, unit test cases and system test cases.
- Expert in creating List, Cross tab, Drill through, Master detail, Dashboard reports.
- Experienced in Transformer model design and Power play cube building.
- Experience in using Multidimensional expressions (MDX) in report studio.
- Expert in dimensionally modeling relational data sources (DMR) Involved in migrating reports from Impromptu to Report Net.
- Experience with Report Net Software Development Kit (SDK) to customize reports.
- Hands on experience administering, deploying and maintaining Models, reports, and Dynamic cubes using Report Net, Impromptu, Transformer, Power Play and PPES.
- Proficient in using best practices to support the reporting activities. Adept in using performance tuning and optimization techniques such as load balancing, table weighing and partitioning.
- Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
TECHNICAL SKILLS
Databases: Oracle9i, Oracle10g, SQL, PL/SQL, Toad, DB2, MS SQL Server 2012, MS SQL Server 2008/R2, MS SQL Server 2005 (Yukon) MS SQL Server 7.0/2000, MS-Access 97/2000, Sybase ASE 12/12.5, DB2
Operating Systems: UNIX (Sun 2.8), Linux (Red Hat 6.1) and WINDOWS 95/98//NT/2000/XP, UNIX (AIX 5.2)
Business Intelligence Tools: Cognos 11 Analytics, Tableau (Desktop/ Server/ Public/ Reader), Qlikview 10, Cognos Planning TM1 9.5.2 & 10.1, TM1 Admin, TM1 Developer, and TM1 Trainer, TM1 9.5.1, 9.5.2, 10.2 & 10.2Cognos Report net 1.1, Cognos (Impromptu 7.x/6.x/5.x & Power Play Enterprise Server 7.x/6.0, Access Manager, Architect, Cognos Query 7.0, Transformer 8/7.x/6.6 and), Upfront Impromptu Web Reports (IWR).
ETL Tools: Informatica 9.5, Data Stage
Web Developing Tools: FrontPage, Flash, HTML, JAVASCRIPT, and XML
Web Servers: IIS, Apache, Netscape Enterprise Server, IE
Application Servers: WAS 6.0/5.1, Tomcat, LDAP
Programming Languages: SQL, C, C++, VB, JAVA, XML, ASP and COBOL.
PROFESSIONAL EXPERIENCE
Confidential, TX
Sr. Cognos Developer / Architect
Responsibilities:
- Installed & Configured IBM Cognos SDK v11.0.5 (On-Premises & Cloud).
- Migrated Cognos content from Cognos 11.0.3 to 11.0.8.
- Customized Sales Module, Forecast Activity, reservations, guest profiles, staffing, back office and payment system integration for Property Management System.
- Involved in analysis, design and gathering of requirement for designing the new data marts.
- Experienced working with large sets of data, Multidimensional data sources from Oracle and MySQL.
- Worked in an Agile Software Delivery methodology highly focused on developing & enhancing build pipelines for Continuous Integration and continuous deployment.
- Created projects, designed models for reporting and created & published packages in Framework Manager from various data sources CR and RDS.
- Created model query subjects, shortcuts, calculated fields, namespaces, folders and filters in appropriate layers in model to make it simple and more user friendly.
- Conduct troubleshooting, root cause analysis, Data Validation, and problem resolution for Cognos Framework Manager models/packages.
- Created complex, multi-page reports involving prompts, cascading prompts, conditional rendering, and conditional highlighting.
- Design & development of multiple reports using various templates like list reports, cross-tab reports and chart reports.
- Worked on report studio, to create complex reports and dashboards for the given requirements.
- Created Java Scripts to default the values in the Prompts and also to default the search options for the prompts in Prompt page.
- Proficient in deploying, managing, and operating scalable, highly available and fault tolerant applications using various AWS services. Experienced in disaster recovery of servers.
- Created and retained backups of EC2 instances by snapshot feature using automated scripting.
- Experience in using elastic load balancer (ELB) and Auto Scaling for elasticity.
- Setup of Auto Scaling of EC2 instances based on Cloud Watch alarms of CPU and memory usage.
- Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
- Created custom filter to meet reporting needs.
- Enhanced the performance of the database by Index Tuning.
- Configure, support and maintain online BI applications and SQL reporting. Involved in performance tuning for Reports and Framework model.
Environment: Cognos analytics 11.0.3 and 11.0.8, Framework Manger, Report Studio, Oracle SQL, AWS Services EC2, S3, EBS, ELB, RDS etc., HeidiSQL, Git, CA Rally, Jira and SQL Developer.
Confidential, Ontario, CA
Sr. Cognos Developer / Architect
Responsibilities:
- Upgraded environment (Dev, Test, Prod) from 10.2.2 to 11.0.x (On-Premises & Cloud).
- Migrated Cognos content from Cognos 10.2.2 to 11.0.x (On-Premises & Cloud).
- Installed & Configured IBM Cognos Client Tools v11.0.x (On-Premises & Cloud).
- Design, develop, and implement Cognos TM1 10.1 Applications for Financial Planning and Budgeting models with complex rules.
- Development of Turbo Integrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.
- Maintenance of TM1 users, roles and security, Import the data from ODBC and Text files using TM1 Turbo integrator.
- Customized Sales Module, Forecast Activity and Inventory for Finished Goods and Raw Materials.
- Involved in analysis, design and gathering of requirement for designing the new data marts.
- This QlikView Project is for Finance Department, which includes Bookings, Revenue, Cost and Gross Margin.
- Leading team of five onshore Members, three offshore QlikView developers and one Database Admin.
- Forecasting model is created by using booking, revenue applications and created 4 year Forecast model and successfully implemented in QlikView.
- Worked with QlikView 10.x, SQL Server, Teradata, Excel, CSV files.
- Designed Reports using Conditional formatting to display based on the prompt selection.
- Created Dataflow and Lookup tables to capture the functionality of EBS into Adaptive warehouse.
- Created new and updated existing parameters maps.
- Developed a complex financial model that can show case the company’s potential for future investors.
- Conducted market research on the newest trends and technologies that insured the company maintained a competitive advantage.
- Developed business plan presentation for potential investors.
- Planned and directed all functions of the company - Enforced strong leadership skills to ensure efficient/effective utilization of corporate resources
- Established and integrated the functional strategies of the company utilizing business expertise to reach financial/operational goals and objectives.
- Creating and modifying Business Intelligence analytical reports using Tableau.
- Major integration with web applications using JavaScript API, Asp.Net and IIS Server.
- Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
- Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
- Core member for integration of Tableau Reports with Asp.Net web application and usage of JavaScript API for performance improvement.
- Created custom filter to meet reporting needs.
- Enhanced the performance of the database by Index Tuning.
- Configure, support and maintain online BI applications and SQL reporting. Involved in performance tuning for Reports and Framework model.
- Done load managements using CDC filters for Fact and Dimensions.
- Experienced working with large sets of data, Multidimensional data sets in a Data warehouse/Data Store supporting Data Mart.
- Created customized framework model and applied package and object level security for Adhoc reporting.
- Designed and Implemented metadata models in Framework Manager and Power play cubes in Transformer.
- Developed various types of reports in Report Studio using dimensional (Cube & DMR) and Relational data sources.
- Implemented data level security to secure the data in reports and dashboards.
- Implemented report bursting to distribute reports more effectively.
- Used Cognos Event Studio to manage scripts, Dynamic cubes refresh and notifications.
- Managed Appworx for scheduling database scripts and Cognos Dynamic cubes.
- File Transfers using command line tool, PuTTY for UNIX platform.
- Validated AW models to EBS source by writing SQL queries.
- Designed and Developed Sophisticated, interactive Dashboard reports.
- Designed and applied conditions and created functions based on the requirements.
- Creation of conditional variable to hide, highlight of the column information on the reports.
- Provided critical information for business decision making by designing and developing various reports at the executive and analytical levels.
- Used conditional variable to hide, highlight of the column information on the reports.
- Used java script to customize reports to meet report needs.
Environment: Cognos 11 analytics, Cognos 10.2.2, IBM Cognos TM1 10.1, Cognos Adaptive Warehouse 10.2, Adaptive Analytics, Report Studio, Analysis Studio, Query Studio, Cognos Connection and Framework Manager, Transformers and Event Studio, Oracle ERP Applications, and Oracle 11g.
Confidential, Fort Worth, TX
Sr. Cognos Developer / Architect
Responsibilities:
- Analyzing the business requirements provided by the business users on all Trackwise Cognos reporting requests.
- Designing, maintaining, and developing all Adhoc and Standard Trackwise reports using IBM Cognos 10.1 Suite.
- Designing and executing Installation Qualification (IQ) and Operational Qualification (OQ) scripts for the Electronic Change Requests (ECR) required deploying Standard and Periodic Safety update reports (PSUR’s) as part of validation and testing.
- Acted as a TM1 expert to create budget input templates to upload data, make version copy, consolidated market level's budget submissions, created cube views, subsets, active forms, in-spreadsheet models for ad hoc analysis.
- Administered Cognos TM1 security using LDAP/ Access Manager and monitored the overall performance.
- Applying Advanced IT theories and methods Generate Cognos business reports with high performance.
- Created Report Studio Reporting widgets for use with Workspaces
- Created Report Studio Filter Widgets for use with Workspaces
- Used advanced techniques to integrate multiple data sources share same filter widgets in Cognos workspace.
- Prepared different P & C (properties and casualties) Data sets and worked on different P & C data models.
- Mixed Dimensional and relational based reporting widgets onto same workspace and could share same report studio built filter widgets across relational and Dimensional widgets.
- Integrated Cognos Report Studio Reports into MS Office PowerPoint Slides for Presentations
- Cognos Report Studio
- Cognos Briefing Book Solution - Built Briefing Book solutions that included multiple reports that used Table of Contents for navigation and book marks to get back to table of Contents
- Cognos Report Booklets - Similar style solution as Briefing book but this type of solution allows you to call a separate reporting objects and bring them into a single report with a Table of Contents as well. In addition, I expended the functionality to call reports outside of Cognos from table of contents as well.
- Identifying and gathering user requirements and business requirements from different groups, end users for developing reports
- Designed and developed Tableau Dashboards for critical Projects, i.e. CEO Scorecard & OBIEE to Tableau Reports Conversion. Particularly CEO scorecard, for which the scope of Workbook included 10+ dashboards.
- Performing yearly analysis and business risks using different line charts.
- Analyzing the future trends and provide business ideas to manage wealth, investments.
- Designed Ad-Hoc reports across various verticals as per the Business Users requirements. e.g.: Bookings, Sales, Quoting, Cases, and Opportunities.
- Created drill down, drill through, sub and linked reports using MS SSRS 2008/2010 as well as maintained subscriptions.
- Created tables, views, triggers using DB Visualizer.
- Enhanced the performance of the database by Index Tuning.
- Configure, support and maintain online BI applications and SQL reporting. Involved in performance tuning for Reports and Framework model.
- Used Team foundation server for report version control and PVCS for database related version control.
- File Transfers using command line tool, PuTTY for UNIX platform.
- Coordinate with data architecture and modeling team to define and develop solutions to the business requirements.
- Analyze requirements and create functional securities and technical specifications.
Environment: Cognos 10.1.1, Cognos Connection, IBM Cognos TM1, Report Studio, Query Studio, Analysis Studio, event Studio, Business Insight, Business Insight Advanced, SQL Server 2008 R2 SP1/2010, T-SQL, BIDS 2008/2012, DB Visualizer, PuTTY, Unix, Team Foundation Server, PVCS Tracker PL/SQL.
Confidential, King of Prussia, PA
Technical Lead/ Cognos Developer/Admin
Responsibilities:
- Developed Adaptive Dashboards for various Business groups using Cognos Active Reports.
- Designed and Implemented metadata models in Framework Manager and Power play cubes in Transformer.
- Developed various types of reports in Report Studio using dimensional (Cube & DMR) and Relational data sources.
- Implemented data level security to secure the data in reports and dashboards.
- Implemented report bursting to distribute reports more effectively.
- Used Cognos Event Studio to manage scripts, Dynamic cubes refresh and notifications.
- Managed Appworx for scheduling database scripts and Cognos Dynamic cubes.
- Wrote stored procedures and PL/SQL scripts to load, update data tables.
- Worked on MS SQL Server tasks such as Data Loading, Batch Jobs, BCP-Bulk Copy, DTS and Indexes.
- Created and automated regular Jobs such as Daily/Weekly Report Generations.
- Involved in building and maintainingSSIS Packagesto import and export the data from various data sources usingBIDSbased on the design data models.
- Designed and Build Dynamic Cubes with Star schema and Snowflake schema using SQL Server Analysis Services (SSAS) 2008 for analyzing purpose.
- Created many complex stored procedures / functions and used them in Crystal Reports directly to generate reports on the fly.
- Used Crystal Reports v 11 to create drill down reports.
- Provided Training to different business users to develop dashboards in workspace and workspace advanced.
Environment: Cognos 10.1.1, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Event Studio, Business Insight, Business Insight Advanced, Windows NT/2000/XP, SQLSERVER 2005/2008, DB2, T-SQL, SSIS, SSAS, SSRS, COBOL, Share Point Portal Server, Enterprise Architect, Visual Source Safe.
Confidential, Rosemead, CA
Sr. Cognos Developer/admin
Responsibilities:
- Design, develop, and implement Cognos TM1 10.1 Applications for Financial Planning and Budgeting models with complex rules.
- Development of Turbo Integrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and Dynamic cubes.
- Maintenance of TM1 users, roles and security, Import the data from ODBC and Text files using TM1 Turbo integrator.
- Created relational and dimensional Framework Manager Models, packages and configured them with appropriate security.
- Involved in creating portal pages for various departments and assigned security to portal pages and reports in Cognos connection.
- Worked on Framework manager to Import metadata from multiple data sources and to create various Query Subjects, create and publish packages to Cognos 10.1
- Involved in deployment of the Reports, Framework manager packages, Cubes from development to Integration, QA and Production.
- Configure, support and maintain online BI applications and SQL reporting. Involved in performance tuning for Reports and Framework model.
- Performed Unit testing of the reports by checking the report output to the SQL output and prepare Unit Test Document.
- Conducted the training session for the employee and users on TM1 10.1, Cognos 10.
Environment: IBM Cognos TM1 10.1,Cognos 10,8.4,8.3 - Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Transformer 8.3,Power Play 7.3, SQL.
Confidential, Hillsborough, NJ
Cognos/BI Developer
Responsibilities:
- Interacted with business users to identify key Dimensions and Measures for custom development of Supply Chain Warehouse.
- Developed professional reports in Report Studio and ad hoc reports in Query Studio. Created list reports, cross tab reports, chart reports and reports with features like conditional formatting, multiple drill through and have extensively used the new features in Cognos 8.4
- Used TOAD to run SQL queries and validate the data in Data warehouse and Data Marts.
- Involved in the Setup security both at package level and at query subject level
- Used conditional formatting and conditional blocks to display different sets of data based on different conditions in Report Studio.
- Created multi page report based on multiple queries using Prompts and Parameters.
- Created Various Dashboard Reports for different business areas based on Cubes and DMR’s.
- Performed Unit Testing to ensure the accuracy of data displayed in the report.
- Created documentation for all the processes involved.
- Provided technical assistance by responding to inquiries regarding errors, problems, or questions with programs/interfaces.
- Created reports using reporting services SSRS.
- Worked as a lead developer in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
- Developed complex TSQL code for the application.
- Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes.
- Design and implementation of stored procedures and triggers for automating tasks.
- Worked on complex data loading (implemented the batch data cleansing and data loading).
- Creating and automating the regular jobs.
- Manage and monitor the system utilization.
- Manage the backup and recovery of the team.
Environment: Cognos 8.4,8.3 - Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Transformer 8.3,Power Play 7.3, Oracle10g, Toad 9.1, MS Access, DTS, SSIS, Query Analyzer, BCP, SQL Profiler, Windows 2003 Server, Client Network Utility.
Confidential
Cognos developer/admin
Responsibilities:
- Created list, cross tab, chart and dashboard reports including features as such drill-thru, slice and dice, conditional formatting, master/detail, bursting and automated reports distributions with e-mails using report studio, query studio and analysis studio.
- Worked on Framework manager to Import metadata from multiple data sources and to create various Query Subjects, create and publish packages to Cognos 8.4.
- Configure, support and maintain online BI applications and SQL reporting.
- Acted as a TM1 expert to create budget input templates to upload data, make version copy, consolidated market level's budget submissions, created cube views, subsets, active forms, in-spreadsheet models for ad hoc analysis.
- Administered Cognos TM1 security using LDAP/ Access Manager and monitored the overall performance.
- Conducted the training session for the employee and users.
Environment: IBM Cognos TM1, Cognos 8.3 BI (Framework Manager, Report Studio, Query Studio, Transformer, Cognos Connection), Oracle 10g/11g, TOAD, Erwin Data Modeler r7.4, Windows vista/X
Confidential
Cognos developer/admin
Responsibilities:
- Involved in understanding the Business and all Departments within Confidential .
- Designed the Model according to the Business Requirements by creating a Presentation Layer.
- Built the Model using Framework Manager and published packages to Cognos Connection for Reporting.
- Created filters within the Model for improving the performance of the Model.
- Developed standard Templates, Standard Reports, Charts, Drill through Reports, Master Detail Reports.
- Created Query Prompts, calculations, Conditions & Filters.
- Created Stored Procedures for Updating and Inserting data into the database.
Environment: Cognos 8.x (Framework Manager, Query Studio, Report Studio, Analysis Studio, Event Studio), Report Net 1.1, Cognos EP series 7.3, Cognos Decision stream, Power play, Oracle 9i/10g, SQL Server 2005/2000, Windows XP/2003, Unix.