SUMMARY

• Over 10+ Years of experience in the Information Technology Industry, as a solution Data Architect and Modeler wif deep Program Management, Logical, Physical Database Design, Database Migration and Administration skills. Ability to manage multiple projects wif 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 wif agile waterfall and scrum Project Management, Program Management, Product Owner, Software Development Life Cycle phases from Requirement Gathering, Analysis, Design, Development, Implementation, Integration, and Data Migration from legacy systems to NOSQL and RDBMS Applications.
• Modeling & Design, Development, pre-QA, QA, Testing and Production Instances of Database for NOSQL, OLTP and OLAP projects.
• Analyzing and designing Logical and Physical Data models, forward and reverse engineering Database models
• Comparing Logical and Physical models.
• Coordinating wif RDBMS, Hadoop, Web Services, AWS, SOA, REST API, ETL Development trams
• Implementing Single Sign on Architecture.
• Worked as a Database Developer, Data and ETL Modeler and Analyst, agile Project Manager, product manager, program manager, Technical Team Lead, ETL Analyst.
• Designed and Implemented Star, Snowflake, Galaxy Schema Models.
• Worked wif Metadata Management, Data Governance, Data Lake, Data Vault and MDM models.
• Extensively worked wif ER-Win, ER/Studio, VISIO, Oracle Data Modeler tool for creating Conceptual, Logical and Physical RDBMS and NOSQL Models.
• Identifying and Analyzing the SQL Queries for NOSQL Data model design.
• Worked extensively wif Teradata, DB2, Oracle, MySQL, SQL Server, Sybase, PostgreSQL.
• Coordinating On Shore and Off Shore Team
• Extensively worked wif E2E Data mapping ETL process
• Designing and Coordinating ETL teams wif DataStage, SSIS, Informatica, Talend, Pentaho.
• Designing and Developing Schema Objects, Packages, Procedures, Functions, Triggers and Exceptions
• Scheduling ETL and DB tasks
• Coordinating wif DBAs in identifying and resolving Performance Issues
• Defined Backup, Archive and Purge policy.
• Coordinate wif Devops team implementing Version Control, CICD
• Worked wif Multitier, Multi-lingual, e-commerce and Client/Server applications, CRM & ERP Products
• Worked as a Database Administrator.
• Customization and Implementation of Oracle Applications (GL, AP, AR, CE, OM), Designing tailor made Enterprise Integration Tools
• Worked wif e-Commerce, Financial, Banking, Manufacturing, Engineering, Cement, Plastic, High Power Cable manufacturing, Sea Port Cargo Management, Hospital Management, Medical Insurance, Games, CRM, Educational Institutions/Universities ERP Application development & Customization.
• Established data extraction methodology for Oracle, SQL Server, MySQL to migrate Hadoop.
• Analyzing and Designing SharePoint Site collections, Websites, subsites, Lists, Libraries, Documents, Web parts, web components, Custom Templates, Groups, Privileges, Users.
• Analyzed, Designed, Developed and Implemented SSRS, Click View, Tableau Dashboards and analytical reports
• Created of Database, database objects, roles, users, schemas, procedures, packages, functions, triggers. Creation of physical and logical models of the database.

TECHNICAL SKILLS

• ER-Win
• ER/Studio
• Informatica
• Oracle Data modeler
• SharePoint
• Click View
• Tableau
• Hadoop
• Bigdata
• MongoDB
• Couchbase DB
• Casandra DB
• Pig
• HIVE
• HBase impala
• BPM tasks & ERP Applications
• SQL*Loader
• Oracle SQL Developer
• Oracle
• MySQL
• Sybase
• SQL Server
• DB2
• Teradata 13 V2R5
• .Net
• JAVA
• ODS
• OBIEE
• RMAN
• RAC
• Enterprise Architect
• Code Charge
• UML Modeling
• SSIS
• SSAS
• SSRS
• Unix
• Linux
• Windows Servers
• SQL
• PL/SQL
• T-SQL
• HTML
• XML
• PHP
• JSP json
• ASP
• Java-Script
• VB-Script
• Jira
• Bamboo
• Bitbucket
• Kibana
• TOAD
• SVN
• JIT
• MS-TFS
• Web Services
• Kettle Pentaho
• C
• C++
• Python

PROFESSIONAL EXPERIENCE

Architect/Data Modeler

Confidential, Lehi, UT

Responsibilities:

• Working as Architect/Data Modeler for Open edge, a division of global payment process, Lehi, UT, responsibilities include but not limited to, as a Data Architect wif agile model, involved in daily standups, backlog grooming session, user story creation, retrospective meetings, working wif sprint tasks.
• Executed the reverse engineering task on existing OLTP, Merchant and Partner Onboarding Process and Payment Transactional Database, using Oracle SQL Developer Data Modeler Tool and analyzing the database objects, identifying the relations, constraints, functional and system process and dependencies, comparing the Data models, update existing objects to meet the business needs. Create physical model and generate DDL for DB creation. Developing solution for long term and short term for Database pain point issues in regards of performance, purge and archive process, identifying good candidates for table partition, preparing the pre and post partition. performance matrix, preparing and presenting the model to product owners, stakeholders, Architects.
• As a Data modeler, Designed Logical and Physical data model for Web Socket AUTH process, created the DB objects, stored procedures. Working on long-term solution, designing new data model for OLTP Credit, Debit, Gift, Check, etc. for merchant and partner payment process.
• Comparing different versions of data model and resolving the issues. Conducting regular meeting wif stakeholders, SMEs and development teams in gathering the system and functional requirements. Analyzing the attribute level functionality, documenting the data dictionary. Creating ER-Model, established industry best practice standards wif Domain Types, Entity, Attribute, Constraint, Index naming conventions, data type consistency. Preparing the case study for Merchant and Partner Payment transactional process business activities.

