Sql Server Data

Veena Myers

PROFESSIONAL SUMMARY

• Over * years of experience in analysis, design, development and implementation of

Business Applications and client/server applications.

• Experience in full SDLC from Requirements Gathering and Analysis, Evaluating Data

Sources, Translating Requirements into Specifications, Business Case Development to

Rollout, Production and Maintenance

• Experience in conducting project meetings, reviews, walk through, and customer

interviews.

• Over 7 plus years of experience in Study, Design, Analysis, Development and

Implementation of Software Application Development under different environments

including 8 years of experience in using DSS/OLAP (Data Warehousing) tools i.e., SAP

BW, BI Accelerator, SAP BPC, BOXI 4.0,BOXI R3.1.Business Objects 6.1, (Supervisor,

Reporter, Broad Cast Agent, and Web Intelligence 2.6.3) and BOXI R2 (Designer,

DESKI, WEBI, CMC, Webi SDK), Xcelsius 2008, Performance Manager, Dashboard

Manager, Crystal Reports XIR2, BOXI R3.1.

• Excellent Skills in SAP Data Services XI 3.0/3.2 in design, creation, and implementation

of work flows, data flows, scripts and performing simple and complex transforms in data

flow using data quality transforms.

• Expertise in domains like Retail, Finance, Healthcare, Pharmaceutical, Government

Services, Energy Oil and Gas.

• Expertise in building Universes and creating reports using Web Intelligence and Business

objects.

• Knowledge in Implementation of OLTP Systems and Data warehousing (OLAP)

Systems.

• Extensive knowledge in all phases of Software Development Life Cycle SDLC

(Requirement Analysis, Design, Development, Testing and Documentation).

• Experienced in performing Unit Testing, Performance Testing and combined UAT with

the Users

• Strong experience in developing Test Scripts and Test Cases for Manual as well as

Automated Testing.

• Worked with End-To-End implementation with Data warehousing team and Strong

understanding of Data warehouse concepts Star Schema, Snowflake Schema and Multi-

Dimensional Models for query and analysis requirements.

• Expertise in providing Business Intelligence solutions using SAP BW,SAP Business

Objects, Cognos, Crystal Reports and other data warehousing tools in OLTP/Data

warehousing.

• Confident, independent, good decision-making power gained over all 9 years of IT

experience and ability to adapt to new technologies very quickly.

• Active in providing functional and technical support, detailed analysis, requirements

gathering, data dictionary, testing and user training.

• Document all business processes, needs, flows and diagrams.

• Keep the project manager and supervisors informed of task accomplishment, issues and

status.

EDUCATION

Bachelors Business Administration focus on Information Systems

Fresno Pacific University, Fresno, CA

California State University, Fresno, CA

1 TECHNICAL SUMMARY

ERP: SAP BW 3.1C/3.0B, SAP R/3 4.6C/4.7

O/S: Windows NT/2000/98/95/XP, LINUX

RDBMS: Oracle 10g/9i/8i/7.x, SQL Server 2005,2008, Teradata, Sybase,

and MS Access 2000

Data Modeling Tools: ERwin 4.0/3.5.2, Visio2002.

ETL Tools: Informatica 6.x/7.x/8.x, PowerCenter/PowerMart, Data Quality11.7, SAP Data Services XI

3.0/3.2, Data Integrator

Database Tools: TOAD 10.5, SQL Navigator, SQL Server (Management Studio Express)

BI Tools: SAP BW 3.5, SAP BI 7.0, ECC 6.0, SAP BPC, SAP BW Accelerator, Data Services,Business

Objects 6.1b/6.5.1/XIR2/R3.1,4.0 (Supervisor, CMC, Designer, Webi) Web Intelligence 6x/XIR2, XIR3.1,4.0

Infoview, WEBI SDK, Xcelsius 2008, Live Office, Crystal XI, Crystal Reports 2008, SAP BW 3.5, SAP BI 7.0, ECC

6.0

2 Professional Experience

TD Bank, Portland, Maine October 12 to Present

Senior Business Objects Developer

Responsibilities:

