Rajib Das Patnaik

Objective: Migration from Legacy systems and creation of DL on s3 bucket using AWS Platform. The sequence of activities/ tasks involved for implementation are as follows:

• Identification and setting up connectivity with source systems or proposing ways for extraction of files. If required setting up discussions with source team and third party team for identifying connectivity.
• Extraction of files/ data from source and loading to AWS s3 landing layer. This is done using SFG or reusable utilities developed using Scala code. From second load onwards delta rows are identified and extracted based on audit dates.
• Extraction of files from s3 landing layer and loading files in parquet format to s3 Sanitized layer. Here we maintain maintaining SCD-2 for keeping track of history records.
• Then curation of data is achieved based of various transformations as per requirement and mapping document and then loaded to s3 Curated layer. Here also we maintain SCD Type-2 for keeping track of history records. Downstream applications can also use extract data from Curated layer based on need.
• Finally required data and columns are extracted and loaded to Optimized layer using Informatica BDM. Here we maintain either snapshot versions of tables or in view formats which can be used by downstream applications.
• Then as per basic requirements, Development team creates .mpf files which is provided to downstream applications for reporting purpose.
• Reconciliation of data/ policies is maintained at each layer for audit purpose.

Domain: Insurance

Tools Used: Informatica BDM, Informatica PC, SQL Developer, SSMS, Postgres, Putty, WINSCP, Hive SQL

Scripting Languages: Unix Shell Scripting, Python

Platform/ Environment: AWS (s3 Bucket/ EMR), Windows, Oracle 12i, SQL Server

Engine: Spark

Methodology: Agile, use of sprints and tracked using Jira

Responsibilities:

• Worked with customers or prospective customers to develop integrated solutions and lead detailed architectural dialogues to facilitate delivery of comprehensive solution.
• Guided and influenced existing partners on recommended upgrades and enhancements to integrated solutions.
• Creation and implementation innovative business solutions to support corporate objectives.
• Conducted requirements gathering, analysis and all required documentation which includes Overall Process architecture Diagram, HLD, LLD and Mapping Documents.
• Assisted team in responses to customer and prospective customer evaluations, escalations and technical requirements documents.
• Review and sign/Off required at each levels along with customer feedback.
• Managed project scope, schedule, status and documentation.
• Implementation of end to end development strategies.
• Integration of wrappers and developed codes for extraction of data at each layers.
• Unit Testing followed by code deployment to higher environments.
• Preparation of deployable components and other related process adhering to deployment process.
• Supporting Test Team and acknowledging their queries during this phase.
• Closing defects assigned to development Team.
• Code and Data Review before Customer Demo. Once data seems good then we have customer demo. Based on further feedback from customer, modification/ customization to code is implemented.
• After receiving customer Customer Sign-Off on pre-prod data and completion of all pre-requisites, code is deployed to Production. Development Team provide support to PROD Team as agreed.
• This continues with supervised troubleshooting, user support and maintenance.

Objective: AV is an agency of DHHS, Melbourne, Australia providing pre hospital services for Victoria State. VT2 project was implemented for providing detailed patient information to VADS, TPOS and 2C Risk from Enterprise Data Warehouse after decommissioning Legacy Data Warehouse. AV has implemented Oracle Financial Analytics and the BI development team is responsible for its maintenance which includes creation and generation of files and reports for required vendors using Informatica PC. The sequence of activities/ tasks involved for implementation are as follows:

• Evaluated and adopted new technologies to address changing industry needs.
• Study and detailed Analysis of Technical Specification document.
• Based on analysis, preparation of questionnaires and discussion for clarifications and sign-off on requirements.
• In Parallel, drove technical initiatives for large enterprise systems to align with long-term business strategies.
• Offered input on technical and platform-related strategic planning initiatives.
• Communicated project plans and progress to key stakeholders and project contributors.
• Discussion with Team exact requirements and preparation of LLD and Mapping Document.
• Sign-Off on Mapping Document and ETL Design.
• Development of Mapping and Generation of files.
• Capturing Incremental Data and maintaining SCD Type -2 for tables.

