James Epps

ad415j@r.postjobfree.com

213-***-****

PROFESSIONAL SUMMARY

Has fifteen years of experience in application development of complex database driven web and client server applications. Has a thorough understanding of the SDLC process and has performed multiple roles as listed below

EXPERIENCE

Neutraderm Chatsworth, CA 11/10 - 3/24

· As a Database Architect/Programmer, I created star and snow flake schema data marts. The data marts were populated by extracting data from DB2 10.5/11.1, MS Access, Sybase Adaptive Server 15.5/16, Oracle 11g/12c as well as SQL Server 2008r2/2012/2014/2016/2019 using SQL/stored procedures and SSIS packages. Data was later loaded into SQL Azure.DreamFactory was used to convert stored procedures in various database into REST API calls. o The data mart was defined using a logical model and converted to physical model using Erwin. Erwin was also used to reverse engineer existing databases.

o The logical model consisted of attributes, entities, and relationships. o The physical model defined the columns, constraints, foreign keys, surrogate/primary keys, data types, indexes, dimension tables, and fact tables.

o When working with Oracle 11g/12c, I used TOAD and Oracle Developer. I created and modified views, materialized views, stored procedures, and synonyms using PL/SQL. o When working with SQL Server 2008r2/2012/2014/2016/2019, I used Management Studio. I utilized/created stored procedures, views, triggers, Common Table Expressions CTE, xquery, partitions, linked servers, clustered/nonclustered/filtered indexes, CLR functions written in c#, synonyms, indexed views with scehmabinding, update statistics, foreign keys, surrogate/primary keys, constraints, functions, maintenance plans, backup/restore, mapping/dimension/fact tables using TSQL. o When working with Sybase Adaptive Server 15.5/16, I used Toad for Sybase. I utilized tables, views, stored procedures, triggers, indexes, and Ansi SQL. o When working with DB2 10.5/11.1, I used Toad for Db2 and IBM Data Studio\. I utilized tables, views, stored procedures, triggers, indexes, and Ansi SQL. o SQL Server Data Tools (SSDT-BI) was used to create SSIS packages that extracted, transformed, loaded data. The packages utilized logging, checkpoints, precedent constraints, Slowly changing dimension wizard, lookups, and various transformations.

· The reporting tools included SQL Reporting Services (SSRS) 2008r2/2012/2014/2016/2019, Microstrategy 8.1.1/9.4.1/10.1.1/10.8.1/11.0/2019, Tableau 9.4/10.3/2019.3, Excel Office 365, MS Access Office 365,, Power BI, Oracle Business Intelligence Enterprise Edition Plus (OBIEE)/BI Publisher 11g/12c. o Reports designed for SSRS utilized indicators, maps, pie/bar/line charts, drill downs on pie chart slice, gauges, expressions, document maps, cascading parameters, report parts, alternating background line colors, custom formatting, shared datasources, multiple datasets, matrix/tabular/list/tablix data regions, MDX, wizards, and were created using Report Builder or Visual Studio SSDT/-BI. o Reports designed for Microstrategy utilized attributes, consolidations, custom groups, calculated expressions, metrics, security filters, derived metrics, free-form SQL, functions, calculations, list, drilling options, sorting, attribute elements, calculations, prompts, thresholds (conditional formating), grid/gaph views. Utilized Visual Insight and Dossiers. Panel stacks and Selectors were created to display multiple panels of grid/graphs on dashboards/documents created inside Desktop. I created reports from existing reports, templates, intelligent cubes, or MDX cube. Created Transaction Services reports that updated data inside database using Freeform SQL for databases and Xquery for web services. All attributes, transformations, tables, facts, and hierarchies were created in Architect. Administrator was used to create users, groups, and security roles. Mirostrategy Mobile took advantage of custom dashboard custom workflows, mobile views, information windows, panel stacks, selectors (allowing current panel to be changed without selector), docked panel selectors, mobile pre defined templates (Iphone Portrait, Iphone Portrait Micro-Application,Iphone Landscape, Iphone Landscape Micro-Application, Iphone Map Information Window, Ipad Portrait, Ipad Ladscape), page by, widgets inside documents, links, drilling, moved legends below graphs to maximize grap size, images on web server were enlarged by adding @2x to filename, and utilized Mobile ID prompts. Installed Microstrategy Mobile on an Intelligence Server and mobile devices. IIS used anonymous authentication to access all directories at the Mobile Server application level. Integrated Windows authentication was enabled for all directories except the following image directories: MicroStrategyMobile/asp/images and MicroStrategyMobile/images.

