premkumar.8787b

 

Premkumar B.

8838377897

Premkumar.8787b@gmail.com

Career Abstract:

• Around 8 years of experience in Software Analysis, Design, Development, Testing and Implementation OLTP, and OLAP applications

• Expertise in Oracle SQL, PL/SQL, Application Development using Oracle Forms, and Reports with knowledge in master-detail blocks, forms triggers, system variables, multiple form applications, menus, alerts, and LOV’s.

• Experience with deploying, automating, maintaining, and managing AWS Cloud-based deployment environments to ensure the availability, performance, scalability, and security of productions systems.

• Experience with configuration management tools, including Ansible,

containers, including LXC, Docker, and Amazon AWS services and APIs, including EC2, S3, VPC, and IAM, or Microsoft Azure or Google Cloud service.

• Experience in data modeling data solutions in Erwin Data Modeler Data Warehouse.

• Strong knowledge of Oracle Database Performance Tuning, RMAN Backup, and Recovery Procedure, and ability to work across multiple global sites.

• Created Ab Initio graphs that transfer data from various sources like Oracle, flat files and CSV files to the Teradata database and flat files.

• Developed Ab-Initio graphs to fetch data from DB2, Oracle, Teradata, Excel, flat files, and XML Files.

Managing the total wealth of client by matching the financial and investment product solutions to their financial needs.

• Implementation approach to deliver various master data domains management on Hands-on experience in Informatica PowerCenter 9.5.1 Administration.

• Responsible for maintaining and growing data held within Service Now such as our users, locations, configuration items, service catalog items.

• Actively involved in the development of Analytics Reports and Dashboards within the OBIEE environment.

• Implemented all facets of MDM including Data Profiling, metadata acquisition, data migration validation, reject processing and pre-landing processing.

• Designed and executed comprehensive test plans for high-stakes software rollouts, ensuring a 99% success rate on initial product launches.

• Experienced in ITIL-based service management processes across Incident, Problem, Change, and Request workflows.

• Implemented Oracle Fusion HCM modules and Configured approval workflows using BPM and managed security roles and privileges.

• Hands-on experience in DevOps and development teams to streamline continuous integration/continuous deployment (CI/CD) processes on GCP.

• Developed and maintained automation routines for PostgreSQL services and provide support for Apache/Tomcat and PostgreSQL/MySQL databases.

• Worked extensively in performance testing initiatives using tools like JMeter, LoadRunner, and Blazemeter, ensuring optimal performance of applications across various platforms.

Expertise in designing and deployment of Hadoop cluster and different Big Data analytic tools.

• Experience working in different versions of EBX5 in developing managing supporting business critical development and systems including production environments.

• Experienced in cloud infrastructure services like IBM Cloud to deliver scalable software solutions.

• Design and implement solutions using Python with DBT and Snowflake.

• Designing and developing a data stage jobs to extract data from heterogeneous sources applied to transform logic.

• Creating Datastage 8.5 jobs using different stages like the transformer, aggregator, sort, join, merge, lookup, data set, funnel, remove duplicates, copy, modify, filter, change data capture, change apply, column.

• Extensively using the Datastage for extracting, transforming and loading databases from sources including flat files

• Spearheaded migration from Puppet environment to Docker-based service architecture.

• Developed financial models, conducted risk analysis, and assisted in implementing new products.

• Produced detailed asset allocation models and generated financial statements.

• Efficiently implemented a variety of full-stack features, including RESTful APIs with C# and ASP.NET Web API 2, server-side views with C# and ASP.NET MVC 5, and dynamic client-side interfaces with Ajax, JSON, JQuery and AngularJS.

• Utilized C# in combination with .NET, contributing to a 20% increase in app efficiency.

• Design CI/CD tools configuration management and managed local Docker deployments and created local clusters.

Spearheaded migration from Puppet environment to Docker-based service architecture.

• Recognized as Wealth Manager within the company for achieving outstanding results and meeting targets.

• Integrated with backend by making Restful web service calls in AngularJS.

· Analyzed and reported on test data using SQL, providing actionable insights that decreased average bug fix time by two days.

· Experience supporting in OBIA pre-built dashboards and reports, Oracle Business Analytics Warehouse metadata objects, and web catalog objects and development efforts in OBIEE 11G/12c application including migrations of web catalog, repository development and BI Publisher objects.

· Created Teradata objects like Databases, Users, Profiles, Roles, Tables, and Views & Macros.

· Reports manage policies and maintain productive broker and agency relationships.

· Established procedures for the collection of revenues, investment of funds and associated accounting.

· Ensured compliance with State Law, County Code and internal financial control requirements.

· Ensured the monthly reconciliation of all County bank accounts and related general ledger accounts.

• Built Data pipelines by creating Cloud ETL mappings in Informatica Intelligent Cloud Service and published them to be used in API calls.

• Development of the OBIEE Metadata Repository including the physical layer, business model mapping, and presentation layer for various subject areas.

• Incorporated OOP principles with C# for robust coding, leading to lower maintenance costs by 10%.

• Produced monthly reports for bank administrators to document long-term goals.

• Data Stewards, Business analysts and Application development teams to develop MDM platform that meets current and future business objectives.

• Work with business units, software developers, security, to design and build applications and services within AWS and/or other cloud providers

• Serves as Informatica Administrator bringing down and restoring services, managing users and governance controls, supporting releases and adherence to change control standards.

• Works with EBX Architect to partner with product and engineering team members on technical architecture and data integration patterns related to EBX implementation.

• Implemented multi-threading in C# to speed up data processing, resulting in faster data analytics and increasing productivity by 25%.

· Configured and installed Informatica MDM Hub server, cleanse, resource kit, and Address Doctor in Dev, QA, Pre-prod and Prod Environments.

