SUMMARY:

• Information management architect having 16 years experience in implementing solutions for BI/DW applications.
• Expert in Enterprise data warehouse solution Architecture, ETL architecture /design, Data Architecture Presentation Layer architecture /Design, Master Data Hub, Data Integration solution
• Expert in Recommending data warehouse solutions and assist with the selection of overall architecture.
• Expert in Data Modeling ( Dimensional / 3NF ) and Architecture xperienced in leading Enterprise data warehouse design .
• Hands on data modeling experience with design tool ERWIN etc.
• Expert PL/SQL, Shell scripting, UNIX/Linux, Oracle,Teradata, MySQL, SQL Server experience.
• Hands on experience in ETL tools like Informatica, DataStage, DTS
• Hands on Data Cleansing and Standardization experience using Quality Stage & regex
• Hands on experience in Data Profiling Tools like Information Analyzer & IDE
• Exposure to BI visualization tools such as BO, Tableau, OBIEE,Cognos
• MapReduce jobs in Java, Pig and Python for sentiment analysis
• Experience in using Big Data ecosystem components like HadoopMapReduce, HDFS, Hbase, Hive, Sqoop, Pig, Flume, Avro, and Horton Works Talend.
• Experienced in preparation of project artifacts, standards, Solution architecture documents, High Level Design documents presentation and review of such documents
• Experienced in developing mulch - year solution roadmap and communicate and secure approval from management
• Experience in ensuring data solutions fulfill business objectives, adhere to established practices, and align with enterprise strategy while addressing architectural concerns, such as performance, scalability, data quality and privacy.
• Experienced in evaluating various design options and trade-offs then build consensus on the most practical solution.
• Experienced in Handling internal teams and external data providers for the evaluation of data sources, and help define the requirements for interface, data movement and integration.
• Experienced in developing work estimates with Project Manager for the end to end data warehouse implementation
• Experienced in ensuring that data strategy, standards, security and governance processes are implemented, interact with these teams for providing input for helping shape the evolving standards and processes
• Experienced in Collaborating with Business, IT, PMO, Vendors and other stakeholders. Abiltity Clearly articulate complex data concepts to Business and Technical audience.
• Experienced in governance of metadata, data security per industry standards eg HIPAA
• Mentoring, and supervising junior team members as applicable.
• Experienced in DMBoK Key Process Areas
• Experienced in Agile Methodologies like Scrum, Waterfall Model of SDLC
• Experienced in Onsite - Offshore Project execution model
• Experienced in Handling Teams of size upto 15

TECHNOLOGY SKILLS:

Database Technology: Teradata, Oracle 10g RAC cluster, SQL Server, DB2, Redbrick,Mysql

Big Data Skills: Trained in Hadoop, PIG Latin, Python, Map Reduce, Tableau, Knowledge of NoSQL Data Structures, and Used AWS for processing MR tasks.

ETL Tools: Datastage 8.x/7.5.1, Informatica Powercenter 8, MS SQL Server DTS, Oracle Warehouse Builder, Quality Stage V8, Pentaho

Reporting Tools: Business Objects XI, OBIEE, ProClarity, Oracle Sales Analyzer, Microsoft Analysis Services, Tableau, BIRT, MDX

Languages: PL/SQL, Shell Scripting, Perl, SQL,Python

Modeling Tool: Erwin, TOAD

Others: MS Office, MS Visio, MS Project, Eclipse IDE, Subversion, SOAP, REST

PROFESSIONAL EXPERIENCE:

Solution Architect

Confidential

Responsibilities:

• Designing Solution Architecture for Business Intelligence project based on SAP OER being introduced for e-pedigree serialization compliance requirement.
• Data Modeling of ODS for use in Business Activity monitoring
• Designing of solution architecture for acquiring data from EPCIS repository into the ODS
• Defining Analytics ( KPI ) for Supply Chain and Serialization get and go functions

Environment: Oracle 11g, Erwin, Informatica 9, TIBCO, SAP OER, XML

BI Architect

Confidential

Responsibilities:

• Data Modeling, data conversion, and testing
• Develop ETL Jobs
• Develop ERP Reports, BI Reports, and Dashboards to meet business requirements
• Database backup and restore

Environment: MySql, BIRT, Pentaho, Subversion, MDX

Senior Data Architect

Confidential

Responsibilities:

• Senior data architect in the EDW area, responsible for defining the logical model, deploying the physical data model for Customer Loyalty, Web analytics, advertising subject areas.
• Participate in requirements session along with the business analyst to understand information and analytics requirement from the business
• Maintain and construct logical and physical data model in Teradata, present solution to business users and DBA group.
• Prepare data volume estimations and deploy database tables in development/test/ production environments with optimization of the physical design.
• Implement data governance policies required for Enterprise and supporting HIPAA regulations.
• Maintain data model metadata and compare databases using the Erwin tool to enable version control of the integrated EDW data model which was worked upon by several data architects.
• Prepared and implemented leading practices for creating enterprise data model
• Advise on integration aspects of new subject areas with the existing subject areas in the EDW
• Design of Integrated data layer on top of existing EDW