. To view reports in Mobile, users had the Use MicroStrategy Mobile privilege for projects. users had Execute permission for any reports they were subscribed to and for anyobjects contained in those reports. o Tableau Desktop was used to create reports/dashboards. The Tableau reports/dashboards included workbooks, sheets, stories, sets (custom fields), views, filters, grouping, and sorting. o Reports created for Excel utilized vba macros, piviots, lookups,, and were emailed out automatically to end users using MS Power Automate.

o Reports created for Access utilized vba macros, views, forms, and sql, o Power BI reports (.PBIX), visualizations, and Power BI apps (bundles of similar reports) were designed in Power Desktop and published/shared within Power BI Service. The reports were combined into dashboards within Power BI Service. Reports connected to Salesforce. Combined data sources into a data model. Had to create, transform, shape the data model in order to build collections of visuals that were shared as reports. Created reports that are collections of visuals, on one or more report pages. Added bookmarks, buttons, filters, and drillthrough, to enhance navigation to reports. Utilized the 3 views: Report (for reports and visuals), Data

(for shaped data, measures, custom column formula, and PowerQuery Editor), and Model (for managing relationships among tables, transform column data types, and used Query Editor). Saved reports to a workspace in the Power BI service. Utilized dataflows (a collection of entities similar to tables) that are created and managed in workspaces in the Power BI service. o Created reports in BI Publisher and dashboards in OBIEE. Created RPD file using Oracle BI Administration Tool to hold the repository. Created joins, business model and mappings inside Repository. Managed Weblogic Server that OBIEE was hosted on.

Ascent Service Group/Providence Hospital Burbank, CA 7/12 -10/13

· As a Database Architect/Programmer, I created SSIS packages to export data from SQL Server 2008 R2 and Oracle 11g into flat files with timestamps as filenames encoded in HL7 format using BIDS. Utilized transact sql when working with SQL Server R2 and PL/SQL when working with Oracle 11g. TOAD and Oracle Developer was used to create views, materialized views, stored procedures, and synonyms in Oracle 11g. Management Studio was used to create views, user defined functions, stored procedures, and indexes in SQL Server 2008 R2. The tools included Microstrategy 9 and Tableau 7.

o Reports designed for Microstrategy utilized security filters, derived metrics, free-form SQL, functions, calculations, list, drilling options, sorting, attribute elements, calculations, prompts, thresholds (conditional formating), grid/gaph views in Desktop Designer. All attributes, transformations, tables, facts, and hierarchies were created in Architect. Administrator was used to create users, groups, and security roles. All reports were decoded from HL7 format.

o Tableau was used to create reports and dashboards. The Tableau reports/dashboards included workbooks, sheets, stories, sets (custom fields), views, filters, grouping, and sorting. Ascent Service Group/Blue Cross Blueshield, San Francisco, CA 3/10 - 10/10

· As a Database Architect/Programmer, I created a data mart. o The data mart was defined using a logical model and converted to physical model using Visio. o The logical model consisted of attributes, entities, and relationships. o The physical model defined the columns, constraints, foreign keys, surrogate/primary keys, data types, indexes, dimension tables, and fact tables. In order populate the data mart. o I created database objects in Oracle 10g. TOAD was used to create views, indexes, and stored procedures in Oracle 10g using PL/SQL. In order to understand the database, I used the reverse engineer feature in Erwin AllFusion 7.1 to create ER Diagram from a SQL script.

· · The tools included Microstrategy 9.

o Reports designed for Microstrategy utilized security filters, derived metrics, free-form SQL, functions, calculations, list, drilling options, sorting, attribute elements, calculations, prompts, thresholds (conditional formating), grid/gaph views in Desktop Designer. All attributes, transformations, tables, facts, and hierarchies were created in Architect. Administrator was used to create users, groups, and security roles. All reports were decoded from HL7 format.

