We provide IT Staff Augmentation Services!

Technical Lead Resume

EXPERIENCE SUMMARY:

  • IBM Cognos and Business Objects Certified Professional having 8.9 years of experience in diversified fields of Application Software Development and Testing in DWBI projects
  • Well versed with OLAP and RDBMS concepts and developed various applications based on Business Objects XIR2 and Cognos.(8.4 and 10,2)
  • Extensively worked with multiple Reporting Tool, and Database testing.
  • Involved in development of numerous number of business reports in multiple versions of Business Objects from BO 6x to BO XIR2. Also acquainted with Cognos 8.4 and 10.2.
  • Implemented Information delivery framework with Self Service, Complex Operational Reports, Dashboards, Advanced Visualization for sales/marketing/finance/fraud business groups using IBM Cognos BI Suites well versed with BO CMC and Cognos FM,Administation,Security,Migration, Report studio, Query Studio, Cognos Workspace, Workspace advanced, Active reports and Cognos insight. Engaged in designing and creating the security structure in the course of the project work
  • Has comprehensive knowledge on Dimensional Modeling and Sybase power Designer
  • Wide exposure in complete Software Development Life Cycle like Requirements Analysis, Solution Architecture, High Level Design, Detail Design, Development, Testing, Support, Implementation, Warranty and Production Support for applications under CMM Level 5 processes
  • Certified in Equity, Consumer and Retail Banking
  • Well equipped with team handling and team building skills
  • Good interpersonal and communication skills.

TECHNICAL SKILLS:

Databases: Oracle 9i,Oracle 10g

Development/Productivity Tools /Technologies: Cognos Impromptu, CRN,Cognos 8.4 (Query Studio, Report Studio, Framework Manager),Cognos 10.2, Data Modeling, BO 6.5/ XI R2, Supervisor, BCA, Admin Console, Designer, Desktop Intelligence, Web Intelligence, CMC, Performance Management, ER Studio, BOXI - 3, SAP BI

FUNCTIONAL AREAS:

  • Finance, Banking
  • Domain Knowledge
  • Data Warehouse

SOFT SKILLS:

  • Excellent communication skills
  • Ability to articulate opinions and ideas efficiently
  • Ability to work in a diverse team
  • Receptive to positive criticism

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead

Environment: /Technology:Three environments(Dev,Stage or QA and Production),Informatica,Oracle 11i,12 c, Cognos8.4 and Cognos 10.2,Sybase Power Designer

Responsibilities:

  • Cognos BI Estimation and Managing the Overall Project(Both Technical and Project Management)
  • Gather the requirement from Business and Partnering with business users and business analysts to understand and translate business requirements in Technical Solutions.
  • Provide suggestion on Design approach and do Development on need basis.
  • Do Code review with Business and Feedback implementation
  • Attending Business meeting and providing first hand solution to customer
  • Working with senior leaderships from the customer’s side to understand the organization’s EIM need and propose technical solutions to satisfy it.

Confidential

Senior Software Engineer T

Responsibilities:

  • working as senior developer and maintaining each universe belonging to each subject area.
  • Now, there would be one integrated schema catering to all the existing universes. Sunit is changing the database pointer for each universe to the integrated schema ensuring no impact for all the existing reports in production at the front end. So, main motive is to have a single integrated enterprise data ware house and all the universes to be based on the top of the same enterprise data ware house.

Confidential

Senior Software Engineer

Environment: /Technology: Oracle 10g, BO Designer,Cognos

Responsibilities:

  • Working as senior developer and single point of contact for the customer.
  • Starting from requirement gathering, creation of universe, unit testing, integration testing and implementation, I am looking into all.

Confidential

Senior Software Engineer

Environment: /Technology:Three environments(Dev,Stage or QA and Production),Informatica,Oracle 10g,BOXIR2,CRN

Responsibilities:

  • Involved in preparing the proposal on response of RFP for the SSS Metric Project Gathered the requirement from the client and also provided the estimation to build 200 reports and universe.
  • Worked closely with the Business Analyst to gather the requirement and suggested best possible design of Data Model based on the reports requirement.
  • Designing and Reviewing the Security Structure following the best practices in BOXIR2 to enable a high secured Environment.
  • Involved in the understanding & gathering the requirements, data mapping, designing phase and deploying the Universe and 200 reports
  • Implementing the Row Level and Object Level Restriction on the Groups.
  • Trouble shooting the issue (Development related) which arises during the time of UAT.
  • Presented Trainings to the higher managements using PowerPoint.
  • Initial work involved understanding and studying the underlying database along with preparing the data mapping document and the report layouts as per the user requirements.
  • Involved in creation of a number of metrics, reports navigating from one to the other along with the creation of universe.
  • Involved in the creation of a universe, which had multiple subject areas but combined in one universe only.
  • The different subject areas were merged within a single universe. For the repeated tables across the subject areas, aliases were created.
  • The universe was logically divided according to the subject areas for easy understanding and readability. Contexts were created on each fact, summary and aggregate table including the required dimensions. Row level security has been implemented in the universe across all the users and groups.
  • The reports consisted of some complex functionalities like two level and three level navigation (summary report to header report and to line level report), creation of reports using different data providers, and some other complex calculations and functionalities.
  • The summary reports have been linked to the detailed ones using the open document functionality.
  • Checking Universe Access.
  • Connections and Connection Parameter.
  • Tables Used in the universe
  • Classes and Objects Used in the Universe
  • Joins, Join Condition and Cardinality
  • Contexts and Aliases
  • Filters Used In the Universe If Any
  • Check for RLR.
  • A round of testing and sanity check was done in the UAT environment after moving the contents from the development environment to the stage for the UAT.
  • The issues raised by the client during the UAT were also handled by him and this also involved interaction with the users.
  • Involved in the documentation of each metric, along with the performance check of the reports.

Confidential

Senior Software Engineer

Environment: /Technology: Oracle 10g, BOXIR2 (Both Deski and Webi)

Responsibilities:

  • Working as senior developer and trouble shooting the end user's problem

Confidential

Software Engineer

Environment: /Technology: Three environments(Dev,Stage or QA and Production),Oracle 10g,BOXIR2

Responsibilities:

  • As an admin, involved in security design and creation of security structure of groups.
  • Worked in validating the reports with the corresponding lower version counterparts and fixed the issue as and when required.
  • Designing, Implementing and Validating the Security Structure following the best practices in BOXIR2 to enable a high secured Environment.
  • Designed a document for validating the security structure of the users, groups, folders and applications.
  • Implementing the Row Level and Object Level Restriction on the Groups.
  • Migrating the Content (Corporate/Personal Documents, Groups and Users etc) from BO 6.5 to BOXIR2 using incremental method.
  • Trouble shooting the issue (Admin/ Development related) which arises during the time of UAT.
  • Documenting all the functionalities and preparing best practice documents

Confidential

Software Engineer

Environment: /Technology: Oracle 10g,BOXIR2

Responsibilities:

  • working as a developer in this project .some of the reports was required to be fixed as because they had some error during migration.
  • So sunit had taken a lead role in fixing of all the reports and at the same time he was coordinating with the other team members as well.

Confidential

Software Engineer

Environment: BOXIR2,Oracle 9i

Responsibilities:

  • Working in the analysis phase of the Data model and generating reports for various applications

Confidential

Software Engineer

Environment: /Technology: Abinitio, Oracle 9i,BOXIR2

Responsibilities:

  • Working for the unit testing and integration testing.

Hire Now