SUMMARY:

• Having worked in so many verticals over the years and understanding the business processes and relating them to Management Information System (MIS) has been my key strength.
• All organizations are data driven and to understand what drives the business decisions when it comes to data and how to extract them to a meaningful model, enrich the quality with proper data governance with data security and delivery mechanism ( be it desktop or mobile platform) has been my expertise and specialization over the past 21 years.
• Having the exposure of domestic and global implementation of data warehouses I have mastered the art of right methodology, techniques and strategies to tackle various management initiatives and made projects successful even with very tight budgets or time constrains.
• Architect & Design technology approaches that align with business strategies.
• Develop the enterprise architecture technology vision, based on As - Is Assessment of existing EDW and Integration Layer, defining the To-Be state, establishing the roadmap to get there, including establishing solutions and standards.
• Act as a liaison to Information Governance, Data Stewardship, Enterprise Information Services, lines of business and the development organization to align business strategy with enterprise data management strategy and solutions.
• Provide senior management with an integrated perspective, assessing risks and the effects of specific requirements on other processes and system priorities; ensure any proposed technology solutions are appropriately aligned with overall strategy.
• Generate the technical approach of the overall solution proposal: including technology, data, application and integration solution description, estimated costs and timeline.
• Establish metrics for tracking and measuring the value of data architecture initiatives.
• For example, measuring model reuse, impact on project costs or improved data consistency across diverse initiatives.
• Planning RDM and MDM strategies for global initiatives.
• With real time implementation along with extensive experience.

AREAS OF SKILLS REQUIRED IN:

Enterprise Data Architecture

Meta Data Management

Reference and MDM Architectures

Enterprise Data Warehouse

Business Intelligence Architect

Operational Data Store

Data Quality & Data Governance

Data Life Cycle Management

Data Security

Data Mining

Content Management, Data Services & Cloud Computing

Business Process Analysis

Data Appliances (PDW, Netezza, Teradata)

Project Management

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Architect

Responsibilities:

• Building various interfaces (data models) which sucks data from various transactional systems covering primacy productivity in processing medications for hospice patients.
• Covering areas of various sources of billing (internally and externally).
• Covering various aspects of alternative and effective medications based on various historical data which are effective intake for hospice patience.
• The responsibility to convert these data to a meaningful analytics through Business Intelligence and Data Mining capability using Microsoft SQL Server 2012, Power Pivot and Power View.

Confidential, Philadelphia

Corporate Data Architecture

Responsibilities:

• To build corporate strategy for Enterprise Data Architecture covering 98 countries to 5 data centers worldwide for BI and corporate level reporting.
• Managed a budget of over 5 million.
• Global MDM initiatives with implementation along with reference data architecture with data governance.
• MDM initiative comprised of set of methodologies, strategies, disciplines which allowed the Claims business unit to acquire cleanse, enriched, consolidated, federate and govern data across many disparate systems.
• From operational prospective it became the best version of the truth, providing and accuracy, consistent and secure copy of master data to all systems and business users across lines of business(LOBs)

Confidential, New York

Sr. Data Architect

Responsibilities:

• To build a data model which integrates Loan IQ Application to centralized Data Warehouse with PeopleSoft integration.
• Supporting global initiatives with alien data models with various applications.
• Responsible to delegate the designs and monitor offshore ETL development team.
• Was also involved in BO interface and its development work.
• Managed a team of offshore developers.

Confidential, New York

Sr. Enterprise Data Warehouse Architect

Responsibilities:

• To integrate over 200 source systems to a centralized data warehouse.
• Managing a large group of developers both inshore and out shore.
• Key initiative was to architect multiple sources to a centralized warehouse using Kimball methodology.

Confidential, New York

Sr. Business Intelligence Architect & Project Manager

Responsibilities:

• To re-engineer the data models and architecture of Loan IQ to cater to various databases for clients having different platforms.
• Worked with a group of 25 engineers.
• Was key architect for ETL loads and it’s process management.
• Involved in BI interfaces using Cognos tools.

Confidential, New Jersey

Sr. Solution Architect

Responsibilities:

• To build Business Intelligence Capabilities covering various departments which was fed from SAP BW.
• Played key role to integrates various lines of business to share and leverage information across them.

Confidential, Pennsylvania

Solution Practice Manager

Responsibilities:

• Was responsible to build POC for various clients as a BI solution with several demos and tools.

Confidential, Pennsylvania

Cognos & ETL Sr. Developer

Responsibilities:

• Was responsible to build a data warehouse for reporting needs for 20 years of financial data after SAP was decommissioned.
• Building the warehouse from scratch which involved design decisions, modeling, ETL and deploying security layer for data access.
• Designed several adhoc reports for financial reporting using Cognos tools.

Confidential, New York

Sr. Cognos Architect cum Developer

Responsibilities:

• That involved understanding various systems and building a data model which pushed data from all the systems to BOE centralized data warehouse, along with ETL using Data Stage.

Confidential, New Jersey

Business Analyst & ETL Developer

Responsibilities:

• Was responsible to build a data warehouse which integrated various operations of Finance, HR, CRM’s and few legacy systems.
• Designed the business model with various process flows feeding data to Oracle 9i by using ETL tools.
• Also was involved on Reporting side using Cognos tools to ensure the data flow was optimum and efficient.

Confidential, New York

Data Architect / ETL Developer

Responsibilities:

• Took responsibility to build various logical & physical models for various operations areas of Confidential covering Sales, Customer Support and Maintenance.
• Data flow was from various systems but the objective was to bring the data to a centralized SQL Server environment.
• Was involved in re-engineering PeopleSoft HRMS data for its feed to the centralized data warehouse.

Confidential, New York

Sr. Architect / BI cum ETL Developer

Responsibilities:

• Was responsible in introducing Cognos Suite of products for reporting.
• In the process had designed several logical and physical models to bringing data to a data center using Data Stage.
• Designed and developed complex ETL mappings to populate data from various source systems to target databases.
• Developed various Cognos Impromptu reports and several cubes which was the end users requirement.

Confidential, New York

Sr. BA & Data Architect

Responsibilities:

• The role was purely consulting and providing end to end BI solutions to clients.
• Was involved in upgrading projects for Peoplesoft 7.5 to 8.0.
• Was responsible in building some Cognos BI infrastructures and giving jumpstart to clients.

Confidential, New Jersey

Sr. Cognos Developer / ERP Business Analyst

Responsibilities:

• Implemented the complete Financial / Distribution package of Peoplesoft 7.5. Implemented various EDI interfaces for customer billing and accounts receivable with 3rd party vendors.
• Was responsible in designing Crystal / Business Objects Universe which had various data sources.
• Built various logical and physical models around the PeopleSoft data to enhance reporting capabilities and performance.
• Involved in integrating various applications for reporting needs.
• Involved in various process flow designs to cleanse data for reporting needs.

Confidential, Chicago

ERP Developer

Responsibilities:

• Was involved in building an integrated manufacturing process flow using JD Edwards.
• Was responsible in configuring the various modules which was governed by the business requirements on various process flows.
• Used Crystal reports for the reporting needs which extracted data directly from transactional system.
• Re-engineered the entire transportation procedures and developed various process flows covering the area followed by custom set up on JD Edwards to meet the business needs.

Confidential

Business Analyst / ERP Developer

Responsibilities:

• Worked as a functional consultant for JD Edwards implementation (Financials & Distribution Modules). Upgraded from World to Confidential .
• Worked in the areas of converting AS400 database to Cognos data mart
• Worked with Impromptu Version 5.0 and Power Play Version 5.0 in building reports and queries from the data warehouse