About Me
- Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Mining, Data Integration and Metadata Management Services... , Data Integration and Metadata Management Services.
- Expert level experience in Oracle SQL, PL/SQL (Packages, Stored Procedures, Functions, Triggers, Cursors, Collections, OLAP queries, java stored procedures. In depth knowledge of Oracle packages and database dictionaries.
- Expert level experience in transforming & loading data from Oracle database to Amazon Redshift (MPP) database using Pentaho jobs & transformations and Linux scripts. Experienced in generating various types of data formats including XML using Pentaho DI.
- Good experience in Data Science/Statistical computing using Python & R programming language. Experienced in data acquisition/cleaning, exploratory analysis, Predictive models and creation of data products using Shiny server.
- Expert level experience in Data Warehousing, Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling.
- Expert level experience in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (Oracle APEX v2.0-5.0).
- Possess knowledge of Oracle database 11g/12c, AWS Redshift, Pentaho BI, Pentaho DI, Oracle Apex & NoSQL databases. Also, have experience in multiple reporting tools like Pentaho Report Designer, MicroStrategy, Business Objects and Jreport.
- Strong knowledge of performance tuning, including extract and load processes.
- Experienced in Agile based development. Organizing and leading the database team guiding technically around the architecture by exhibiting fine leadership qualities.
- Ability to understand current business processes and implement efficient business process.
- Expertise in defining scope of projects based on gathered business requirements including documentation of constraints, assumptions, business impacts & project risks.
Skills
Others
Data & Analytics
Software Engineering
Web Development
Programming Language
Database
Networking & Security
Development Tools
Portfolio Projects
Company
Oneshield Software
Description
- Working with Oneshield India Pvt. Ltd. on Insurance billing product & business intelligence.
- Responsible for managing gaps implementation & defects fixing.
- Managing the Oracle data warehouse & Pentaho BI reporting modules.
- Responsible for data modeling. Creating data flow diagrams, ER diagrams for all new features.
- Creating PL/SQL packages, procedures, functions including tables, Materialized views, job creation, and shell scripting.
- Also, playing as a scrum master role and responsible for managing all the business/technical user stories.
- Writing technical/functional documents in Confluence.
Company
Birlasoft India Pvt. Ltd.
Description
- Worked with Synapse Group Inc. (A division of Time Inc.) on data warehousing, data analysis & data integration projects. Also, working on data science projects like probabilistic matching for MDM, Automated Data Quality & Sales data analysis using machine learning algorithms.
- Managing the database team at offshore location which is responsible for handling large data warehouses, DataMart creation & business reporting. Also working as an individual contributor.
- Responsible for data modeling. Creating data flow diagrams, ER, Sequence, State diagrams etc.
- Responsible for creating Pentaho jobs & transformations to load data into AWS Redshift database.
- Creating PL/SQL packages, procedures, functions including tables, Materialized views, jobs creation and shell scripting. Also managing the Redshift databases used for data warehousing.
- Writing complex SQL queries for data retrieval.
- Playing a scrum master role and responsible for managing all the business/technical user stories.
- Writing technical documents & logs.
Skills
AWS Redshift Oracle 11g Oracle 12c Pentaho Data Integration Data Warehousing Data analytics MySQL PostgreSQL MongoDB Shell Scripting Business Intelligence Scrum Framework Visio Data Integration Apex Machine Learning Redshift PL/SQLTools
SQL Developer ToadCompany
Impetus InfoTech India Pvt. Ltd.
Description
- Worked with GOOD technologies & BoxTone Inc. (acquired by BlackBerry Limited) on Mobile Device Management, Mobile Service Management. Responsible for creating design documents and creating complex functionalities related to mobile devices tracking and management using Oracle PL/SQL, Oracle Apex, Jreport and other technologies. Built several components like, Apple, Blackberry, ActiveSync devices trackers, mail flow tracking, problem detection at device/carrier/server levels and data warehousing for complex data reporting and dashboards.
- Handling large database team at offshore location and also worked as an individual contributor.
- Responsible for data modeling, data analysis and data mining and PL/SQL programming including creation of tables, views, indexes, packages, procedures, functions triggers, DB links, materialized views etc.
- Creating applications in Oracle Apex. Also, migrating old applications to the new versions.
- Writing complex SQL queries for data retrieval.
- Working with Oracle support and other vendors.
- Handling database administration activities including Oracle software cloning, DB creation/Upgrade, Patching, Backup/Restore, tablespace management, memory management, Import, Export, AWR analysis, Tuning, OEM configuration & Oracle Apex & http server installation/configuration.
- Designing DFDs, ER diagrams, Sequence, State, Class Diagrams, Pseudo Code, and Descriptions.
- Organizing meeting for reviews and team co-ordination.
Skills
Oracle APEX Oracle 11g PL/SQL Confluence Database Administrator Mobile Device Management Data miningTools
SQL DeveloperCompany
Heuristics Informatics Pvt. Ltd.
Description
- Worked with many US based clients including Atlantic Diving Solutions (ADS), Argus, Camden County, Illinois Department of Transportation (IDOT) on quotation management system for Oracle EBS, EDI (x12 upload) tool, GENIII Inventory system, EMCMS system for Patrol scheduling, EAP-Argus, Umbrella project of Camden Country for security benefits.
- Worked on Oracle Apps R12/11i Order Management, AP, AR, INV, CE, OM and PO modules. Also, worked in Business Intelligence tools like Oracle Discoverer and XML/BI Publisher.
- Acted as a technical lead for development, customization and information gathering.
- Development of SQL queries & PL/SQL packages/procedures and development of forms and Reports in Apex.
- Also worked on Oracle forms/reports 6i/10g, XML publisher.
- Import/export of the database and database monitoring.
- Designing of Apex reports with Scheduling, emails & other complex features.
- Directly communicating with the client to handle day to day problems and changes.
- SQL & PL/SQL Performance tuning using explain plan, profiler & AWR analysis.
Skills
Oracle APEX Enterprise Resource Planning - (ERP) Oracle Forms SQL AWR Shell HTTP Electronic Data Interchange - EDI Triggers Data analytics PL/SQLTools
SQL DeveloperCompany
Reliance Energy Ltd (BSES)
Description
- Worked in Electricity Billing System, Meter reading management, Energy audit systems, Bill amendment modules.
- Designing of billing & meter reading related forms and reports in Oracle forms 6i.
- Developing SQL queries & PL/SQL Program units to extract data for business reporting.
- Data loading from multiple subsystems in Oracle database using SQL*Loader.
Tools
visual studio Toad