PROFESSIONAL SUMMARY:

• Over 26 years of experience with more than 22 years in IT projects in cross industries experience like the Higher, financial services and Insurance and automobile industries.
• Strong understanding of the implementation and usage of the Banner Student Information System Suite, including but not limited the following modules:

• Partner and integrate with application process and technical architecture across business, engage business users and projects in defining reporting and analysis requirements throughout the Software Development Life Cycle (SDLC)
• Prepare Functional Specifications, Technical Specifications, process flows based on GAP - Analysis between existing system and new business requirements.
• Create, manage, customize, and tune ETL scripts in a multi-threaded environment incorporating
• Provide end user on Banner application and Involved in development of user material for the usage of Banner Applications.
• Ellucian ODS and colleague ODS (Operational Data Store) database administration including oracle streams and ETL (extract, transform, and load) process using Oracle Warehouse Builder / ODI .
• Perform performance tuning and optimization on nightly schedule jobs, patching and upgrades and reporting processes and also involved transactional (BANNER) databases archiving, backup/recovery processes, replication, cloning, importing/exporting.
• Modify existing mappings and create new ETL mapping (Extract, Transform, and Load) from staging data base and use change tables to be stored in the ODS/ODI: custom mods, Banner baseline tables, external data sources (outside Banner).
• Write and Modify SQL scripts that define/amend the SGHE baseline ODS infrastructure.
• Design and develop data extraction process from enterprise resource planning (ERP) systems like SunGard Banner Higher, People Soft, SAP and UltiPro ® for HR, payroll, Degree Works, Communication Management, Recruiter, Flexible Registration, ODS , Document Management, Course Signals, Mobile, Payment Center, FM Needs Analysis, Recruiting and Admissions Performance, Student Retention Performance for Higher industry.
• Involve Migration process, data mapping and code conversion between Banner and People Soft ERP.
• Extract data from third party ERP and Load into Banner /ODS database for Legacy data.
• Use subject areas like HR, Payroll, Finance, Accounts Receivables, Advancement, Student Information Systems, financial AID, and Foundation departments.
• Conduct Business Intelligence Tool Evaluation process, Business Requirement Analysis, OLAP Architecture, design and implementation of Business Intelligence report.
• Define scope, develop plan, and implement a process for developing and maintaining reporting and analysis solutions.

EXPERTISE AREA:

• Core Banner modules
• HR
• Payroll
• Financial Aid
• Advancement
• Degree Works
• Communication Management
• Recruiter
• Flexible Registration
• ODS
• Document Management
• Course Signals
• Mobile
• Payment Center
• FM Needs Analysis
• Recruiting and Admissions Performance
• Student Retention Performance and Luminas Portal
• Workflow
• Application Manager

TECHNICAL PROFICIENCIES:

Data Warehouse Tools: Cognos Suite of Tools Cognos Report Net, MDX Frame Work Manger, Report Authoring, Ad hoc Querying and Report Studio, Power-play Reports, Power-Play Enterprise Server, Access Manager, Transformer, Impromptu Reports, Automic Applications Manager

Other BI Reporting Tools: Hyperion Essbase, Business Objects, ARGOS Report, Crystal Reports, Script Editor

ETL Tools: ODI, Oracle Warehouse Builder, Data stage and Informatica

ERP: Banner, People Soft, Ultipro, Oracle

RDBMS: Tera-data, ORACLE, Microsoft SQL SERVER 7.0, SYBASE and ESSBASE

Languages: SVG, JAVA - J2EE 1.4, Java, Groovy/Grails Oracle SQL*Plus, PL/SQL, TSQL, SQR

GUI / Front-Ends: Developer/2000 (Forms, Reports), Tools SQL*Loader, SQL export, SQL import, Browser 2.1, Query Analyzer, Enterprise Manager

Operating Systems: Windows NT/98/95, MS-DOS 6.2, UNIX, HP-UX

RELEVANT EXPERIENCE:

Confidential

Sr Data warehouse Engineer

