Database developer/ Analyst

Location:

Trabuco Canyon, CA

Posted:

August 06, 2023

Contact this candidate

Resume:

Karthika Bathina

Ph: 949-***-****

eMail: ********.*******@*****.***

PROFESSIONAL SUMMARY:

●Over 7 years of experience in the development of Application Software Design, Development and Management on Oracle 19c, 12c, 11g, 10g, SQL Server, SnowFlake, DBT, Weblogic, JEUS, WebtoB, Airflow, Informatica, SharePoint, C#, Crystal Reports/Crystal Enterprise 9.0/10.0/XI, SSIS, SSRS, Business Objects, MicroStrategy, Tableau and Power BI.

●Involved in Design phases of the projects and Well experience in leading Database and Application teams.

●Efficient in designing, developing Conceptual, Logical and Physical Datamodel, ERD Diagrams following Data Integrity, Redundancy, Transparency, Auditability, Accountability, Standardization, MDM, CDM, Risk Managements and other Data Governance principles.

●Proficient in implementing Normalization and De-Normalization techniques on Relational (OLTP) and Dimensional (OLAP) Datamodels.

●Well experienced in designing and developing Data warehouse in Star Schema, Snowflake Schema, Multi Start Schema, Confirmed Dimensions, Slowly Changing Dimensions and Datamarts.

●Strong RDBMS concepts and well experience in creating database objects like Tables, Views, Sequences, triggers, Collections, etc. taking the Performance and Reusability into consideration.

●Very proficient in writing Stored Procedures, Standalone Functions, Nested Functions, building Packages and developing Public and Private Sub-Programs using PLSQL, TSQL and providing Documentation.

●Optimal in performing Database Tuning in reducing the Cost and Cardinality of the SQL Queries by using various Hints and Optimizers on looking at the Explain Plan.

●Improving the Performance of the SQL Queries, Functions, Procedures, Packages and Database Objects by creating Normal, Unique and Bitmap Indexes.

●Optimal Experience on WebLogic 8.x, 9.x, 10.x,11 Server JEUS 7.0, WebtoB, Apache http Server, Apache Tomcat Server as administrator for Server Installations, Node Manager Configuration, Application components deployment, Cluster Management, Load Balancing, performance tuning including troubleshooting and maintenance.

●Migrated Data from On-Prem Oracle to aws Cloud via S3 Buckets using Airflow and DBT on SnowFlake.

●Proficient in designing Metadata based ETL Process using Airflow and DBT products for Generic Data Movement.

●Designed end to end Pipelines on Airflow Integrating DBT Models with Centralized Notification process.

●Designed and Developed SQL based Incremental, Snapshot models on DBT to ingest data into Data Warehouse

●Involved in configuring Multi Cluster Scalable Warehouses sizes on SnowFlake

●Good experience in following CICD based deployment of the Artifacts on GIT on Database and Server based Projects.

●Extensive experience on Informatica and Data Integrator ETL Tools to Design, Develop Mappings, Workflows, Schedule daily jobs and process monitoring.

●Involved in the design architecture of transformations and loading methodologies in Informatica and Data Integrator.

●Expertise in Designing, Developing and writing complex SSRS and Crystal Reports to create Static, Dynamic and Dynamic Cascade Parameters using Visual Studio, Crystal Designer.

●Proficient in design, development, deployment and administration of Business Objects Universes, Web Intelligence, Desktop Intelligence.

●Extensively used SSRS, Oracle Forms, Crystal Reports, Universes, Web I, Crystal Publishing Wizard, Import Wizard, Infoview and Central Management Console.

●Experienced in migrating different versions of Business Objects reports and universes from Business Objects V5.x, Business Objects V6.x to Business Objects XIR1/R2

●Excellent communication and interpersonal skills. Versatile team player with proven problem-solving skills. Worked independently as well as in team environments and Experience in Interacting with users for business requirements.

TECHNICAL SKILLS

RDBMS:

Oracle 19c/12c/11g/10g, MYSQL, MS SQL Server 2000/7.0/6.5, MS-Access2000

Middleware

Weblogic, Jeus, Apache, WebtoB, HP Diagnostics, Java Visual VM

Reporting Tools:

Crystal reports 9.0/10/XI, Crystal Enterprise 9.0/10/XI, Business Objects 6.x/XIR1/XIR2/XIR2, Oracle Forms, BO Universe Designer 6.X and SP2(X1), BO Web Intelligence XIR2, BO Desktop intelligence XIR2

ETL Tools:

Airflow, DBT, Informatica Power Center, Data Integrator

Languages:

C, C++, Java, Visual Basic, PL/SQL, SQL, SQL*Plus, perl, Python, Cobol.

Operating Systems:

