Data Developer

NAVEEN MAREDDY

Phone No: 804-***-****

Email: *****@*****.***

EXPERIENCE SUMMARY:

Over 8+ Years of hands on experience in the software industry with the Software Development Life Cycle through Requirements Gathering, Database Analysis, Design & Development, Testing, Implementation, Production Support, Maintenance, Documentation and Delivery.

Highly experienced in Software Design, Analysis, Coding, Development and Testing with specialization in ORACLE 18c/12c/11g/10g based on Cloud, Client-Server & Three-Tier Computing Architecture.

Experienced in Project planning, scheduling, technical & functional design specification, coding, and unit & system test plan.

Experience with various tools, technologies and languages such as SQL, PL/SQL, Oracle APEX, ODI – Oracle Data Integrator, ODV – Oracle Data Visualization, Tableau, Oracle Forms, Oracle Reports, SQL*Loader, TOAD, PL/SQL Developer, SQL Navigator, Rational Clear Case, Perl, Python, Crystal Reports, Cognos Reports.

Expert in Development of PL/SQL Stored procedures, Functions, Database triggers, Packages, Cursors, Handling Exceptions and other database objects to implement business logic.

Design, code and maintain complex data extraction, transformation and loading (ETL) processes using ETL tools like ODI and Informatica.

Hands on technology experience of designing and developing software applications with Microsoft .NET Framework 1.0/1.1/2.0/3.0/3.5 using C#, ASP.NET and ADO.Net.

Strong experience in Data Visualization, Data Quality, Data Analysis, Data Validation, Data Profiling, Data Verification, Data Mapping, Data Staging, Data extraction using flat files like .csv, .txt, .exp etc. and Data Loading.

Experienced in designing front-end interfaces using mod_plsql, JavaScript, HTML, Bootstrap, jQuery, Ajax, CSS, Oracle APEX (Application Express) and XML.

Developed Unix Shell, Python and Perl Scripts to automate backend jobs, loading data into the Database.

Performing problem assessment, resolution and documentation in existing ETL packages, mapping and workflows in production.

Expertise in designing, developing analytical reports, dashboards using Tableau, Oracle Data Visualization (ODV), Crystal Reports XI, Cognos 10 and other BI tools to show trends, forecasting and future predictions.

Designed UML Diagrams like E-R Diagrams using ERWIN and Designer 2000.

Excellent Database (On-Prem & Cloud) administration skills including user authorizations, Database creation, Tables, indexes, scheduling jobs and clusters creation.

Experience in Batch processing, Performance Tuning Data Modeling, Import-Export utilities, and scripting.

Strong knowledge of Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema.

Experience in Scrum, Agile and waterfall methodologies.

Experienced in using Oracle Cloud and AWS Cloud to spin up database instances, adding/editing users/groups and setting up alerts/notifications.

Strong Problem solving, Decision making and Result oriented skills.

Team player with excellent interpersonal skills, and professional communication skills and ability to work as part of a team.

Able to work independently under minimum supervision.

TECHNICAL SKILLS:

Tools

Oracle Apex 19.2, Oracle Forms 10g/9i, MS Access, SQL Navigator, TOAD, PL/SQL developer, SQL Workbench, ERWIN, Power Builder (10,8), ESRI Arcgis, Oracle ODI, Informatica 7.1.3, Smart Draw, Ellucian Banner

Programming

SQL, PL/SQL, Shell Scripting, HTML5, Bootstrap, JavaScript, XML, JQuery, AJAX, CSS, Python

Source Control

Tortoise SVN, GitHub, Serena PVCS, Bit Bucket

Operating Systems

UNIX(AIX, Sun Solaris, HP-UX), Windows XP/2003/2008, LINUX, DOS 6.0/3.0

Database

Oracle 18c/12c/11g/10g, MySQL, SQL Server, Snowflake, Redshift, Ms-Access.

Dimensional Modeling/Tools

ERwin 4.x/3.5.2/3.x, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Physical and Logical Modeling, Oracle Designer 9i/6i

Analytical/Reporting

Oracle Reports 10g/9i, Crystal Reports 11, Cognos 10, Oracle Hyperion, Oracle Data Visualization (ODV) 12.2.4.3, Tableau 2018.1.1

EDUCATION:

Degree

University

Major

Location

GPA

Masters

Monmouth University

Computer Science

West Long Branch, NJ

3.4

Bachelors

JNTU

Electronics and Communication Engineering

Hyderabad, India

3.0

CERTIFICATIONS:

Certified Associate in Oracle Database 11g Administration.

Oracle Data Integrator 12c Certified Implementation Specialist.

AWARDS AND RECOGNITIONS:

Citation of Special Recognition – DPI, Dec 2016.

GALS Team Award, FDACS – DPI, May 2014.

Medallion of Merit, FDACS – DPI, May 2014.