Technical environment includes: AWS, Linux, BANNER- ERP XE, People Soft Finance, Ellucian Power Campus, Operational Data Store ( ODS 8.5), ODS 9.0 / ODI - IA ADMIN tool, Oracle Warehouse Builder ( OWB ) and ODI, Student Information Systems, Financial AID, ORACLE 11.2.0.2, Microsoft SQL SERVER,, Cognos Report net 10.2..2 and Frame Work Manger 10.2.2 Ad-hoc Querying (Query Studio 10.2.2 ), Report Studio 10.2.2 and Oracle tools

Responsibilities:

• Involved in Migration process from ODS 8.5 to ODS 9.0 include migrate custom OWB mappings to ODI, custom objects, and custom scheduled jobs in IA ADMIN tool.
• Installed new environment on VM machines for ODS 9.0 with Oracle 11.2.0.2 database.
• Customized data freeze process and scheduling in IA Admin tool.
• Exported ODS data base for student information systems, Admissions data, and student course data into other data bases.
• Created, managed, customized, and tuned ETL scripts in a multi-threaded environment incorporating Oracle 11.2 g.
• Performed complex troubleshooting, root-cause analysis and solution development.
• Worked collaboratively with functional and technical data experts to balance functional reporting requirements with a robust technical design.
• Set up user accounts and roles, parameters, schedule processes, ran utilities, created materialized views, maintained freeze data, maintained data display rules via the ODS Administrative interface.
• Modified and created ETLs (Extract, Transform, and Load) from the following data sources to be stored in the colleague ODS: custom mods, baseline tables, external data sources (outside Banner).
• Wrote and Modified SQL scripts that define/amend the colleague ODS.
• Troubleshot and analyzed system issues, including thinking creatively to develop and test business process.
• Evaluated the need for and appropriately recommend future system enhancements and additional functionality.

Confidential, Davie FL

Solution Architect

Technical environment includes: Linux, BANNER- Operational Data Store ( ODS 8.5), Automic Applications Manager tool, Oracle Warehouse Builder ( OWB ), Student Information Systems, Financial AID, ORACLE 11.2.0.2, Microsoft SQL SERVER, from PLSQL to Java, Grails, Groovy/Grails , Cognos Report net 10.2..2 and Frame Work Manger 10.2.2 Ad-hoc Querying (Query Studio 10.2.2 ), Report Studio 10.2.2 and Oracle tools

Responsibilities:

• Involve business requirements gathering with end users, business analysts, managers and business directors and designing and develop Meta data model in Operational Data Store (ODS) from the ERP systems.
• Worked on migrating PLSQL into JAVA and Grails.
• Participated as a member of the Banner core team that is driving the success of the designing and developing REST APIs using Java, Grails implementation project.
• Outlined technical recommendations and identify technological requirements that support client’s job submission process for SIS and Finance modules and business goals.
• Defined and created technical standards, guidelines and quality control measures for enabling and implementing third-party software systems into banner system integrations.
• Planned and organized the software and systems installation and technical readiness activities.
• Involved in development of user material for the usage of Banner Applications
• Coordinated and communicated with technical services teams across the enterprise to facilitate effective and efficient project execution.
• Worked collaboratively with multiple subject-matter experts to support project success.
• Facilitated and supported the data conversion activities, the interface/integration activities, and the reporting, Version Control systems and portal implementation activities.
• Monitored and documented the technical aspects of ongoing projects and identified, documented, and mitigated significant technical project risks proactively.

Confidential, Manhattan, NY

Banner/ODS/Cognos - Solution Architect

Responsibilities:

• Provide technical leadership to assist clients with strategies for Enrollment Management tasks for a variety of clients implementing on SunGard HE Banner products.
• Monitor and document the technical aspects of ongoing projects and identify, document, and mitigate significant technical project risks proactively.
• Provide ongoing evaluation of technology solutions and capabilities to ensure appropriate alignment of business objectives.
• Provide ongoing evaluation of technology solutions and capabilities to ensure appropriate alignment of business objectives.
• Create interfaces from ODS and Banner data to third party systems on different data formats like CSV, fixed width column and excel or flat files.
• Create interfaces on PeopleSoft data using TSQL, SQL and Pl/SQL in procedures and packages in oracle and running using oracle schedules by hourly, daily, weekly, or monthly depends upon business requirements.
• Create new tables or insert data into existing tables in ODS from people soft and Fund-ware third party ERP systems for historical data into ODS.
• Use TSQL, SQL, PL/SQL programming in oracle.
• Create reports in subject areas like HR, Payroll, Research Finance, Grants, Budgets Accounts Receivables, Advancement, Student Information Systems, and financial AID on ODS and Banner data.
• Involve business requirements gathering with end users, business analysts, managers and business directors and designing and develop Meta data model in Operational Data Store (ODS) from the ERP systems.
• Provide material and hands on on Cognos reports with ODS data to end users.
• Design data mapping and interfaces between Banner, ODS.

Technical Environment: BANNER- ERP, Operational Data Store (ODS 8.5), ODS IA ADMIN tool, Oracle Warehouse Builder (OWB), Student Information Systems, Financial AID, ORACLE 11.2.0.2, Microsoft SQL SERVER, Cognos Report net 10.2..2 and Frame Work Manger 10.2.2 Ad-hoc Querying (Query Studio 10.2.2 ), Report Studio 10.2.2 and Oracle tools

Confidential, Yonkers, NY

Solution Architect

Responsibilities:

• Participated as a member of the Banner core leadership team that is driving the success of the Banner /ODS implementation project.
• Outlined technical recommendations and identify technological requirements that support client’s al and business goals.
• Defined and created technical standards, guidelines and quality control measures for enabling and implementing third-party software systems into banner system integrations.
• Planned and organized the software and systems installation and technical readiness activities.
• Involved in development of user material for the usage of Banner Applications
• Coordinated and communicated with technical services teams across the enterprise to facilitate effective and efficient project execution.
• Worked collaboratively with multiple subject-matter experts to support project success.
• Facilitated and supported the data conversion activities, the interface/integration activities, and the reporting and portal implementation activities.
• Monitored and documented the technical aspects of ongoing projects and identified, documented, and mitigated significant technical project risks proactively.
• Provided ongoing evaluation of technology solutions and capabilities to ensure appropriate alignment of business objectives.
• Performed ongoing evaluation of technology solutions and capabilities to ensure appropriate alignment of business objectives.
• Assessed options, risks, and cost-benefit analyses as pertains to data architecture, security, and other technology issues.
• Involved as Solution Architect for OBIEE and Argos reporting services on Banner/ODS data base.

Confidential, Columbia, SC

Lead Banner Developer

Responsibilities:

• Involved in Migration process from ODS 8.3 to ODS 8.5 include migrate custom OWB mappings, custom objects, and custom scheduled jobs in IA ADMIN tool.
• Installed new environment on VM machines for ODS 8.5 with Oracle 11.2.0.2 database.
• Customized data freeze process and scheduling in IA Admin tool.
• Exported ODS data base for student information systems, Admissions data, and student course data into other data bases.
• Created, managed, customized, and tuned ETL scripts in a multi-threaded environment incorporating Oracle 11.2 g.
• Performed complex troubleshooting, root-cause analysis and solution development.
• Worked collaboratively with functional and technical data experts to balance functional reporting requirements with a robust technical design.
• Set up user accounts and roles, parameters, schedule processes, ran utilities, created materialized views, maintained freeze data, maintained data display rules via the ODS Administrative interface.
• Modified and created ETLs (Extract, Transform, and Load) from the following data sources to be stored in the colleague ODS: custom mods, baseline tables, external data sources (outside Banner).
• Wrote and Modified SQL scripts that define/amend the colleague ODS.
• Troubleshot and analyzed system issues, including thinking creatively to develop and test business process.
• Evaluated the need for and appropriately recommend future system enhancements and additional functionality.
• Ensured accuracy, security, and confidentiality in maintaining database, Student, AR, Financial-AID, Financial, HR, Payroll, and associated records.

