SUMMARY

• Around Twenty years of Information Technology experience across broad spectrum of techniques, concepts, and technologies in Retail and Healthcare domains.
• Around sixteen years of experience in Enterprise Data Warehouse systems with techniques, concepts, and technologies including Data Modeling, ERwin, Netezza, Oracle, SQL Server, Oracle Retek/Retail, MicroStrategy.
• Around eighteen years of experience in Enterprise Integration solutions and information architecture with techniques, concepts, and technologies including TIBCO, Oracle Fusion, Confidential MQ, Confidential InfoSphere Information Server, Microsoft SSIS, Informatica PowerCenter, Open Source Integration tools, SOA, Oracle, Netezza, SQL Server, C, TCP/IP, C++, J2EE, Pro*C.
• Around eight years of experience in Enterprise Architecture by collaborating with Business Architects, Project Management teams, and cross - functional IT departments.
• Knowledgeable with two years of experience in Big Data, Data Lakes, Cloud Computing with technologies including Hadoop, MongoDB, Open Source, and AWS in Linux and Windows environment.
• Working with all levels of staff including C-level executives in project delivery with Leadership, Comprehensive Business & IT Strategy, Project Management, Ownership, System/Solution architect, Technical Lead, Design, Development, Implementation, and Support responsibilities.
• Planning, leading, enterprise architecture, technology roadmaps, solution blueprints, solution delivery strategy, technology selection, and implementation of comprehensive strategies in support of Data Warehousing and Integration solutions.
• Design current and future state business processes, Data Flow Diagrams, and Conceptual to Physical data models.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Big Data SQL, CQL, Python, PHP, J2EE, C++, C, Pro*C/C++, UNIX shell scripts, JavaScript, Perl, JSON, XML, XHTML, HTML

Tools: ECLIPSE, ERwin, Confidential Rational System Architect, Visual C++, Visual Caf Semantics, TOAD, SQL*Navigator, Netezza Aginity, PVCS, HEAT, SQA, Microsoft Office, Google G Suite

Infrastructure: EDW, Retek Data Warehouse (RDW), Oracle Retail/Retek, Confidential InfoSphere Information Server, Confidential DataStage ETL, Informatica PowerCenter, Confidential MQ, Confidential WebSphere, TIBCO, JBoss Enterprise SOA, HIE Cloverleaf, MicroStrategy, Microsoft Power BI, Microsoft SSRS, Tableau, UNIX, Linux, Windows, Oracle, SQL Server, Netezza, Teradata, MySQL, Microsoft Access, Non-relational databases, REST, SOAP, Web Services, Big Data Technologies, AWS Cloud Computing, Agile/Scrum, VMWare

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Enterprise/Solution Architect

Responsibilities:

• Prepare and Review RFPs, prepare RFP responses, and evaluate RFP responses using pre-defined scoring system.
• Provide consultation on architecture involving Data Warehousing and Integration.
• Provide consultation on presentation decks prepared for C-level executives and Technical teams.

Environment: EDW & BI, RDBMS, Big Data, AWS, SAP, TIBCO, ERwin, Linux, Windows, Microsoft Office, Google G Suite.

Confidential, Dallas, TX

Technical Consultant

Responsibilities:

• Planning, leading, and developing comprehensive enterprise architecture strategy and high-level design documents.
• Develop project charter, project scope, Statement of Work (SOW), solution architecture, and capacity planning.
• Provide consultation on roadmaps, solution blueprints, solution delivery strategy, and technology & vendor selection.
• Collaborate with Project & Portfolio Management Office to develop and maintain project management principles, methodologies, architecture standards, policies, and the application of industry best practices.
• Ownership and design of future state business processes, Data Flow Diagrams, Conceptual to Physical data models.
• Project delivery oversight with leadership, project management, solution architect, and technical lead responsibilities.
• Establish communication methods and conduct learning sessions for stakeholders and cross-functional IT departments.
• Provide consultation on architecture, design, and development of enterprise data warehouse and integration solutions.
• Identify the opportunities and recommend solutions involving Data Warehousing, Integration, Big Data, and Cloud.
• Part of the architecture team to develop BI information architecture addressing the EDW system reengineering.
• Technical/Project lead and solution architect for various BI projects.
• BI Project Manager role to manage and support BI department goals and objectives.

Environment: Netezza, SSIS, AWS, Hadoop, MongoDB, Kafka, TIBCO, JumpMind METL, ERwin, SQL Server, SSRS, Microsoft Visio, Microsoft Access, MicroStrategy, SQL, PL/SQL, Linux, Windows, VMWare, XML, Netezza Aginity

Confidential, Marlborough, MA

