Post Job Free

Resume

Sign in

Software Engineering Data Warehouse

Location:
Simi Valley, CA
Salary:
180
Posted:
February 13, 2024

Contact this candidate

Resume:

Simi RAJ Valley, MALPANI CA *****805-***-**** • ad3lz6@r.postjobfree.com • www.linkedin.com/in/rajmalpani PROFESSIONAL SUMMARY

COMMITMENT LEADERSHIP INTEGRITY

An innovative and vision-driven Senior Technology Leader with over 20 years of success applying cutting edge technology and leading global teams to deliver end-to-end solutions from concept through production within multiple industries including manufacturing, transportation, telecom, pharmaceutical, and financial. Passionate about building and implementing technological strategies focused on streamlining operations and increasing a company’s bottom line. Exceptional problem resolution and client needs assessment aptitude and a sincere interest in contributing to a positive work environment. Unique ability to relate to all levels of staff, mentor and motivate employees while still achieving high performance. Committed to excellence; dedicated to maintaining a reputation built on quality, service, and uncompromising ethics. Optimize Service management and initial cost via monitoring & open-source adoption. AREAS OF EXPERTISE

§ Software Engineering

§ Enterprise, Data Architecture

§ CRM / Master Data Mgmt.

§ Project/Budget Management

§ IT Services Management

§ Strategic/Tactical Planning

§ Cloud solution delivery

§ Architecture Governance

§ Risk Mitigation

§ Performance Management

§ Data Warehouse / Lake

§ ETL / BI / Advanced Analytics

§ Global Project Delivery

§ Global Team Management

§ DevOps, FinOps, DataOps, SecOps

PROFESSIONAL EXPERIENCE

ADP – PASADENA, CA Nov 2016

MIGRATION STRATEGY ARCHITECT & DELIVERY [C] – COMPLIANCE SOLUTIONS

§ Align collaboratively with product, technology and business stakeholders to drive strategic roadmaps, identify KPIs / OKR’s. Plan, prioritize scope, business objectives and deliverables. Deliver resilient, scalable, reliable platform, automating processes Implement domain driven design with micro-services, rules-driven, event architecture, with continuous integration, automated functional and performance testing part of deployment pipeline to Cloud.

§ Migrate business functionality from mainframe / db2 platform to java / spring boot / oracle, postgres, AWS cloud with fully automated data pipelines. Shadow deployments with file and transaction replication across old and new systems. Implement automated output comparison, validation and reporting to rollout feature to production.

§ Work with stakeholders to break down business domain, sub-domain(s) and discrete events. Design, plan, prioritize business & technical features to incrementally deliver outcomes in a phased manner.

§ Design and implement ELT, ETL pipelines to seamlessly migrate data to new platform. Streaming data to Databricks lakehouse, bronze, silver and gold stages with data quality and governance enabling faster analytics, reporting on critical capabilities / KPI.

§ Lead 35+ team of full stack cross-functional resources, recruit, coach, mentor, nurture, engage, motivate and guide. AWS / Azure, java, c#, asp.net, spring boot, spark, data factory, data pipeline, bpa engines, camel, oracle, redis, elastic search, angular, kafka, dynamodb, lambda, API gateway, databricks data lakehouse. TOYOTA FINANCIAL SERVICES - TORRANCE, CA Feb 2016 – Nov 2016 SR. ENTERPRISE APPLICATION / DATA ARCHITECT & DELIVERY [C] – CORPORATE SERVICES

§ Drive modernization strategy & provide architecture thought leadership for Corporate Services technology portfolio of financial, tax, accounting and dealer lending systems, build out ODS and augment data warehouse.

§ Document baseline business, data and application architectures for dealer lending, define transition / phase architectures that identify clear targets along the roadmap to realize target architecture. Document high-level conceptual and logical model of existing process/systems, catalog business processes and integrations.

§ Lead definition of data acquisition, integration & provisioning strategy, reusing strategic solution building blocks where applicable, identify commercial off-the-shelf and internal systems that can evolve into new architecture building blocks. Conduct business transformation readiness assessments, implementation and migration plan.

§ Won Innovation Shark Tank to improve Insurance Customer engagement, proposed a mobile solution. Led Business case (save, revenue, ROI, cost solution) preparation to present to C-level leadership for seed funding. AWS, azure, rackspace, asp.net, oracle, mssql, ibm mq, c#, erwin, enterprise architect, api gateway, salesforce FARMERS – LOS ANGELES, CA Aug 2015 – Jan 2016

SR. ENTERPRISE DATA ARCHITECT [C] – ENTERPRISE DATA ARCHITECTURE & BUS INTELLIGENCE Contract Position via Odesus Inc.

§ Developed ‘Data Architecture Principles’, a foundation for development of strategic & tactical architectures, including modernization of policy underwriting system with COTS product. Define and implement Data Governance practices, for consistent data & architecture development.

