SHAPE OBJECTIVE:

• To obtain a Business Intelligence Systems Developer/Analyst position working with Business Units, Project Teams, Process Teams to ascertain initiatives relative to the improvement of Business Processes across the organization with a growing dynamic company offering potentials for technological enhancement and career advancement. SUMMARY: Business Intelligence Information Systems Development and Analysis experience working with a variety of Mainframe/Fourth Generation Languages and Relational Database Management Systems and n-tier architecture applications and a variety of platforms designing financial, sales and marketing ETL/OLAP utilizing Microsoft toolset technology for applications on various platforms in the Healthcare, Insurance, Telecommunications, Banking and Pharmaceutical industries. Excellent balance of business and technical knowledge, and outstanding analytical skills. Excellent verbal and written communication skills. SOFTWARE: Microsoft Windows/NT, Lotus Notes 4.6, Lotus SmartSuite, SQL Server 2005/2008, Banner, Qlikview, Agile, Microsoft CRM, BUSINESS OBJECTS, SSRS, SSIS, SSAS, Data Stage, DBMS-Focus, Oracle, Access 2000, ADO/DAO, ODBC, VM/CMS, TSO/ISPF, MVS/ESA, CICS, Unix, APO, DB2, SAP R/3, QMF, JCL Utilities, Cobol, HTML, Perl, Legacy, EDI, Erwin, Toad, FrontPage 2000, Endevor, Java, AutoSys, Tivoli, VBA, DTS, Visual-Basic 6.0, Active X, ASP.NET, Transact-SQL, Windows NT 4.0, Microsoft Project, ProClarity, Microsoft Visual FoxPro, Microsoft PowerPoint, Rational Clear Case, Quattro-Pro, Rumba, IBM 3270 Emulation, Sync Sort, Visio, Cold Fusion, Datacom, DDL, IMS, SQA, Crystal Reports, Xcelsius, Brio, LAN/WAN, PL/SQL, COGNOS, UML, XML, TERADATA, INFORMATICA, SIX SIGMA, WEBSPHERE, APACHE HARDWARE: IBM 370 Architecture, IBM 30XX, MVS/ESA, IBM 4341, IBM PC's Laptops Compatibles, UNIX Client Server Environment, Laser Jet Printers, IBM AS400, IBM 3090, OS/390, Novell, Client/Server, OS2, HP/UNIX, AIX, Business Control Machines PROFESSIONAL EXPERIENCE: Confidential BI Analyst As a consultant for The State of North Carolina reviewed clients' information needs and provided analytical reviews. Responsibilities include interpret business requirements and define technical alternatives, tools, and approach for defining business requirements. Performed desktop support duties for software upgrades. Developed dashboards in Qlikview for reporting analytics. Designed reporting for financial applications utilizing Banner software. Developed, test, implemented and documented the technical solutions to address the defined business requirements. Responsible for developing Oracle Financial modules for financial reporting. Participated in evaluating and analyzing utilities and tools offered by BI Applications/Tool Vendors. Provided second-tier support to the IS Support Center to assist in problem resolution as required. Utilized Business Objects SDK/Enterprise for application design. Utilized Crystal Xcelsius to create dashboards to reflect KPI's.
• Utilized Business Objects/Crystal Reports to develop extensive financial reports.
• Responsible for developing BI reports financial reports utilizing Crystal Reports. Responsible for administering Q A processes. Performed training to end users on applications. Environment: Windows NT, Unix, Oracle 11i, Oracle ERP Suite, SQL Server 2005/2008,Qlikview, Banner, PL/SQL, SSAS, SSRS, SSIS, MDX DB2, Cognos Series 7/8/10, Business Objects XI, Crystal Reports, Confidential BI Analyst Gathered business requirements for client World Trade Center Health Fund and translated those requirements into reporting solutions. Responsible for developing Oracle Financial modules for financial reporting. Designed Xcelsius Dashboards for financial reporting. Responsible for developing BI financial reports utilizing Crystal Reports. Developed MDX cubes utilizing MDX. Developed ETL processes of overnight data loads. Developed queries to analyze financial data. Environment: Windows NT, Unix, Oracle 11i, Oracle ERP Suite, SQL Server 2005/2008, PL/SQL, SSAS, SSRS, SSIS, MDX DB2, Cognos Series 7/8/10, Business Objects XI, Xcelsius, Crystal Reports, Confidential Systems Analyst Gathered business requirements for client Dell several business units. Utilized Business Objects SDK/Enterprise for application design. Utilized Crystal Xcelsius to create dashboards to reflect KPI's.
• Utilized Business Objects/Crystal Reports to develop extensive financial reports.