Comsys/Bonneville Power Association, Portland, OR

9/09 - 3/10

· As a database programmer, created a database objects in Oracle 10g and MySQL 5.1. o I created database objects on several platforms for reporting purposes. TOAD was used to create views, indexes, and stored procedures in Oracle 10g using PL/SQL. MYSQL Administrator and MYSQL Query Browser were used to create backups using mysqldump, views, stored procedures, and indexes in MYSQL 5.1 using ANSI92 SQL. In order to understand both databases, I used the reverse engineer feature in Visio 2007 Enterprise for Architects to create ER Diagrams from SQL script files.

· As a Report Writer, I created reports utilizing a variety of reporting tools for various department. The tools included SQL Reporting Services (SSRS)2005 and Microstrategy 9. o Reports designed in SSRS utilized indicators, maps, pie/bar/line charts, drill downs on pie chart slice, gauges, expressions, document maps, cascading parameters, custom formatting, shared datasources, multiple datasets, matrix/tabular/list/tablix data regions, MDX, wizards, and were created using BIDS. o Reports designed for Microstrategy utilized security filters, derived metrics, free-form SQL, functions, calculations, list, drilling options, sorting, attribute elements, calculations, prompts, thresholds (conditional formating), grid/gaph views in Desktop Designer. All attributes, transformations, tables, facts, and hierarchies were created in Architect. Administrator was used to create users, groups, and security roles. Galpin Ford, North Hills, CA

3/09 - 8/09

· As a database programmer, created database objects in Oracle 10g and SQL Server 2008.. o I created database objects in Oracle 10g and SQL Server 2008. Oracle Developer was used to create views, materialized views, stored procedures, and synonyms in Oracle 10g using PL/SQL. Management Studio was used to create linked servers, views, indexes, stored procedures, and functions in SQL Server 2008 using TSQL. Er Studio was used to reverse engineer the database schema in both databases to understand them.

· The tools included Microstrategy 9

o Reports designed for Microstrategy utilized security filters, derived metrics, free-form SQL, functions, calculations, list, drilling options, sorting, attribute elements, calculations, prompts, thresholds (conditional formating), grid/gaph views in Desktop Designer. All attributes, transformations, tables, facts, and hierarchies were created in Architect. Administrator was used to create users, groups, and security roles. Adecco/Sega Entertainment USA, Glendale, CA

9/08 - 1/09

· As a Database Architect/Programmer, I created a data mart based on a snow flake schema and MOLAP/ROLAP cubes for SQL Server Analysis Services 2005.

o The data mart was defined using a logical model and converted to physical model using Erwin. o The logical model consisted of attributes, entities, and relationships. o The physical model defined the columns, constraints, foreign keys, surrogate/primary keys, data types, indexes, dimension tables, and fact tables. In order populate the data mart. o I built stored procedures in SQL Server 2005 that gathered data from various sources. o Databases from MySQL 4.1, Oracle 10g, and SQL Server 2000 were used as linked servers in SQL Server 2005.

o I created clustered indexes, surrogate keys, cursors, views, functions, staging tables, nested queries, table hints, in/ out parameters, and explicit transactions within the stored procedures. o The execution plan and SQL Profiler were used to investigate slow running stored procedures.

· The tools included SQL Reporting Services (SSRS)2005 and Microstrategy 9 o Reports designed in SSRS utilized indicators, maps, pie/bar/line charts, drill downs on pie chart slice, gauges, expressions, document maps, cascading parameters, custom formatting, shared datasources, multiple datasets, matrix/tabular/list/tablix data regions, MDX, wizards, and were created using BIDS. o Reports designed for Microstrategy utilized security filters, derived metrics, free-form SQL, functions, calculations, list, drilling options, sorting, attribute elements, calculations, prompts, thresholds (conditional formating), grid/gaph views in Desktop Designer. All attributes, transformations, tables, facts, and hierarchies were created in Architect. Administrator was used to create users, groups, and security roles. Nova Management/Magellan GPS, Santa Clara, CA

2/08 - 7/08

