Senior Database Developer Resume
SUMMARY
- Over 12 yearsof experience in architecture, analysis, design, development and implementation of business applications using RDBMS, mainly Oracle, SQL Server and PostgreSQL.
- MongoDB certified and over 1 year of experience implementing Scalable and High availability systems using replication and sharding.
- Experienced in Amazon AWS cloud infrastructure with reference to provisioning, security, and management of AWS RDS - PostgreSQL database.
- Experience working with Monitoring tools such as AWS CloudWatch.
- Experience working on Big Data eco-system mainly performing data driven activities using Scoop, Hive, Impala, Map-Reduce and Python/Shell Scripts.
- Proficient in ER modeling for OLTPand dimensional modeling forOLAP.
- Proficient in logical and physical database design, creating data flow diagrams, applying normalization techniques, designing ETL workflows, performance monitoring and scheduling jobs.
- Expert in utilizing Table Functions, Indexes, Table Partitioning, Collections, Bulk Collects, Analytical functions, Materialized Views, Execution Plans, etc., to build DB modules and to improve performance.
- Strong programming experience in writing complex SQL’s and business logic in PL/SQL, T-SQL, PGSQL and Unix shell scripting using DB tools like Toad, SQL Plus, SQL Loader, PgAdmin III, SSMS and Putty.
- Strong experience in writing ETL workflows using Informatica 9.x and SSIS.
- Strong experience in developing reports using Crystal Reports, Oracle Reports 10g, SSRS and Cognos.
- Experienced in administrative tasks like installation, users and security, backup and recovery.
- Led multiple teams, both locally and remote and at all stages of the SDLC including support and maintenance using agile methodologies.
- Functioned as primary contact for business users, stake holders and management during project lifecycle.
- Excellent communication and leadership skills working with various levels of business groups. And, take active initiations and responsibilities on project deliveries
- Professional team player with a positive attitude and the ability to multi-task in a dynamic environment.
TECHNICAL SKILLS
Databases: Oracle 11g/10g/9i, PostgreSQL, SQL Server 2005 & above, MySQL and MongoDB.
Database Tools: Toad, SQL Developer, PL/SQL Developer, SQL Loader, PgAdmin III, SSMS, MySQL Workbench, MongDB Compass, Mongo Shell.
Reporting & ETL: SAP Business Objects, Crystal Reports, Cognos, Oracle Reports, SSRS, Informatica 9.x, SSIS, 1Key Agile, MongoDB BI Connector.
Programming: PL/SQL, PGSQL, T-SQL, Python, Unix shell scripting, Oracle Forms, .Net, HTML and JavaScript.
OS & office: Windows, Linux, Unix, Microsoft Office products.
Workflow Tools: JIRA, HP Quality Center, HP PPM, IBM ClearQuest.
Version Control: TFS, SVN, IBM ClearCase, Visual Source Safe.
Big Data eco-system: Cloudera, Hue, Hive, Impala, Sqoop, Hadoop, and NoSQL.
PROFESSIONAL EXPERIENCE
Confidential
Senior Database Developer
Responsibilities:
- Designed and develop MongoDB documents and collections.
- Implemented MongoDB replication, sharding and indexing for huge data sets.
- Performed MongDB administration tasks - Backup/Recovery, configurations, security and administration.
- Wrote migration scripts for producing JSON documents from Oracle tables.
- Migrate Oracle procedures to PostrgreSQL functions and make changes to get the function equivalence.
- Performance tune PostrgreSQL functions using EXPLAIN.
- Involved in design and deployment ofPosgreSQL DB on AWS RDS and monitoring it through CloudWatch.
- Involved in setting up the security profile and administering the PostgreSQL database on AWS.
- Write complex Oracle PL/SQLstored procedures, functions and packages utilizing advanced features likebulk collection, Records, Tables Types, Object typesand Dynamic SQL.
- Write UNIX shell scripts for data processing and refreshing materialized views in the data warehouse.
- Facilitate sprint planning, daily scrums, retrospectives, stakeholder meetings and sprint review meetings.
- Support organizational Data Warehouse through appropriate utilization of Integration and ETL tools.
- Create database objects likeTables, Views, Materialized Views, procedures and packages using the database tools Toad, PL/SQL Developer, SQL Plus and PgAdmin III
Environment: Oracle 12c/11g, Exadata, Toad, SQL Developer, Putty, PgAdmin III, Mongo Shell, MongoDB Compass, MongoDB BI Connector, SVN, TFS, JIRA, SharePoint, IBM Rational Tools, Scrum delivery model.
Confidential
Senior Database Developer
Responsibilities:
- Managed the data migration activities to extract, transform and load legacy system data into new system using SQL, PL/SQL, UNIX and Windows scripting.
- Wrote complex PL/SQLstored procedures, functions and packagesfor data extraction and data manipulation as per the data migration needs.
- Facilitate sprint planning, daily scrums, retrospectives, stakeholder meetings and sprint review meetings.
- Coordinated with different level of team member for successful data migration & progress update on cleansing, mapping and enrichment.
- Worked on the database development for several other projects utilizing SQL Server 2008 and MySQL.
- Designed and develop complex reports using Crystal Reports, SSRS and Cognos.
- Used TFS for source control and JIRA for scrum management and bug tracking.
Environment: Oracle 10g, SQL Server 2008, SSMS, SAP Crystal Reports, SSRS, SSIS, Cognos, Toad, SQL Developer, Putty, TFS, JIRA, MongoDB 3.2, Scrum delivery model.
Confidential
Senior Database Developer
Responsibilities:
- Created complex PL/SQLstored procedures, functions and packagesfor data extraction and data manipulation as per the data migration/reporting needs.
- Created database objects liketables, views, materialized views, indexes, procedures, functions and packages using oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
- Coordinated with different level of team member for successful data migration & progress update on cleansing, mapping and enrichment.
- Trained team members to evaluate, coordinate and provide error free data migration solution.
- Developed complex reports using SAP Crystal Reports 2008, PL/SQL procedures and packages and integrate with Confidential, the e-licensing product.
- Used SVN for source control, HP Quality Center for bug tracking, JIRA for scrum management and workflow.
Environment: Oracle 11g, Toad, PL/SQL Developer, Crystal Reports, SVN, JIRA, HP Quality Center and Agile Scrum delivery model.
Confidential
Scrum Master/Senior Software Engineer
Responsibilities:
- Successfully piloted the development teams through transition from waterfall to Agile scrum development model.
- Coached team members on Agile processes and facilitated daily scrums, planning meetings, sprint review and retrospective meetings.
- Developed complex PL/SQL procedures and packages for data extracts, SWAN system enhancements, claims data loading and data validation.
- Formulated a generic process to support automated loading of claims data from multiple partners and in different file formats.
- Developed complex PL/SQL and UNIX components to automate the loading of claims data from several different sources into SWAN.
- Created various complex reports using Oracle Reports, Crystal Reports and SSRS.
- Collaborated with Business Analysts/Product Owners to discuss user stories and design business logic for appropriate changes to database objects such as Tables, Views, Packages, and SQL procedures.
Environment: Oracle 11g, Toad, PL/SQL Developer, UNIX, Putty, Oracle Reports, Crystal Reports, SSRS, .Net, Java TFS, HP Quality Center and Agile Scrum delivery model.
Confidential
Senior Software Engineer
Responsibilities:
- Worked on major enhancements to the Underwriting, Claims and Accounting modules of Insurance application.
- Developed SQL scripts to read Chart of Accounts data from excel file and load into database.
- Developed various complex accounting reports using Oracle Reports 10g.
- Actively participated in the requirement gathering and documentation phase.
- Played a key role in the architecture and design of the data model and physical database.
- Customized the database SQL Procedures, Packages, Views, and Functions as per technical specifications.
- Developed Cubes and various on-demand and ad-hoc custom Reports using 1 Key Agile, SSRS and Cognos.
- Was a key member of the ETL team to extract and load data from the existing legacy system into Agilis by using complex PL/SQL logic.
- Made use of the Data Dictionary and the PL/SQL noledge to extract the database table, column, data type information in a format needed for data migration.
- Created the data migration templates.
- Trained business users on 1 Key Agile BI tool to develop on-demand and ad-hoc reports.
- Pro-actively resolved technical issues and software/data defects through debug, research and investigation using SQL Monitor and Toad.
- Developed websites and portals in classing ASP and VB Script for logistics systems and Insurance systems.
- Worked on major enhancements in the ERP and logistics systems built on .Net and Oracle 9i.
- Wrote complex PL/SQL logic and VB.net code to correct major issues in stock handling logic of ERP systems.
- Developed complex reports such as Material Requirement Details, Work in Progress valuation, Product Detailed Yield analysis, etc. using Crystal Reports 8.5.
Environment: Oracle Forms 10g, Oracle 10g, SQL Monitor, Toad, PL/SQL Developer, SQL, PL/SQL, SSRS, Cognos, 1Key Agile BI Reports, Toad, SQL Developer, Visual Basic 6.0, ASP, VBScript, HTML/DHTML, JavaScript and VSS