Domain: Health Care

Tools Used: Informatica PC, SQL Developer, DAC, Putty, WINSCP

Environment: Windows, Oracle 11g

Engine: Informatica Native

Responsibilities:

• Developed project plans and managed project scope using methodologies to guide projects from conceptualization to implementation and maintenance.
• Investigated system issues and implemented resolutions to reduce downtime.
• Automated monitoring and security measures to reduce required employee attention.
• Outlined work plans, determined resources, wrote timelines, and generated initial budgets as part of project scope determination.
• Collaborated with business users, technical teams, database administrators and testing teams during kickoff meetings, joint application designing, and planning sessions to validate requirements.
• Partnered with project team members to identify and quickly address problems.
• Updated customers and senior leaders on progress and roadblocks.
• Adjusted project plans to account for dynamic targets, staffing changes, and operational specifications.
• Analyzing Requirements and study of data for understanding functionality of already existing Legacy Model.
• Preparation and Delivery of Solution Design Document, Mapping Document and ETL Design Document.
• Provided educational expertise and mentoring to junior team members.
• Review of Informatica Mappings and Validating data.
• Creation of Shell Scripts, Tasks, Phase and Execution Plans in DAC for executing sequences and creation of files.
• Preparation of Deployment documents as per process for deploying to UAT/ PROD.
• Providing warranty support.
• Accomplished client goals by providing quality technical projects.
• Implemented best practices to drive quality IT project delivery.
• Wrote, updated and maintained project documentation.
• Communicated project updates to stakeholders at all levels.

Objective: Davita Inc. provides Kidney dialysis services after understanding the causes, risks, symptoms, and stages of Kidney disease. It also provides diets, medications management, different treatment options after an early stage diagnosis. The sequence of activities/ tasks involved for implementation are as follows:

• Discussion with senior BA and client for understanding requirements.
• Study and detailed Analysis of functional and Technical Specification document.
• Based on analysis discussion with vendors and clients for clarifications and sign-off on requirements.
• Design and facts and dimensions after gathering detailed attribute mapping.
• Discussion with leads on project plans and progress to key stakeholders and project contributors.
• Based on requirements preparation and Sign-Off on Mapping Document and ETL Design.
• Development of Mapping, creation of Data Warehouse and loading of target tables.
• Creation of Views for Reporting Team.

Domain: Health Care

Tools Used: Informatica PC 9.6.1, DB Visualizer, SQL Developer, Source Tree, Bit Bucket, Putty, WINSCP, Jira, Confluence, Service Now

Environment: Windows, Netezza, Oracle 11g

Engine: Informatica Native

Responsibilities:

• Developed project plans and managed project scope using methodologies to guide projects from conceptualization to implementation and maintenance.
• Analyzing Requirements.
• Design of Facts and Dimensions.
• Preparation of mapping documents, creation of sql procedures with appended logic for loading facts and dimensions.
• Creation/ Generation of mappings/ workflows using Informatica.
• Execution and Debugging of mappings for extraction and loading of facts/ dimensions.
• Implementing Incremental Loads, maintaining SCD-2, handling early arriving facts and late arriving dimensions.
• Provided educational expertise and mentoring to junior team members.
• Review of Informatica Mappings and Validating data.
• Unit Testing and creation of Test Document.
• Creation of views required by reporting team.
• Preparation of Deployment documents as per process for deploying to QA/ PROD.
• Providing warranty support.
• Wrote, updated and maintained project documentation.
• Led cross-functional teams to successfully complete IT projects.
• Monitored and tracked project progress to support timely completion.
• Developed and introduced IT strategies to improve operational efficiency.
• Implemented best practices to drive quality IT project delivery.

Objective:

