SUMMARY

• Data Architecture: business requirements definition, enterprise strategy and architecture, guidelines and standards, process/data flow, conceptual / logical / physical design, performance, partitioning, optimization, scalability/throughput, data quality, exception handling, Metadata, Master Data design and implementation, auditing, capacity planning, etc.
• Data Warehousing: Full life - cycle project leadership, business-driven requirements, capacity planning, gathering, feasibility analysis, enterprise and solution architecture, design, construction, data quality, profiling and cleansing, source-target mapping, gap analysis, data integration/ETL, SOA, data marts, Kimball methodology, star/snowflake design, ODS, Data Marts.
• Business Intelligence: Requirements analysis, Key Performance Indicators (KPI), metrics development, sourcing and gap analysis, OLAP concepts and methods, aggregates / materialized views and performance, rapid prototyping, tool selection, semantic layers.
• Application DBA in Data warehousing environment in SQL Server, oracle, MySQL, Teradata.
• Experience in leading the team of DBA, application, ETL, BI developers.
• Well versed with all phases of SDLC, quality process and procedures like business requirements definition, enterprise strategy and architecture, guidelines and standards, process/data flow, conceptual / logical/physical/design, performance, partitioning, optimization, scalability / throughput, data quality, exception handling, Metadata, Master Data design, implementation, auditing, capacity planning etc.
• Significant experience in Data Modeling for OLTP, dimension modeling for data ware house like Star Schema, snowflake schema and MDM.
• Responsible for detail architectural design.
• Responsible on Source to target mapping and traceability matrix.
• Worked on MDM (master data management).
• Actively involved in data profiling to ensure data quality of vendor data.
• Logical and physical database designing like Tables, Constraints, Index, etc. Using Erwin tool, DB Artisan, ER Studio, Power Designer, DB designer.
• Excellent T-SQL, PL/SQL programming skills like triggers, stored procedures, functions, packages etc in developing applications
• Performance and tuning of SQL queries using option clause and indexes in SQL Server.
• Tuning of SQL statements using query analyzer, by gathering statistic, analyzing tables and indexes, using option clause in the query, parallel query, and analytical function, SQL Profiler table partitioning and rebuilding, validating the Indexes etc. in SQL Server.
• Performance and tuning of SQL queries using option clause, indexes, Execution Plan Analysis, Locks & MaxDOP Options, Re-Write Queries, Profiler Analysis, Temp Tables and CTE’s, Indexed Views, Index Tuning, Partitioning Tables & VLF’s.
• Tuning of SQL statements using tools like AWR reports, ASH report, explain plan, TKPROF, Auto trace, gathering statistic, analyzing tables and indexes, using Pipeline function, parallel query, Inline views, analytical function, Bulk Binds, Bulk Collect, Query rewrite, hints etc. in oracle, MySQL.
• Worked on Informatica Power Center Tools-Designer, Repository Manager, and Workflow Manager.
• Worked on informatica administration like created user/groups.
• Worked on performance and tuning of ETL process like Using Thread Statistics, partitioning of session, push down optimization, Buffer Memory Optimization, Target bottleneck like dropping indexes and key constraints, bulk load etc.
• Deployed mapping, workflow etc. through export/import and deployment group in test and prod environment.
• Worked on backup and recovery of SQL server and oracle.
• Experience in Table partitioning and rebuilding, validating the Indexes in oracle.
• Experience in Reorganize database structures as needed.
• Exposure to data analytic, machine learning in SAS.
• Experience in Map Reduce programming model andHadoopDistributed File Systems.
• Knowledge of big data in writing Hive, Pig Queries forHadoopDistributed File system.

TECHNICAL SKILLS

Job Functions: Project Management, Configuration Management, Application Support, DBA tasks, Handling Database, Analysis, Design, Coding, and Testing Documentation, Maintenance.

Databases: SQL server 2008, 2012, Oracle-RAC 12c,11g, 10g, 9i, MySQL - 5, 4.x

DBA Tools: Toad, SQL Navigator, Spotlight, DB Artisan, Platinum SQL Station & Analyzer, DB Vision, DB Designer, PL/SQL Editor, Erwin, Golden Gate, OEM12c, Erwin, Power designer, Oracle designer, ER Studio, OEM.

Data warehouse Tools: Informatica, Data integrator XI (Business Object ETL), Businessobjects (Reports), Cognos, Data stage, Golden Gate, SSIS, SSRS, SSAS

