Jan 2019 – Nov 2019 · 10 mos · San Francisco

• Data migration from Appian KYC Application to KYC DireKT in restful client server app data is exchanged in JSON format.
• Designed hybrid database with flat and key value tables for dynamic addition of questions, high availabity and scalabitly.
• Created mapping documents for ETL team to load data from Appian KYC Application to KYC DireKT database
• Work with Data warehouse team to load historical KYC data for Eagle Eye Vision fraud analytics
• Created data cleanup scripts and implemented in SQL SSIS to extract and clean data and load to SQL server
• Integration with MDM to get golden record for KYC
• Create private and public consumption layers to provide desired data for downstream applications
• Designed data feed from HR, AD, Consumer Risk Rating and NACIS information
• Designed document migration from Appian to OnBase and integrate KYC –DireKT application
• Design documents mapping for Document Import process and work with OnBase team to design workflow and Keyword search for documents.

Jul 2018 – Jan 2019 · 6 mos · Foster City

• Worked with cards product team on Co-Brand dashboard
• Created data pipeline to extract PayPal performace dashboard
• Worked with Tableau and MicroStrategy team to create reports and visualization using HIVE and Impala
• Created HIVE tables as per requirements (internal/external tables) with static and dynamic partitions
• Developed Python programs for data cleansing , parcing and formatting unstractured and Spark jobs.
• Worked with Oozie to automate jobs for Scoop, Hive, Spark and JAVA jobs
• Optimize Hive queries to ensure faster results.
• Design ETL process to extract raw data from multiple sources and create certified L1 and L2 datasets
• Certified datasets for CMS(Chase Bank)
• Data validation of L1 &L2 datasets with business and generate validation reports
• Perform code reviews, guidelines and data validation ensuring data integrity.

Jun 2017 – Jun 2018 · 1 yr · San Francisco Bay Area

• Migration of First Republic Private Wealth Management documents for offices across United States. Worked with PWM project management team to gather information and created new Datamart. Design ETL process to extract raw data from multiple sources. Design tables and created mapping documents for ETL team to load extracted documents metadata information. Work with Data Hubs teams and to load structured and non structured data with different file formats like word, PDF,Excel, CSV,Jason and Avro files that are in different locations, SharePoint and shared drives. Worked with FRB Data Management team to integrate 30+ account types and IPS information from Eagle-vision Data Hub.
• Created data pipeline in Python to extract and clean data and load to SQL server. Design documents mapping for Document Import process and work with OnBase team (Hyland Document Management System) to design workflow and Keyword search for documents. Moderate with Business analysts to create mock screens for UI for wealth managers.Worked with Business Analysts and project managers in identifying and defining requirement. Designed solution to assessed Blue Prism capabilities to identify and classify 100+ document types. Provide expertise in staging and deploying the Blue Prism automation solution into test and live environments. Facilitate meetings to demonstrate the capabilities of RPA for on-going projects and potential clients. Created MIS reporting of Blue Prism from different sources in MS SQL SSIS reporting tools.

Jun 2012 – Jun 2017 · 5 yrs

• Building Data Warehouse and Business Intelligence and Reporting group within State Fund. Developed data marts transferring data from various transactional Business systems like Claims, Legal, Billing and Finance. Hands-on experience in handling large data warehouse systems architecture, implementing Enterprise Data Warehouse which involves Dimension Modeling, Data Integration (ETL) and using Tableau, Micro Strategy and SAS.
• Worked Anti-fraud workbench application using Big Data Hadoop HDFS, Map-Reduce, Sqoop, Hive, Oozie, Cassandra, Zoo Keeper, MongoDB, Spark, SparkSQL, Spark Streaming, Kafka, Flume, HBase, Weka, DynamoDB. Experience in Scala and Spark SQL, Spark Streaming, Spark Core, RDD transformations, Data Frames and actions for faster analyzing and processing of data.
• Subject matter expert on workers’ compensation, subrogation, USLH and performs a variety of duties including, but not limited to: workers’ compensation ,subrogation analysis; developing recovery strategies; and assisting claims staff and others will all aspects of subrogation.
• Responsible for functional facets of Legal Technology system development life cycle including: business cases,process definition and reengineering, high and detailed-level requirements gathering, vendor selection, fit/gap analysis, functional design, testing, training, reporting, support, and continuous improvement of business applications. Execute a range of initiatives that build the foundation of the Legal team’s processes and technology capabilities targeted at creating efficiencies across the Legal Departments. Participate in recommending ways to improve business processes through system development and controls. Knowledge in eBilling, Matter Management, Contracts Management. Excellent analytical skills and comfort with multiple data sets, with the ability to draw conclusions and make informed recommendations.