BOAR project basically deals with XML format messages which is received from the source system BIDS. As per business justification, the source systems AXIAL and BPSA sends trade related information through XML and swift message formats using MQ. Excluding XML and swift messages, the source system also provides flat files for processing. This included to develop a new system to read the real time cage activity messages, then generate a output XML message as per the requirement mentioned in FSD and finally send the target messages to target system (AXIAL/ Broadridge) through MQ which is used further for reporting purpose by the business users.

The processing of source XML messages includes the following steps:

• Firstly source XML messages from AXIAL is loaded to BIDS source table in development environment.
• From BIDS table processing of XML messages starts and data is loaded to intermediate staging tables.
• For this Informatica mapping is developed which extracts data from source table BIDS. Then required elements are extracted from XML tags using XML parser and data is loaded to columns of staging tables.
• Then using data from staging tables, new XML is generated as per FSD requirement and is loaded to same BIDS table.
• Finally, target XML messages are sent to target system through MQ
• .
• Build of dashboards and reports through OBIEE 11g.

Domain: Retail

Tools Used: Informatica 9.6.1, SQL Server Management Studio 2014, SQL Developer

Environment: Windows, Oracle 11g, SQL Server

Responsibilities:

• Analyzing of requirements as per FSD and preparation of source specification, mapping document based and ETL design document.
• Design of end to end mapping as per customer requirement and getting it reviewed/ signed off from client based on feedback .
• Creation of Informatica mapping and workflow with complete UNIT Test specification and result set.
• Creation of deployment groups in Informatica Power Center Repository Manager during deployment of workflows to UAT and PRODUCTION.
• Creation of UNIX scripts for executing workflows and scheduling jobs.
• Providing resolutions to issues in UAT and Production.
• Review of Codes and scripts before client review process and UAT/ PROD migration.
• Preparation of Deployment docs and deployment groups.
• Daily onsite – offshore communication for daily status and clarification
• Involvement in quarterly Audit and PMR.
• Regular assessment of team members
• Involvement in preparation of contract during extension of SOW.
• Timesheet Approval and Billing Vitals preparation.
• Follow up for invoice clearance and maintaining mapping sheet for same.

Objective: Bombardier is a Canadian multinational aerospace and transportation company which deals with airliners. The objective was to establish an integrated data platform by extracting the required data for major source systems like SAP, NCMS, flexnet, ENOVIA and few more The sequence of activities/ tasks involved for implementation are as follows:

• First step is source dependent data load to logical staging database.
• Second step is source independent data load to DW which ETL approach. This includes loading of data to oracle staging area from SAP environment through datastage using ABAP Programs.
• This is followed by Incremental runs every four hours for capturing and loading delta records into oracle staging area. This also includes Full and Incremental Loads from flexnet files and Oracle 8i tables through datastage Jobs.
• Design and Creation of facts/ dimensions as per requirement.
• Loading of data to these facts/ dimensions through datastage Jobs.
• Final Process is to load Aggregated Facts based on which MicroStrategy reports can be build.
• Build of dashboards and reports through OBIEE 11g.

Domain: Retail

Tools Used: datastage 11.3.1, Toad

Environment: Windows, Oracle 11g

Responsibilities:

• Analyzing of requirements and preparation of source specification based based on source tables and files.
• Designing of OLAP Model after proper identification of customer requirement and creation of facts and dimensions.
• Queried databases for information needed for report processing.
• Developed effective improvement plans in alignment with goals and specifications.
• Creation of Datastage jobs for loading of data into Oracle Staging area and subsequently into OLAP Schema in order to load dimensions and facts.
• Creation of sequence and master sequence for completing the Datastage workflow for loading of data.
• Validated results and performed quality assurance to assess accuracy of data.
• Recommended process improvements to continually identify, analyze and fix constraints and challenges.
• Performed system analysis, documentation, testing, implementation, and user support for platform transitions.
• Assessed data modeling and statistics to integrate high-level business processes with data rules.
• Daily onsite – offshore communication for daily status and clarification.
• Bug Fixing in UAT and PRODUCTION.
• Providing warranty support.
• Identified and resolved problems through root cause analysis and research.
• Devised and implemented processes and procedures to streamline operations.

