PROFESSIONAL SUMMARY:

• Senior PL/SQL Developer, SAS programmer with 9 years of functional experience in designing along with maintaining database applications, including implementation and support to designed systems for applications.
• I am associated with various phases of SDLC including Requirements Analysis, Design and Construction, Testing, Implementation & Post implementation support.
• Have worked primarily in the domain of Insurance, Banking and financial services and also have hands on experience in the PL/SQL, UNIX, Shell Scripting, SAS Base, Tableau, Pro*C, ETL Datastage and Java/J2EE technologies.
• 9+ years of extensive IT experience in various technical fields like Software Analysis, Business Data Analysis, Design, Development, Testing, Implementation and Support in various projects using SQL, PL/SQL, UNIX, Shell scripting, ETL Datastage and SAS technologies.
• Extensive experience in Database Design using SQL & PL/SQL - developing Stored Procedures, Functions, Triggers, Sequences, Views, Cursors, Packages and Exceptions.
• Experience in using Oracle packages like UTL FILE, DBMS JOBS, performance tuning using explain plan, SQL Trace, partitioning techniques etc.
• Analytical experience working on SAS Programming applications like SAS/Base, SAS/Macros, SAS/STAT in Windows and Linux Environment.
• SAS programming experience in accessing external DB(ORACLE, NETEZZA, SQLSVR, DB2) tables using LIBNAME and PROC SQL Passthru logic.
• SDLC: In depth strong working knowledge of the Software Development Life Cycle (SDLC) phases such as Planning, Analysis/Design, Development, and Testing for the software/system development process.
• Good understanding and knowledge with Agile and waterfall environments.
• Application Data warehousing experience in various domains:
• Investments
• Insurance
• Financial and Banking sectors.
• Designing the SQL queries with Joins, Sub queries and used Analytical Functions in Queries, Using Oracle utilities like SQL*Loader, Export/Import for file reading.
• Designing the Procedures for Data Validations and Business Validations and Integrating the Modules.
• Experience in Peer & Lead level business, system requirements and design reviews.
• Experience in leading a team as lead actively involved in requirements gathering, business analysis, impact analysis, estimation, review activities, testing, assigning and tracking work, status reporting and providing quick resolution of issues.
• Good communication skills and excellent customer relations in implementing technology based solutions for business problems.
• Effective in cross-functional and global environments to manage multiple tasks and assignments concurrently with effective communication skills.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, UNIX, Shell scripting, SAS, C/C++, HTML, XML, Core Java, Pro*C.

Environment:: Windows NT 2000/XP/2007, LINUX, Unix

Databases: Oracle, DB2 UDB, Netezza, SQL Server 2008, Microsoft Access

Analytics: SAS (Enterprise Guide)

Data Visualization: Tableau, Crystal Reports 2008

Special Software/Tools: SQL Developer, SQL*Plus, Putty, SAS EG7.1, GIT, Mattermost, NORCOM, Beyond Compare, RTC, Code Collaborator, Slick/JEdit, BMC Control -M Automation Enterprise Manager, Borland STRATEAM, Winscp, IBM InfoSphere/WebSphere DataStage, Microsoft Office (PowerPoint, Word, Outlook and Visio).

WORK EXPERIENCE:

Confidential, San Antonio, TX

Consultant

Responsibilities:

• Optimize the code and tune the business logic for each alert-queue to generate efficient alerts using Oracle PL/SQL, SAS, Unix, Shell scripting.
• Established a batch infrastructure using PL/SQL triggers, packages, cursors, views, procedures, functions, SAS Macros and Base SAS programs.
• Identifying the pain areas and reduce the steps/timings of the job execution and performance tuning.
• Implementing new rules and Automating various alert queues based on business cases
• Implemented the process to load the alerts using UNIX, PL/SQL and ETL.
• Playing a key role as onsite lead working with DBAs and Data Architects to design the infrastructure for Data Quality and Adhoc reports processing.
• Providing descriptive analytical reports and statistics to Fraud investigation management team using SAS/BASE, SAS/Macros, R and Tableau.
• Prioritizing the alerts to get them worked at the earliest before fraud happens
• Provided optimal solutions to fetch data from databases like Oracle, UDB DB2, SQL Server, Netezza using SQL
• Created and maintained the data dictionaries, Maintained some parameters to provide faster query performance using SQL.
• Implemented Fraud regulations during the initial transformation of Data, Created flagged data with the regulations before loading to various business entities.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms.
• Code review and code migration to production using GIT, mattermost, post production support and fixing the defects.
• Creating and monitoring job sequences and schedules for automation using BMC Control -M Automation Enterprise Manager.

Confidential, Wayne, PA

Consultant

Responsibilities:

• Key role in Database Design for new Schema to store the data received from Vendors.
• Data mapping for AS-IS to TO-BE data elements.
• Implementing Purge process for new Schema tables using PL/SQL.
• Coordinating with each work stream to get the DB requirements and designing and requesting for tables creation. Publishing DB changes to entire team to make everyone is aware of the changes to avoid issues.
• Wrote stored procedures and triggers extensively and working very closely with developers, business analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems.
• Attending the RSM meeting to understand the business requirements and documenting detail design documents.
• Created ftp connections and file transfer/receive setup through B2B.
• Creating mappings/workflows to extract data from different Servers and other sources and load into various Business Entities.
• Documents/code review to get the approval from Clients and M&P.
• Implementing data load processes by developing ETL jobs using IBM InfoSphere/WebSphere DataStage, SQL*Loader, PL/SQL, UNIX, Shell scripting.
• Code review and code migration using RTC. Scheduling the jobs using Control-M Desktop/Enterprise Manager.
• Monitoring the jobs status and fixing post production defects.
• Created high quality dashboards using Tableau, crystal reports 2008.
• Constructing on demand queries/process based on business need and Querying/Analyzing production data to make critical business decisions.
• Identifying production defects and presenting process improvement ideas to fix various issues.
• Attending the RSM meetings to understand the business requirements.
• Preparing the approach documents, detail design documents and presenting the same to the clients.
• Provided quick solutions to avoid production issues using SQL, PL/SQL, UNIX, Shell scripting and Pro*C
• Code review process using Code collaborator(Smartbear).
• Presenting the code to SME Clients and maintenance team to get the code approved.
• Co-ordination with testing and configuration management team.
• Taking care of code migration using RTC, fixing post production defects.

Confidential, San Antonio, TX

Consultant

Responsibilities:

• Analysis on the existing Cost Basis models to understand the Process & interacting with Business/Vendor for any process clarifications
• Attending the RSM meeting to understand the business requirements.
• Preparing the approach documents, detail design documents and presenting the same to the clients.
• Responsible for tracking the changing requirements on a day to day basis and handling the code changes using SQL, PL/SQL, UNIX, Shell scripting and Pro*c.
• Conducting document/code reviews at each phase and ensure timely good quality deliveries using boreland starteam.
• Unit test plan preparation, execution of the test plans on all developed components and preparation of unit test reports as part of quality process.
• Configuration management-Setting up of Batch and real-time production jobs scheduling environment for the customer using Control-M Desktop/Enterprise Manager.
• Conducting trainings with onshore and offshore teams on project designs, technologies and applications systems.
• Handling additional responsibilities to allocate tasks to team members and Monitoring onshore and offshore work status.