Medallion of Merit, FDACS – DPI, May 2013.

PROFESSIONAL EXPERIENCE:

Client: Siemens Corporation (Contractor) May 2019 – Present

Position: Sr. Database/ETL/APEX Developer

Responsibilities:

Developing procedures, packages, triggers, tables, views and other logical and physical objects in database to process business logics.

Developing Applications using Oracle APEX, create Shared components like, Dynamic, Static LOVs, Lists, Themes, Templates, Navigation Menu, Breadcrumbs and Navigation bar lists using oracle APEX.

Implemented Oracle APEX APIs such as APEX_ITEM, APEX_MAIL, APEX_COLLECTION, APEX_APPLICATION, APEX_PLSQL_JOB and APEX_UTIL.

Extensively using advanced PL/SQL concepts for better coding standards.

Moving data between systems like oracle, snowflake, redshift using ETL processes, staging tables which helps business users to develop reports/dashboards using BI/Visualization tools like Tableau.

Developed Python scripts to automate data sampling process. Ensured the data integrity by checking for completeness, duplication, accuracy, and consistency

Experienced in oracle apex administration like, Maintaining, Creating users and groups.

Experienced in AWS (amazon web services) including EC2, VPC, S3, EBS, ELB, Cloud-Front, IAM, RDS, Cloud Watch etc.

Developed API (rest, web) using Python for data pull from different 3rd parties.

Implementing APEX Office Printing (AOP) and developed different formats of output reports.

Modifying Themes and Template design as per the requirements.

Experienced in APEX App deployment from one environment to other and responsible for backup for disaster recovery.

Involved in APEX upgrade from lower versions to higher.

Environment: Oracle Exadata, Snowflake 4.1.1, Oracle ODI 12.2.1, Oracle Apex 19.2, Tableau, Python, UNIX, and Windows.

Employer: Riceland Foods Inc, Little Rock, AR Apr 2018 – May 2019

Position: Sr. Database/APEX Developer/ETL Engineer

Responsibilities:

Interacting with users/customers to understand their requirements on functionality of the applications.

Developed and supported existing Applications using Oracle APEX.

Created Shared components like, Dynamic, Static LOVs, Lists, Themes, Templates, Navigation Menu, Breadcrumbs and Navigation bar lists using oracle APEX.

Proficient in using APEX_COLLECTION, APEX_WEB_SERVICE, APEX_ITEM, APEX_UTIL, APEX_VIEWS, APEX_MAIL.

Experienced in oracle apex administration like, Maintaining, Creating users and groups.

Analyzed data flow requirements and developed a scale able architecture for staging, processing and loading data.

Extensively used the advanced PL/SQL concepts like Bulk collect, Records.

Created mappings (Control Append, Incremental load, CDC – Change data capture), sessions and workflows as per requirement of business to implement the logic.

Utilized knowledge modules like LKM, IKM, CKM etc. and developed custom knowledge modules when required.

Created Tableau and Oracle Data Visualization Dashboards with interactive views, forecast, trend lines, reference line and drill downs along with user level security and published them to cloud.

Experienced in using Oracle Cloud to start, stop and restart oracle database, analytic cloud stack.

Extensively used ODI (ELT tool) to move data between on-premise database to oracle cloud autonomous data warehouse (ADW).

Environment: Oracle Cloud, Oracle Autonomous data warehouse (ADW), Oracle 18c, 12c, Toad 12, Oracle ODI 12.2.1, SAP Crystal reports, Oracle Hyperion, Oracle Apex 5.1.4, Oracle Data Visualization 12.2.4.3, Tableau 2018.1.1, UNIX, and Windows.

Client: Delta Dental Insurance (Health), Roanoke, VA Dec 2017 – Apr 2018

Employer: Infosys Solutions Inc.

Position: Sr. Oracle Developer/Production Support

Responsibilities:

Worked as Production Support specialist on DCS2000 Application and served as first line of support being on call rotation.

Worked with Oracle External Tables to load data from external entities through flat files into database and also used external tables in procedures and packages for automating the load process.

Wrote complex PL/SQL subprograms, packages, procedures, functions, and DB triggers to implement the backend business logic and automated system administration for .Net Application.

Leveraged 12c features like Index Storage, JSON in SQL, Real Time Materialized views, Invisible column and Identity column etc.

Participated in Agile (Kan-Ban) standup meetings and coordinated with off-shore team.

Worked closely with Dev-Ops team to move technical changes to test/prod.

Extensively used the advanced PL/SQL concepts like Bulk collect, Records.

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE

Used Advanced queuing (AQ) techniques to automate different activities across multiple databases.

Used UNIX shell scripts to automate and systemize the load process at nightly cycles.

Environment: Oracle 12C, PL/SQL, Toad 12, Crystal Reports, Atlassian Jira, Tortoise SVN, GitHub, .Net, UNIX, and Windows.