Technical Environment: BANNER- ERP, Operational Data Store (ODS 8.3 and ODS 8.5), ODS IA ADMIN tool, Oracle Warehouse Builder (OWB), Student Information Systems, Financial AID, ORACLE 11.2.0.2, Microsoft SQL SERVER, Cognos Report net 10.2.1 and Frame Work Manger 10.1.1 Ad-hoc Querying (Query Studio 10.2.1 ), Report Studio 10.2.1 and Oracle tools

Confidential, South Orange, NJ

Lead Banner/ODS/Cognos Developer

Responsibilities:

• Created and modified interfaces and reports on HR, Payroll, Student Information systems and Advancement modules, Academic probation, Admission and Students attributes, Student Course Catalog, Schedule Offering, Web and INB Registration process, and combined max SAT scores in Admission.
• Performed requirement analysis and gap analysis, coordinate with EDW team and BI architecture team to map BI capabilities with requirements and plan for new BI functionality.
• Provided technical leadership to assist clients with strategies for Enrollment Management tasks for a variety of clients implementing on SunGard HE Banner products.
• Created lot of interfaces from ODS and Banner data to third party systems on different data formats like CSV, fixed width column and excel or flat files.
• Created interfaces on banner data using TSQL, SQL and Pl/SQL in procedures and packages in oracle and running using oracle schedules by hourly, daily, weekly, or monthly depends upon business requirements.
• Created new tables or inserting data into existing table in ODS from banner data like some of data or table missing in ODS. SQL, PL/SQL programming in oracle.
• Created reports in subject areas like HR, Payroll, Finance, Accounts Receivables, Advancement, Student Information Systems, and financial AID departments on ODS and Banner data
• Involved in business requirements gathering with end users, business analysts, managers and business directors and designing and develop Meta data model in Operational Data Store (ODS) from the ERP systems.
• Designed data mapping and interfaces between Banner, ODS and EDW.
• Involved in development of user material for the usage of Banner Applications.

Technical Environment: BANNER- ERP, Operational Data Store (ODS 8.3), Student Information Systems, Financial AID, ORACLE 11.2, Microsoft SQL SERVER, Oracle Warehouse Builder, Cognos Report net 10.2.1 and Frame Work Manger 10.1.1 Ad-hoc Querying (Query Studio 10.2.1), Report Studio 10.2.1 and Oracle tools

Confidential

Banner Developer

Responsibilities:

• Worked directly with business users in understanding the information needs of the Day to day business.
• Captured and translated requirements through a variety of interviewing and analysis and facilitation techniques, to help create coherent design leading to successful data warehousing solutions.
• Participated in identifying the complete platform architecture and infrastructure to support business intelligence solution.
• Worked with business users, managers, stakeholders, customers, and project managers to gather and analyze the requirements for data warehouse projects.
• Participated in modeling, designing, developing, tuning and testing appropriate back-end structures and front end reporting tools to meet business requirements.
• Prepared Functional Specifications, Technical Specifications, process flows based on GAP analysis between existing system and new business requirements.
• Designed and developed strategies and test plans for various reports using Cognos.
• Subjects areas like Student Information Systems and financial AID departments.
• Involved in development of user material for the usage of Banner Applications.

Technical Environment: BANNER- ERP, Operational Data Store (ODS 8.3), Student Information Systems, Financial AID, ORACLE 11.2, Microsoft SQL SERVER, Oracle Warehouse Builder, Cognos Report net 10.2.1 and Frame Work Manger 10.1.1 Ad-hoc Querying (Query Studio 10.2.1), Report Studio 10.2.1 and Oracle tools

Confidential, Granville, OH

Cognos Architect Consultant

Responsibilities:

