SUMMARY

• Having around 7+ years of experience as SQL/ PLSQL/BI with design and tuning performance optimization stored procedures and triggers with emphasis on Evaluation of existing system and Data collection, System Design, Implementation specifications, Implementation schedules, Database design, Development, testing and Documentation of business applications using Oracle and Microsoft technologies.
• Over 7+ years of IT experience in Development, System Analysis, Design and Testing of business applications using Oracle 11g/10g/9i.
• Design build and support batch processing for database updates.
• Configuration Management with Teradata and SQL server 2008/2012 and 2014.
• Extensive programming knowledge in SQL, PL/SQL, SQL*Plus, TOAD, SQL*Loader in Data warehousing.
• Data modeling, SSAS,SSIS batch processing and tabular and Creating general reports Data warehousing environment
• Develop, Design and Support interactive Tableau dashboards
• Translate business requirements into sustainable and efficient visualizations and reporting;
• Experience in development of Trigger, Procedures, Functions and Packages.
• Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, Oracle Object and Collection, Bulk Collect etc.
• Experience in Oracle Data Warehouse, ETL Process Basic level.
• Experience in development and maintenance of data warehouse initiatives and reporting needs for the business.
• Worked on Migration of packages from DTS using SQL Server Integration Service (SSRS).
• Generating reports using SQL Reporting Services (SSRS) for customized and ad - hoc Queries.
• Involved in Report writing according to business requirement using SSRS.
• Monitor and maintain system security, including monitoring database alert logs manage file system disk space, resizing table space and de-fragmenting the database as needed, system shut down and restart, unlocking database table locks, as well as monitor and create additional table space and file space
• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Experience in implementation and support of SQL Server Database Systems, Reporting Services (SSRS), and Integration Services (SSIS) and drill down reports, partitioned views and large data sets.
• Experience in performing back-up/recovery, running Database Consistency Checks using DBCC, implementing security, and configuring replication.
• Experience in creating Reports from Web Services and used MDX on Cubes to create reports in SSRS Perform unit testing at various levels of the ETL.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Dashboards, Performance Point Server version.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Experience in implementing all types of Replication Models like Snapshot, Merge and Transactional and in Database Backup, Recovery and Disaster Recovery procedure.

TECHNICAL SKILLS

Operating Systems: Windows 8.1/10/ LINUX, SUN Solaris, UNIX, Shell Scripting

Languages: SQL, PL/SQL, T-SQLC++, Apex, JavaScript, PHP, HTML,SQL Loader, python

Databases: Oracle11g/10g/9i/, MSSQLServer2005, 2008/2012, 2014 PostgreSQL, Toad, MySQL, Cassandra. SQL loader, SQL toad, Oracle Toad, SQL navigator, Teradata

Reporting Tool: Crystal Report, Business Objects, Oracle Report, SSAS, SSIS, SSRS Oracle BI, Forms and reports, Shell scripting.Tableau.Batch processing.

Modeling: UML, ERWIN, Agile

ETL tool: Informatics, Oracle Warehouse Builder (OWB), Putty, Winscp.HIPPA.

Front End: Oracle Forms, VB 6, HTML, APEX, SSIS, SSRS, AWR.Infoview, BOBJXI

Other Tool: TOAD, SQL Navigator, PVCS, AWS, Eclipse, Apache tomcat, JIRA Winscp, Eagle pace

Other Applications: MS Office, HTML, VB script

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

PLSQL Developer

Responsibilities:

• Prepared program Specification for the development of PL/SQL procedures and functions.
• Batch processing implementation in SSIS packages and loops for transactions process for upgradation and monitoring setup.
• Developed the scenarios and provided production support through Eagle pace interface.
• Had cluster management and repository issues downgraded and upgraded according to the issues.
• Expert in Data Conversion, Add-hoc reporting, Data Analysis and validation in Teradata.
• Experience in design and development of end user Reports using Crystal Report, Business Objects, Report Builder.
• Creating Dashboards with Tableau.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Perform unit testing at various levels of the ETL.
• Proficient in setting up Standby Database using Shell Script and Rman tool, Activating Standby Database & Re-building Standby.
• Enable and Configure Database Auditing for Production databases.
• Excellent analytical, problem-solving and learning skills as well as keen interest in the emerging technologies.
• Created Custom Staging Tables to handle import data Tableau reports.
• Created custom triggers, stored procedures, packages and functions to populate different database.
• Developed SQL* loader scripts to load data in the custom tables.
• Run Batch files for loading database tables from flat files using SQL*loader.
• Created UNIX Shell Scripts for automating the execution process.
• Developed SQL and PL /SQL code for updating payment terms.
• Created indexes on tables and Optimizing Stored Procedure queries.
• Design, Development and testing of Reports.
• Modified existing codes and developed PL/SQL packages to perform Certain Specialized functions / enhancement on oracle application.
• Created Indexes and partitioned the tables to improve the performance of the query.
• Involved in preparing documentation and user support documents.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.