Environment: Windows NT, UNIX, Oracle, Business Objects, Crystal Reports

Confidential

Senior Systems Developer

• As a consultant at Arlington Pharmaceutical Company, reviewed clients' information needs and provided analytical reviews. Responsible for the configuration, testing and implementation of reporting needs for the CLv2 CORE LIMS V2 implementation in a GxP environment. Adhered to GMP 21 CFR 210 and 211 regulations thru SDLC process. Responsible for developing Oracle Financial modules for financial reporting. Performed reporting analysis on sales call activity. Responsible for designing complex data models utilizing Erwin. Responsible for Designing and implementing data warehouse ETL using SSIS and building SSAS cubes with complex data dimensions, measures, data source views . Responsible for performance tuning and deploying and processing SSAS cubes. Designed MDX queries for analysis in SSAS. Responsible for SQL server table and SSAS cube partitioning. Creating SSRS reports using SSAS as data source passing parameters to drill-down reports Responsible for utilizing Oracle Streams for data capture for clinical trial databases. Responsible for development of Supply Chain analytical models.
• Involved in Requirement Gathering and working with Design team to implement various Custom Controls.
• Built SSIS Master and child packages for initial load of data and incremental monthly loads of data for small data mart consisting of 10 standard type1 dimensions and 4 aggregated fact tables. Utilized Oracle Streams for data replication across clinical trial databases. Responsible for setting security access permissions and report properties within the Business Objects environment. Utilized SQL Server 2005 for reporting packages. Utilized SSPS for data mining activities. Developed ETL processes utilizing DTS/DATASTAGE for staging tables. Responsible for designing and maintaining SSAS OLAP cubes. Designed classes/objects for JAVA applications. Monitored system functionality and performance to ensure standards were met. Responsible for migrating DTS packages to SSIS.
• Developed action plans and service level agreements with internal customers. Built long-term relationships with key individuals and groups.
• Serve as in-house expert on new or more effective data sources in the marketplace.
• Responsibility for the reporting, QC, and interpretation of standard deliverables such as periodic dashboard and tracking reports.
• Provided analytical support to measure the effectiveness of budget vs. actual financial reporting for drug studies of marketing initiatives.
• Created improvements to standardized report prototypes for drug studies.
• Solved customer issues, and keep updated on pharmaceutical industry trends and issues.
• Created and delivered highly effective presentations thru PowerPoint presentations. Responsible for data warehouse development utilizing Oracle Warehouse Builder. Responsible for Lotus Notes system problem resolution. Responsible for development of LIMS applications. Responsible for ownership and support of sales and marketing applications. Served as lead person for all sales and marketing IT applications. Responsible for implementing sales call tracking reporting application. Designed and implemented database design for financial and marketing applications in COGNOS. Performed SDLC system development life cycle duties for COGNOS Financial Reporting System applications. Responsible for final system testing and implementation of COGNOS applications. Responsible for configuration of COGNOS Framework Manager Packages and SDK. Designed reporting packages in COGNOS Report Studio. Performed metrics reporting utilizing COGNOS Metrics Studio. Responsible for designing Oracle databases for clinical trial studies. Responsible for developing PL/SQL queries for data extractions. Responsible for creating financial reports using COGNOS Impromptu. Designed and created COGNOS Power Play cubes for OLAP reporting process within an UNIX environment. Responsible for designing Oracle 11i Financials reports for AP/AR. Responsible for schema and data modeling development in Oracle 11i Financials. Developed Oracle Discoverer worksheets for dashboard development. Created Oracle portlets for dashboard development utilizing Oracle 11i Financials. Created Excel spreadsheets, pivot tables for statistical reporting purposes. Lead person for implementation process of MS-ACCESS financial databases conversions to 2007 version. Responsible for full SDLC process for MS-ACCESS financial databases conversions. Utilized TOAD for database development. Developed PERL scripts for reporting purposes. Utilized Business Objects SDK/Enterprise for application design. Utilized Business Objects Data Integrator for ETL processes. Utilized Crystal Xcelsius to create dashboards to reflect KPI's for clinical trial studies. Responsible for creating Universes utilized Business Objects.
• Utilized Business Objects XI/Crystal Reports to develop extensive financial reports.
• Responsible for utilization of Business Objects Web Intelligence for end user reporting.
• Designed data marts and universe structures for reporting purposes.
• Responsible for development of drilldown reports.
• Responsible for Oracle Forms development for front end process.
• Responsible for writing SQL to extract data from and import to DB2, Oracle Teradata
• Responsible for database schema design and T-SQL development.
• Responsible for making recommendations for utilization of 3rd party tools which resulted in 50 overall system enhancement.
• Designed complex reports utilizing SSRS.
• Designed queries to extract data using SQL Server 2008. Performed detailed analysis to fully identify customer's systems change request. Created detailed, clear and thorough specifications for all systems change requests. Responsible for troubleshooting software problems. Responsible for resolving network issues and end user system problems. Ensured that strategies, plans and deliverables for application design were met on time. Environment: Windows NT, Unix, Oracle 11i, ProClarity, Oracle ERP Suite, Microsoft CRM, SQL Server 2005/2008, PL/SQL, SSAS, SSPS, SSRS, SSIS, MDX, Perl, JAVA, DB2, Cognos Series 7/8, Business Objects, Xcelsius, XI, Data Integrator, UNIX, MS-ACCESS 2003 Confidential Database AnalystResponsible for maintaining an Oracle 9i database, which tracks donor donations for a relief organization. Assisted in database tuning and optimization for reporting purposes. Responsible for supporting IT marketing applications. Worked with Data Analysts/Modelers with mapping data from source to target systems. Developed and tested Mainframe / ETL processes, including program and systems documentation and test plans, according to established IS standards. Developed and maintained CRM Marketing sytems. Responsible for configuration of COGNOS Framework Manager Packages and SDK. Utilized TOAD for database development. Responsible for schema and data modeling development in Oracle 9i. Responsible for Oracle Forms development for front end process. Designed queries utilizing Oracle Discoverer 4.1 for financial reporting. Responsible for creating UNIX scripts for historical data load processes. Designed queries to extract data using SQL Server. Responsible for database schema design and T-SQL development.
• Designed data marts and universe structures for reporting purposes.
• Utilized Business Objects SDK/Enterprise for application design. Utilized Crystal Xcelsius to create dashboards to reflect donor donations.
• Utilized Business Objects/Crystal Reports to develop extensive financial reports.
• Responsible for application of CMMI methodology techniques for IT applications. Responsible for creating financial reports using COGNOS Impromptu. Designed and created COGNOS Power Play cubes for OLAP reporting process. Responsible for developing COGNOS Contributor datasheets for management comparison reports. Responsible for building and testing of COGNOS cubes. Support and troubleshoot production systems as required, optimizing performance, resolving production problems, and provided timely follow-up problem reports Environment: Windows NT, Oracle 9i, SQL Server, PL/SQL, Cognos Series 7/8, Autosys, AS400, UNIX, Business Objects/Crystal Reports, Xcelsius Confidential Senior Hardware TechnicianResponsible for reviewing schematics of computer hardware of multiple product lines of business control machines for IBM. Work with design engineers to ensure that product development is done in timely matter and within budget. Responsible for building of computer communications hardware from initial development phase. Responsible for loading of software to ensure that products are operating properly. Responsible for pretest and final testing of hardware.