• Gathered, defined and documented business and non-functional requirements for Data Warehouse and BI Reporting projects while working as a Student Information System Functional Consultant.
• Supported the Oracle database and tools with review and installation of updates and patches.
• Worked directly with business users in understanding the information needs of the Day to day business.
• Captured and translated requirements through a variety of interviewing and analysis and facilitation techniques, to help create coherent design leading to successful data warehousing solutions.
• Participated in identifying the complete platform architecture and infrastructure to support business intelligence solution.
• Worked with business users, managers, stakeholders, customers, and project managers to gather and analyze the requirements for data warehouse projects.
• Participated in modeling, designing, developing, tuning and testing appropriate back-end structures and front end reporting tools to meet business requirements.
• Prepared functional specifications, technical specifications, process flows based on GAP analysis between existing system and new business requirements.
• Designed and developed strategies and test plans for various reports using Cognos.
• Designed and developed complex interfaces and reports using PL/SQL in colleague data and ODS data, also used embedded SQL in the Cognos for detail and complex reporting.
• Involved in development of user material for the usage of Banner applications.

Technical Environment: Colleague Operational Data Store (ODS), Student Information Systems, ORACLE 11.2, Microsoft SQL SERVER, Cognos report net 10.2.1 and Frame Work Manger 10.1.1 Ad-hoc Querying (Query Studio 10.2.1), Report Studio 10.2.1 and Oracle tools

Confidential, Fairfax, VA

COGNOS Architect Consultant

Responsibilities:

• Performed requirement analysis and gap analysis, coordinate with EDW team and BI architecture team to map BI capabilities with requirements and plan for new BI functionality.
• Installed and configured Cognos 10.2.1 on windows server 2008 machines with Oracle 11.2.
• Migrated existing Cognos 8.4 reports to Cognos 10.2 and gap analysis.
• Created Cognos reports using reports studio some of them like canned reports, standard reports with prompts and dash board reports with single or multiple query in following reports depends upon business requirements.
• Created Cognos packages using directly from transactional data and publishing to Cognos connection for dynamical reports.
• Created lot of interfaces from ODS data to third party systems on different data formats like CSV, fixed width column and excel or flat files for state of VA.
• Created interfaces on ODS data using SQL and Pl/SQL in procedures and packages in oracle and running using oracle schedules by hourly, daily, weekly or monthly depends upon business requirements.
• Created reports in subject areas like HR, Payroll, Finance and Accounts Receivables, departments on ODS and Banner data.
• Involved in development of user material for the usage of Banner Applications.
• Providing material and hands on on Cognos reports with ODS data to end users.

Technical Environment: SAP- ERP, Operational Data Store (ODS), Budgeting, Accounting, fund and payroll ORACLE 11.2.0, Microsoft SQL SERVER, Cognos Report net 10.2.1 and Frame Work Manger 10.1.1 Ad-hoc Querying (Query Studio 10.2.1), Report Studio 10.2.1 and Oracle tools

Confidential, Brunswick, MA

Banner Developer

Responsibilities:

• Created and modified interfaces and reports on Degree works, Academic probation, Admission and Students attributes, Student Course Catalog, Schedule Offering, Web and INB Registration process, combined max SAT Scores in Admission.
• Mentored and provided direction to application development staff in the creation and maintenance of system processes.
• Assumed project leadership capacity in the management of application development work and resources.
• Served as the subject matter expert for the ERP and systems that interface with the ERP.
• Assured systems quality and data integrity between Banner and ODS data base
• Modeled and architected information solutions for efficiency and effectiveness.
• Analyzed, developed, and maintained programs and procedures; prepares system analysis documents using structured methodology tools; develop new programs and processes.
• Researched discrepancies to the more complex application systems; considers developing new methods to achieve the proper results.
• Administered application systems with technical parameters to best suit customer needs.
• Collaborated with functional liaisons to establish technical specifications used to develop solutions.
• Established interfaces with the enterprise ERP and ancillary support solutions.
• Assured compliance with ITS procedures with regard to the project framework, development standards and change management processes.

Technical Environment: BANNER- ERP, Operational Data Store (ODS 8.3), Student Information Systems, Financial AID, ORACLE 11.2, Microsoft SQL SERVER, Oracle Warehouse Builder, Cognos Report net 10.1.1 and Frame Work Manger 10.1.1 Ad-hoc Querying (Query Studio 10.1.1), Report Studio 10.1.1 and Oracle tools