Database Developer Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

                                               Anna Dunning

                                                       SAP Business Objects

                                                     Annadunning@gmail.com 

           

Summary:

• Technical Design and Implementation of Business Intelligence Solutions
• Over 10 years of IT experience in Analysis, Design and Development of Client-Server and Web Based Business Intelligence and Data Warehousing applications.
• Expertise in Business Objects XI R2 (Designer, CMC, Desktop Intelligence, Web Intelligence and Info View, Import Wizard, Report Conversion tool, Publishing Wizard, CCM)
• Clear understanding of BO Enterprise interface, architecture and process flow.
• Expertise in Business Objects 4x, 5x and 6.x (Designer, Business Objects Full-client, Web Intelligence and InfoView, Supervisor, Broadcast Agent)
• Experience in building large Universes, retrieving data from Personal data files, Stored procedures, derived table and aggregate aware function, Free hand SQL and creating complex ad-hoc reports
• Worked with Business Users to analyze the business process to create/modify user-friendly objects and reports.
• Experienced in Migrating BO reports and Universes from version 5.x/6.x to version XiR2
• Proficient in Unix shell scripting and AutoSys scheduler
• Designed and Created reports using Crystal reports XI /10
• Trained business-user in Business Objects modules.
• Well versed in various phases of software development life cycle and ETL.
• Experience in writing SQL queries, PL/SQL procedure and packages, and advanced knowledge of database systems.
• Have good exposure in architecture, analysis, design, development and testing of Data Warehouses/ Data Marts systems.
• Experience in deployment of Business Objects & Web Intelligence from Various Sources Oracle, MS SQL Server, DB2 and Access.
• Excellent communication and interpersonal skills.

Computer Skills:

Business Intelligence	BO Xi R3, Dashboard, BO Xi R2 (Desktop Intelligence, CMC, Designer, Web Intelligence, Import Wizard, Publisher, Report Conversion Tool); Business Objects 6.x (Business Objects, Supervisor, Designer, Broadcast Agent, Web Intelligence, Publisher), BO 5.x and 4.x, Crystal Reports XI/10/9, BO Xi R2, XCelsius 4.5, Dashboards with QAAS,LiveOffice and XCelsius MicroStrategy, OBIEE
ETL Tools	Data Integrator, Informatica Power Center/Power Mart 7.1/6.2/6.1/5.1 (Source Analyzer, Warehouse Designer, Mapping Designer, Mapping Designer, Mapplet Designer, Transformations)
Data Modeling	Star Schema Modeling, Snowflake Modeling, FACT Table, Dimension Table, ERwin
Tools	MS Access Reports, SQL *Loader, SQL *Plus, TOAD, ClearCase, ClearQuest, TestManager
Web Tools	HTML; Java Script, FTP, Telnet
GUIs	Developer (Forms 6i/5.0/4.5, Reports 6i/3.0/2.5), Visual Basic 6.0
OS	Windows NT/XP, Unix
Languages	SQL, PL/SQL, C, JavaScript, HTML, D L, VB.NET. Java, COBOL
RDBMS	Oracle 10g/9i/8i/8.0/7.x, Rapid SQL, Command Center, MS Access, DB2

Training: BO Advanced Universe Design, BO Performance Management, BO Xi R2 Xcelsius

Professional Experience:

SunTrust Banks, Inc., Atlanta, GA                                                                Jan 2010 – Present

Sr. Business objects Developer

Environment: Business Objects XI R3.1 (Administrator, Designer, Desktop Intelligence, Web Intelligence, CMC & Info View), SQL, PL/SQL, Oracle 9i, Windows 2003.

Responsibilities:

·         Installed and configured Business Objects XI 3.1 on windows 2003 and Red hat Linux EL 4.

·         Applied patches in cluster environment for Business Object Server, Crystal Enterprise Server and Crystal Reports.

·         Mapped the database fields after developing the reports as per the client requirement.

·         Migrated the Crystal Reports 8.5 to Crystal Report 10 and published the reports in Crystal Enterprise server.

·         Extensively used the Report Inspector tool to change multiple reports, database schemas, scheduled multiple reports, deploying and publishing.

·         Customized the Infoview page with Company Logo, User required information and redeployed the WAR files.

·         Published and maintained the reports of daily, monthly and yearly.

·         Configured the SMTP settings to send the reports to user’s email after scheduling the reports in Crystal Enterprise Server and Business Object Server.

·         Defined the security model in Enterprise XiR2 and XI3.1.

·         Created slides for data flow and process flows using PowerPoint and Microsoft Visio

·         Designed, defined, developed, tested and maintained the universe and reports