Environment: Windows NT, Nortel Hardware, IBM Hardware

Confidential

Senior Application Developer Consultant

Responsibilities include interpret business requirements and define technical alternatives, tools, and approach for Equifirst Mortgage Brokerage company. Responsible for ownership and support of sales and marketing applications. Served as lead person for all sales and marketing IT applications. Developed, test, implement and documented the technical solutions to address the defined business requirements. Performed detailed analysis to fully identify customer's systems change request. Created detailed, clear and thorough specifications for all systems change requests. Worked with Data Analysts/Modelers with mapping data from source to target systems.

• Develops and tests Mainframe / ETL processes, including program and systems documentation and test plans, according to established IS standards.
• Participated with the development team and IT staff as appropriate in the design of solutions. Collaborated with other technical areas to integrate across tiers, platforms, and responsibilities. Provided rotating pager support for front-end Systems by interacting with external and internal customers to resolve end user issues including production problems, process clarification, and training issues. Collaborated with other team members to define effort estimates, time tables and project plans. Responsible for backend development process. Responsible for extracting large historical data sets databases into data repositories. Responsible for data warehouse development utilizing Oracle Warehouse Builder. Responsible for schema and data modeling development in Oracle 9i. Wrote PL/SQL queries for data extractions.
• Responsible for writing SQL to extract data from and import to DB2, Oracle Teradata
• Responsible for data loading into Staging and Star Schemas correctly for operational system. Responsible for establishing and maintaining standards for data quality and data validation in the data warehouse. Utilized Business Objects SDK/Enterprise for application design. Utilized Crystal Xcelsius to create dashboards for performance reporting.
• Utilized Business Objects/Crystal Reports to develop extensive financial reports.
• Designed data marts and universe structures for reporting purposes.
• Managed technical aspects of application to ensure timely and effective implementations. Ensured that expected application performance levels were achieved. Acted as liaison between business units and the application development area. Responsible for configuration of COGNOS Framework Manager Packages and SDK. Designed and creating COGNOS Power Play cubes utilizing Power Play enterprise server. Created detailed reports featuring COGNOS Visualizer and COGNOS catalogs. Developed Scorecards for Funded Loans reporting purposes. Responsible for the Oracle 9i table and report development. Responsible for Oracle ERP module development. Wrote PERL scripts for report analysis. Responsible for development of Oracle Forms 6i and Reports 6i for operational systems. Designed and created COGNOS Power Play cubes for OLAP reporting process. Responsible for dashboard development utilizing COGNOS Metrics Manager. Set up detailed drill down mortgage reports in COGNOS Report Net. Set up ETL processes using COGNOS Decision Stream. Responsible for tuning of the reporting process of the data warehouse. Set up process of extracting mortgage data from mainframe environment down to data warehouse. Set up UNIX scripts for the extraction process to data warehouse. Created Power Prompts parameters for reporting purposes. Created data models using ERWIN for data warehouse. Created ETL scripts for overnight process of loading mortgage information data from mainframe to COGNOS environment. Set up COGNOS Notice Cast alerts for messaging purposes. Responsible for setting access permissions and report properties within the COGNOS environment. Responsible for creating financial reports using COGNOS Impromptu, COGNOS IWR. Created dimensions tables within SQL SERVER environment. Responsible for data validation of COGNOS data. Responsible for query tuning of utilizing SQL SERVER. Environment: Windows NT, UNIX, ORACLE 9i, PL/SQL, COGNOS Series 7, SSAS, SSIS, PERL, ERWIN, DB2, BUSINESS OBJECTS, Xcelsius, SQL SERVER

