Onsite Lead/data Architect Resume
5.00/5 (Submit Your Rating)
SUMMARY:
- Analysis - Design - Development - Implementation - Testing
- Offering over 15 years of total IT experience in Data Warehousing, Big Data, ETL Applications, Reporting Applications, Database Applications and Design Methodologies.
- Excellent Exposure as Data Architect and was responsible for Architecting the Enterprise Analytics Data Warehouse system by defining various logical and physical layers for one of the major Pharmaceutical Clients on cloud platforms.
- Excellent Knowledge on Data Integration/Data Ingestion and ETL process using Informatica suite of Products like Informatica Big Data Management, Informatica Intelligent Cloud Services, Informatica PowerCenter.
- Good Hands on Exposure in Dimensional Modelling methodologies and data profiling activities using tools like Erwin Data Modeler and Informatica Analyst and was responsible for design and implementation Logical and Physical Data Models using Erwin Data Modeler Tool.
- Excellent Knowledge on various RDBMS stacks like Oracle, Sql-Server, Netezza, Teradata along with procedural language skills like Oracle PL/SQL, TSQL and performance tuning implementations on RDBMS systems.
- Good exposure and operational knowledge on various cloud offerings like Microsoft Azure HDI and Amazon Webservices components like AWS Lambda for data validation purposes.
- Hands on exposure in Spark-based analytics platform Databricks and Hive data warehouse system for Hadoop on Microsoft Azure HDI.
- Excellent domain knowledge of Commercial Pharma, Finance, Technical Operations in Pharma Industry and worked for renowned clients like Confidential Pharmaceuticals and Lifesciences clients like Gilead Health sciencess and Health Care Industry.
- Good knowledge and excellent development experience in reporting tools like OBIEE 11G and Power BI.
- Good Leadership qualities working in Onsite Offshore Model along with solutioning mindset and Client Interfacing Skills along with extensive exposure to software Development Processes like Safe Agile and waterfall Models.
TECHNICAL SUMMARY:
- Informatica Power center
- Informatica Developer
- Informatica Cloud Services.
- Informatica Analyst
- Oracle Warehouse Builder
- Business Intelligence Applications 7.9.6.0/7.9.6.4
- Power-BI
- Netezza
- Hive
- Oracle
- MS SQL Server 2008
- Teradata
- Databricks
- Erwin Data Modeler
- Microsoft Azure HDI
- Amazon Web Services
- Lending Domain
- Finance Domain
- Pharma Domain
- Health Care Domain
- Unix Shell Scripting
- T-SQL
- PL/SQL
- Python
PROFESSIONAL EXPERIENCE:
Confidential
Onsite Lead/Data Architect
Responsibilities:
- Working as ETL Architect/Onsite Lead and actively responsible for analyzing the existing legacy mainframe systems used in various modules of Actuarial Process like Premium calculations, Renewal Process etc. in effort to modernize the legacy actuarial applications.
- Identify the data elements in existing Enterprise Data Warehouse system that would be required for Actuarial team using Collibra Data Governance Data Models.
- Design the necessary table structures using Erwin Data Modeler and deploy the same into target sql- server systems by defining suitable partition strategies, indexes, column datatypes etc.
- Interact with business stake holders to identify the Key factors impacting the process of premium calculations.
- Develop Informatica artifacts to extract the datasets from source EDW data warehouse system in Teradata and populate the data into target SQL Server system by carrying out necessary business transformations.
- Provide a performance enhanced ETL design to carry out the necessary ETL Load process and implement the same with offshore development team support using Informatica ETL Tool.
- Develop Technical Specification Documents based on the requirements gathering sessions for implementation using Informatica PowerCenter and prepare Source to Target Mapping documents.
Confidential
Data Architect
Responsibilities:
- Participated in requirement discussions with Business Analyst’s to formulate a robust data warehouse model for marketplace and model the same using Erwin Data modeler.
- Responsible for design and development of ETL components to ingest data from different sources like ERP Systems, Internal IT systems of Confidential and various end user reporting systems, legacy ODS systems on Netezza and Oracle Platforms into Azure Blob storage using Informatica Cloud Mappings and Mapping configuration Tasks.
- Responsible for formulation and implementation of various load strategies in different layers of marketplace and scheduling the data loads using enterprise scheduling tool Atomic UC4 V11.
- Responsible for development of various Informatica BDM mappings, Informatica workflows and Informatica BDM Applications using Informatica Developer to ingest data to hive data base instances after carrying out various transformations as per ETL requirements document.
- Responsible for design and implementation of slowly changing dimension mappings and hybrid slowly changing dimension Informatica BDM Mappings as per business requirements and also developed various Informatica BDM Mappings to load data to various Fact Tables.
- Responsible for identifying the load time bottlenecks and implements various tuning strategies to reduce the load times to meet the business SLA’s.
- Responsible for migration of various components like hive tables, Informatica ICS Mappings, Informatica BDM Mappings and UC4 Jobs to upper environments like Quality and Production instances and provide care support for the same and handover to support teams.
Confidential
ETL Lead
Responsibilities:
- Responsible for design and development of Informatica Cloud Mappings and Mapping configuration tasks to components to ingest data from commercial DataMart system specifically plantrak,Alignment and in Netezza and Oracle Database in case of track wise modules into Azure Blob Storage.
- Responsible for creation of External tables pointing to the Blob storage and develop UC4 jobs to invoke the Informatica Cloud Services Mapping configuration tasks using Rest API provided by Informatica.
- Responsible for development of various Informatica BDM mappings, Informatica workflows and Informatica BDM Applications using Informatica Developer to ingest data to hive data base instances hosted on Azure Platform after carrying out various transformations as per ETL requirements document provided by modelling teams.
- Responsible for identifying the load time bottlenecks and implements various tuning strategies to reduce the load times to meet the business SLA’s.
- Responsible for migration of various components like hive tables, Informatica ICS Mappings, Informatica BDM Mappings and UC4 Jobs to upper environments like Quality and Production instances and provide care support for the same and handover to support teams.
Confidential
ETL Lead
Responsibilities:
- Responsible for identifying and design and modelling of the various fact and dimension tables and co-ordinate with various stake holders to get the necessary data elements.
- Responsible for development of various Informatica Power center mappings to read the data generated from SAP source systems in terms of flat files.
- Responsible for developing various Informatica Power center mappings and workflows to load data to various dimensions and fact tables created on Netezza database to provide visibility of various order status in reporting layers.
- Responsible for developing various UC4 Jobs to automate the data load process from various ERP systems like JDE, SAP, SC2020 etc.
- Responsible for providing Infant Care support in the project and have the ETL components moved to upper environments.
Confidential
Onsite Technical Lead
Responsibilities:
- Responsible for showcasing the abilities of Informatica CDC methodologies using Informatica Power Exchange to capture incremental data from various high load Transactional OLTP applications.
- Responsible for Design and Implementation of various business reconciliation mechanisms using Informatica Mappings.
- Responsible for creating Informatica mappings to read the data for custom web based Confidential Bank Applications using HTTP Transformations and XML Parser Transformations.
- Responsible for writing shell scripts to massage the source flat files to confine to agreed upon format and design a data flows using command task in informatica.
- Responsible for creation of various reusable Informatica Mapplets to be used for loading the fact tables.
- Responsible for design and load of a generic framework to load various flat files into Oracle Database using Informatica.
- Responsible for developing SCD2 type of mapping using Informatica Power center using various types of transformations like Lookup transformations, Joiner Transformations and Update strategy transformations.
- Responsible for scheduling ETL jobs using Control-M and monitor the same.
- Responsible for developing Oracle Database PL/SQL procedures and Packages to truncate the partitions tables and carry out routine maintenance activities of Oracle Objects to have updated statistics for optimal query performance for Reporting Layers.
- Responsible for development and implementation of masking methodologies to mask sensitive data in UAT and development environments using Informatica Power center.
- Responsible for creating TSQL Procedures in sql server 2008 to carry out the data comparison activity between Oracle and Sybase systems and report any discrepancy in the data migrated from Sybase to oracle systems using sql server link server features.
Confidential
Onsite Technical Lead
Responsibilities:
- Responsible for platform upgrade from OBIEE 10G to OBIEE 11G and address the subsequent upgrade challenges in terms of RPD, Web Catalogue and Security.
- Responsible for customizing out of the box Informatica mappings to load various additional KPI's in fact tables and scheduling the same using DAC.
- Responsible for developing various Informatica Mappings to carry out data loads to custom dimension and fact tables from legacy source systems and carry out the Data Model changes with respect to OBIA out of the box financial analytics Data Model.
- Responsible for showcasing the abilities of OBIEE 11G and the value that upgrade of platform can bring to business analytics users at Confidential .
- Responsible for Providing the Technical Architecture for BI upgraded environment for implementation in Production and performance environments.
- Responsible for installation of OBIEE 11.1.1.7 on unix platforms and configure for clusterware architecture.
- Responsible to tune the platform related parameters to ensure optimal performance of OBIEE environment along with installation of Oracle HTTP servers to enable HTTP compression in Unix environment and integration with OBIEE11g cluster ware instance.
- Responsible for implementing EBS integration with OBIEE11G using Action Links.
- Responsible for Configuring and changing the default Authenticator LDAP to OID and implement security roadmap for Confidential .
- Responsible for understanding and analyzing the customizations done with respect to financial analytics and Procurement and Spend analytics and provide a gap analysis document by interacting with the end users.
- Responsible for consolidating multiple instances of OBIEE spread across the organization for various departments and provide a standalone instance of centralized reporting.
- Responsible to formulate and implement a MUDE environment for development.
- Responsible for installation and configuration of BI Management Packon top of unix environment to enable centralized access to the entire IT infrastructure in the data center.
- Responsible for development of custom reports and RPD modeling changes to accommodate the new user requirements.
- Responsible for implementing OBIEE features like SSO and custom OID integration instead of inbuilt LDAP functionality.
- Responsible for implementing various performance tuning strategies like Aggregate Navigation, Caching strategies, HTTP Compression using OBIEE advance features along with the database objects design to improve the turnaround time of reports.
- Responsible for allocation and monitoring of tasks among team members and guide them with necessary inputs to overcome technical challenges.
- Responsible for providing Infant care support for the project as a part of support team.
Confidential, Houston, Texas
Offshore Technical Lead
Responsibilities:
- Responsible for gathering the requirements for the custom report development Using OBIEE.
- Responsible for analysis of data and prepare various Data Mart models across different subject areas of Confidential using Toad data modeler tools.
- Responsible for design and implementation of various confirmed dimension hierarchies which included the modeling of Parent Child Hierarchies and Skipped Hierarchies in OBIEE 11G.
- Responsible for data profiling and data quality checks to suffice the report requirements gathered above and provide an ETL Mapping technical specifications document to cater to shortcomings in data if any.
- Responsible to articulate the Data Mart design based on reporting requirements using Data Modeling best practices and Techniques.
- Responsible for providing Technical design document for the reporting requirements along with RPD Modeling of the same.
- Responsible for design and implementation of various confirmed dimensions across Confidential organization to be used across multiple subject areas.
- Responsible for design and development of various reports using OBIEE11G across multiple subject areas/business lines to cater to the custom reporting needs of weather ford departments like Operations, Safety and Environment, Project Management groups.
- Responsible for implementing various performance tuning strategies like Aggregate Navigation, Caching strategies using OBIEE advance features like cache seeding techniquesusing agents along with the database objects design to improve the turnaround time of reports.
- Responsible for setting up of usage tracking on OBIEE 11G system in development, UAT and production instances.
- Responsible for Migration of Artifacts for QA and Production environments.
- Responsible for allocation and monitoring of tasks among team members and guide them with necessary inputs to overcome technical challenges.
Confidential
ETL Lead
Responsibilities:
- Responsible for understanding the business processes of SIDBI (lending domain) and translate the requirements to a warehouse model.
- Responsible for Implementation of Change Data Capture Strategies for acquiring incremental data from various source systems.
- Responsible for developing and implementing the various tuning strategies to improve the overall load time of Warehouse and turnaround time of OBIEE reports.
- Responsible for guiding developers in the Project to implement various tuning strategies in RPD of OBIEE to increase the turnaround/response time of reports.
- Responsible for leading a ETL team of 20 people in assisting them to carry out their day to day development activities using OWB and PL/SQL.
- Interacted with clients to understand the business requirements from different of Physical Layer, Business Mapping and Presentation Layer.
- Built Reporting Dashboards and Pages. Created 8 Critical Reports in Answers developed and debugged existing Dashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Alerts, Guided Navigation and Dynamic Dashboards with drill-down capabilities using dashboard and page prompts.
- Created Materialized views, created indexes on tables which has text to boost performance.
Confidential
Senior Analyst
Responsibilities:
- As a Senior Analyst my responsibilities includes project planning, estimation of the effort for development, testing and implementation.
- Responsible for design and development of various components using Informatica and oracle pl/sql that determine the routing/shipping rules across Confidential manufacturing centers to optimize the shipping costs.
- Responsible for developing code for flattening of corporate hierarchies.(Geo,Product,Channel hierarchies).
- Responsible for developing percolation logic for Shipping Confidential products across various demand lines with the objective to reduce the shipping costs.
- Prepare BRDs, FRD’s, and Technical Design Documents (TDD) for new projects.
- Performance Tuning of ETL flows and made changes to database by implementing the materialized views, re-building of indexes, overwriting the SQL execution path by making use of hints etc.
Confidential
Staff Consultant
Responsibilities:
- Responsible for installation of BI-Apps 7.9.6.0 that includes hardware estimation and installation of Informatica 8.X, OBIEE infrastructure and DAC server and client components on windows and Linux platforms along with the initial data load for vanilla implementation of Financial Analytics and Procurement and spend analytics.
- Was also responsible for deciding the data acquisition approach from source systems to capture incremental data and implement summary management strategies to improve reporting layer performance.
- Other efforts include gathering the requirements for custom reports and estimation of efforts for customizations in ETL/Reporting layers.
- Implement Type2 and Type3 customizations for BIAPPS based on the functional specification documents provided by the Business Analyst Teams.
- Responsible for design and development/modification of custom Informatica mappings to cater to custom reporting requirements.
- Responsible for configuring the files for initial data load activities.
- Provide the technical specification documents for process/turnaround improvement related development work in the existing DWH system.
- Implementation of tuning strategies for improving the overall load process.
- Analysis of existing legacy pl/sql code and provide a warehouse implementation using Informatica ETL Tool as overall process improvement approach
Confidential
Project Engineer
Responsibilities:
- Was involved in the process of development of ETL Mappings to load the various warehouse tables.
- Worked on development of various ETL Mappings. Was also responsible for design/creation of Materialized views for the reports.
- Was responsible for providing Infant Care support and Production support for the project.
- Was responsible or creation and deployment of warehouse objects in the production environment.
- Involved in Production Support, UAT and sign-off from the users