S. LINGARAJA PATIL adjp2m@r.postjobfree.com

704-***-****

Professional Summary

Extensive experience in Data Analysis, Database development and customiza9on and have overall 19 years of experience.

Technical background and also have expert level programming skills C#, VB.net, SQL, PL/SQL and UNIX shell scrip9ng.

Exper9se in Oracle and SQL Server Databases.

Achievements include automa9on of manual business processes, Designing and developing complete environment processing SSIS packages, exper9se on working with OLTP & OLAP systems, tuning programs down from 2-3 hours down to 15 minutes, surgical changes in code for specific issues, using shell scrip9ng to speed up data processing.

Experience includes gathering business requirements, conver9ng that to a func9onal specifica9on perform detailed technical analysis to determine the required rela9onships and then create the technical specifica9on with mapping to the database aOributes.

Extensive experience in Banking and Finance Domain.

Focused & detail oriented person. Believe in depth analysis and execu9on of tasks. Strong analy9c and problem solving skills and feel ecsta9c when challenged to use my skills to complete a task, solve a problem or lead and work with a team to provide a solu9on.

Extensive experience in Design and Development of Business Intelligence ETL Solutions & Data Modeling using MS SQL Server 2008 R2/2012 /2014 (T-SQL), MS Business Intelligence Development Studio 2008/2010 and SSDT 2012.

Domain Experience: Banking & Finance – Investment & Capital Management, Enterprise Market Risk Technology(EMRT), Comprehensive Capital Analysis & Review (CCAR).

Experience with Axiom Controller View Regulatory Reporting tool.

Good development experience in CCAR, Y9C, FRY14 A/M/Q reporting.

Exposure to MongoDB Database and Robo & Compass client tools.

Experience in SYBASE database.

Professional Experience

Description:

CCAR reviews are part of the “stress tes9ng” conducted annually by the Federal Reserve to determine a bank’s capital adequacy. The goal behind it is for important banks to have a reliable two-year documented capital plan that demonstrates that they have sufficient capital to con9nue opera9ng soundly during 9mes of economic distress & to have a robust capital planning process that includes a sophis9cated understanding of their unique poten9al risks. I was part of Data Services team which supplied data for CCAR. Responsibilities:

Wells Fargo, Charlotte NC

SQL Developer & ETL Specialist

August 2018 – Till Date

Project: Market Risk System and CCAR

• Developed various SSIS packages for the ETL process involved in CCAR application.

• Worked with Business Analysts for gathering the requirements & implementing the tasks.

• Developed complex SQL stored procedures for business needs.

• Created Autosys jobs (jil ailes) for scheduling the SSIS packages.

• Involved in the design of data models.

• Designed and implemented complex ETL transformations by developing, scheduling and deploying complex packages using SQL Server Data Tools 2012 (SSIS).

• Processes included designing complex script tasks, bulk loads, look up transformations, merge join, derived column and data conversion transformations from 2-3 different servers as well as multiple Zile types.

• Designed & implemented generic packages for all CCAR templates in SSIS.

• Designed and implemented generic SSIS package which executes multiple stored procedures by forming a dynamic SQL from a database table.

• Implemented Slowly Changing Dimension (SCD) in T-SQL using MERGE.

• Developed a package to copy tables data from one environment to another(UAT to Prod) dynamically using SqlBulkCopy in script task.

• Designed regulatory reports and created data sources.

• Developed data models, portfolios and tabular reports.

• Prepared aggregations and free forms as per report requirements.

• Participated in migration of Axiom components within environments. Environment: SQL Server 2012, SYBASE, SSDT 2012 (SSIS), JIRA tracker & Tortoise SVN for source control, Axiom Controller View .

Responsibilities:

Automated program workflows and developed web architecture paOerns.

Designed regulatory reports and created data sources.

Developed data models, porYolios and tabular reports.

Prepared aggrega9ons and free forms as per report requirements.

Par9cipated in migra9on of Axiom components within environments.

Supported UNIX file management and implemented shell scrip9ng.

U9lized Axiom technologies for automa9on of workflows.

Administered regulatory reports and maintained technical documenta9on. Description:

Wells Fargo, Charlotte NC

SQL Developer & ETL Specialist

October 2015 –October 2017

Project: Market Risk System and CCAR