· Experience with Cloud Infrastructure as a Service (IaaS), primarily AWS, Azure, or GCP Strong familiarity with containers and orchestration technologies like Docker and Kubernetes.

· Responsible for providing the highest level of technical support

· Resolves issues regarding patches and impact analysis, and application issue resolution and with developers, business analysts, and end users to provide system administration support

· Executes in designing, building, deploying and maintaining MongoDB databases

· Involved in the daily activities of configuration and system administration associated with non-production environments

· Optimizes system operation, performance, and resource utilization and participate in system capacity analysis and planning

· Executes extremely large, highly complex MongoDB projects/ datasets. Assists in documenting cluster strategies and architectures.

· Installed and Configurated of PostgreSQL and EnterpriseDB Advanced server (10 to 12).

· Designed and implemented in the installation, configuration, and upgrading of non-production MongoDB software and related products.

· Experienced in the integration of ServiceNow with Siebel, integrated Service Catalog and Incident module and Coordinated Service Catalog options, including two-step checkout, cart controls, and variables.

· Actively involved in the development of Analytics Reports and Dashboards within the OBIEE environment.

· Implemented application using Ruby and basic MVC architecture and developed stored procedures compatible with MySQL and MongoDB supportive in ruby.

· Design and implement complex database architectures for high-traffic applications.

· Develop and optimize SQL queries, stored procedures, and triggers to enhance application performance and data retrieval efficiency.