·         Using Import Wizard deployed the reports from Dev system to Test and to Production. 

·         Defined the report deployment strategy

·         Configured the Single Sign On in .net environment

·         Developed reports in Web Intelligence XIR2 and XI 3.1.

·         Added/created complex objects to the universe to enhance the report functionality.

·         Optimized the usage of user objects, conditions and universe level filters

·         Maintained existing reports and Created standard template for all reports.

·         Involved in documenting the changes to the universe and reports functionality.

·         Identified issues with some of the reports with ambiguous data and resolved the issues

·         Performed data validation by writing SQL queries and creating ad hoc reports using desktop intelligence and web intelligence

·         Created Hierarchies to facilitate drill down

·         Resolved the performance issues with the drill down reports.

Arbitron Inc, Columbia,MD                                                                              Sep 2007 – Dec 2009

Sr.Business Objects Architect

Arbitron Inc. is a media and marketing research firm serving radio broadcasters, cable companies, advertisers, advertising agencies and outdoor advertising companies. Arbitron’s core businesses are measuring network and local market radio audiences; surveying the retail, media and product patterns of local market consumers; and providing application software used for analyzing media audience and marketing information data.

Environment: Business Objects XI R2/R3, Crystal Reports XI/ 10, XCelsius 4.5, QAAWS, Data Integrator, Oracle 10g/9i, UNIX and Windows NT.

Accomplishments:

◊ Ownership of all aspects of Administration functions for projects, servers, user & security administration

◊ Managing migration of development, QA and production projects and objects

◊ Providing technical support; troubleshooting report design; monitor system usage and proactive troubleshooting

Responsibilities:

• Strategic Assessments of the requirements to provide high quality solutions
• Gathering Requirements, Proposed Scenario Walkthrough and ad-hoc queries
• Designing, developing, testing, implementing and maintaining business intelligence applications for accessing, analyzing, and presenting business information
• Delivering Technical Solutions while working with Data Architects, Database Administrators as well as Business Team members
• Meeting with appropriate technical staff, end users, and senior management

• Providing administration support for the various Business Objects instances (Dev,QA,Pord) inclusive of server and service monitoring, report posting, code migration, platform upgrades, universe creation and establishing user ids in UNIX/Linux based environment
• Providing mentoring to team members as appropriate
• Creating users, groups, folders and categories with the implementation of Enterprise security model
• Involved in Business Objects Universe design, creation and maintenance activities utilizing Industry Standard data warehousing best practices
• Responsible for the creation of the Universe Structure modeled from relational databases and create classes/objects/measures using existing data warehouses
• Using CCM for Server Management, CMC for User, Group setting
• Design Universes based on reporting requirements to include aggregate awareness, derived tables, and linked universes, row-level security as needed
• Translating business needs into data analysis and reporting solutions
• Performing data warehouse lifecycle functions, including requirements gathering, design, develop, tests implement, and maintain BI tool products
• Design, configure, test, and implement OLAP solutions, drill down/through paths, and reports
• Designing, developing Dashboards using Query as Web Services (QAAWS) and XCelsius
• Defining Source and Target Metadata in Data Integrator
• Creating and Defining Data Flows; adding source, target objects and transforms to Data Flows and Executing Data Flows
• Creating and Executing Jobs, Exchanging Meta Data, Performing Data Cleansing Operations and Monitoring Jobs

.

Fannie Mae, Washington DC                                                                         Feb 2007 – Aug 2007

Sr.Business Objects Developer

The Interest Rate Database (IRDB) stores various market data such as Treasury and Libor rates, MBS benchmark prices, Fannie Mae derived curve, etc. The data can be accessed by various application that need current or historical market rates.

Environment: Business Objects XI R2, XCelsius 4.5, QAAWS,Crystal Reports XI/ 10, Oracle 10g/9i, UNIX and Windows NT.

Accomplishments:

◊ Reduced overall Business Intelligence Management using Reusable objects and Intelligent Reporting Solution

◊ Facilitate the management of the application, movement and testing of objects and performance monitoring/capacity planning of the overall system

◊Successfully provided solution for Interest Rate Report Automation

Responsibilities:

• Gathering Requirements, Proposed Scenario Walkthrough
• Designing, developing, testing and implementing reports and portals using Business Objects
• Developed Business Objects Universe from various data sources using BO Designer
• Resolved loops, define contexts, effectively use LOVs, create and use hierarchies
• Generated Web Services using Query as a Web Services (QAAWS)
• Used Web Services in XCelsius 4.5 to generate critical Business flow  reports
• Passed parameters to Web Services in XCelsius
• Developed Xcelsius Dashboards for the corporate clients
• Providing administration support for the various Business Objects instances (Dev,QA,Pord) inclusive of server and service monitoring, report posting, code migration, platform upgrades, universe creation and establishing user ids
• Extensively using User conditions, Filters, Functions, Variables, Sort, Ranks, Drilling, Slice and Dice, Alerts, Sub queries, and Prompts for creating efficient Business Objects reports
• Heavily involved in BOXI Universe design based on business requirements
• Administered user management and content management of BO enterprise
• Interacting with user to gather requirements and designing technical and functional specifications
• Providing daily status report and project milestones to stakeholders
• Handling Installation, configuration and management of BO components

Freddie Mac, McLean, VA                                                                Oct 2005 – Jan 2007

Business Objects Developer

Ex-Post is an economic view of actual results and cash flows of Freddie Mac’s Single Family line of business. With the Ex-Post data business can generate core management reports such as Profit and Loss Statement and UPB Roll forward. The balance and key results are tied to the General Ledger.

Environment: Business Objects XI R2, Business Objects 6.5, Crystal Reports XI/ 10, Oracle 10g/9i, SQL Server 2000 & Windows NT.

Accomplishments:

◊ Successful setup and configuration of Business Objects Enterprise Servers, Adding and Maintaining Users, Groups and Reports

◊Seamless integration of User Group to External LDAP, Windows Authentication

 

Responsibilities:

• Migrated Reports, Universes from Version 6.5 to Business Objects XI R2
• Used Report Conversion Tool to migrate Business Objects documents version 6.x to web intelligence documents.
• Designed and created complex, multi-tabbed Deski and Webi reports, debugged and tuned existing reports
• Designed, developed, debugged and managed Universes
• Developed training material and Mentored employees on the Business Objects XI R2 suite of products

• Extensively used User conditions, Filters, Functions, Variables, Sort, Ranks, Drilling, Slice and Dice, Alerter, Sub queries, Prompts for creating efficient Business Objects reports.

• Created new Universes and fine-tuned existing ones by resolving join problems, setting up aggregate awareness, defining hierarchies, cascading LOV, @Functions and more.
• Designed and Created reports using Crystal reports XI /10
• Researched/resolved problems and advise client regarding Business Objects issues and hot-fixes
• Interacted with user to gather reports requirements and designed technical and functional specifications.
• Mapped actual LOV data to more user-friendly 
• USA Resume
• that are displayed in the prompt LOV
• Used Stored procedure, Free hand SQL and personal data files along with RDBMS data providers

 

Federal Reserve Bank, Richmond, VA                                                       March 2005 – Sept 2005

Business Objects Consultant

SCA is a web application, which is designed for monetary circulation management. This system controls monetary flow from inventory to clients and vice versa. In this application information was extracted from different OLTP applications using Informatica.

Environment: Business Objects 6.5, Oracle 9i/8i, SQL Server 2000, Windows NT, Unix

Responsibilities:

• Interacted with user to gather reports requirements and designed technical and functional specifications
• Designed and created complex Full-client and Webi reports, debugged and tuned existing reports
• Designed, developed, debugged and managed Universes

• Extensively used User conditions, Filters, Functions, Variables, Sort, Ranks, Drilling, Slice and Dice, Alerts, Subqueries, and Prompts for creating efficient Business Objects reports.

• Created new Universes and fine-tuned existing ones by resolving join problems, setting up aggregate awareness, defining hierarchies, cascading LOV, @Functions and more.
• Research/resolve problems and advise client regarding Business Objects issues and hot-fixes
• Used personal data file data providers along with RDBMS data providers
• Installation/Setting of Web Intelligence and Broadcast Agent server.
• Mentored employees on the Business Objects suite of products
• Planned coordinated and executed Business Objects 6.x deployment for End-users and documented the entire deployment.

Freddie Mac McLean, VA                                                                             Jan 2004 – Feb2005

Business Objects Developer

Single and Multifamily Application is a part of ON-TRACK (re-instatement) web application, which is designed for Mortgage Business. This system consists of Customer information, Customer Loan information, Customer interest rate information, Loan status information, Cost & price etc.

ENVIRONMENT: Business Objects 5i, Web Intelligence 2.6, Oracle 8i & Windows NT, Unix

Responsibilities:

