SUMMARY:

• 12+ years of experience with various Relational Database systems (RDBMS), (Oracle 8i, 9i, 10g, 11g, 12c, Mysql 4.1, 5.1, DB2 LUW) and ORDBMS (PostgreSQL) working as Developer, developing back - end modules, such as packages, functions, procedures, triggers, object types, views, snapshots for multitier business applications, all Data Warehouses, OLAP and OLTP systems.
• 12+ years of experience in scripting, analytic reports and SQL ad-hoc queries, by urgent requests from various business units.
• 10+ years of concentrated experience of Performance Analysis and SQL query tuning, response time reducing, while designing scalable applications from scratch and maintaining existing ones, using AWR, Profiler, EXPLAIN PLAN and TKPROF. Good Confidential of key Oracle performance-related features, such as cost-based optimizer, execution plans, hints, indexes, clusters, partitioning, temporary tables, v$-views.
• 10+ years of experience in Data integration/migration and ETL/ELT processes, scalable Data Modeling, creating ER-Diagrams, Data Flow Diagrams.
• 10+ years of experience in gathering, manipulating, and analyzing large sets of structured/unstructured data
• 6+ years of experience in Business Analysis, gathering of business requirements, functional and technical specification writing.
• 3+ years of experience with NoSQL db like Mongodb.
• Strong Confidential of Object Oriented Programming and experience in developing various client server applications for Windows platforms, using Visual Basic, VB.NET, C++. Strong working Confidential of Java/J2EE..
• Highly experienced in managing multiple projects and deliverables in a fast-paced environment.
• Experience in testing database applications - creating test cases, user testing, regression testing, UAT, load testing, bug fixing, trouble-shooting.
• Strong Confidential of UNIX shell scripting.
• Working Confidential of the different components of Hadoop ecosystem.
• E xcellent exposure to DBA routine tasks; can be self-serving DBA, managing users, roles, privileges, schema and objects, developing PL/SQL triggers for user access audit. Experience in data loading, export/import, backup/restore, session monitoring, providing technical support to Oracle users, Oracle Client installation, and network environment setup.

TECHNICAL SKILLS:

Operating Systems: Linux, Unix, Solaris, MacOSX, MS DOS, Windows XP/2000/2003/Vista/7

Databases: Oracle 8i/9i/10g/11g, Mysql 4.1/5.1, Mongodb 3.2, PostgreSQL, AWS Redshift, Ms SQL Server, MS Access

Database Tools/Utilities/IDE: PL/SQL Developer, SQL Workbench, SQL Navigator, Eclipse, SQL*Plus, TOAD, SQL*Loader, SQL Developer, Profiler, EXPLAIN PLAN, TKPROF, OEM, AWR, Informatica, ODI

Programming Languages: PL/SQL, SQL, PL/pgSQL, Python, C, C++, VB, Java/ J2EE, Delphi, and VB.NET

Web Technologies: JSP, CSS, XML, JSON, HTML, DHTML, JavaScript, Macromedia Flash,

Software Tools: MS Office and MS Visio, Crystal Report, UC4 Scheduler Computer Hardware and Networking Skills

PROFESSIONAL EXPERIENCE:

Senior Consultant - Lead Database Developer 

Confidential, New York, NY

Environment: Windows, Linux, Oracle11g/12c, SQL, PL/SQL, SQL Developer, SQL*Loader, Workbench, Putty, Mulesoft, Jenkins, Hybris, XML, UC4, Github, Agile, AWS, Amazon Redshift, python, Postgress 9.6.2, PL/pgSQL

Responsibilities:

• Lead the data migration design, coding and implementation for the ecommerce re-platforming effort.
• Worked closely with business users to gather business requirement and come up with technical and functional requirement.
• Lead the application for Base Data Management (BDM) and Create your Own (CYO).
• Developed various PL/SQL packages/procedures, PL/pgSQL functions to support the business functionality.
• Created shell scripts in Linux to automate the data load.
• Worked on Performance Tuning for new and existing queries in Oracle and Redshift.
• Collaborated with other cross-functional teams like BI, Site setup, Middleware Integration and other application owners.
• Worked on creating various functions in AWS redshift.
• Worked on loading data files from Amazon S3 to Redshift database.
• Worked on creating various adhoc reports.

Sr. Database developer

Confidential, New York, NY