• Participated in collecting user requirements.

• Gathered Business requirements from users and key experts to understand the current

functionality of the existing system.

• Modified existing Universes, specified the Joins, checked the cardinalities and resolved

loops by either using Aliases or Contexts.

• Implemented Security Features of Business Objects like row level, object level and report

level security.

• Designed and created WEBI reports using Web Intelligence Rich Client and InfoView.

• Created reports involving table/section breaks, multiple data providers and derived tables.

• Functionalities such as Slice and Dice, Drill mode and Ranking were used for

Multidimensional Formatting.

• Resolved loops, chasm and fan traps using contexts, aliases and integrity checks

• Extensive use of major functionalities like Alerter, Group By, Query prompt, drill filter,

indexes, breaks, sorts, ranks.

• Developed reports using Business Objects functionality's like Queries, Slice and Dice,

Drill Down, @Functions, Cross Tab, Master Detail

• Developed reports using calculation contexts, function specific operators (Previous, Self),

used Input controls on webi reports.

• Involved in trouble shooting of various reporting errors.

• Prepare documents regarding technical design, high level system flows, project plan,

System use cases, requirements & solution, code reviews and issues, unit test plan, test

results, modification processes and weekly status reports for project management.

• Participate in project planning sessions to gather, analyze business requirements, and

assist in root cause analysis and resolutions.

• Expert knowledge about the file layouts and table structures/fields.

• Participate in design, coding, technical writing, testing, implementation, and

documentation of solutions.

• Status report preparation and co-ordination. Attend weekly team meetings and, client

meetings.

Environment: Business Objects XI R3.1, Oracle 10g/9i, Crystal Professional XI R2, SQL,Window 2003 Server/XP

Ann Taylor, New York, NY

Senior Business Objects Developer October’11 to July’12

The project was to create/maintain OLAP universes and to generate Webi, Crystal reports from sales, purchase

departments using SAP BW, Oracle, SQL Server as data sources. Interacting with end Users, to know their

requirements and develop/modify Universe and Reports accordingly.

Responsibilities:

• Worked with several users, and interacted with them to gather requirements.

• Developed Webi reports, extensively used Calculation contexts, Variables, Drill down,

Slice and Dice, Breaks, Sections, Ranks, Alerts, input controls.

• Created simple and complex reports including dynamic calculations involving Contexts,

Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, Ranking and

multiple data.

• Extensively used slice and dice, filtering and ranking to create cross tab and master/detail

reports.

• Involved in formatting sections, tables, inserting and organizing multiple breaks.

• Used the formatting options like cross tab representation, section breaks, data sort

options, calculations, font, colors.

• Expert in preparing report specifications, database designs to support the reporting

requirements.

• Developed Webi reports using multiple data providers.

• Perform data validation and cleansing while developing analysis datasets.

• Develop model scoring code for historical and current data that generates tabbed Excel

spreadsheets using

ExcelXP Tagsets.

• Experience in building dashboards, score cards, metrics using Crystal Xcelsius, Live

Office for adhoc reporting.

• Created Cross Tab Reports and Sub Reports, insert sub reports, Share Formulas Between

Main and Sub reports using Crystal Reports version 2008.

• Designed queries in Bex query designer and created workbooks in Bex Analyzer using

conditions, structures, calculated key figures, character variables, formula variables and

text variables

• Worked with business users for defining reporting needs, help design flexible queries, pre

calculated reports using BEX reporting features like variables, conditions, exceptions

• Creation and maintenance of OLAP universes source from BEx queries.

• Writing and editing of SAP BEx queries using Query Designer.

• Used Webi SDK to customize the look and feel of Infoview as per the client's

requirements.

• Writing of test scripts for accuracy, formatting, and performance.

• Preparation of Technical Design Document based on the Functional Requirement

Environment: Business Objects XI R4.0,Business Objects XI R3.1, Xcelsius 2008, SQL Server 2005/2008R2, Oracle

10g/9i, Window 2003 Server/XP, SAP BW 3.x, SAP BI 7.x

Conoco Phillips, Bartlesville, OK