· As the Web Developer, used Visual Studio .NET 2005 to create a custom reporting intranet application. o The application relied upon Business Scoreccard 2005 Web Part, SQL Reporting Services Web Part, Sharepoint Server 2007, NET Framework 3.0, Internet Information Server 6.0, ASP.NET, c# class files, .NET server controls, HTML, DHTML, CSS, JavaScript, and ADOMD.NET.

· As a Database Programmer, used SSIS 2005 to create OLAP database based on a star schema datamart. o DTSX files/SSIS packages were created and modified in SQL Server Business Intelligence Development Studio and scheduled using SQL Server Agent.

o MOLAP/ROLAP cubes were created and deployed to SQL Server Analysis Services 2005. Alexicon/Northrop Grumman, Los Angeles, CA

9/07 - 1/08

· As a Database Programmer, I created a data mart based on a snow flake schema and MOLAP/ROLAP cubes for SQL Server Analysis Services 2005.

o The data mart was defined using a logical model and converted to physical model using Erwin. o The logical model consisted of attributes, entities, and relationships. o The physical model defined the columns, constraints, foreign keys, surrogate/primary keys, data types, indexes, dimension tables, and fact tables. In order populate the data mart. o I built stored procedures in SQL Server 2005 that gathered data from various sources. o Databases from MySQL 4.1, Oracle 10g, and SQL Server 2000 were used as linked servers in SQL Server 2005.

o I created clustered indexes, surrogate keys, cursors, views, functions, staging tables, nested queries, table hints, in/ out parameters, and explicit transactions within the stored procedures. o The execution plan and SQL Profiler were used to investigate slow running stored procedures. o Some stored procedures were used for reports and others were used inside SSIS packages to populate dimension/fact tables within the data mart.

o All SSIS packages included logging and checkpoints. o I used SQL Analysis Services 2005 to create MOLAP cubes for reports. o MOLAP cubes included dimensions, named queries within the data source view, user-defined hierarchies, attributes, member properties, perspectives, KPIs, and measures within Business Intelligence Development Studio.

o The cubes were regularly updated utilizing proactive caching features of SQL server Analysis Services 2005.

· As a Report Writer, created reports using a variety of reporting tools for various groups within the company. o Reporting tools used consisted of Business Objects XI R2, Access 2003, and SQL Reporting Services 2005, Microtreategy 8.

Prime Team Partners/ Microsoft, Seattle, WA

7/07 - 8/07

· As a Report Writer, I used SQL Server Reporting Services 2005 to create 5 reports utilizing MDX and Transact SQL. o The data sources included SSIS 2005, SQL Server 2005, and SSAS 2005 cube.

· As a Database Programmer, modified and created stored procedures and views in SQL Server 2005. o The stored procedures were used to populate a mapping tables and a star schema data mart. o Created SSIS packages to populate the staging database using data from TAB files, RSS feeds, SQL Server 2005, EXCEL, SharePoint list, and CSV files. o Used SQL Server Agent to populate mapping tables and star schema data mart using stored procedures. o All SSIS packages included logging and checkpoints. o Modified MOLAP cubes by adding additional dimensions, named queries within the data source view, hierarchies, attributes, member properties, and measures within Business Intelligence Development Studio. o All cubes were processed and deployed to SQL Server Analysis Server 2005. E Quest Solutions/ Spotrunner, Los Angeles, CA

1/07 - 4/07

· As the Web Developer, used Visual Studio .NET 2005 to create a custom reporting intranet dashboard application. o The application relied upon Business Scorecard 2005 Web Parts, Dundas Map for Reporting Services v1.0, Crystal Xcelsius SharePoint web part 4.5, Reporting Services 2005 Viewer Web Part, Reporting Services 2005 Explorer Web Part, NET Framework 3.0, C#, Code Snippets, Internet Information Server 6.0, SharePoint Services 2007, Web Parts, ASP.NET, c# class files, .NET server controls, HTML, DHTML, CSS, JavaScript, VB Script, and ADO.NET.

· As a Database Programmer, used SSIS 2005 to de normalize an OLTP database in order to build an OLAP database based on a star schema.

o All the dtsx files were created and modified in SQL Server Business Intelligence Development Studio and scheduled using SQL Server Agent.

