Professional Focus:

Passionate about building practical Business Intelligence solutions for Oracle and MS SQL Server data platforms to businesses for all industries.

Professional Training/Skills/Tools:

• Project Management Certification Training
• SQL Server Integration Services SSIS
• SQL Server Reporting Services SSRS
• Qlickview Dashboard Development
• Microsoft SQL Server
• Microsoft SSIS SQL Server Integration Services
• Microsoft SSRS SQL Server Reporting Services
• ORACLE Versions 7i, 8i, 9iAS, 10g, 11i financials
• ORACLE Developer Forms, Reports 4.5/6i
• Oracle Warehouse Builder ETL tool OWB
• Oracle Portal training
• T - SQL/PL-SQL Programming/interface development
• Cognos 10/8 BI Portal Development Administration
• Cognos 8 BI Server Maintenance Application development
• Cognos Series7 BI Server Maintenance Application development
• Cognos Certified Professional
• Cognos Impromptu Administrator 4,5, 6 7 Series
• Cognos Power Play Client/Web 7.0 OLAP
• Clear Case, Clear Quest version control application
• MS Visual Source Safe version control application
• TOAD Quest Software
• SQL Navigator Quest Software
• VB.Net 6.0 exposure working knowledge
• UNIX Sun for Solaris
• DB2 Version 5-7 UDB Query
• Citrix MetaFrame/ICA Client working knowledge
• Embarcadero 'DB Artisan's SQL Management tool
• ERwin data modeling tool.
• HTML exposure working knowledge

Professional Experience:

Confidential

Senior Business Intelligence Analyst

• Senior Business Analyst to Business Intelligence Group
• Project Management and resource planning
• Develop scope for production projects utilizing both SQL Server and Oracle database platforms.
• Work closely with Database Developers and BI Solutions Architects on company-wide/client-based initiatives while incorporating Kimball-based methodology data modeling of proposed data warehousing projects
• Quality Assurance validation and test acceptance within continental United States
• Manage off-shore QA validation initiatives with India resources

Confidential

Senior Enterprise Business Intelligence Analyst/Architect

• Intercontinental/Continental consulting services to external client sites for development and support
• Work with Data Architecture team in the United Kingdom on company-wide initiatives.
• Develop scope for production projects utilizing both SQL Server and Oracle database platforms.
• Qlikview Dashboard Development for various external client-based projects United States, Canada and United Kingdom
• Recommend system modifications and give development detail on the best way to achieve the goal of tasks in scope directly to Divisional Vice President and Director.
• Prepare recommendations for production roll-out/implementation
• SSIS/DTS Automation for all projects

Confidential

Senior Enterprise Business Intelligence Business Analyst

• Develop scope for production projects utilizing Neteeza and Oracle database platforms.
• Served as Senior Business Analyst to help manage project lifecycle working with upper-management and mid-level management from other groups within the XO organization for a team of 12 individuals across the United States in other XO locations and onsite
• Project Management Keeping the tasks aligned with the responsible party and assuring the timeline of scope remains current for upper-management and field engineers.
• Create and deploy Web/OLAP-based Cognos ReportNet 8.4 reports
• Recommend system modifications and give development detail on the best way to achieve the goal of tasks in scope to Project Managers, Upper-Management and Technical Leads
• Allocate solutions to the problems encountered during the break session.
• Prepare recommendation for production roll-out/implementation
• Quality Assurance testing: Document and execute project unit test plans orchestrated with other team Informatica developers to prove implementation scenarios and results of data migration.
• Pre-user testing of data extracted from external source files as well as TBS database
• Prepare technical support recommendation for post-project implementation and web-deployment.

Confidential

Senior Enterprise Business Intelligence Developer Business Analyst