· Implement and enforce security policies and procedures, encryption, access controls, and compliance with data protection regulations (

· Responsible for installation and configuration of databases in clusters and setup & maintain replication for active/active solutions between data centers.

· Evaluate testing tools for UI performance testing and transition  on all JMeter activities, process/protocols, and existing scripts on project completion.

· Supported ITIL processes, ensuring SLA compliance and service quality.

· Developed OTBI and BI Publisher reports for HR analytics and compliance.

· Implemented dbt in a multi-terabyte database, reducing data load times by 40%.

· Analysed to identify incompatibilities between Teradata V12.0(old version) and Teradata SO BOX (new version) and fixing identified issues.

· Developed features in support of IBM’s Cloud Object Storage system and developed software for the Cloud Object Storage Manager product using the agile methodology.

· Designed and developed Ab Initio graphs, created psets and user defined functions using GDE as per the client requirement.

· Experienced with various Ab-Initio parallelism techniques, Ab-Initio Graphs using Data, Pipeline & Component parallelisms.

Designing and developing DataStage jobs for loading staging data from different sources like files, Oracle, SQL server DB into data warehouse applying business rules which consist data loads, data cleansing, and data massaging.

· Creating a shared container to simplify the DataStage design, and used it as a common job component throughout the project.Responsible for configuring backup / restore utilities and developing disaster recovery policies and procedures

· Responsible for setting up effective monitoring for alerts and capacity analysis. Also, tuning the database environment to insure optimal performance and resource utilization

· Responsible for creating, maintaining and updating documentation necessary to support the database operations by the DBA team

· Responsible for recommending optimal schema designs for better performance and scalability

· Responsible for enforcing Enterprise security policies and procedures on databases

· Designed and implemented scripts in support of database maintenance to ensure consistent performance. Maintain solid working knowledge of functionality of existing platforms and future enhancements

· Coordinate with vendors to assure the continuing functionality of NoSQL as regards upgrades, versions, services packs, new releases

· Provide 24 x 7 on call support as part of a scheduled rotation with other team members

· Provide advanced troubleshooting for applications and systems and advanced technical support for database related project activities.

· Responsible for recommending database solutions to recognized problems and for design and implementation of new Oracle databases

· Responsible for creation of databases in Oracle systems

· Responsible for configuring backup / restore utilities and developing disaster recovery policies and procedures

· Responsible for Installation and Configuration of Oracle solutions like Data Guard, Golden Gate

· Responsible for setting up effective monitoring for alerts and capacity analysis. Also, tuning the database environment to insure optimal performance and resource utilization

· Responsible for creating, maintaining and updating documentation necessary to support the database operations by the DBA team

· Responsible for enforcing Enterprise security policies and procedures on databases

· Designed and implemented of hardware, including RAID, multi-processor architecture, etc

· Configured and tune databases and operating system software to ensure optimum performance and resource utilization

· Function as the technical liaison between System Administrators and DBA teams. Provide mentoring to fellow administrators

· Configured advanced troubleshooting for applications and systems and advanced technical support for database related project activities.

· Experienced on-going enhancement and maintenance of the ServiceNow platform and Ensured the configuration and customization to ServiceNow – adhere to the goals/strategy determined by the SN Architect and SN Product Owner.

· Implemented of replication/sharding/partitioning/clustering between data centers.

· Monitored database performance and applied updates and patches as necessary.

· Designed and developed Ab Initio graphs, created psets and user defined functions using GDE as per the client requirement.

· Developed data migration projects, ensuring data integrity and accuracy throughout the transfer process.

· Developed and maintained internal tools for database monitoring and management.

· Developed in the administration of MongoDB databases, including data entry, querying, and performance monitoring.

· Designed and implemented a cloud-based database architecture for a global e-commerce platform, resulting in a 30% improvement in transaction processing speed and 40% cost savings.

· Performed database tuning and optimization, resulting in a 20% reduction in query execution times.

· Created and managed database documentation, including architecture diagrams, change logs, and recovery plans.

· Conducted regular database performance reviews and implemented improvement strategies.

· Developed scripts for automation of routine database maintenance tasks, reducing manual workload by 40%.

• Analyzing root cause of issues and working with teams in closing them permanently.

• Provide rotational on call support during off-business hours.

• Successfully led ITIL process optimization project, reducing incident resolution time by 20%.

· Experience in operating expenses while improving asset management through improved value-dating and idle cash investment.

· Experienced in Backup & Restore using pg_dump and pg_dumpall Binary tools.

· Experienced in Full Backup using pg_basebackup setting up WAL archiving, Point in time recovery.

· Corporate treasury experience – cash management, cash forecasting, payment processing, banking relationships

· Strong knowledge in the Bank’s accounting practices, including a high level understanding of Balance Sheet compositions.

· Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps (OBIA), Informatica – Power Center and DAC..

• Expertise in Setup High-Availability as part Disaster Recovery Strategy for the Database

• Experience in  Data Model, Data Flow, and Data Mapping with application development team.

• Developed and delivered IDQ (Informatica Data Quality) components, as specified in the design, functional and non-functional requirements, within established budget, time and quality standards.

• Experience in creating Logical, and Physical Data Models from the requirements

• Good knowledge of executing the data modeling using Erwin Data Modeling Tool

• Experience in Oracle DBA with parallel Oracle/ SAP Database using Oracle Parallel Server

• Experience in SQL Server Database Administration Support

• Upgrade Oracle GoldenGate from 11gR2 to 12c. Implement OGG 12c new features in mission-critical production environments.

• Created Teradata objects like Databases, Users, Profiles, Roles, Tables, and Views & Macros.Set up Teradata Workload Manager with the proper partitions and workloads based on Service Levels.

• Set up Teradata Query manager to automate many of the DBA tasks such as collection of statistics, monitoring spool space, candidate tables for purge, etc.

• Tuning DataStage jobs for better performance by creating DataStage lookup files for staging the data and lookups. And Extensively working with Datastage Designer and Director to load data from source extract files to the warehouse.

• support large-scale (up to 8 nodes), mission critical production RAC environment from 9i version to 11gR2 version RAC on deferent platform(including IBM AIX, Red Hat Linux, Sun SPARC Solaris, HP-UX)

• Hands-on experience in writing and executing various MySQL Database Queries from Python using Python-MySQL.

• Ensured sufficient funds are available to meet ongoing operational and capital requirements.Developed and improved upon the accuracy of the rolling cash modeling techniques.Provide guidance on areas of risk and opportunities and how to balance the need for simplification with the need for accuracy.

• Develop Ab-Initio Batch/Real time graphs for loading and extracting data from various schema relating to Oracle and Used Ab-Initio components such as Reformat, Redefine Format, Rollup, Normalize, Scan, Input Table, Output Table, Partition by Expression, Partition by Key and Sort, Merge, Concatenate, Gather, Dedup-Sorted, Replicate, Join, Generate records, FTP To, and Lookup.

• Developed custom dbt macros to automate and enhance data validation and testing.

• Loaded data from source systems into Teradata Warehouse using Teradata Tools and Utilities, CRs(Change request) Implementation for all Circles.

• Designed and deployed integrations using Oracle Integration Cloud (OIC), REST/SOAP APIs, and BIP reports.

• Integrated ServiceNow with third-party systems using modern integration technologies and protocols.

• Prepared Treasury response to audit and due-diligence requests accounting to resolve reconciling items.Developed and implemented technologies in support of the Workforce Product.Monitored interest payment schedule and ensure the validity of lender calculations.

• This is a real career opportunity to take complete ownership of a large-scale AWS implementation and to join a company who work with the latest technologies, and who offer excellent training and progression opportunities

• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

• Proficient in creating and modifying PL/SQL and SQL*Loader Scripts for Data Extractions, Conversions (ETL), and Automating Data Loading, Extraction, Report Generation using Unix Shell Scripting.

• Developed user interface for a website with ERB, RJS, Ruby for the view, controller, model in ruby on rails framework on the OS X operating system.

• Executed configuration management using ServiceNow Discovery, which resulted in a 20% improvement in asset tracking and management

• Created Ab Initio graphs that transfer data from various sources like Oracle, flat files and CSV files to the Teradata database and flat files.

• Developed Ab-Initio graphs to fetch data from DB2, Oracle, Teradata, Excel, flat files, and XML Files.

Experience in using Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update Strategy, Sequence Generator, and Stored Procedures

• Well-versed in resolving issues with Oracle 6i Forms/ Reports Application running on MS Windows 7/ MS Windows Server 2008 R2, if upgrade option is not feasible

• Ability to work independently with the Business/ Functional Teams to understand the requirements and come up with Optimal model for the data structures.

• Used Teradata DDLs created Tables, Views, Macros, Triggers and Stored Procedures.Implemented TASM (Teradata Active System Management) across enterprise for performance and load balancing.

• Sound knowledge of Oracle Database Performance tuning Sound knowledge of RMAN backup and recovery procedure Ability to work across multiple global sites. .

• Experienced on SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).

• Ability to understand the existing Data Integrations, and propose Optimal Data Integration Methodology.

• Operations Installation  Configuration of SQL Server 2008  2008R2  2012 on Local System and Well-versed in Remote Servers, and Configuring  Maintenance of SQL Server 2012

• Good knowledge of working with development teams with Loading, and Extracting Data (ETL)

• Detail knowledge of Sybase ASE v15.X

• Designed, implemented and supported a multi-domain MDM solution using Informatica MDM platform at enterprise level.Designed, modeled and implemented Reference Data sets (RDM) on Informatica MDM.

• Resolve issues with Oracle 6i Forms/Reports application running on windows 7 or Windows Server 2008R2, if upgrade option is not feasible.

• Experienced for Installation and Configuration pg_backrest (Backup) Tool.

• worked independently with the Business/ Functional Teams to understand the requirements and come up with Optimal model for the data structures able to Reverse Engineer existing database to understand the current implementation

