SUMMARY:

Masters in Computers having around 16 years of experience in Information Technology. Highly qualified Database Technology extensive experience developing numerous databases to support data warehousing (OLAP) & OLTP environments. Strong detail - oriented data analyst capable of participating in cross-functional teams. Oracle Certified Professional in Oracle 9i/10g/11g. Hadoop bigdata Hadoop Hive, Sqoop, flume, HDFS and Pig certifications from Bigdata University certifications and scrum master certification

SPECIFIC EXPERTISE:

• Analysis of business requirements and system design
• Deep understanding of Software Development Life Cycle
• Install, configure, upgrade software: server, tools, applications
• Designed the logical database using ERWIN, Power Designer 9.0 and Designer 2000
• Design and implemented DB security, user management
• SQL and PL/SQL: scripts, triggers, procedures, packages, automation projects.
• Support developers in tuning SQL, procedures and apps for optimal performance.

TECHNICAL SKILLS:

LANGUAGES: Pro *C, PL/SQL ver2, UNIX Shell Scripting, Perl Script, JavaScript, COBOL, C, C++, Java JAVA ENVIRONMENT JDK, GUI Developer 6i(Forms 6i, Reports 6i and Graphics 6i), RDBMS Oracle 7.3, 8, 8i, 9i & 10g 11g,12c & SQL Server 2000, DB2 UDB 8.x

PROFESSIONAL EXPERIENCE:

Confidential, Weehawken, NJ

Senior Data Architect/Development DBA

Responsibilities:

• Working with BA’s from the requirement gathering.
• Implement the requirements in logical model and present the model to Business users and BA’s
• Maintain the naming standards in Erwin model master
• Implement the changes in Development database on objects.
• Had implemented for the certain dimension tables for data quality checks by using oracle hash function.
• Developing pl/sql packages, procedures for the market risk team requirements.
• Working with the developers close the gaps in question and performance queries address if anything arise during the developments
• Maintain the version control for the models and compare after the releases to make sure model and physical database are in sync.
• Release the documentation on the entity, Attributes and data types.
• Doing the POC from migrating the data from oracle to Hadoop using sqoop.
• Storage requirements /Planning for the databases
• Work with developers very closely in fixing issues and guide lines for the performance improvements periodically.
• Work with developers on performance related issues and resolve them.
• Doing POC with HBASE, Hive NoSQL databases and leveraging database with Elastic Search/GPU databases.
• Working with QA team on fixing bugs
• Supporting production releases.

Confidential, Princeton, NJ

Senior Data Architect/Development DBA

Responsibilities:

• Expert Data Modeler and Designer and a deep understanding of developing transactional enterprise data models using Star and Snowflake schema, normalization verses de-normalization, referential integrity etc.
• Implemented end-to-end database design, right from interview customer, gather information, logical and physical design
• Developed the Logical model and presented to the application team and business team.
• Physical data model to generate the DDL changes and share the model with the DBA team to generate the DDL changes
• Naming standard for the database objects for across the R&D units.
• Documented technical specifications of the new database design
• Designed the data model considering the performance of the applications.
• Old Equity core team database had DSS and OLTP requirements combined and simplified the requirements and separated the database into the OLTP and DSS into it’s own database.
• Developed PL/SQL Packages, Stored Procedures, Functions, Triggers, Tables/Views and SQL queries to effectively in corporate Business rules and reusability of the codes is key to the projects.
• Managed developers for the deliverable in agile methodologies for multiple projects.
• Used Erwin for data modeling tools
• Projects progress are tracked and delivered using Agile and Scrum methodologies.
• Implemented the client caching oracle features for the Extraction Team.
• Wrote PL/SQL stored procedures for the complex business needs
• Implemented the partition tables/ for the reported features for the application
• Implemented the PL/SQL data pump features to promote the data from one environment to another environment.
• Wrote numerous UNIX shell scripts for automating jobs
• Implemented the Oracle Advanced Queues to Process the documents and extract the documents on timely fashion.
• Maintained one of the critical database and development activities
• Was part of the data governance team and responsible for the data quality for the Equity data that was scrapped from HTML and PDF documents
• Basically developed the QC rules that would validate the data quality.
• Had worked extensively in early Mongodb database for document store with the replication.
• Hosted microservices out of the Mongodb databases using pymongo.
• Interacted with MDM folks to get core dimension data.
• Fine tuning SQL statements to speedup overall health of the system.
• Supported the application for upgrades from Oracle 10g and 11g.
• Proactively identifying the database bottlenecks performance using AWR, ASH reports.
• Designed Informatica jobs for continual updates for the DSS database from various databases (Postgres, SQL Server and Oracle 12c)
• Wrote ETL jobs in SQL loader and UNIX shell scripts for scheduling and DTS in MS SQL server.
• Wrote numerous Python RESTful/SOAP services.
• Wrote ETL jobs using Python to move data from other (berkeylydb) to HIVE and HBASE in Hadoop.

