SUMMARY:

• Highly motivated, results - oriented with extensive experience in software development with over 15 years experience.
• Experience in all phases of SDLC (Software Development Life Cycle) requirements gathering, analysis, design, development, testing and implementation of Business Applications using client/server Data Warehouse systems in Financial and other industries.
• Extensive experience working with database Procedures, Functions, Packages, Triggers using SQL and PL/SQL.
• Good experience with Performance Tuning of SQL.
• Experience working in different SDLCs models - agile and waterfall.
• Proficiency in using Informatica Power Center tool.
• Experience working with complex mappings applying various transformations such as Lookup, Source Qualifier, Update Strategy, Router, Sequence generator, Aggregator, Rank, Stored Procedure, Filter, Normalizer, Joiner and Sorter transformations.
• Experience in gathering business requirements and converting into technical specifications.
• Extensive knowledge in production support environment and the processes involved.
• Good knowledge of Dimensional Modeling, Star and Snowflake schema.
• Ability to quickly adopt/learn new technologies.
• Known for being collaborative and approachable, possessing exceptional analytical and problem-solving skills, and exhibiting excellence in meeting needs of business and key stake holders.
• Direct customer & client interaction during requirements gathering, negotiating, design, development phases.

TECHNICAL SKILLS:

Languages:  SQL, PL/SQL, T-SQL, C, C++, Java, Unix Shell Scripting, Perl

Software:  Informatica PowerCenter, NiFi, Erwin, SQL*Loader, Oracle Forms and Oracle Reports 6i, Developer 6i, SQR, Procedure Builder, Graphics Builder, Discoverer 3.1, VBA, VB, Toad, SQL Navigator, Embarcadero Rapid SQL, Putty, Crystal Reports E-Commerce

Technology:  AWS, HTML, Java Script, Java, MS Front Page 2000,Oracle Web Server, HTP, HTF and OWA packages

Databases:  Oracle 12c, PostgreSQL, Sybase, MS SQL Server 2008, MS Access 2000

PROFESSIONAL EXPERIENCE:

Confidential, Columbia, MD

Database Engineer

Environment: PostgreSQL 9.5.4, NiFi 1.2.0, Erwin 9.7, AWS, Linux, JIRA, Aqua Data Studio, Putty

Responsibilities:

• Implementation of redesigned Medicaid Drug Program (MDP) system, reusing elements of existing systems and processes, as appropriate. This project is funded by CMS.
• Worked on a POC for using NiFi as ETL tool.
• Maintaining of Data Model using Erwin.
• Development and maintenance of PostgreSQL relational database routines hosted in AWS.
• Regular business interaction.

Confidential, Durham, NC

Principal Software Engineer

Environment: Informatica 9.1.0, Perl, Unix, Lynx, Oracle 12.1.0.2.0, Sybase, T-SQL, clearcase, AutoSys, Stash, Source Tree, Crucible, JIRA, Sonar, OBIEE - 11, utPLSQL, Jenkins, Application Lifecycle Management Quality Center, iCEDQ, Embarcadero Rapid SQL, Putty

Responsibilities:

• Analyzed, designed, developed, tested, and deployed code to various non-production environments and provided production support activities.
• Modified Informatica loader workflows to fix bugs and add stability.
• Analyzed several Informatica workflows as part of Production support activity.
• Supported and maintained in-house Fund Fact Generic Extract data warehouse application.
• Developed new and maintained existing Perl data loaders.
• Analyzed and executed resolution of discrepancies in Ranking data. Served as SME for Ranking Engine application.
• Created and implemented multiple process/improvements: data movement, report posting, dividend calculation.
• Created a process using Informatica to provide fund readiness signal to Performance Attribution team.
• Setup Sonar for code quality reporting, conducted several knowledge transfer sessions, and ran daily scrum meetings on a rotation basis.
• Improved query performance.
• Implemented PWI Non-Registered Fund Project.
• Led cross-functional collaboration to gather and load 2500 funds to performance system: set up new funds, loaded historical NAV/ Dividends/Milrate income, calculated performance results for historical data, validated performance data, produced consumer feeds/flat file.
• Involved in project planning meetings - determined intermediate deliverables and timelines.
• Used bulk copy utility (bcp) to load historical data to staging table.
• Managed release planning and install.
• Regular interaction with Production support team.

Senior Software Engineer

Confidential, Merrimack, NH

Environment: Oracle, Sybase, MS SQL Server, T-SQL, Informatica 7, Erwin 7.0, Perl, Unix, VBA, VB, clearcase, AutoSys, OBIEE - 11g, Embarcadero Rapid SQL

