Sql Developer
Resume:
Sivakumar Pichaikkannu
404-***-****, acqbmq@r.postjobfree.com, Atlanta, GA
Summary:
Detail oriented highly motivated Sql server database developer with around 8 years of experience in database design, application development, data analysis using SQL and PL/SQL programming. An effective communicator who can easily interface with end-users, technical teams, and professionals at all levels with hands-on experience.
Strong diversified experience in analysis, design, development, testing and implementation as PL/SQL Developer.
Extensive experience in utilizing PL/SQL procedures, functions, packages, triggers, and cursors alongside being involved in data extraction, transformation and loading operations on SQL using SQL Loader
Strong working knowledge in database objects like creating tables, views, indexes, sequences, primary key, foreign key constraints.
Experience in restructuring tables, denormalize tables and building Materialized views.
Used SQL Loader and wrote control file scripts to load data from flat files to SQL tables.
Good knowledge in other Relational and Normalized databases such as MS SQL Server, SQL.
Adept Knowledge in writing UNIX shell scripts, scheduling cron jobs, DBMS_JOB and good understanding of ANSI standard C.
Good experience in Data Modeling, Relational Database concepts and Entity relation diagrams (ERD).
Experience with software development life cycle (SDLC) process performing detailed analysis, collecting requirements, documents requirements, coding and unit testing, integration and system testing.
Practical understanding of the Data modeling(Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
Proven previous experience providing 24/7 production support and involved in implementation of coding standards and database change requests.
Technical Skills:
Database : SQL Server 2012, MS Access (2000, XP)
Scripting : UNIX Shell Scripting
Languages : Java, Java Scripts, SQL * Plus, SQL Scripts, PL/SQL, HTML, JSP
Data migration : DTS, SSIS, BCP, SQL Loader, Import/Export Wizard
Operating Systems : Windows 7, Windows Vista, XP, UNIX
Education & Certifications:
Master of Computer Application (M.C.A) from Jayaram College of Engineering and Technology, Trichy. (Anna University).
Bachelor of Science (B.Sc.) from A.V.V.M Sri Pushpam College, Poondi, (Autonomous), Thanjavur. (Bharathidasan University).
Experience Summary
Apr 2011 – till date iSIGMA Inc USA
Data Base Administrator
Aug 2005 – Apr 2011 iSIGMA IT Solutions Pvt. Ltd Chennai, India
Programmer Analysts
Professional Experience:
Client : TriEagle Energy, The Woodlands, PA Feb2014 – Till Date
Role : PL/SQL Developer/Data Analyst
Project : United Health Care
Project: The Sales desktop team provides personalized data to fit the needs of every customer and small business. Additional customer analytics, marketing techniques, and process are done for consistent customer performance throughout the customer life cycle. The team involved in developing and maintaining segmentation systems and targeting models with little consideration as to who should be targeted when and little analysis on who is targeted, how often and how that affects long term results.
Responsibilities:
Coordinated and presented deliverable to business teams and development teams where primary responsibilities included system analysis, coding, testing, debugging and deploying.
Developed Stored Procedures, packages, Functions using PL/SQL to implement day to day modified business rules into the current system.
Involved in modifying various existing packages, procedures, functions and triggers according to the new business need.
Handled Errors and Transaction Processing in the Procedures.
Written Complex SQL statements using joins, sub queries, inline views.
Supported the Sales Desktop team in helping them identify the front end related fields that will affect due to the change in backend.
Helped the QA team with queries, data for their testing.
Proactively involved in writing efficient queries for better performance.
Tuning the existent queries for better performance.
Used a lot of ref cursors and created global temporary tables.
Created tables, views, synonyms, indexes, sequences as well as custom packages tailored to business requirements.
Created Indexes to improved performance.
Co-ordinated with other teams with any production related issues.
Depending on the need changed/modified/cancelled the Autosys jobs.
Environment: PL/SQL Developer, UNIX AIX 5.2, Windows 2000XP/NT
Client : Amigo Energy, Houston, TX Apr2013 – Jan2014
Role : PL/SQL Developer/Data Analyst
Project : Collection and Financing Management System
Project: IPO-CFMS is to manage the collection of funds or financing for IPOs against securities. The System has the functionality to support the Collecting bank, Financing bank, Refunding bank and Lead Banker. Verification, Evaluation and Approval are Credit Module to sanction finance for IPOs. The extensive Document management module allows maintaining the documents, tracking and reporting the Non-received and expiry documents for further action. The generic upload/download framework and design allows the USER to define the file format dynamically. There is an online MQ interface to base banking system to get the customer information, balance details and to block the balance. Also there is batch interface to core banking system to post the financial entries. There are extensive search modules to drill down the information in the required format
Responsibilities:
Primary responsibilities included system analysis, coding, testing, debugging, deploying and documentation.
Ensure application design and code meets user interface standards (Forms and reports).
Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
Developed database objects including Tables, Clusters, Cursors, Indexes, Views, Sequences, Packages, Synonyms, Triggers and Procedures to troubleshoot any database problems.
Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
Developed Master Detail, Detail reports using tabular and Group above reports.
Developed SQL scripts to extract data the various lookup and delta tables and Spool to a flat file.
Instrumental in developing PL/SQL procedures and rolling-out new improvements required for data load.
Wrote stored procedures, Functions, Packages etc. besides working on creation of Sequences for automatic generation of Billing Statements.
Extensively worked in writing SQL Queries (Sub queries and Join conditions, correlated sub Queries and inline views)
Written many database triggers for automatic updating the tables.
Created indexes on tables and Optimizing Stored procedure queries.
Worked on SQL Tuning and Query Optimization Techniques for complex SQL Statements.
Assisted DBA to implement backup and recovery techniques and Query level Optimization
Development and Testing of advanced SQL and PL/SQL based code in support of Reports.
Worked extensively on Shell scripting.
Worked in the direct interaction with the end users and implemented reviews of the application.
24/7 production support, and reporting to manager on weekly basis.
Environment: Windows NT/2000/XP, PL/SQL, PL/SQL Developer 7.1.5, SQL*Loader, UNIX
Client : Champion Energy Services, Houston, TX Jun 2012 – Mar 2013
Role : PL/SQL Developer
Project : Energy Aggregator
Project: It is a web-based application to handle the operations of Energy Aggregators. It helps to manage customers and their premises locations. The readings are taken from premises historical consumption (12 months) of the customers. Portal to request quote on behalf of customer to Retails Energy Providers. To maintain the customers contracts managements.
Responsibilities:
Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures.
Generated server side PL/SQL scripts for data manipulation and validation and created various materialized views for remote instances.
Produced SQL reports, data extraction and data loading scripts for various schemas.
Created and modified SQL*Plus, PLSQL and SQL*Loader scripts for data conversions.
Developed a new package with tuned queries to improve the performance and reduce the time taken for the refresh.
Modified UNIX Shell scripts to Import and Export data and user schema.
Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports.
Wrote PL/SQL procedures to generate DDL scripts that created database objects dynamically based on user inputs.
Used SQL Loader for migrating flat file data into target
Written shell scripts and executed them as cron jobs on UNIX Involved in comprehensive testing of the system to check it satisfies the Functional Specifications.
Wrote technical specification requirements and provided production Support.
Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
Environment: WIN 2008 Server, UNIX, PL/SQL, SQL, MS VISIO Professional.
Client : Clearview Energy, Dallas, TX Jul 2010 - May 2012
Role : PL/SQL Developer
Project : Deposit Enhancement
Project: It is a web-based application to handle the operation of deposit of the customers. It holds the information regarding of the deposits charge, collected and refunded customers. At the system level, it providers the total deposit charged, collected and refunded. It providers report to show the customers eligible to receive deposit after 12 months of the service
Responsibilities:
Worked with Business Systems Analysts and Database Administrators to understand and implement functional and non-functional requirements into the project.
Developed new hire report, Seasonal Hire Report, wages and tax info reports and modified the existing SQL reports.
Extensively worked on Database objects (Tables, Views, and Indexes etc) and stored procedures (PLSQL).
Created Stored Procedures for Batch Processing, and also involved in moving large data using Bulk Insert/for all Methods.
Performed tuning of the system by eliminating redundant joins, creating indexes, removing redundant code.
Data warehousing ETL (Extraction Transformation Loading) is done between two databases.
Prepared test case for the GUI screens and tested the application.
Involved in designing and development of several web pages using visual studio, HTML, CSS, XSLT / XML and JavaScript.
Environment: Windows NT, UNIX Shell scripts, SQL server 2012, HTML, CSS,XSLT/XML
Client : Tara Energy, Houston, TX Mar 2008 - May 2010
Role : Programmer Analyst
Project : Customer Information System
Project: Customer Information (CIS) and Billing solution is a web based regulated and deregulated energy markets such as Retail Electric Providers, TDSPs, Energy Aggregators, Co-ops and Municipals over a decade. CIS is the integrated billing process of the Power distribution to the customer from Retail Electric Provider. Customer can access the bill and also they can pay the bill directly by using this CIS.
Responsibilities:
Involved in the Analysis, Design, Coding and Testing of the application.
Created and Modified PL/SQL Triggers, Procedures, Functions and packages.
Developed SQL scripts to create database objects like Tables, Views and Sequences.
Used SQL*Loader to load bulk data from various flat files and legacy systems.
Developed SQL and PL/ SQL scripts for transfer of data between databases.
Used For all and Bulk collect to fetch large volumes of data from table.
Developed Complex SQL Coding, Triggers for building Reports using Form, form letter and mailing label report styles.
Developed Complex Triggers in reports before/after for validation of user input.
Performed Unit Testing and supported Integration Testing and End User Testing.
Extensively worked on production issues with effective defect management.
Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency.
Implemented Application Infrastructure policies, Procedures and Standards, and ensured their continual compliance.
Environment: Visual Basic, SQL, PL/SQL, Windows NT, WIN 2003 and UNIX
Client : Ameri Power, Sugar Land, TX Feb 2007 to Feb 2008
Role : Programmer Analysts
Project : Sentry Insurance
Viking Insurance (http://www.vikinginsurance.com) has served the specialty auto insurance market for over three decades for the countries like UK and USA and previously having the partner of Royal Sun Alliance, now it gets turn to Sentry Insurance, one of the leading insurance providers in USA. As a leading provider of mandatory coverage for individuals who are less able to afford auto insurance. Viking Insurance primarily focuses on overcoming the difficulties of acquiring and maintaining continuous coverage. Viking Insurance offers products; services and training are marketed solely through independent agents in all 27 of the states in which it conducts business. Viking Insurance products offer low down payments, flexible payment plans, and extremely quick turnaround time through a proprietary agent interface web site: AutoLink®. Drivers can purchase minimum limit liability coverage’s to comply with state regulations or expanded protection, including comprehensive and collision, as mandated by lien holders.
Responsibilities:
Design & Development.
Creating and Modifying Decision handler for workflow process.
Implementing Database logic using Helper classes.
Design Documents Preparation.
Involved in client meeting to gather the requirements.
Involved in Unit integration, bug fixing, Code reviews.
Environment: : HTML, CSS, AJAX, JDK1.5, JSP, JQuery, Java,J2EE, Red Hat Linux
Contact this candidate