We provide IT Staff Augmentation Services!

Senior Developer / Bi Consulatnt Resume

SUMMARY:

  • More than 6 years of experience in core development / production support.
  • Strong base and work experience in datawarehousing - ETL and Reporting and working with different databases.
  • Extremely diligent, excellent communications skills, and eager to collaborate with, learn from and share knowledge with others.
  • Strong functional/domain knowledge with a good understanding of technology, methodologies and processes.
  • Hands on experience in all phases of software development lifecycle from requirement gathering, analysis, development, testing and defect tracking to production support.
  • Willing to expand knowledge base and learn - to work with different /new technologies and tools.
  • Exceptional skills and experience at source system analysis, understanding business requirements and interpreting data.
  • Experience in leading a team, coordination, delegating tasks and tracking releases.
  • A highly motivated individual, good at multi-tasking and a good team player.
  • Experience in development of ETL using Business Objects Data Integrator and PL/SQL stored procedures.
  • Experience in Business Objects (BO XI 3.1) Crystal Reports and Business Objects Desktop Intelligence and Web Intelligence Reports development.
  • Experience in Oracle 10g/11g, Teradata, Microsoft SQL Server, SQL and PL/SQL coding.
  • Experience in BO Universe design and mapping.
  • Experience in developing complex ETL workflows, mapping and creation of database objects.
  • Experience in creating source to target mapping by extensive source system analysis.
  • Database design experience to set up a relational model in 3NF and dimensional model in Confidential .
  • Experience in handling production support, defect tracking, testing and trouble shooting.
  • Functional knowledge of FX/Trading, Finance, Insurance and telecomm domains.

PROFESSIONAL EXPERIENCE:

Confidential

Platform: Oracle 11g, Business Objects BI (version. BO XI 3.1)

Technology: Business Objects Web Intelligence Reports, Oracle 11g SQL/PL SQL

Senior Developer / BI Consulatnt

Responsibilities:

  • Requirements gathering, analysis, development, testing and deployment of Compliance Reporting Sysytem.
  • Single-handedly designed the BO Universe for the Webi reports.
  • Implemented complex BO Universe workarounds to accommodate cascading prompts with ‘ALL’.
  • Designed and developed complex WebI reports.
  • Designed and defined database structures to restrict data access based on the user login.
  • Based on the requirements developed set of reports starting with the dashboard report with charts and hyperlinks to all detailed reports.
  • Analysed the requirements for user onboarding and set up multi user/level access in BO CMC based on it.

Confidential

Platform: Oracle 11g, Business Objects BI

Technology: Business Objects Web Intelligence Reports, Oracle 11g SQL/PL SQL

Senior Database Developer / BI Consultant

Responsibilities:

  • Actively involved in designing a stable and automated reporting system based on the business requirements.
  • Developed complex PL SQL procedures to load data.
  • Analysed the business requirement and developed the data flow.
  • The PL SQL procedures involved complex derivation from souce system and was designed to automate the entire system with least manual intervention.
  • Also developed SQL queries for the front end GUI.
  • Designed and developed WebI reports involving complex calculations.
  • Performed intensive testing to match numbers on revenue and commissions.

Confidential

Platform: Microsoft SQL Server 2005, Business Objects ETL and BI

Technology: Business Objects Data Integrator and Data Services, Business Objects Crystal Reports, Business Objects Web Intelligence Reports, Microsoft SQL Server 2005 SQL, PL/SQL

Module Leader

Responsibilities:

  • To handle change management - understand business requirement for change requests, analyse the impact and estimate efforts.
  • Release management - To delegate issues / tasks and change requests based on priority, severity and efforts; ensure on time delivery.
  • Played a pivotal role in understanding and analyzing the requirements directly from the business analysts from the client side and representatives from the regulatory body for two major initiatives.
  • Actively helped in system design, defining data flow, system and data integration techniques and development methodologies.
  • Performed impact analysis of changes on data and on system.
  • Made design changes in the existing flow when implementing new change requests that ensured the system stability and in streamlining the applications.
  • Manage and monitor data loading of previous day’s business from source system (AS 400) to target (Microsoft SQL Server 2005) using Business Objects Data Integrator 11.7.
  • Developed and modified DI/DS jobs and procedures as part of change requests or to reolve issues. Delivered defect free critical and complex change requests on time.
  • Designed, developed and modified WebI and crystal reports.
  • Defining upgrade strategy - Charted out tasks list, delivery plan and timeline for migrating from existing BO Data Integrator 11.7 to SAP BO Data Services 4.0. In addition to this, actively involved in migrating UAT and production databases as part of restructuring of existing architecture for optimal use of job servers and space.
  • Identified data related issues anomalies and analyse with business to determine the best course of action to correct the data.