Windows 2003/2000, Unix, Linux

Web Technologies:

Java Visual VM, HTML, Python, PHP, C#, Macromedia Dreamweaver, MS FrontPage 2000

Modeling and Other Tools:

Erwin, PowerBuilder, PLSQL Developer, Adobe, SQL*Plus, SQL developer, TOAD, IBM Rational Clear Case and Clear Quest, Microsoft Visual Source Safe.

Professional Experience:

Sumitomo - SRNA

Rancho Cucamonga CA June 2022 – Present

Data Warehouse/Reports Developer

Sumitomo is a Tire Manufacturing Company and one of the largest wholesale tire distribution company operating business across United States of America. The Tires are manufactured and distributed from Thailand and china to other countries and we deal with SRNA deals with sales and returns to the distributors across United States in particular POI. Worked closely with Fianance Team and Internal Audit Team doing the GAP analysis and developed Reporting models based on Business Patterns.

Responsibilities:

Data Modeling and Programming:

●Involved in gathering the Functional requirements and Design specifications from the End User and developed Reporting Data model.

●Transformed the logic from Business Requirement documents into Oracle Functions, Procedures, Packages, Views, Materialized Views, Triggers, etc.

●Created Database Schema Objects like Tables, Views, Indexes, Triggers and Sequences, etc.

●Implemented Dynamic SQL in Procedures and Packages and populated the data.

●Efficiently reduced the Cost and Tuned the SQL Queries by using various Hints and Optimizers on looking at the Explain Plan.

●Completely performed the data validation on the base tables for execution of the AIS cycle Package.

●Loaded the data into Tables from various Flat files using SQL Loader and implemented Data Cleansing process.

●Worked on populating the data in the DataMart Tables in Star schema and Snowflake schema, Aggregate.

●Involved in developing the Datawarehouse for the complete Actuarial Information System Application and Reports Development using SQL.

●Migrated Data from On-Prem Oracle Database to aws Cloud via S3 Buckets

●Developed Analytical Datamodel on SnowFlake for Reporting and Historic Data Requirements.

●Involved in configuring Multi Cluster Scalable Warehouses sizes on SnowFlake.

●Performed ETL process using Airflow and maintained a metadata around generic Implementation and process automation.

●Designed and Developed SQL based Incremental, Snapshot models on DBT to ingest data into Data Warehouse.

●Designed end to end pipelines on Airflow integrating Data Movement with DBT Models.

●Good experience on SVN and GIT on CICD based deployments and Migrated Projects from SVN to GIT.

Reporting:

●Designed and Developed Parameterized Queries for generating Tabular reports, Row and Column Grouping, formatting report layout, Sub reports using Global Variables, Expressions, Subtotals, Functions, Defining Data Source.

●Designed and Developed Power BI Datasets and Dashboards on Multi Page visualizations.

●Efficiently modeled the dataset in Power BI using the Analytical Data Marts.

●Built deployment pipelines and Dataset Gateways in Power BI

●Developed Attributes, Facts, Metrics, Datamodels and Designed Dossiers and Documents in MicroStrategy.

●Integration of MicroStrategy and Power BI with AutoSys to Automate Data Refreshes.

Environment: Oracle 19c, SnowFlake, DBT, Airflow, Informatica, ASP.net, LINUX, MicroStrategy, Power BI, SVN, GIT.

Hyundai Capital America March 2020 – May 2022

Newport Beach CA

Datawarehouse Developer (Pl/SQL with Power BI)

Hyundai Capital America is a part of the Hyundai Motor Group family of companies, supporting the financial services needs of Hyundai Motor America and Kia Motors America, Inc. Hyundai Capital America provide financial products tailored to meet the needs of Hyundai and Kia dealerships nationwide, including dealer inventory and facility financing. And, through these dealerships, we provide indirect vehicle financing and leasing solutions to over 1 million retail customers. Hyundai Capital America’s subsidiary, Hyundai Protection Plan, Inc. offers vehicle service contracts and other vehicle protection products.

Responsibilities

Data Modeling and Programming:

●Designed the Enterprise Datamodel in 3rd Normal Form by following Data Governance principles and establishing entity to entity relationships.

●Proficiently implemented Normalization and De-Normalization techniques on Relational (OLTP) and Dimensional (OLAP) Datamodels.

●Expertly designed and defined the entity-to-entity relationships and proficiently transformed Conceptual, Logical Datamodels to Physical Datamodels.

●Architected framework for MDM and Datawarehouse solutions to provide Datamart solutions on Policy, claim and risk analysis.

●Identified potential pitfalls like Fan Trap and Chasm Trap and proficiently resolved the issues.

●Implemented Slowly Changing Dimension Types for various modules as per Functional process and Business needs.