· Familiar with FX market, previous experience in handling FX hedging and effectiveness control for major currencies

· Effectively supporting the implementation of the Group Financial Risks and working capital policies at local level

 

 

Technical Competencies:

 

Programming Languages SQL, PL/SQL, Oracle Golden gate, Oracle Integration Cloud, oracle Fusion,Unix Shell Scripting, Datastage,Informatica power center, Informatica Admin,IICS,D2K Oracle Forms/ Reports, Sybase DBA.Mongo db ,snowflake,DBT,Data model,, Ab-Initio,IBM cloud,AWS cloud ,Azure cloud ,ruby on rails,R,service now,Teradata, postgresql,  OBIEE, Oracle BI Apps

Development Tools TOAD, SQL *Plus, SQL Developer,  Informatica , PuTTY, Erwin

Database Oracle RDBMS 10g/ 11g/ 12c, Oracle DBA ,Mongo DB,Teradata,PostgreSQL

 

 

Project Details:

Voyager Partners

Client name:Parentpay

Role: Technical data architect

March 2025-Till date

Project Description

 

• Excellent working knowledge  with Teradata SQL Assistant. Developed BTEQ scripts to Load data from Teradata Staging area to Data Warehouse, Data Warehouse to data marts for specific reporting requirements. Tuned the existing BTEQ script to enhance performance.

• Developed and maintained ETLELT processes to support data analytics and reporting, using Python scripts and Snowflake tools for data transformation and integration.and managed Snowflake Cloud environments and performed Snowflake Admin Management tasks.

• Expert in Teradata RDBMS, initial Teradata DBMS environment setup, development, and production DBA support, use of FASTLOAD, MULTILOAD, TPUMP, and Teradata SQL and BTEQ Teradata utilities.

• Understanding and usage of SEO deployment strategies and social networking hooks.

• Experienced server and desktop user of Linux environments including Debian, Ubuntu, Arch, and their derivatives.

• Ensuring resource and operational efficiency to meet the Banking growth work on the various MIS

· Global banking experience with operational banking requirements in developed and emerging markets.

· Responsible for portions of treasury operations’ adherence with  compliance and adherence to board approved treasury policies.

· Planned and coordinated the administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long-range requirements, and operational guidelines.

• Managed the investments and cash flow of three public agencies ensuring compliance.Established a compliance schedule and review process to ensure full compliance of all outstanding bonds.Accurate reporting and presentation for all public documentation.

• Modeled new data models based on user requirements and updated existing data model

• Created new metadata and updated the existing Metadata.

• Developed custom interfaces between Oracle Fusion Financials and SAP using OIC, enabling seamless  payment processing.

• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps (OBIA), Informatica – Power Center and DAC.Online Data Move connection from within Oracle SQL Developer to Sybase source database and migrate the data.

• Involved in ETL Mappings, Mapplets, Workflows, Worklets using Informatica Powercenter 9.x

• Perform Oracle database administration tasks include configuration management, backup/recovery, performance optimization, and space management

• Developed platform using PHP backend and Bootstrap/jQuery UI.

• Maintained scalability and performance levels of .NET applications and related software.

• Implementing rest APIS in Python using micro-framework like Flask with SQLALCHEMY in the backend for management of data center resources on which OpenStack would be deployed.

• Prepares agency budget, allocation of funds, appropriation requests for the Agency’s operating.Capital budget and communication with the Department of Planning & Budget.

• Enhanced ServiceNow instance performance through regular upgrades and best practice implementations, increasing system uptime by 10%.

• Involved in Informatica application administration that includes creating users, connections, folders, and managed privileges on them

• Generated server-side PL/SQL Scripts for data manipulation and validated/ materialized views for remote instances

• Performed Installation of Repository Creation Utility and OBIEE 11.1.1.3 on Windows Server 2003 Environment.

• Integrated multiple source system using OBIA OOTB ETL framework using Informatica & DAC and Implemented Financial, Procurement and Spend Analytics.

• Implemented Snowflake’s data sharing features to streamline collaboration across departments, resulting in a 20% increase in data-driven decision-making efficiency.

• excellent understanding of Snowflake Internals and integration of Snowflake with other data processing and reporting technologies

• Generation of reports using Conditional Styles, Conditional Blocks, Render Variables.

• Designed Data Modeling, Design Specifications and to analyze Dependencies

• Involved in performance optimization of IICS jobs and design efficient queries to query data from azure cloud database.

• Plans and execute budget management program including fund review and staff instruction on coding procedures.Prepares financial, statistical, and continuing disclosure Annual Financial Report and Component Year-End schedules.Serves as an agency liaison in assisting auditors with questions relating to the Annual Financial Report.

 

 

ALTIMETRIK

Client: Takeda

Role: project manager data architect

Mar 2022 – Jan 2025

Project name: Radio pharmaceutical order management environment

Description: Project Description

· Develop and maintain strong banking relationships to ensure delivery of appropriate and cost effective global banking services and support.

 

Responsibilities.

 

• Ability to come up with Data Migration Requirements/ Strategy, Troubleshoot various problems that arise in a day-to-day work, and fix the issues

• Experience in monitoring and Performance Tuning; Physical Server Level, Database Level, and Query Tuning; Index and statistics, creation and maintenance

• Senior level Informatica Admin with extensive experience in Informatica PowerCenter, Installation and configuration of Informatica Power Center.

• Involved in importing and exporting the data from RDBMS to HDFS and vice versa using Sqoop.

• In depth knowledge on performance tuning, installing and configuring

• Developed  ServiceNow applications using JavaScript, AngularJS, and REST APIs and updated with the latest ServiceNow releases and industry trends for continuous improvement.

