SUMMARY:

• Worked as Solution Architect on Data Warehousing and BI related product development for last 12 years mostly in lead position. Designing and transitioning existing applications at Confidential to cloud.
• Total 15 Years exp. on various IT tools and technology with different roles & responsibility
• Expertise in process optimization in multi - application networked systems
• Experienced in customer / user interaction for production support or requirement analysis
• Designed, developed and lead multi-platform solutions with onsite/offshore team members
• Solution Architect / Tech Lead at Confidential Commercial Banking division, designing data warehousing solutions and streamlining existing Architecture / Process / Data Flow for Optimal Performance. Moving existing solution to microservices based Cloud solutions.
• Developed modules for complex BFSI (OLTP & OLAP) solutions using PostgreSQL, Java, Python, PL-SQL, Ab Initio & C/C++
• Production support experience of a 50+ TB Database environments, 15+ yrs. of total IT exp, in Application design and coding; logical and physical design of Databases; Data Warehouse and user applications. Develop high-performance OLTP and OLAP systems to help clients manage their business critical data & derive business intelligence to exceed challenging business needs.
• Expert in aspects of Component Management, Resource Management and Change Management during migration projects at large organizations, and Handling user expectation at client sites
• Developed & Tuned PL-SQL stored procedure using DBMS Profiler, Statspack, explain plan, ASH, AWR & ADDM reports to optimize report extraction from multi-million row tables and TB sized databases leading a team of developers onsite and offshore.
• Certified professional having OCP and MCDBA with 12+ yrs. of Oracle & SQL Server related software development experience, mostly at Banks and financial Institutions using Extreme Programing, RAD and Agile methodology.
• Developed many financial reports using HP Exstream Dialogue/ PL/SQL & C/C++ for the Banking requirement and regulatory reporting like Basel II related reporting.
• Developed data extraction and Data entry application for pre-migration data cleaning in VB and SQL Server for a very large scale multi location Data Migration projects.
• For Motorola’s Separation Project, created or analyzed Technical Build Document for 1,000+ diverse application consisting of over 15,000+ servers (prod, test, DR servers of App, DB, Web and Middleware) spread across various datacenter with stand-alone servers, Server clusters & virtual farm, spread all over the globe, for resource optimization.

TECHNICAL SKILLS:

Tools: Toad, DBArtisan, OEM, AWR, Erwin, ER-Studio, Erwin, APEX IDE, Forms6i Developer, XMLSpy, VS.Net & Microsoft Products

Languages: PL/SQL, Java, Python, C/C++

Databases: PostgreSQL, Oracle; SQL Server 2000/2005, MS-Access

Reporting Tools: HP Exstream Dialogue, Crystal Report, Reports 6i

Source Control Tools: GitHub, Subversion, Clear Case, TFS, VSS, HP Quality Center.

Operating Systems: Windows, HP Unix, Solaris

Project Management Tools: Jira, VersionOne, MS-Project, Remedy, Quality Center, Agile,

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Sr. Software Engineer / ETL Developer

Responsibilities:

• Analyze Loan Ops requirements, design and develop Pl/SQL, Python, Java, Oracle, Postgres based solution to maintain Bank Data Warehouse. Develop Pl/SQL procedures for ETL and Reporting.
• Migrate existing Oracle / PL/SQL / Ab-Initio based IT solutions to Python/Java/ Postgres on AWS
• Maintain Commercial Loan Servicing Platform and cater to Loan Ops requirements
• Update Monthly Invoices Statements / Year End Reports as per changing requirement
• Update IRS Reports (1098/1099) as per IRS guidelines using PL/SQL, Java, Postgres RDS
• Developed Escrow Report Module using PL.SQL and HP Dialogue
• Developed Reserved Escrow Reports using PL.SQL and HP Dialogue Development

ENVIRONMENT: Oracle 11G, Pl-SQL. Java, Python, Postgres on AWS

Confidential, Inc Richmond, VA

PL/SQL Developer and ETL Architect

Responsibilities:

• Analyze the reporting requirement with BSA
• Design and document a staging database and code structure for ETL process
• Perform Development DBA work and Create Tables, Indexes, Triggers, Packages & Procedures.
• Develop detail design document to help offshore as well as onsite recourses to code as per requirement.
• Get the modules pass through the QA system testing and UAT

ENVIRONMENT: Erwin, AbInitio, Oracle 11G, Pl-SQL & ClearCase

Confidential, Phoenix, AZ

Implementation & Production Support

Responsibilities:

• Pl/SQL development for Job transcription module Development, Test, QA and UAT system
• Perform Development DBA work and create tables, indexes, triggers and Packages.

ENVIRONMENT: VS.NET, Oracle 11G Pl-SQL / Team Foundation Server