Environment: Windows, Unix, Linux, Oracle10g/11g, Postgres, PL/pgSQL, MacOSX, Ms SQL, SQL, PL/SQL, TOAD, SQL Developer, SQL*Loader, Putty, ODI, UC4, Blue martini, DB2, WCS, Informatica, Mongodb, JSON, XML, UC4, Google Analytics, Github, SVN, Agile

Responsibilities:

• Responsible for database architecture, creating data models (Conceptual/Logical/Physical), Data Management policy development, support and QA activities of data management developments.
• Worked as a team lead and managed and mentored junior developers.
• Managed data warehouse projects from inception to delivery.
• Involved in creating the Master Data Management.
• Coordinated with the various IT and cross functional system owners to design and deliver integrated Data Management solutions that will result in operational efficiency and a high data quality standard in the provisioning and distribution of enterprise data.
• Involved in design and development of ELT/ELT process development for the data warehouse to support various business units like planning, BI, Merchandise operations and Marketing.
• Designed and created the ETL process to move data from/to relational database (oracle/db2/Teradata) to/from the non-relational database (mongodb) for various micro web services.
• Developed various scripts to generate data in JSON format to communicate with various partners API.
• Experience working with REST API with CURL.
• Developed various bash shell scripts in Linux to automate the data load and other jobs.
• Involved in migration of the crontab jobs to UC4 scheduler by designing the process flow and scheduling it with external/internal dependencies.
• Worked closely with web analytics team supporting the google analytics and tag management.
• Developed various PL/SQL procedures/packages, PL/pgSQL functions for the implementation of various functionality.
• Developed various data replication using materialized views.
• Creating programming interfaces between legacy systems and new Product Information Management system.
• Designed and developed various interfaces in Oracle Data Integrator (ODI).
• Lead the implementation of version controlling system, SVN/DBDEPLOY and GO for data warehouse environment.
• Worked on Performance Tuning for new and existing queries by using Indexes, Explain plans and various hints.
• Worked on automating various data feed to third party vendors using shell scripts to spool the data, encrypt and ftp the file.
• Worked closely with the marketing team to support and improve customer segmentation, email acquisition from various sources and other email marketing initiatives.
• Liaised with BI team to provide them with the data they need for the daily/weekly/monthly reporting.
• Worked with website development team to provide them with backend support for the database in an effort to add various new features to the website such as refer a friend, waitlisting items, site personalization.
• Worked on creating dashboards for email database that identifies the key areas of the reporting environment for marketing email database and allow drill down that highlights the supporting detail level.
• Implemented processes to improve activity monitoring, alerts and status notification.
• Involved in migration of oracle 10g to 11g.

Sr. Database Developer/ Programmer Analyst

Confidential, Englewood Cliffs, NJ

Environment: Windows, Unix, Linux (CentOS), Oracle 9i, 10g, My SQL, SQL, PL/SQL, Java, JSP, Visual Studio (VB, C++, VB.NET), TOAD, SQL Navigator, SQL*Loader, Asterisk, Putty, Visio, etc.

Responsibilities:

• Formulate detailed plans; outlining steps required to develop programs using structured analysis and design; design user interfaces to accomplish goals of user request; convert project specifications using flowcharts and diagrams into sequence of detailed instructions and logical steps for coding.
• Run ad-hoc SQL queries and design and develop reports as per the users’ requirement using oracle analytical SQL functions, PL/SQL, shell scripts and Crystal Report.
• Develop and maintain specification documentation to describe program development, logic, coding and corrections.
• Develop test plans, test case, test scripts and test procedures.
• Perform requirements analysis, data requirements documentation, data warehouse/data mart design, ETL requirements specification, Metadata documentation, and data quality support.
• Implement data models and database designs, data access.
• Resolve database performance issues, database capacity issues, replication, and other distributed data issues.
• Collaborate with DBA and programmers on both production and development environments with database design and integrity issues.
• Involved in design and development of ETL process development for the data warehouse.
• Support the designing, developing and debugging of web based business application using JAVE, J2EE, CSS, ASP, JSP, HTML, DHTML, XML, etc.
• Create and maintain existing scripts, database objects, stored procedures, packages, sequences, indexes and tables.
• Wrote several shell scripts scheduled to run batch job periodically.
• Evaluate, test and provide recommendations for new tools for enterprise database management.
• Support the installation, configuration, maintenance and administration of Oracle database. Manage Oracle table space, data files and performance tuning.

Developer/ IT/ IS Specialist

Confidential, Morristown, NJ

