Summary:

• Sixteen years of software experience with over six years of technical lead & managerial experience in data warehouse development as Business Intelligence/ Data Warehouse Manager, Architect
• Extensive experience in software size estimation, cost and resource estimation, RFP - proposal writing, due diligence study and preparation of statement of work and project management skills, technical presentation, client liaison
• Architected data warehouse from requirements gathering to conceptualisation to creation of data marts using Inmon and Kimball methodologies
• Expertise in Conceptual Data Modelling, Enterprise Data Modelling, Logical Data Modelling, Physical Data Modelling, Enterprise Data Warehouse Design, Datamart Design, Metadata , Data Quality , Master Data Management and Data Governance
• Hands on experience using various ETL tools such as SQL Server SSIS, Informatica, SSAS analysis services for OLAP cube creation, SAP Business Objects, Oracle Business Intelligence OBIEE
• In depth and thorough knowledge of development and design with RDBMS -OLTP, dimensional modelling using data modelling tool ERWIN, Sybase PowerDesigner. Involved in analysis, development and migration of Stored Procedures, Triggers, Views and other related database objects with solid experience in MS-SQL Server 6.x to 2008, Sybase 10.12 , Sybase 4.2 and Oracle, IBM-DB2 .
• Experience in various technologies - In depth experience with client server technologies on PowerBuilder ; Internet technology - Java
• Implemented and lead projects at all stages of SDLC.Managed offshore onsite resources
• Good working knowledge of Unified Modelling Language (UML) for Object Oriented Analysis & Design methodologies, Rational Unified Process -RUP & Extreme Programming -XP, Agile Development
• Proficient in SEI-CMM standards of quality assurance. Good knowledge of GISB, SOX,HIPAA standards
• Excellent documentation skills for database design document, technical design document,
• Project Management course at UTD, earned the requisite PDUs to qualify for PMP certification
• Engaged by several clients to understand and reengineer their business processes
• Experienced in various verticals- Oil and Natural Gas, Health Services, Insurance, Finance, Transportation, Sales and Marketing
• Excellent interpersonal and communication skills.

Technical Skills

Data warehousing - SSIS - 2008 ,Informatica ,OLAP -SSAS 2000,2008 -Reporting - SAP Business Objects, Cognos, Crystal Reports, SSRS, MDX Query, DTS, Oracle Business Intelligence OBIEE
Database - Sybase 12, Sybase 10.0 Sybase 4.2 , Oracle 7.0/Unix, MS SQL Server 6.x to 2008, DB2-V7.1
Database Design - Normalized and Dimensional Modelling (Star and Snow Flake)
Software Architecture - Object Oriented Design (UML), Corporate Information Factory (CIF),Data warehouse BUS Architecture, Rational Unified Process, Extreme Programming, Agile Technologies, knowledge of SOA (Service Oriented Architecture), Master data management, Metadata management

Software sizing and estimation - Function point method, Object size count
Internet Development- JavaScript, HTML, Java Script , XML, Java Web Server ,IBM-Visual Age For Java, Microsoft IIS WebServer, Weblogic 5.1,6.x(BEA systems), Versata 4.1/5.0 , MS-Visio, Rational Rose,Java 1. 2, J2EE
Client/Server Development - Power builder, MS SQL Server, Sybase 10, Oracle 7/8
Project Management Tools - MS- Project, MS-Word, MS-Excel, MS-Outlook

EXPERIENCE

June 2007 - July 2009
Confidential
Data Solutions Manager / Architect

