We provide IT Staff Augmentation Services!

Senior Edw Bi Architect Resume Profile

Las Vegas, NV

Summary:

  • 13 years of IT experience that includes various fields of Information Technology related to Healthcare, Gaming, Casino/Hospitality Industry, GIS, Grant Management and Web Development.
  • Strong knowledge in EDW Architecture, VLSD, ETL processing, BI Reporting Tools and Master Data Management.
  • 10 years of experience with Business Intelligence Development Studio, SSIS, MS Reporting Services 2005/2008/2012 in SQL Server 2005/2008/2012
  • 2 Years of experience in Master Data Services 2008/2012, Data Quality Services 2008/2012
  • 10 years of technical proficiency in Business Intelligence and Analytical tools like Precision.BI, Cognos Powerplay, Cognos Transformer, Tableau 8.0, Active Reports, SSAS, SSRS, Crystal Reports and Epic Clarity,
  • 10 years of technical proficiency in healthcare applications like GE/IDX, EPIC PM/EMR, Siemens, NextGen, Athena, EMDEON, Clinical Systems, HL7 interfaces and other areas of healthcare industry.
  • 6 months of experience in Gaming Industry data ATI, CMS, LMS .
  • 6 months of experience in GoldenGate Replication tool.
  • 10 years of Dimensional Data Modeling experience using Data Modeling, Star Schema/Snowflake Modeling, Fact Dimensions tables, Physical Logical data modeling, Erwin 4.0/3.5
  • Strong database experience using SQL, PL/SQL and Transact-SQL.
  • 5 years of experience in Cognos BI tools like ReportNet, 1.0/1.1, Cognos 8.2 Framework Manager, Query Studio, Analysis Studio, Report Studio, DMR Models and Transformer Cubes
  • Excellent understanding on Bill Inman and Ralph Kimball Data Warehouse models.
  • Capable of delivering optimized, effective and well documented code independently.
  • Extremely dedicated, self motivated, Pro-Active and willing to assume responsibility.
  • Efficient in SQL Server 2012/2008 R2/2005/2000, Teradata and Oracle Administration.

Programming Languages

C, C , Java, Visual Basic 6.0/5.0, VB.NET, C , T-SQL, PL/SQL, Mumps, LISP

Scripting Languages

VB Script, Java Script, Perl and CGI.

Operating Systems

Windows XP/2000/95/3.1/NT 4.0, Solaris 8, Red Hat Linux SVR4 and MS DOS.

Web Technologies

HTML, DHTML, XHTML, ASP, ASP.NET, XML, XSL, XSD, CSS

Servers

Internet Information Server IIS 5.0 , Apache Web Server, Windows NT/2000/2003, AIX, HP/UX

RDBMS

SQL Server 2012/2008/2005/2000/7.0, Oracle 9i, Teradata Administrator, Teradata SQL Assistant, MS Access 2000/97, Paradox, Sybase, FileMaker Pro

Business Intelligence Tools

Precision.BI, Cognos 10 BI Series, Cognos 8.4 BI Series, Cognos ReportNet 1.1/1/1, Cognos Impromptu 7/6, Powerplay Transformer7.x/6.x, Cognos Access Manager, Business Intelligence Development Studio SQL Server 2012/2008/2005 , SSIS 2012/2008/2005, SSRS 2012/2008,2005, SSAS 2012/2008/2005, SQL Server BISM, SQL Server Power Pivot, SQL Server Power View, SSAS Tabular Model, SQL Server 2012 Data Quality Services, SQL Server 2012 Master Data Services 2012.

Technology

ActiveX, RDO 2.0, ADO 2.5, OO4O, ADO.NET, MS runtime scripting, MS File system objects, COM and COM .

Other Softwares/Tools

Seagate Crystal Reports 8.5/6.0, Oracle Application Server, Oracle utilities primarily SQL Loader , IDX Systems BAR, PCS, Analyzer, MCA, AVM, HPA, TES, DBMS , Erwin, Opalis Robot, Cold Fusion, Macromedia Flash MX, Fireworks MX, Free Hand MX, Dream weaver MX, Adobe Photoshop, MS Visual Studio.NET, 6.0, MS Office Suite, MS Visio, IBM Rational Rose, MS Project

Industries

Medical Billing Practice, Casino/Hospitality, Management, Medical Insurance, Ecommerce, Web Solutions, ISPs/ASPs, Credit/Financial Services, Non-Profit Management, Charitable Foundation/Grant Management, Construction Transportation, Geographic Information Systems

Work Experience

Confidential

Senior EDW BI Architect

Responsibilities

  • Worked as a EDW BI Architect for the transition of EDW databases from Teradata to SQL Server 2012.
  • Worked on generating dimensional data models for Player Ratings, Hotel and Reinvestment data. Legacy systems included ATI Aristocrat Technologies , LMS Lodging Management System , CMS Casino Management Systems and MGT Micro Gaming Technology . Erwin was used for modeling layout.
  • Created ETL SSIS Packages in SSIS 2012 to perform the data loads from staging to EDW database.
  • Worked on GoldenGate Replication setup for replication of source to the staging database.
  • Worked on Teradata database to maintain the stored procedures, changes to the data models, trouble shoot the daily load perform extraction sets for BI reporting.
  • Worked on setting a MDS Master Data Services model for the business users to control the master data.
  • Setup ETL data feeds from source to MDS database and moving the MDS data to EDW database.
  • Worked directly with business users to setup EDW Views which were used in Tableau for the BI reporting.
  • Worked on Master Data Management project to standardize the gaming data player names, addresses, master data tables and generate a golden record in each entity.
  • Created complex stored procedures, triggers and scripts for the transformation of legacy system data into EDW database.
  • Worked on Data Quality Services project to setup validation routines which tied back the data between source, staging and EDW databases. Setup SSIS packages to run as part of daily delta loads to perform DQ checks and generate SSRS reports with validation results.

