We provide IT Staff Augmentation Services!

Senior Bi Developer Resume

New, JerseY

PROFFESIONAL SUMMARY:

Highly motivated Business Intelligence Developer with 11+ years of experience in Report Design, Implementation, ETL, Migration, Enhancement with TST and Production environment support for various business application across different domains like Banking, Telecom and Healthcare.

SKILL:

  • Cognos BI Report Studio, Analysis Studio and Query Studio, Workspace Advance, Active Reports, Cognos Connection
  • DMR/RMR Modeling with Framework Manager
  • Cube Modeling with Powerplay Transformer
  • TM1 cube, TI Process, Rules, Dimension
  • IBM Datstage 8.1
  • Microstrategy 8.0
  • Javascript with Cognos BI reporting
  • Client - server configuration between Cognos transformer on Unix and Windows
  • Cognos 10 BI Server installation/configuration on windows and Unix
  • Business Object XIR2
  • Knowledge on Tableau Desktop, Tableau Prep, Tableau Server
  • Migration from Cognos 8.4 to Cognos 10.2.1, Cognos 10.2.2.
  • Dynamic cube with Cognos cube designer.
  • Cognos security through LDAP, Cognos Connection Roles and in Framework manager at object and Package level.
  • Report scheduling and administration
  • SQL, PL/SQL
  • GitHub, Jira, HP QC, SVN

PROJECT EXPERIENCE:

Senior BI Developer

Confidential, New Jersey

Responsibilities:

  • SVN, Jira, Github, Cognos BI, TM1 Architect, Oracle 11g, Toad, HP QC
  • Work closely with business users gathering requirment and prepare technical design documents
  • Efforts estimation of design, development, testing and deployment of BI reports/cubes
  • Development of Daily/MTD/YTD Trading BI reporting solution in Investment Banking using Cognos BI with FM
  • Advanced Turbo Integrator scripting
  • Rules to apply business rules to a cube
  • Participate in peer code reviews
  • Responsible for reports and database performance analysis and tuning.
  • Provide post implementation level 3 technical support
  • Managing offshore and on-site Developement/Support with mentoring new developers

Senior BI Engineer

Confidential

Responsibilities:

  • SVN, Jira, Cognos BI, Powerplay Transformer, TM1 Perspective, Oracle 11g, Toad, HP QC, Unix
  • Debug, monitor and troubleshoot Cognos BI & TM1 Applications solution.
  • Collecting Enhancement requirement, preparing tech spec and development of Cognos BI Report and cubes
  • Development of Cube views based security on Cube with respect to business requirement
  • Worked extensively on creating Models using Framework Manager and publishing package
  • Rules application in Cognos TM1 perspective
  • BI Dashboards Reports in Report Studio using MDX model from Cube
  • Level 3 Support for 14 different Sales Mgmt BI Application
  • Migration of Legacy Cognos 10.2.1 IQD based cube model to Cognos 10.2.2 FM Package Based model
  • Estimation of migration of 14 Sales Mgmt application from Cognos 8 to Cognos 10.2.2

Senior Software Engineer

Confidential

Responsibilities:

  • SVN, MicroStrategy Desktop, MicroStrategy Intelligence server, MicroStrategy Architect, IBM Datastage 7.5, Oracle 10g, Toad, Unix
  • Requirement gathering at onsite with client community on first 3 months. Preparation of tech spec document approval for further design/development
  • Daily supervision of each production incidents and delivery in production following version mgmt Tortoise SVN policy.
  • Supervision of each documentation followed by client for each production delivery in different tools like gedeon, PVCS PC
  • Created different schema objects like Attributes, facts by using MicroStrategy Architect of the MicroStrategy BI Suite
  • Created different Project Sources for different environments like production, testing and development.
  • ETL process design in Datastage
  • DW Technical knowledge sharing with other technology skilled team to prepare multi skilled resource environment

ETL Datastage Developer

Confidential

Responsibilities:

  • IBM Datastage 8.1, Sybase ASE, unix Shell Script
  • Agile methodology
  • Migration from Legacy mainframe to new Data mart using IBM datastage ETL
  • Creation of unit test cases and documents.
  • Testing newly developed & Enhanced ETL jobs on daily bases
  • Unix scripting to run all the module jobs.

BO Report Developer

Confidential

Responsibilities:

  • Analyzing of the existing crystal reports developed in crystal reports 9 and Finding comparative functionalities in BO
  • Creation of documents/Reports for comparative features and work around for different feature available in BO and any alternative solution for road blocks
  • Created Sub Reports, Sorting, Group, Suppress, Variable, Drill and Charting.
  • Designed Standard List Reports, Cross-tab Reports, Charts, Master-Detail and Drill through Reports
  • Test the report at query level as well as report level in client environment using SQL query profiler

Cognos Report Developer

Confidential

Responsibilities:

  • Migration of 47 Cognos macro report from Cognos 7.2 to Cognos 8.3 with different 11 BI based application
  • Existing Cognos Series 7 macro reports study and analysis
  • Provide some ad-hoc report using Query studio
  • R&D on Cognos Macro and provide support to develop macro using Cognos SDK and Java scripting during migration to support Cognos C7 macro
  • Creation of report views with saved prompts and schedule according to the business requirement
  • Created PowerPlay Reports by using Analysis Studio

Hire Now