Sql Server Data Warehouse
Resume:
FAYE HOSSEINY
Irvine, CA
*******@*****.***
PROFESSIONAL SUMMARY
Information Technology professional with more than 12 years experience in
Reporting, Business Analyst and Application Development with a strong
Finance background.
TECHNICAL SUMMARY
. Reporting- Crystal Report/Enterprise 11, Web Intelligence, MS Access
. Databases - Oracle, SQL Server, PeopleSoft, Hyperion, Essbase
. Office Tools - MS Office (Access, Excel, PowerPoint, Word)
. Applications - Query Analyzer, Business Objects XI, Universe, Microsoft
Visual Studio2005 version8, Toad, Safesource, Peregrine, SAP R/3, CDO,.
. Industries: Finance, Accounting, Sales, Marketing, Inventory, Desktop
Support, Production Services, and Accounts Payable.
. Key Terms\experience- Strong Data Warehouse and relational database
concept, Stored Procedure, MS Sql Server T-SQL, Requirements gathering,
Crystal Reports, MS Excel, Data queries, Report design, Testing, and User
training, Access database, Webi, Universe.
PROFESSIONAL EXPERIENCE
Business Objects\Report Developer (Contract) 03/2010- 06/2010
Newport Consulting Solutions Inc., Irvine CA.
. Responsible for gathering requirements, creating specs, testing and
writing reports.
. Maintained universe for creating Ad Hoc reports.
. Created advanced Crystal reports, Webi using Universe,
. Created SQL queries using Add command.
. Created reports using Query Analyzer.
Report Developer (Contract) 09/2007- 03/2009
Deutsche Bank, Santa Ana CA.
. Responsible for gathering requirements from users, creating specs,
testing and writing Crystal Reports (version 11).
. Responsible for reporting environment including testing, QA and fixing
Crystal reports supporting the London Data Warehouse.
. Created advanced crystal reports using sub-reports, formulas, conditional
formatting, graphs and grouping.
. Responsible for reporting on Collateralized Debt Obligation and other
Asset Backed Securities.
. Developed and implemented the usage of stored procedures used by the
reports.
. Responsible for translating complex Indentures to create Crystal reports
of their requirements.
. Responsible for maintenance of over 1000 Crystal reports.
Business Analyst\Crystal\ SQL Developer (Contract) 05/2007 - 08/2007
Pacific Life, Newport Beach CA.
. Responsible for gathering requirements, creating specs, testing and
writing reports.
. As being part of IT worked with the development teams and Data Warehouse
to provide data analysis and reporting.
. Created stored procedures using SQL Server Management Studio 2005.
. All Crystal reports and sub reports created off of stored procedures.
. Used Microsoft Visual Studio 2005 version 8 to keep track of tasks, open
risks, bugs, changes and checking-in and checking- out queries, reports
and documents.
Business Analyst\Crystal Report Developer (Contract)
04/2005 - 03/2007
New Century Mortgage Corporation, Irvine, CA
Projects - Marketing and Production Services:
. Responsible for gathering requirements, creating specs, testing and
writing reports (version 10).
. Responsible for working with users for gathering requirements.
. Developed complex reports for executives and functional departments.
. As part of development teams worked directly with data Warehouse group to
provide data analysis and reporting.
. Created Crystal report off SQL server and Oracle databases.
. Created reports directly off SQL queries and added (nolock) in to the
statement.
. Created SQL queries using Add command.
. Created Stored Procedures using Query Analyzer, toad and Safesource.
. Created advanced reports using sub reports, parameters, selection
criteria, formulas, conditional formatting, SQL query, running totals,
and On-demand grouping.
. Created complex reports using advanced formulas to calculate time
differences while excluding weekends.
. Created Audit reports to compare present to history.
. Responsible for Installing Crystal Report 11 and creating ODBC connection
to SQL Server.
. Responsible for updating Oracle tnsnames Ora file.
. Converted reports from oracle database to sql database.
Senior Crystal & Financial Report Developer (Contract)
Toyota Financial Services, Torrance, CA
08/2002 - 02/2005
Toyota Motor Sales, USA, Torrance, CA
10/2000 - 07/2001
. Responsible for gathering requirements, creating specs, testing and
writing reports.
. Created Crystal report off of Essbase, Peregrine, Excel, MS office and
SQL Server using ODBC connectivity. In order to automate the Financial
reports, converted all financial reports (budgeting, forecasting) from
excel to Crystal reports.
. Created advanced reports using sub reports, parameters, selection
criteria, formulas, conditional formatting, SQL query, running totals,
graphs and grouping.
. Created financial reports for high-level Management.
. Created PeopleSoft queries.
. Created and Maintain Access databases and reports off these databases.
. Responsible for setting up Info Desktop 7 to ensure accuracy and timely
distribution of reports.
. Responsible for administrating and scheduling reports using Crystal
Enterprise 9 and 10.
. Responsible for distributing reports Via Crystal web.
Merisel, Inc., El Segundo, CA
09/1994 - 10/2000
Merisel was a Fortune 500 North American distributor of technology
products, use to generating sales of $5.2 billion in 1999.
Data Warehouse Team- 1999-2000
Programmer II (Full Time)
. Responsible for application development and reporting environment
administration tasks supporting the North American Data Warehouse.
Technical environment includes Oracle/Unix data warehouse/ data marts
sourced from SAP R/3 application environments. MicroStrategy OLAP and
Seagate Crystal Info/Reports are deployed as the decision support and end
user access reporting solutions, including web-based data analysis and
reporting for over 300 users.
. Seagate Crystal Reporting and Info Administration:
. Created advanced reports using subreports, parameters, selection
criteria, formulas, conditional formatting, running totals, graphs and
grouping.
. Worked with the development teams, product management teams, executive
level, to provide data analysis and reporting.
. Developed over 25 Infoviews providing a standard 'semantic layer' to
support end-user data warehouse report development
. Provided technical leadership for Seagate Crystal Reporting and Info
environment for report development and system administration.
. Provided quick response and resolution to production issues.
. Resolved power user's issues with Crystal report development.
. Provided training and support for over 35 report developers in the
functional departments.
. Developed complex reports for executives and functional departments.
. Participated as Application Development lead for Crystal 7 upgrade.
. Responsible for Crystal Info administration.
. Assisted lead DBA with database script development and maintenance.
. Developed validation scripts to ensure referential integrity of data
loads.
. Prepared production change control documentation.
. Developed structure and data to support application development.
. Utilized Oracle's export and import utilities to extract and load sample
data.
. Utilized Oracle's sqlloader to load into development and test
environments.
. Created control files to be used by sqlloader utility.
. Developed pl/sql scripts to manage growth of historical data
. Created UNIX control files.
Inventory Information Analyst, Application Developer- Finance Department
Sr. Analyst 1994-1999 (Full Time)
. Responsible for development, enhancement, and maintenance of Inventory
accounting system to facilitate Forecasting, Inventory Accounting,
Reporting of daily Inventory, and various aging reports. Participated in
gathering of application requirement, design, development, as well as
testing, documentation, and implementation.
. Designed and developed Automatic daily process of creating reports for
the remote user.
. Designed and maintained various forms for accounting department.
. Designed and developed a new database to age our Inventory level of 400
million dollars at sku level.
. Assisted management with reporting and variance analysis.
. Designed and maintained various forms for accounting department.
. Tool Utilizes: Crystal, MS Access, Paradox, Excel, MicroStrategy, Object
Pal Language (OPL), SAP, Cambar.
EDUCATION
B.S. in Computer Science - Franklin University, Columbus Ohio.
Contact this candidate