Post Job Free

Resume

Sign in

Developer Data

Location:
St. Louis, MO
Posted:
October 28, 2020

Contact this candidate

Resume:

INDU K

Mobile: 785-***-****

E-Mail: adhdmd@r.postjobfree.com

Summary

Solid technical experience of over 9 years in full software life cycle using RDBMS systems for Financial, Manufacturing & Healthcare industries including Database design, development, Modelling, testing and implementation of various software projects, applications in various environments.

Experience in Data Integration, Data Warehousing, Business Intelligence and expertise in business implementation like OLAP and OLTP.

Experienced in interacting with Business Users to gather and analyze business requirements and translating requirements to functional and technical design specifications.

Experience in Database design using Normalization.

Coherent with Normalization/Denormalization techniques & normalizations up to 3NF.

Good Knowledge on Anonymous Blocks, Autonomous Transactions, Procedures, Functions, Record Types, Collections, Analytical Functions, Dynamic SQL/PLSQL, Pipelining, Hierarchy Queries, Cursors, Exception Handling and Advanced Queuing.

Experience in writing SQL Queries, Sub Queries, Views, Materialized Views, Packages, Triggers, Ref Cursors, Dynamic SQL, Exceptions.

Experience in developing Joins, Indexes and sequences.

Expertise in query optimization, performance and tuning using Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, global temporary tables and table partitioning.

Experience in writing Technical Design Documents and Developing Unit Test Documents.

Well versed in system analysis, Relational and Dimensional Modeling, Database design and

Experienced in developing Conceptual, Logical and Physical models using Erwin

Well versed in Forward and Reverse Engineering principles.

Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions.

Expertise in Data Warehousing methodologies.

Knowledge on .Net technologies and supported front end developers on .net applications.

Articulate with Data Quality, Profiling, Conversion, System Testing, implementing RDBMS features and ETL and data integration.

Knowledge on Staging area to Data Warehouse, Data Warehouse to data marts for specific reporting requirements.

A Self-starter with a positive attitude, willingness to learn new concepts and accept challenges.

Strong written and verbal skills along with good communication skills.

Experienced in using ETL tools Informatica and SSIS using multiples sources like Excel, Flat file & RDBMS systems

Data analysis and data migration by transferring them using SSIS packages.

Good experience with latest JavaScript frameworks .

Good understanding of front-end technologies, such as HTML5, and CSS3.

Good experience in Building and Deploying code in development and testing environments .

Good Experience in preparation of unit and Integration test scripts for testing to perform testing in all the testing environments and creating required documentation.

Involved in production deployment and in post-production support of the Project.

Technical Exposure:

Databases : MS Access, Oracle 12c/11g/10g/9i/8i,MS SQL Server 2012/2015,DB2

Languages : PL /SQL, SQL, C, Java,JavaScript, JSP, HTML, XML, UNIX Shell Scripting,VB.Net .

Operating Systems : Windows, Sun Solaris 9.0/8.0, Linux 8.0

RDBMS Tools : SQL developer, TOAD, SQL * Loader, SQL*Plus, Oracle Forms and Reports 10g/9i/6i, SQL Server Management Studio.

Applications : MS Office tools, Putty, GitHub, Git Shell, Jenkins, UDeploy, SVN, CVS, PAC 2000, Anthill, Workbench, Bugzilla,MS Visio, MS Visual Studio 2015,MS Visual Source Safe,Splunk

Reporting tools : Crystal reports, SSRS, Oracle Reports

ETL Tools : Informatica Powercenter,SSIS

DataModelling Tools : Erwin 4.0

Methodologies : Agile, waterfall

Scripting& Scheduling : UNIX, Linux, Shell scripting, Crontab, Autosys

Project Summary:

Wells Fargo Advisors St. Louis, Mo

Sr.Oracle PL/SQL Developer Sep, 2018 –Till date.

Wells Fargo & Company is an American international banking and financial services. It is the world's second largest bank by market capitalization and the third largest bank in the U.S. by assets. Wells Fargo is a provider of banking, mortgage, investing, credit card, insurance, and consumer and commercial financial services.

Responsibilities:

Acts as a lead in providing application design guidance and consultation.

Analyzes highly complex business requirements, designs and writes technical specifications.

Acts as an expert technical resource for modeling, simulation and analysis efforts.

Verifies program logic by overseeing the preparation of test data, test Scripts for testing and debugging of programs.

Oversees overall systems testing and the migration of platforms and applications to production.

