Sr Data Engineer

• Jan 2019 - Present

Data Engineer

• May 2014 - Jan 2019

LendKey is a digital lending platform that partners with community-oriented financial institutions to offer consumers a range of products, including private student loans, student loan refinancing and home improvement loans. With a complete end-to-end solution that encompasses marketing/customer acquisition support, credit decisioning, loan origination, loan servicing and liquidity management, LendKey enables its nearly 300 lending partners to rapidly deliver an expanded menu of credit options to consumers via a user-friendly, cost-effective digital channel. In addition, by providing lenders with the ability to offer credit products online in an efficient, compliant and secure way, LendKey offers borrowers a simple digital lending experience and access to financing options they need to improve their lives and enable their dreams.• Perform ad-hock "what-if" data analysis using Python and Pandas• Manage and prioritize data team's backlog based on customer value through regular sprint planning sessions• Working on defining development coding standards and deployment processes for the data team• Design, model, develop & optimize stored procedures to meet data management and data reporting objectives in SQL Server Management Studio• Perform data analysis and develop interactive dashboards and reports with drill-down capabilities using Logi Analytics• Automate month-end Lender Reporting activities/reports using VBA/Logi Analytics/MS SQL Server/Python • Lead Design, Development, and Testing of Enhancement efforts, act as Subject Matter Expertise around data and design for credit reporting• Ensure compliance with the standard credit reporting METRO2 file format and required customer information submitted to the credit bureaus• Collaborate with business stakeholders, Service Operations, Legal and Compliance, as well as credit agencies to identify and resolve issues, manage risks, and communicate status, escalate risks as appropriate Show less

Business Analyst

• Jan 2012 - May 2014

• Acted as a liaison between business units, technology teams and support teams for commission applications. Work with commissions line of business to elicit, analyze and document business requirements in accordance to Software Development Life Cycle (SDLC) best practices. • Led user acceptance testing and reviewed test strategy documents for various projects. Conducted user workshops facilitating effective change management • Assisted in troubleshooting post implementation issues and performed ad-hock analysis for business units • Mentor/Point of contact for multiple projects to train users to use tools like RQM and ReqPro that support adoption of Lean SDLC process framework • Created detective controls to facilitate internal audit to validate changes done to sales compensation rate classifiers. This solution enabled business to close critical audit findings. MS Access tool was used to sift through large datasets in order to capture and report changes done to rate classifiers • Created a process to track and coordinate service requests until closure and generated reports on service levels Show less

Business Analyst

• Jul 2010 - Jan 2012

• Created Portfolio Analytics/EPMO Executive Dashboard report that was presented to the C level Executive Committee on a bi- weekly basis • Supported the Director of Enterprise Project Management Office by creating procedural documents such as user guides, job aids and process flow diagrams to setup a new demand management process • Orchestrated a Resource Management tool (using MS Project and MS Excel) and a process for the IT Organization that resulted in increased visibility into resource capacity and better management of project prioritization • Collaborated and facilitated Joint Application Design (JAD) sessions with business and technology partners to identify, analyze and document requirements for an enterprise-wide implementation of HP – Project & Portfolio Management tool • Prioritized defects found during UAT and worked with the implementation team to track them through to resolution Show less

Business Applications Analyst Intern

• Jun 2009 - Jun 2010

• Ensured timely rollout of a travel management project in 5 different countries in Americas and EMEA regions; involved in process improvement efforts; conducted user workshops facilitating effective handover. • Led business testing (as a Test Coordinator) for various projects using Solution Manager. • Enabled the implementation of two major HR projects while working in the Business Process Solutions team; assisted in Project Management activities and also developed use cases. • Ensured timely rollout of a travel management project in 5 different countries in Americas and EMEA regions; involved in process improvement efforts; conducted user workshops facilitating effective handover. • Led business testing (as a Test Coordinator) for various projects using Solution Manager. • Enabled the implementation of two major HR projects while working in the Business Process Solutions team; assisted in Project Management activities and also developed use cases.

Business Analyst Intern

• Jan 2009 - Jun 2009

• Created business process diagrams to their “as-is” business process and performed gap analysis to compare the existing system with the proposed system and documented new requirements and features to meet growing business needs • Enabled their IT organization to continue using open source software by suggesting techniques like data partitioning that addressed growing data concerns and also resulted in cost savings • Created business process diagrams to their “as-is” business process and performed gap analysis to compare the existing system with the proposed system and documented new requirements and features to meet growing business needs • Enabled their IT organization to continue using open source software by suggesting techniques like data partitioning that addressed growing data concerns and also resulted in cost savings

Teaching Assistant

• Sep 2008 - Dec 2008

• Managed and tutored undergraduate lab sessions that were set up to enhance students’ MS Excel and MS Access skills. Assisted professors regularly with grading and blackboard setup. • Managed and tutored undergraduate lab sessions that were set up to enhance students’ MS Excel and MS Access skills. Assisted professors regularly with grading and blackboard setup.

Associate - Projects

• Nov 2005 - Aug 2008

• Automated regression test cases of the claims system which resulted in an efficiency gain of 80hrs/month Reduced coding and testing effort involved in ad-hoc/new project work items by almost 60%, by introducing IBM utilities like ICETOOL and ICEMAN to the team • Analyzed, designed and implemented two critical projects that dealt with claims payment processing without any production defects; actively engaged in all stages of the SDLC process • Trouble-shot and provided resolution for several critical defects that were unresolved for almost 2 years, thereby reducing effort spent on ad-hoc data fixes • Facilitated Senior Management to track multiple projects simultaneously by automating weekly and monthly metrics using VBA and MS Excel Show less