SUMMARY:

• Data Architect with over ten (11) years of progressive experience in information technology and five (5) years as a lead and manager
• Expertise with decision support systems and data warehousing concepts: exposure to data mining methodologies and tools. Experienced in relational and dimensional data modeling, and logical and physical database design
• Experienced in physical/logical database implementation, indexing, partitioning and performance tuning for development, test and production environments
• Expertise in maintaining data quality, data organization and metadata
• Experience creating PL/SQL Packages, Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle databases
• Experienced with various ETL tools like Data Integrator/Data Services, SSIS, Informatica and Datastage
• Developed and implemented codes in high volume data environments with multiple data sources
• Expertise in building universe(s) that access SAP BW. Expertise with Bex report designer
• Migrated repositories, universes, reports and users from lower versions to the higher versions
• Experience with Business Objects 6.5/ XIR2/ XIR3/4.x installation and configuration of server products, such as Web intelligence and application server such as TOMCAT and Web servers like Apache and IIS, and Business Objects implementations in a shared environment
• Proficient in all phases of the software development lifecycle, and with Data Cleansing, Data Conversion, Performance Tuning, Unit Testing, System Testing, User Acceptance Testing and Performance tuning
• Expertise in report/universe moves of UAT to development and production servers
• Converted desktop intelligence to Web intelligence documents using report conversion tools
• Expertise in developing dashboards using Xcelsius from Live Office

TECHNICAL SKILLS:

Languages: C, C++, Core Java, SQL, PL/SQL

Databases: Oracle 11g/10g/9i, SQL Server 2000/2005/2008, Teradata V2 R6.0/R5.0, DB2, MySQL

Data Modeling Tools: ER Studio, Microsoft Visio, ERWIN, Oracle Designer ERP SAP R/3

ETL Tools: Business Objects Data Integrator/Data Services, Informatica, Microsoft SQL Server Integration Services

OLAP/Reporting Tools: SAP BW, Business Objects XI4.x/R3.1/R2, 6.5/6.0/5.x, Crystal Reports XI/10/9, Crystal Xcelsius, Central Management Console (CMC), Central Configuration Manager (CCM), Import Wizard, Performance Management, Desktop Intelligence, Web Intelligence, Microsoft SQL Server Reporting Services, Tableau, Power BI

Operating Systems: Windows 98/2000/2003/ XP, Windows NT 4.0, Linux Application Servers IIS 7.0 and Apache Tomcat 6.0/5.5/4/0

PROFESSIONAL EXPERIENCE:

Data Architect

Confidential, Alpharetta, GA

Responsibilities:

• As senior data architect, I set up the architecture capability in alignment with enterprise business requirements, defined enterprise level - architecture roadmap, data management strategy for processes, target state architecture, defined and established the architecture governance practices and data standards
• Responsible for modeling and building enterprise data marts for different business reporting needs
• Responsible for analysis of massive and highly complex data sets, performing ad-hoc analysis and data manipulation for data integration
• Developed ETL Jobs with high volumes and multiple data sources
• Responsible for design and development of Universe(s) and Dashboards/Reports

Environment: Oracle, Business Objects Data Services

Data Architect

Confidential, Norcross, GA

• Responsible for implementation of SLDS (Statewide Longitudinal Data System) for the State of Rhode Island and State of Maine
• Designed and implemented early warning indicators for the State of Rhode Island
• Responsible for design and implementation of ADHOC tools so the users could view the results and compare against other classrooms, districts and statewide entities
• Responsible for building PARCC framework, dashboards for the State of Rhode Island
• Built public reporting framework and dashboards for the State of Rhode Island and the State of Maine
• Responsible for design and development of assessment factory (XML Manifest based) for the State of Rhode Island and several other district clients
• Developed ETL packages with high volume and multiple data sources
• Developed multiple dashboards associated with SLDS, early warning, PARCC, ADHOC and public reporting
• Responsible for obfuscating the data in the training environment so the users could be trained on the latest updates and applications

Environment: SQL Server, BO 4.1, Business Objects Data Services and Tableau

Data Architect

Confidential, Atlanta, GA

• Responsible for both the logical and physical implementations of SLDS (Statewide Longitudinal Data System)
• Responsible for integrating post-graduation results with SLDS to help facilitate prediction associated with the high school results
• Responsible for design and implementation of ADHOC tools so the users could view the results and compare against other classrooms, districts and statewide entities
• Responsible for design and implementation of TRL (Teacher Resource Library)
• Designed data model land extensible XML manifest architecture to support integration of any district-based assessment data into the SLDS
• Responsible for design and implementation of CCRPI (College and Career Ready Performance Index)
• Designed and implemented accountability applications
• Responsible for implementing security around SLDS
• Developed ETL packages with high volume and multiple data sources
• Developed multiple dashboards associated with SLDS, ADHOC, TRL, post-graduation and CCRPI
• Obfuscated the data in the training environment so the users could be trained on the latest updates and applications