Involved in production deployment and in post-production support of the applications.

Doing Code reviews for the junior developers.

Creating,Enhancing or Decommissioning Packages, Stored Procedures based on the requirements.

Writing high performance queries/programs using Collections, Bulk Binds, Objects,Records Nested tables, REF Cursors, pipeline functions, Pragma Exceptions, Autonomous Transactions etc.

Tuning PL/SQL Packages and PL/SQL Stored Procedures/Functions to improve the performance by creating function-based Index, Optimizer Hints, table partitions, Global Temporary tables .

Tuning SQL Queries by analysing with Explain_plan,AUTO Trace & AWR reports with the use of Materialized Views,Indexes,Partitions,Gathering statistics for high performance.

Working with the DBA and Data Modelers for the ongoing issues Productions issues .

Building and Deploying code in development and testing environments using Jenkins and IBM UrbanDeploy .

Analyzing, Debugging and Fixing code for errors to help or support team.

Rewritten the DB2 stored procedures to Oracle Packages/Stored procedures for data Migration applications.

Writing SQL Queries in SQL Server 2012 RDBMS for some of the projects.

Working on ETL Transformations & Workflows using Informatic Power Center.

Involving in Team meetings and discussions about the status of the projects and on going production issues .

Working on PAC2000 and Tortoise SVN for Change Management and Source Control Products.

Debugging ASP.Net code along with the service developers for production issues using Visual Studio 2015.

Environment: Oracle Database 12c, SQL Developer, SQL*PLUS, Windows 2010, Jenkins, IBM Urban Deploy, MS Word, MS Excel, SQL Server 2012,PAC2000,TortoiseGit2.7.0 SVN,MS VISIO 2010,Visual Studio 2015,ASP.Net.,ETL(Informatica Powercenter 9.0),JIRA Issue tracker,Splunk .

Blue Cross Blue Shield Topeka, KS

Database Developer Sep, 2015 –Aug, 2018.

Blue Cross Blue Shield (BCBS) companies have provided healthcare coverage to members, allowing them to live free of worry, free of fear. In every ZIP code, Blue Cross Blue Shield offers a personalized approach to healthcare based on the needs of the communities where their members live and work. They work closely with hospitals and doctors in the communities they serve to provide quality, affordable healthcare.

Responsibilities:

Involved in analysis, Design, Development phases of the project.

Involved in walkthrough sessions with business users during Analysis and Designing phase. Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.

Created and maintained Tables, views, procedures, functions, packages, DB triggers, and Indexes.

Involved in implementing the data integrity validation checks through constraints and triggers.

Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors, pipeline functions etc.

Tuned PL/SQL Packages and PL/SQL Stored Procedures/Functions or T-SQL Procedures/Functions to improve the performance by creating function-based Index, Optimizer Hints, table partitions, Explain_plan and analyzing the tables.

Involved in creating DYNAMIC SQL that will update or insert data into the tables on the run.

Wrote UNIX shell scripts to automate load process and scheduling batch jobs.

Extensively worked on IBM’s Automation tool-Tivoli Workload Scheduler, Used to Run, Hold, delete a job from a job stream and also used to validate the Jobs.

Implemented Exception handling, Autonomous Transactions, Pragma Exception Init, Locks, used save points, commits & rollbacks to maintain Transactional consistency & database integrity.

Wrote complex in-line Views which summarized the business needs to the fullest.

Designed, implemented and tuned interfaces and batch jobs using PL/SQL and UNIX utilities.

Involved in formulating general methodologies, Naming conventions and Coding standards for various procedures and packages.

Wrote T-SQL stored procedures based on the requirements.

Expertise in creating Packages using SQL Server Integration Services (SSIS) and creating SSRS reports.

Proficient in Tuning T-SQL queries to improve the database performance and availability.

Developed User Defined Functions and created Views.

Debugging the Java code issues along with the front end developers .

Environment: Oracle database 11g, TOAD 9.5, SQL Developer, SQL*PLUS, MS SQL SERVER,T-SQL,MS SQL Server Integration/Reporting services (SSIS/SSRS),AIX Unix operating system, Windows 2008, Tivoli Workload Scheduler, WinSCP, Filezilla, Putty and MS Visio 2010,Java 1.7,

US Bank Richfield, MN.

Oracle PL/SQL Developer Aug,2012 -Jan,2013.

U.S. Bank is the fifth-largest bank in the country and its core businesses include Consumer & Business Banking, Corporate & Commercial Banking, Payment Services and Wealth Management & Financial & Investment Services.

