SUMMARY

• 6+ Years of IT experience worked in Banking and Insurance domains as Report Developer
• Extensively worked on Cognos BI suites
• Good experience on Agile & Software Development Life Cycle (SDLC)
• Expertise in design, develop and test reports in Cognos 10 & Cognos Analytics (11.x)
• Expertise in optimization of reports with respect to data and response time
• Follow the quality process defined by client to ensure defect free deliveries
• Expertise in model design across physical, logical and presentation layers
• Documentation of all project related docs such as FRD, BRD, and TDD until test reports and performance tracking reports, etc
• Good knowledge on Oracle, SQL Server Databases, Teradata & ETL (Informatica)
• Good experience of interacting with business partners to identify information needs and business requirements for reporting
• Possess strong analytical reasoning and ability to provide prompt solutions while handling issues

TECHNICAL SKILLS

• IBM Cognos 10 & Cognos Analytics 11.0.x
• Tableau Basics
• Banking
• Insurance
• Oracle
• SQL Server
• Teradata
• Report Studio
• Framework Manager
• SQL Server Management Studio
• SQL Developer
• VersionOne/Rally Agile
• SQL Assistant

PROFESSIONAL EXPERIENCE

Confidential - Roseland, NJ

Cognos Developer

Responsibilities:

• Analyzed and consolidated the reports to be migrated
• Developed complex reports that contain charts, crosstabs and lists with drill through capability to other reports
• Used filters, cascading prompts, value prompts, date prompts, search and select prompts
• Used conditional blocks to address reporting specifications as is in current reports (SAAS, SAP, etc)
• Developed reports requiring multiple queries, direct SQL, unions and joins at report level
• Designed proper layout of reports as per report output like HTML, PDF
• Incorporated user defined standards in developed reports
• Done data analysis and gap analysis between existing report application database and new DM database using SQL in SQL Developer
• Followed best practices during reports development
• Optimized the reports for performance and ensured that reports running in business defined SLA
• Automated previously manual jobs by developing reports & scheduling which saved time and efforts
• Unit Testing of developed reports and preparing UT document
• Update development status and issues in VersionOne
• Coordinate with Testing team and resolve issues for flawless deployment into production

Confidential

Cognos Developer/Analyst

Responsibilities:

• Enhancements in design of the reports & dashboards
• Participating in the workshops for gathering requirements as part of project enhancements.
• Providing production support (L3) to business users in case of any issues during monthly/quarterly runs.
• Analyzing the impact on the reports due to the changes in the Source systems.
• Working on improvements in reports performance and proposing new ideas to business users.
• Involving in the Design discussions of the Mappings for data loading using datastage jobs.
• Modifying the Framework Manger Models to incorporate the new data elements.
• Designing and developing the reports as per the requirements in Cognos 10.2.2 and Cognos Analytics.
• Testing end to end reports while migrating from Cognos 10 to Cognos 11/Analytics.
• Involving in writing complex embedded SQL queries to improve the performance of the reports.
• Implementing security into Cognos Framework Manager.
• Publishing the Framework Packages into Cognos content store.
• Modifying existing reports to incorporate the changes in the Source system.
• Preparing the Test cases for report validation.
• Involving in Unit and Integration testing.
• Responsible for code migration across environments ( DEV, QA/UAT & PROD).
• Responsible for documenting the code changes as per the User change requests.
• Conducted multiple sessions between offshore/onsite for code review as part of project enhancements

Confidential

Report Author

Responsibilities:

• Created, enhanced and maintained relational/DMR/OLAP metadata Framework manager Models to support business requirements.
• Designed & Developed reports/dashboards using Report Studio, Analysis Studio, Query Studio, Cognos Workspace (+ Advanced)
• Delivered advanced/complex reporting solutions such as Dashboards and Standardized Reporting (including the bursting of reports globally) using Cognos. Created complex Dashboards with Area charts, Pie charts, Cross tabs and Multi prompts in Report Studio.
• Defined and followed Cognos development best practices for Continual Service Improvement.
• Authored technical specifications that describe program development, data modeling coding, testing, changes and corrections.
• Interacted with business units, business analysts, and IT professionals throughout the product life cycle.
• Advised management the best practice to build a full life cycle BIDW from data marts using SSIS to using BI suites to support Cognos artifacts, package, reports, and dashboards.
• Ensured that developed reports meet specifications, run efficiently and are error free through Data Validation and Performance Testing.
• Responsible for evaluating and analyzing requirements, for developing the User Interface and the Database Developed business architecture using requirements, analysis, questionnaires, scope, and risks to communicate the client’s needs to developers and various teams.
• Conducted training on advanced report authoring to familiarize end users to the new reporting environment.
• Led tech team to complete around 150+ reports including dimensional cuts successfully before the deadlines.