Bank of America, Charlotte NC

Axiom Developer

November 2017 – August 2018

Project: CRR –Centralized Regulatory Reporting

CCAR reviews are part of the “stress tes9ng” conducted annually by the Federal Reserve to determine a bank’s capital adequacy. The goal behind it is for important banks to have a reliable two-year documented capital plan that demonstrates that they have sufficient capital to con9nue opera9ng soundly during 9mes of economic distress & to have a robust capital planning process that includes a sophis9cated understanding of their unique poten9al risks. I was part of Data Services team which supplied data for CCAR. Responsibilities:

• Developed various SSIS packages for the ETL process involved in CCAR application.

• Worked with Business Analysts for gathering the requirements & implementing the tasks.

• Developed complex SQL stored procedures for business needs.

• Created Autosys jobs (jil ailes) for scheduling the SSIS packages.

• Involved in the design of data models.

• Designed and implemented complex ETL transformations by developing, scheduling and deploying complex packages using SQL Server Data Tools 2012 (SSIS).

• Processes included designing complex script tasks, bulk loads, look up transformations, merge join, derived column and data conversion transformations from 2-3 different servers as well as multiple Zile types.

• Designed & implemented generic packages for all CCAR templates in SSIS.

• Designed and implemented generic SSIS package which executes multiple stored procedures by forming a dynamic SQL from a database table.

• Implemented Slowly Changing Dimension (SCD) in T-SQL using MERGE.

• Developed a package to copy tables data from one environment to another(UAT to Prod) dynamically using SqlBulkCopy in script task.

• Designed regulatory reports and created data sources.

• Developed data models, portfolios and tabular reports.

• Prepared aggregations and free forms as per report requirements.

• Participated in migration of Axiom components within environments. Environment: SQL Server 2012, SYBASE, SSDT 2012 (SSIS), JIRA tracker & Tortoise SVN for source control, Axiom Controller View.

Description:

In$ight Applica.on- Data Insights, Forecas.ng Dashboard In$ight is the financial analy9cs repor9ng Dashboard of record for Bank of America. It accepts feeds from the Bank’s various general ledger systems (FCS, GBS, GEAC, etc.) for use in repor9ng monthly and daily data as well as posted transac9on history. In$ight is also used for pos9ng entries to close the company’s books each month. It contains planning, scheduling and forecas9ng by linear regression modules as well as several u9li9es that report the chart of accounts, organiza9onal hierarchy, and en9ty structure.

Develop Analy9c Modules & troubleshoot using Oracle PL/SQL and Unix Shell scrip9ng and Models in VB Macros.

Analyze and tune processes using Oracle PL/SQL, Shell scrip9ng.

Use advanced PL/SQL concepts like Bulk Collect, XML genera9on, Collec9ons, LOB Manipula9on, database email.

Use shell scrip9ng commands like sed, awk for file manipula9on and tuning. Bank of America, Charlotte NC

Oracle Developer

April 2005 – September 2014

Project: IN$IGHT and FrontierFin SSIS

Requirement analysis, review changes, analyzes impact, support produc9on issues, provide weekly repor9ng & coordinate with Business & technical teams.

Coordinate with Applica9on manager, Business and Global teams.

Review, Test Analy9c Models, Assist & Guide team with development, support & tes9ng ac9vi9es.

Analyze, Propose, Create and Implement technical solu9ons to business problems.

Create custom process to improve efficiency and eliminate repe99ve tasks by automa9ng manual processes.

Verify applica9on results by conduc9ng system audits of technologies implemented.

Soeware Development Life Cycle (SDLC) requirements defini9on, design, Programming/tes9ng and implementa9on of major systems.

Use applica9on development methodologies like schedule, quality, stability & performance best prac9ces.

On-call & Primary contact to support for any major issues or system breaks.

Coordinate with leads of applica9ons upstream and downstream. Environment: UNIX, Power Builder 11, PL/SQL, oracle 9i. Fron.erFin SSIS Applica.on – Analysis and Categoriza.on of Accounts Data Fron9er provides support for Reconcilement of all types of accounts. This system currently has 5 databases to support the volume. The following reconcilia9ons are currently supported on Fron9er.

Reconcilement of General Ledger, Internal DDA, FRB and IP Accounts

