Design, develop and deliver large-scale, complex Data Warehouse and Business Intelligence / Analytic solutions across multiple verticals to help companies achieve high performance in business.Services Include:● Design data architecture including framework, principle, guideline and template to guide the delivery team realize an optimized solution● Designing and implementing cloud-based Data solutions● Design the detailed data architecture includes data governance, master data… Show more Design, develop and deliver large-scale, complex Data Warehouse and Business Intelligence / Analytic solutions across multiple verticals to help companies achieve high performance in business.Services Include:● Design data architecture including framework, principle, guideline and template to guide the delivery team realize an optimized solution● Designing and implementing cloud-based Data solutions● Design the detailed data architecture includes data governance, master data strategy, master data management, data quality, data modeling, ETL approach, data storage etc.● Design optimal data warehouse and analytics solution to fulfill the business/technical requirement.● Develop business intelligence and data management solution plan. The solution plan includes requirements, solution design, estimation, project plan and implementation considerations● Identify the gap between business requirement and data architecture and propose solution to resolve or shorten the gap.● Shaping and leading large-scale analytics project full lifecycle implementation activities.● Engage with client deeply at all levels● Remote/Virtual – Corp-to-Corp Show less

● Creating security plans and implementing security in Cognos Connection. ● Data Modeling using Visio and Framework Manager ● Database Maintenance including Indexing and Performance Tuning ● Design and develop custom reports using Report Studio. ● Design and Develop Dimensionally Modeled Data Warehouse using Kimball methodology ● Design and Development of Cubes using Transformer, TM1 and Dynamic Cubes, including developing scripts to schedule the cube builds. ● ETL… Show more ● Creating security plans and implementing security in Cognos Connection. ● Data Modeling using Visio and Framework Manager ● Database Maintenance including Indexing and Performance Tuning ● Design and develop custom reports using Report Studio. ● Design and Develop Dimensionally Modeled Data Warehouse using Kimball methodology ● Design and Development of Cubes using Transformer, TM1 and Dynamic Cubes, including developing scripts to schedule the cube builds. ● ETL Development using IBM/Cognos Data Manager and SQL Server Integration Services (SSIS) ● Requirements gathering with Business Users used to design custom solutions including enterprise data warehouses, reports, dashboards and cubes. ● Training end users in the Cognos tools and the solutionsClients Include:Clark County Department of Family Services (DFS)FF Properties LPGM Financial, Inc. AmeriCreditIdeal IndustriesLyons Township High School DistrictSkinMedica, an Allergan CompanyState of Mississippi Department of Human Services Show less

Requirements gathering with Business Users used to design custom solutions including enterprise data warehouses, reports, dashboards and cubes. ● Data Modeling using Erwin, Visio and Framework Manager ● Design and develop custom reports using Cognos ReportNet and Report Studio. ● Responsible for database and query/report SQL Optimization and tuning. ● ETL development and deployment using Data Manager, Decision Stream and DataStage. ● Design and Development of Powerplay Cubes… Show more Requirements gathering with Business Users used to design custom solutions including enterprise data warehouses, reports, dashboards and cubes. ● Data Modeling using Erwin, Visio and Framework Manager ● Design and develop custom reports using Cognos ReportNet and Report Studio. ● Responsible for database and query/report SQL Optimization and tuning. ● ETL development and deployment using Data Manager, Decision Stream and DataStage. ● Design and Development of Powerplay Cubes using Transformer, including developing scripts to schedule the cube builds. ● Creating security plans and implementing security in Cognos Connection. ● Training end users in the Cognos tools and the solutions created for them.Clients IncludeAdvent Software Inc.Affymetrix Electronics for ImagingGilead SciencesIdeal Industries IncLeapFrog EnterprisesNetGearNUMMIPapa Charlie's IncPeet's Coffee & TeaRiver Ranch Fresh Foods LlcSephoraUS Air Force Show less

Designed, developed and deployed database information systems in a team-based environment using technologies such as MS Access, Visual Basic, Oracle and SQL Server. ● Working with clients to support and enhance the productivity of database information systems. ● Assist in development of methodology for the ongoing assessment of database performance, identification and resolution of conflicts arising over the creation, control and use of data and the development and enforcement of… Show more Designed, developed and deployed database information systems in a team-based environment using technologies such as MS Access, Visual Basic, Oracle and SQL Server. ● Working with clients to support and enhance the productivity of database information systems. ● Assist in development of methodology for the ongoing assessment of database performance, identification and resolution of conflicts arising over the creation, control and use of data and the development and enforcement of database use guidelines. Show less