Senior Business Objects Developer May’11 to October’11

ConocoPhillips is an international, integrated energy company. It is the third-largest U.S. integrated energy company,

based on market capitalization, as well as proved reserves and production of oil and natural gas, and the largest refiner

in the United States.

Responsibilities:

• Designed / developed Crystal reports from a number of different data sources with a

number of formats including PDF, spreadsheet, or graphic using Crystal Report XI

• Developed Standard, Summary, Cross Tabs, SQL, grouping, sub reports, summary detail

reports, linking sub reports, Custom Formatting Techniques in Crystal Reports

Environment.

• Developed new reports using stored procedures, enhanced the existing reports for

performance and data accuracy.

• Developed reports in Crystal XI with Oracle, SQL Server, Stored procedures, views,

customized SQL, Universe.

• Coding and Design of User Interface, Business Logic, Integration Design Reports and

Queries.

• Worked with the business unit to define, develop prototypes for SAP BW reporting.

• Modified BW queries in the Crystal reports using BW query designer with Crystal XI R2

professional tool.

• Experienced in working with Business Explorer (BEx) and publishing the reports on web

using Web

Reporting tools.

• Extensively work on Query Designer and Web application designer to create Queries for

financial reports, budget and delivery analysis using Restricted Key Figures, Calculated

Key Figures, Variables, filters and exceptions.

• Developed queries from SAP Infocube using Bex Query Designer and applying filters,

free characteristics for slice and dice techniques.

• Developed reports from SAP Infocube by using BEx Analyzer, applied filters, variables,

parameters/prompts.

• Worked on transports of BW queries, objects from Development, Test and Production

Environments.

• Responsible for developing test cases, business validation rules for verification and

validation of data quality.

• Contributed in loading data from various data sources like Oracle, SQL Server, SAP R/3,

Fixed Width and Delimited Flat Files, MS Access & XML Files.

• Experience in building Dashboards using SAP Netweaver BW connection to create

metrics, score cards, rules, alerts, goals and insightful analytics using Xcelsius.

• Strong Knowledge in SAP BW, BI

Environment: Business Objects XI R3.1 (Designer, Desk I, Web I, Import Wizard, Publishing Wizard), Business

Objects XI R2, Xcelsius 2008, SQL Server 2000/2005, Oracle 10g/9i, PL/SQL, Window 2003 Server/XP, SAP BW

3.x, SAP BI 7.x,

Onpoint Health Data, Portland, ME

Senior Business Objects Developer/Administrator February ’11 to April '11

Onpoint Health Data provides a wide range of client services, including designing and executing analysis using large,

complex healthcare databases. Business Intelligence Concept of proof project is intended to develop a customer data

warehouse using a small dataset to analyze inpatient and outpatient hospital utilization based on demographics, health

status, payments, and cost, in support of improved decision making across the organizations and development of

reports for the management.

Responsibilities:

• Worked with the Business analysts, end users, Data Modelers and the DBA for

requirements gathering, business analysis, and testing, project coordination.

• Database structure, analysis of business rules/logic and design in coordination with

DBA’s.

• Design and Recommend changes to Data warehouse design like Star and Snow Flake

schema.

• Created reports using Oracle Databases and Personal Data File Providers.

• Worked with the Oracle DBA to improve the performance of SQL queries.

• Designed and developed Universes by using Business Objects Designer 3.1.

• Optimized the universe developing time and SQL Tuning to increase the query

performance.

• Defined Customized Hierarchies in Universe level.

• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the

Integrity of the Universes.

• Resolved table-linking problems like Chasm traps and Fan traps using Aliases and

Contexts.

• Created Dynamic Filters and Dynamic Conditions in universe level as per Business rules.

• Created several Classes, Objects, Conditions, and Measure objects.

• Used Calculation contexts, Variables, Drill down, Slice and Dice, Breaks, Sections,

Ranks and Alerts in the creation of reports.

• Created Drill-Through Reports to provide users with more detailed information and query

linking.

• Worked with the new features in XI 3.1 like Optional prompts, Else if functions.