Tools: D2k (Forms, Reports), Harvest, VSS, Edit Plus 7, Test Director, MS office, MS Project, Clarity, TFS

Languages: PL/SQL, Visual Basic, C, C++, JAVA, D2k (Forms, Reports)

Concept: ORDBMS, RDBMS

Monitoring tools/Others: Nagios, MRTG, Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential

Sr. Architect

Environment: Oracle, SQL Server, Informatica, Oracle, Maria DB(MySQL), Linux, Big data, BO Reports, Erwin

Responsibilities:

• Working as OLTP/Data warehouse architect.
• Responsible for detail architectural design.
• Responsible on Source to target mapping and traceability matrix.
• Gathered the requirement from business and implemented the new projects.
• Data modelling, Dimension Modelling, Database Designing using Power Designer.
• Working on conceptual, logical and physical data model.
• Working on master data management (MDM).
• Working on T-SQL, PL/SQL, stored procedures, functions, triggers etc.
• Tuning of SQL statements using tools like Explain plan, Auto trace, gathering statistic, analyzing tables and indexes, using Pipeline function, parallel query, Inline views, PPI analytical function, Query rewrite, hints etc. in oracle SQL server and Teradata.
• Tuning of SQL statements using query analyzer, by gathering statistic, analyzing tables and indexes, using option clause in the query, parallel query, analytical function, SQL Profiler table partitioning and rebuilding, validating the Indexes etc. in SQL Server.
• Tuning of SQL statements using tools like AWR reports, ASH report, explain plan, TKPROF, Auto trace, gathering statistic, analyzing tables and indexes, using Pipeline function, parallel query, Inline views, analytical function, Bulk Binds, Bulk Collect, Query rewrite, hints etc. in oracle, MySQL.
• Worked on Informatica Power Center Tools-Designer, Repository Manager, and Workflow Manager.
• Worked on informatica administration like created user/groups.
• Worked on performance and tuning of ETL process like Using Thread Statistics, partitioning of session, push down optimization, Buffer Memory Optimization, Target bottleneck like dropping indexes and key constraints, bulk load etc.
• Deployed mapping, workflow etc. through export/import and deployment group in test and prod environment.
• Reverse engineering of databases for performance and business needs.
• Profile data and identify data quality rules. Data map and gap analysis
• Actively involved in data profiling to ensure data quality of vendor data.
• Working with Hadoop team for Ingestion of data from various sources.
• Working on Hive tables, loading data and writing Hive queries.
• Developed the Pig, Hive UDF'S to pre-process the data for analysis.

Confidential

Sr. Architect

Environment: SQL Server, Informatica, Oracle, Maria DB(MySQL), Linux, Big data, BO Reports, Erwin, Oracle

Responsibilities:

• Worked as Data warehouse architect.
• Lead the team of application, ETL, BI developers.
• Worked on Data Modeling for OLTP, Dimension Modeling for data ware house like Star Schema, snowflake schema and MDM.
• Worked on Informatica Power Center Tools-Designer, Repository Manager, and Workflow Manager.
• Worked on informatica administration like created user/groups.
• Worked on performance and tuning of ETL process like Using Thread Statistics, partitioning of session, push down optimization, Buffer Memory Optimization, Target bottleneck like dropping indexes and key constraints, bulk load etc.
• Deployed mapping, workflow etc. through export/import and deployment group in test and prod environment.
• Created and maintained stored procedure, function, trigger, packages etc.
• Table partitioning and rebuilding, validating the Indexes.
• Worked on Teradata.
• Worked on stored procedures, functions, triggers etc.
• Worked on key performance indicator for reporting purpose.
• Created Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Written and executed complex T-SQL and PL/SQL queries.

Confidential, Seattle, WA

Environment: oracle, Power Designer, BO, SQL server 2012, informatica, SQL server, Erwin, Teradata.

Responsibilities:

• Worked as Data warehouse architect.
• Gathered the requirement from business and implemented the new projects.
• Data modelling, Dimension Modelling, Database Designing using Erwin.
• Worked on stored procedures, functions, triggers etc.
• Worked on key performance indicator for reporting purpose.
• Profile data and identify data quality rules. Data map and gap analysis
• Actively involved in data profiling to ensure data quality of vendor data.
• Tuning of SQL statements using query analyzer, by gathering statistic, analyzing tables and indexes, using option clause in the query, parallel query, analytical function, SQL Profiler etc.
• Performed database administration lie User Management and implement Security using Roles, Privileges, Grants and capacity planning etc.
• Tuning of SQL statements using tools like AWR reports, ASH report, explain plan, TKPROF, Auto trace, gathering statistic, analyzing tables and indexes, using Pipeline function, parallel query, Inline views, analytical function, Bulk Binds, Bulk Collect, Query rewrite, hints etc in oracle.
• Worked on reengineering of database, performance testing of volume data
• Worked on data modeling using SQL developer data modeling tool.
• Worked on performance and tuning of ETL process like Using Thread Statistics, partitioning of session, push down optimization, Buffer Memory Optimization, Target bottleneck like dropping indexes and key constraints, bulk load etc.
• Deployed mapping, workflow etc. through export/import and deployment group in test and prod environment.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Written and executed complex T-SQL and PL/SQL queries.
• Worked inSQL Server Integration Services(SSIS)andSQL Server Reporting Services (SSRS)with good knowledge onSQL Server Analysis Services(SSAS).
• Worked on developing,monitoring, extractingandtransformingdata using SSIS, Import Export Wizard, and Bulk Insert.
• Worked on Hadoop POC.

Confidential

Database Architect

Environment: oracle RAC11gR2, Sybase Informatica, Teradata, ER Studio, Sybase, business object, MySQL, J2EE, MSSQL 2008, ERWIN

Responsibilities:

• Worked as Portfolio\Data warehouse architect.
• Data modelling, Dimension Modelling, Database Designing using power designer lead the team of application, ETL, BI developers.
• Tuning of SQL statements using query analyzer, by gathering statistic, analyzing tables and indexes, using option clause in the query, parallel query, analytical function, SQL Profiler etc.
• Gathered the requirement from business and implemented the new projects.
• Written and executed complex T-SQL and PL/SQL queries.
• Created and maintained stored procedure, function, trigger, packages etc.
• Table partitioning and rebuilding, validating the Indexes
• Performed database administration like User Management and implement Security using Roles, Privileges, Grants, tablespace management and capacity planning etc.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Worked on Informatica Power Center Tools-Designer, Repository Manager, and Workflow Manager.
• Worked on developing,monitoring, extractingandtransformingdata using SSIS, Import Export Wizard, and Bulk Insert.
• Tuning of SQL statements using tools like AWR reports, ASH report, Explain plan, TKPROF, Auto trace, DBMS PROFILER, Gathering statistic, analyzing tables and indexes, using Pipeline function, parallel query, Inline views, analytical function, Bulk Binds, Bulk Collect, Query rewrite, hints etc in oracle.
• Profile data and identify data quality rules. Data map and gap analysis
• Worked on business object, created universe, dashboard etc
• Shell scripting in Linux
• Worked on performance and tuning of ETL process like Using Thread Statistics, partitioning of session, push down optimization, Buffer Memory Optimization, Target bottleneck like dropping indexes and key constraints, bulk load etc.
• Deployed mapping, workflow etc. through export/import and deployment group in test and prod environment.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.

Confidential, Phoenix AZ

Portfolio\Data warehouse Architect

Environment: oracle 10g,11g, HP - UX, Solaris, Erwin 7.2, Toad,, ER Studio, MySQL, MSSQL, Oracle, SSIS, SSRS

Responsibilities:

• Responsible for program and portfolio management activities.
• Worked on High Level Design ofETL, SSISPackages for integrating data using OLE DBconnection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided bySSISsuch asData Conversion,Conditional Split,Bulk Insert,Mergeandunion all.
• Direct the coordination of all implementation tasks involving third party vendors as well as provide consultation to clients on system implementation.
• Worked with ETL team on Informatics tool for extraction, transformation and load
• Worked with Business Object team for reporting
• General database administration for oracle 11g RAC, ASM
• Capacity Planning, Space Management
• Worked on Pl/SQL, Created and maintained stored procedure, function, trigger, packages etc.
• Data modelling, Database Designing using Erwin.
• Written and executed complex T-SQL and PL/SQL queries.
• Created summary tables, materialize views for query rewrite purpose etc.
• Created partitioned table, index according to the need of application
• Data loading using Faster Batch Processing, SQL Loader, external tables, UTL FILE package
• Performance and tuning using AWR reports, ADDM, 10G Advisors.
• Monitoring and optimizing the performance of the database through tuning applications, tuning memory and tuning disk usage etc.
• Worked on backups Data pump, RMAN, Data Guard
• Created databases for development, test, production etc.
• Shell scripting in Linux.