Business Intelligence Software Consulting Company

This site  The Web 

1220 N. MARKET ST Suite 600, Wilmington, DE, 19801| Phone: 877-367-5520| Fax: 312-577-0854| info@emrintl.com

Our consulting firm specializes in BI software and training solutions , that are tailored to your business and your challenges
Our goal is to get you implementing, not just planning. Our work is grounded in real business issues to produce tangible, bottom line outcomes.
 We use the context of your business to develop the strategies and behaviors necessary for success in today's market driven climate.
We utilize extensive experience in the following technolgies:
·         11 years as DBA/Developer of SQL Servers (Versions 6.5, 7.5, 2000, 2005, 2008), Netezza, ORACLE 10i, DB2 UDB·         11 years of stored procedures and scripts development, including analysis and programming using T-SQL, PSQL, Shell scripting, VB.NET, .NET ·         6 years of developing DTS, SSIS, SSRS, and SSAS·         4 years of ETL, using Informatica Data Mart, Power Designer, Informatica Power Center ·         9 years of data modeling using Erwin, Embarcadero, ER-Studio and Sybase Power Designer in data warehouse design, including CRM, SAP, PeopleSoft, Siebel Analytics·         2 years of SharePoint administration/development·         2 years of Hyperion administration and development
The companies we did the projects for:
  SG2 - Healthcare Business Intelligence  October 2011 – May 2012 provided ongoing support and troubleshooting for production support of SSIS packages and SSAS cubes in creation analytical business forecasts for hospitals and health care institutions.  Extensively use MS BI stack (SSIS, SSAS, T-SQL) in SQL Server 2008.   Provide ETL design and development for ongoing projects in EDW.  Build BI Analysis cubes. Create scripts to extract, transform, load (ETL), to clean and data mine from:  SQL Server 2008 databases, Access databases, Excel, Flat Files, and XML.   
 RYDER Systems, INC   July 2009 – October 2011   Worked on ETL design and development for ongoing projects in EDW. Create the scripts to extract, transform, load (ETL), to clean and data mine from:  Netezza, DB2 UDB on AIX, UDB, AS-400, ORACLE, Access databases, Excel, Flat Files, and XML. Create and modify ETL processes to accommodate changes in source systems and new business user requirements for EDW reports in Microstrategy.  Map source system data to EDW, and develop the staging areas, recoveries, data cleansing, fact and dimension tables, slowly changing dimensions, conformations, and use of surrogate vs. natural keys. Define and capture metadata and rules associated with ETL processes. Apply Data Warehousing theory and techniques.  Troubleshoot ETL job failures during regular business and after hours.  Use SSIS/DTS, T-SQL, PLSQL, Netezza SQL, Informatica Power center, SQL 2005 in 64 bit environment, SSRS and SSAS. Created SSAS project, identified data sources, cubes, dimensions, and mining model deployed to EDW databases, and SSRS utilizing EDW databases as the sources, troubleshoot the issues, and performance. Work responsibly together with the other team members to provide the success of the EDW/BI solution. Work with key members of various departments to determine the definitions of essential data. Provide quality and timely work for full customer satisfaction.
 DENTAL TECHNOLOGY EXPERTS - Chicago, IL   Oct 2008 – July 2009Performed MS SQL server 2005 32 and 64-bit, 2008 installations and upgrades, troubleshoot the issues, worked on improving the performance.  Applied patches, and implemented SQL Server 2005 Server failover clustering. Converted 16 large size digital X-Ray images databases to MS SQL 2005 EDW, involving database redesign, stored procedure changes, data conversions issues, jobs creation, used CA ERwin® Data Modeler r7.3, T-SQL, SSIS/DTS, SQL server Jobs. Created logical and physical data models and performed inventory of data objects and data quality assessment, using Embarcadero ER-Studio. Identified data sources, cubes, dimensions, and mining model deployed to EDW, using SSRS and SSAS, utilizing EDW as a source; Created ETL to load DW Stage, using Informatica Power Center 8.11 and PSQL Integrator to connect to different sources;Worked with management and programming team to ensure that deliverables are met on time, on target and on budget. Project: MORGAN STANLEY REIT TRUST - Chicago, IL   SR. DBA/Developer                                            Jan 2008 – Oct 2008Upgraded test, stage and production data environments from SQL Server 2000 to SQL Server 2005 64-bit, virtual servers, and maintained test, stage and production data environments. Managed the distribution, replication and archival of enterprise data. Maintained Clustered and mirrored servers, supported BACKUP and RECOVERY and created server’s jobs to alert team’s members by e-mail and pager to check on backups and space issues. Converted DTS packages into SSIS packages, using T-SQL, MS Access and SQL databases, Shell scripting, Informatica Power Center 8.11 to design ETL processes to load DW, and created stored procedures for SQL Server 2005 and Oracles 10i, 10G RAC databases to develop custom and dashboard reports for Intranet applications, using PSQL V8 and PSQL Integrator, T-SQL.        Designed and architected solutions using content management, portal, search, form services and custom code within the platform (Sharepoint Services 3.0 and Sharepoint Server (MOSS 2007). Provided administration and development to manage Intranet sites and applications for company staff and clients, and investigated and alleviated application related performance problems by resolving critical issues for 24/7 production environment’s support, and worked closely with management and with the programming teams, ensuring deliverables are met on time, on target and on budget.Project: FEDEX GROUND - Berlin, WI     as SR. Performance Analyst/DB Modeler                                    Jan 2007 – Jan 2008   Designed database objects, modeled data and created stored procedures and triggers for new FedEx Ground Security application, using CA Erwin and ER-Studio to create and maintain data models. Analyzed and troubleshot performance and storage usage for 3 Sybase 12.5.4, 12.9 and 3 Sybase 15.0 on AIX servers, 15 critical databases and applications, using BMC Patrol, DBArtisan, and SQL Backtrack, Rman, Sybase performance and tuning utilities, UNIX shell scripts, addressing Very Large Database (VLDB) issues and partitioning.  Project: AMERICAN MEDICAL ASSOCIATION - Chicago, IL     as   Sr. DBA/SQL Developer                  Oct 2005 – Dec 2006Created logical and physical data models using ER-Studio for CRM DW and DM (release phase 1 and phase 2). Deliverables included: inventory of data objects, data quality assessment data flow diagrams, data to process grid, data mappings and transformations, using Informatica Power Center 8.11 to create ETL to load DW. Performed DB2 UDB installation, implementation, maintenance, store procedures creation, performance issues resolution, backups, restores, etc.  on 3 production (100 GB, 60 GB, 10GB) DB2 UDB databases for CRM DW and DM, Business Objects databases, tests (100 GB, 60 GB, 10GB), and 3 development (100 GB, 60 GB, 10GB) databases with data ownership / stewardship responsibilities as well as data administration, data quality, data standards, audit and compliance, metadata definitions and use, performance and tuning, etc.   Tools: DB2 UDB Management Console (control center, command center, client, store procedure builder, etc), UNIX scripts, ODBC, CA-AllFusion Erwin Data Modeler, Rational Clear Case, Rational Rose, Web Sphere Studio, SQLJ, Informatica Power Center 8.11, ER-Studio. ACCENTURE LTD - Chicago, IL CONSULTANT/ DBA/ SQL DEVELOPER/ANALYST    Dec 2003 – Oct 2005 Project: Limited Brands DirectCreated logical and physical data models using ER-Studio for integration architecture during enterprise design phase, and helped to validate the feasibility and technical risk with the integration data architecture for costing purposes. Performed data modeling for Insight-Direct Project (Limited Brands, Victoria Secrets, Henry Bendel, etc), developed application design strategies, review inventory of data objects, and assess data quality.  Implemented SSRS and SSAS, created AS project. Identified data sources, cubes, dimensions, and mining model, deployed to EDW, and ensured Metadata quality, data standards, audit and compliance, metadata definitions and use.Deliverables included design data models documentation, data flow diagrams, and data to process grid, data mappings and transformations.  Prepared review analysis for client meeting, etc. Tools: CA-AllFusion Erwin Data Modeler, ODBC to Teradata Data warehouse, ORACLE 10G RAC Data Mart, Microsoft PowerPoint.  Project: LIBERTY Mutual – Odin     Created logical and physical data models using ER-Studio for ODIN CBP release (Liberty Mutual Underwriting Automation), inventory of data objects and data quality assessment., and was responsible for DB2 UDB installation, implementation, maintenance, store procedures creation, performance issues resolution, etc.  Responsibilities included data ownership / stewardship, data administration, data mining (data quality and data standards, audit and compliance, metadata definitions and use, performance and tuning, etc. Deliverables included data flow diagrams, data to process grid, data mappings and transformations. Tools: DB2 UDB Management Console (control center, command center, client, store procedure builder, etc), UNIX scripts, ODBC, CA-AllFusion Erwin Data Modeler, Rational Clear Case, Rational Rose, Web Sphere Studio, SQLJ.   Project: NEWMONT GOLD MiningProvided ESSBASE and MS SQL Server OLAP database support on ORACLE 10i  DW. Performed network connections and security issues support for Hyperion Financial Solutions, Hyperion Planning,  Hyperion Reports applications for global mining operation.Project: MUTUAL FUND BREAKPOINT - Wachovia Securities: Provided modeling of logical and physical design for trade remediation; created and populated the tables to aggregate the client base within the household. Worked with very large tables (40 mil), creating the indexes and triggers in DB2 UDB, Unix AIX, ODBC Connections, DB2 UBB Control and Command Centers, Embarcadero, ER-Studio, FTP, MS Access and SQL databases and created ETL and Data Cleansing scripts and stored procedures.   BLUE CROSS/BLUE SHIELD OF ILLINOIS           SR DBA/ SQL DEVELOPER/ANALYST                     Jan 2001 – Nov 2003Converted 2 large applications from Sybase 11.2 to MS SQL 2000, involving database redesign, stored procedure changes, data conversions issues, and implemented SQL Server 2000 Server failover clustering. Maintained test, stage and production data environments, managed the distribution, replication and archival of enterprise data.   Performed server installations and upgrades; troubleshoot the issues, worked on improving the performance, applied patches. Investigated and alleviated application related performance problems. Used MS SQL 2000 DTS and scripting, T-SQL, Sybase, T-SQL, MS Access and SQL databases, DB2 UDB SQL, ERWIN, Shell scripting, AIX UNIX scripts, COGNOS Reports.  Created and implemented DDL’s per client requests, and created server’s jobs to alert team’s members by e-mail and pager to check on backups and space issues. Worked within a team, providing 24/7 database application support for critical HCSC applications on 62 SQL Servers 2000 (251 databases), 3 Sybase 12.9 Servers, 3 DB2 UDB servers and 6 DB2 UDB 6.1 databases on AIX and NT.  DELOITTE AND TOUCHÉ TAX TECHNOLOGIES SR DBA/ SQL DEVELOPER/ANALYST                                 Jan 2000 – Dec 2000Designed Metadata Data warehouse for Web-based Tax Preparation Proprietary Software System, using  MS SQL 2000, Oracle 8i, DTS, ETL, Informatica, MS Metadata, Rational Methodology, Rational Clear Case, Rational Rose. Supported data analysis needs for North American, Canadian and Mexican Operations, utilizing MS SQL 7, 2000, T-SQL, Store procedures and triggers, DTS, OLAP, and Cognos Reports, building new datasets and data structures, performing database design, created stored procedures. Implemented and deployed Cognos and Web-based in-house software for New Technologies Division of the company. Established, managed, and monitored production, test / QA and development servers to support both systems, utilized ETL, DTS and OLAP, Informatica, Cognos Reports.  JOHNSON WAX                ERP Architect/ Database Warehouse                                                                                            Apr 1997 – Dec 1999Acted as team lead in charge of design and development of DW logistics and manufacturing,  performing subject matter interviews and data modeling for complete redesign of logistics and manufacturing systems, using ERWIN, ER-Studio, Embarcadero, DB2 and ADABAS on Mainframe. IBM CORPORATION as Consultant DBA/ SQL DEVELOPER/ANALYST                       Oct 1992 – Apr 1997As senior developer in 5 person development team performed database design, set triggers, created stored procedures for KIOSK Project, and received a special status as an IBM Partner in Software Development forKiosk@ an interactive visual sales catalog generator and order processing system, generating Web / Internet / Client-Server based catalogs from the existing database of client’s inventory. The software allowed processing the orders, taken over Internet and update the client’s database in real-time. Utilized DB2 UDB, AS-400, PowerBuilder, PL/SQL                 For KRAFT FOOD CONTRACT MANAGEMENT SYSTEM (as IBM Consultant)   constructed a special visual tool to help contract and account managers incorporate best business practices,  featuring extensive online                  Help that enhanced manager’s performance when signing new contracts and evaluating old contracts for performance and profitability.  Built the windows, menus, controls and data windows, utilizing PowerBuilder, SQL  Scripts and stored procedures, employed object-oriented techniques such as inheritance and encapsulation using Kraft framework, utilizing COBOL, DB2/SQL,ClCS, MVS TSO and MVS/JCL, UNIX Scripts, Tandem SQL to download data and ETL.For SEARS & ROEBUCK COMPANY on  Fashion Merchandising Barcode Project (as IBM Consultant)   performed coding and testing of the programs, utilizing COBOL, DB2/SQL, ClCS, MVS TSO and MVS/JCL, while working with the development team for this very critical application. Received an Award of Excellence from the president of Sears & Roebuck. For CNA Insurance Company FINANCIAL REPORTING system   (as IBM Consultant) performed troubleshooting to synchronize databases on Teradata Relational database, DB2 and IMS mainframe databases and SQL servers on the network.  Monitored download/upload jobs.  Analyzed and maintained production runs, utilizing DB2/SQL V7, CA-Platinum, BMC DB2, MVS JCL, TSO and batch, MVS/ JCL / ISPF, IBM Utilities, VSAM, IDCAMS, Endeavor, WSF2, CA-7, Omegamon/DB2, Omegamon MVS.  

Ask the Expert!

For free email business advice, send your questions, comments or ideas to ourname@ourcompany.com. For issues that are of particular interest to the the community, we may publish (with your permission) your questions along with our answers on this web site.

our technical expertise include:

Data Warehousing: ETL, ODS, MS SSIS/DTS, SSAS/OLAP, Netezza, Hyperion, SharePoint, Informatica Data Mart, Power Designer, Informatica Power Center, SA-designer, CA- AllFusion Erwin Data Modeler, ER-Studio, Embarcadero,Databases: SQL Server 2008, 2005, SQL Server 2000 SP3a, 7.0 SP 3, 6.5, Pervasive SQL 8.1, WATCOM 3.x, SQL Anywhere, DB2 UDB NT and AIX, Teradata, SYBASE 12.9, ORACLE 10iOperating Systems: Microsoft NT, LAN Network, Windows 2000, XP, UNIX HP &AT, IBM OS2/Servers and AIX, PC, PC DOSLanguages: T-SQL, PSQL, SSIS, SSRS, SSAS, OLAP, DTS, PL/SQL, Triggers and Stored Procedures, NET, VB.NET, MS SharePoint Server 2007(MOSS), Rational Rose, ClearCase, ClearQuest, SourceSave, PowerBuilder 6&7,8, PFC, Distributed PB, Web PB, Cornerstone Framework, Silverstream, XML, SQL, SAP ALE & RFC, SAP BW Legacy Databases: DB2/DBA; DB2/SQL V7; CA-Platinum, BMC DB2, ADABAS/DBA PREDICT, AS-400Legacy Operating Systems: IBM 3080, 3090x, XA, MVS JCL, TSO and batch, OS/ DOS/ VSE/MVS/ESA, OS / JCL / ISPF, IBM Utilities, VSAM, IDCAMS, Endevor, WSF2, CA-7, Omegamon/DB2, Omegamon/MVSLegacy Languages:  COBOL, CICS Command, DYL280, SAS, EASYTREIVE, ADABAS/ NATURAL 2, RPG and Assembler

 

Abstract still life w/ two clocks

Join Our Mailing List!
By joining our mailing list, you will be the first to know about:
  • Breaking news about our business
  • Helpful tips
  • Exclusive special offers
To join, type your email address below and then click the Go button.

We are proud members of the following organizations:

Replace with an organization logo