• Restoring/recovering databases from backups.

• Designing and developing DataStage jobs for loading staging data from different sources like files, Oracle, SQL server DB into data warehouse applying business rules which consist data loads, data cleansing, and data massaging.

• Installed and configured High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments (Front-end: Sun SPARC Server, Back-end: Oracle Exadata Full Rack).

• Ensure SLA’s and operational KPI’s are met, working as necessary with internal and external support functions when major incidents occur.

• Configured performance management, goal setting, and succession planning modules; created OTBI dashboards.

• Implemented monitoring tools and processes to ensure the reliability of data systems, and leveraged DBT for transforming data within Snowflake, if applicable.

• Developed and maintained the routines for automation of our PostgreSQL services and Performance tuning of our PostgreSQL services.

• Prepared Test cases and Test Data Create data manipulation and definition scripts using Teradata Bteq utility Involved in the analysis and design of the system Involved in Testing of prototype.

• Created Ab Initio graphs that transfer data from various sources like Oracle, flat files and CSV files to the Teradata database and flat files and used Ab Initio Components like Join, Rollup, and Reformat etc., as well as Partition and De partition extensively and functions like is_valid, is_error, is_defined, sting_substring, srting_concat and other string functions etc.

• Designing and implementing a fully operational production grade large scale data solution on Snowflake Data Warehouse.

• Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages, and procedures.

• Experience with Visual Studio Web Test & Load Test/ Jmeter / HP Performance Centre (Load Runner)with load testing products such as JMeter.

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement Business logic using SQL Navigator

• Extensive knowledge with Teradata SQL Assistant. Developed BTEQ scripts to Load data from Teradata Staging area to Data Warehouse, Data Warehouse to data marts for specific reporting requirements.

• Implemented .NET testing procedures through code designing and capabilities.

• Strong understanding of Treasury and Balance Sheet Management (liquidity, capital, interest rate risk, rwa forecasting, balance sheet optimization).

• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL, and PL/SQL engines

• Developing ETL pipelines in and out of data warehouse using combination of Python and Snowflakes SQL Writing SQL queries against Snowflake.

• Monitored database Backups and point in time restore in case of failure

• Extensively worked on PMON/Viewpoint for Teradata to look at performance Monitoring and performance tuning.Expert in Teradata Involved in upgrades of Informatica product suite from 8.6.1 to v9.1.

• Maintained web applications using .NET framework, ensuring adherence to coding standards and best practices.

• Designed & driven implementation of application architecture, including application domains, integration layer and scalability.Provided Informatica MDM Hub development expertise and detailed technical knowledge of Informatica MDM projects.

• Designed and Developed Forms for tracking the account details of the customer

• Performed SQL and PL/SQL tuning and Application tuning using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AutoTrace.

• Involved in D2K development. Worked on calling the procedures, functions and packages in form level using Forms 11g

• Introduced GitHub as a version control plugin for IICS.

• Designing and implementing a fully operational production grade large scale data solution on Snowflake Data Warehouse.

· Upgraded RPD and Catalog from OBIEE 10.1.3.4.1 to OBIEE 11.1.1.3 by using ua.bat file.

 

ACL  DIGITAL

Project name : FSI

Client: Novartis Pharma

Role: Technical lead

Aug 2019 – Jan 2022

Description: Project Description

Extensive experience in designing the Data models for OLTP & OLAP database system.

 

Responsibilities:

Implemented MVC Architecture by enabling data shared between model, view, and controller simultaneously.

 

• Collaborated with architects MDM and solution architects to design and deploy the MDM system to meet business needs.Designed, developed, debugged ETL routines, MDM hub configurations, data quality services, and workflow solutions.

• Installed, Configured Informatica product suite such as PowerCenter 9.1/9.5, Metadata Manager, Reference Table Manager (RTM), Essbase etc.

• Administer user, user groups, and scheduled instances for reports in Tableau.

• Resolved issues with Oracle Forms/ Reports 10g or higher applications to run on or already deployed on Oracle Exalogic Servers as well as MS Windows7/ 8, and MS Windows server 2008 R2/ 2012 use cases, like Development, Virtual machines, and Citrix platform.

· Expertise in applying Optimization Models, and a good theoretical grounding in core Machine Learning concepts and techniques.

· Analyzed OBIEE 11G technical solutions. Complete requirements analysis, capture and document the customer’s business and technical needs.

• Developed and launched a ServiceNow automation workflow that streamlined change management processes, cutting approval times by 40% and minimizing service disruptions.

• Created and maintained Snowflake data pipelines using Apache Airflow, ensuring reliable and timely data processing for analytics and reporting.

• Scheduled and monitored nightly batch jobs using Unix Shell Scripts.

• Developed processes and procedures for the measurement, restriction adherence, correct recognition.Provided efficiencies in the reporting process and increased transparency in the financial results for the executive team and the boards reported to.Accurate representation of the financial results, and clear communication of those results to the boards.

· Execute daily Treasury operations activities for global cash management. Oversee global daily cash position and monitor global cash status.

· Conducted thorough testing, debugging, and troubleshooting of Ab Initio jobs to identify and resolve issues, ensuring seamless data flow and minimizing downtime and Resolved critical data integration issues by conducting thorough troubleshooting and debugging of Ab Initio graphs, enhancing overall data quality and accuracy.

• Creating a shared container to simplify the DataStage design, and used it as a common job component throughout the project.

• Installed, configured, tested, monitored, upgraded, and tuned new and existing PostgreSQL databases.

• Experience in Oracle Business Intelligence Enterprise Edition (OBIEE 10.1.3.x/OBIEE Plus/OBIEE 11g) in the development of complex Dashboards, Answers, Agents/iBOTs, Oracle BI Publisher reports and data model – metadata repository (RPD) using OBIEE Administration tool.