Environment: SQL Server, Oracle, .NET, Business Objects 4.0/4.1, Business Objects Data Services

BI Consultant

Confidential, Denver, CO

• Responsible for both logical and physical implementation of the data model, Business Objects semantic layers and ETL workflows
• Worked on retro-fit existing projects to conform to new architectural standards
• Conducted quality reviews of projects
• Worked on developing functional specifications for specific data objects encompassing extraction and transformation
• Coordinated with the business users for specifying rules required to cleanse, standardize the existing legacy master data and to meet the universal standards using industry proven unique cleansing methodology
• Facilitated data extraction, transformation and loading from Source to the Target System using ETL tool Business Objects Data Services (BODS)
• Developed and implemented codes in high volume data environments with multiple data sources
• Responsible for debugging, troubleshooting and performance tuning of data flow
• Identified data quality issues and provided recommendations for improvements/resolution

Environment: Oracle, BO XIR3/XI4.0, Business Objects Data Services XI 4.0, Windows Server 2003, TOAD

BI Architect

Confidential, Tonopah, AZ

• Responsible for production and management of all data architecture objects related to the assigned projects including data models - both logical and physical implementation, Business Objects semantic layers and ETL workflows
• Conducted and gathered business requirements and metrics for a major KPI system developed in the Business Objects suite of products
• Gathered business requirements, performed data analysis, architected, designed and implemented ODS/Data Mart for Palo Verde operational and business intelligence reporting environment
• Developed additional standards and processes surrounding the BI data architecture
• Responsible for Business Objects development and deployment of data objects in support of Palo Verde data mart
• Developed and deployed data naming conventions and standards
• Worked with data extraction, transformation and loading from Source to the Target system using ETL tool Business Objects Data Integrator (BODI)
• Migrated universes, reports and users from BO XIR2 to BOXIR3
• Developed universes that access SAP BW
• Developed complex universes to support the migration of the existing MS access/excel reports to Business Objects
• Set up user groups and maintained user profiles across the organization in Business Objects.
• Implemented row level/column level security
• Set up a process for the migration of ETL jobs/universes/reports from one environment to the other (development test production)
• Migrated over 500 existing MS Access/Excel reports to Business Objects
• Set up an operational warehouse for Ad Hoc reporting
• Created complex Web intelligence reports with multiple data providers
• Created both static and dynamic dashboards using Crystal Xcelsius
• Implemented Java SDK to design and maintain the client desktops with specific functionalities
• Trained all of the power users on Business Objects for Ad Hoc reporting
• Created links to the Business Objects reports using Open Doc Syntax in the process of integrating with SharePoint 2007 for better visibility
• Implemented API functionality within the Crystal Reports to call reports from various Web applications
• Scheduled several KPI reports using a process account based on specific time, events and calendars and in various formats such as excel and PDF as a part of the morning package

Environment: SAP BW, BO XIR2/XIR3, Business Objects Data Integrator/Data Services XI, WEBI, Crystal reports XI, Live Office, Oracle 10g, DB2, SQL Server 2005/2008, Windows Server 2003, MS Access 2003/2007, MS Excel 2003/2007, SharePoint 2007, TOAD, DBArtisan

BO Lead Developer

Confidential, Radford, VA

• The main objective was to develop a finance tracking system. The project included developing financial reports that outlined the performance of the company over a particular period of time.

Environment: SAP BW, Business Objects Data Integrator XI, BO XIR2/XIR3, Crystal Reports 2008, Live Office, Oracle 10g, SQL, SQL Server 2005, Windows Server 2003

Business Objects Lead Developer

Confidential, Bloomfield, CT

• This project was based on a client server system, which contained customer information files (CIF) and their policies. The project focused on analyzing data regarding sales and highlighting of marketing trends to create reports for periodic, geographic and different product lines.

Environment: Informatica, Business Objects 6.5.1 (Supervisor, Designer, BO Reporter, InfoView), BO XIR2 (CMS, CMC, Designer, Desktop Intelligence, Web Intelligence), Import wizard, Report Conversion Tool, Broadcast Agent 6.5.1, Crystal Reports XI R2, Oracle 9i/10g, MS SQL Server 2000 and Windows 2003 Server