SUMMARY:

Decisive and multi - faceted IT professional with 22+ years of software development experience in delivering efficient software solutions and expertise in architecture, design, implementation, support of cutting-edge programs, and processes across a broad spectrum of technologies. Experienced in working with all levels of staff and consistently recognized for delivering cost effective and quality solutions. Excellent work ethics and strong customer support, communication, documentation, training, and interpersonal skills.

TECHNICAL SKILLS:

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

Tools: ECLIPSE, ERwin, IBM Rational System Architect, DevOps Jenkins, Visual C++, Visual Caf Semantics, TOAD, SQL*Navigator, Netezza Aginity, SQL*Reports, SQL*Loader utilities, Oracle export/import utilities, Microsoft Project, PVCS, HEAT, SQA

Infrastructure: Enterprise Data Warehouse (EDW), Oracle Retail, Retek Data Warehouse (RDW), IBM InfoSphere Information Server, IBM DataStage, Informatica PowerCenter, Informatica PowerExchange, IBM MQ, IBM WebSphere, TIBCO, JBoss Enterprise SOA, Oracle Fusion, MicroStrategy, QlikView, Tableau, Business Objects, IBM Cognos, UNIX, Windows, Oracle, SQL Server, Netezza, Teradata, DB2, MySQL, Microsoft Access, REST, SOAP, Web Services, Open Source Technologies, Big Data Technologies, AWS Cloud Computing, Agile/Scrum, DevOps, Internet of Things (IoT)

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Business Intelligence (BI) Technical Consultant

Responsibilities:

• Ownership of project delivery with leadership, project management, system/solution architect, and technical lead responsibilities.
• Planning, leading, and implementing comprehensive strategies in support of BI goals and objectives.
• Develop project charter, project scope, Statement of Work (SOW), and project technical documentation for BI projects.
• Provide consultation for architect, design, and development of enterprise data warehouse and integration solutions.
• Provide consultation for enterprise architecture, solution blueprints, solution delivery strategy, and technology selection.
• Identify the opportunities and recommend the POCs and solutions that involves Cloud and Big Data Technologies.
• Ownership and design of future state business processes, Data Flow Diagrams, conceptual to physical data models.
• Participate in the global definition of project management principles, methodologies, policies, and the application of industry best practices.
• Participate in the global definition of architecture principles, methodologies, policies, and the application of industry best practices.
• Technical/Project lead for Netezza Upgrade project to migrate from TwinFin to Striper with solution architecture, project planning, and project management roles.
• Technical lead responsibilities for Merchandise Reclass project to reclass 3+ years of historical data in Netezza based Enterprise Data Warehouse system.
• Technical/Project lead and solution architecture roles to migrate Supply Chain Operational Reporting tool from Access database to SQL Server enhance the tool to support multi-DC environment, and provide additional reports.
• Part of the architecture team to develop BI information architecture that addressed the reengineering of data warehouse system, enterprise data warehouse system, and integration solution.
• Technical/Project lead for MicroStrategy Upgrade project to upgrade from 9.3 to 10.4with solution architecture, project planning, and project management responsibilities.
• Project Lead role to implement MicroStrategy 9.3 reporting capabilities for Forecast & Planning application.
• Identify the opportunities and recommend/implement the solutions in System performance tuning and optimization.

Environment: Enterprise Data Warehouse (EDW), Netezza data warehouse appliance, SSIS integration middleware, AWS, Hadoop, MongoDB, Kafka, JumpMind METL, Erwin, SQL Server, Microsoft Visio, Microsoft Access, MicroStrategy, SQL, PL/SQL, Linux, Windows, XML, Netezza Aginity, Microsoft Project.

Confidential,Marlborough,MA

Lead Information Architecture Consultant

• Provide consultation for the design and development of enterprise-wide data and information architecture.
• Provide inputs to 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 global definition of information architecture principles, policies, and the application of industry best practices.
• Ensure continual maintenance of high quality timely and standardize data that meets all regulatory, industry compliance and industry best practices procedures. Participate in the development and implementation of the data governance and master data management plan.
• Lead, develop, and provide input to data usage designs in enterprise data integration efforts (ETL/SOA/Middleware) and in the creation of enterprise data mappings. Create, maintain, identify gaps, and monitor the Data Architecture framework for stability, awareness, and source to target mapping.
• Design and support the implementation of business and Systems key performance indicator (KPI) dashboards.
• Review of project team deliverables for key transformational projects in the enterprise such as enterprise data warehouse, operation data store, data marts, and MDM initiatives.
• 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 ETL teams. Perform data profiling as part of the data quality analysis exercise.

Environment: Enterprise Data Warehouse (EDW), Netezza data warehouse appliance, Hadoop, ERwin, QlikView, IBM Cognos, IBM InfoSphere Information Server 8.7, IBM MQ, SQL, PL/SQL,, UNIX, Windows, TOGAF, XML, ITIL, TOAD, Netezza Aginity

Confidential,Irving,TX

Enterprise Architect

• 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, procurement of software& hardware, and system installation & configuration.
• Solution architecture for various projects including but not limited to Enterprise Application Integration, Confidential, Price Optimization, Internationalization, and Information Architecture &Governance.
• Play a key role in the technologies, vendors, products, and tools evaluation, POCs, and selection process.
• Ownership of Enterprise Integration POC with leading technology vendors including TIBCO, JBoss, IBM, and Oracle.
• Collaborate with all the teams in attaining the smooth transition of the company to co-sourcing IT model.
• Develop the strategy for IBM DataStage ETL system migration from 7.5.2 version to IIS8.7, identified suitable implementation partner, and played a key role in migration plan, architecture, and implementation of DataStage ETL migration project. Developed the strategy to build the foundation for future ETL roadmap.
• Design, development, and implementation of Enterprise wide integration processes utilizing IBM DataStage 7.5.2, Pro*C, and UNIX for critical projects.
• Instrumental in working with various project teams in analyzing and implementing the changes to improve the systems performance.

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