●Developed Datamarts in Star Schema and Snowflake Schema in building Enterprise Data warehouse and designed the operation of replication servers.

●Active interaction with the end users in gathering critical requirements and documented the entire process in EPLC standards.

●Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.

●Worked on Private Temporary Tables in Oracle Database 18c and Qualified Expressions in PL/SQL in Oracle Database 19c.

●Worked on Inline External Tables in Oracle 19c and JSON Enhancements in Oracle Database 19c.

●Application of Oracle Database 19c Patch Release Update in both QA and Production environments.

●Created complex and robust Stored Procedures, Functions and various Database Objects and implemented Performance Tuning techniques.

●Automating Deployment process on Database and Application servers with custom shell scripts and Installation Tool.

●Automated the programs to handle exceptions and made user friendly for the end users to execute themselves.

●Developed Procedures to Capture the Trace Files at Instance Level using SQL Trace and TKPROF.

●Created Database Objects like Tables, Procedures, Datafiles, Tablespace, Functions, Packages, Indexes, Constraints, etc for effective and efficient performance on the Database.

Reporting:

●Developed SSRS Reports specific to Line of Business.

●Designed Dossiers, Relational Data Blending and Documents in MicroStrategy.

●Integration of MicroStrategy and Power BI with AutoSys to Automate Data Refreshes.

●Experience in Cluster Management, Fail Over Management, setting up Node Managers, Admin.

●Designed Datamodels in Power BI Query Builder and Developed Datasets specific to reporting needs.

●Analyzed ETL Process and Automated Power BI Datasets refresh mechanism from Autosys.

●Built deployment pipelines and Dataset Gateways in Power BI

●Developed Multi Visual Page Dashboards referencing the underlying Datasets

●Parametrized Dataset source connections for systematic deployment pipelines

Environment: Oracle 19c/11g, SQL Server, Weblogic, Apache, Jeus, WebtoB, AIX, Solaris, HP Diagnostic Probes, Java Visual VM, perl, ASP.Net, F5 Load Balancer, Informatica.

Auction.com June 2019 – February 2020

Irvine CA

Datawarehouse Developer (PL/SQL with Power BI)

Auction.com has distinguished itself as the world leader in maximized asset disposition strategies, asset management and real estate sales. Our expertise lies in selling residential, commercial, luxury homes, multi-family and hospitality properties, land, as well as performing and non-performing notes and loan pools.

Responsibilities

Data Modeling and Programming:

●Involved in designing Conceptual, Logical and Physical Datamodels for the entire Database Architecture.

●Excellent Governance on the entire Database Architecture in terms of Business Process Management and Risk Management.

●Designed Relational Datamodel in 3rd Normal Form and normalized the legacy data.

●Designed Dimensional Datamodels in Start Schema and Snowflake schema to the fines level of Granularity in terms of Business Reporting.

●Designing, Developing, Enhancing and Maintaining Data warehouse Oracle PL/SQL scripts, DB Procedures, DB functions, creating tables and indexes.

●Developed Data flow diagrams, ER diagrams to migrate the data from legacy systems, ETL, process the data according to DW methodologies, apply star schema and store them in Data mart tables.

●Worked on populating the data in the Datamart Tables in Star schema, Snowflake schema, Multi star schemas, Aggregate tables and normalized.

●00…….0Identified the Circular references in the Datamodel and efficiently resolved the issues.

●Created Database Tables, Views, Indexes, Triggers and Sequences and Developed the Database Structure.

●Developed Packages to populate the data into the Base tables.

●Developed shell scripts to export and import XML files into the database and schedule daily jobs on Linux server.

●Developed shell scripts to SCP the files from Source to Target systems and developed Load Batch Files.

●Upgrade and expand functionality of several perl and shell scripts using Python.

●Conceptualize, Design, develop tool in python to Parse log files and export contents to ElasticSearch repo via RESTful interface

●Interaction with the End users for the Functional requirements and Design specifications in EPLC Standards.

Reporting:

●Designed and Developed Power BI Datasets and Dashboards on Multi Page visualizations.

●Efficiently modeled the dataset in Power BI using the Analytical Data Marts.

●Built deployment pipelines and Dataset Gateways in Power BI

●Designed Dossiers, Relational Data Blending and Documents in MicroStrategy.

●Integration of MicroStrategy and Power BI with AutoSys to Automate Data Refreshes.

Environment: Oracle 11g, MYSQL, SSRS, MicroStrategy, perl, PHP, Python, ASP.net, Informatica, Microsoft Visual Source Safe, LINUX.

CVS Caremark January 2017 to May 2019

GalaxE Solutions

Somerset NJ and Detroit MI

Application Developer Pl/Sql