• Project Management Maintain the pace of project development and deliver task report to upper management
• Facilitate status conference call for team of 10 individuals across the United States in other XO locations and onsite.
• Served as Business Analyst to initiate scheduled projects and deliver product to end-user base working with other systems and server administrator groups within XO.
• Lead project planning and development of data mart for terabyte-sized extracts of company data with 7 other developers.
• Document SSIS package process flows for all client-based projects in a dual platform environment
• Create and modify MS SQL Server 2005 procedures, user-defined functions/triggers, views and table structures
• Develop SQL code for both MS SQL Server 2005 and Oracle 10g within all development, testing and production environments
• Optimize database environments - extracting and process data from TBS, Single View and Bill Track Pro BTP data structures.
• Quality Assurance testing: Document and execute project unit test plans orchestrated with other team SQL developers to prove implementation scenarios and results of data migration.
• Migrate system data from Oracle 10g data platform to MS SQL Server 2005 database via SSIS packages
• Import and Export data via MS SQL Server 2005 developer interface
• Create web-base Microsoft Reporting Services and display results via web-enabled Report Manager to end-user
• Orchestrate MS SQL Server data environment cleanup with SQL DBA's between multiple database instances
• Analyze information to determine, recommend and plan installation of a new development or modification of an existing systems/development

Confidential

Senior SQL Server Database Developer

• Develop back-end MS SQL Server database platform for external venture known as

Confidential

Senior Enterprise Business Intelligence Developer

• Responsible for the planning stages for MS SQL Server 2000/2005 data warehouse projects logical layer and code development for the physical layer
• Project lead for implementation of various projects depending on clients, spanning between multiple departments and user groups.
• Mentor junior-level developer and hired consultants with both the Logical and Physical layers of both MS SQL Server 2000/2005 databases
• Manage and maintain Cognos 7BI/8 Server Administration abroad two separate single-server environments company-wide working with Network and Desktop Services Group within Moroch.
• Predict project development lifecycle for new reporting initiatives and revise time management expenses for maintaining pre-existing reporting projects.
• Responsible for implementing application budget for hardware and structuring budget for application support and renewals.
• Set indexes on database tables for query sensibility and better development flow
• Assisted in the hiring process of consultants and new talent being brought to the team
• Create MS SQL Server 2000 and 2005 PL/SQL procedures and scripts for load process to test, development and production areas
• Automate upload processes for various environments by creating and utilizing MS SQL Server 2000 DTS packages/SSIS for MS SQL Server 2008
• Create Cognos ReportNet, Impromptu Web Reports and Power Play Web cubes for OLAP modeling drill-down reports and be responsible for deployment to all environments test, development, and production
• Develop and maintain company reports utilizing Microsoft Reporting Services
• Cognos 8 Framework Manager Modeling for multiple client data warehouse schemas
• Customizing/re-facing Cognos Connection interface pages and specialty modules
• Cognos server installation and configuration Series 7 and Cognos 8
• Extensive experience developing dimensional models and data warehouse/marts
• Hands on understanding of dimensional modeling and data analysis data profiling .
• Create mainstream documentation for all projects once the task was moved to production

Confidential

Senior Oracle Database Engineer/Cognos Developer Administrator

• Project lead of 4-person development team for implementation of accounting portal containing sensitive company-income data
• Managed the implementation, migration and maintenance of Cognos BI Series 7 Web single-server environment working with
• Quality Assurance testing: work with QA specialist to test the Accounting and Oracle Financials upload and migration of data to the Test, Development and Production databases.
• Create custom queries in Oracle 9/11i Financials environment, SQL Server as well as DB2 Version 5-7 UDB for external offices.
• Plan for data warehouse development logical layer and code development for the physical layer
• Develop Oracle dimensional data warehouse with fact tables, aggregate tables for all lines of business
• Create Oracle data warehouse structures utilizing tools such as Embarcadero's-'DB Artisan's' data management tool, Oracle Warehouse Builder ETL tool and ERD Entity Relationship Diagram diagrams using ERwin
• Data migration utilizing the TOAD application from flat file to Oracle database platform
• Oracle, SQL Server DB2 for upper-management reporting needs
• Build OLAP Models for Cognos BI/Series 7 suite for Power Play Reports and Power Play Transformer Administrator of all Cognos web applications
• Create Impromptu reports and Power Play Web cubes for drill-down reports and be responsible for roll-out to all environments test, development, and production
• Teach courses for Cognos Upfront PowerPlay Web Application to all users, company-wide Build Oracle Reports and Forms for production use and implement connection address for Web deployment
• PL/SQL procedures and scripts for load process to test, development and production areas
• Analyze database performance and send recommendation for tuning
• Coordinator of all web-related/interactive projects and system access permissions for web-based applications and applications to be implemented on Citrix Server environment

