SUMMARY

16 years of experience in IT industry, 12 years of Lead data architect/ data/ business analyst experience in the areas of Finance, Retail, Supply chain, Manufacturing, data warehousing. Fast technology learner and constantly updating/adopting of current technology developments Extensive knowledge in building enterprise wide data warehouse applications using multidimensional Model, Cubes , dynamic web reports

Experience in Project Management methodology with full cycle of SDLC method in Client/server application in Unix/ NT/Novell Environment using regular databases like Oracle 9.0, SQL Server 2000 in Internet technology based projects. .

Good functional knowledge of all business processes, improvement and process re-engineering, mapping to system process design methods, technical architecture solutions

Skills

Professional Experience

Confidential

Sr. Data Architect

• Establish Enterprise architect model framework
• Involve in Enterprise data warehouse effort in identifying prime source systems
• Track enterprise ,level in data movement and data model standards using Erwin repository
• Grouping applications for business process, business and service applications including internal/external
• Enterprise data security, quality and naming standards

Environment : Oracle 11g , Mainframe, RAA, DB2, SQL server, Erwin, Unix, Sharepoint

Confidential

Lead/Data Architect

• Establish data design standards and reporting designs
• Establish data flow and data quality standards
• Develop complete ETL design and controls to load target tables
• Design logical, physical of Oracle 11g database with metadata information
• Pilot Project on Hadoop using Cloudera/Hbase/Pig /SAS/R
• Lead Oracle BI report development and user training
• Maintain all the project contract, software development, security compliance documentation and follow the submission guidelines NIST, FEAF
• Maintain the source and data objects standards and version controls

Environment : Oracle 11g RAC, ODI, OBIEE, ArcGis, Web Services and SOA suite, Hadoop, Erwin, Unix, Sharepoint

Confidential

Lead/ Data Architect

• Design fact and Dimension tables based on the source Claims and Enrollment data
• Conversion/migration from COBOL flat file to DB2 Target table for reporting collection
• Design logical, physical of DB2 Report database with metadata information.
• Create data mapping , ETL specs for loading from flat file into DB2 target tables
• Analyze new report requirements and review the target tables design
• Define Data Architecture standard and data definitions
• Define and capture the data aggregation, transformation during ETL documentation
• Involved in HIPPA 5010 project requirement data design changes for reporting team

Environment : DB2, COBOL, Mainframe, DB Studio, Netezza, Rocket shuttle, Informatica, Erwin, Unix, Sharepoint

Confidential

Lead/ Data Architect

• Develop project scope, data migration plans for Retail and Finance Datamart
• Design fact and Dimension tables based on the source Retail and Finance data
• Plan and schedule the mapping for data load in DEV and Prod servers
• Review logical/physical model, table re-org/design, sql-execution plan, indexes, database memory parameters, disk cache sizes, disk storage area size, through put rate while executing reports as performance improvement
• Create data mapping for Retail and Finance Datamart using OWB
• Analyze new report requirements to match ETL load mappings
• Define Data Architecture and EIA standard and data definitions
• Define and capture the change process in ETL mapping for documentation

Environment : Oracle10g, OWB 10.2 RAC , ERWIN, Unix, Clear case Tools, Sharepoint

Confidential

Lead/Data Integration Architect

• Develop data mapping for interface requirements with standard Canonical data model
• Maintain/update logical/physical Data model according to naming standards and grouping by functions
• Involved in MDM, Data governance, data quality process
• Create Datwarehouse mappings using OWB connecting different source systems
• Create XSD schemas, WSDLs and validate using XML Spy
• Create mapping for request/response schemas, XSLT using Contivo Analyst, Mapforce
• Generate application design document for interface developers using Data power
• Participate in interface impact sessions to identify affected data elements and systems
• Participate in requirements sessions to study/analyze the interfaces impact

Environment Oracle10g,, ERStudio,XML Spy, Contivo, SQL server 2005, Unix, MS Project, Clear case tools, Microstrategy, Abinitio

Confidential

Lead/Sr Business/Data architect

• Develop project scope, data migration plans from people soft HR to ADP external systems
• Study impact on Data warehouse and staging tables due to migration
• Review table re-org/design, sql-execution plan, indexes, database memory parameters, disk cache sizes, index clustering factors, through put rate while executing reports as performance improvement
• Create data mapping for ADP system to Data warehouse using OWB based on SOA
• Organize the data dictionary effort covering all it systems in the organization
• Setup data quality and data flow rules between upstream and downstream applications
• Setup plan for data conversion in existing dimension and fact tables to accommodate the index data value changes due to outsourcing of People soft payroll system
• Organize SQL server DTS packages, sharepoint folders and access management