Confidential

Platform: Oracle 10g, Business Objects Universes based on Flexcube

Technology: Business Objects Crystal Reports, Business Objects Desktop Intelligence Reports, Oracle 10g SQL, PL/SQL

Senior BI Developer - Team Member

Responsibilities:

  • Part of the team that developed the reports with the source as a universe based on flexcube.
  • Identified mapping for the report attributes that involved understanding the underlying flexcube architecture.
  • Shared responsibilities for change management and helped define reporting structure and standards.
  • Reports developed were based on major flexcube modules like CORE, CASA, CL, GL, FX, MM, BC, LC.
  • Made changes to universe as part of extracting accurate data for reports.
  • Developed complex crystal reports that included multiple subreports and sectioning.
  • Worked on change requests which included changes to the flexcube to universe mapping as per the requirement.
  • Identified, analyzed and interpreted complex data sets using database queries for generating accurate and desired reports.
  • Actively involved in testing including test cases preparation, defect fixing and documentation (Design documents, Release documents).
  • Involved in all phases of the production from development of the reports through various testing phases including user acceptance testing till production.

Confidential

Platform: Oracle 10g, Siebel CRM System, Kenan Billing System

Technology: Oracle 10g SQL, PL/SQL

ETL Developer/Team Member

Responsibilities:

  • Part of the team that developed the ETL for the generation of new source tables for extracting data for reporting. Oracle 10g SQL was used for the same. The entire task was based on the migration of data from the existing Unicorn system to Kenan Billing system.
  • Developed the scripts for scheduling and source file management.
  • Developed queries to analyse data to match it to the new source system entries.

Confidential

Platform: Oracle 10g, Siebel CRM System, Kenan Billing System

Technology: Oracle 10g SQL, PL/SQL

Developer/Team Member

Responsibilities:

  • Part of the team that developed new finance and customer centric reports and modified existing ones using Oracle 10g SQL and PL/SQL based on the new source system prior to the migration of data from the existing BSCS system to Kenan system.
  • Quick resolution of billing ticket issues.
  • Worked in tandem with front-end reporting team in identifying data flow to reolve issues.
  • Also involved with the team that handled the delivery and support activities for pan-India VAS reports and dashboards.
  • Analyzed reports for errors and duplicates in billing data sets using database queries.

Confidential

Software Engineer

Platform: Oracle 10g, Teradata, Unix, Siebel CRM System, Kenan Billing System

Technology: Business Objects DI, Oracle 10g SQL, Teradata SQL

Responsibilities:

  • Actively involved in the end to end development starting from the development of the design document till the user acceptance testing.
  • Developed the complete column level mapping for Teradata’s Communication LDM by in-depth analysis of various sources - Siebel CRM, Kenan and sample data files. The mapping was verified by a team comprising the internal functional consultant and Teradata’s functional consultant.
  • Developed and deployed the physical data model for the LDM in Teradata.
  • Developed Confidential Jobs that performed the ETL to load target entities.
  • Deployed the Confidential jobs in various environments viz. development environment, testing environment.
  • Developed scripts to schedule jobs, performed source file management, job integration, data validation, peer-peer reviews.
  • Developed and performed unit testing and system integration testing.

Confidential

Software Engineer

Platform: Oracle 10g

Technology: Oracle 10g SQL, PL/SQL, Business Objects Crystal Reports

Responsibilities:

  • Prepared the design document for the development of the Confidential database for reporting purposes and for the development of reports. The work involved column level mapping between ODS and Confidential and column level mapping for the reports.
  • Also developed reports and help files using Business Objects Crystal Reports, Oracle 10g PL/SQL procedures and performed unit-testing.

Hire Now