SUMMARY

• IT professional with excellent interpersonal skills and 15+ years of experience in the areas of Enterprise Information Management, Data Architecture, Data Modeling, Data Analytics, Data Integration, Data Governance, Datawarehousing, and Business Intelligence. Experience in leading, managing and ramping up teams in onsite, offshore as well as geographically distributed working environments.
• Experience in complete life cycle of DW/BI/ETL implementations including defining Vision, Strategy, Architecture, Design, development, Testing, Governance, Troubleshooting, Administration, and Production Support.
• Experience in defining data architecture for data warehouses, Data marts and business applications.
• Experience in building conceptual (ERDs), logical and physical data models from ground up. Adept in Star - Schema modeling and Dimensional modeling.
• Strong analytic and SQL skills to analyze source systems and define integration/Data requirements.
• Experience in business analysis and requirement gathering.
• Implemented multiple large scale DW/BI projects involving Data Integration, Migration, Conversion, Upgrade and Reporting (BI) projects.
• Experience in working with industry leading ETL and BI tools and establishing governance standards and best practices for DW/BI environments.
• Experience in Prototyping solutions for design and architecture validation, creating technical specifications, preparing testing strategy, and creating deployment plans
• Adept in implementing Service Oriented Architecture, Master Data Management, Metadata management, Data profiling, and Data Quality Improvement initiatives.
• Expertise in IBM InfoSphere suite of products including DataStage (Parallel as well as Server Editions), QualityStage, Information analyzer, Business Glossary, Fast Track, and Information Services Director. IBM Certified Solution Designer/Developer for InfoSphere Information Server.
• Implemented projects using Agile, Waterfall, RAD, LD, and Hybrid methodologies.
• Experience in Mentoring, Coaching and Training of team members.
• Active interest in implementation of Cloud based DW/BI technologies and SaaS, PaaS and IaaS solutions.
• Active interest in implementation of Big Data technologies such as Hadoop/MapReduce and integrate them with overall DW/BI architecture to perform complex BI analytics.
• Experience in presales, creating proposals and implementing global delivery models.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, UNIX Shell scripting

Databases: Oracle, DB2, Teradata, Microsoft Access, SAP BW, SQL Server, MySQL, Sybase

ETL Tools: IBM InfoSphere (11.x,9.x,8.x/7.x/6.x), Informatica Power Center, SSIS, ODI, Talend, Abinitio

InfoSphere Products: DataStage, QualityStage, FastTrack, Information Analyzer, Information Service Director, Business Glossary, IBM Information Server Console & Server Manager, Metadata Workbench, DataStage Packs- SAP BW, SAP R/3, XML, Web Services, Java, PeopleSoft, Siebel, JD Edwards

Data Modeling: Erwin, SQL Developer, Visio

OLAP/BI Tools: SAP BexAnalyzer, Cognos, Business Objects, Crystal Reports, Microstrategy, SSAS, Tableau

Database Tools: SQL Loader, TOAD, SQL* Plus, Import, Export, File-AID,SQL Developer

Operating System Platforms: Linux, AIX, UNIX, Windows, OS/390, z/OS

Release Management: Visual Studio Team System 2008 Team Foundation Server (TFS), CVS, IBM Rational Clearcase & Clearquest, MS Visual SourceSafe (VSS)

Scheduling Tools: Autosys, Tivoli, Cron, DataStage Director, UC4

Miscellaneous: Hummingbird, WinCP, SharePoint, WebEx, Citrix, VMware, Reflections, ALM

Project Management: MS Project, VersionOne, Rally, Clarity, VersionOne

Big Data: Hadoop, Hive, MapReduce

PROFESSIONAL EXPERIENCE

Lead Data Architect

Confidential, Brainerd, MN

Responsibilities:

• Carry out Accelerated Solution Design phase to come up with enterprise wide Data Vision, strategy and roadmap.
• Conduct interviews with SMEs and identify pain points and challenges faced in day to day data operations.
• Based on current state analysis and future State data vision, provide recommendations for optimal, scalable and flexible data architecture, Data model, and Data governance.
• Conduct requirements gathering and design sessions with product owners. Review Business and data requirements with Business Owners and obtain sign off.
• Create and Implement Data Governance standards and best practices.
• Create and Maintain enterprise wide data dictionary/catalog.
• Work with Enterprise Information Management group to define and support Business Intelligence and reporting requirements.
• Provide end to end Data solutions for business requirements ranging from design, architecture, data modeling, technical specs, governance and stewardship.
• Work with data suppliers to establish input and interface specifications.
• Perform data analysis for source system data and assist in creating and modifying conceptual, logical and physical data models for Confidential System of records.
• Conduct reconciliation sessions with IT/QA to discuss elaborated stories to make sure that they are fully understood and are development Ready.
• Generate and record Data requirements, ERD, data flow diagrams, and data mapping documents.
• Review and sign off on data level testing by QA Teams

