SUMMARY

• He has an expert level knowledge in Database migration / Informatica Data Integration, Informatica Data Quality, Informatica iPaaS suite, MDM and Big Data Products. Other areas of expertise include, but are not limited to the following:
• Knowledgeable in a wide variety of technologies including ETL (Informatica), Database design and administration (Oracle, Sybase and SQL Server), UNIX, Mainframe, Operations Automation and Reporting tools.
• Expertise in Managing Oracle Appliances (Exadata).
• Expertise in Installing, Configuring and Administration of Informatica & Cloudera Hadoop products. (both cloud and on premise offerings)
• Design and development in Relational Databases (Oracle 12.11g, 10g, 9i/8i, SQL Server 7.0, SQL, and PL/SQL).
• Expert in the entire Data Science process life cycle including Data Architecture, Data Acquisition, Data Preparation, Data Manipulation, Feature Engineering, Machine Learning Algorithms, Validation and Visualization.
• Expert in Data Migration strategies (Cloud and On - Premise).
• Expert in Microsoft Power BI.
• Expert level knowledge in Guidewire Products Claim Center, Policy Center and Billing Center.
• Well versed in Fiserv Financial Service products including Risk control and AML products.
• Experience with database querying languages (SQL), programming languages for reproducible data analysis (Python, R), Electronic Medical Records (Epic Systems), Research database systems.
• Knowledgeable in project management frameworks (Lean, A3 Thinking, Agile, Six Sigma, Waterfall).

TECHNICAL SKILLS

Operating Systems: UNIX (Solaris, AIX, HPUX), Windows platforms, Linux, iOS, Android

Software: Oracle 7-12g RAC, Exadata Appliance, Informatica Power Center 10 and below, Informatica B2B and MDM, Metadata Manager, Informatica Cloud and Big Data Editions (IICS, ICRT, iPAAS suite), Informatica Data Quality and Governance including AXON, Power BI, Tableau, Altryx, Qlikview, Erwin, SAS, SSIS, UNIX Shell Programming, Hyperion Essbase, BO XI, Hadoop Big Data Platform (Cloudera), Salesforce, Peoplesoft, Workday, Version One. Guidewire Claim Center 8.0.3, Policy Center and Billing Center 8.0.3

Databases: Oracle Exadata Appliances and Oracle Relational Databases Including RAC (12c and lower), SQL Server, Sybase Adaptive Server, Netezza, Mongo DB, Teradata

Hardware: IBM P-series Class, HP Superdome, SUN Microsystems Enterprise Servers, EMC Clarion, Oracle Exadata Platform.

Methodology: PMI, Dimensional Modeling, Structured Analysis and Design, Object Oriented Analysis and Design (OOA and OOD), Waterfall and Agile SLDC

Utilities: FTP, TOAD, SQL Navigator, Win SQL Developer, Github, SVM

Languages: SQL, PL/SQL, Visual basic, Visual C++, C++, C, Java,Python, HTML, R

Cloud: Hadoop Big Data Platform (Cloudera) (including but not limited to Hive, Hbase, Pig, Apache, Spark) and No SQL technologies (including Mongo DB, Cassandra) and Cloud platforms (Amazon AWS, Microsoft Azure)

PROFESSIONAL EXPERIENCE

Confidential

Consultant Data/Technical End to End Architect

Responsibilities:

• Responsible for End to End implementation of functional implementation of two android/iOS applications. (Kapanetics)
• Application involved NFC authentication with implementation of automated financial transactions.
• Integration of android/iOS applications with external Banking applications. (Kapanetics)
• Manage Branding and messaging of the applications to customers (External investors/Internal Banking applications). (Kapanetics)
• Evaluate and make recommendations for Enterprise Roadmap Centralized architecture of Genuine Auto Parts. (POS architecture)

Confidential

Consultant Data/Technical Architect

Responsibilities:

• Responsible for End to End architecture of Fundraising area for Confidential .
• Architect and Implement Migration of several fundraising interfaces and data from one vendor to another.
• Architect and Implement the new next generation fundraising Gift Management System.
• Responsible for the architecture and implementation architecture roadmap of move from SAP BO to Microsoft Power BI.
• Responsible for the architecture and implementation of move from On-premise Informatica Power Center to Informatica Cloud versions (iPaaS, IICS, ICRT) including Data Quality and Governance Suite.
• Evaluated Reporting Solutions for recommendations to be implemented.
• Evaluated and Recommended different cloud platforms for the Fundraising Gift Management System.
• Migration of traditional servers including data to Microsoft Azure servers.

Confidential

Consultant Architect/Delivery Lead

Responsibilities:

• Responsible for End to End Delivery of several IMCC projects assigned to me.
• Responsible for establishing standards related to Informatica, Oracle and Unix for IMCC projects.
• Architect and Implement the Components for Claim Daily, Surety BI Integration, Long Term Care applications with the Enterprise Warehouse.
• Consolidate several databases and applications as part of the CNA’s long-term strategy.
• Upgraded the enterprise warehouse to Exadata Oracle 12g and Informatica Power Center 9.6 and Linux platforms.
• Consolidated the Billing and the Policy ODS databases and application into the Merlin Databases as part of the consolidation strategy.
• Involved in evaluating and recommended Cloud /Big Data Solutions for implementation.
• Played the role of Scrum Master/BA for the Reporting track of Guidewire implementation of Claim Financials and Policy Center Integration.
• Apply data mining techniques, conduct statistical analysis and build high quality prediction models including Predictive DataMart to solve challenging business problems.