• Developed Ab Initio applications (Graphs) using GDE for purposes such as data validations, data enrichments, data extractions and rule transformations.

• Developed complex Teradata SQL code  using OLAP and Aggregate functions.Extensively worked as a Teradata Developer and involved mainly in building Teradata warehouse.

• Knowledge of monitoring, logging and cost management tools that integrate with AWS

• Deep knowledge of Oracle 11g Grid Infrastructure, Clusterware, ASM, RAC internal, Active Data Guard in RAC environment.

• Exp in Production Database in OLTP systems. Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.

• Implemented web service calls using ruby on rails MVC framework and developed web applications using ruby on rails.

• Created reports and graph dashboards using OBIEE 11 G, incorporating into Oracle Web Center as necessary, to meet the business requirements of the project.

• Created and deployed new jobs in ruby to perform clean-up of application data and to extend existing features.

• Installed & Configured MDM Hub on Dev, Test and Prod Server, cleanse, and Address Doctor in Dev, QA.

• Informatica Admin required for supporting the entire enterprise Informatica platform and improve the design of existing Informatica mappings.

• Developed various new reports from scratch utilizing Oracle Reports Builder for day-to-day validations

• Created indexes on the tables for faster retrieval of the data to enhance database performance

• Provided financial and investment solutions to existing clients resulting in new assets under management.

• Design, development and implementation of performant ETL pipelines using python API (pySpark) of Apache Spark on AWS EMR Performance tuning of pySpark scripts.

Pinaki  Softcon Private Limited

Dec 2017 to Jul 2019

Project name: SCI

Client: SCB Group (Standard Chartered)

Role: Senior Software Engineer

Description:

Perform Oracle database administration tasks include configuration management,  backup/recovery, performance optimization, and space management

 

Responsibilities:

• Engaged in Dynamic SQL, Collections, and Exception handling

· Solved all customer issues in the investment banking department, increasing our customer base by 15%.

· Experienced establishing master data and reference data for domain entities using Informatica MDM and implementing data quality rules using Informatica DQ for a data mart or a data warehouse.

• Assisted in building the ETL source to Target specification documents by understanding the business requirements.

• Created Teradata objects like Databases, Users, Profiles, Roles, Tables, and Views & Macros.

Set up Teradata Workload Manager with the proper partitions and workloads based on Service Levels.

• Set up Teradata Query manager to automate many of the DBA tasks such as collection of statistics, monitoring spool space, candidate tables for purge, etc.

• Optimized existing Snowflake queries by analyzing execution plans and making necessary adjustments, leading to a significant reduction in query execution time.

• Implemented automated reporting solutions using ServiceNow Performance Analytics, resulting in a 40% reduction in reporting time across multiple departments

• Extensively used DataStage designer to develop processes for extracting, transforming, integrating and loading data from various sources into the data warehouse database.

• Pioneered a new code documentation method, leading to improved code maintainability by 20

• Implemented rally OpenStack benchmarking tool on the entire Cloud environment.

• Responsible for providing revenue, expense, treasury operation, and software management services to the County.Responsible for Coordination and performance evaluation of the Treasury Division.

• Responsible for creating, preparing, processing, collecting and posting Residents.

Responsible for Maintaining, posting and balancing all general ledger accounts, and bank statements Responsibilities included interviewing resolving problems.

· Developed key modules independently using PDL and Metaprogramming constructs using all Ab Initio components and Involved in designing Load graphs using Ab Initio and tuned the Performance of the queries to make the load process run faster.

· Developed ETL processes using Snowflake’s Snowpipe to automate data ingestion from various sources, significantly reducing the time required for data availability.

Knowledge in architecture of OBIEE, Informatica tools helped in thorough analysis of backend log files and trace files to troubleshoot any application errors / issues.

· Created Teradata objects like Databases, Users, Profiles, Roles, Tables, and Views & Macros and Set up the Teradata Workload Manager with the proper partitions and workloads based on Service Levels.

· Extensively used different types of DataStage stages like modify, sequential file, copy, aggregator, surrogate key, transformer, dataset, look up, join, remove duplicates, cff, sorter, column generators, cdc, and funnel.

· Migration of ETL objects, SQL scripts using Kintana and ClearCase and also migrated OBIEE objects using catalog manager Worked extensively in creating OBIEE reports with Guided navigations, Drill down function, Conditional formatting, Summary detail views, external web links, HTML and CSS formatting options.

• Responsible for dealing with Bank’s Internal & External auditors & inspectors thereby complying with statutory norms & Bank’s laid down policies.

• Updated the latest security patches to the database, which are provided by the PostgreSQL open-source community.

• Perform Informatica Power Exchange System Administration including team-based development administration.

• Ability to design high availability applications on AWS across availability zones and availability regions.

• Utilized Oracle Forms and Reports 10g/ 11g, and PL/SQL for software development and maintenance in the Insurance industry

• In a secondary role, the Senior AWS Engineer will be expected to provide support extending beyond AWS in corporate datacentre and Amazon cloud.

• Implemented complex ETL pipelines in Snowflake that allowed for the ingestion and transformation of diverse data sources, enhancing the analytical data foundation.Proficient in Informatica administration work including installing and configuring Informatica PowerCenter and repository servers on Windows and UNIX platforms, backup and recovery, folder and user account maintenance.

• Provided support for the clients in production environments, including database replication, backup/ recovery, imports/ exports from other databases, and upgraded the database.

• Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.

• Install upgrade Tableau server and server performance tuning for optimization.

• Developed various ETL transformation scripts using Hive to create refined datasets analytics use cases.

• Imported data from Oracle database to HDFS using Unix based File Watcher tool.