Due From Bank reconcilement

Internal Reconcilia9on

Responsibili9es:

Developed the SSIS packages for processing the feeds in BIDS 2008.

Built the environment to schedule and execute the SSIS packages on batch server with/without SSIS engine.

Developed generic batch file for execu9ng SSIS packages via DTexec u9lity.

Developed generic batch file for Execu9ng stored procedures with parameters.

Developed generic batch file for transferring file files to mul9ple batch servers & Mainframe systems. Environment: Windows, SSIS 2008, Windows Batch scrip9ng. AHU-Automated Hold U.lity (September 2006 to December 2006) AHU is the Automated Hold U9lity to place holds on customer Accounts, AHU can place deposit holds, memo holds and collateral holds. Back office agents use AHU to place holds 24 hours a day 7 days a week. AHU has a GUI part where users can place hold manually, there is a web service part which interacts with Reg CC to place holds requests in real 9me. AHU also has the ability to process batch holds. Responsibili9es:

Gathered and analyzed Business Requirements, prepared of HLD, interacted with Business Users and Technical teams for requirements gathering and beOer understanding of the specifica9on.

Coding, Designing Database Model & Es9ma9on.

Created and Updated Applica9on related Documents and HLD.

Prepared and maintained the Control Plan Documents. Environment: Windows, C#, Web Services, SQL Server 2000. Recovery Management System/CROG Technical Group (RMS/CTG) (April 2005 to September 2006) RMS/CTG applica9on is the service plaYorm for BOA Consumer Card Call Centers. It provides complete account access, workflow, business rules, and service request and fulfillment capability for call center professionals. The CROG Desktop Automa9on describes several component applica9ons that automate various func9ons in the Credit Risk Opera9ons Group. The programs provide efficiencies to perform repe99ve tasks in support of Collec9on func9ons. The various desktop automa9on modules that the project caters to are Advocacy, CROSS Desktop, Bankruptcy (Card and Non Card), Na9ons Trac, Fraud GUI and VGS Repor9ng. These applica9ons are used by Call Centre associates in Norfolk, Pasadena, Dover and Phoenix. The client, CROG is responsible for collec9ons for the General Bank. Affected product lines include Direct, Indirect (Secured and Unsecured), Lease, Specialty, MSP, CSA/AFS, and RMS/Na9onal Recovery. Clients are located in Greensboro NC, Ft. Lauderdale FL, Brea CA, Norfolk VA, Pasadena CA, and Phoenix AZ. The main objec9ve of this engagement was to understand the environment, System architecture and exis9ng processes, to provide enhancement and maintenance services for RMS/CTG Applica9ons and to provide a generic solu9on/methodology.

Performed applica9on study, Par9cipate in impact analysis and development of change requests.

Deployed the new changes, performed Defect tracking.

Updated system documenta9on.

Program analysis for problem diagnosis and change impact analysis

Extracted business rules, En9ty Rela9onship models, process models and cross references in the various applica9on modules of the project

Deployed IRIS, the Integrated Rela9onship Informa9on System across the project. This gives the detailed metrics, defects, back up processes, and risk management and mi9ga9on strategies for the project.

Analyzed the defects and implement ac9ons to improve the produc9vity of the project. Environment: Windows, Oracle 9i database, Power Builder 5.0(For GUI), korn Shell scripts, SQL server, Visual Basic 6.

Description:

This data analy9c product is a window-based Workflow Management System developed specifically for file management in field of healthcare. It has 2 modules – System Administrator and WorkSta9on.

Conceptualized the whole Product Architecture from the idea

Developed in VB.Net, Designing Components in .net, crea9ng stored procedure and lead the team implemen9ng the same.

Environment: Windows, Visual Basic.Net, SQL Server 2000 database. Technical Summary

Oracle 9i, SQL & PL/SQL, TOAD & Quest SQL Op9mizer, R language, UNIX Shell scrip9ng, SQL Server, SSIS 2008, Power Builder 12, and .Net VB & C #.

EducaSon

R.V.C.E College, Bangalore, India

Bachelor of Engineering in Instrumenta9on and Electronics, 2000 Vennar SoT Systems Pvt Ltd,, Bangalore

.Net Developer

August 2001 – April 2005

Project: Development of Health Care Data Management System

Contact this candidate