Environment: Oracle 11g (RAC)/10g, Solaris 10, SQL loader, Toad Enterprise Manager Console, SQL PLUS, VNC server, Putty.AWS,Python.

Confidential, Glen Allen, VA

PLSQL developer

Responsibilities:

• Performed review of the business process, involved in Requirements Analysis, System design documents, Flows, Test Plan preparations and Development of Business Process and Work Flow charts.
• Developed database objects like Tables, Views, Indexes, Synonyms and Sequences.
• Involved in Creation of tables, Join conditions, correlated sub queries, nested queries, views, sequences, synonyms for the business application development.
• Involved in data cleansing to remove unnecessary columns eliminate redundant and inconsistent data by using SSIS transformations.
• Worked with various Dataflow tasks like Merge Join, Merge, Aggregate, OLE DB Command and Conditional Split while designing SSIS Packages.
• Involved in maintaining Data consistency and Data Integrity with various constraints like Unique, Check, Primary Key and Default.
• Worked with design, development, implementation and support of ETL process using SSIS Packages in SQL Server 2008.
• Involved in Incremental Data Load from various sources into SQL Server Database Engine with ETL Operations.
• Worked with different Control flow tasks in creating SSIS packages such as Data Flow Task, For Loop and For Each Loop containers with Execute SQL and Script Tasks.
• Created Materialized views to calculate aggregated data, such as Sum of monthly revenue.
• Developed complex ORACLE stored procedures and packages to calculate borrower's debt ratio, property taxes, mortgage insurance, regular/ irregular payments, etc.
• Developed PL/SQL code for updating payment terms.
• Supported DBA team for the data migration from oracle 9i to 10g.
• Creation of Forms, Pop-up Menus and maintaining Master Detail relationship.
• Used various LOVS (List of Values) and record groups at various points in runtime.
• Involved in the design and development of User Interfaces using Forms 6i, Reports 6i and coding modules in PL/SQL.
• Development of PL/SQL program units and sharing them among multiple applications for processing business logic in the database.
• Testing all forms, PL/SQL code for logic correction.

Environment: Oracle 9i/10g (SQL, PL/SQL), SQL *loader, Toad 9.0.1, Forms/Reports 6i, UNIX

Confidential, Hartford, CT

SQL developer

Responsibilities:

• Analyzed Internal & External Source systems and Business Requirements to develop Health
• Insurance Claims Data warehouse LOGICAL AND PHYSICAL MODEL (Facts and Dimensions
• Developed back end interfaces using Tables, PL/SQL packages, stored procedures, functions, Collections, Object types specifically for financial reporting
• Involved in the design and development of User Interfaces using Forms 6i, Reports 6i and coding modules in PL/SQL.
• Development of PL/SQL program units and sharing them among multiple applications for processing business logic in the database
• Problems by using Hints, Indexes, Partitioning and analyzing the Stats updates.
• Extensively used the Triggers, Indexes, Views and Materialized Views for the Application design.
• Developed Informatica Mappings using various Transformations and PL/SQL Packages to extract, Transformation and loading of data.
• Performed subsequent alterations using SQL, PL/SQL to make any changes on adhoc Requirements.
• Implemented Business Rules using PL/SQL Procedure/Packages with complex water fall Calculations
• Normalized and De-normalized entities for the Data Warehouse.
• Involved in Data Extraction, Transformation and Loading (ETL process) from source to target.

Environment: Oracle PL/SQL, SQL, 10g/11g, Oracle Forms, SQL Loader, ERWIN, ETL, Informatics, Visio, Rational Rose Clear case and Clear Quest.

Confidential

Database Analyst

Responsibilities:

• Create and maintain tables, views, procedures, functions, and packages.
• Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Forms Developer 9i
• Developed screen layouts, report layouts using Forms and Reports and participated in implementation.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Successfully manipulated Stored Procedures, Functions and Packages using TOAD.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
• Designed and developed various reports using Oracle Reports 9i.
• Created and used Table Partitions to further improve the performance while using tables containing large amount of data.
• Used Designer 2000 for Data Modeling, Design Specifications and to analyze Dependencies.
• Assisted in debugging Visual Basic.NET components
• Developed PL/SQL packages using Oracle Standard/ Custom Exceptions.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Used external tables to manipulate data obtained daily before loading them into the tables.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Designed reports that had complex SQL, PL/SQL code and stored the procedures. The filter conditions for the Queries were dynamic in nature and included lexical parameters.

Environment: Oracle 10g/9i, Sun Solaris 9, AIX, Redhat Linux, OEM, SQL, SQL plus, UNIX, Erwin