Confidential, New York, NY

Data Architect

Responsibilities:

• Developed the ERWIN model for all the above exiting applications /Reversed Engineered
• All the development changes are discussed with team and maintained physical models changes to generate the DDL.
• Worked with Business Analyst for the new requirements and presented the models with development team and address their concerns
• Naming standard for the database objects for across the Prime brokerage units.
• Documented technical specifications of the new database design
• Presented the Data Model with business team as well as development team.
• Designed the data model considering the performance of the applications.
• Developed PL/SQL Packages, Stored Procedures, Functions, Triggers, Tables/Views and SQL queries to effectively in corporate Business rules and reusability of the codes is key to the projects.
• ETL was
• Managed a team of data modelers and DBA’s for the project coordination.
• Migrated DB2 UDB8.1 databases to oracle 11g.
• Worked closely with developers, business team and performance team to trouble shoot and potential issues and rectified them.
• Worked extensively in Golden Gate to replicate the data between databases to keep the databases in active mode.
• Designed and developed row level security using Application Context and FGAC (Fine Grain Access Control) Oracle Techniques to be used for the Risk applications.
• Suggested and deployed the performance improvements using PL/SQL types, bulk load, collections, and bind variables to improve the load performance.
• Working in largest database in Merrill Lynch for the client reporting data warehouse database on 4 node RAC environment.
• Monitoring the query performance using Explain Plan & SQL Trace
• Setup 3 way replication between US, EURO and Asia Pacific
• Good understanding and experience with oracle 9i/10g/11g Real application cluster.
• Packed the production release scripts for the production DBA’s and coordinated the releases
• Developed the scripts in development database, promoted the scripts to staging and production database
• Database permissions are controlled through Roles for the application users and production support users.
• Redesigned the queries slow performing queries by MV’s and Partitions to improve the performance
• Wrote the stored procedure to alert the production support team when the critical data load job failures.
• Worked with production support team and production DBA’s to fix the data issues in production databases.
• Wrote shell scripts to load the data from flat files and automated the Partition creation, dropping the partitions and Materialized refreshes
• Limited exposure/experience with Cognos reporting tool.
• Create and schedule Unix Scripts to control the night batch loading processes using autosys schedulers.
• Worked with testing team very closely on performance testing and rewritten the regressed SQL.

Environment: Oracle 10g/11g, UNIX & Linux , Unix Shell Scripting

Confidential, NJ

Database Architect/ Sr. DBA

Responsibilities:

• Participated in database consolidation of various insurance applications into single large OLTP database.
• Involved in Logical data model of the various applications by collapsing the commonly used tables using ERWIN tool and model mart.
• Involved in performance tuning of data warehouse & OLTP projects.
• Worked with infrastructure team to understand and hence evaluate/recommend best technology available.
• Migrated data from AS/400 and UDB to Oracle databases.
• Acted as a technical expert on the implementation of business requirements
• Participated in various documents repository tools like Documentum
• Responsible for the analysis of business requirement and evaluation of potential solutions to provide an efficient and cost effective system design
• Created comprehensive project documentation with FAQ's to help the support team to understand the project details and provide efficient service.
• Authored UNIX shell scripts to execute ETL scripts
• Written PL/SQL packages for data cleansing and partitioning the tables based on the trade type.
• Manage project schedules, change management, database development, production, and application implementation.
• Worked on Oracle 9i RAC environment for oltp environment.
• Developed PL/SQL Packages, Stored Procedures, Functions, Triggers, Tables/Views and SQL queries to effectively in corporate Business rules and reusability of the codes is key to the projects
• Monitoring the query performance using Explain Plan & SQL Trace
• Packed the production release scripts for the production DBA’s and coordinated the releases
• Wrote complex procedures, functions and packages for the integrated databases.
• Developed the scripts in development database, promoted the scripts to staging and production database
• Redesigned the queries slow performing queries by MV’s and Partitions to improve the performance
• Wrote shell scripts to load the data from flat files and automated the Partition creation, dropping the partitions and Materialized refreshes
• Worked with production DBA team on QA refreshes with production data.
• Worked very closely with DBA team on implementing the two way streams for an application.

Environment: Oracle 9i/10g/SQL Server, Unix, Autosys

Confidential, OH

ODS Claims & National Platform

Responsibilities:

• Developing various Packages, Stored Procedures and Functions for backend processing of database
• Creating database Tables/Views by performing table layout analysis and design with emphasis on Referential Integrity
• Enhancing the database performance by creating Table Indexes
• Optimizing database Packages, Procedures, Functions, Cursors, Triggers and Tables/Views
• Creating Crystal reports in the application for Managers/Supervisors
• Developed PL/SQL Packages, Stored Procedures, Functions, Triggers, Tables/Views and SQL queries to effectively in corporate Business rules and reusability of the codes is key to the projects
• Monitoring the query performance using Explain Plan & SQL Trace
• Packed the production release scripts for the production DBA’s and coordinated the releases
• Migrated the data from AS/400 to DB2 UDB and Oracle.
• Wrote complex procedures, functions and packages for the integrated databases.
• Developed the scripts in development database, promoted the scripts to staging and production database
• Redesigned the queries slow performing queries by MV’s and Partitions to improve the performance
• Wrote shell scripts to load the data from flat files and automated the Partition creation, dropping the partitions and Materialized refreshes
• Worked with production DBA team on QA refreshes with production data.

Environment: IBM UDB 8.0, Oracle 9i, Crystal Reports 8.5 and Unix shell scripting

Confidential, MI

Database Architect/ Sr. Database Developer

Responsibilities:

• Installed Oracle 9i database on Sun Solaris and AIX 5.2
• Installed and configured Oracle RAC for Call Center business.
• Transformed the business requirement into Logical data model.
• Built the logical data model using Power Designer 9.0.
• Database designed reviews with Business users.
• Designed the layout for Development, UAT and production databases and their capacity planning for databases.
• Transformed the logical database into physical database.
• Migrated the database objects to multiple database environments.
• Managed & worked with the database programmers.
• Actively participated in Application tuning and helped the developer to write optimized the SQL statements
• Tuned the database for heavy volume transactions.
• Wrote Unix shell scripts to automate the daily database batch jobs.
• Wrote Unix shell scripts to automate the basic administration tasks.
• Installed & Configured BMC Patrol Database Monitoring Tool.
• Worked closely with Unix Administrator to resolve frame and SAN related issues.
• Mentored Junior Database Administrators.
• Installed and Configured DB2 UDB 8.1 on UNIX (AIX) and Windows 2000.
• Created Instance and created database.
• Created Migrated Db2 UDB objects between different environments.
• Installed and configured DB2 Connect servers and cataloged AS/400 and OS/390.
• Ran the Db2advis and created recommended indexes in the development environments
• Ran Db2mtrk utility to track the db2 memory in AIX 5.1

Environment: Oracle 9i, Solaris 2.8, Java, Script, J2EE, EJB, Struts, Java, Web Sphere.