• Lead projects at various stages from requirements gathering and business rules analysis to creating physical database model, SSIS/SSAS development ,BO Universe Architecture and Reporting.
• Lead and improvised existing Enterprise Data Warehouse
• Instrumental in creating process , procedures, policies and standards for data warehouse implementation
• Creating/ Managing the project plan, task allocation, work with stake holders and PMO office for achieving project goals in an agile work environment
• Responsible for project planning, scope management, resource estimation, metrics definition, change control process, define data quality process and standards, verification and validation.
• Designed architecture for SSIS implementation and cube creation using SSAS
• Co-ordinate with business owners, DBAs, reporting team to address system improvements
• Managed the project in breaking down the existing EDW to manageable data marts
• Mentored individuals from business and technical stand point
• Instrumental in creating an in-house tool for meta data and data governance for quality purposes
• Responsible for Data Modelling, Architecture, Production support and migration to SQL Server 2008
• Hands on SSIS, SSAS development and production support of around 32 data marts and the Enterprise Data Warehouse, Meta data and Universe creation for reporting
• Hands on architecture and creation of Business objects universes, cube universe, business views for Crystal reporting, developed Webi reports, security implementation , basic administration

Sybase PowerDesigner, DTS ,MS-SQL Server 2000/2008 - SSIS and SSAS, SSRS, MDX, SAP Business Objects XIR2, MS-Project, MS- Word and Excel, Team Track, Team Foundation Server, VSS, Corporate Information Factory, Data Warehouse Bus Architecture

Jul ’06 - Apr ’07
Confidential
Claims Processing System
Data Warehouse Architect

• Architected and implemented facts and dimensions for data mart
• Developed, modified, and optimized complex queries for data retrieval and modification.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time
• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications
• Designing process flows, deploying and populating staging area objects defining and populating the Enterprise Model Warehouse
• Architected meta data layer, universe creation and reporting
• Basic DBA activities such as backup and restore database, indexing

ERWIN, SSIS, Business Objects, MS-Sql Server 2005, Data Warehouse Bus Architecture

May’04 - May ‘06
Confidential, Addison, Texas
Billing and Collection System
Lead Systems Analyst

• Production support and enhancement of existing PowerBuilder application for Billing and Collection System
• Performed business analysis and architected data mart design for reporting
• Created and implemented facts and dimensions for data mart
• Designed processes to Extract, Transform and Load data for reports
• Worked on large amount of transactional data and optimized data retrieval procedure
• Enhanced existing database design
• Implemented Sarbanes Oxley Security standards for the application
• Documentation as per SOX / company standards
• Knowledge of HIPAA regulations

Sybase 12 / UNIX 8.0, ERWIN, PowerBuilder 9, MS-Visio, T-SQL

Jan’03 - Mar ‘04
Confidential, Connecticut
Reinsurance System
Data Architect / Project Lead

• Worked in the role of project manager and architect handling cross functional teams
• Involved in scoping of project and suggesting cost effective means of maintaining application or parts of application
• Preparation of Statement of work and related Service Level Agreement for the suggested projects
• Involved in resource allocation, costing for the suggested projects
• Participated in due diligence study of various prospective projects
• Involved in development and maintenance of in-house Master Data Management tool for Customer, Account and Location Information
• Responsible for project planning, scope management, resource estimation, metrics definition, change control process, risk management, verification and validation, final project closure and hand off.
• Involved in requirements analysis and design of data mart
• Performed Extraction, Transformation and Loading data into data mart. Created procedures, triggers and views appropriate to business logic
• Created Logical and physical model for newly added business features using ERWIN
• Developed mappings using various transformations like expression, aggregator, joiner, sequence generator, router and filter.
• Universe architecture design and Report creation and generation from the data mart

ERWIN, Informatica Power Center 6.x, Business Objects, PowerBuilder 6.x/ 7, Sybase 12/UNIX, T-SQL

Apr \'02 - Dec’02
Confidential, Victoria, Australia
DALS-Driver and Licence Status System
Technical Lead/Project Lead

Responsibilities

• Participated in JAD sessions for business requirements gathering for the project.
• Created logical and physical database design for the middle tier database (OLTP) in DB2 using ERWIN.
• Involved in planning, defining and resolving technical issues for scalability, maintainability and reusability.
• Designed class hierarchies and distributed components in keeping with IBM’s framework for various classes based on OO techniques and extensively used factory and command patterns.
• Used UML extensively for specifying, capturing, communicating and documenting the application with class diagrams, state diagrams and sequence diagrams.
• Involved in complete SDLC application development in keeping with SEI-CMM standards.
• Fine-tuned the application for performance and load.
• Team formation and allocation of tasks and mentoring team members.
• Performed various user acceptance tests to check conformance of the application with requirement.
• Interacted and communicated with client to resolve functional issues.

