We provide IT Staff Augmentation Services!

Senior Software Engineer Resume

SUMMARY

  • Having 9 + Years of experience in Data warehousing, Business Intelligence, designing, developing, and maintenance of reports and systems utilizing BI software including Cognos suite.
  • IBM Cognos 10.1.x and 10.2.x BI Suite(Framework Manager, Dynamic Cubes, Report Studio, Analysis Studio, Query Studio, Event Studio, Cognos Connection, Active Reports, Business Insight and Business Insight Advanced,
  • Cognos Work Space and Workspace Advanced, Cognos 8 BI v8.4,8.3,8.2 (Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio),Cognos Power play Transformer V8.3.
  • Lead and guide development of IBM Cognos BI Reporting solutions, perform architecture design and implement best performance strategies.
  • Expertise in performance tuning of Cognos Reports.
  • Expert in SDLC of Data warehousing, project planning and effort estimation.
  • Proficient in ETL (Extraction, Transformation and Loading) process, Dimensional Data Modeling, Business Intelligence (BI), SQL and PL / SQL across multiple databases (SQL Server 2008, Oracle, DB2 etc.)
  • Strong knowledge of Data Warehouse Architecture and Designing Star Schema, Snow flake Schema, Slowly changing dimension, FACT and Dimensional Tables.
  • Efficient in end - to-end development of software products from requirement analysis to system study, designing, coding, testing, debugging, documentation and implementation.
  • Proficient in Business process documentation and end-user training/knowledge transfer.
  • An effective communicator with excellent relationship, team building & interpersonal skills. Team Player with the ability to communicate effectively at all levels of the development process. Possess a flexible & detail oriented attitude.
  • Exceptional analytical, problem solving skills and multitasking abilities. Ambitious and hardworking with commitment to excellence.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, HTML, C

Data Modeling: IBM Infosphere Data Architect, MS Visio

Tools: Cognos BI Suite (10.x/8.x/1.1Reportnet), Informatica, IBM DataStage

Database: Oracle 11g/10g/9i, SQL Server 2008/2014, DB2 9

Scripting: Shell Script, JavaScript

Domain Knowledge: Insurance, Telecommunications, Consumer Packaged Goods (CPG), Retail, Real Estate.

PROFESSIONAL EXPERIENCE

Confidential

Senior Software Engineer

Responsibilities:

  • Creating/Enhancing exiting Metadata models using Cognos Framework Manager.
  • Involving in Cognos Administration activities like code deployment from development to higher regions, providing User access etc.
  • Build Dashboard-style reports using RAVE Charts to give executives an at-a-glance look at the key metrics of the organization using IBM Cognos Workspace.
  • Extensively working on Active Reports for Cognos BI Mobile interactive applications.
  • Working on relational, OLAP, Star Schema, Snowflake Schema, Multi-Dimensional database modeling and design.
  • Designed and build multidimensional models and cubes for reporting and analysis.
  • Proactively able to handle diverse situations, multiple projects and rapidly changing priorities and successfully delivered fast Faced and intelligence solutions that expand to meet the business needs.
  • Proficient in implementing user level and data level security in Cognos.
  • Setting up projects across multiple environments (Development, Test, Production), ensuring solutions and deliverables are 100% compliant with the Client’s SDLC and meet controllership and audit standards.
  • Coordinate with Software Testers and Release Management to integrate the final work product into the production environment and provide off hours support as required.
  • Providing Functional/Technical documentation and End user training.
  • Involved in preparing Cognos Dynamic Cube - Proof of Concept comprising of Single Star schema.

Confidential

Cognos BI Tech Lead

Responsibilities:

  • Developing complex reports by implementing different concepts like Master - Detail relationships, Report Bursting, Conditional Formatting, Table of Contents, Drill up /Drill Down, Drill Through, Dashboard reports, Active Reports etc.
  • Involving in Project plan preparation, providing estimates and Migration of reports from Cognos 8.4 version to Cognos 10.2.1 Version.
  • Performed the health check for models exist in Cognos 8.4 and moving the models to Cognos 10.2.1 by converting to use Dynamic Query Mode where ever applicable.
  • Coordinating between Cognos Admin team, QA Team and all other Stake Holders in project.
  • Using Cognos LifeCycle Manager Tool to perform in testing for Cognos reports upgrade project.
  • Developing and deploying Dynamic Cubes in Cognos 10.2.1 environment.
  • Developing Meta data models that support both Dimensional and Relational Modeling.
  • Prepared Data Mart data model using IBM Infosphere Data Architect.
  • Providing access security permissions in UAT/QA and Development regions.
  • Providing End - User trainings on Developed Cognos Reports on a need basis.
  • Providing Support and Enhancement Activities.
  • Co-ordination between Onsite - Offshore comprising of 6 members.
  • Gathering Requirements from Process and Business teams.
  • Developing Technical Design documents and Process Flow diagrams based on requirements from Business.
  • Assuring quality of code to fulfill requirements and adhering to IBM Cognos Reporting standards.
  • Providing support activities for ETL code developed using Informatica.
  • Written PL/SQL functions and procedures that was imported into Cognos.

Hire Now