SUMMARY:

• Over 15 Years of experience in Information Technology Industry, as an Enterprise solutions / Data / ETL architect and Modeler with deep Program Management skills.
• Ability to manage multiple projects with OLAP, OLTP, ODS applications, handle challenging deadlines on complex and interdependent business processes, identify the client’s needs and translate them into appropriate technical solutions.
• Providing motivation, guidance and leadership to cross functional teams.
• Extensively worked with Software Development Life Cycle phases from Analysis, Design, Development, Implementation, Integration, Data Migration, from legacy systems to various RDBMS Applications.
• Designed Development, Testing and Production Instances of Database for OLTP and Data warehousing projects
• Worked with Web Services, SOA, REST API, ETL Architecture and migration patterns, Payment Gateway Integration and Implementing Single Sign on Architecture.
• Worked as a Database, Data Architect, Data Modeler and Analyst, Project Manager, Technical Team Lead, ETL Architects.
• Worked extensively with Teradata, Oracle, MySQL, SQL Server, Sybase and legacy database integration, data migrations, data mining and data transformations.
• Worked with ER - WIN tool extensively in designing Generalization, Specialization and Analytic data models
• Interacting with On Shore and Off Shore Teams. Responsible for interacting with stake holders, Evaluating functionality and gathering the requirements
• Data modeling, Designing Physical and Logical model, Designing and Developing OLAP, OLTP, ETL Models for Data Migration, Identifying Data migration strategies
• Working with Schema Objects, Packages, Procedures, Functions, Designing and Developing Stored Procedures, Function, Triggers from legacy systems to Oracle
• Implementing Standard Custom Application Exceptions, Coordinating with the UI and Middle tire Teams for navigating best practices to improve performance, Coordinating onshore and offshore teams
• System Designing, Work Scheduling, Infrastructure selection, Data Migration Architecture, Selection of Technical and Functional teams
• Tracking Performance Issues and resolving, Planning for Backups and Restore of database
• Maintaining Version Control with various Products and Projects, Working with Multitier, Multi-lingual, e-commerce and Client/Server applications, Tailor made ERP Products
• Involved in Database Administration, Customization and Implementation of Oracle Applications (GL, AP, AR, CE, OM), Designing tailor made Enterprise Integration Tools
• Business Enterprises serving in e-Commerce, Financial, Banking, Manufacturing, Engineering, Cement, Plastic, High Power Cable manufacturing, Sea Port Cargo Management, Hospital Management, Medical Insurance, Games, Educational Institutions/Universities ERP Application development & Customization.
• Involved with Hadoop architects
• Established data extraction methodology for Oracle, SQL Server, MySQL to migrate Hadoop.
• Coordinating with ETL, QA Teams

TECHNICAL SKILLS:

Technical Expertise: Hadoop, BigData, Pig, HIVE, impala, HBase, BPM tasks & ERP Applications, SQL*Loader, Oracle SQL Developer, Oracle Applications 10.7/11i, Oracle 11g, MySQL, Sybase, SQL Server, DB2, Teradata 13 V2R5, MS-DotNet, JAVA, ODS, OBIEE, RMAN, RAC, Enterprise Architect, LucidCharts, Code Charge, UML Modeling, MS Business Intelligence (BIDS-SSIS, SSAS, SSRS), Unix, Linux, Windows Servers, SQL, PL/SQL, T-SQL, HTML, PHP, JSP, ASP, Java-Script, VB-Script, ER-Win, TOAD, SVN, JIT, MS-TFS, Web Services, Kettle Pentaho.

PROFESSIONAL EXPERIENCE:

Solution Data Architect/Modeler

Confidential

Responsibilities:

• Working as Solution Data Architect/Data Modeler, interacting with the Tiger Team & stake holders meeting, investigating the existing Sales Out, Channel Management, Customer, Indirect Chanel Analysis, MDM, CIM HUB, Data Cleaning tasks in SQL Server and Teradata EDW subject areas, working with Next Transformation, Master Data Maestro, COSOR, Inspector, HMT.
• Interacting with Data architects from various Business Domains, coordinating with Business Analysts, Program & Project Managers, DBAs, MSBI team, SAP team, analyzing the data anomalies, resolving the issues.
• Redesigning the IT and Business rules such as CIM Merge and Split.
• Coordinating with various Confidential ’s, resolving the Business and Technical issues, designing the conceptual, logical models.
• Analyzing the data anomalies, coordinating with data Analysts, business analysts, and business stake holders.