Java 2 Platform, JDBC 2.0, DB2 7.1,IBM-Websphere 3.5.5, Visual Age for Java 3.5, Rational Rose ,LDAP,PVCS Version Control and Tracker 6.6,Mercury Load Runner, Windows NT 4.0

Jul \'01 - Jan ‘02
Confidential, Houston, TX
TAI Integration - Contracts and Accounting
Technical Lead / Weblogic Administrator

Responsibilities

• Analysed the business requirements of the project to arrive at suitable transformation requirements
• Involved in planning, defining and resolving technical issues for scalability.
• Designed class hierarchies using inheritance / interfaces for various utility classes based on OO techniques.
• Analysed the distributed components required for the application in keeping with J2EE architecture to arrive at better flexibility.
• Used UML extensively for specifying, capturing, communicating and documenting the application with use-case diagrams, class diagrams and sequence diagrams.
• Upgraded Weblogic server across development and test machines to perform testing
• Analysed, developed, tested and deployed Session and Entity Beans to suit the business requirements.
• Team formation and allocation of tasks and mentoring team members.

Java 2 Platform, JDBC 2.0, Oracle 8.0,WebLogic Server 6.1,EJB 2.0, JBuilder 5.0, TIBCO Integration Manager 3.2, Active Database Adapter 3.3, Windows NT 4.0

May \'01 - Jun\'01
Confidential, UT
Consumer e-Finance, Financial Fusion Server
Weblogic Administrator

Responsibilities

• Tuning Weblogic Server for better endurance and stability
• Ran consistent load tests to test server performance under varying load conditions.
• Reading thread dumps from Weblogic, noting various errors and fixing them to help keep the server run error free
• Profiled the application for determining bottlenecks.
• Determined different bottlenecks in the application and suggested remedial measures for the same.
• Monitored the Weblogic , content and other related in-house products to determine and subsequently enhance performance.
• Suggested and executed code changes in the Java application and database for performance fine-tuning.
• Involved in making changes and suggestions on the operating system to achieve better performance.
• Ran duration test against Weblogic on different versions of java under different scenarios for benchmarking purposes.
• Separated one single service into different counterpart services to enable better resource management and load balancing.

Java 2 Platform, JDBC 2.0, Servlets, MS SQL Server 7.0,T-SQL, WebLogic Server 5.1, Java Profiler, Alfred XML Parser ,Microsoft IIS 4.0,Mercury Load Runner , Windows NT 4.0

Jan \'98 - May’01
Confidential, El Paso, TX
Passport Energy Services - Scheduling
Lead Systems Analyst

Responsibilities

• Created / Enhanced existing data model (OLTP) as per business enhancements using ERWIN.
• Created stored procedures, triggers and views.
• Participated in data warehouse business analysis sessions and involved in data mart creation from conceptual to physical design.
• Extract, load and transform data into data mart
• Report generation using Crystal Reports, Cognos
• Involved in studying the transition of Power Builder system to Java based web enabled system
• Involved in planning sessions, architecture sessions during the project lifecycle.
• Created UML diagrams for specifying, visualising, communicating and documenting.
• Involved in different stages of System Development Life Cycle from defining, designing and developing the new system to testing evaluating and maintaining the system .
• Was responsible for making detailed analysis of the various existing and newly added database objects for integrating with the system.
• Performed data transformation services (DTS) and bulk inserts.
• Mentored group of programmers.

MS-SQL Server 6.x, 7.0, 8.0,T-SQL, ERWIN, Cognos Impromptu, Crystal Reports, PowerBuilder 5.0, Java 2 Platform, Versata Server 4.1/5.1, MS-Visio

Apr 95 - Jan 98 - Developer - Project Lead
PowerBuilder, MS SQL Server 6.x /Sybase/Oracle / AS-400, Windows 95, Robo - Help, Unix

Educational Qualification:
Bachelor of Engineering
UTD - Project Management course