Dec 2010 – Jun 2012 · 1 yr 6 mos

• Successfully migrated SAL application to TeamConnect application. Migrated millions of claims and legal related documents from Hummingbird PCDocs to EMC Documentum. Created TeamConnect Data warehouse using Pentaho. Integrated Business Object reporting. Migrated TeamConnect SIU instance to InSight application and integrated YellowFin as reporting tool. Developed management reports and fraud detection support. Support e-discovery projects by providing surgical data of claim, payments and bill to attorneys and chief counsels for legal cases. Experience in Attivio, Apache Solr(Query) and Lucene (Index) Search technologies,
• Provided data feeds to Kaiser Permanente, Anthem and Bluecross. Integated Pharmacy billing . Developed EDI between CWCI and WCRIB organzations,

Sep 2010 – Nov 2010 · 2 mos · Saudi Arabia

• Provided consulting services to Riyadh Bank on fine tuning ETL process using Informatica and optimized Business Object reports to run 10X faster by creating materialized views.

Feb 2004 – Aug 2010 · 6 yrs 6 mos · San Francisco Bay Area

• Coordinate with project management on assigned projects adhering to our Project Lifecycle Methods (including Governance, Project Management, Release Management /SDLC methods) - delivering on-time, within budget. Contribute to the provision of a robust, reliable and effective BI and enterprise DW platform. .Hands-on working with architects and researching new technology and develops business cases to support enterprise-wide business intelligence solutions. Partners closely with business partners, systems analysts, development, and architecture teams to facilitate issue resolution, develop solution designs and deliver valuable business solutions .Promoting best practice adoption of SAP BI functionality and skills development to maximize its use. Articulate and validate the technical and functional requirements to meet architectural guidelines and business requirements. Develop and document data and reporting requirements for the development of new or enhanced approved systems. Consult with and advise business partners for improvements based upon enhancements or new applications. Develop functional documentation and deliver training materials. Provide project and program leadership for EDW initiatives so that these meet or improve on project timelines, cost estimates and service levels. Work with enterprise-wide business and IT senior management to understand customer issues and their environment in order to manage enterprise data warehouse solution. Solves complex technical problems and guides team on how to implement corresponding changes. Create appropriate and acceptable testing methodology as per business needs.

Jan 2000 – Jan 2004 · 4 yrs · Greater Toronto Area, Canada

• As Data Warehouse Architect collaborate with a Business Analyst to define the data requirements and recommend a data structure. Responsible in leading and managing projects pertaining to the design, development, and implementation of enterprise data warehouses tool for Business Intelligence (BI) applications that will support the reporting requirements. Designing, developing and optimizing data warehouses, with flexible and scalable data and ETL architecture, to support business users and Business Intelligence (BI) applications. Analyzing business intelligence data and makes recommendations for data warehouse growth and integration an application/business function.
• Exellent knowledge forETL tools such as Informatica, DataStage, Oracle Warehouse Builder (OWB), SAP Data Services, Data Migrator (IBI), Oracle Data Integrator (ODI) etc.Extensive experience with SQL and SQL scripting for relational databases such as Oracle, Microsoft SQL Server, IBM DB2, MySQL. Ability to communicate design solutions to both technical and non-technical audiences.Strong analytical and documentation skills. Different development methodologies including SDLC, Scrum, and/or Agile, and test-driven development. Ability to mentor others and provide technical direction on data architecture, reporting, warehousing and OLAP design. Excellent shell scripting on Unix and Linux.

Aug 1998 – Dec 2000 · 2 yrs 4 mos · Toronto, Ontario, Canada