Environment: SAP, Hadoop, MSBI, Jive, Teradata EDW, SQL Server, Oracle, Hana, Master Data Maestro, COSOR look up tool, NEXT User Interface, JIVE, ER Studio.

Confidential, Chicago

Responsibilities:

• Acting as a POC for all On-Site Development & Architecture Definition, was involved in the Development of Analyzing the existing application and infrastructure, requirements for future demands, prepare Database Replication Solution.
• Working in an on-site/off-shore model, was responsible to interact with customers' Subject Matter Experts, Enterprise Architecture Team and Management Team to define business and system requirements for successful deployment of Solutions and Services.
• Proactively involved in Customer Meetings & Training Sessions, Implemented Data replication with LOG shipping for reporting.

Environment: SAN, SUN Solaris, MS-Windows, SQL Server2005/2008R2/2012, Web Services, .Net, SQL Litespeed, SSIS, DTS.

Data Architect/Modeler

Confidential, LA, CA

Responsibilities:

• Worked as a Data Architect/Modeler for Confidential, involved in investigating existing ORACLE 11g, MYSQL, SQL Server databases, preparing the migration models, preparing the architecture for customized Daybreak Lending Suite dayend and monthend schema, creating new oracle tablespaces, schemas, tables, indexes, oracle packages, stored procedures, functions, global temp tables, table partitions, exception tracking with best practices approach, migration plan for 170 million records of multiple databases from mysql monthend snapshot to oracle.
• Working and applying patches in Development, Testing, and Production databases.

Environment: LINUX, MS-Windows, Oracle DayBreak Lending Application, Web Services, 2008R2 MSSQL Server, oracle10g, Oracle 11g, Oracle SQL Developer, MySQL, PHP, JAVA, Kettle Pentaho migration tool.

Confidential, Chicago

Solution Architect

Responsibilities:

• Data Integration, Data Migration, Data Mapping, Data Mining, responsible for managing multiple projects for Confidential LLC, USA, for eBools2Go Conversion, Confidential Sales and Distribution, Confidential e-Royalties.
• Primary responsibilities includes, investigating the existing data model, gathering the project requirements, managing the development, production, testing servers environments, selection of software application, migration, development tools, coordinating with the on-shore and off-shore teams.
• Data migrated from SQL Server 2012, Oracle 10g. Designing the complex reports for the business analysis.
• Closely interacting with the Business, Functional and Technical, project Leads, BI Architects, BO Architects, UI Architects, Team members and client to fulfill the gaps and bring the best solutions in time and in budget.

Environment: Hadoop, MongoDB, LINUX, MS-Windows, REST API, Web Services, 2012 R2 Server, oracle10g, My-SQL, ASP.net, VB.net, C#.net, IIS, JAVA, JQuery, Oracle 11g, Teradata 13 V2R5, MS-TFS 2010, MS-BIDS(SSIS, SSAS, SSRS), MySQL, PHP, Talend

Confidential

Senior Technical Data Architect

Responsibilities:

• Worked for CCK E-Learning application development, designed and implemented logical and physical database layers, migrated application from MySQL, MS SQL Server and Oracle 11g to Teradata 13 V2R5.
• Involved In designing and implementing application for online catalog generation for leevalley.com, designed and developed database, navigated middle tire developers involved in designing the UI and web services.

Environment: LINUX, MS-Windows, REST API, Web Services, 2012 R2 Server, oracle10g, 11g, My-SQL, ASP.net, VB.net, C#.net, IIS, JAVA, JQuery, Oracle 11g, Teradata 13 V2R5, MS-TFS 2010, MS-BIDS(SSIS, SSAS, SSRS), MySQL, PHP, Talend

Confidential

Senior Data Architect

Responsibilities:

• Designed and developed Business Process Management for Sheridan Press which manages the details of Customers, Order management, payment information, invoice history, Bulling management, and Cash management modules.
• Responsible for Design and Implement database, construction of stored procedures, migrating of data from SQL Server to Oracle.

Environment: Hadoop, MongoDB, LINUX, MS-Windows, REST API, Web Services, 2012 R2 Server, oracle10g, 11g, My-SQL, ASP.net, VB.net, C#.net, IIS, JAVA, JQuery, Oracle 11g, MS-SQL Server 2008,2012 DB, MS-TFS 2010, MS-BIDS(SSIS, SSAS, SSRS), MySQL, PHP, Talend