ProHELPDESK is the primary component of a larger pharmacy benefits management solution, ProPBM. The ProPBM system provides online, real-time claims adjudication, network editing, reliable reporting, and system flexibility. The key system features include Benefit Design Flexibility (BDF), Member Eligibility, Help Desk Tools and Centralized Prescription History.

Responsibilities:

Data Modeling and Programming:

●Supervised the work of the development team and assigned the tasks among the team members.

●Organized daily team meetings to review the tasks accomplished and tasks need to be accomplished.

●Travelled to the Client sites and interacted with the Clients directly and the Executives to discuss the project details and Resource Management.

●Lead the development team proficiently, Stabilized the system with proficient Data Governance implementation and developed the end product efficiently.

●Involved in the Designing of Business requirement and technical design documents.

●Designed the Prototype for Conceptual and Logical Datamodels and Prepared Physical Datamodels.

●Worked on populating the data in the Datamart Tables in Star schema, Snowflake schema, Multi star schemas, Aggregate tables and Normalized.

●Implemented Slowly Changing Dimension Types for various modules as per Functional process and Business needs.

●Involved in developing the Datawarehouse for the complete Actuarial Information System Application and Oracle Forms Development.

●Identified potential pitfalls like Fan Trap and Chasm Trap and proficiently resolved the issues.

●Active interaction with the end users in gathering critical requirements and documented the entire process in EPLC standards.

●Created IV&V(Independent Verification and Validation) procedures to perform analysis on the entire Database for Active Groups and their Hierarchical Object Dependences and vice versa.

●Automated the programs to handle exceptions and made user friendly for the end users to execute themselves.

●Created complex and robust Stored Procedures, Functions and various Database Objects and implemented Performance Tuning techniques.

●Developed Procedures to Capture the Trace Files at Instance Level using SQL Trace and TKPROF.

●Created Database Objects like Tables, Procedures, Datafiles, Tablespace, Functions, Packages, Indexes, Constraints, etc for effective and efficient performance on the Database.

Environment: Oracle 11g, 10g, Weblogic, Apache, Erwin, perl, PowerBuilder, Oracle Forms, ASP.net, Informatica, AIX UNIX.

DTE Energy December 2015 – December 2016

Detroit MI

PLSQL Programmer

DTE generates, transmits and distributes electricity to customers in southeastern Michigan. It is the largest electric utility in Michigan and one of the largest in the nation. My Project at DTE involved various tasks such as migration of applications/databases and integration with systems and processes from SQL Server to Oracle, to provide better public access to data, promote mission success and improve internal client data usage productivity.

Responsibilities:

Data Modeling and Programming:

●Worked as team lead and assigned the work uniformly among the team members, reviewed the performance of the team members and governed the team efficiently.

●Organized daily scrum meetings among the team members to review progress on daily tasks.

●Administered the team and communicated the status of the project to the Executives from time to time.

●Involved in gathering the Functional requirements and Design specifications from the End User and developing Data model for the Database.

●Transformed the logic from Business Requirement documents, Mainframe and COBOL codes into Oracle Functions and packages.

●Performed Reverse Engineering strategy on Legacy systems and proficient in Governing the entire Database design.

●Created Database Tables, Views, Indexes, Triggers and Sequences and Developed the Database Structure.

●Developed Packages to populate the data into the Base tables.

●Building the Datamart Tables for individual Extracts by taking Performance and Reusability into consideration.

●Implemented Dynamic SQL in Procedures and Packages and populated the data.

●Efficiently reduced the Cost and Tuned the SQL Queries by using various Hints and Optimizers on looking at the Explain Plan.

●Loaded the data into Tables from various Flat files using SQL Loader and implemented Data Cleansing process.

Reporting:

●Involved in the administration of Central Management Console (CMC) for implementation of security at Report level, Folder level. Created Users, user groups.

●Published objects to Business Objects XI R2/R1 Enterprise system using Import Wizard, Publishing Wizard, Infoview and CMC.

●Used Schedule Manager to change the database parameters for multiple reports at once during migration of reports between environments.

●Developed formulae using both the crystal syntax and the basic syntax to use in the reports and for reusability.

●Used dynamic cascading prompts and static parameters for different record selection criteria.

●Built reports using drill down and hierarchal grouping functionalities of crystal.

●Exported reports into various formats like Editable RTF, XML, PDF, HTML, EXCEL, and WORD using Crystal Reports XI for user.

●Offered training to Business users in using Infoview to Schedule, Run, and View the report Instances.

Environment: Oracle 11g, Erwin, UNIX, Weblogic, Crystal Reports 2009, Business Objects 3.1, MS Access 2003, SSIS, SSRS, UNIX.

Contact this candidate