Information Architect
EIM
مجموع سنوات الخبرة :28 years, 10 أشهر
Ohio Integrated Eligibility and HHS Business Intelligence Project
HHB 153 gave the Governor’s Office of Health Transformation (OHT) the authority to simplify Medicaid eligibility systems. The Mid-Biennium Review (MBR) legislation will clarify that the authority granted in HB 153 extends to eligibility systems for federal and state health and human services programs other than Medicaid. This change will allow Ohio to create a single eligibility solution and seek enhanced (90/10) federal funding to upgrade eligibility and enrollment functions for other federal entitlement programs. The Statewide Data Sharing Project was established to develop business and technical standards to integrate information across all of the state’s health and human service systems to support integrate eligibility operations, as well as aid the State’s ability to departure from the agency-centered solutions of the past.
Role: Enterprise Information Architect
Responsibilities:
Participating in the development of the requirements, principles, models and designs for the future-state EIA, as well as the documentation (at the appropriate level of detail) of the current state EIA and working with State agency enterprise architects to develop road maps for the orderly transition to the future-state. Overseeing the implementation of EIA through the organization's enterprise information management (
Netezza 2 Teradata Migration Project
Netezza 2 Teradata Migration Project is part of the innovative Data Initiative for the business to consolidate the Netezza systems on to a newly upgraded Teradata Platform, which will reduce the redundancy and complexity in the analytics environment and allow for flexibility and agility. This will also significantly improve the system capacity and performance. This involved consolidation and migration of hundreds of Terabytes of Netezza databases, data loading programs, analytical and reporting applications, to the Teradata Platform.
Role & Responsibilities:
Team 45
As a Teradata Application Architect I was involved in the migration planning and execution of the "Shop Your Way Rewards (SYWR) Data Marts and Reporting" application.
Responsiblities includes but not least to the following,
•Gather and document migration requirements and translate these into process and system architecture designs.
•Understand the migration business goals, IT plans and architecture and articulate linkage to the proposed data warehouse migration architecture and application designs.
•Provide technical thought leadership and actively participate in the application design, implementation, and roll-out efforts as a Teradata Architect and SME.
•Demonstrating ability to relate business problems to the underlying data and the ability of Data Warehouse technology to solve the business problems
•Understanding, documenting and articulating the Sears HC current data warehouse/data mart architecture. This includes a complete inventory of the Sears HC data warehouses and DataMart’s as well as their respective business functions
•As a Teradata SME, working on the Performance optimization approaches and fine tune the scripts.
•Working with the DBA’s to define the PI, PPI’s and SI’s along with the strategic approach of collecting the STATS on the application tables.
•As a Teradata SME working with the team to develop and create the templates for the Team to work on the same as - is for the conversions and responsible in resolving any business case related issues to satisfy the business needs and not deviating from the existing logic during the conversion along with the technical coding issues
•Working with the application development team to get the converted code to optimize, test and migrate into the production.
ETV-Data Warehouse
ETVDW is a warehouse platform for the SATV Application Software products and third party products. The Warehouse provides centralized repository designed to facilitate the standard reports and custom reporting Analysis giving operators a reliable, consolidated, unique and integrated reporting and analysis of its data.
Team of 14
Roles & Responsibilities
•As a DWBI Architect I was responsible as facilitator to all the teams Development, System Integration, QA and Product Management.
•Also I was responsible to develop and organize the project tasks to track the developments and accomplishments.
•Main responsibility as a DWBI Architect is to ensure the complete requirements understanding and the developments progress with the team’s progress to ensure the objectives were met as per timelines.
• As a DWBI architect I was primarily responsible on the requirements clarifications and to find any gaps by doing all requirements scrub all the time and radiate the information to ensure the product management and customer understands the requirements and confirm the development team on the changes/enhancements on the requirements.
•Also responsible to get the complete development and testing environments ready for the dev and qa teams to perform their tasks without any impediments.
•As the project is of very agile in nature the requirements were changing fastly and new enhancements were added, the project though started in a waterfall mode, because of its nature of quickly adding changes and enhancements it was actually managed in Scrum method so that all the requirements were handled as per the priority.
•Facilitated with weekly three status meetings with the team and the product management to make them available and track the status of the developments and meet the release goals.
•With the Scrum experience worked on the requirement stories and worked with the product management to prioritize and update and track the stories in the ACCEPT tool.
•Working on any changes to the plan or the requirements with the product management to have an impact analysis and get them into an agreement and sign off’s with the business.
EQP Projects
The Enhanced Quality Program (EQP) in Quest Diagnostics is a collection of projects aimed at the company’s continuous improvement goal of enhancing the quality of patient care.
Projects Handled:
BU Datamart (Team of 6)
Roles & Responsibilities:
•As a Scrum Master and the project manager I was responsible to facilitator for both the Product Owner and the team.
•Primary responsibility as a scrum master for this project is to radiate the information or ensure that the team’s progress and successes are highly visible to all stakeholders, including team itself, product owner or business partners through various forms of scrum artifacts like Backlogs to Burndown and Daily stand-up meetings.
•Facilitating the empowerment for the team with 15 - 30 minutes sprints stand-up meetings by ensuring the product owner and business partners to making them available at all the points to build the confidence to meet the sprint goals.
•Ensure the team is fully functionally and productive
•Ensure that the process is followed including invitations, approvals, daily scrums, sprint reviews and sprint planning.
•Also as a project manager I was responsible for the deliverables of this project.
•I worked directly with the internal customers to understand the business and the product requirements. I documented my findings and created the backlog for the project and got it prioritized the stories identified by the Product owner.
•Scrum team worked on the backlog stories and gave the shirt SIZING and the commitment with a fist of five on the sprint goals to ensure that they were achieved.
Patient Distribution (Team of 8)
Roles & Responsibilities
•Develop and maintain the project plans for the rollout of the release.
•Working with the business partners to understand the product requirements and converting the functional requirements into stories and work with product owner to prioritize them.
•Ensure the process is followed with the release, sprint, Demo/Retro and release retro invitations following up with the email on the acceptances for the committed deliverables at each sprint with the business partners.
•Ensure the team is fully functional and productive and remove any hindrances are roadblocks to their productivity.
•Working on any changes to the plan or the requirements to have an impact analysis and get them into agreements and sign off’s with the business.
•Ensure the smooth User acceptance and signoff’s and code reviews and approvals as per the tollgate check list for migrations to one env to another. (DEV/QA/PROD).
Positivity Rate Distribution Program (Team of 4)
Roles & Responsibilities
•Creation of the project charter with the requirements for the application creation
•Creation of the project plan, backlog and getting them approved and signed off on the documents to proceed with the project developments.
•Working on the designs of the application reports and getting it reviewed by the customer and get the approvals to proceed with the development.
•Co-ordinations with the other teams like infrastructure and facilitating the meeting to clarify the concerns and the requirements to get the project infrastructure, Database, and security requirements are met for the project goals.
•Code reviews and checklists were created for all the deliverables at all the identified tollgates at each deliverable of the sprints.
QDSS CAP Proficiency Testing (Team of 8)
Roles & Responsibilities:
•Creation of the project plan, release plan and sprint planning.
•Conducting Release, sprint and scrum meetings to ensure the project status on track and providing the updates to the business partners.
•Helping the business by closely working with them to identify the business requirements and converting it into a project by creating a prototype and getting a buy-in from the business to convert it into a large project to deliver.
•Development of all the scrum artifacts for the project like release planning, sprint planning, backlog, burndown and demo/retro meeting and release retrospective meetings.
•Due to highly complex nature of the data nature need to have a close interaction with the business team and development team to ensure the project requirements are meant.
•Facilitating meetings at every milestone with the team and Business and co-ordination become key for the success of the project.
•Got highly appreciated by the higher management at organizational level for the work done on the project.
PACE - Informatics - QDIB Setup (3 teams involved with Informatics (team of 5)
Roles & Responsibilities
•Develop and update project plans for the roll out in Agile Scrum methodology.
•Work with technology teams to ensure that infrastructure requirements and technical dependencies are well understood and meet project objectives.
•Manage schedule and scope.
•Prepare project status reports by collecting, analyzing, and summarizing information and trends with daily scrums and the reporting to the stakeholders in every project manager meet.
•Coordinate recruitment and selection of project personnel.
•Direct and coordinate activities of internal project personnel, business departmental teams, technology resources and external vendors.
•Establish and execute project communication plans.
•Initiate, review, and communicate modifications made to project plans.
•Monitor and track project milestones, issues and risks
•Schedule and facilitate meetings.
•Manage all project documentation and backlogs.
•Confer with project personnel to identify and resolve problems.
•Monitor the performance of project team members.
•Ensure that project deliverables are submitted and that quality standards are consistently met.
Automated PRDP Reports (Team of 4)
Roles & Responsibilities:
•Responsible for developing business intelligence solutions and supporting data warehouse processes as Business Intelligence Architect for enterprise reporting.
•Provided overall reporting solution foundation for the development, implementation, and operation of BI solutions.
•Support and enhance data warehouse and ETL processes.
•Develop SQL queries to identify and resolve data issues.
•Work with users to gather and document requirements for system enhancements.
•Provide Oracle, Datastage, Cognos expertise and guidance to the team.
•Develop database models to satisfy reporting requirements.
•Responsible for the UAT of reports in Cognos 8.4.
•Strategically plan and deploy Products for the enterprise reporting.
•Insure internal customers are delivered the highest quality IT products and services.
•Responsible and accountable for internal control performance within their area of responsibility.
ETL BI
Team Lead for overall production support and delivery manager for the BI support.
•Managed GDC Production Support team for the GEHC ODS Modules.
•Client Interaction for various levels of ODS Support
•Overall team co-ordination and technical issue management.
Environment: Teradata, Informatica, Oracle
GEHC BI Architect for ERP07 Project
GEHC is deploying Oracle ERP suite in Russia and requires an interface to the local software package 1S. The 1S system would help Russia GEHC to meet its statutory reporting needs. The interface would move the transactional and financial data from GLA/BO Teradata to the 1S system. Today no such interface exists and Russia uses its local system to meet its reporting needs. To increase visibility and merge with global design, ERP07 project would bring Russia on common ERP oracle platform. This interface would then help them move transactional data to 1S that is critical for local statutory needs.
Responsibilities:
•Managing the BI end for the ERP deployment as an Architect and also as BI Manager for the Project.
•Providing End to end BI Solutions and getting the approval from all the Stake holders to get the project moved from one milestone to another as part of the GEHC Process
•Developed testing strategy and base line test cases to meet critical success factors for the project.
•Working as the coordinator between the for various teams and at various levels of the Project
•As a BI SME and Architect worked as a knowledge bridge between BI Environment and the ERP Project team and was instrumental in the kick off.
•Overall team co-ordination and technical issue management.
Environment: Informatica, Sql Server, Teradata
GECF - CFI Hyperion Implementation
Responsibilities:
•Onsite coordinator, team lead and senior staging resource in this project, owning databases and responsible for all database related activities.
•CFI has three environments Production, Development & QA for all of its databases. Managed and reported to IT Architect and manager Infrastructure.
Environment: CFI Hyperion Implementation, ETL - Informatica
GEHC OPERATIONAL DATA STORE
GE Healthcare is in the implementation stages of a revised architecture of BI system. The older architecture had the data movement from Source directly to EDW. In the new architecture, the data movement is through one more layer called ODS refining the data which goes to EDW. Testing newly developed ODS data warehouse and reporting universes.
Daily and Hourly Loads of various sources having storage requirements of production data warehouse is 900 GB with 250 GB of data in cubes
Responsibilities:
•Managed GDC Development team for the GEHC ODS Modules.
•Managed test services - provided common team to all modules
•Developed testing strategy and base line test cases to meet critical success factors.
•Team Interaction for various levels of ODS Project
•Improvement on various internal tools used for Project specific testing - Performance testing, query creation, data validation, load metrics.
•As a SME worked as a knowledge bridge between testing and ODS Project team and was instrumental in the kick off.
•Overall team co-ordination and technical issue management.
Environment: Teradata, Informatica, Mercury QC
Maxtor EDW
Responsibilities
•Gathering business level requirements, driving ASR (application Service Requests) in all stages to completion.
•Coordinating with both offshore and onsite teams.
•Planned and Coordinated production deployment of ASR’s.
•Experienced in 24*7 Production Support of the DW and ensure to meet the SLA of the support.
•Reporting weekly to the Client and higher managements on the metrics captured on the support activities for any Effort Variance and SLA Variance.
I was involved since initiation of project, proposal building, project planning and scheduling, defining offshore migration approach for customer buying, implementation of offshore migration and achieving steady state. I visited client site for comfort building with client during initial period of project and for overall project coordination on program level. I am playing a role of designated project Lead for overall project and delivery manager for ETL and DW piece or project.
As a Lead and Developer for the development of ETL Process of HEDW, Working with EDW Team and the Source System experts to Understand the Source Systems (Prepaid) and Other Source systems(Postpaid and MCDR’s) data. Analyzing the data for data quality using Teradata utilities like Teradata Warehouse Miner. As a part of Transformations Business rules and Transformation logic is imposed using utilities like BTEQ and as a loading procedures followed different strategies for different type data and its availability to load into the Warehouse.
All the Transformation part is done in Staging area. Initial Load is done using load utility Fast Load and for the incremental used BTEQ.
Projects
AutoSMT
Oracle 2 Teradata Forklift Migration
O2T project requests migration of the client Oracle Data Warehouse to the new Teradata platform. The primary benefit to BI group is improved availability - Stabilization of the DWP infrastructure with world class business intelligence tools, increased availability of data, and better reports - with stable query and load performances.
The primary technical challenge in current environment is unstable infrastructure which is critical to BI and user communities.
In the new environment Teradata will conduct the planning-analysis-execute-deploy activities, in an “as-is” forklift of the DWP and data migration.
Forklift Migration is essentially a re-host of the current DWP environment and underlying data. It is defined by the following steps:
•Creation of identical versions of the Oracle tables on Teradata while converting incompatible data types.
•Copying of historical data from the Oracle tables to the Teradata tables.
•Conversion of the current Oracle ETL processes in Informatica to instead load Teradata.
•Conversion of Database Procedures and Triggers, where applicable, to Teradata.
•Conversion of related Oracle SQL, Dynamic SQL, and PL/SQL to equivalent Teradata SQL.
•Migration of the BI universes to work against the new Teradata environment.
•Verification that all public user reports function in the new environment, and support user acceptance testing.
•Development of a basic backup and recovery process for the new environment.
•Unit and System testing to ensure that the migrated systems function correctly in the new Teradata environment, prior to user acceptance testing.
•Merge of selective required critical changes to production code made during the Forklifting
•Replication of the final solution for consistency across the four environments: Development, UAT, QA, and Production
Role & Responsibilities:
Team of 25
•As an Architect I was responsible for the ETL Migration Design and Development and BO Migration and Development.
•As a Technical Lead, responsible for the complete Conversion Process and migrations to PROD and other Non-Prod Environments
•Responsible for all the documentations related to the Migration Process, which involves the Migration FBTR Document, EDW Architecture Document, ETL Design Document, BO Design Document, and Testing Strategy Document.
•Responsible for the complete inventory to create the Gold Copy for the Migrations as per the use cases developed during the due diligence.
•As a Technical Lead, the complete ETL and BO Conversions, testing UT, E2E and ST are responsible and getting approvals from the SME’s so that the converted code to Migrate to PROD environment for the UAT.
•Not exactly as a Scrum, but the complete conversion, Testing and Migrations were done as Scrum with the Daily Stand-up calls.
•As a lead used to develop and create the templates for the Team to work on the same as - is for the conversions ad responsible in resolving any business case related issues with the logic or any technical issues.
•Responsible for the stake holder and business related meetings along with the daily scrum meetings with the Team.
•Also responsible for the In-flight changes to capture from the Client and merge into the converted code and ensure the changes are reflected in the current converted code for the UAT ready.
Creation of databases design dimension and fact tables, Development and Production. Creation of roles, profiles and frequent modification to user accounts, Creation of schema objects, granting of roles and privileges to the users and set-ting default table spaces,
Temporary table spaces, Planning and Troubleshooting of Rollback Segments
Environment: Informatica with Data Warehouse
Nestle Globe - Nestle Globe DC/ETL - Localization
Responsibilities:
•Review of Functional Spec’s! And raising issues for any clarification.
•Writing Technical Specifications and sending it for approval
•Construction and development of mappings based on Technical specification.
•Running the construction to ensure a successful data conversion and loading based on UTP’s.
•Documenting the Object including the mappings, reusable transformations, tables etc.
•Based on CHR’s changes to be made in Technical specs and Documents and according to CHR changes in development.
•Developed and constructed two objects.
responsible for the following.
•Responsible for Oracle Database (Production and Testing), and related issues installed and configured Oracle8i /server.
•Database capacity and growth planning, Installation and upgrades
•Creation of new instances for production, Development, Testing and Training Services.
•Regularly monitoring and responsible for performance tuning.
•Responsible for backup and recovery strategy
•Applying patches for application requirements.
Computer