• Engaged in Informatica 9.0/ 8.6/ 8.1 client tools – Designer, Repository Manager and Workflow Manager

• Experience assisting customers with setting up new services. Proficiently assists corporate clients with all their banking needs.

• Perform data analysis and develop data models to support OBIEE dashboards and reports.

• Strong database performance tuning skills – query optimization and server tuning with Sybase and SQL platforms

 

 

Larsen and Toubro Infotech,

Nov 2016 to Oct 2017

Project name: GCBC

Client: Citi Group

Role: Software Engineer

Description:

Expertise in Dynamic SQL, Collections and Exception handling.

 

Responsibilities:

• Designed the Web application Using Python on Django Web Framework pattern to make it extensible and flexible

• Implement systems that are highly available, scalable, and self-healing on the AWS platform.

• Experience in migrating Sybase from Solaris to Linux platform and Sybase to SQL platform

• Designed Oracle Reports 10g/ 9i/ 6i for complex projects

• Developed a best practice or standards document for Oracle 6i/ 10g/ 11g Forms/ Reports application development.

• Developed RapidRents, a civic web app built in collaboration with providing a wide range of tools to residents looking for affordable and stable housing options.

• Project managing upgrade of asp applications to ROR and build of customer-facing applications

• Created a user account management portal, various geo-location, and map search features and tenant-focused features enabling quick and easy communications with landlords.Fix and maintain bugs for improved web functionality and efficiency.

• Followed agile development practices with daily stand-ups and regular product demo days with product stakeholders.

• Deployed OBIEE 11g RPD and Web Catalog by using Web logic Enterprise Manager. and Implemented end-to-end BI reporting solutions using Oracle Business Intelligence (OBIEE) 11g.

• Designed and developed Oracle Forms Reports using Forms11g/ 10g/ 6i, and Reports 11g/ 10g/ 6i Including Forms based on stored procedures.

· Created automated workflows and scripts on ServiceNow, significantly reducing manual process time by 35% and minimizing human error.

· Created Teradata DDLs created Tables, Views, Macros, Triggers and Stored Procedures and Set up Teradata Query manager to automate many of the DBA tasks such as collection of statistics, monitoring spool space, candidate tables for purge, etc

· Prepare, validate and consolidate global cash forecast to improve reliability on the global cash position, borrowing levels and availability of funds.

• Developed interface for item data conversion to load items from flat file to Oracle Inventory using SQL* Loader, PL/SQL, and imported items program.

• Designing several DataStage jobs using join, merge, lookup, change apply, change capture, funnel, filter, odbc, column generator, transformer, modify, surrogate key, aggregator, decode, row generator and XML stages.

• Architecting and implementing very large scale data intelligence solutions around Snowflake Data Warehouse.

• Extensively used Ref cursor, Bulk collect, PL/SQL Collections, and Dynamic SQL.

• Reduce software defects by 35% within the first quarter by implementing a new testing framework using Selenium and JUnit. bug tracking process with Jira, cutting down reporting and resolution time by 25%, which accelerated product release cycles.

• Involved in Database Query tuning, and Implementation

• Handled errors using Exception Handling extensively for the ease of debugging, and displayed the error messages in the application

• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Updated Strategy Designing, and optimized the Mapping

• Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Unions, Intersect and Aliases

• Involved in Informatica administration work including installing and configuring Informatica Power Center and repository servers on MS Windows and Unix platforms, backup/ recovery, folder and user account maintenance.

• Experience in Configuring and Integrating the Servers with different environments to automatically provisioning and creating new Installed and configured PostgreSQL from source or packages on Linux machines.

· Developed and maintained data models in Snowflake, supporting business intelligence initiatives and enabling a 10% increase in reporting accuracy.

· Designed a comprehensive data model in Snowflake specifically tailored for marketing analytics, leading to a 20% increase in campaign ROI due to improved targeting.

· Working experience in Treasury covering Corporate Finance, Cash Management, and Financial Risk Management.

• Developed and Published Packages in Framework Manager.

• Collaborated with cross-functional teams to gather and analyze business requirements, translating them into technical specifications for Ab Initio workflows, ensuring seamless integration with existing systems.

• Designing data model from scratch to aid team in data collection to be used for Tableau Visuals.

• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

• Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads

• Create Users, Groups and Roles in Admin console (Administrator) and assign the privileges to the same..

• Performed data analysis and develop data models to support OBIEE dashboards and reports

Strong knowledge of Informatica ETL and Oracle/DB2 database technologies

• Experienced in optimizing performance in relational and dimensional database environments by making proper use of Indexes .

• Experience in using DBMS_SCHEDULER to run jobs in parallel to improve time-constrained performance

· Drive a global cash flow forecast process and provide various cash flow analysis as needed Run the monthly  settlement process.Manage the FX trading program including spots and hedging program.

· Maintain responsibility for analysis of Sybase and SQL code.

· Provide recommendations for minimizing foreign currency risk; aiding in development and execution of holistic foreign currency risk management strategy.

· Installed and configured High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments (Front-end: Sun SPARC Server, Back-end: Oracle Exadata Full Rack).

 

 

 

Azure Systems

Apr 2011 to Jul 2016

Project name : FMC

Client: First Merchants Corp

Role: Software Engineer

Description:

Expertise in Dynamic SQL, Collections and Exception handling.

 

• Designed Oracle Reports 10g/9i/6i for complex projects.

• Strong database performance tuning skills – query optimization and server tuning with Sybase and SQL platforms.

• Develop a best practice or standards document for Oracle 6i/10g/11gForms/Reports application development.

• Worked on Data cleanup, ETL and handling scalability issues for enterprise level data warehouse