Confidential

Integration Systems Analyst

• Collaborate with Michaels and Oracle teams in requirements analysis, functional design, and technical design documentation.
• Develop conceptual, logical, and physical data models for both Oracle Promote and Oracle RMS systems.
• Work closely with business and Oracle team to extract the sales and inventory data from Netezza EDW as part of PILite project, which was implemented to analyze Michaels’s data.
• Work with business and BI reporting team to design, develop, and implement the reports using MicroStrategy for PILite project.
• Develop the ETL standards, information strategy, architecture, and governance models.
• Part of the team to implement Promote Intelligence (PI) and Promote Planning Optimization (PPO) applications as part of optimized promotional planning solution. These applications are deployed and managed through Oracle On-Demand service.
• Build end-to-end integration between Oracle Promote and Oracle RMS using IBM DataStage 7.5.2, Pro*C, SQL, and PL/SQL to implement optimized promotional planning.
• Implement the enhancements to various modules within Oracle RMS as part of the optimized promotional planning.
• Provide production support for all integrations between Oracle Promote and Oracle RMS.
• Participate in all phases of software testing.

Environment: IBM, Oracle, RDW, EDW, Oracle RMS, Netezza data warehouse appliance, MicroStrategy, SQL, PL/SQL, Pro*C, IBM DataStage 7.5.2, UNIX, ControlM, SQL*Navigator, TOAD

Confidential Systems Analyst

Confidential

• 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, deploy, and support of integration processes across the enterprise by utilizing IBM DataStage 7.5.2, Pro*C, UNIX, Windows.
• Architect, design, develop, and implement Enterprise Data Warehouse (EDW) system enhancements by utilizing Star Schema, Netezza data warehouse appliance, Oracle Retail, Oracle Retek Data Warehouse (RDW), IBM DataStage ETL (version 7.5.2), and Pro*C.
• Played a key role in building the strategy to migrate the Oracle based Retek Data Warehouse (RDW) to Netezza based Enterprise Data Warehouse (EDW) and implement the migration plan with Oracle, Pro*C, SQL, PL/SQL, Netezza data warehouse appliance, IBM DataStage ETL (version 7.5.2), and MicroStrategy reporting tool.
• Played a key role in RFP process to evaluate and choose the products for ETL and Confidential systems. The ETL products for evaluation include IBM DataStage, Informatica, and Ab Initio. The Confidential systems for evaluation include Netezza, Teradata, and IBM DB2.
• Design, develop, and implement Retek Confidential (RDW) system enhancements, Star Schema, Oracle, Pro*C, and UNIX.
• Design and develop processes to capture dimensional and sales & inventory fact data from various source systems into RDW system using Oracle, SQL, PL/SQL, Pro*C, Database Triggers, Shell Scripts, ControlM Scheduler.
• Architect, design, develop, and implement SKU reclassification in Retek Confidential (RDW) system using Oracle, Pro*C, SQL, PL/SQL in UNIX environment.
• Perform system performance analysis and implement the performance enhancements.
• Participate in all phases of software testing and provide production support for various systems including Oracle RMS, RDW, and EDW.

Environment: IBM, Oracle, RDW, EDW, Retek, Netezza data warehouse appliance, MicroStrategy, SQL, PL/SQL, Pro*C, IBM DataStage 7.5.2, UNIX, ControlM, SQL*Navigator, TOAD

Confidential,Plano, TX

Technical Specialist

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

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

Confidential, Irving, TX

Software Engineer

• Part of the team to design and develop Object-oriented, web-based application using JAVA, and Visual Café Semantics.
• Design, develop, and deploy Ambulatory Payment Classification (APC) Grouper Engine as part of APC Grouper application using XML, Visual C++, RDBMS (oracle, MS Access, MS SQL Server), Windows 95/98/NT, and Health Care Financing Administration (HCFA) rules.
• Design, develop, and implement interface systems using HIE Cloverleaf interface engine, Oracle, Pro*C, C, TCP/IP, Shell Scripts in UNIX environment.
• Implement and support yearly enhancements to DRG grouper application at all customer sites utilizing Oracle, Pro*C, C, and UNIX.
• Project/Technical Lead for a team of five to implement and manage Oracle and UNIX based Healthcare Information Management System (HIMS).
• Project/Technical Lead for a team of three to implement and manage Oracle and UNIX based Financial Support System (FSS), which include 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, and Shell Scripts on UNIX platform.
• Provide production support for all interface systems, HIMS, and FSS for all customers and perform software performance tuning.
• Participatedvarious phases of software testing.

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

Programmer Analyst

Confidential, Irving, TX

• Design, develop, and deploy batch interface systems such as state submissions, patient billing, patient visits, and among others 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 utilizing Oracle 7.x, Pro*C, C, Shell Scripts, Database Stored Packages, Database Signaling, and daemon processes in UNIX environment.
• Collaborate with customers to analyze health care business requirements for patient management system and develop software modules using Oracle 6.0/7.0 in UNIX environment.
• Develop and maintain Patient Registration and Patient Accounting modules by utilizing Oracle database, SQL*Plus, SQL, PL/SQL, Pro*C, SQL*Forms, SQL*Menus, SQL*Reports, and Shell Scripts in UNIX environment.
• Provide production support for all interface systems for all customers and perform software performance tuning.
• Participate in various phases of software testing.

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