Qualifications Profile Summary:

• 20 years of experience in database design, architecture development, and integration talents, resulting in stable, scalable, and secure database-driven systems.
• Demonstrated experience in Enterprise Data warehouse design using Star Schema, Extended Star Schema, and Snowflake schema dimensional models.
• Extensive knowledge in developing the ER Conceptual/Logical/Physical data model for the transactional systems
• Installation and Administration of the IBM InfoSphere CDC services on BODS/Oracle/Informix servers.
• Experience in configuring the Apache MQ servers for staging the XML files for Real-Time ETL process
• 10 years of experience in Business Objects CMS/CMC administration, Universe Reports development and deployment using DeskI and Web Intelligence solutions with BO XIR2/3.1/BI 4.0.
• 3 years of experience in developing the Corporate dashboard using the custom built web services and Business Objects QAAWS with Xcelsius 2008/ Dashboard Design
• 10 years of experience in data extraction, transformation, and loading ETL to the ODS and staging environment using the BODS, SSIS packages and OWB.
• Migration experience from BO XI R2 to BO XI 3.1 and BO BI 4.0
• 10 years of experience in developing and administrating the Crystal reports Enterprise and XI R2/3.x.
• 15 years of experience as a Primary SYBASE 11.x/SQL Server 2000/2005/2008R2 DBA.
• Years of experience in the Information Technology industry including custom development as a Programmer, Systems Analyst, Project Lead and Project Manager
• Managed full life cycle Custom Development SDLC for several business applications from inception to completion.
• Highly adept at promptly and thoroughly mastering new technologies and adapting to existing corporate infrastructures, producing results immediately on hire in cross-functional IT roles.
• Exceptional interpersonal and customer relationship skills serve as liaison between technical teams, business representatives, client management, and users.

Technical Background

• OS Platforms: UNIX Solaris, HP-UX, AIX, SCO , Linux, Windows NT/2000/2003/2008R2, OpenVMS
• Databases: Oracle 9i 10g RAC, Informix 11.x, SQL Server 2000/2005/2008 R2, Sybase 11.x,
• Languages: VB, VB.Net, C, Java, JavaScript, HTML, UNIX shell scripting, JSP, ASP, XML
• Application Servers: Apache, Oracle Application Server, Web Sphere, Cold Fusion, Microsoft IIS
• Modeling Tools: CA ERwin, S-Designer, Oracle Designer
• CDC: IBM InfoSphere CDC 6.x 10.x, Access Server, Management Console
• Data Management Tool: Toad, SSMS, DBArtisan, SQL Server BIS
• Reporting Tools: Crystal Reports 9/10/XIR2/2008/2011, Oracle Reports, R R Report Writer
• OLAP Tools: Business Objects, Info View, WebI, and Oracle Discoverer, Crystal Reports
• Dashboard tools: BO Xcelsius 2008, BO Dashboard Design BI 4.0
• ETL Tools: Business Objects Data Services, MS SSIS, Oracle Warehouse Builder OWB

.

Professional Experience

Confidential

Enterprise Data Warehouse Architect

• Designed Enterprise Data warehouse EDW for all 204 bankruptcy, district and appellate courts and collecting the transactional data from Case Management/Electronic Case Files CM/ECF system.
• Designed and developed Data Marts for CGI's Momentum /Judiciary Integrated Financial Management System JIFMS application.
• Responsible for designing the Conceptual, Logical Dimensional modeling and get approved from the business domain experts.
• Implemented the Real-Time ETL process using IBM InfoSphere CDC to support EDW.
• Data Profiling and Data Modeling for the Case Management/Electronic Case Files CM/ECF system.
• IBM InfoSphere CDC installation and administration for the Real time process on BODS/Oracle/Informix servers.
• Configure and maintain XML Schema, Message subscriptions and Message XML destinations for the CDC
• Configuring and administrating the Apache MQ server for the Real time XML queues
• Configuring and Administrating the BODS Real time Services and Adapter Instances
• Preparing the Data Dictionary for each subject area with ETL mapping documentation
• Develop and Implement the ETL technical architecture, data acquisition techniques and decision rules
• Implements the Entity Attribute standards and work with DBA to implement the strategy for the SQL query performance tuning.
• Work with BO Architect to implement the row level security to access multiple court records to support the EDW architecture for every subject area
• Establish and enforce technical standards and Define meta data standards for the data warehouse
• Develop Best Practices documents for data dictionary, MDM, ETL

Confidential

Data Warehouse / Business Objects Architect

• Reengineered security and management tasks to suit clustering environment.
• Experience with Business Objects Data Integrator, Application Foundation Dash board and VBA.
• Developed the custom web services and used Business Objects QAAWS to create the Xcelsius Dashboard
• Designed and developed the Enterprise Dashboard using Xcelsius to provide the performance monitoring and performance management with KPI to the executive management.
• Managed full life cycle custom report development for several business applications from user requirement to signoff to the production environment.
• Experience in creating the Crystal reports all versions for the operational and analytical reports.
• Experience in developing the operational and analytical DeskI/WebI reports using different data providers
• Query performance improvement in the Universe design using the Keys, filters compatible objects
• Designed and developed the Universes for different functional application modules and resolved the Loops, Chasm traps Fan traps using alias and contexts.
• Design and developed the ER logical and physical data model for the Qatar Scholar Management System and Enterprise Scholars Student applications
• Developed several ETL SSIS packages and scheduled to extract the data from the SAP FICO module and loading the data to the SAP Financial data mart.
• Developed the data warehouse dimensional model for SAP Financial data mart to support the analytical and BI reports.
• As a Data Architect, responsible for designing the ER logical model Dimensional modeling and get approved from the business domain experts.
• Experience in Business Objects Enterprise XI R2/3.1/ BI 4.0 installation and security, User and server administration and maintenance
• Administrator for Business Objects BO and Crystal Enterprise servers managing over BO Servers in multiple locations supporting several hundred users.
• Server migration experience from XI R2 to XR3.1 and BI 4.0 configurations
• Experience in MS SQL Server administration with HA architecture and DR setup with log shipping.
• Analyzed query patterns of 3rd party application and recommended improvements.
• Improved space management and monitoring to meet expansion needs and streamline the effort required.
• Communicate with all the application users in solving all the issues related to the application.
• Recommended improvements to existing applications to meet performance and scalability requirements.
• Prepared the different type of drill down analysis reports to provide the detailed visibility about the Students and Scholars programs and financial responsibility.
• Design and developed the various analytical reports for state and federal education departments.