• Created complex reports using the multiple data providers and synchronized the data

providers by linking the common objects to create the common report.

• Migrated existing Crystal reports to Webi.

• Installed and configured Business Objects Edge 3.1 on Red Hat Linux environment.

Installed client tools on Windows XP.

• Install, Maintain and Trouble shoot the Business Objects Enterprise Servers.

• Configure Business Objects 3.1 to work in Firewalls, Enable the port(s) needed like 6400,

6401 etc for Business Objects 3.1.

• Created user accounts, groups, applied complex security for each group on Central

Management Console(CMC).

• Configured third party authentications like Windows Active Directory, LDAP and

Enterprise.

• Created Dashboards in Xcelsius using Excel as Data providers.

• Mentoring/trained business users using Designer and create adhoc webi reports using

Infoview.

Environment: Business Objects Edge 3.1 (Designer, Web I, Webi Rich Client), Crystal Professional XI R2, Xcelsius

2008, Oracle 11g/10g, PL/SQL, Windows XP, Tomcat Web server, Linux.

TD Bank North, Falmouth, ME September ’10 to January ‘11

Business Intelligence Consultant

The need to enhance the Management Information Systems available to support the needs of the Bank’s business

processes (Automated Clearing House (ACH) process, Risk Management, Credit Risk). Provide robust business MIS

reporting solutions to Management. This project was to develop score cards, dashboards to enable executives get a

bird’s eye view of the business performance.

Responsibilities:

• Involved in defining the scope and defining business rules of the project. Also involved in

gathering business requirements, documented them textually or within models.

• Interview business owners and external vendors to understand and document expected

outcomes of sessions.

• Increase management’s access to day-to-day and summary level information to assist in

the evaluation and understanding of the risk and opportunities within the business.

• Assist in current or potential application users in identifying and describing problems or

opportunities.

• Worked closely with the business to clarify goals and facilitated the discovery and

prioritization of business requirements, including requirement risks.

• Heavily interacted with the Business Users to get a better understanding of client business

processes and gathered Business Requirements.

• Business Requirements are analyzed according to System specifications and to evolve a

measurable Plan for the complete group.

• Conduct workflow, process diagram and GAP analysis to derive requirements for existing

systems enhancements.

• Organized many informal Sessions to widen an architectural solution that the application

meets the business requirements, resolve open issues, and change requests.

• Worked closely with the project managers to monitor progress, and the deliverables for

the project.

Environment: Crystal Professional XI R2,Clarity Systems, SQL Server 2000/2005, Oracle 10g/9i, PL/SQL, Window

2003 Server/XP

Human Services Agency, Redwood City, CA July ’08 to July ‘10

Business Objects Developer

Involved in designing, administering and migration of Business Objects from XI R2 to XI R3; Worked closely with the

DBA, architect in migration from XIR2/R3. Universe(s), reports were developed using XIR2/R3.

Responsibilities:

• Involved in requirements gathering session with the business for reporting requirements

and Business logics.

• Architect, upgrade and set-up the existing datacenter Business Objects-BO XI production

Platform/environment and migrate the BO applications from XIR2 to XIR3.

• Involved in planning and migrating the reporting application from XI R2 to 3.1.

• Troubleshoot issues with reports on the crystal enterprise environments ( Development,

UAT, Test and Production )

• Configured E-mail functionality (Outbound SMTP Relay) into the XI R3.1 Application

and users will have the ability to send documents using E-mail and to send the output of

the reports in PDF, excel or webi documents or as an link.

• Supported multiple Business Objects environments ( BO6.5, BOXIR2, BOXIR3.1)

• Applied latest patches, service packs on test and production environments under change

management process by sending communication outages to users.

• Created user accounts, groups, applied complex security at the CMC level.

• Configured FTP on Development and Production XIR3 servers to send report output to a

shared network drive as pdf or excel format.

• Debug issues which resulted from Migration. Provide support in improvement and

maintenance of the Reports and Universes.

• Created / Modified Universes, Reports from the underlying Databases for business

modules.