Environment : Peoplesoft HR, Oracle10g, ERStudio, SQL server 2005, Unix, MS Project, Clear case tools, Visio, sharepoint , Informatica, Microstrategy

Confidential

• Responsible for change/maintain logical/physical models and generate ddls to implement the change in database DB2 8.1 ,Sybase 12.5, Oracle
• Manage change control and maintain project artifacts in clear case and clear quest tools as per standard SOX compliance
• Follow data abbreviation standards using metadata repository rules in logical and physical modeling for project using web services and XML schema for interfaces
• Discuss business requirements and guide the team in data redundancy, storage, performance while changing the data models
• Identify/document data aggregation, facts and dimensions for data warehouse module and enhance reporting Options
• Participated as Lead in asset based security systems, loan evaluation system, custom fee assessment, credit risk rating system, credit enhancement system, guiding the team in changes and interact with the technical team to implement the changes according to the project time line
• As a Project Team lead created and monitored the MS Project Project tasks, task execution, delivery to user, End User support/interaction, change management, interact with operation team in production support
• Review table re-org/design, sql-execution plan, indexes, database memory parameters, disk cache sizes, index clustering factors, compare database reports with various settings as performance improvement

Environment : Mainframe, Sybase, DB2, oracle, Erwin, Unix, MS Project, Clear case tools, Visio, Lotus notes, Web services, DB Artisan, Micro strategy, Datastage, Clearcase/Clearquest

Confidential

Project Lead/Data Analyst

• Study existing data warehouse models to improve the coverage with new sources
• Maintain the logical and physical models and metadata repository in line with corporate data naming standards
• Project Lead for ETL development using Informatica managing ETL developers, data analysts and testers using OWB
• Identify the outstanding business requirements to finalize with the users and technical groups
• Prepare business requirement for the new request coming from users and update in requirement database
• Discuss with the vendor about the progress of open and closed business requirements
• Gather requirements from various business users and turn into system specs and prepare project plans
• Designed and documented complete enterprise data warehouse architect framework facts and conformed dimensions, data quality procedures ,logical and physical database models to be implemented by phases
• Lead for Business Objects and Micro strategy reporting project for accounting, client management users
• Work with data warehouse ETL team to enhance the data quality, performance and loading issues

Environment: DB2 8.1 , NT/2000, Unix/AIX, Oracle 9i, Java, Toad query tool, Informatica, Cognos 7 tools, Web services, Microstrategy, ERStudio, Business objects, Erwin, Visio

Confidential

Project Lead/Sr Data warehouse Consultant

• Design data validation templates for data integration from legacy systems to new Order management application
• Define interface validation rules/testing scope for interfaces to sales, order and inventory systems
• Identify/document data aggregation, facts and dimensions for data warehouse module and enhance reporting Options for project using web services and XML schema interfaces
• Support project designing EDI interfaces, EDI file pickup with payment servers using mainframe, AS/400
• Define Metadata templates in DSS environment and ways to improve metadata representation using Informatica add-on tools
• Define data architecture, Data modeling, building fact and dimensional tables using Informatica designer/workflow for enterprise data warehouse decision support systems
• Work on data profiling/cleaning/transforming using Oracle/Toad query tool, build up validation rules for data migration
• Maintain/monitor Project Plan tasks and review in the team meeting
• Lead reporting project using Impromptu, Powerplay, web reports using Cognos 7
• Work with data warehouse ETL team to enhance the data quality, performance and loading issues

Environment: AS/400, NT/2000, Unix, Oracle 9i, DB2/UDB, Java, Toad query tool, Informatica 6.0, Cognos 7 tools, SAP, Access 2000, Business objects, Erwin, Visio, web services, Business Objects, Microstrategy, OWB

Confidential

• Client feasibility study, Business Analysis , Project Management, Roll-out Plan, Implementation, Role in Data integration and migration, configuring Retail Merchandising software Product, and design for data mart requirements
• Team Lead in Data management in migration, transformation and matching with current business requirements traveled to Japan, HongKong to meet users
• Developed interface file formats for financial systems GL, AP
• Responsible for create and design of data mart tables Star Schema design using SQL 7.0 server, Options using Data Transformation services, , DTS import/export Wizards, clustered index analyzer wizards, SQL server query processor/ analyzer,
• SQL server Enterprise manager, MS Olap services cubes , Web Assistant Wizard, Access 97, Impromptu/Power Play etc. Used SQL Server performance objects for maintaining and tuning of data warehouse, replication, multi server options, Raid option for failsafe etc.
• Developed project plan and implemented using MS Olap datamarts for Pricing and promotion user group

Environment: NT Server with SQL 7.0 /Access 97/VB 6.0, IBM Intel based server ,IBM POS