Work Experience

Over 8 years of experience in development and deployment of Application Software.

Solid exposure to Finance, Mutual fund and Health care domains.

Over 5 years of experience as a tech lead on various projects.

Experience Summary

• Experience in project management, system analysis design, construction, deployment, change management, verification and validation of Web Based Applications and Back end Applications.
• Strong Experience in Oracle and PLSQL.
• Expert level skills in Data Mapping, Normalization, Batch jobs, Troubleshooting, Data migration, Data collation, Data cleansing, Entity Relationship Design ERD model and application oriented design.
• Experience in PERFORAMNCE TUNING and Optimization using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor and Query Execution Plans.
• Expertise in writing Complex Stored Procedures, creating Triggers, Cursors, User-defined functions, and Joins.
• Experience in design of ETL Packages using SSIS for integrating data from heterogeneous sources Excel, flat file, Oracle, Access, DB2, XML format using multiple transformations.
• Hands on experience in creating SSIS packages with Error handling, Logging, Package configurations and by implementing Break Points, and Check Points as well.
• Experience in creating and parsing XML using PLSQL packages.
• Experienced using various methods to Execute SSIS packages and Deploying through different modes.
• Experience in creating Jobs, Alerts and scheduling SSIS Packages using SQL Mail Agent.
• Experience in Migration of packages from SQL 2000 to SQL 2005.
• Exposure to Agile methodology SCRUM .
• Familiar in core Java and J2EE Technologies like Servlets, JSP, JMS, JDBC, JNDI.
• Experience with UNIX.
• Source code control systems like Subversion, CVS.
• Familiar in complex messaging and routing systems using IBM MQSeries

Technical Skills

Project Profile

Confidential

SQL Developer

Roles and Responsibilities:

• Working extensively on highly concurrent applications managing the various stages of a transaction life cycle
• Worked on a Complex Event Processor i.e used to trigger specific work flows and to generate Real time events.
• Designed and developed Matrix and tabular reports with drill down, drill through and drop down menu options.
• Created complex stored Procedures, triggers, cursors, and SQL joins for applications.
• Developed tables, views, indexes, functions and advanced queries for databases.
• Gathered functional requirements, Business requirements and wrote the technical specifications for building the Global Enterprise Data warehouse.
• Created Indexes and maintained FILL FACTOR for fast and efficient reporting process.
• Used SQL Server Profiler to monitor for long running queries and tune them to improve performance.
• Developed SSIS packages to bring data from Oracle, Excel, XML, and Flat Files into SQL db
• Involved in the full life cycle of ETL software development - analysis, design, build, documentation and testing for the project.
• Webservice communication in PL/SQL: Created common stored procedure to access Webservice.
• Sending message to IBM MQ Series: Using AQ MQ Mechanism sending message to IBM MQ Series.
• Created complex reports that draw data from SQL and Oracle, and loaded them to Report server URL.
• Generated on-demand reports and scheduled reports for business analysis or management decisions.
• Formatted Reports using Global Variables, Expressions and Functions and implemented stylish report layouts.
• Scheduled reports for daily, weekly through Report subscriptions based on business needs.
• Regular monitor of servers, which includes backups and troubleshoot all the issues on regular basis.
• Worked on tasks like Execute SQL, ftp, Send mail, for each loop container, Derived column, conditional split.
• Solution Environment:
• Oracle SQL/PLSQL, SSIS, SSRS, J2EE, SPRING, HIBERNATE, Oracle, JMS, MQ Series

Tools: SVN Subversion , PL/SQL, SQL Developer

Confidential

Java/Oracle PLSQL developer

Roles and Responsibilities:

• Implemented Event Handlers in SSIS packages for error notifications.
• Created clustered, non-clustered indexes for querying data faster.
• Used performance monitor and Sql profiler to enhance performance of database servers.
• Used Database engine tuning advisor for creating indexes.
• Changed existing stored procedures according to new hierarchy.
• Carried out performance tuning to optimize the run time of processing.
• Creating stored procedures, joins, functions to meet business rules.
• Normalized tables and maintained Referential Integrity by using Triggers and keys.
• Developed SSIS packages to bring data from Flat Files, Excel files, Oracle and deployed to production server using package configurations.
• Worked with different methods of logging in SSIS and created jobs.
• Created SSIS Packages with error handling and implemented breakpoints to check status of package.
• Used transformations like conditional split, row count, derived column, union all, character map, merge and containers like for each loop, sequence container.
• Performed data transfers using BULK COPY and BULK INSERT utilities.
• Solution Environment: JAVA/J2EE, ORACLE SQL/PLSQL, SSIS/SSRS, SOA, SOAP, SPRING, XSLT and Hibernate

Tools: Apache Tomcat 5.0 Server, Eclipse IDE, Maven, Oracle, SVN Subversion , Application Monitoring

Confidential

Roles and Responsibilities:

• Coded HTML screens, JSP , Struts and JavaScript Validations
• Involved in design and development of interfaces using JAVA technologies JSP and JavaScript. Designed different interfaces for different type of users - Technicians and managers.
• Used Struts to develop the framework. Form beans and Action classes are used extensively.

Solution Environment: JAVA, JavaScript, Struts, JDK 1.3, J2EE, JSP, Servlets, Swing.