VIGNESH NARAYANAN
Salesforce Architect
Atlanta,GA
Summary
Software Engineer excited about understanding business problems, designing and delivering efficient solutions.
Ability to work across the complete tech stack, quickly scale-up in and work with any skill.
Overview
16
16
years of professional experience
5
5
years of post-secondary education
Work History
Software Engineer
MRC Global - On Contract Via Scope IT Consulting
Atlanta, Georgia
02.2022 - Current
- Salesforce Architect / Lead Developer
- Work across 3 Scrum teams, design and develop solutions around Salesforce B2B Commerce platform
- Product backlog identification and refinement, requirements elicitation, story writing
- Proofs-of-concept for identifying new products
- Salesforce platform customization - Apex, VisualForce, LWC, JavaScript, HTML, CSS
SFDC and Data Integrations Developer
Bank Of America
Chennai, Tamil Nadu, India
03.2019 - 01.2022
- Wholesale Credit Transformation
- Multi-year transformation program to move loan origination, underwriting, fulfillment and monitoring processes from siloed .NET platform applications to single end-to-end wholesale credit system based on Salesforce CRM / nCino managed package
- Tech Lead for 10-member Scrum team - Salesforce.com platform development
- People-manage 15 contractors – actively mentoring and managing their aspirations apart from logistics such as access, time-sheets and hiring and back-fill management
- Daily stand-ups, planning sessions, and retrospectives to plan, track, and code development tasks
- Features elicitation, User Story documentation and story-pointing – collaborate with product owners, platform managers and business analysts
- Translate simple to complex user stories into functional and actionable software within Salesforce environment
- Develop product capabilities using Force.com, APEX, VisualForce
- Carefully evaluate Salesforce Governor limit consumption patterns and decide best approach to implement requirements in Apex triggers / validation rules / workflow rule field updates
- Data modeling – plan for new custom objects / fields, implement Lookup, Master-Detail and Many to Many relationships between Objects and created Rollup-Summary Fields, worked with Cross-Field Objects
- Design and develop new APIs using Mulesoft
- Frameworks aimed at minimizing future development efforts
- Design and develop data pipelines / ETL processes- using Informatica, PL SQL stored procedures and UNIX shell scripting
- Technical Documentation of problem statements and flow diagrams using Confluence
- Production Release Planning and support
- Timely escalation and documentation of risks, identify and implement appropriate mitigations
- Ideation, brain-storming and development of process improvements
- Develop and demo proofs-of-concept (POCs) for new tools / utilities / ideas
Database Team Lead / Data Engineer
Bank Of America
Chennai, Tamil Nadu, India
05.2014 - 02.2019
- Regulatory Data Capture Toolkits
- Appian based BPM solution to manage flood insurance tracking, due diligence, calculation, QA, and collateral flood zone determination
- Develop key enhancements to reuse existing zone determinations and reduce operating cost, easier collateral management
- Team leader for 3-6 member team located across various onshore/offshore locations
- Apache Elastic Search based UI to enabling high-speed integrated search of client reference information and AML-KYC workflow information from different databases.
- Requirements elicitation and documentation – close liaison with business partners and business analysts
- Design logical and physical data model in close coordination with information /solution architects
- Build data pipelines / ETL processes - using PL SQL programs, SFTP and UNIX shell scripting
- Load test planning and coordination; Database performance monitoring, analysis and tuning using AWR, OEM, Dynatrace
- Data Analysis – data dictionary of wholesale credit data elements, extraction of complex reports
- Documentation – Design, Application Maintenance, Production Support knowledge base and run-books
- Release Planning
- Build presentations and system flow diagrams
- Timely escalation and documentation of risks, identify and implement appropriate mitigations
- Ideation, brain-storming and development of process improvements
Production Support Analyst
06.2013 - 04.2014
- Interconnected suite of Oracle database applications which host Bank’s client reference data and Accounts data
- Complex and Inter-dependent overnight Autosys batch processes loading data from multiple SORs with tight SLAs
- Team Leader for 5 member team responsible for batch monitoring and incident triages
- Routine Health-checks and maintenance of 3 applications based on Oracle PL/SQL, UNIX, Autosys Batch Scheduler
- Automation of manual job monitoring activities
- Performance Tuning of PL SQL programs and UNIX shell scripts
- Design documentation, Application Maintenance documentation
- Ideation, brain-storming and development of process improvements
- Mentor colleagues on technology, soft skills and process
Production Support and Applications Maintenance Analyst
04.2010 - 06.2013
- Client: Financial Conduct Authority (FCA - UK)
- Production Support and Maintenance of a number of IS applications based on various technologies like Oracle PL/SQL, Oracle BPEL Process Manager, Microsoft Access, VBA
- Incident, Change and Problem Management
- Service Requests, Work Requests, Estimations
- Quality Control of deliverables
- Performance Tuning of PL SQL program units
- L2 support for a number of 3rd party managed product based IS applications
- Subject Matter Expert for a number of applications
- Provide consultancy to BAs for planned changes to apps
- Design documentation, Application Maintenance documentation
- Identify and progress Continuous Service Improvements
- Technical review of contractual documents
- Subject matter expertise and impact analysis for upgrading database from Oracle 9i to 11g
- Application Impact Analysis documentation
- Provide inputs to Solution Architects and Technical Infrastructure Partners to identify key remediation factors as part of the upgrade
- Provide inputs to testers to write regression test plan and test cases
- Release Notes detailing the steps to configure the applications to point to the upgraded databases
Services Transition Technical Analyst
Financial Conduct Authority (through Steria)
London, United Kingdom
01.2012 - 04.2012
- Case and Intelligence Management application - Services Transition, Client: Financial Conduct Authority (FCA - UK)
- Knowledge acquisition of a newly commissioned application
- Acquire technical and functional knowledge on SAS’s off-the-shelf product – Memex Patriarch
- Played key role in completion of project closure activities
- Timely identification of risks and issues
- Effective reporting to onshore Services Transition Manager, and offshore Services Delivery Manager and ensure seamless transition of application support services to offshore
- Application Maintenance documentation
- Incident and Change Management in conjunction with 3rd party support vendors
Developer
Financial Conduct Authority (through Steria)
London, United Kingdom
03.2009 - 04.2010
- Client: Financial Conduct Authority (FCA - UK)
- Acquire technical knowledge on off-the-shelf products - OpenText Livelink Content Management suite, Oracle (InQuira) Knowledge Management suite, OpenText (Vignette) Web Content Management suite
- Seamless transition of level 2 support services from onshore to offshore
- Timely identification of risks and issues
- Effective reporting to onshore Services Transition Manager and offshore Services Delivery Manager, and ensure seamless transition of 2nd line support services from onshore to offshore
- Application Maintenance documentation
- Incident and Change Management in conjunction with 3rd party support vendors
- Deployment and testing of product patches and releases, yr)
- Business Automation in Regulatory Transactions (BART), Payment Services Directive (PSD) – Oracle PL/SQL Applications Development
- Client: Financial Conduct Authority (FCA - UK)
- Regulatory directives transaction automation for UK’s financial regulator
- Oracle PL/SQL application development – Stored packages & procedures, Database triggers
- Technical specifications, Unit test plan, Release notes documents
- Performance tuning – using Explain Plan, Autotrace, DBMS_XPLAN, DBMS_PROFILER, DBMS_STATS, TKPROF
- First line administration of Development databases – Database Shutdown/Startup, User and Roles creation, monitoring log files
- Disk space forecasting, planning and creating tables, table spaces and indexes
- Enhancement of UNIX shell scripts and SQL scripts used for data extraction
- DBA
Database Administrator
British Telecom (through Steria)
Pune, Maharashtra, India
07.2006 - 02.2009
- Applications Maintenance
- Client: British Telecommunications (BT – UK)
- Maintenance services for a suite of Telecom applications
- Oracle PL/SQL development – Stored Procedures, DB triggers, collections
- Incident & Change management, handling how-to queries through emails and phone calls, ad-hoc reports, data fixes
- Automation of routine monitoring tasks
- Troubleshooting stuck and long-running Oracle Workflow items
- First Line Database Administration - shutdown and startup, table, tablespace and index creation, user and roles creation, export/import, DBMS_JOB scheduling
- Oracle Advanced Replication troubleshooting – using DBMS_REPCAT, DBMS_REPUTIL, DBMS_DEFER_SYS
- UNIX shell scripting
- 24/7 support
Education
Bachelor of Engineering - Electrical And Electronics Engineering
VLB Janakiammal College of Engineering And Technology (Anna University
Coimbatore, Tamil Nadu, India 01.2002 - 01.2006
Higher Secondary -
Suburban Higher Secondary School
Coimbatore, Tamil Nadu, India 03.2001 - 06.2002
Skills
Salesforcecom Platform (SFDC) Customization
Sales Cloud - designing and developing VisualForce pages, LWC components, Apex classes, Triggers, Controllers, Test methods, Schedulers, Batching
REST-enable classes, Bulk API V20 based data loads, fluency with Composite API callsPlatform Cache, Platform EventsSalesforce B2B Commerce Cloud - CloudCraze Datamodel, APIs
NCino Bank OS (screen, route, route group and field configurations)Mulesoft API Design and Development 38 and 4 - REST/SOAP APIs, Batch Processing, Exceptions, HTTP, DB, VM, Salesforce connectors
Informatica ETL Batch Integration - mappings, sessions and workflows, performance tuning, Salesforce data loading
Salesforce B2C Commerce Cloud (SFCC) – Business Manager Site Configurations, Cartridges, Controllers, Models, ISML, OCAPI, JavaScript
Accomplishments
- LinkedIn Profile
- CAREER SNAPSHOT
- 15 yrs work experience in software design, development and maintenance with 3 yrs of Salesforce.com platform expertise
- Feature Lead – 10-member Scrum team for 15+ consecutive Program Increments delivering well-recognized business value
- Primary expertise:
- Salesforce.com Platform (3 yrs) – Salesforce Certified Platform Developer I (PD I)
- Data Integrations Development using Mulesoft and Informatica ETL (3 yrs) – Mulesoft Certified Developer (MCD)
- Thorough understanding of business processes and delivering highly effective and robust solutions in an efficient manner
- Technology-agnostic logical thought process that enables to quickly step up with any tech-stack
- Automation and continuous process improvements
- Secondary expertise:
- Salesforce Commerce Cloud - B2C – Salesforce Certified B2C Commerce Developer
- CI/CD – Jenkins, Groovy, XLR, Artifactory
- NCino
- Oracle PL/SQL (12 yrs), Data Modeling and Database performance tuning
- People management and mentoring
- 6 months onsite exp
- During 2016/17 at NC, USA for Bank of America as Database team lead
- 6 months onsite exp
- During 2011/12 at London, UK for Financial Conduct Authority (through Steria) as on-site coordinator leading support services transition
- Exceptional team leadership and mentoring qualities; 8 yrs exp
- In setting up and leading high performance global delivery teams
- Effective written and verbal communication skills
- Strong presentation and articulation skills, and process design expertise
- Rigorous practitioner of Continuous Learning
- Extensive knowledge in Banking domain – specialization in Wholesale Credit Underwriting, Operations and Regulatory Reporting frameworks such as 14Q, CCAR, HMDA
- Risk Management and Auditing
- SPECIAL CALLOUTS
- Championed the adoption of Salesforce trigger framework by 20+ feature teams in the release train, resulting in standardization of all triggers to efficiently perform SOQLs and DMLs better adhering to the governor limits, and enabling modularity and easier traceability – 2021
- With a strong relational database and ETL development background for 10+ years, stepped up fairly quickly on Salesforce.com (PD I certified) and Mulesoft integration skills (MCD I certified), obtained full-stack expertise, consequently leading a Feature team successfully for 2 years – 2019-2021
- Designed and developed pluggable and configurable frameworks
- Metadata-driven dataset API framework using Mule and Salesforce composite API, leading to quick build-out of new APIs just using configuration avoid costly development and testing efforts - 2021
- Batch framework using Mule batch capability, leading to migration of Informatica ETL processes to Mule in turn resulting in platform simplification and FTE saves – 2020
- Proposed and built framework to invoke Salesforce Apex classes from Autosys / Unix / Mule thereby preventing scheduling conflicts between Autosys and Salesforce CRON
- This allowed easier dependency definitions and centralized control of all scheduled processes under one umbrella, resulting in failsafe overnight batches, easier monitoring and alerting – 2021
- Collaborated with vendors and DevOps teams and led end-to-end CI/CD setup of Datical (Liquibase) database automation
- This helped in automating build validations and Artifactory packaging for Oracle database DDL/DML changes and stored programs hence avoiding costly manual errors - 2019
- During times of funding shortages and resource crunches, led global development teams from offshore to deliver Oracle database design and development for key regulatory programs such as CCAR and HMDA in extremely short timeframes, leading to dollar saves - 2015
- Tuned performance of a Loan Booking platform database using AWR, exec plans, indexes, hints, query remodeling, and delivered 30% improvement in run time of critical batch processes - 2016
- Risk Champion and Process Improvement Champion for project portfolio – 2018-2021
- Collaborated with broader teams and brainstormed 50+ ideas resulting in effort saves and user experience improvements; helped articulate problem statements and benefits accurately
- Pro-actively identified and escalated multiple process and technology risks leading to operational robustness.
Timeline
Software Engineer
MRC Global - On Contract Via Scope IT Consulting
02.2022 - Current
SFDC and Data Integrations Developer
Bank Of America
03.2019 - 01.2022
Database Team Lead / Data Engineer
Bank Of America
05.2014 - 02.2019
Production Support Analyst
06.2013 - 04.2014
Services Transition Technical Analyst
Financial Conduct Authority (through Steria)
01.2012 - 04.2012
Production Support and Applications Maintenance Analyst
04.2010 - 06.2013
Developer
Financial Conduct Authority (through Steria)
03.2009 - 04.2010
Database Administrator
British Telecom (through Steria)
07.2006 - 02.2009
Bachelor of Engineering - Electrical And Electronics Engineering
VLB Janakiammal College of Engineering And Technology (Anna University
01.2002 - 01.2006
Higher Secondary -
Suburban Higher Secondary School
03.2001 - 06.2002