SUMMARY:

• Over 10 Years of experience in Information Technology Industry, as a solution / Data / ETL Architect, analyst and Modeler with deep Program Management, Logical, Physical Database Design and Administration skills.
• Ability to manage multiple projects with OLAP, OLTP, ODS, EDW 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.
• Design, 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
• Analyzing and Designing SharePoint Site collections, Websites, subsites, Lists, Libraries, Documents, Web parts, web components, Custom Templates, Groups, Privileges, Users.
• Analyzing and Designing Tableau analytical reports
• Creation of Database, database objects, roles, users, schemas, procedures, packages, functions, triggers. Creation of physical and logical models of the database.

TECHNICAL SKILLS:

Technical Expertise: Sharepoint, Tableau, 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, C, C++, Python.

PROFESSIONAL EXPERIENCE:

Solution Data Analyst/Modeler

Confidential

Responsibilities:

• Working as 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.
• Involved in requirement gathering, Creation of Logical and Physical data models in Oracle, SQL Server, working with Teradata EDW subject areas, working with Next Transformation, Master Data Maestro, COSOR, Inspector, HMT. Interacting with Data architects, 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.

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

Solution Data Analyst/Modeler

Responsibilities:

• On-Site Data Analysis, creation of logical and physical database models scripts, creation of databases, File Groups, schemas, roles, privileges, user, database objects, stored procedures, applying business rules.
• 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 Analyst/Modeler

Confidential, LA, CA

Responsibilities:

• Worked as a Data Architect/Modeler, 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 Development, Testing oracle database, 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. Working closely with the development, ETL, QA Teams.

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.

Solution Architect/ Analyst/ Modeler

Confidential, Chicago

Responsibilities:

• Working as a Solution Architect for Confidential, Confidential Sales and eRoyalties, with OLTP and OLAP applications, designing logical and physical models, Creation of databases, schemas, Tables, Users, Roles, procedures, functions, triggers, coordinating with ETL Process team, Data Integration, Data Migration, Data Mapping, Data Mining, responsible for managing multiple projects for Confidential.
• Primary responsibilities include, investigating the existing data model, gathering the project requirements, managing the development, production, testing server 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

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

Confidential

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