Data Architect/Data Lead

Confidential, New York

Responsibilities:

• Capture Data requirements and design processes to capture, store and retrieve financial and Ratings data for Simplify Rating Workflow application.
• Create and/or modify ERDs, conceptual, logical and physical data models based on business/data requirements.
• Create Data flow diagrams, business process flow diagrams, Technical specification and data mapping document to assist design, implementation and Quality assurance.
• Design Service contracts for web service APIs to transport data between data sources and applications.
• Perform Data Analysis, Gap analysis and data profiling across data domains to ensure data architecture/Models can support the applications data needs.
• Review and obtain signoff on Data requirements from business and application owners.
• Deliver data solutions using agile framework.
• Established and enforce Data governance standards and best practices. Implemented SOA architecture by creating reusable code base and eliminating redundancies.

Data Architect/Data Modeler

Confidential, Denver, CO

Responsibilities:

• Created the Conceptual and Logical data model to capture Demographic Data from Data Lake in order to support reports and data visualizations to help hospital administrators and planners to create strategies and revenue augmentation plans.
• Maintained and managed data models for Encounters, Diagnosis and Procedure data marts.

Senior Data Analyst

Confidential, New York

Responsibilities:

• Performed Data analysis and Data modeling to support NYL’s financial transformation (FT) program.
• Performed Source system analysis and wrote specifications to convert Annuity Valuation data from legacy systems to support SAP HANA and Insurance Analyzer (IA) based integrated technology platform.
• Performed Data Harmonization to bring data for different annuities products (FDA, VDA etc.) to common IA data structures.
• Involved in designing the solution for ETL processes, Change Data Capture (CDC), Error Handling, Data Reconciliation and Data retention.

ETL Lead and InfoSphere Administrator

Confidential, Dublin, OH

Responsibilities:

• Worked as the Subject Matter Expert on IBM InfoSphere Suite of Products. Led the successful Installation, Configuration and Administration of the product (DataStage, QualityStage, Information analyzer, Fast Track, Business Glossary, IISD, Metadata workbench).
• Designed and Implemented ETL processes for Integration of several new data sources from acquired businesses to existing ETL framework and load the Enterprise Datawarehouse.
• Established DW/ETL governance standards and best practices. Implemented SOA architecture by creating reusable code base and eliminating redundancies.
• Performed Data analysis to define integration requirements and creating technical specifications
• Prepared Testing Strategy and plan. Reviewed, troubleshoot and resolved technical design and architectural issues. Managed the release management cycle for DW/ETL deployments

Solution Architect and Engagement Lead

Confidential, Boston, MA

Responsibilities:

• Led Virtusa team to implement a Microstrategy based BI reporting solution which consisted of the development of 40 flexible core reports and customization of web user interface.
• Created technical architecture and design to provide Single Sign-on (SSO) capability for seamlessly accessing Microstrategy reports from Client Access Website.
• Worked with Business and Microstrategy team to align business requirements with tool capabilities and propose adjustments, changes if necessary.
• Performed data analysis to ensure correct and complete data is available for reporting requirements.
• Involved in analysis and tuning of reporting SQL queries. Identified opportunities for reusability of business logic in reports to minimize development time and improve efficiency.

DW Architect

Confidential, Boston, MA

Responsibilities:

• Provided Confidential Services (JHFS) a roadmap for implementing a large Datawarehouse for its Rerate and Business Integrity functions which would enable Seamless reporting and Data mining capabilities. Proposed a scalable architecture to include future subject areas, multi- dimensional query facilities (data marts and OLAP cubes) and anticipated data growth.
• Developed a prototype using Microsoft DW/BI stack consisting of a small Datawarehouse with real data and generated several high business impact reports to showcase the usefulness of data warehouse for the organization.

Database Migration Lead

Confidential, Columbia, MD

Responsibilities:

• Successfully led Virtusa team to perform a detailed analysis of the backend databases (on Sybase and MS SQL Server platforms) of 3 key hospitality POS applications (RES, SimVen and Suites) and came up with a comprehensive technical approach and estimation of the cost and effort involved in migrating the backend databases to Oracle platform.
• Identified tools and technical approaches for Schema migration, data migration, ways to address SQL code for impacted applications and comprehensive application regression testing. Identified potential technical issues, risks, and dependencies.
• Performed a trial migration using one of the identified tools to come up with its limitations and prepared an inventory of possible activities to be performed manually.