Environment: Windows, Oracle 9i, Ms SQL Server 2000, Ms Access, SQL, PL/SQL, VB 6, SQL Navigator, TOAD, IIS, Crystal Reports, SQL Loader

Responsibilities:

• Involved in analysis of existing system and suggested enhancements.
• Involved in creating and reviewing business requirements documents.
• Involved in recovery, database export/import, listener management, monitoring server performance, and performance tuning.
• Developed database packages, procedures, functions, and database triggers to implement business functions.
• Involved in fine-tuning stored procedures by making use of PL/SQL Collections and its BULK FETCH and BULK INSERT features.
• Involved in ETL Development using native Oracle tools (SQL*LOADER, Oracle PL/SQL).
• Involved in creating Specification Documents, Mapping documents, Data Flow Diagrams, ER Diagrams, Dependency documents.
• Used DTS to transfer files from Excel datasheets and text files to SQL server database
• Developed scorecards for the system using SQL Server reporting services.
• Involved in data normalization process.
• Developed database backup and recovery strategy.
• Performed query analysis, performance monitoring and tuning
• Reviewed quality assurance and user acceptance test plans.
• Created various reports using Crystal reports as per business Requirements.
• Involved in business analysis user requirements for the ad-hoc reports and reports show Month-To-Date, Year-To-Date Data, reports from Archive Database and Data Warehouse Reports.
• Created different type of Crystal reports including Cross-tab, Conditional, Drill-down, Top N, Summary, Form and Sub reports.
• Involved in installation, administration, database creation and building and scheduling jobs for maintenance for Ms SQL Server 2000 database.
• Resolved technical issues and researched best practices for the monitoring, support, maintenance, and implementation of applications.

Graduate Assistant - Programmer/Analyst

Confidential, Teaneck, NJ

Environment: Windows, Linux, Oracle 9i, PL/SQL, SQL Navigator, SQL Plus, SPSS

Responsibilities:

• Created packages, procedures, functions and database objects like tables, views etc. according to technical specifications using SQL Navigator and SQL PLUS.
• Collected data (from internal and external sources) and, analyzed, interpreted and disseminated the information to various University constituencies.
• Used EXTERNAL TABLES and SQL*Loader to load data from a third-party into Confidential database and data-warehouse tables.
• Assisted the data warehousing team for creating data-marts, data integration and creating ETL work-flows.
• Designed and developed forms and reports for student surveys.
• Involved in the creation of student factbook.

MIS/ IT Officer

Confidential

Environment: Windows, Merak Mail Server, Oracle 9i, Ms SQL Server 2000, Ms Access, VBA, VB 6, UNIX, IIS, SQL, SQL*Plus, PL/SQL Developer,

Responsibilities:

• Implemented structure and data changes, database and SQL tuning, database and client installation and upgrades, backup and recovery, database availability, writing administration script.
• Supported and resolved SQL Reporting services and T-SQL related issues.
• Used DTS jobs for importing data from legacy systems to the current model.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and scripting/data Migration with SQL server Export Utility
• Involved in complete life cycle of the project and experience in interacting with end users right from collecting requirements to production support.
• Involved in migration of Ms SQL Server 2000 to Oracle 9i
• Extensively involved in migrating existing T-SQl to PL/SQL.
• Maintained and created UNIX shell scripts to automate jobs.
• Analyzed data and business processes, improved workflow.
• Supported month-end processing, initiated change control, created custom ad-hoc reports, maintained version control, authored user guides and technical documents, and built/maintained solid customer relations.
• Participated in the design, management, and implementation of PSI/Nepal’s MIS including the development of databases relevant to all organizational functions.
• Compiled and disseminated timely Monthly Reports (e.g. sales, procurement and quality monitoring) and other operational reports needed by the senior management.
• Managed the IT Operations and involved in decision making of various IT Projects.

System Analyst

Confidential

Environment: Windows, My SQL, JSP, Tomcat

Responsibilities:

• Involved in the system analysis, design and development of Refuse Collection System (RCS) using JSP and My SQL.
• Involved in the end user acceptance testing and training.
• Implemented and supported the application.

Database developer

Confidential

Environment: Windows, Ms SQL server 2000, VB 6,

Responsibilities:

• Gathered and documented user requirements for employee payroll system.
• Designed and developed employee payroll system using VB6 in the front-end and Ms SQL server at the backend.
• Involved in the end user acceptance testing and training.
• Implemented and supported the application.