Client: Kennesaw State University, Atlanta, GA Jul 2017 – Dec 2017

Employer: Infosys Solutions Inc.

Position: Sr. Oracle Applications Developer

Responsibilities:

Understanding the customer requirements, analysis, design, development, and implementation into the system.

Ensure conformance to code standards and documentation requirements.

Extensively used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL.

Work closely with architects to align the ETL design to the business case and the overall solution.

Develop reports, dynamic pages, menu, forms using oracle portal.

Analyzed data flow requirements and developed a scalable architecture for staging, processing and loading data.

Develop/Create ETL frameworks and methodologies.

Designed Type1, Type2 and Type3 Slowly Changing Dimension strategies for some dimensions of the Data Marts.

Create the mappings, sessions and workflows as per requirement of business to implement the logic.

Developed Informatica mappings to transform the data using different transformations like Source Qualifier, Normalizer, Sorter, Aggregator, Stored Procedure, Sequence Generator, Joiner, Filter, Expression, Lookup, and Update Strategy.

Migrate applications to use the latest version of Universal Theme and keep current with the latest features, enhancements and bug fixes.

Experience developing data validation and data reconciliation SQL queries to confirm appropriate transformation of data and identify issues in source data for data cleanup

Environment: Oracle 12C,11g, PL/SQL, Toad 12, Informatica 7.1.3, Oracle reports 10g, External Tables, Oracle Portal, Ellucian Banner, UC4 Scheduler, UNIX, and Windows.

Client: FDACS – DPI, Gainesville, FL Jan 2012 – Jul 2017

Employer: Infosys Solutions Inc. & Pelican IT LLC

Position: Sr. Oracle Applications Developer

Responsibilities:

Involved in complete SDLC (system development life cycle) including system analysis, high level design, detailed design, coding, and testing.

Understanding the customer requirements, analysis, design, development, and implementation into the system.

Ensure conformance to code standards and documentation requirements.

Worked with Data migration team, provided the mapping between the source and target systems.

created web services using ASP.Net with C#

Developed web pages using ASP.NET, HTML and used JavaScript for styling the web pages

Extensively used controls such as Data Grid and Data List to populate the records for presentation layer. Extensively used Multi-Threading for fetching data from web services using C#.

Used ADO.NET and data objects such as Data Adapter, Data Reader, Dataset, data table for consistent access to SQL data sources.

Wrote complex PL/SQL subprograms, packages, procedures, functions, and DB triggers to implement the business logic and automated system administration using Perl.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views.

Developed Unix Shell Scripts and python jobs to automate backend jobs, loading data into the Database.

Performed systems analysis and impact analysis on downstream processes.

Extensively used the advanced PL/SQL concepts like Bulk collect, Records.

Written Control Files for Loading ASCII/Flat files onto the Oracle database using SQL*Loader.

Developed interactive Reports, data entry forms, hypertext-linked reports using Oracle APEX.

Utilized APEX utilities like debug, advisor to check for errors in sessions, long running pages, maintain code standards.

Extensively coded using mod_plsql (HTP, HTF functions) to develop oracle database applications.

Developed and monitored daily oracle jobs using dbms_scheduler, DBMS_JOBS.

Tuning the performance of SQL statements using HINTS, TKPROF utility & Explain Plan.

Created security module inside the database to control users, roles and permissions.

Environment: SQL Server 2005, Oracle 11g/10g, PL/SQL, SQL Navigator 6.6, .Net Framework 2.0, ASP.Net, C#, Oracle reports 10g, Oracle APEX 5.0, MS Access, SQL*PLUS, SQL*Loader, SQL Developer, ArcGIS, UNIX, and Windows.

Dollar General, Nashville, TN Aug 2011 – Dec 2011

Employer: Pelican IT LLC

Position: Oracle Developer

Responsibilities:

Creation of database objects like Tables, Indexes, Views, Stored Procedures, Functions, Packages, Triggers, and Synonyms.

Used Dynamic SQL programming technique to build and process SQL statements.

Used TOAD, PL/SQL developer tools for faster application development.

Extensively used UTL_FILE to read and write files that are located on the server.

Performed exception handling.

Developed the Shell scripts, Cron jobs for monitoring, troubleshooting and administration of the databases.

Apart from developing, other day to day responsibilities involved gathering information from the databases, turning them into files, and sending them as SFTPs to customers.

Documenting procedures, packages and other business logics for future reference and drafting up Unit test plans for QA team.

Used the SQL Loader for extracting the data from Flat Files into Oracle.

Environment: Oracle 11g/10g, PL/SQL, TOAD v10.6, SQL*Loader, Cloud SAAS environment, OpCon Scheduler, UNIX-AIX, and Windows.

Contact this candidate