• Created derived tables at the Universe level to reduce the complexity of the Universes.

• Involved in testing the migrated universes and reports and fixing the issues

• Developed Complex Reports that involved multiple data providers, Master/Detail charts,

cross tab, bar charts, pie charts, complex variables and calculation contexts.

• Created Prompts, Conditions and Filters to improve the report generation. Used Alerts to

improve the readability of the report.

• Extensively used Calculation contexts, Variables, Drill down, Slice and Dice, Breaks,

Sections, Ranks, Alerts and synchronized the data using Merge Dimensions in the

creation of reports.

• Created Drill-Through Reports to provide users with more detailed information and query

linking.

• Preparing and running SQL scripts on TOAD for Data Analysis and tracking errors.

• Customized the user interface to meet the needs of end users with Business Objects SDK

with VBA

• Developed dynamic and static Dashboards in Xcelsius 2008, Live Office and Excel Data,

for various Business groups.

• Coordinating with the team for quality data and analysis

• Assisted in implemented workflows, scripts, data flows, transformations in Data Services.

• Assist with user testing of systems, developing and maintaining quality procedures, and

ensure that appropriate documentation is in place.

• Responsible for all project documentations.

• Developed test plans for data accuracy, analysis and load validation.

• Responsible for knowledge transfer to end-users and trained them on various

functionality using Infoview and Designer.

• Business Objects/Crystal Enterprise, and supported the users with their issues / problems.

Environment: Business Objects XI R3.1 (Designer, Desk I, Web I, Import Wizard, Publishing Wizard), Business

Objects XI R2, WEBI SDK Xcelsius 2008, Business Objects 6.5 (Supervisor, Designer, Reporter),SQL Server

2000/2005, Oracle 10g/9i, PL/SQL, Window 2003 Server/XP

San Mateo Health Department, Redwood City, CA July ’06 to June ‘08

Business Objects Developer/Admin

Involved in designing and integrating three different source systems into the Health Client Data Store for the Health

Department in San Mateo County, using Business objects as front end and Oracle as back end. Collaborated closely

with client managers, architects, DBA's and Business users. Reports were created using the Reporting Tool Business

Objects.

Responsibilities:

• Involved in requirements gathering from the business users to build the reporting

application.

• Installed and configured Business Objects XI R2 on Development, Test and Production

Environments.

• Enabled/Disabled different servers in Central Configuration Manager and Central

Management Console.

• Created users and groups and applied row level and objects level securities using Central

Management Console.

• Installed and configured Business Objects XI R2 using Tomcat and Apache as

Application and Web Servers.

• Applying latest patches, service packs onto the testing and production environments

under change management process by sending communication outages to users.

• Worked with System Administrators to troubleshoot the Business Objects Services after

the application patches have been applied.

• Managed and Configured Servers (File Repository Server, Report Application Server,

Web Intelligence Server, Destination Job Server, Program Job Server, Event Server)

• Worked with End-To-End implementation with Data warehousing team and Strong

understanding of Data warehouse concepts Star Schema, Snowflake Schema and Multi-

Dimensional Models for query and analysis requirements.

• Experience in building Universes, retrieving data using Universes, Personal data files,

Stored procedures, Free hand SQL methods and creating complex ad-hoc Reports using

the Business Objects and Web Intelligence modules.

• Created universes, classes and objects by retrieving the data from various data sources

and defining the necessary connections.

• Resolved table-linking problems like Chasm traps and Fan traps using Aliases and

Contexts.

• Created several Classes, Objects, Conditions, and Measure objects

• Involved in migration and deployment of the universes and reports across multiple

domains.

• Creating Full client and WebI reports.

• Business Objects Enterprise authentication, scheduling, publication and automation of

reports.

• Responsible for creating training documentation.

• Coordinated and participated in the successful implementation of the application and

performed validation in production environment prior to the users, to ensure the validity

of code, tables, views, reports and user interface.

• Documenting the production and development environment changes made on the web

servers.

• Used the Import wizard to import existing user accounts, groups, categories, WebI

documents, universes, connections and universe restrictions to BO XI environment.