Confidential

Lead Data Warehouse/BI Architect

Responsibilities

  • Mentoring other architects with the best practices and engineering better data modeling concepts. Mentored and trained project team members in the implementation and use of latest data warehouse tools and methodologies.
  • Technical project manager and data architect for Data Conversion, Data Quality, Data Migration, and Data Warehouse projects associated with the various clientele of Precision.BI.
  • Working with the ETL Modeling using SQL Server 2012/2008/2005's Business Intelligence Development Studio
  • Responsible for the design, building, testing, and documentation of an Enterprise Data Warehouse integrating several source system schemas. Designing and implementing the ETL process using several staging schemas and an Operational Data Store for reporting using Precision.BI.
  • Reviewed and assessed all major database designs for implementation feasibility, ensuring that data structure aligned with business goals, intended use, and flexibility of design.
  • Translated business requirements into implementation process by considering all alternatives and implementing the best strategy to ensure design meets performance, usability, reliability and scalability requirements.
  • Lead the process of automating the data modeling process using templates and SSIS data flow tasks.
  • Worked on creating data models for various healthcare systems like GE Flowcast/GPMS, Siemens, NextGen, EMDEON, Athena, GPMS and EPIC.
  • Developing SSIS packages to perform complex data transformations, data cleansing and high volume lookups.
  • Worked with Slow Changing Dimensions to handle history to multiple attributes in a given dimension.
  • Handling the E Extraction , T Transformation and L Loading parts of the data to setup dimensional data model in SQL Server 2000/2005/2008/2012 for Precision BI reporting tool.
  • Managing cases from end users through customer support module for Precision.BI
  • Creating business logic using stored procedures, triggers, functions, database constraints and scripts
  • Understanding Healthcare Standards data for Business logic ETL implementation.
  • Creating complex stored procedures, triggers and scripts for the transformation of legacy system data into Precision BI's reporting database.
  • Worked on Ralph Kimball Methodology of Dimensional modeling to identify Facts and Dimensions.
  • Worked on Archiving/Purging large databases at different client sites to improve the performance of ETL loads.
  • Wrote stored procedures to drop and recreate indexes for efficient loading.
  • Maintained warehouse metadata, naming standards and warehouse standards for future application development.
  • Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design Star Schema and maintenance.
  • Perform Incremental loading.
  • ETL administration ensuring that existing jobs complete on time and checking for error.
  • Created and maintained ETL technical documentation.
  • Training end users on the reporting tool and technical functionalities.
  • Created List Reports, Cross Tab Reports, Drill Through reports and Custom Reports using Precision BI.
  • Performing Database Maintenance Plans, Disaster Recovery, and Backup/Restore of the databases as part of the tool maintenance at different client locations.
  • Creating various DTS packages in SQL Server 2000 to bring in data from different data sources and incorporate them with the Precision BI's reporting database.
  • Perform the installation and configuration of the Relational Database Management System, Keep the Logical and Physical data models synchronized, Generate the Physical database design for the data model, Monitor Database Performance, Database tuning, SQL tuning in combination with end-user query tool tuning, Resource control in the DBMS, Database reorganization, Implement database security which determines access to the databases, Responsible for distributing data and deploy distributed databases, Perform database backup/recovery, Enforce data integrity where necessary, Gather application and business requirements for data storage systems, Deal with performance, usability and productivity issues.

Confidential

Programmer Analyst II

Responsibilities

  • Developing custom reports and routines related to patient and physician information for the clients using Mumps Programming.
  • Monitoring the daily extraction process of the IDX legacy data into SQL Server 2005 using Opalis.
  • Developing reports and queries for the clients using Cognos Impromptu and Powerplay.
  • Developing data cubes and model files using Cognos Transformer as part of a team.
  • Writing Stored Procedures/SQL queries in SQL Server 2005/2000/Access as part of building cubes.
  • Created Data warehouses in Star Schema Dimensional Model for the Business Intelligence Reporting in Cognos.
  • Perform the installation and configuration of the Relational Database Management System, Keep the Logical and Physical data models synchronized, Generate the Physical database design for the data model, Monitor Database Performance, Database tuning, SQL tuning in combination with end-user query tool tuning, Resource control in the DBMS, Database reorganization, Implement database security which determines access to the databases, Responsible for distributing data and deploy distributed databases, Perform database backup/recovery, Enforce data integrity where necessary, Gather application and business requirements for data storage systems, Deal with performance, usability and productivity issues.

Confidential

Application Developer

Responsibilities

  • Developed application, Project Manager , for Soils Foundations Department to maintain global data.
  • Application used VB.NET as front end and was developed for both MS Access Database and Oracle 9i Database as back end using ADO.NET for database connectivity. Used ADOX component to create MS Access Databases dynamically.
  • Used various COM components and Interop Assemblies as part of User Interface Design.
  • Application was connected to Intergraph, Inc. designed applications like Logplot 2001, Rockworks 2001 and Geomedia, a Geographic Information System based application.
  • Analyzed the data from Oracle Database used for Project Manager in Geomedia by plotting the coordinates and generating images. Used spatial filters and queries to manipulate the data.
  • Designed software presentations in Macromedia Flash MX using Macromedia Fireworks and Macromedia Freehand.

Confidential

Software Analyst

  • Worked on Raiser's Edge Fundraising Software, which included maintaining Parent Information, Gift Giving.
  • Responsible for printing reports, querying database and updating the University alumni information.
  • Created forms and reports in MS Access 2000 for the alumni department.
  • Prepared Logos and presentations using Macromedia Flash MX and Adobe PhotoShop.

Hire Now