Kalpesh Patel Email & Phone Number

Bethesda, Md, Us

Bethesda, Md, Us

• Implemented near realtime data analytics platform using Snowflake, Qlik Replicate and Qlik Compose. Platform is used to deliver business process optimization, analytics and machine learning.• Build dashboards and analytics for Security Operations using Snowflake and QuickSite. This replaces manual process and provide richer analytics. • Annual cost savings of $300K by optimizing licensing, AWS and Snowflake cost. • Re-engineer technology solution and processes for generating messaging schema to reduce risk, increase flexibility and productivity. • Led project for POC of AWS Aurora as replacement for Oracle. • Implement data archival solution on Snowflake which saves about $3MM over 5 years (in-progress).• Implemented monitoring and controls for enterprise data lake using AWS Lambda and Splunk.• Managed data modelers for transactional and data analytics systems.• Managed team of ETL developers for implementation of process controls and data mart.•

• Responsible for conceptual and logical data models of Immigration and Customs Enforcement (ICE) systems• Partnered with CDO and business users for vision, justification and implementation planning of Collibra data governance tool• Responsible for planning, execution and quality of all team deliverables

Mclean, Va, Us

Subject matter expert for GE analytics, data, systems and processes.• Successfully converted GE analytics, reports and historical data to Capital One systems in timely manner.• Collaborated with product management to redesign real estate portfolio management tool providing integrated view of deal for asset managers.

Norwalk, Ct, Us

Developed and executed BI strategy in partnership with senior leadership. Managed onsite and offshore team of data architects, ETL and report developers.• Implemented portfolio analytics resulting in additional asset of $105MM and net income of $5MM. • Managed project to deliver Spotfire and OBIEE dashboards for risk management, marketing and finance for $10B of commercial loan portfolio.• Envision and implement dashboard to analyze competitive positioning of real estate portfolio.• Partnered with Risk, Sales, Finance, Operations and Marketing to deliver data and analytics. • Present business case, project status and product demo to C-level executives.Document requirements, perform business analysis, design dimensional model and data visualization.Participate in innovation challenge to build predictive model for loan payoff.

Us

Oversaw strategy and execution of all electronic fund transfer products. Managed a team of product managers.• Redesigned customer experience of funds transfer product (Quick Transfer) and wires to increase online completion and reduce customer calls. • Managed online fraud prevention to reduce fraud from $24 MM to $8 MM between 2006 and 2008. • Implement Cyota risk assessment and out of wallet (OOW) and over the phone (OTP) authentication for online transactions.• Developed justification for projects and receive buy-in from stake holders.• Wrote and reviewed business and functional requirements.• Developed customer experience including web page design and messaging.• Researched data analysis to understand pain-points, product usage and launch success.• Reviewed customer feedback and complaints.

Us

Responsible for development, reporting and production support of the enterprise data warehouse.Managed team of developers for data sourcing, reporting and production support.• Experienced in building enterprise data warehouse in demanding and dynamic environment at E*Trade. Data warehouse supports 500+ users from marketing, customer service, product management, credit, fraud detection and operations. • Completed multiple projects to load data and generate production BO reports.• Provided hands-on data modeling using ERWin.• Integrated data from various sources to create unified customer profile.• Supported mergers and acquisitions by integrating key performance indicators in the data warehouse.• Worked with Business Objects to translate reporting requirements for building of data mart.• Completed conversion of Teradata data warehouse to DB2 running on Linux cluster to reduce upgrade cost. • Saved conversion cost of $250K by developing in-house conversion tools.• Negotiated statement of work (SOW) for DB2 conversion with IBM.• Initiated data warehouse governance committee to prioritize development requests.• Standardized business requirements, data requirements, ETL design, data modeling, testing, defect tracking, code migration and change control processes.

Secaucus, Nj, Us

Ludwigshafen, De

Masters, Computer Science

Masters, Mechanical Engineering