Lead Information Architecture Consultant

Responsibilities:

• As part of Architecture team, participate and contribute to the Information, Application, Integration, and Technology Architectures principles, policies, and the application of industry best practices.
• Provide consultation on design and development of enterprise-wide information architecture.
• Provide inputs to project cost estimates, resource planning, solution blueprints, solution delivery strategy, functional requirements, and non-functional requirements.
• Ownership and design of future state business processes, Data Flow Diagrams, Conceptual to Physical data models.
• Participate in the development and implementation of the data governance and master data management plans.
• Lead and develop data usage designs in enterprise data integration efforts (ETL/SOA/Middleware) and in the creation of enterprise data mappings.
• Design and support the implementation of business and Systems key performance indicator (KPI) dashboards.
• Develop source data analysis technical documents, high-level solution architecture documents, source to target mapping documents, data conversion/migration strategy documents, data archival strategy documents, and data transformations for Enterprise Data Warehouse and ETL processes.

Environment: EDW, Netezza, Oracle Retail, Oracle RPAS, ERwin, QlikView, Confidential Cognos, Confidential InfoSphere Information Server 8.7, Confidential MQ, SQL, PL/SQL, UNIX, Windows, TOGAF, XML, TOAD, Netezza Aginity

Confidential, Irving, TX

Enterprise Architect

Responsibilities:

• Play a key role in Enterprise Architecture team in establishing architecture standards and guidelines, information governance and policies, and technology roadmaps.
• Collaborate with project teams and infrastructure team in capacity planning and software & hardware configurations.
• Collaborate with project teams to create project cost estimations and high-level architecture design documents.
• Solution architecture for various projects including but not limited to Enterprise Application Integration, Data Warehousing, Price Optimization, Internationalization, and Information Architecture & Governance.
• Play a key role in evaluation and selection of technologies, vendors, products, and tools.
• RFP reviews and Ownership of Enterprise Integration architecture and POC planning with leading technology vendors including TIBCO, JBoss, Confidential, and Oracle.
• Collaborate with other teams in attaining the transition of the company to co-sourcing IT model.
• Develop ETL roadmap, migration plan, architecture, and strategy for DataStage ETL migration from 7.5.2 to IIS 8.7.
• Enterprise integration architecture utilizing Confidential DataStage 7.5.2, Pro*C, and UNIX for various projects.
• Work with various project teams in analyzing and implementing systems performance improvements.

Environment: Confidential, DELL, Oracle, Netezza, Confidential InfoSphere Information Server 8.7, Confidential DataStage 7.5.2, Confidential MQ, TIBCO, JBoss Enterprise SOA, Oracle Fusion, MicroStrategy, SQL, PL/SQL, Pro*C, J2EE, Retek, Oracle Retail/Retek, Retek Data Warehouse (RDW), EDW, UNIX, LINUX, Windows, VMWare, XML, REST, SOAP, Web Services, ControlM, SQL*Navigator

Confidential

Senior Application/Integration Systems Analyst

Responsibilities:

• Collaborate with Michaels and Oracle teams in requirements analysis, functional design, and technical design documentation.
• Develop Conceptual, Logical, and Physical data models for Oracle Promote and Oracle Retail/Retek integration.
• Work closely with business users and Oracle team to extract the sales and inventory data from Netezza EDW for PILite project to perform data analysis.
• Work with business and BI reporting teams to design and implement the reports using MicroStrategy for PILite project.
• Develop the ETL standards, information strategy, architecture, and governance models.
• Participate in the implementation of optimized promotional planning solution with Promote Intelligence (PI) and Promote Planning Optimization (PPO) applications through Oracle On-Demand service.
• Build, implement, and support end-to-end integration between source and target systems including Oracle Promote and Oracle Retail/Retek using Confidential DataStage 7.5.2, Pro*C, SQL, and PL/SQL.
• Implement Oracle Retail/Retek enhancements as part of optimized promotional planning project.

Environment: Confidential, Oracle, RDW, EDW, Oracle Retail/Retek, Netezza, MicroStrategy, SQL, PL/SQL, Pro*C, Confidential DataStage 7.5.2, UNIX, ControlM, SQL*Navigator, TOAD

Confidential

Senior Application Systems Analyst

Responsibilities:

• Collaborate with business users in requirements analysis, functional design, and technical design documentation.
• Participate in developing information strategy, architecture, and governance models.
• Architect, design, develop, test, deploy, and support integration processes for EDW by utilizing Confidential DataStage 7.5.2, Pro*C, UNIX, Windows.
• Architect, design, develop, test, and implement Enterprise Data Warehouse (EDW) system enhancements by utilizing Star Schema, Netezza, Oracle Retail, Oracle Retek Data Warehouse (RDW), Confidential DataStage 7.5.2, Pro*C, Shell Scripts, Control M Scheduler, and UNIX.
• Played a key role in building the strategy to migrate Oracle based Retek Data Warehouse (RDW) to Netezza based EDW and implement the migration plan involving Oracle, Pro*C, SQL, PL/SQL, Netezza, Confidential DataStage ETL (version 7.5.2), and MicroStrategy reporting tool.
• Played a key role in RFP process to evaluate and select the products for ETL and data warehousing systems. The ETL products for evaluation include Confidential DataStage, Informatica, and Ab Initio. The data warehousing systems for evaluation include Netezza, Teradata, and Confidential DB2.
• Architect, design, develop, test, and implement SKU reclassification in Oracle based Retek Data Warehousing (RDW) system using Pro*C, SQL, PL/SQL in UNIX environment.

Environment: Confidential, Oracle, Retek Data Warehouse (RDW), EDW, Oracle Retail/Retek, Netezza, MicroStrategy, SQL, PL/SQL, Pro*C, Confidential DataStage 7.5.2, UNIX, ControlM, SQL*Navigator, TOAD

Confidential, Plano, TX

Technical Specialist

Responsibilities:

• Collaborate with business users in requirements analysis, functional design, and technical design documentation.
• Part of the team to design, develop, test Object-oriented, Web-based Object Translator for OpeN/2 engine (system) by utilizing J2EE, Visual Café, C++, Pro*C/C++, TCP/IP, RDBMS, and Windows NT/2000.
• Design, develop, test, and deploy TestNet tool for OpeN/2 system by utilizing J2EE, Visual Café, Visual C++, TCP/IP, RDBMS, Windows NT/2000, Java Applets, Java Servlets, and Bluestone application server.
• Develop prototypes as part of TestNet tool to integrate the C/C++ and Java applications using JNI technology.

Environment: Oracle, SQL Server, J2EE, C++, C, XML, PL/SQL, Pro*C/C++, TCP/IP, Shell Scripts, UNIX, SOAP, Web Services, XML

Confidential, Irving, TX

Software Engineer

Responsibilities:

• Design, develop, test, and deploy Object-oriented, Web-based application using J2EE and Visual Café Semantics.
• Design, develop, test, and deploy Ambulatory Payment Classification (APC) Grouper application Engine using XML, Visual C++, RDBMS, Windows 95/98/NT, and Health Care Financing Administration (HCFA) rules.
• Design, develop, and implement interfaces using HIE Cloverleaf, Oracle, Pro*C, C, TCP/IP, Shell Scripts, and UNIX.
• Implement and support yearly DRG Grouper enhancements for all clients by utilizing Oracle, Pro*C, C, and UNIX.
• Project/Technical Lead for a team of five to implement and support Oracle and UNIX based HIMS application.
• Project/Technical Lead for a team of three to implement and support Oracle and UNIX based Financial Support System (FSS) that includes Contract Management, Cost Accounting, Product Line Management, Capitation, and Enterprise wide Reporting modules.
• Design, develop, and implement IMN/FSS interface system using Oracle 7.3.4, Pro*C, C, Shell Scripts, and UNIX.
• Provide production support for interface systems, HIMS, and FSS and implement software performance improvements.

Environment: Oracle 6.0/7.x/8.x, SQL Server, XML, SQL*Plus, SQL, PL/SQL, Pro*C, C, TCP/IP, HIE Cloverleaf, Shell Scripts, UNIX, HL7

Confidential

Programmer Analyst

Responsibilities:

• Design, develop, test, and deploy batch interfaces such as state submissions, patient billing, and patient visits using HL7 standards, Oracle, Pro*C, C, and shell scripts in UNIX environment.
• Design, develop, and implement real-time Admission, Discharge & Transfer (ADT) interface system with third party vendors using HL7, Oracle, Oracle Forms, Pro*C, C, TCP/IP, and Shell Scripts in UNIX environment.
• Design, develop, and implement real-time interface system between IMN Patient Management System and Canadian Regional Client Information System (RCIS) in distributed database environment by utilizing Oracle 7.x, Pro*C, C, Shell Scripts, Database Stored Packages, Database Signaling, and daemon processes in UNIX environment.
• Collaborate with clients in analyzing business requirements for patient management system and develop software modules using Oracle 6.0/7.0 and Shell scripts in UNIX environment.
• Provide production support for interface systems and implement software performance improvements.

Environment: Oracle 6.0/7.x/8.x, SQL, PL/SQL, Pro*C, C, TCP/IP, Shell Scripts, UNIX, HL7, database triggers, database signaling