o MOLAP and ROLAP cubes were created and deployed to SQL Server Analysis Server 2005. o The reports utilized data from linked servers, distributed queries, views, stored procedures, derived tables, and MDX queries.

· As a Report Writer, created 22 reports using several tools. o The tools included Microstrategy 7, Microsoft Office Business Scorecard Manager 2005, SQL Server Reporting Services 2005, Proclarity 6.2, Crystal Xcelsius Designer 2005, and Excel 2003 for pivot reports. o The data sources included SSIS 2005, SQL Server 2005, SSAS 2005 cubes, xml, Excel, and Microsoft Active Directory.

Mitratech, Los Angeles, CA

9/06 - 12/06

· As the Web Developer, used Visual Studio .NET 2005 to create a custom reporting intranet dashboard application. o The application relied upon Business Objects .NET SDK, Web Intelligence Viewer, Desktop Intelligence Viewer, NET Framework 2.0, C#, Code Snippets, Internet Information Server 6.0, SharePoint Services 2003, Web Parts, ASP.NET, c# class files, .NET server controls, HTML, DHTML, CSS, JavaScript, VB Script, and ADO.NET.

· As a Database Programmer, modified the SQL script to recreate database objects on three platforms. o Used SQL Server Management Studio to create and modify views, stored procedures, and synonyms in SQL Server2005 using Transact SQL. Setup Publishers, Distributors and a Subscriber using SQL Server Replication Server to replicate articles in databases. o Used TOAD and Oracle Developer to create and modify views, materialized views, stored procedures, and synonyms in Oracle 10g using PL/SQL.

o Used MYSQL Administrator and MYSQL Query Browser to create and modify views and stored procedures in MYSQL 5.0 using ANSI92 SQL.

o Used Visual Studio 2005 to modify and create views and stored procedures in DB2 Data Server 8.1. In order to understand the databases, I used the reverse engineer feature in Erwin AllFusion 7.1 to create ER Diagrams from SQL script files.

o Used Business Objects Data Integrator 11.5.2 to extract data from various sources and load into data marts using ETL jobs.

o The real time jobs extracted data from xml web services and the batch jobs extracted data from 7 OLTP databases.

o Used SQLXML 3.0 with IIS 6.0 to expose stored procedures as SOAP web services in order interact with real time jobs.

o Data was analyzed for anomalies using the Profiler prior to using Administrator to schedule batch jobs and creating services from real time jobs.

o All projects created by the Designer were stored in Local and Central Repositories. o Each project contained jobs, work flows, data flows, transformations, data stores, and custom functions. o Installed and configured Jobs Servers and Access Servers using Server Manager and Repositories using Repository Manager.

· As a Report Writer, created 21 reports for each reporting tool totaling 84 reports. o The reporting tools used consisted of Microstrategy 7, Business Objects XI, Crystal Reports XI, Eclipse Birt 2.1, and SQL Server 2005 Reporting Services.

o Used Business Objects Designer to create 3 universes in Business Objects 5.1, 6.5, XI R2. Create canned reports within SQL Server Business Intelligence Studio. o The canned reports utilized stored procedures, views, queries, cascading parameters, formulas, dynamic sorting, grouping, and conditional formatting.

Razorgator, Santa Monica, CA

1/06 - 7/06

· As a Lead Web Developer, used Visual Studio .NET 2005 to create an intranet reporting application. o The application I created utilized web forms, functions created in VB.NET, .NET server controls, HTML, DHTML, CSS, Javascript, AJAX, VB Script, ASP.NET Membership 2.0, and ADO.NET to access stored procedures in SQL Server 2000.

o As a Database Programmer, created MOLAP and ROLAP cubes using SQL Server 2000 Analysis Server. o Each cube was either based on a star or snow flake schema. o They featured dimension(s), attributes, measures, and fact tables.

· As a Report Writer, Developed 76 tabular and matrix style reports using Report Designer in Visual Studio 2005. o The reports connected to SQL Server 2000 via OLE DB. o Used OLE DB 9.0 for Analysis Services when creating reports in excel and SQL Server Reporting Services.

o Installed and configured SQL Server 2000 Reporting Services in order for users view reports on demand. o The reports relied on stored procedures, Transact SQL statements, and MDX queries created to retrieve data.