Objective:

In the current system, following sources will be used to populate the Business Analytics Warehouse.

• Flat files from SAP
• Flat files from JD Edwards
• Flat files from Trintech

The ETL is implemented using Oracle BI Applications. The data from the sourcing system is populated in to Oracle Business Analytics Warehouse in a two step process :

• First step is source dependent data load to logical staging database.
• Second step is source independent data load to data warehouse. It uses mappings to perform Extract, Load and Transform (ELT) of data from source system. Following processes are being done during ODI mapping
• File polling and Sequencing of files,
• Loading of data from source files is done after mapping source and target columns, applying transformation logic, choosing appropriate knowledge modules , using SQL Loader utility so as to eliminate and capture detailed errors, application of validation (constraint error ) check into datastore by use of interfaces and packages and
• Data from the datastore is finally loaded into facts and dimensions using SCD Type 2 after mapping between facts and dimensions using joining condition and different mapping and validation rules
• Email notification on successful completion of process for any failure or success.
• Building Dashboards and Reports through MicroStrategy.

Domain: Retail

Tools Used: ODI Studio 11g, Oracle Sql Developer, OBIEE 11g

Environment: Windows, Oracle 11g, ODI 11g

Responsibilities:

• Analyzing of requirements and preparation of source specification based of flat files provided from client.
• Creation of sql scripts, database procedures and packages.
• Creation of ODI interfaces, packages, data model and executing scenarios for loading data.
• Performance tuning of sql scripts being scripted.
• Creation of Test Plan and Test Case while Unit Testing Phase.
• Daily onsite – offshore communication for daily status and clarification
• Sending WSR to onsite and offshore
• Bug fixing in UAT and Production
• Review of developed codes/ scripts by team.
• Involved in project management related activities like preparation of UPP, Project Profile doc, Induction Manual during project start up phase.
• Also involved in managing Monthly Metrics, TCS Process related activities, Audit, PMR and so on.
• Creation of Reports and Dashboards as per request from Customer
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Having good knowledge of creating and assigning Roles to different dashboards.
• Checking Privileges for the Roles in Manage Privileges.
• Basic Unit Testing of Dashboards, RPD, Reports, Prompts etc.
• Fixing defects raised by Customer for the existing reports/dashboards.
• Checking data quality and reporting as per ETL

Objective:

The Project is based on regular maintenance activities of the database and providing support to different data warehouses.

The Unified Inventory Interface(UII) is a Service Assurance

infrastructure component which creates a single interface

to give a consolidated view of network inventory data enabling the network to be managed from a Customer centric view. The data initially comes from the various source systems which is processed by ETL and gets populated in UII database. Then it gets propagated to outside system through APIs and Batches. These ETL and APIs are created and maintained in UII.

At project level, I was basically involved in design activities. Also was fully responsible for end to end development using pl/sql packages and procedures which also includes specific interfaces Testing, preparation of Unix scripts and co-ordination with the ASG team at the time of Live Deployment. This also included developing various Batches and API's in PL/SQL

Domain: Telecom

Tools Used: Putty, Toad, PL/SQL Developer, CVS, HUDSON

Environment: Windows XP,Unix,Oracle9i, OWB

Responsibilities:

• Collaborated on stages of systems development lifecycle from requirement gathering to production releases.
• Collaborated with project managers to select ambitious, but realistic coding milestones on pre-release software project development.
• Updated old code bases to modern development standards, improving functionality.
• Discussed issues with team members to provide resolution and apply best practices.
• Development of Oracle queries and pl/sql packages.
• Development of multiple API's using OWB .
• Creation of new databases and table structures.
• Authored code fixes and enhancements for inclusion in future code releases and patches.
• Analyzed work to generate logic for new systems, procedures and tests.
• Unit Testing and Creation of Unit Test Documents.
• Support during Deployments and Sanity Checks.
• Warranty Support during Production Run.