Environment: Teradata 12 & 13, Erwin 7.3, Datastage 8.5

Architect

Confidential

Responsibilities:

• Worked for the department of Bank Resolution and Receivership and participated in bank pre closing and closings.
• Performed download of deposit data and transformation and migration of the data to the Claims Administration system for Insurance determinations
• Used IBM infosphere to automate Account Ownership determination in deposits Data . Perfomed Data Quality Checks by ensuring trial balances match deposits data and the GL for specific product categories.
• Generated reports for Franchise Marketing, Claims and Proforma department to enable receivership & resolution processing of the financial institution by FDIC.
• Currently involved in re-engineering the system to have a single central repository and a reporting layer using Business Object & have automation of data processing.

Environment: Datastage 8.5 & Quality Stage

Architect

Confidential

Responsibilities:

• Definition of Requirements, Functional Specs and strategy for migration of Roche HCO and HCP data into the Confidential MDM environment.
• Development, design of mapping.
• Managing work stream for Virology and Specialty master data migration to the Confidential environment.

Environment: Oracle Exadata, Informatica

ETL Architect

Confidential

Responsibilities:

• Responsible for providing the design of Incremental ETL for trade promotion management project in Oracle BI analytics package
• Development, design of mapping.
• Led development team in client meetings for KT sessions.

Environment: OBIEE, Informatica, Oracle 10g, DAC

Data Warehouse Architect

Confidential

Responsibilities:

• Responsible for providing the design for E-commerce EDW and the Specialty Client reporting Data Mart
• Delivered the Logical and Physical Data Model
• Implemented Data Security views to comply with HIPAA regulations for PII information
• Delivered ETL architecture and design
• Provided Solution for Product Data Integration in Confidential EDW
• Provided Roadmap & Solution for Building the presentation layer on the EDW.
• Provided oversight to development activities for implementation of the project
• Advised on Development/Test/Production infrastructure setup requirements and capacity planning for the EDW project requirements
• Participated in JAD sessions with users groups to elicit business requirements

Environment: Teradata 12, Erwin 7.3, Datastage 8, Oracle 10g

Lead Architect

Confidential

Responsibilities:

• Prepared Project Plan, effort & cost Estimates, Resource Scheduling plans, Identified Risk & issues
• Prepared the Functional Design document for mapping legacy functions to the target SAP R/3 modules.
• Identify data quality issues and compile recommendations. Interface with LOB Data Owners as needed to resolve source data quality and cleansing issue
• Manage, Monitor and support construction, SIT testing and production roll out of the Data Migration Software of the development team and report progress to the Confidential IT project manager
• Delivered ETL architecture
• Designed ETL and Cleansing Modules

Environment: SAP R/3, Oracle Financials 13, Erwin 7.3, Datastage 8, Information Analyzer

Technical Project Manager

Confidential

Responsibilities:

• Provide Solution for collapsing the existing data Warehouse application to the evolving OneSource EDW.
• Identified and promoted best practices and patterns for data modeling and provided oversight for all activities related to data cleansing, data quality and data consolidation using standard data modeling methodologies and processes.
• Provide Technical recommendations for optimized data access and retention for the data warehouse
• Build repository of reusable knowledge assets and implement best practices, concept documents for client .
• Managed the teams involved in the engagement. Participated in staff recruitment activities for the engagement and mentoring team members.
• Lead aspects of proposal development process, scope out effort and cost of solution, develop statement of work

Environment: Oracle 9i & 10g, Erwin 7.3, Informatica 8

Project Manager

Confidential

Responsibilities:

• Review Logical and physical data model
• Project Hardware capacity requirements
• Provide oversight to all design and development activities
• Develop and communicate project plans, work assignments, target dates. Ensure that projects follow Agile development life cycle and meet quality standards
• Responsible for costing, budgeting, resource planning, quality, timely completion, contract management, billing, project health check, profitability, closure, issue resolution and escalation

Environment: Oracle 10g RAC, OWB, OBIEE

Lead Architect

Confidential

Responsibilities:

• Design and develop Tool using ETL and geo coding tools
• Presentation of Migration to stakeholders and end clients
• Implement data quality assessment framework

Environment: QAS, Informatica IDQ, Oracle 9

Technical Lead

Confidential

Responsibilities:

• Maintain and enhance existing data marts
• Strategize and architect the evolution of the of Data Warehouses from one that was loaded weekly to one that would be loaded daily
• Provide on call support to critical issues for resolution.

Environment: Oracle Sales Analyzer

Data Modeler and ETL Lead

Confidential

Responsibilities:

• Formulation of Blueprint for re-engineering of National Business Database
• Provide Solution Architecture, Technical architecture
• Tool Evaluation & Selection
• Gap Analysis between as-is and to be state
• Meeting Business Users for Requirements Gathering, Organizing JAD sessions/workshops
• Design of data model for National Business Database
• Data Quality Assessment
• ETL process Design, Design and development of cleansing strategy
• Development of Test Scripts
• Capacity Planning - provide database size projections
• System deployment

Environment: DB2, Ascential DataStage 7.1, Integrity ( Now Quality Stage ), CODE1, Erwin 4.