Confidential

Mid-Level ORACLE Developer/Cognos Developer Administrator:

Network-driven Responsibility:

• Managed project to for the implementation of ORACLE-based utilities onto LAN-driven, Citrix MetaFrame server, for accessibility to 30 remote clients working with team of 5 Oracle DBA's as well as 2 Network Administrators across the United States

Daily Tasks/Responsibility:

• Cognos Impromptu Administrator and Report Developer
• Quality Assurance testing: work with QA specialist to test the payroll/HR upload and migration of data to the Test, Development and Production databases.
• Work with the ORACLE Financials Group for creating conversion specifications and coding changes, in order to write the General Ledger G/L reports and custom objects for company clients.
• Assisted in the migration of Human Resources data to Cyborg's HR System as well as Cyborg's Payroll system
• ORACLE Developer-Programmer/Analyst for Human Resources, Benefits, and Payroll departments, company-wide
• Create/Modify- ORACLE tables, views, and stored-procedures for Cyborg HR/Payroll users, both internal and external, utilizing SQL Navigator PL/SQL editor.
• Provide on-going system support for ORACLE, Cyborg, and Impromptu applications for internal and external users
• Create Payroll and Human Resource reports, menus, and screens using utilities such as ORACLE Forms, ORACLE Reports, ORACLE Discoverer, SQL Navigator PL/SQL Editor and Impromptu Administrator.
• Data-modeling of Cyborg System non-relational objects for customized conversion to fully relational objects for easier and more sufficient reporting for both developer and end-user communities.
• Assist in the procedures of ORACLE Data Migration to the Cyborg Human Resource and Payroll System using the SQL Loader program
• Data-Warehouse design of Cyborg System objects for ORACLE versions 7 and 8i development, test, and production environments
• Create/Modify- Unix scripts and run batch jobs for company pay run processes month-end, quarter-end, bi-weekly pay periods
• Work with ORACLE DBA's to resolve database issues within the company's testing, development, and production environments

Tool/Utility Implementation and Administration:

• Administer the Payroll check printing procedures through WestCorp and deliver on-going system support for internal server and client sites.
• Technical writer for internal and external users of processes and procedures
• Technical training of Impromptu software to internal and external users.
• Writing technical and function documentation for Payroll projects, along with executing the development and Quality Assurance Testing QAT work for custom reports, comparing them to the Cyborg HR/Payroll system.

Confidential

Senior Helpdesk Lead

Helpdesk Team Lead of 7 helpdesk support specialist

• Implementation of the McAfee helpdesk utility for internal users onto Windows NT network
• Training for Individual technicians working on the helpdesk team

Confidential

Junior Network Administrator

• Junior Network Administrator for Windows NT Local Area Network LAN, supporting approximately 250 employees
• Windows '95, '98 Beta, and NT 4.0 workstation system configurations
• Install and configure peripherals for customer sites as needed
• Administer accounts for internal users to receive access to specific network resources
• Analyze and answer departmental/company personnel with internal network questions, with resolutions

Confidential

• Telephone Technical Support for the IBM System/34,36,
• AS/400, and Lattice RPG II III
• RPG II III program development and modifications
• Technical writing for IBM PC, System/36 and AS/400 software