Environment: MS-SQL Server 2014, Oracle SQL Developer Data Modeler 17.2.0.188 , Java, JavaScript, APIGEE, Apache Tomcat, Jira, Bamboo, Bit bucket, Kabana.

Architect/Data Modeler

Confidential, MI

Responsibilities:

• Worked as Architect for Bureau of Elections, Michigan State, USA, responsibilities include but not limited to, gathering system requirements, coordinating meetings, and daily standups wif Stakeholders, Development Team, and Architects. Migrating QVF (Qualified Voter File) Oracle Database to SQL Server 2016, Creation of migration scripts,
• Designing Data model using Oracle SQL Developer Data Modeler Tool, migrating existing OLTP oracle data model to SQL Server, creation of data objects, SSIS Packages for data migration. Preparing migration plans, validating and resolving data issues between Oracle and SQL Server.
• Designed logical and physical models, Creation of databases, schemas, Tables, Users, Roles, procedures, functions, and triggers, ETL Process, Data Integration, Data Migration and Data Mapping.
• Analyzed the existing data model, gathering the project requirements, managing the Sandbox, development, production, testing server environments.
• Closely interacting wif the Business, Functional, Technical and project Leads, BI Analysts, Team members and client to fulfill the gaps and bring the best solutions and resolving and improving the performance. Managing the .net Db Project, managing the Schema for sandbox, DEV, Test databases and version control wif MSTFS2015.

Environment: Oracle 11g, MS-SQL Server 2016, IIS, Visual Studio 2015, JQuery, CSS, AJAX, TFS2015, SSIS, SSRS.

Architect/Data Modeler

Confidential, Chicago, IL

Responsibilities:

• Worked as Architect for a Data warehouses project, as onshore coordinator responsibilities include but not limited to, gathering system requirements, conducting meetings wif Stakeholders on site and offshore tiger team.
• Closely worked wif BA teams, DBAs for designing NOSQL, OLTP and OLAP applications. Designing ETL architecture and Process, Staging Database, Data warehouse, Fact & Dimension Tables.
• Worked wif Talend, Qlik Sence reporting models. Designed logical and physical models, Creation of databases, schemas, Tables, Users, Roles, procedures, functions, triggers, coordinating wif ETL Process team, Meta Data Management, Data Integration, Data Migration, Data Mapping, Data Mining, and Data Profiling.
• Analyzed existing data model, gathering the project requirements, managing the development, production, testing server environments, selection of software application, migration, development tools, coordinating wif the on-shore and offshore teams.
• Closely interacting wif the Business, Functional and Technical, project Leads, BI Analysts, BO Architects, UI Architects, Team members and client to fulfill the gaps and bring the best solutions in time and in budget.
• Designed data Mapping, Analyzing, Cleansing, Data Mining, Metadata Management, Profiling, Identifying Data migration strategies, coordinating wif ETL Teams.

Environment: Hadoop, LINUX, ER-Win, MS-Windows, 2012 R2 Server, Postgre SQL, MS SQL Server2012, C++, IIS, JAVA, JQuery, Hive, PIG.

Architect/Data Modeler

Confidential, Portland, OR

Responsibilities:

• Worked as Architect interacting wif 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 wif Teradata EDW subject areas, working wif Next Transformation, Master Data Maestro, COSOR, Inspector, HMT.
• Interacted wif Data architects, Business Analysts, Program & Project Managers, DBAs, MSBI team, SAP team, analyzing the data anomalies, resolving the issues.
• Redesigned IT and Business rules such as CIM Merge and Split. Designing, Normalizing, De-Normalizing, and Creating Oracle PL/SQL Packages, performance Tuning. worked wif Start and Snowflake schemas, table partitions.
• Worked wif Function based Indexes, Reverse Indexes, Table Partition Global Index and local index, gathering runtime statistics wif DBMS Profiler.
• Worked wif Hints, development of Database packages, procedures, functions as part of database migration from SQL Server 2008 R2 to Oracle 11g.

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

Architect/Data Modeler

Confidential, Chicago, IL

Responsibilities:

• Acted as a POC for all On-Site Architect, 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.
• Involved Development of Analyzing the existing application and infrastructure, requirements for future demands.
• Prepared Database Replication Solution. Working in an on-site/off-shore model, was responsible to interact wif 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 wif LOG shipping for reporting. Working and fine tuning the existing stored procedures, Updating the SSIS packages, migration planning from SQL Server 2005 to SQL Server 2010.
• Designed and coordinated wif ETL Team in the process of DTS packages to SSIS packages.

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

Architect/Data Modeler

Confidential, LA

Responsibilities:

• Worked as an Architect for Confidential, involved in investigating existing ORACLE 11g, MYSQL, SQL Server databases.
• Prepared the migration models, preparing the architecture for customized Daybreak Lending Suite day end and month end schema, creating Development, testing oracle database, table spaces, schemas, tables, indexes, oracle packages, stored procedures, functions, global temp tables, table partitions, exception tracking wif best practices.
• Approached, migration plan for 170 million records of multiple databases from MySQL month end snapshot to oracle. Working and applying patches in Development, Testing, and Production databases.
• Worked closely wif the development, ETL, QA Teams. Designing, Normalizing, De-Normalizing, and Creating Oracle PL/SQL Packages, Analyzing, Data Cleansing, performance Tuning. worked wif Start and Snowflake schemas, table partitions. Working wif Function based Indexes, Reverse Indexes, Table Partition Global Index and local index, gathering runtime statistics wif DBMS Profiler. Worked wif Hints. Development of Database packages, procedures, functions as part of database migration from SQL Server 2008 R2 to Oracle 11g.

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, Informatica.