SUMMARY

• Over 12 years of Hands - on experience in Solution architecting, Application Design and analysis and development.
• Strong knowledge in TOGAF architecture framework, TOGAF 9 Certified.
• Around 8 + Years of experience in Warehouse design and development, utilizing Ab Initio 3.0+, Ab Initio EME 3.0 and EMMS, Conduct - IT, SAS DI Studio, SAS Management console, SAS Information Maps, Base SAS, SSIS, Teradata, Unix, Autosys Job scheduler, Lotus Notes.
• Designed, Developed major warehouses and data mart layers as a lead designer and developer, which involved processing tera bytes of data.
• Experience in working on building strategic warehouse using Agile Methodologies.
• Designed and implemented ETL batch solutions on the database as well as file level processing side, for both warehouse layer and DataMart layer.
• Experience in Performance tuning of DataMart layer model and complex SQL’s and graphs.
• Extensive knowledge over building architecture for ETL process in Ab Initio with sources varying from COBOL files, flat files, excel files, xml, web services and databases like (Teradata, Oracle, SQL server).
• Exposure on reverse engineering legacy application and moving from one warehouse to the other.
• Proficient in eliciting requirements and assisting the ETL/ Quality assurance team for business intelligence / data warehousing environments including technologies and processes across data sourcing, validation, reconciliation, and reporting.
• 7+ Years of client facing experience working with IT/business architects and preparing various documentations like Business Requirement Document (BRD), Functional Requirement Document (FRD) / System Requirement Specification(SRS), Source to Target Mapping Document (STTM), Requirement Traceability Matrix(RTM) and  other client specific documents.
• Have successfully managed onsite/offshore delivery models. Developed methodologies to ensure quality and consistency in delivery.
• Leadership & Management Skills: Focused on integrating business customers, business process and technology to deliver business value and successfully managed onsite/offshore delivery models
• Having 7+ years working directly with clients at different client locations in UK, US, India.
• Have developed POC on Hadoop and BI reporting.

TECHNICAL SKILLS

Databases: Teradata 13.0 & 14.0, Oracle 11g, MS Access, SQL Server

ETL Tools: Abinitio 3.0(GDE, EMMS), SAS (9.2, 9.3), Knowledge on Informatica & Talend

Reporting: Qlikview, SAS Web Report Studio, Business Objects

Query and Programming: SQL, UNIX Shell scripting

Domain: Health Care, Property and Causality insurance

Scheduling tool: Business modelingMicrosoft Visio

Methodologies: Waterfall, Agile, Iterative

WORK EXPERIENCE

Confidential, Hartford, CT

Data Architect

Responsibilities

• Lead Design and development team for RPC project, building Renewal price change DataMart.
• Identified reporting needs, created specification, and worked closely with report development team to achieve the reporting goal.
• Lead design and development of Production job dashboard in Abinitio/Qlikview to analyze Abinitio job performance, server utilization, Autosys job flow tracking and IO with data from EME, Abinitio Console Center, Abinitio logs, and Autosys.
• Developed generic graph, plans for frequently used features like, CDC, email, unload and load data to databases and DBC files and shared business process.
• Implemented shared file level process technique across applications optimizing the database server load.
• Implemented Shared dimension concept on shared key tables to develop better data extraction and load by multiple application.
• Supported and prepared the team for Abinitio and Teradata upgrades by prepping and planning the upgrade validation process.
• Working on Hadoop POC for data discovery, organize and cataloging of HDFS data.

Data Architect

Responsibilities

• Worked closely with the system architect, business partners, and end users to validate and locate source data, develop the data flow diagram, conceptual data model and develop Abinitio jobs for Actuarial Analytics in Premium Loss segment.
• Designed multiple small datamarts following the star Schema and shared dimension modeling and
• Lead Data integration team of Abinitio and Teardata developers and delivered multiple projects to Production using Agile methodology.
• Implemented a variation of SCD2 to cater to extract historical and future data based on load time and active/expire/projected premium rates.
• Performed complex Teradata query tuning by implementing index, Statistics, joins, analyzing Skewness, and tracking using Teradata view point.
• Developed Unix scripts to support ETL process. And used all the Abinitio tool and concepts in the development process.
• Performed performance tuning of Abinitio code by optimizing the depth of partition, increasing parallelism, component selection validation, resource pool management and max-core memory management.
• Used Abinitio BRE to define business rules and support the ratemaking process.
• Analyzed and developed Projected Infrastructure requirements closely working with the infrastructure and Abinitio support teams.

Development Lead

Responsibilities

• Converted legacy BTEQ scripts based Abinitio monthly data ware house load to Abinitio only code for Daily data processing
• Migrated 40 year of history data from the legacy system to support daily data loads using optimized data model
• Extracted data from Mainframe using connect direct process, Teradata through Fast export and load data back to Teradata using FastLoad and Multiload.
• Responsible for cleansing the data from source systems using Ab Initio components such as Join, Dedup Sorted, Denormalize, Normalize, Reformat, Filter-by-Expression, Rollup.
• Metadata mapping from legacy source system to target database fields and involved in creating Ab Initio DMLs and written complex XFRs for implementing the business logic transformation.
• Extensively Used Transform Components Aggregator, Match sorted ,Join, sort, Reformat, Rollup and Scan Components
• Used Partition Components like Partition-by-key, Partition-by-expression and Partition-by-Round Robin to increase data parallelism.
• Performed performance tuning of Abinitio code by optimizing the depth of partition, increasing parallelism, component selection validation, resource pool management and max-core memory management.
• Created Auto Sys job stream to schedule jobs by creating box jobs and jil templates.
• Participate in / Conduct functional, design and code reviews.

Development Lead

Project: E-visor

Responsibilities

• Designed and developed process to automate Clinical validation rules in SAS
• Transformed the capability from 1 rule per month to 100+ rules per month.

Development Lead

Responsibilities

• Lead the process in setting up first offshore team for Lastminute mid office applications
• Transitioned from monolithic quarterly releases process to incremental agile by weekly release.

Development Lead

Responsibilities

• Involved in developing break fix for a critical issue using SAS DI Studio.
• Was involved in developing and debugging reports in SAS Web Report Studio.
• Create flows in SAS Management console and execute
• Design and Implemented major Data Reload to the SABRE database.