Confidential

Project Lead/ Data Warehouse Architect

• Managed multiple projects in development through the Logistics management system.
• Implemented workflow driven business integration engine to capture, route and process orders automatically from multiple systems
• Designed and developed the dimensional data model using Star schema and Snowflake schema
• Designed and developed the Dashboard and Scorecard to provide the performance monitoring and performance management with KPI to the executive management.
• Provide the visibility about the performance associated with a company's strategic objectives and plans.
• Designed the Conceptual, Logical and Execution architecture to implement the Logistics system.

• Design and setup the Staging and Operational Data Storage ODS environment for the enterprise data warehouse including the Dimension and fact table design using Kimball's Star Schema approach.

• Design and developed the End user Layer and Workbooks to support the Discoverer OLAP development to provide the visibility to the top level management.

• Design and deploy the ETL functionalities using the OWB from the various data sources to the oracle environment to build the data marts, dimensions and fact tables.
• Design and configure the Stage, ODS and DSS schemas and involved in creating the ETL scripts and data acquisition from different data sources, data cleansing and metadata management.
• As a Discoverer Administrator, developed and maintained the entire the end-user layers and provide the security privileges for the discoverer plus users.

Confidential

Principal System Architect /Business Objects Designer

• Responsible for System study and designing the Logical Model and Physical Data Model of the project. The system is being developed Power Builder as front end and SYBASE 11.9 as the back-end database server.
• Responsible for Design and development of the On-line Project Management System for the Fulbright Senior Specialist Program FSSP This system enables Post/Commission officers to submit the Project proposal and The Bureau of Educational and Cultural Affairs ECA officer CIES officers will review the scope of the project and approve.
• Developed an internal web system for implementing the Student and Exchange Visitor Information System SEViS . SEVIS system provides tracking, monitoring, and access to accurate and current information on non-immigrant students F and M visa and exchange visitors J visa .
• Responsible for Design and development of the On-line Award Book module. In this module the system will generate the Dynamic Html pages from the Database tables and maintain the proper link between World Areas and their countries based on the related award information
• Responsible for Design and development of the On-line application module for the American scholars These scholars can directly enter their application information through the web module and review committee people will submit their review statement against each scholar. After that this scholars is recommended for getting the Grant from Department of State. This system has developed using the Cold fusion server.
• Having extensive experience in OLAP tool Business Objects installation Administration. Responsible for migration of the product from version 4.1 to 5.1 and related Universes and scheduled reports. I am administrating the BO Account server and Web Intelligence Server. I am the responsible for creating Universe for the Whole Fulbright System and posted into the Infoview server.

Confidential Project Lead/DBA

• Responsible for the successful implementation of a Production Planning and Control System, Foundry Production and Rejection Analysis System. This system tracks daily raw material consumption, production and rejection details are keyed in. This system is provided reports with Production, Rejection analysis based on Raw Material consumed, Department rejection analysis, rejection cause wise, customer rejection analysis based on dispatch. It keeps track maximum production rate in each department against the request given by Sales department. Production scheduling is prepared on machine and manpower resources. If demand is high, it prepares request list to submit to the Sub-contractors.
• Responsible for the successful implementation of an Accounting System. This package is developed with master files such as General Ledger, Debtors Creditors and Transactions that include Cash, Bank, General Journal Vouchers, Sales Vouchers from Sales Order System and Purchase Vouchers from Purchase Order System. Cash/Bank day Books, Sales Purchase Ledger, Creditors Debtors Ledgers, Balance Sheet, P L Balance Sheet are provided with this system. This system has implemented in all Branch Offices using Watcom SQL with VB 3.0.
• Responsible for the design and development, and coding and implementation of and Inventory Tracking System. This inventory Model is based on an unlimited nested layers bill of materials with bill of process built into the structure. It includes Receipts, Issues and returns of Raw Materials WIP and finished goods can be logged in and tracked on line.

Confidential Programmer/System Analyst

• Implemented an Employee Details System. This Package is used to maintain Employee master details, Department master Details and Constants such as PF, ESI, HRA, CCA, LTA, Medical Allowance, and DA. Monthly Attendance details, Deduction details and Earning details are entered for each and every employee. Using this system Employee's pay slip, pay statement, Pay Abstract ESI statement, PF statements are prepared.
• Implemented a package consisting of Financial Accounting, Daybooks, Accounts Receivable and Payable, Ledgers, Trail Balances, Profit Loss Account, Balance Sheet, Budgeting etc. System was developed using Unix, Oracle, and C programming. Primary responsibilities included coding and testing.
• Used Oracle Forms and Reports to build an on-line System. Developed the Modules such as Inventory Control Stores Accounting and Purchase Order Processing.