o The reports connected to a shard data source.

o Used the export wizard within DTS to export data into Excel in order to create a few reports. Utimate Staffing/ Directv, El Segundo, CA

8/05 - 10/05

· As a Lead Web Developer, used Visual Studio .NET 2003 to create intranet application and enhance another. o The dynamic calendar intranet application, I created utilized web forms, web services created in c#, .NET server controls, HTML, DHTML, CSS, Javascript, VB Script, ASP.NET directives, and ADO.NET to access SQL Server 2000 and Oracle 10 g databases using the OLE DB .NET data provider. o Used C# to create a Winform email application.

o The intranet application I enhanced utilized VB COM, MTS, ASP, DHTML, HTML, JavaScript, VB Script, file system object, and ADO 2.7 to access SQL Server 2000.

· As a Report Writer, developed 9 reports using Report Designer in Visual Studio 2003.

· As a Database Programmer, created stored procedures and views in SQL Server 2000 and views in Oracle 10g. o The stored procedures and views in SQL Server 2000 consisted of Transact SQL statements. o Used vb script and windows scripting host (WSH) to create a custom DTS package to export data from SQL Server 2000 and Oracle 10g into a xml file and ftp that file to their vendor. o The views in Oracle 10g consisted of PL SQL statements. o Created 2 additional tables in SQL Server 2000.

o The rules of data normalization were followed when creating the tables. o Installed and configured SQL Server 2000 Reporting Services in order for users view reports on demand. Nielsen Entertainment, Hollywood, CA

6/05 - 8/05

· As a Web Developer, used Visual Studio .NET 2003 to enhance a movie tracking application called CINESYS. o The application took advantage of Internet Information Server 5.0 (IIS), Windows 2003 server, and Microsoft .NET Framework 1.1.

o Various technologies were used in each layer of the three tier application. o Used C# to create a COM+ component that is derived from the Service component class of the System. o Enterprise Services namespace.

· As a Database Programmer, used SQL Plus to create 25 PL/SQL views within Oracle 9i and 10g. o The databases consisted of 64 tables.

TheMortgageStore.net, Los Angeles, CA

3/05 - 6/05

· As a Lead Web Developer, used Visual Studio .NET 2003 to create an intranet mortgage tracking application. o Various technologies were used in each layer of the three tier application. o The presentation layer consisted of ASPX and XSL files. o Used c# to create an xml web service.

o The data layer consisted of stored procedures and views in SQL Server 2000.

· As a Database Programmer, created stored procedures and views in both SQL Server 2000 and Oracle 9i. o The stored procedures and views in SQL Server 2000 consisted of Transact SQL statements. o Created a DTS package to update several tables using an update cursor within a stored procedure. o The stored procedures and views in Oracle 9i consisted of PL SQL statements. o Created 7 additional tables in SQL Server 2000.

o The rules of data normalization were followed when creating the tables.

· As a Report Writer, installed and configured Microsoft Reporting Services in order for five scheduled reports is sent to users via email in EXCEL format on a recurring basis. o Reports were created using the Report Designer in Visual Studio 2003.

· As a Crystal Report Writer, developed two reports using Crystal Reports 11 Developer Edition. o These reports consisted of two standard reports. Teklead/JD Powers and Associates, Agoura Hills, CA 1/05 - 3/05

· As a Web Developer, Used Visual Interdev 6.0 to create an intranet application for different levels of users for viewing surveys.

o The application took advantage of Internet Information Server 4.0 (IIS) and Windows 2000 server. o The presentation layer consisted of HTML, DHTML, and JavaScript. o The business logic layer made calls to VB COM objects hosted in Microsoft Transaction Server. o The data layer utilized stored procedures to retrieve data in SQL Server 2000.

· As a Crystal Report Writer, developed three reports using Crystal Reports 10 Developer Edition. o These reports consisted of one bar/line reports and two standard reports. o The reports connected to SQL Server 2000 via OLE DB.

· As a Database Programmer, used SQL Query Analyzer to create 18 Transact SQL stored procedures within SQL Server 2000.

o Used parameters, temp tables, cursors, and custom functions to create the stored procedures. The database consisted of 27 tables.

Contact this candidate