Muralidhar Posanipally

San Ramon, CA ***** • 240-***-**** • ad4p2e@r.postjobfree.com

Summary:

•Lead business analyst having extensive experience specializing in the Banking and Financial industry, with a focus in ETL & Data solutions. A versatile technology leader having excellent communication, problem-solving and people skills with, 23+ years. multifaceted client experience across various range of large international technology leaders.

•Expertise in various phases of the product development life cycles (Technical and Project Management, Business Analysis, Functional Specifications, System/Application Architecture, High Level Design, Implementation, Testing, Support, Operations, and Professional Services).

•Significant experience in delivering products in agile and startup environments - release scheduling, progress reporting, customer and release prioritization, product development (including infrastructure and guidelines setup)

•Ability to coordinate activities across various teams. Certified CSM.

•Industry verticals experiences: telecommunications, banking, healthcare, finances.

•Project management skills - scope definition, budget management, work effort estimates, project schedule development, tracking and reporting, risk management

•Team leadership, presentation, training and customer engagement skills. Also proactive, independent and able to work with little or no supervision to meet deadlines.

•Ability to articulate complex technical issues to both internal and external customers and recommend appropriate solutions.

•Hands-on development (Informatica, PL/SQL, SQL optimization, MDM, OBIEE Reporting, Python, Apache Kafka).

Technical Skills:

•Software development methodologies – Agile & Scrum.

•Proficient in analysis, design and implementation.

•Project Management – MS Project, JIRA.

•Modeling tools and languages - Oracle designer & Erwin.

•Operating Systems – Linux, Windows, Unix (Solaris), Mac.

•Experience in programming languages, including JavaScript, Python, & PL/SQL.

•Source code management – Git, Subversion, VSS.

•Problem/defect tracking – JIRA & GitHub Issues.

•Content Management Systems (CMS) – WordPress.

•Business Intelligence (BI) and Data Warehousing – Business Intelligence Enterprise Edition (OBIEE).

•Technical Manager/System and Application Architect/Senior Software Designer.

•Technical manager and Scrum Master for a social platform product.

•Architecture and management of an off-shore development team.

•Technical tools: SQL, PL/SQL, COBOL, C, HTML, JavaScript, Oracle 19c, PL/SQL Developer, Forms and reports Visual SourceSafe, TOAD, Quality Center, Unix, Designer 10G/9i/6i, JavaScript, HTML, Dream Weaver and Oracle 9iAS, Portal10G/9i/3.0, Oracle Apps (AR, AP& GL), OBIEE12c, OBIEE 11g, Python, Shell Scripting, OBIEE, SQL/PL SQL, Anthill, Autosys, UDeploy, Jenkins, GIT, Jira, Informatica ETL. Informatica MDM. Good understanding of Kafka and Airflow.

Work Experience:

PG&E Corporation, San Ramon, CA ( July 2023 – Till Date).

Working as a Sr. Business lead analyst for MID Quality Management team which helps the Geographic Information Systems (GIS) system on a various application support needs.

First Republic Bank, San Francisco, CA (June 2021 – May 2023)

Working as a business analyst lead for CORE banking. converted the legacy system data into the new NACHA file formats and loaded into several databases. Also been part of the bank 160 conversion project. I was involved in enhancing/fixing several database issues related with daily wires and checking processing system related batch jobs. Also involved in release management and I managed Scheduling and coordinating releases across multiple applications within various portfolios across different teams and projects. Worked with Jenkins, OpenShift and few others deployment tools.

Wells Fargo, San Francisco, CA (2010 – Jun 2021)

•Over the several years of my Wells Fargo work experience, I have been involved in different application development lifecycles with various responsibilities.

•GBF: This application is an out-of-box FLEX-CUBE complete banking software, which we have customized to fit our business needs of our bank. I was leading on the reporting division for this application. My overall responsibilities include being a part of all scrum planning and implementation and drove the development team to accomplish goals. My role involved constant in Development, contacted code reviews, production support, middleware support and worked closely with development team, analysts and QA team.

•GTAR: Global tax application & reporting. It’s a complete Informatica ETL application. I was involved from the beginning of this project from design stage to implementation. I worked extensively with business users and mentored developers and worked closely with them on a daily basis. contacted code reviews sessions and involved in QA and built a support system in place for the production runs. Also implemented MDM part for the customer data which was coming from 4 different sources using Informatica MDM.

•GAMS/GABS: I have involved at foundation of these two applications. Part of architectural designs and led the database for both applications. Build all the DB environments for GAMS and GABS applications. Also built a robust PL/SQL procedure to implemented a OV3GL ETL interface system.

•FRAUDMIS: Lead ETL Development team in building custom ETL framework that collected, cleansed and integrated the company’s fraud related data from various operational source systems. This application is part of an overall initiative in get the internal risk management that supported and provided Wells Fargo executives, senior managers, and business analyst with analytical reporting capability on the company’s position and helps in their decision making.

Previous Experience:

•Chegg, Santa Clara, CA (Nov 2009 - July 2010).

•State Compensation Insurance Fund, Pleasanton, CA (July 2008 - Nov 2009).

•TGIC (Triad Guaranty Insurance), North Carolina (Apr 2006- July 2008).

PBGC (Pension Benefit Guaranty Corporation), DC Dec 2004 - Apr 2006

Location : Washington DC, DC

This is a PBGC is a federal corporation created by the Employee Retirement Income Security Act of 1974. It currently protects the pensions of nearly 44 million American workers and retirees in 30,330 private single-employer and multiemployer defined benefit pension plans. PBGC receives no funds from general tax revenues. Operations are financed by insurance premiums set by Congress and paid by sponsors of defined benefit plans, investment income, assets from pension plans trusted by PBGC, and recoveries from the companies formerly responsible for the plans.

Responsibilities:

· Gather, document, and analyze business requirements from stakeholders. This involves conducting interviews, surveys, workshops, and studying existing documentation. Also studied the current business processes to identify inefficiencies and areas for improvement. Propose and document optimized processes.

· Define detailed functional requirements that specify what a system, software, or application should do. These requirements serve as the foundation for development. Prepared functional/technical specification documents using the PBGC's customized template for the custom reports to be developed.

· Worked with Development & created creating the Database packages and procedures to load data into custom tables. Also worked with Development & created procedures and SQL queries to run the Ad-hoc reports and tuned the application (report queries, other SQL queries) to improve the performance.

· Worked with functional team in GL_Interface to load data into base tables. Interacting with the users for gathering the requirements and assisted them in User Acceptance testing.

· Prepared test document template for testing the custom reports and involved in unit testing of reports.· Maintained Code and Documentation using PVCS.

•NCI (National Cancer Institute), Canon USA.

•Department of Revenue, IL.

•GE Nuclear Power Plant, Wilmington, NC.

•Lucent Technologies, NJ.

•Gallup, Washington DC.

Note: Can provide full details of the above if needed.

Education:

•University of Osmania, Masters in Management Information Systems & Computer Applications-Hyderabad, India.

•University of Osmania, Bachelor in Electronics, Hyderabad, India.

Residency Status:

Citizen of USA

Contact this candidate