Jovita Lobo

BI Developer / Analyst Programmer / Senior Software Engineer في Accenture Services Pvt. Ltd.

• الهند - بنغالورو
• أغسطس 2008 إلى سبتمبر 2012

PROJECT 1

Client : Insurance Client (UK)
Location: India Duration: Oct 2008 to Sept 2012
Designation: BI Developer
Team Size: 20

Project Description:

This is a BI project which is basically being used to provide reports to the higher management of the Insurance Company. The reports are specific to the regions which help the management people to keep the track of their insurance policies so that they can understand how the business is performing in different regions and they can take their decisions on the basis of performance of the policies in those regions.

Roles & Responsibilities:

• Technical Requirement Analysis, Estimating, Designing, Schedule Planning, Resource allotment, Development and Production Implementation of modules.
• Preparation of design documents and documents depiction solution architecture for minor projects.
• Involved in Implementation and Maintenance of 18 Modules (Major and Minor Projects).
• Status Reporting and On-shore Co-ordination.
• Involved in Upgrading of SQL Server 2000 databases to SQL Server 2005.
• Expertise in building and migration of various DTS packages.
• Creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules.
• Developing SSIS packages to automate the Import and Export of data to SQL Server 2005 using SSIS tools like Import and Export Wizard and BIDS.
• Created Database authentication modes, configuring permissions and assigning roles to users.
• Created Reports using SSRS, Brio, ProClarity, ASP and Dashboard.
• Scheduling and deployment of reports and uploading files to a report server catalog from the report manger.
• Created data driven subscriptions for sending SSRS reports to end users via email on a daily/weekly basis.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures & modified MDX Queries using SQL Server 2005 Analysis Services.
• Involved in end to end dry run of test data in all modules.
• Created DB Installers for the releases.
• Maintained the database schema in source code control.
• Maintenance of the existing application and resolving bugs/defects and other issues.
• Production Support for critical job failures and high priority issues.
• Created package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
• Created Visio flow diagrams to depict the flow of data in all modules.

PROJECT 2

Client : Accenture Services Pvt. Ltd. (Internal)
Location: India
Duration: Aug 2008 to Oct 2008
Designation: Software Engineer
Team Size: 12

Project Description:

Data warehouse Project development and maintenance using Informatica and Business Objects.

Roles & Responsibilities:

• Actively involved in design document preparation on the basis of high level requirement documents.
• Design and develop PL/SQL packages, stored procedures, tables, views, and functions and implement best practices to maintain optimal performance.
• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modelling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Build ETL Process for processing fact and dimension tables with complex transformations.
• Developed complex ETL mapping and its corresponding sessions & worklets, workflows.
• Performed End-to-end testing of Data warehouse/Data Mart load.
• Created Derived tables at universe level to resolve report level complexity.
• Developed universes to accommodate complex database design approaches.
• Created and formatted reports to visually represent data.