• Implemented, troubleshot, and optimized distributed solutions based on Informatica product

• Wrote and executed various MYSQL database queries from python using Python-MySQL connector and MySQL DB package

• Created, managed, and modified logical and physical data models using a variety of data modeling

• Involved in CSS for whole site following Django MVC Architecture.

• Experience in dataset registration in Exchange for S3, One Lake, and Snowflake

• Created load scripts using Teradata Fast Load and Mload utilities Code Reviews and Code walk through of  prototype.

• Designed and developed various custom packages triggers and forms

• Generated various report using Python Report lab and sent to Business users to improve their decision making.

• Manages professional-level responsibilities in support of accounting, auditing, reporting, and budget analysis.Performs treasury management for multiple accounts to include monitoring and funding operating.

• Created Test cases for the mappings developed and then created integration Testing Document

• Involved in Tuning of SQL Queries, Explain plan, and DBMS_Profiler

• Experience in installation, configuration and migration with both Sybase and MS-SQL database platforms.

· Monitor and ensure compliance with policies, procedures and operational controls related to global cash management with support for audit as needed.

· Optimized ServiceNow platform performance by implementing best practices and conducting regular audits, resulting in a 50% reduction in system downtime.

· Analyzed complex business requirements and translated them into ServiceNow functionalities, resulting in a 25% improvement in service delivery

· Designed and developed the process for real-time data movement of reference data from Sybase to db2 using a mix of DataStage jobs.

· Participated in migration and integration of Sybase database servers.

· Excellent understanding of Snowflake Internals and integration of Snowflake with other data processing and reporting technologies

· Working on admin tasks like deployment of reports, security patching and report user group access to application.

· Customized various OOTB ETL mappings and built custom DAC tasks, subject areas & execution plans as per business requirements including configuring domain values and transaction types.

· Installed and configured PostgreSQL from source or packages on Linux machines.

· Automated routine data loading tasks using Snowflake’s native tools, reducing manual effort by 30% and improving operational efficiency

· Created Service Requests (SR’s) for RPD and Reports issues and coordinated with Oracle support team for resolution of the Issues Creation and Mapping of Application Roles and Policies using Fusion Middleware Control.

• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security.

• Used SQL*Loader as an ETL tool to load data into the staging tables

· Optimized performance of Ab Initio graphs by tuning database connections, implementing parallel processing techniques, and utilizing advanced transformations, resulting in a 20% increase in data processing efficiency.

Experience in Datastage as an ETL tool to extract data from sources systems, loaded the data into the IBM DB2 database.

· Manages daily cash positons, and invest/borrow funds as required under Corporate guidelines.

· Analyzes and consolidating daily cash movements in support of global cash positioning reports and cash flow projections.

• Prepared the error handling document to maintain the error handling process

• Worked on maintenance tasks like index defrag or rebuild on different databases

 

 

Yalamanchili Software Exports Private Limited

Sep 2010—Feb 2011

Client name:city union Bank

Project name:CUB

Role:Software Engineer

Project Description

• Worked on database backup and restorations Implementation of Logins creating Users  assigning responsibilities as a part of Security Policies for various categories of User Support

• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

• Performed data mapping to determine where identified source data belonged in the Database.

• Focused on Software Quality Assurance, Performance Testing, and Agile Methodologies

and Co-developed an innovative approach to smoke testing, which decreased production defects .

• Perform general ETL administration duties that includes Product setup, upgrades, migrations, patching, storage management, security & performance tuning.

• supporting informatica admin activties in all environment and migrating the code from one evironment to another environment.

• Oracle database administration skills and experiences in high-end telecom and financial enterprise environments (DB size from 2 TB to 60TB) across multiple industries including design, development, implementation, migration, upgrading, maintenance of RAC, ASM, Data Guard, GoldenGate and production support of complex database applications and huge data warehouse system.

• Designed the database Backup and Restoration Strategy.

• Well versed with Teradata Analyst Pack including Statistics Wizard, Index Wizard and Visual Explain.

• Implemented Test Driven Deployment (TDD) using Rspec and Jasmine spec runner to perform unit and functional testing.

• Developed reusable test scripts with QTP, reducing test preparation time by 40% and boosting overall test execution speed.

• Strong database performance tuning skills – query optimization and server tuning with Sybase and SQL platforms.

• Handling and making decisions regarding Doorstep Banking which has been provided service quality department.

• Collaborated with architects MDM and solution architects to design and deploy the MDM system to meet business needs.Designed, developed, debugged ETL routines, MDM hub configurations, data quality services, and workflow solutions.

• machines using Configuration management/provisioning tools like Ansible.

• Developed Drill Through, Prompted Reports, Cascading Prompts and Master/Detailed Reports

• . RDBMS, initial Teradata DBMS environment setup, development, and production DBA support, use of FASTLOAD, MULTILOAD, TPUMP, and Teradata SQL and BTEQ Teradata utilities.

• Wrote packages to fetch complex data from different tables in remote databases using Joins, Sub Queries, and database links:

• Involved in creating UNIX Shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.

· Experience in Corporate Treasury including cash management, funds transfer and check processing

· Have good understanding of derivatives, hedging, investments, bank account management, and international funds flows

· The creation of efficient and effective processes to monitor funding structures moving forward

· Oversee the development and maintenance of the global banking structure, ensuring proper internal controls are in place and effective.

· Experienced with DBT for data transformations and workflow management, data warehousing, query optimization, performance tuning, and integrating data pipelines using Matillion, dbt, and Snowpipe. Experience in dataset registration in Exchange for S3, One Lake, and Snowflake.

· Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

· Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.

· Scheduled and monitored nightly batch jobs using UNIX shell scripts.

·

 

Education

 

Master of engineering in  Anna University 2010