Keval Parekh Email & Phone Number

Mumbai, Mh, In

Mumbai, Mh, In

Mumbai, Mh, In

Mumbai, Mh, In

Mumbai, Mh, In

Electronic Blue Sheet (EBS) is strategic solution for regulatory reporting for Citi’s CGMI broker-dealer to disseminate trade data based on "Blue Sheet Request” that is generated by regulators, specificallya) Financial Industry Regulatory Authority, Inc. (FINRA)b) Securities and Exchange Commission (SEC)c) other Self-Regulatory Organizations (“SRO’s”) Trades reported as part of EBS requests include the security details, firm account details, trade details (price quantity etc.) clearing details and the parties involved.

San Diego, California, Us

Ab Initio ETL and Teradata Technical Sr. Consultant.• Understand customer requirements, business problems and objectives and develop sales -oriented solutions while responding to RFP/RFQ.• Provide solution and guidance during the solution development process to ensure customer requirements are met in cost effective and timely manner. • Interacted with Business clients regularly to analyze their requirements and propose IT solutions to them.•Consulted and worked on Proof of concept for a major American banking Client and Middle East telecom Client.

Dublin 2, Ie

Client : Travelers Insurance, USARESPONSIBILITIES:• Implemented Hive queries to Analyze data.• Good understanding and knowledge of Hadoop architecture and various components such as HDFS, Job Tracker, Task Tracker, Resource Manager, Application Master, Name Node, Data Node and working of Map & Reduce, Parallel & Distributed Computing.• Spearheading efforts across creating Ab Initio graphs, psets and plans that transfer data from various sources like Teradata, flat files and CSV files to the Teradata database and flat files. Worked on Multi file systems with extensive parallel processing.• Skillfully implementing lookups instead of joins, in-memory sorts to minimize the execution times while dealt with huge volumes of data. Extensively used Partitioning Components like Broad Cast, partition by key, partition by Range, partition by round robin and De-partition components like Concatenate, Gather and Merge in Ab Initio.• Accountable for implementing Transform Components such as Aggregate, Dedup Sorted, Filter by Expression, Join, Normalize, Reformat, Rollup and Scan Components and created appropriate XFRs and DMLs. Used Lookup Transformation in validating the warehouse customer data.• Proficiently creating mapping document and ETL design document.• Involved in all the four phases namely planning, analysis, design and implementation. Experienced in testing, documentation and requirements gathering. Excellent understanding of the System Development Life Cycle. Clear and through understanding of business process and workflow.

Dublin 2, Ie

Client : Travelers Insurance, USAResponsibilities:• Worked with business to understand business requirements and prepared technical metadata for multiple enhancements and change controls• Built, executed and presented data for MI2 UAT cases to business.• Worked with multiple source vendors to streamline data and eliminate irregularities.• Created resuable code framework with use of metaprogramming language.• Designed and preformance tuned ETL & SQL code for handling historical data of 4 years.• Assisted in complete design, build & implement solutions which included integration of 7 source systems.• Developed Connect direct unix scripts and Connect Direct psets to transfer data between Unix, windows, SAS servers and Gateway nodes.• Developed and worked with Generic Graphs and plans.• Worked on Lineage implementation for the entire project.

Dublin 2, Ie

- Worked extensively in development environment in Financial Services domain for Allstate insurance (Auto and Property Insurance)- Implemented SQL queries to fetch customer data & analyze it to observe the effect of critical factors like discounts & surcharges, coverage, violations and accidents leading to premium impact on customer.

Bachelor Of Engineering (B.E.), Electronic And Telecommunication Engineering

Diploma, Electronics And Telecommunications Engineering