§ Develop conceptual architecture for Farmers data lake, define reference architectures for data sourcing / ingestion / federation and BI capabilities. Multi-phase roadmap to enable data discovery & self-service BI.

§ Define architectural vision to reduce complexity, simplify data integration & provisioning. Position operational data store (ODS) to address data integrity challenges and rationalize application that provide this capability across different business lines within the company. Conduct assessments across the enterprise to document current state, define transition, target state architecture. Socialize and obtain buy-in from leadership.

§ Authored white paper ‘Farmers Data Development’ providing in depth details of data architecture principles outlining features and benefits, with concrete examples, that demonstrate short-term and long-term benefits of applying consistent architectural principles.

§ As part of Data Warehouse modernization strategy, proposed an architecture positioning Data Lake (on Hadoop) to facilitate self- serve data discovery and analytics, ingesting to data warehouse. Evaluate Hadoop distributions and provide recommendation. Identify, document use-cases, develop data lake standards, to guide development.

§ Solution architecture for projects with conceptual, logical & physical models, applying architecture principles, define data pipelines using Informatica, IIB, ODI, DataStage and SSIS. Research & evaluate use cases for data virtualization & caching.

§ Perform cloud assessments and evaluate vendor solutions that can be integrated. Review and propose options that can be leveraged with minimal impact to current business functionality, architecture and provide saving. TOGAF, db2, oracle, hadoop, sqoop, hive, flume, spark, kafka, tableau, BO, OBIEE, ODI, Informatica, SSIS, SSAS. BANK OF AMERICA– AGOURA HILLS, CA June 2003 - Apr 2015 SVP. § Provide SENIOR overall TECHNOLOGY thought and MANAGER technical leadership – ARCHITECTURE to the engineering SERVICES teams on evaluation, development and deployment APR 2013 – for APR 2015 various projects executed by the department in partnership with technical & business teams.

§ Lead definition of multi-phase strategy to migrate users and ad-hoc reporting from a MSSQL shared scalable environment to Cloudera Hadoop multi-tenant platform to support data discovery & analytics.

§ Define and build new data pipelines using SSIS, ODI, DataStage, Golden Gate and Flume. Research & evaluate data integration options using kafka, ibm mq, message broker and composite for data virtualization, to optimize, rationalize and simplify overall architecture and reduce overall cost of technology ownership.

§ Lead transformation of team to adopt Agile delivery methodology moving away from waterfall.

§ Establish application and data architecture governance to review and approve design for simplification of Architecture(s).

§ Publish; maintain blueprint, standards and roadmap for Application, Data, technical and Domain architectures.

§ Research and evaluate (POC) new products to determine fit with the overall Mortgage domain architecture, ex. Feasibility study of Composite to virtualize/abstract data from end users & ad-hoc reporting, enabling testing and phased platform migration.

§ Having direct responsibility to streamline Data Acquisition and Abstraction, managed a cross-functional team. Defined roles, functions, processes and department capabilities. Identified key metrics to measure cost effectiveness, efficiency. Assess and implement technology / process changes to align with overall strategy. SSIS, SVP § § Lead Consult SENIOR SQL, and hadoop with motivate TECHNOLOGY business (cloudera 60+ unit global & and MANAGER hortonworks)cross-executive functional – leadership, MORTGAGE hive, team DataStage, to of understand REPORTING developers, map reduce, business analysts, & WAREHOUSE Linux, strategy. architect, obiee, Collaborate quality bo, cognos, assurance with tablaeu. peers, & DEC support partners 2011 personnel. & – MAR 2013

§ subordinates Conceive, oversee, in updating lead and technology drive the road architectural map, technology direction goals, and development and department across goals. many software development projects, provide alternative recommendations as needed.

§ Design ETL/ELT/streaming data pipelines to source data from disparate sources for ODS, Data Mart & EDW

§ Deliver proposed solution and lead discussions with clients, partners and vendors related to technical solutions, as well as provide consulting services for a variety of technology teams and services.

§ Responsible for developing the staff, scheduling training, overseeing resource time and assignments, defining resource availability and requirements, and evaluation of staff performance.

§ Build a common catalog of Mortgage data elements with documented data lineage back to source of origin

§ Perform strategic research and design in several major technical areas, and model business data elements.

§ Partner with IT governance, PMO and Risk partners to effectively manage project and risk to deliver within established timelines and cost targets, conduct periodic review of progress and remove roadblocks.

§ Works closely with other discipline leaders to ensure a tight integration across all disciplines is in place, as well as diversifying technology offering leveraging best in class products and services.

§ Optimized Mortgage Modification monitoring/reporting process by redesigning infrastructure and architecture, to derive business value out of company Data Assets.

§ Segregate production reporting from sandbox (ad-hoc) analytics for true data discovery. Use of storage cloning to improve data replication and overall system availability.

