Krupesh Patel Email & Phone Number

Atlanta Metropolitan Area

Atlanta Metropolitan Area

Atlanta Metropolitan Area

Greater Atlanta Area

Greater Atlanta Area

- Customized Qlik sense reports to manipulate large dataset for the purpose of creating business intelligence. Constructed user stories in facilitating the development of new applications and reports in Qlik Sense.- Created queries in Aginity workbench (Netezza), Notepad ++, and Access using SQL utilizing joins, grouping, and where clauses to pull data from our data warehouse.- Wrote custom SQL scripts in Excel PowerPivot to work with millions of rows of data beyond the Excel row limit for the purposes of analyzing and mining data.- Created forecast reports to determine cost savings from the implementation of new pricing models to help negotiate contracted rate with our clients.- Created cost overrides reports to identify areas to reduce high cost trips and find lower cost alternatives.

-Ran queries from an enterprise data warehouse to extract data essential for data analysis -Generated business intelligence by utilizing raw data drawn from an EDW and applying various excel functions including vlookups and pivot tables to aggregate data from multiple workbooks. -Created custom macros in Excel using VBA to help facilitate in the grooming, formatting, and analysis of data. -Created ad hoc reports to determine which client’s ATM units required action by analyzing data for billing and service issues that arouse.

-Helped created a strategy on a new project to process unformatted text files containing Air Check Wi-Fi data into a database format-Executed programming code to clean data into a readable format for entry into the SAS database-Wrote SQL code to merge imported Excel data and SAS tables in SAS for Quality Assurance and analysis. -Created an extensive process flow in SAS in order to scrub erroneous data and ensure data integrity-Instrumental in devising a strategy to implement data quality assurance and data quality control for client’s data- Documented the process of our project in great detail to provide a guideline on how best to process and analyze data in the future.

Greater Atlanta Area

-Categorized items from various bank statements and created financial transactions in QuickBooks-Reconciled and maintained bank accounts-Created profit and loss statements to assess the financial performance of the business-Tracked and handled the flow of money into and out of the business

Greater Atlanta Area

-Responsible in filtering and data scrubbing client’s IDs and permissions for over 20,000 + records -Performed data integrity checks to ensure accuracy and consistency of data -Wrote and executed Excel VBA coding to create and format workbooks for our client -Generated data analysis reports -Instrumental in the transition and organization of customer’s records into customer relationship management software

-Leading provider of solutions that enable successful "cash banking" relationships for more than 70 million underbanked consumers in America serving 36 states.; -Manage and verify checks processing by following risk management methodology to enable mobile deposit capture to provide instant funds to consumers.-Exceeded monthly performance goals on a consistent basis; promoted from base level to highest level with increased approval authority. -Identify checks from various institution, highlight fraudulent checks in Chexar system to prevent future check fraud. -Analyze weekly performance metrics in check verification system to improve overall verification process.-Liaison between banks, check originators, and consumers to ensure accuracy of information regarding each transaction.