Confidential

Senior Systems Developer

Responsibilities include interpret business requirements and define technical alternatives, tools, and approach for JC Penney. Responsible for ownership and support of sales and marketing applications. Served as lead person for all sales and marketing IT applications. Developed, test, implement and documented the technical solutions to address the defined business requirements. Participated with the development team and IT staff as appropriate in the design of solutions. Collaborated with other team members to define effort estimates, time tables and project plans. Collaborated with other technical areas to integrate across tiers, platforms, and responsibilities. Responsible for data loading into Staging and Star Schemas correctly for operational system. Responsible for establishing and maintaining standards for data quality and data validation in the data warehouse. Responsible for designing complex data models. Monitored system functionality and performance to ensure standards were met. Responsible for application of CMMI methodology techniques for IT applications. Managed technical aspects of application to ensure timely and effective implementations. Ensured that expected application performance levels were achieved. Acted as liaison between business units and the application development area.

• Responsible for the technical operation and support of data delivery systems in a UNIX/Oracle data
• Warehouse environment.
• Responsible for schema and data modeling development in Oracle 9i.
• Responsible for writing SQL to extract data from and import to DB2, Oracle Teradata
• Responsible for extracting large historical volume data sets into data repositories.
• Utilized Business Objects/Crystal Reports to develop extensive financial reports.
• Set up development and enhancement of batch oriented technical ETL applications, automatic scheduling routines, and related programs and procedures.
• Responsibilities included overall database and data warehouse development for a Sales Tracking System in Oracle 9.1 within an UNIX environment. Performed ETL processes using DTS. Responsible for development of Oracle Forms 6i and Reports 6i for operational systems Wrote PL/SQL queries for data extractions. Wrote Unix Shell Script procedures for data loads. Created database design utilizing ERWIN. Created graphical diagrams of data models utilizing Allfusion Model Navigator. Created user documentation for end users and management. Responsible for configuration of COGNOS Framework Manager Packages and SDK. Designed and created COGNOS Power Play cubes for OLAP reporting process. Responsible for creating detailed reports featuring COGNOS Visualizer. Responsible for setting up ETL process using COGNOS Decision Stream. Set up process of extracting sales data from mainframe environment down to data warehouse. Set up tuning process of the reporting feature of the data warehouse which resulted in a 50 overall performance enhancement. Performed Full Data Warehouse Development Life Cycle processes. Performed data mining activities with PolyAnalyst. Responsible for setting access permissions and report properties within the COGNOS environment. Translated business intelligence requirements into logical/physical data models. Assisted in the building of custom data marts and data warehouses. Designed drill down sales reports for region managers utilizing COGNOS Report Net. Responsibilities included collaboration of the design and deployment of INFORMATICA data warehouse utilizing PowerCenter, PowerMart and PowerAnalyzer tool sets. Responsible for creating extensive sales reports using COGNOS Impromptu. Responsible for developing and implementing TERADATA data warehouses version 7 in a Windows NT environment. Performed Teradata data queries and adhoc reporting utilizing BTEQ utility tool for financial reporting. Performed Teradata data loads and data transfers for reporting purposes utilizing FastLoad and FastExport. Performed data maintenance on Teradata tables utilizing MultiLoad. Responsible for designing import process of data into BRIO from data warehouse. Utilized Business Objects SDK/Enterprise for application design. Utilized Crystal Xcelsius to create dashboards for performance reporting.
• Utilized Business Objects/Crystal Reports to develop extensive financial reports.
• Designed data marts and universe structures for reporting purposes.
• Responsible for database schema design. Responsible for backend database development. Designed queries to extract data using SQL Server Responsible for development and customization of SQL Server databases. Designed Brio/SQR reports for management reporting purposes. Created reports using Oracle Developer 2000. Provide weekly project management reports utilizing MS-PROJECT. Environment: Windows NT, UNIX, COGNOS Series 7, BRIO, TERADATA, BUSINESS OBJECTS, INFORMATICA, ERWIN, MODEL NAVIGATOR, ORACLE 9i, POLYANALYST, MS-PROJECT, NCR SERVER, SQL SERVER Confidential Senior Systems Analyst Responsible for reviewing client information needs for a Patient Care Information System for 3HC a health care provider within an AS/400 environment. Responsible for design of front end utilizing Visual Basic. Created MS-ACCESS databases for Patient Care Information tracking purposes. Performed coding of programs for information system in Microsoft Visual FoxPro. Performed COBOL programming and maintenance on the AS/400. Responsible for designing Oracle databases for clinical trial studies Performed system testing and implementation of Patient Care Information System. Responsible for troubleshooting end user and hardware problems. Designed queries to extract data using SQL Server Created daily reports for management which resulted in a 60 overall reporting enhancement. Environment: Windows NT, AS400, VISUAL BASIC, MICROSOFT VISUAL FOXPRO, SQL SERVER, ORACLE, MS-ACCESS Confidential Database Administrator Consultant For IBM Corporation, responsible for Database Administration on the IBM-Microsoft Royalty Payment project, allowing IBM to pay Microsoft royalties for Microsoft software installed on IBM equipment on multiple platforms. Created functional design specifications. Responsible for ownership and support of sales and marketing applications. Responsible for coordination of offshore/onshore template data gathering. Assisted in preparation and execution of testing activities. Responsible for application of CMMI methodology techniques for IT applications. Ensured that strategies, plans and deliverables for application design were met on time. Delivered training to technical and business users. Participating in converting Lotus Note Approach databases to MS-ACCESS. Responsible for creating MS-ACCESS applications for Royalty Payment Tracking applications. Responsible for web application development. Coordinated tracking and monitored development of application design. Supported development of training materials and participated in training activities. Responsible for solving network issues and moving legacy data across multiple platforms via FTP. Worked with business units to gather functional business requirements, develop process and application design. Responsible for designing COGNOS cubes for OLAP reporting purposes. Designed and customized COGNOS Series 7 query reports for financial reporting purposes. Responsible for setting access permissions and report properties within the COGNOS environment. Set up ETL process using COGNOS Decision Stream.
• Performed Full Data Warehouse Development Life Cycle processes.
• Set up scripts for the extraction process to data warehouse. Created extensive royalty payment reports using COGNOS Power Play, COGNOS Impromptu, and COGNOS IWR. Created and developed custom data marts and data warehouses. Developed design recommendations that provided a 50 overall system improvement. Created database design for worldwide COA Tracking System utilizing MS Access within a SQL Server environment. Performed maintenance of Access databases made enhancements to VBA Code. Responsibilities included overall database development for Royalty Payment database project in Oracle 8.1 within an UNIX environment. Responsible for data normalization and physical and logical design of databases. Performed data modeling activities utilizing Erwin for database design. Ensured that strategies, plans and deliverables for application design were met on time. Performed for data extractions from DB2 UDB from data warehouse utilizing SAP BW for reporting purposes. Responsible for planning and designing of layout of DB2 UDB databases, defined scheduled maintenance procedures. Responsible for database schema design in SQL Server. Designed queries to extract data using SQL Server. Responsible for upgrades to DB2 UDB databases, worked closely with vendors to coordinate software upgrades. Responsible for establishing reorganization, backup and recovery procedures of DB2 UDB databases. Designed dataflow, data feeds processes for sites to adhere to, and for creating process for uploading of data feeds into databases. Design Excel spreadsheets for reporting purposes. Performed weekly reviews with worldwide sites to ensure data integrity. Ran weekly reports for management review. Created worldwide templates for site locations to input data in.

Environment: Windows NT, AS400, DB2 UDB, BRIO/SQR, SAP, LOTUS NOTES, ERWIN, OS390, UNIX, SQL SERVER, VBA, MICROSOFT ACCESS 2000, ORACLE 8i, COGNOS