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