Responsibilities:

Develop queries/stored procedures to analyze and correct issues in the Oracle OIM/OIA provisioning system.

Data analysis to determine discrepancies between the two systems and generation of SQL to correct issues as they are found as well as reporting trends in those discrepancies.

Cleanup of data initiative for the mainframe. This involves data ETL of both data from mainframe reports and OIM/OIA data.

Analysis and generation of mainframe commands to add users to missing mainframe groups as well as analysis of RACF permission sets and reporting of access that users may lose based on the cleanup process.

Develop other ad hoc queries based on need for OIA/OIM clean up.

Created and maintained Tables, procedures, and Indexes.

Tuned PL/SQL Stored Procedures/Functions to improve the performance by creating function-based Index, Optimizer Hints, Explain plan and analyzing the tables.

Involved in creating DYNAMIC SQL that will update or insert data into the tables on the run.

Exporting and importing the data into the database as and when user provided the data and do analysis.

Worked closely with the ETL Team to provide database information .

Environment: ETL, Oracle 11g, Windows XP/2003,SQL Developer, Informatica powercenter 9.0

ITC Limited-Paper Boards & Specialty Papers Division Hyderabad,India

Database Developer/Analyst/Application Developer Jun, 2006– Sep, 2010

ITC’s Paperboards and Specialty Papers Division is India’s largest,technologically advanced and most eco-friendly,paper and paperboards business .ITC's Paperboards and Specialty Papers Business is the leader in volume, product range, market reach and environmental performance, and is the clear market leader in the value-added paperboards segment. Providing internationally competitive quality and cost, the Business caters to a wide spectrum of packaging, graphic, communication, writing, printing and specialty paper requirements.

Responsibilities :

Designed, developed and enhanced custom Forms and Reports according to the functional specification.

Did code reviews of other developers and provided suggestions to improve performance

Wrote high performance queries/programs using Bulk Binds, REF Cursors etc.

Helped other developers in tuning queries or programs and trained them to write well-tuned code.

Provided expertise to development managers in design or preparing proof-of-concept testing.

Converted Forms & Reports from 6i to 10g.

Wrote complicated stored Procedures, Functions, Database Triggers and Packages, Shell Scripts for efficient data storage and manipulation.

Involved in handling Exceptions through PL/SQL Blocks.

Created various feeds/downloads, nightly batch jobs and other daily/monthly reports/downloads.

Developed SQL *Loader scripts to load data from flat file to Oracle 10g database tables.

Tuned batch jobs and other daily/monthly reports/downloads.

Involved in migrating the oracle forms and reports from 6i to 10g.

Developed and Enhanced around 200 Reports using 10g/6i to meet the business needs.

Developed critical Reports that helps the business users

Development of dynamic Reports by using Lexical parameter to run the Generic Reports.

Involved in performance fine-tuning of the queries/reports using PL/SQL and SQL Plus

Used Toad for creating and modifying procedures, functions and triggers.

Developed complex Oracle Forms providing extensive GUI features (multi-selects drag and drop, graphical charts, automated system alerts and notifications etc).

Documenting all Oracle Reports, Packages, Procedures and Functions development specifications.

Maintaining different version of software (version control) using CVS.

Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.

Preparing test plan for QA for testing before moving from Preproduction to Production environment.

Trouble shooting the day to day problems in the areas of Costing, Process Raw materials and Raw material accounting, Security system, Stores, Private vouchers, OptiVISION (OTIF).

Doing month end activities.

Providing data to corporate auditors and to the users as per their requirement.

Modifying forms, reports and stored procedures & packages, triggers, functions etc to meet the business requirements.

Developed a website internal to a department in ITC using HTML 5,CSS 3,Flash,Adobe Photoshop and Java Script tools.

Develop and execute unit, functional, integration testing of developed software components.

Good experience with latest JavaScript frameworks .

Good understanding of front-end technologies, such as HTML5, and CSS3.

Preparation of unit and Integration test scripts for testing to perform testing in all the testing environments and creating required documentation.

Involved in production deployment and in post-production support of the Project.

Environment: Oracle 6i&10g, Forms & Reports, Crystal reports, Oracle 8i,9i,10g,HTML,CSS,Flash,Adobe Photoshop, Java Script.

Education :

Bachelors of Technology in Computer Science Engineering from JNTU,Hyderabad,India- May,2006.



Contact this candidate