§ These changes resulted in a direct improvement of overall Business & IT Service Level Agreements (SLAs) by providing a timely view into modification lifecycle and required actions. ASP.net, oracle, mssql, hadoop, hive, ssis, odi, datastage, golden gate, obiee. VP § SENIOR Architect, TECHNOLOGY lead, and inspired MANAGER a team of - SOA SOA Integration / ESB engineers to develop an enterprise-class SOA capability Feb 2007 and build – NOV out 2011 of reusable SOA services for customer, account and financial transaction to meet mortgage needs.

§ Rationalize SOA capabilities across domain, by conducting feasibility/proof of concept study of xi50 DataPower appliance to build out ESB capability, and defined 3yr SOA roadmap. SOA / ESB framework focused on quicker integration of new applications, by stubbed interface on XI50 platform.

§ Integrated track, monitor, alert and report on SLA/OLA response time analytics.

§ Define / Improve process, documentation and tools for deployment and maintenance of major software projects, drive creation SOP, support documents to transition to operations staff.

§ Designed and built an enterprise class FaaS comprising of access control, authentication, authorization, logging, and caching with business rules capabilities services, to enable reuse, rapid prototyping and over time to deploy.

§ Built REST API enable generic search and update capabilities for existing web and windows applications, driving down complexity and change costs.

Mssql, VP § TECHNOLOGY As c#lead, asp.Enterprise net, wireframes, MANAGER Architect, ajax, – designed PRIVACY java script, and / MDM delivered ms enterprise multi-framework tier Enterprise (orm)Privacy . Management System to MAY capture 2005 consumer – JAN 2007 privacy preferences across marketing and communications channels. Automated business rule driven application of federal/state privacy rules.

§ Complex event based real-time integration of customer profile and account changes, to apply default privacy rules and extend existing preferences for existing customers.

§ Built an Enterprise Master Person Index (MDM) solution to uniquely identify customers by with a weighted probabilistic Predictive model, generating confidence scores for matching and making decisions.

§ Periodically interface with technical, Privacy, Marketing team leads and provide periodic update to leadership.

§ Consult on work schedules to expedite workflow. Confer with and advise subordinates on administrative policies and procedures, technical problems and priority management.

§ MVC based user interface in ASP .Net, SOA interfaces with caching to support pagination & quick response.

§ Asynchronous multi threaded privacy data scrubs of marketing campaign lists, with high throughput. BizTalk SENIOR § Data • SOFTWARE Integration C# .Net • Java architect ENGINEER • RPG interfacing • CDC – CUSTOMER • IBM with & business, Microsoft REPOSITORY internal/messaging / external CRM • MS CRM SQL product Server. delivery leads. Collaboratively JUNE 2000 built – APR a set 2005 of end-user interfaces to improve data quality and standardize how name and addresses get managed within enterprise.

§ Designed real-time and near real-time integration between Siebel CRM System, customer, business domains with dispatch service, workflow, EAI adapter, and custom Business Services in Siebel.

§ Design & build ETL / ELT pipelines, using EIM for eClaims for nightly data import and real-time integration using journal scraping, custom events, web services, XML messaging, real and near-time needs for employee facing applications. EDUCATION & CERTIFICATIONS

• The Open Group – TOGAF 9 • AWS Solution Architect • PMP, Certified SM & PO

• Data Science & Big Data Analytics • ITIL v3 Practitioner • Siebel Certified Consultant Mahatma Gandhi Mission College of Engineering, Maharashtra, India - Bachelor of Engineering Loyola College, Chennai, India – Masters in Computer Applications University of Illinois Urbana Champagne – Data Visualization, Mining & ML John Hopkins University, Baltimore, MD - Data Scientists Toolbox TECHNOLOGY PROFILE

Architecture Skills – TOGAF, Archimate, DMBOK, EABOK, ESB, API management, Micro-service, MVC, ORM, PaaS, SaaS, Data Acquisition, Modeling, Federation, Process modeling & optimization, Statistical Modeling. Languages –Python, SQL, PL/SQL, C, C++, C#, Java, AJAX, JavaScript, Typescript, Messaging (IBM, MS, JMS) Apache Kafka, Kinesis,

Database Skills – DB2, MS SQL, Oracle, Hive, Hadoop, MySQL, MongoDB, Ingress, Sqoop, SSIS, DataStage, tableau, quick sight MicroStrategy, Oracle BI, BO,, ER Studio, Power Designer. Project Methodology – Agile, Scaled Agile, Waterfall, Lean, Six Sigma, PMP, Program, Portfolio Courses & Seminars – .Net/Java Design Patterns, BizTalk, DataStage, Horton Works, Cloudera, Oracle Big Data, Exadata, ITIL, AWS Solution Architect, Data Science and Machine Learning, Databricks, Snowflake



Contact this candidate