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

Some project experience running concurrently

Professional Experience

Confidential

Sr. Data Architect/Enterprise Architect

• 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, MDM and TOGAF
• Open payments Health care project as data architect transaction and Datamart
• Data Planning preparation for Big data Pilot project using Cloudera/Apache/Hbase/Pig/R
• Devloped/configured/designed Hadoop datawarehouse /Oracle

Environment : Oracle 11g , Micro strategy 9.4, DB2, SQL server, Erwin, Unix, Sharepoint, Bigdata Cloudera, Hive, Hbase, R/SAS,

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
• Project on Hadoop using Cloudera/Hbase/Pig /SAS/R/Apache
• 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, Bigdata Cloudera, Hbase, R/SAS Data Mining

Confidential

Lead/ Enterprise 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 for MDM in TOGAF standard
• 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 in DODAF standard
• 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

• Building various API interfaces using web services for various business groups and as well as for external vendors common usage to facilitate data interchanges in common XML/XSLT format.
• 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 in TOGAF
• 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

Lead/Data Warehouse Consultant

• Creating technical specifications, data flow diagrams, logical modeling and physical modeling using Erwin, applying normalization procedures, matching the models with business requirements
• Support project designing EDI interfaces, EDI file pickup with payment servers using mainframe, AS/400
• Leading JAD sessions with business users in scope and design meetings, gathering business users requirements, developed work flow diagrams, use case analysis, system scope and coverage in phases
• Data aggregation models Ralph Kimball methods using Informatica Power center 6 and Power Connect ETL data integration/ staging tool for Consumer products division.
• Involved in designing Enterprise Data Warehouse Dimensions/subject areas from legacy databases Supply chain from AS/400 5.1, DB2 8.1 , Oracle 9, SQL server 7/2000. OLAP Cube design using DB2 OLAP/ESSBASE
• Team Lead for Data aggregation models using Informatica Power center 6 and Power Connect ETL data integration/ staging tool for Consumer products division.
• Solution with Informatica Power mart/power analyzer for warehouse and logistics users, connecting legacy system and Olap cubes star schemas and tested the performance against AS/400 data.
• As a 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

Environment : AS/400,IBM Mainframe, NT/2000, DB2/UDB,Oracle 9i,DB2/UDB, MS office tools, Erwin, Visio, Informatica 6 tools, Cognos 7 tools, Business objects, ERStudio, Business Objects

Confidential

• Involved in outsourcing supply chain project Logistic, Manufacturing, Warehousing, distribution, Finance/Accounting for the Asia Pacific Region covering Business and IT functions. Oracle 11 Applications Modules and Oracle Data warehousing tools
• Team lead responsible for consolidating Region and Country Business requirements and drafting IT scope and requirements and implementing using SDLC methodology and documentation
• Defining and consolidating dimensions and aggregations from supply chain systems using star/snowflake schema , managed data dictionary and meta data
• Designed ER diagrams, logical model relationship, cardinality, attributes, and, candidate keys and physical database capacity planning, object creation and aggregation strategies as per business requirements using Erwin and OWB
• Involved in preparing the Bid documents IT Functions for the outsourcing Prepared hardware architecture and data flow for the supply chain
• Team lead in Informatica Power mart 6 and Power analyzer Project for users in Asia using Oracle database
• Team lead in Cognos Enterprise reporting project having Impromptu, Powerplay, Visualizer, upfront to access the different OLAP cubes, OWB

Environment : NT/2000, UNIX, Oracle 9i,OWB, MS office tools, Erwin, Visio,