• Created reports prototypes using Web Intelligence XI for user presentation.

• Trained the Business Users in report creation and also new features of Business Objects

XI R2.

Environment: Business Objects XI R2 (CMC, Designer, Desk I, Web I, Import Wizard, Publishing Wizard),, Crystal

Professional XI R2 (Supervisor, Designer, Reporter), Business Objects XI R3.1, Oracle 10g/9i, Tomcat 4.0, Apache

server 1.3, PL/SQL, Window 2003 Server/XP

Walgreen’s, Deerfield, IL Sept ’05 to June ‘06

Business Objects Developer

Employee Repository Report Management

The projects scope is to develop reports for Employee Repository for their Human Resources Department. The project

involved developing universes, building reports and co-ordinate with off shore team to ensure report synchronization.

Interacting with end Users, to know their requirements and develop/modify Universe and Reports accordingly.

Collaborated closely with client managers, architects, DBA's and business users. Helping in maintenance work related

to reports.

Responsibilities:

• Interacting with end users, to know their requirements and develop/modify Universe and

Reports accordingly.

• Collaborated closely with client managers, architects, DBA's and business users.

• Involved in the creation of Universes, Classes, Objects, and Hierarchies for

Multidimensional Analysis for Production, Technical, and Human Resource departments

of the company.

• Exported the universes to the Repository making resources available to the users.

• Developed various Table/ Cross tab reports, Developed Adhoc Reports on some universe.

• Worked on Crystal Canned reports with multiple sections.

• Build complex reports with free hand SQL, VBA, personal data providers with multiple

data providers.

• Used features like ranking, alerters, user objects, UNION, INTERSECT, MINUS query

operations.

• Declared complex formulae and local variables at the report level.

• Designed complex reports based on discussions with user groups and created various

objects using built-in @functions (like @prompt, @select, @where, @aggregate),

complex SQL queries and joins.

• Converted reports to external formats like PDF, txt, .CSV for further analysis and

emailing as attachments.

• Involved in testing the database for the queries that are generated and handled the

performance issues effectively.

• Responsible for troubleshoot/debug existing report/template objects and universes.

Environment: Business Objects 6.5.1(Supervisor, Designer, Reporter), Web Intelligence 6.x, ZABO, Broad Cast Agent,

Oracle 8i/9i, Teradata,MS SQL Server 2000, PL/SQL and Windows 2000, UNIX.

Cardinal Health, Dublin, OH Jan '04 to Sept ‘05

Business Objects Developer

Pharmaceutical Distribution Report Management

The project was to create/maintain universes and to generate reports from the Pharmaceutical Distribution department

Data warehousing databases. The project was to develop a Reporting system to generate annual reports and to monitor

the customer's aging profile, customer transaction processing. Data is loaded to a central database from existing

operational databases.

Responsibilities:

• Involved in collecting the user requirements.

• Designed new universe and maintained existing universe according to the user

requirements.

• Created and managed users/groups and assigned privileges using supervisor module.

• Created Multiple Universes in Designer using different databases like SQL Server, MS

Access and DB2.

• Exported the universes to the Repository making resources available to the corporate

users.

• Improved system performance in data access by fine-tuning SQL statements and joins.

• Created user specific classes and objects and maintained object level security at the

designer level.

• Developed complex SQL code to enable user queries to the database for data access,

using triggers.

• Involved in full life cycle of Business Objects reporting applications.

• Created Master-Detailed reports using Drill down/up functionality for the Decision

Support System regarding the company’s products.

• Created complex prompts and conditions in the Universe using @Functions and CASE

statements.

• Created complex reports using various functionalities as prompts, slice and dice, drill

down, break, formulae, calculations, cross tab and master details.

• Created Webi Reports and deployed them using Info View.

• Trouble shooting and tuning of the Existing Reports.

Environment: Business Objects 5.1.5 (BO Reporter, Designer, Broadcast Agent, Supervisor, Web Intelligence 2.6, Info

View), MS SQL Server, DB2 UDB, Windows 2000.

Contact this candidate