PROFESSIONAL SUMMARY:

• 6+ years of combined experience in analysis, design, development, maintenance and Support of Software’s in Banking and Trading Domain
• Highly proficient in Data Modeling and SQL, PL/SQL, T - SQL.
• Expert in creating Table, View, Materialized view, Sequence, Synonyms, Indexes, Trigger, Cursor, Package, Stored Procedure, Function
• Possess good exposure to back-end programming and hands on experience to Data Mapping, ETL Design and development
• Worked on ETL tool like Informatica, djCosmos
• Worked on Finacle (Core banking product by Infosys)
• Around 2 years of Performance Tuning experience on Explain Plan, TK Proof and Trace
• Experience on using tools for Monitoring and Tuning MS SQL Server Performance like SQL Profiler, Tuning Advisor and Query Execution Plan
• Experience on running jobs in the background and taking regular backups of the systems and restore data during failures
• Used Redgate tool for schema compare and data compare
• Work in advanced PL/SQL concepts like Bulk collect and FORALL
• Imported/Exported Data from different sources using Integration Services such as DTS, BCP,
• Created SQL*Loader scripts to load data into the temporary staging tables, intermediate tables
• Experience on Unix Shell Scripting
• Hand on creating users and assigning access level privilege for data security purpose
• Experience on Scheduling/Automating Jobs through Crontab and SQL Server Agent
• Well versed with MS Visio for developing Application Flow, Data Flow Diagram
• Proficient in interaction with end-users in Gathering Requirements, Ensuring their active involvement in Development Cycle, extensive experience in Software Development Lifecycle
• Supported the testing team with noledge transfer, Defect Management, Load testing. Created test cases for System Testing (Development Environment), Integration Testing (UAT) and Production (Post Implementation Review), review of the test case results and provided input to the testers or Production support team.
• Good Knowledge indesigning, developing and implementing complex reportsusing tool likes Crystal Report, Universes.
• Knowledge of NoSQL databases
• Knowledge of Data Warehouse, OLAP, SSRS
• Familiar with work environment Agile methodology and Scrum meeting
• Self-motivated and quick learner with excellent communication and presentation skills

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2012/2008/2005 MS Access, MySQL, DDBMS, RDBMS

Languages: C, SQL, PL/SQL, PRO*C, Unix, XML, Shell Script

Graph Database: Neo4j for Big-Data

Development Tool: Oracle SQL Developer, SQL Server Management Studio (SSMS)

Optimization Tool: Explain Plan, TK Proof, Trace, SQL Profiler, Tuning Advisor

Productivity Tool: Informatica, Redgate, Toad, BeyondCompare, MS-Visio, MS-excel, Liquibase, Finacle, DTS, djCosmos, Crontab, SQL*Loader

Version Control Tools: Tortoise SVN, Visual Source Safe, TFS

Protocols: TCP/IP, FTP, HTTP, SMTP, SOAP

Reporting Tools: Crystal Reports, SQL Server Reporting Services (SSRS)

OS and Servers: Windows 2000/ 2003/2008/ XP, Microsoft Windows 8/7, Unix

Project Management Tools: Redmine

PROFESSIONAL EXPERIENCE:

Confidential

Software Developer

Responsibilities:

• Working on reporting projects for Confidential Bank business requirements
• Involved in development and modifications of various monthly and yearly reports
• Working on query optimization of various reports to enhance the performance of report generation process
• Exposure to UNIX environment with commands and shell scripting
• Involved in report automation module to reduce the manual intervention
• Interacting and solving the functional and technical issues with Testing Team
• Work on Finacle for business user
• Providing the audit and Ad hoc reports
• Developed complex stored procedure, function, trigger, package
• TEMPEffectively managed team of two member

Confidential

Team Member

Responsibilities:

• Reviewing Change Request
• Analysis of Changes raised by Business / Process amendments
• Providing Estimates / Creating schedule
• Creating Impact Analysis Document
• Creating / Amending Flow Charts / Data Flow Diagrams
• Interacted with the Business Users with my inputs during Designing & Development phases
• Development / Amendment of Back-end code and Table Design
• Preparation of Unit Test Plans and Test Data
• Unit testing
• Reviewing peer’s code and peer testing
• Environment setup
• System Integration Testing
• Release Management
• System Testing support
• Operational Acceptance Testing
• Carrying out Mock Test
• Post Implementation Support
• Involved in Support of existing modules

Confidential

Team Member

Responsibilities:

• Interaction with the business users for gathering the requirements and integrating them in the system design
• Involved in Planning, Designing and Development of the application
• Extensive experience in Database development like table, stored procedure, view
• Preparing Design Documents and Flowcharts
• Creating and altering Stored Procedure, Function and logical codes

Confidential

Team Member

Responsibilities:

• Extensively involved in Data Extraction, Transformation and Loading (ETL Process) from source to target systems
• To understand client requests and convert the business requirement into technical logic and in corporate it into the process
• Creating SQL queries of high complexity involving joins and sub-queries
• Constructing cursor, trigger, procedure, function and view
• Worked at QA level for Quality Assurance of data loading
• Database Testing and Front-end testing to maintain Data Consistency and Accuracy
• Performing database testing & front-end testing for various modules using the test cases