• Designed and created Complex Full-client and Webi reports
• Analyzed and defined requirement analysis for Business Objects Reporting
• Installation/Setting of Web Intelligence and Broadcast Agent server.
• Used personal data file data providers along with RDBMS data providers
• Installed/Set Web Intelligence and Broadcast Agent server.
• Mentored employees on the Business Objects suite of products
• Extensively used User conditions, Filters, Functions, Variables, Break points, Sort, Ranks Drill down, Slice and Dice, Alerts for creating efficient Business Objects reports.
• Research/resolve problems and advise client regarding Business Objects issues and hot-fixes
• Created new Universes and fine-tuned existing ones by resolving join problems, setting up aggregate awareness, defining hierarchies, cascading LOV, @Functions and more.
• Designed, developed, debugged and managed Universes
• Analyzed and defined requirement analysis for Business Objects Reporting
• Designed and created Full-client and Webi reports
• Used aggregate awareness in universes
• Installation/Setting of Web Intelligence and Broadcast Agent server.
• Extensively used User conditions, Filters, Functions, Variables, Break points, Sort, Ranks, Drill down, Slice and Dice, and Alerts for creating efficient Business Objects reports.
• Research/resolve problems and advise client regarding Business Objects issues and hot-fixes

Integra Systems Inc., Tulsa, OK                                                                   July 2002 – Dec 2004

PL/SQL Programmer

CMS was a web application, which was designed for Warehouse Business. This system consists of Customer information, Customer Order information, Customer Account information, Shipping and Mailing status, Customer products, Customer purchase information, Cost & price etc.

Environment:  Oracle 7.1, PL/SQL, Developer 2000, Windows NT.

Responsibilities:

·         Designed, developed, tested, implemented and maintained PL/SQL  procedures/packages/triggers to solve business requirements

·         Worked with development team members to architect and build new and enhance existing applications

·         Optimized and tune stored procedures

·         Designed, optimized PL/SQL implementations and packages

·         Analyzed and documented existing PL/SQL migration procedures

·         Automate UNIT testing for PL/SQL packages

·         Involved in writing SQL stored procedures to access data from Oracle 7i

·         Developed data model(s) and business logic in Oracle using PL/SQL

·         Developed SQL queries to check the database

·         Developed packages/procedures using PL/SQL

·         Assisted Database Architect and DBA in the creation of a data warehouse

·         Developed scripts in PL/SQL, SQL to build the application database objects

·         Created the UNIX shell scripts to automate the PL/SQL procedures and functions.

·         Involved in writing PL/SQL Cursors and Triggers for Exception Processing.

·         Created Triggers, Stored Procedures, Functions, Tables, Indexes, Rules.

·         Coordinated with clients as needed for on-going system support and troubleshooting.

 

SoftTech Inc., Oklahoma City, OK                                                                April 2000 – June 2002

Database Developer

The integrated Drug file System used an extensive repository of drug information and provided means for efficient dispensing and pricing of drugs in pharmacies all over the country.  

Environment: Oracle 7.x, SQL*plus, SQL*Loader, PL/SQL, Forms 4.5, Reports 2.5

Responsibilities:

·               Involved in the design of the overall database using Entity Relationship diagrams

·               Created, designed database based upon business and user requirements

·               Performed both logical and physical modeling of database objects for optimal performance

·               Wrote triggers and stored procedures in PL/SQL.

·               Involved in developing interactive forms and customization of screens using Forms 4.5.

·               Involved in building, debugging and running forms

·               Developed queries to provide user view of data

·               Developed functional and technical requirements and design documentation

·               Developed testing scenarios and required testing environment and procedures

·               Translated end-user requirements and specifications into efficient executable programs

·               Involved in Data loading and Extracting functions using SQL*Loader.

·               Designed and developed all the tables, views for the system in Oracle.

·               Designing and developing forms validation procedures for query and update of Data.

Renoir Inc., Westchester, NY                                                                        Aug 1999 –March2000

Oracle Developer

The project develops a database application for a leading investment management company which focuses on building solutions for its clients through an unsurpassed array of quality mutual funds and related investment products and services to investors worldwide.

Environment: Oracle 7.3(SQL, SQL*Loader), SQL Server 6.5, and Developer/2000

Responsibilities:

·         Attended several business sessions with the business users and created Views and altered some of the dimensional tables to satisfy their reporting needs.

·         Wrote the SQL procedures replaced for SQL Server to improve the warehouse loading

·         Designed the Database Schema using Designer /2000

·         Designed the Mapping for sales organization

·         Defined entities, attributes, UIDs, and relationships

·         Database Schema Design, Wrote SQL procedures for the application

·         Created dimensions and facts in physical data model

Certification: BOXI Certification in progress

Education:                          MSME         The University of Akron, Akron, Ohio

                                         BSME        

Download Resume Format