SUMMARY:

• Around 17+ years of experience in Database Administration, Database modelling, Database development and software design with a specialty in data architecture, data integration and data migration.
• 10+ years work experience in Japan.
• Extensive Database administration experience in Oracle,SQL Server,PostgreSQL,IBM DB2,Sybase,Teradata.
• 13+ years experience in Data Warehouse/ETL using OWB,Pervasive,PL/SQL,MSSQL DTS, Informatica.
• Extensive Experience using OLAP Tools such as Eclipse BIRT,Jasper Report,Oracle Discoverer,Business Objects and work experience in OBIEE.
• Extensive experience as a ETL developer on on building data mart and ODS in Oracle,Postgresql,MSSQL,DB2 and Sybase
• Extensively used SQL,TSQL,PSQL and PL/SQL for development of Procedures, Functions, Packages and Triggers.
• Experience in Design & Development of Enterprise Data Warehouse infrastructure.
• Analyzed Source Systems, Business Requirements, Identify and Document Business Rules for Decision Support Systems.
• Augment the design of the business intelligence architecture solution for the Financial Securities reporting platform
• Augment the development of the reporting platform with a focus on Oracle OIBEE, Sybase, Java and Informatica technologies while adhering to client specific standard procedures
• Experiene using JIRA as a tracking system and RT as a ticketing system in accordance with specific standards
• Extensive experience on Database and SQL Performance Tuning
• Project management of full lifecycle software development projects using AGILE Methodologies.
• Experience in Project Management using Redmine Project Management Apllication
• Experience in Cubes
• Instrumental in complete architecture, re - design and development of data warehouse using Kimball dimensional model. Designed, model and implemented new fact grains, SCD, Conform dimensions, degenerate dimensions.
• Actively participated in requirement gathering sessions with business stake holders, business users, business analysts and project manager.
• Organize business requirements into conceptual, logical and physical (OLAP) data warehouse model.
• Design, model, implemented fact table grain, dimensional tables, dimensional hierarchy.
• Liaise with off shore configuration and support team and provide specs, directions, worked with them to implement release and provide appropriate documents.
• Design business intelligence solutions including ETL, staging and calculations required to support specific related business requirements and information flows.
• Created source to target mapping, validation rules, transformations, and business rules.
• Physical data warehouse design, table partitioning, indexing strategy, materialized views, hands on with PL/SQL, SQL development using packages, program units.
• Designed, developed, made valuable addition to each aspect of physical data warehouse design and development, PL/SQL stored procedures, packages, procedures, SQL tuning, indexing strategies, partitioning, parallel processing, materialized views.

TECHNICAL SKILLS:

ETL: Pervasive 2.6, OWB 9.2, PL\SQL,SSIS , MSSQL DTS, Informatica

Databases: Oracle 11g R2/10g RAC, SQL Server 2000/2005/2008/2012/2016 IBM DB2 9.7 / PostgreSQL 9.6, Sybase,MySQL,MongoDB,Teradata

Database Development: PL\SQL,T-SQL ,PGSQL

Data Modelling: ERWIN, Case studio, Sybase Power Designer, MS Visio,SPSS

OLAP Reports: Oracle OBIEE, Business Objects 6.5, Eclipse BIRT, Oracle Discoverer 10g, Cognos, SSAS\SSRS

Cluster Utilities: Oracle CRS,Pacemaker with Corosync

Programming: Oracle Forms 6i/9i, Visual Basic, C++

ERP: Oracle E-Business Suite 11i, OODO

Database Tools: Toad for Oracle, Toad for SQL Server, Toad for DB2, PLSQL Developer, Spotlight on RAC, SQL Developer IBM Data Studio 3.2.0,DB Artisan, PgAdmin

Source Control: Team Foundation Server,CVS,GIT

PROFESSIONAL EXPERIENCE:

DWH Architect/ Database Administrator

Confidential

Responsibilities:

• Design, Evaluate, review, and manage database resources and services across the organization while ensuring high levels of data quality. Responsible for Database Design, developing, implementing the database policies and procedures to ensure the integrity and availability of databases and their accompanying software. Design, monitor, maintain, and performance tune the production databases and applications.
• Providing technical leadership and solutions architecture for Business Intelligence - Enterprise Data Warehouse team.
• Monitoring at Server, Database, Collection Level, and Various Monitoring Tools related to MongoDB
• Export and Import of Data to and From MongoDB, Run time configuration of MongoDB
• Log rotation/ maintenance ( mongos, mongod, config . etc) experience with MongoDB scaling across data centers and/or in-depth understanding of MongoDB HA strategies, including replica sets and sharding.
• Architecture, development and implementation of a Master Data Management (MDM) solution to integrate data from multiple systems
• Gathering end-user data and reporting requirements and performing in-depth analysis of source systems, data and complex business rules in order to build optimal solutions to meet the needs of our data consumers.
• Designing, developing and implementing various components of our enterprise data warehouse to include: staging, integration, and operational data store (ODS) and analytics databases. Responsible for all phases of the SDLC including gathering requirements, data/system analysis, data modelling, ETL development, database development, testing, deployment, etc.
• Develop and Manage ETL packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues. Proficient with Server-Side System Default & Black box Traces to analyse other issues on the server.
• Analyse designs and validates data models, structures and processes to define data structures and business operations.
• Design database object elements based on the requirements and contained in the system specification according to ETL/DW/BI architecture.
• Analyse risk and assist data modeller’s with the creation of detailed data flow/data analysis specifications.
• Leading the review process for Data Models, data mappings, data quality related aspects.
• Validate the overall source/target systems integrity to the DW/DM built against the DW/DM objective.
• Design databases in conjunction with project teams and develop database operational procedures to ensure availability
• Perform day to day Database Maintenance tasks - Database Monitoring, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers.
• Database Performance Optimization on a large scale database
• Experience using OpenStack cloud computing
• Indepth working experience with NoSQL Data Modeling
• MSSQL Server Capacity Management,Security Management, High Availability Management, Backup and Recovery Management, Performance Tuning and Process Improvements, DB Installations / Upgrades / Patching.
• Created the T-SQL script to generate all the tables and relationships based on the finalized ER-Diagram.
• Familiar with different SDLC methodologies like Waterfall, RUP, Spiral and XP also understanding of various phases in these methodologies .
• Created Stored Procedures, Views, and User Defined Functions to facilitate the automation of data entry by a front end application.
• Created database documentation for table and column dictionaries and other reference material.
• Responsible for the indexing and performance tuning of the queries.
• Analyzed physical data model for ETL mapping.
• Involved in the creation of scheduled jobs for Extracting, transforming and loading operations as well as database maintenance tasks like defragmentation, re-indexing, and recompiling stored procedures.
• Created several reports using SSRS like drill through reports, linked and sub reports.
• Developed various automated as well as ad-hoc SSRS reports as per the business requirements.
• Migrated existing DTS packages to SSIS and Crystal Reports for Accounting into SSRS.

Database Architect / DWH Tech Lead

Confidential

Responsibilities:

• Data Marts for regulatory reporting were created that would also drive the multidimensional cubes and generate reports that would aid in business analysis.
• Designed logical and physical models for star schema based data marts
• Implemented various integrity constraints and triggers for data integrity and SQL features like complex joins, sub-queries, ranking functions etc.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Remodeled existing DW as well as create logical and physical data model for the new data mart.
• Designed the ETL process using SSIS Packages in which the data sources include SQL, Sybase, and flat files.
• Responsible for the indexing and performance tuning of the queries.
• Understanding the Business requirements and responsible for overall design
• Managing the ETL development and OBIEE development resources by providing adequate knowledge on the business requirements and design
• Work closely with business analysts and technical analysts on business user requirements
• Augment report design and implementation
• Working closely with production support team to support ETL program.
• Conduct and augment code review in accordance with specific standard procedures
• Conduct and document unit testing in accordance with specific standard procedures
• Draft test cases for system integration testing as well as user acceptance testing
• Coordinate and augment system integration testing as well as user acceptance testing
• Providing necessary support on ETL program and logic improvements while needed
• Draft pre-production release review documentation in accordance with specific standard procedures
• Conduct knowledge transfer to the production release team as well as the relevant support team
• Optimized performance of the queries running against the data mart by creation of Table Partitions, Indexes and Indexed Views.
• Optimized cubes using proper partitions across storage modes, proactive caching and usage based optimization.

DWH Architect / Senior Database Administrator

Confidential

Responsibilities:

• Validate the overall source/target systems integrity to the DW/DM built against the DW/DM objective.
• Leading the review process for Data Models, data mappings, data quality related aspects.
• Responsible for educating in-house and vendor application developers on good database development practices
• Performs database tuning and troubleshooting. Install and troubleshoot replication, performs production migrations, backups, and database recovery.
• Analyse data requirements and documents according to required standards by utilizing prescribed tools and methods to ensure that design and implementation are according to company guidelines and client specifications.
• Manage user and data security to allow access to appropriate resources. Proven experience in maintenance of Oracle DB and resolving database issues with large tables.
• Data warehousing - Data mapping, Data Extraction Transformation and Loading using Oracle PL\SQL Programming, SQL Server DTS and SSIS packages.
• Oracle discoverer reports development and Maintenance for EBS application.
• Design databases in conjunction with project teams and develop database operational procedures to ensure availability
• Created the T-SQL script to generate all the tables and relationships based on the finalized ER-Diagram.
• Hands on experience in managing Reporting Server and creating ad-hoc reports from OLTP and OLAP including its delivery using push and pull delivery methods.
• Managed the entire ETL process involving the extraction, manipulation, loading and presentation of data from heterogeneous data sources to aid data predictive analysis using SSIS.
• Implemented custom SSIS functionality using the Script task component.
• Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.
• Created multiple reports such as linked reports, sub, drill through and drill down reports depending upon the client's need.
• Provide third party application support for systems that depend on Oracle and Microsoft SQL Server 2000 & 2008 including the creation and maintenance of database user accounts and password management.
• Implemented the multidimensional cubes on Analysis Services (SSAS) and built Key Performance Indicators, actions and Calculated Members.
• Ensure accurate and up-to-date full, incremental and differential backups are made periodically according to strict IT guidelines to reduce risk of potential productivity and intellectual property loss.
• Worked closely with the Oracle EBS development team to implement EBS 11i application suite in the organization from the beginning.
• Proven Experience in Oracle EBS 11i application implementation on the technical side.
• Continuously review of table relations to ensure database functions at optimized normalized level as well as ensure day to day database performance remain at optimized levels.
• Experienced with utilizing SQL queries to extract information at the request of operations team members as well as senior management on ad-hoc basis as well as scheduled intervals.
• Troubleshoot database performance issues and tune database objects. Set up traces and Profiler to troubleshoot performance issues. Analyse deadlocks & diagnose issues on the server.
• Setup and configure Oracle, SQL, DB2 and PostgreSQL Databases for other business functions. Index & Data Management to determine Defragmentation level; whether to Update Statistics or Rebuild Indexes.
• Developed, enhanced PL/SQL packages perform SQL tuning, use SQLLDR.
• Utilized all aspects of Oracle SQL, analytical functions, ranking, rollup, Lag, Lead, Case, merge.
• Load data into warehouse utilizing SQL loader, shell scripting, and Oracle PL/SQL
• Database and Query Performance Tuning and solving techniques
• Strong DBA,DWH, Data modelling and database Programming skills
• Data analysis, data modelling, data integration - conceptual, logical and physical models design