Confidential, Phoenix,AZ

Development Implementation & Production Support

Responsibilities:

• Architect, develop and Support the ODS Oracle /Pl/SQL system on Dev, Test, QA-UAT
• Manage and monitor reverse migration data to AS400 system
• Production release of software into new States as per the state’s requirement
• Debug and develop stored procedures for new functionality.
• Complete the Process Document and Architecture Model to reflect the present system.
• Test the modules on Oracle 11G before migration.

ENVIRONMENT: NET, AS400, XML, Oracle 10G Pl/SQL / AS400, Erwin

Confidential, Phoenix,AZ

Data Architect

Responsibilities:

• As Data Architect, complete the Logical and physical model of the different module.
• Collection of data from user departments in different format, for migration to SAP.
• Validate and perform quality check on the data received from different sources.
• Write transformation script to categorize inventory as per SAP data requirement.
• Develop a rules engine to identify Parts and assign SAP acceptable Material Master Group code, based on part’s naming pattern, keywords in description or other attributes.

ENVIRONMENT: Oracle 9i, ER/Studio, MS Office (MS-Access, MS-Excel)

Confidential, Phoenix,AZ

Database Architect

Responsibilities:

• To gather and analyze technical build document of 1000+ applications for inter-dependency, server requirement, load and possible migration planning.
• Develop a utilization dashboard for separation planning using APEX, pulling data from SQL Server
• Help maintain an in-house developed component management database on SQL Server 2005.
• Analyze existing CMDB, user requirement to help plan a migration to BMC Atrium
• Participate and contribute to the various separation planning meeting with teams spread across globe to formulate strategy for Successful and error free separation of companies
• Report the Separation planning effort to the AVP-IT and top management at Motorola.

ENVIRONMENT: MS Project, ER/Studio, Oracle 9i, SQL Server, Unix, Solaris

Confidential, Newark, NJ

DBA/Developer

Responsibilities:

• Debug and deploy PL/SQL stored procedures for ETL operations to maintain the Data-warehouse for Billing, Trading and Business Intelligence (OLAP) reports.
• Develop / Migrate PL/SQL based weather analysis application from legacy C/C++/RDB based application
• Maintaining and monitoring Oracle 9i/10g database using shell scripts as cron jobs, windows scheduler and other 3rd party job scheduling tools like Tivoli Workload Scheduler.
• Maintaining and monitoring SQL Server2K/ 2k5 on different versions of Windows.
• Performing the Dev. DBA related other jobs of user maintenance, space management, backups, migration of data between databases using Import/Export or SQL Loader.
• Liaison between the client and the Offshore support team for 24x7 operations and nightly processing.
• Performance tuning for faster query and less resource uses using DBMS Profiler, AWR, ADDM and ASH reports on the OLTP Database and the Data-warehouse.
• Migrating Legacy application and databases to newer versions of OS and database (Oracle9i on Solaris9 or HP UNIX to Oracle10g on Solaris10).

ENVIRONMENT: SQL Server 2005/2000, Oracle 10g/9i, HP-UX, Solaris, Windows

Confidential

IT/Data Manager

Responsibilites:

• Managing the Bank’s Datacenter, to Install, upgrade and maintain SQL Server2k & Oracle 9i/10g production databases of 20+ countries in Asia Pacific region running Finacle on HP UNIX, Solaris, Red Hat Linux and Windows based servers with a team of DBAs in a 24x7 operation.
• Develop OLTP apps and reports using C/C++, PL/SQL, VB, Oracle, Btrieve as per the banking need and regulatory requirement. I was part of the discussion group to implement BASSEL II reporting.
• Design and deploy Redundancy (DR) and High availability (100% uptime) of the database using Log-Shipping in Oracle9i and Replication in MS SQL server2k databases.
• Tune Database & SQL for day to day smooth functioning of the Branches and EOD report Generation. Design, Debug and Tune, Stored Procedures developed using PL-SQL for Business Intelligence and reporting using Statspack, AWR, ADDM and other tools.
• Conceptual Design of the Data warehouse for banking data and Documents.
• Migrate data from different legacy banking system to centralized banking system & Oracle Database
• Also worked initially as developer to Develop and deploy software for OLTP and Reporting, using VB, Oracle APEX, MS Access, C/C++ and Btrieve to support banking products for the changing requirement of a large bank in India, with 14,000 branches.
• Developed ShubhSign a Signature capture & display software on DOS systems using C/C++.

ENVIRONMENT: C/C++, Btrieve, VB, ASP, SQL Server 2000, MS Office products, Oracle 8i/9i, PL/SQL, APEX, Forms/Reports6i, Novel Groupwise, HP-UX, Solaris