Senior Software Engineer

A Senior Software Engineer with 10 ten years of work experience in design and development of RDBMS and Big Data. Having 8 years of extensive experience in Oracle DB Design and 1 Year in Big Data like Hadoop Mongo DB.

SUMMARY:

• Implemented business solutions in Credit Score domain.
• Implemented business solutions in Secondary Mortgage domain.
• Implemented business solutions in Consumer Goods Retail domain.
• Implemented Data transfers between Hadoop and Non-Hadoop systems using Sqoop/Hive.
• Hands-on experience with HiveQL, Sqoop and Impala.
• Hands-on experience on data format like ORC and AVRO.
• Designed Implemented DB Architecture for MongoDB.
• Designed Implemented Data Warehouse Architecture.
• Designed Implemented Oracle DB for OLTP System.
• Experienced in SQL/PLSQL/Advance Features like VPD/Queue/Expression Filter etc with Oracle11GR2.
• Hands-on experience with Core Java.
• Experienced in data modeling using tools such as MS Visio, ERWIN.
• Experienced in development methodologies such Waterfall, Agile Scrum and Iterative.
• Experienced in working on Operating Systems like Windows, Linux and AIX.
• Self-motivated, Aggressive Team Player, Positive Attitude and Adhere to Strict Deadlines.
• Has got excellent analytical, communication and programming skills.

Technical Skills:

PROJECT EXPERIENCE:

Confidential

Position: Technical Specialist

Environment: Oracle 11g R2, .Net

Description: Confidential is the Web-based portal, lenders and their designated agents use this to electronically submit loan appraisal data files prior to loan delivery to Fannie Mae and/or Freddie Mac Government Sponsored Enterprises or GSEs . Appraisals may be in pdf format or in XML MISMO format. Appraisal files are validated for the data format and file size. Once the appraisals are validated then its contents are validated with some business rules and hence findings and hardstops are generated for further analysis. Once the appraisals are successfully uploaded and validated then the system can generate the score for loan evaluation. GSEs use this score to appraise the loans.

Responsibilities:

• Data Modeling using ERWIN Tool
• DB Design for Oracle 11g R2
• Implementation of Oracle Advance features like VPD Policies, Advance Queue, and Expression Filters etc.
• Writing complex SPs.
• Performance Tuning.
• Root cause analysis and trouble shooting of production issues.
• DB training and mentoring for all the unit members.

Confidential

Position: Sr. DB Developer

Environment: Java , DB2, MongoDB

Description Confidential Advertising platforms together by providing a unified delivery system and retaining best from both platforms. A general API layer is required for system integration. Built entirely with open source tools and technologies, the Web API, a part of this layer, is available as Web services for consumers of varied platforms. The API provides interfaces for complete control of the administration of Advertising campaigns via interfaces such as Campaign, Website, Customer, Advertiser and Banner Management.

Responsibilities:

• Provide support in database architecture of the organization for data warehouse through database design, modeling and implementation.
• Created numerous simple to complex queries involving self joins and correlated sub queries for credit reports.
• Writing PL/SQL stored procedures and implementing it through Pentaho job, triggers to perform the data cleaning/maintenance activities.
• Preparing static/master data from functional specification document and loading into the DB through Pentaho ETL.
• Maintain and prepare documentation of the data architectural process and progress.
• Training and mentoring to the team members.

Learning:

• Manage the exceptions of large size of data.
• Experience with Scrum methodology.
• Exposure to DB2 MongoDB.

Confidential

Position: Sr. Software Engg

Environment: .Net, Oracle 10g, Windows 2003

Description: Confidential 5 modules made for more than 150 entities including retail outlets, franchise outlets, market region warehouses and suppliers having around 1500 users having local servers connected through centralized server with public IP. Data is transferred every half hour from and to central server and local servers.

Responsibilities:

• Planning data migration process and validating the processed data.
• Assisting senior architect in development of conceptual, logical, and physical data models.
• Writing the procedures to validate the consistency and integrity of data using queries and store procedures. Also Size estimation of all the tables according to the current and future transactions of business.
• Writing ad hoc complex queries, Oracle PL/SQL Code to meet business requirement or audit report.
• Training and mentoring to the team members.

Learning:

• Exposure to Consumer Goods Retails Domain.
• Exposure to Core of ERP.
• Exposure to ERWIN Data Modeling tool.

Confidential

Position: Software Engg

Environment: VB6, Oracle10g, Windows

Description: Confidential of row materials of companies, without intervention of human. Smart card implementation with PC and hand held terminal. Records are written to Smart Card and in database both.

.

Responsibilities:

• Evaluate client requirements and collaborate with other teams on the requirements for the overall application.
• Database study and designing using several tools DFD, ER-Diagram .
• As the lead developer for the Weighment Processing team, did table creation, constraints implementation, integrity checking, stored procedures writing, triggers writing for data integrity.
• Code writing using Oracle PL/SQL and performance tuning at production database.

Learning:

• Exposure to Client interactions and meetings
• Exposure to Smart Card programming.

Confidential

Position: Asst. Programmer

Environment: VB6, Oracle10g, Windows, Unix

Description: Employees Record Keeping, GPF No maintenance, Advance amount, arrear calculation, calculation of final balance according to reduction, arrear, deposited amount.

Responsibilities:

• Evaluate client requirements and collaborate with other teams on the requirements for the overall application.
• Database designing, data migration.
• Code writing using Oracle PL/SQL and performance tuning at production database.
• Trouble shooting and root cause analysis.
• Development of new features and enhancements as per customer requirements.