Responsibilities:

• Migrated various modules (calculation, data retrieval) to new system.
• Conducted analysis of the business requests - defects / enhancements.
• Designed, developed, and tested various defects / enhancements; created packages, triggers.
• Performed QA testing during development and prior to install in Production.
• Deployed code to various environments, including Production. Provided Production support of the application.
• Created Perl loader to load Money Market Fund NAV.
• Involved in data model design and review meetings.
• Managed team for one year: led business meetings to determine business requirements; prepared project plan and conducted capacity planning in MS Project; presented project results to key stakeholders; and, performed database code reviews.

Consultant

Confidential, Boston, MA

Environment: Informatica 7, Unix, Oracle, Sybase, MS SQL Server, T-SQL, VBA, VB, AutoSys, MS Access, Crystal Reports, Rapid SQL

Responsibilities:

• Maintained Legacy Bonus Calculation suite of applications developed in MS Access, VBA, Net, MS SQL Server, Sybase, and Crystal Reports.
• Fixed bugs and created enhancements, including writing SQL scripts and making changes to VBA code.
• Performed QA testing during development and prior to install in Production.
• Developed Informatica workflows to move vendor data from Oracle database to MS SQL Server database.

Confidential, Southborough, MA

Database Analyst

Environment: Oracle 9.2.0, SQL*Loader, Analog, SunOS, Toad

Responsibilities:

• Installed Oracle and created development database on SunOS.
• Performed DBA tasks, such as creating users, granting privileges, and managing objects and storage on the development database.
• Responsible for backup and recovery of development database.
• Created procedures, functions, and triggers using SQL and PL/SQL.
• Wrote Shell, Perl, and PL/SQL scripts for extracting data and automating data passing. Scheduled and managed jobs in Unix.
• Managed various data integration projects, including changes to XML registration forms for real-time data passing.
• Led the implementation of on-demand CRM application SFDC.
• Managed the data synchronization between Accela, YesMail, and Commerce.
• Loaded data into Oracle using SQL*Loader and MS Access.
• Installed and configured MS Service for Unix on Win2K3 server and set up backup and recovery of Unix servers.
• Managed custom reporting process for internal and external customers.
• Used Analog reporting tool to analyze web server log data. Managed Lotus Notes mail system.

Confidential, Windsor, CT

Programmer/Analyst

Environment: Oracle 8.1.6, SQL*Loader, SQR Work Bench 4.1, MS Access, Windows NT, SunOS 5.6, SQL Navigator

Responsibilities:

• Wrote adhoc SQL scripts to apply changes to production environment and wrote procedures, functions, triggers, and packages.
• Created and modified SQR reports for claims processing; created reports that ran stand alone and also on the Web.
• Performed tuning of SQR reports and created data extract and SQR report templates.
• Created adhoc reports using SQL*Plus, loaded data into Oracle using MS Access and SQL*Loader, and wrote batch programs to perform various tasks, as well as several macros in Excel for complex data processing.
• Mentored new developers.
• Received several employee and manager recognitions.

Confidential, Boston, MA

Consultant

Environment: Oracle 7.1, 7.3, 8.0, Oracle Applications 10.7, Oracle HRMS 11, Reports 2.5, 3.0, Discoverer 3.1, CuteFTP1.4, PVCS 5.2, HP Unix 10

Responsibilities:

• Created reports with Oracle HRMS using Reports and Discoverer.
• Responsible for Discoverer administration module and creating base views for reports.
• Worked with Time and Billing module, responsible for creating new reports and maintaining existing reports.
• Extensively used Concurrent Request Manager (CRM). Created reports to generate an EFT file for international bank payments.
• Performed a preliminary analysis of aggregate tables’ usage to resolve performance problems and wrote a routine to fix data in one of the aggregate tables used extensively by reports (used a procedure with extensive PL/SQL).
• Worked on reports collation and distribution project (extensively used SQL and PL/SQL).
• Interacted extensively with users’ group.

Confidential, Waltham, MA

Consultant

Environment: Oracle 7.1, Oracle Financials 10.6, SQR 4.0, HP Unix 10

Responsibilities:

• Worked with Project Accounting module of Oracle Financials, responsible for creating, testing, and performance tuning SQR reports.
• Modified numerous reports to meet end user requirements and to fix bugs; interacted extensively with end users.
• Performed migration of code from development database to QA and production databases for both SQR and Business Objects.