SUMMARY

• Enterprise Solution Architect with over 15 years' experience in Information Technology industry with domain expertise in Insurance, Pharmaceutical, Telecommunications, Manufacturing and Retail. Also includes Technology skills in Big Data, Hadoop, Data warehousing and Business Intelligence practice.
• Has had international experience in working as part of teh Business Intelligence, Big Data and Data warehousing technologies for major transformation projects.

TECHNICAL SKILLS

• Oracle, Greenplum
• Netezza, DB2.
• Hadoop/Big Data
• Hive, HDFS, Spark, Pig, Sqoop, Python.
• Informatica Power Center, Data Stage, Attunity.
• Business Objects, Tableau Analytics
• Denodo, SAS
• Enterprise Architect, ER Studio, MS Visio
• Clear Case
• Guidewire Policy Admin system
• Insurance Agency Strategy Operations
• P&C, Life, Brokerage Insurance Policy Quote, Underwriting and Policy systems.
• P&C Insurance Campaign System.
• P&C Insurance agent compensation system.
• Physician Data restriction program for Pharma.
• Incentive Compensation Goals and Crediting for Pharma.
• Chargebacks and Rebates for Pharma.
• Demographics and Territory for Prescribers alignment.
• Informatica Administrator
• ITIL

PROFESSIONAL EXPERIENCE

Confidential

Solution/Data Architect

Responsibilities:

• Planning and executing a variety of methodologies as part of teh concept stage in teh overall project development of information/business analytics architecture.
• Planning and executing Information and Business Analytics architecture at teh conceptual, logical and physical levels applying teh concepts of Master data management for reference data, data virtualization using Denodo and data replications using Attunity.
• Evaluate various emerging Bigdata (Hortonworks) and Cloud technologies (AWS, Azure) for teh BI / Analytical solutions. Architected Cloud & Hybrid BI solutions using Amazon Web Service (AWS) platform for deployment.
• Evaluating various emerging tools like Hadoop (Horton works), Microsoft Azure and AWS cloud based tools and documenting candidate architectures with SWOT analysis.
• Creating conceptual, Logical and Physical data models and prototypes.
• Architect solutions using Data lake ELT strategies to support business driven customer life value models.
• Architect data ingestion and transformation from multiple data sources in Hadoop using Sqoop, SPARK, HDFS, Hive, Pig scripting.
• Architect solutions using Lambda architecture and framework in Hadoop.
• Design and define Data ingestion patterns with Aurora and Informatica Cloud in AWS EC2.
• Performing POC for BI Financial reporting using Microsoft Azure platform and tools.
• Define architecture guidelines and standards on Data ingestion and Security (PII).
• Delivered real time replication solutions using tools like Attunity.
• Reverse engineered application specific name - value pair database into a query friendly normalized data model to support reporting in Hadoop.
• Engineered implementation of Denodo for Data virtualization by collecting data from disparate sources to support analytics.
• Engineered implementation of Informatica Master Data management (MDM) for Reference data.

Confidential

Solution/Data Architect/Delivery Manager.

Responsibilities:

• Perform teh role of Business Intelligence Architect in designing and implementing solutions pertaining to various BI reporting and analytics requirements.
• Perform teh role of an architect by laying out strategic architecture roadmaps by taking into account of emerging tools and technologies.
• Managed, design and enhanced ODS, enterprise-wide data warehouse, data marts & Data modeling for reporting (Business Objects) and analytical solutions.
• Designed and developed several data warehouse processes and data models (Logical and Physical) along with guiding other teams that includes development, Testing, Metadata management, Security and governance and reporting.
• Demonstrated strong noledge of cross-functional business processes including; marketing, sales, service, finance, supply chain and manufacturing.
• Developed and managed working relationships with different stakeholders at teh client site and within teh organization .
• Accomplished teh strategic execution of projects to ensure teh processes align to teh customer's plans and technology road maps architecting OLAP data model schemas for cube development allowing analytical reports to render at maximum performance.
• Engineered BI solutions by deploying scorecard reports for provider productivity, care costs, and payment reimbursement imbalances through clinical claims integration by collecting data from disparate sources to giving physician providers' 15-20% increase in negotiations with private insurance companies.
• Developed SOX compliance procedures for data cleanup, removal and encrypting as well as comprehensive data security and privacy protocols.
• Involved in all teh phases of Data Warehouse development including prototyping, data modeling, analysis, design, development, testing and documentation.
• Created ER Diagram for databases and demonstrated business process modeling and requirements definition into it.
• Accomplished Oracle Exadata implementation upgrade.
• Engaged in technical presales, proposal, client presentations, solution architecture definitions & program estimations

Confidential

Application Lead

Responsibilities:

• Perform System analysis and define teh user requirement / software requirement specifications (SRS). Reverse engineering & analysis of existing applications for teh application enhancement.
• Developed and managed working relationships with different stakeholders at teh client site and within teh organization .
• Developed a strong understanding of teh operational systems' underlying data relationships, and translated business data requirements and business rules into preliminary data screening and profiling requirements.
• Managed teh onsite team for multiple programs / deliveries with teh help of geographically dispersed teams across India and UK.
• Define technology architecture for application considering teh optimal design principals and technology constraints.
• Engaged in technical presales, proposal, client presentations, solution architecture definitions & program estimations.
• Design and document High-level design (HLD), detail design (LLD) & Data models (E-R/ Dimensional) for teh solutions.