Confidential

Solutions/Data Architect

Responsibilities and Key Successes

• Created and maintained Solution Architect Document including service integration diagrams, logical data diagrams, conceptual ER diagrams and logical infrastructure diagrams.
• Worked as Data Architect on Oracle 11G DataStage 8.5 upgrade projects currently working on DataStage server upgrade project.
• Providing architecture guidance as part of the the Rx Pharmacy Architecture team and a review board member.
• Design data solutions that are scalable and flexible to meet future state Business requirements within supported business areas.
• Maintain metadata repository and data catalog, and keep track of data lineage.
• Participated in project design reviews, and extract/translate/validate data requirements from various project lifecycle work products and resources.
• Re-Engineered the Formulary management in the 340B Government mandated discount program applications.
• Involved deeply in identifying and finalizing PROS solution for forecast modeling of prospective clients for 340B program.
• Identify and analyze business requirements to implement/update Critical Data Elements according to Data Standards.
• Partner with business analysts, other developers and business partners, and production support teams to provide guidance on business element technical and architectural impacts.
• Worked on POC for implementing Hadoop solution for 340B program.
• Defining and implementing the Data Archival process for 340B program.
• Design analytical DataMart to decouple analytics from the exiting transactional Database and working on building dimensional Data Model with Star Schema.

Environment: Visio, Erwin, Oracle, DB2, DataStage, PROS, Informatica, Hadoop

Confidential

Sr. Solutions Architect - Data

Responsibilities and Key Successes

• Worked as ETL/Data Architect to implement the MDM for CUSTOMER , SUPPLIER , ITEM and RMI Raw Material Inventory dimensions and maintain the Golden De-Duplicated Data in to the EDW.
• Used ERWIN as modeling tool in Dimensional Data modeling Star/Snowflake with the EDW Stage and base environments with the implementation of MDM for Suppliers and Customers.
• Partnered with the Application Lead, Development Lead, and System Designer in application and transaction design.
• Partnered with the Data Architects of the other Source systems to realize the overall data architecture vision.
• Ensured data deliverables are created for the project conceptual model, logical model, physical model, data flow diagram, data topology, data mapping, detailed data access design.
• Ensured all SQL go through reviews and that the correct procedures are in place and team members understand their responsibility as reviewers.
• Deeply involved in communicating with DBA's on physical database design.
• Deeply involved in Data Architecture Governance Process, decision Making, Escalations, Stakeholder communication, Blueprinting and documentation etc..,
• Involved in Defining Source Data Integration Mechanism and involved in reviewing Data mapping between Source and Existing EDW Entities.
• Involved in defining and preparing EDW Framework to implement the MDM and integrate the Golden De-Duplicated Master Data in to the EDW.
• Designed and implemented the Re-usable component to build the Cross-reference between Master De-duplicated Entities and Existing EDW Master Entities.
• Designed and implemented the re-usable component to maintain and manage the Survival and Victim records of the Master data with Auto Manual Merge process that is done through MDM. Also made sure the Survival accounts are updated accordingly in to the respect Fact AP, AR etc.., transactional tables.
• Used the Appworx for scheduling the ETL mapping jobs.
• Involved and contributed in designing the Process control Framework in the ETL architecture.
• Involved and Lead in creating reusable and non-reusable Mappings and Mapplets using Filters, Aggregators, Lookups, Expression Aggregator, Sequence generator, Joiner and Update Strategy Transformations
• Involved in design and lead the Development of Custom Mappings, Sessions and Workflows using Informatica
• Developed the Batch and Incremental ETL process i.e., Mappings Mapplets using various Transformations and Workflows with Sessions / Tasks.
• Administered and maintained Clarity Risks/Issues, Functional and Non functional documentation, Change Controls, Technical Specs
• Provided solution for designing OBIEE RPD to support the report requirements
• Involved in designing the OBIEE RPD in all 3 layers by importing metadata, doing joins and applying business rules.
• Enhanced all the AP Dashboard reports and introduced new dashboard reports to accomplish SIM Golden Suppliers in to the reports.
• Enhanced all the AR Dashboard reports and introduced new dashboard reports to accomplish UCM Golden Customers in to the reports.

Environment: Visio, Erwin, Informatica 9.0, OBIEE 10G 11G, Oracle APPs R12

Confidential

Data Solutions Architect

Worked as Architect as part of HSBC global COE team.

Responsibilities and Key Successes

• Worked very closely with business users to gather requirements and worked in providing technical solution to do a preliminary feasibility study, impact analysis and presented multiple clear choices to the project steering committee for making a decision on the implementation choice
• As Data Architect I was deeply involved with Data Governance between multiple source systems and the existing model of the target data models.
• Extensively involved with technical leads to work on data profiling, data Integration and data cleansing processes.
• Extensively worked on parallel processing and implementing various partitioning technics.
• Prepared solution architecture documents which include source data analysis, gap analysis, recommendations, Logical, Physical data models and ETL Mapping design specs.
• Deeply involved in working and preparing the ETL Framework at HSBC financial and Loan origination domain.
• Worked as Data Architect to identify and prepare FACT /Dimensions matrix and data mapping documents for Informatica and Data Stage as well.
• Involved in performance tuning at various levels session, mapping, database architecture .
• Followed and worked on RBPM methodology in the project lifecycle.
• Involved in helping Team Lead by providing resource availability, project status and maintain project plans.

Environment: Data Stage 8.5, Informatica 8.6, DB2, Oracle 11g, TeraData, SQR, Visio, Erwin 4.1

Confidential

ETL Technical Lead

Responsibilities and Key Successes

• Designed and developed reusable services using SOA standards.
• Managed the roll out of ARM mortgage lending products nationwide.
• Managed flagship projects such as Sales Engine and roll out secure plus lending products. Worked on building a Rules Based Engine for use in complex business rule and rules evaluation
• Subject matter expert SME for various functionalities of application such as Application Management, Payment Calculation, Underwriting and Loan Close
• Received several recognition awards including the People's Choice award for being an outstanding individual and helping others at their work and addressing and supporting production support team to resolve issues
• I have lead teams of more than 30 people across demographic boundaries in accomplishing these projects and have utilized my people and technical skills to unify their efforts for achieving the project results
• Below are the some of the projects that I lead:
• Data migration Conversion implementation using ETL tool from IMS, VSAM to DB2.
• Implementation of Pricing and Sales Analytics in to the Enterprise Data Warehouse.
• APEX under wring: Integration VISION with IAW work flow management system .
• Pricing system enhancements on the risk based pricing of the Consumer lending system and implementation of the Rate sheet and Clear Script automation
• ESCROW product rollout for Taxes and Insurances with the 1st lien mortgage loans
• Sales Engine/Solution Builder project to deploy and sales tool for selling loans to a customer.
• Vision Rules Engine development.
• Interest Only First Lien product. To create and deploy an interest only offering as part of HSBC's product portfolio.
• Voucher Payoff and Loan Payoff project implementation

Environment: Datastage 6.0, Informatica 7.5, Cognos, J2EE, PowerBuilder 6.0 to 10.00, Sybase, Oracle9i, SQL server, DB2 and IMS