We provide IT Staff Augmentation Services!

Sql Developer Resume Profile

Experience Summary

  • 8 years of experience in IT industry in Banking Financial Services Domain with comprehensive exposure to the Software Development Life Cycle in the area of Dot Net technology and also having sound knowledge in Investment Banking and Mutual Fund Business Processes.
  • Trained in Eagle suite of products like Eagle PACE/STAR and Eagle utility tools like Message Center, Panels, Uploader and Exporters.
  • Specialization
  • Strong knowledge in ASP.NET 3.5, C , VB.NET, Telerik Product, VB 6.0, VBA and SQL
  • Strong Reporting knowledge in Crystal Reports, Telerik Reports, Active Reports, SSIS and SSRS
  • Application Development/Maintenance and Production Support Activities
  • Eagle PACE - Advanced Reports, Active Reports, OLAP Reports
  • Analyzing the requirements and preparing Functional and Technical Specifications
  • Functional and Unit test cases preparation, Executing the test cases and test logs
  • Code review, Error Tracking and Bug fixing
  • Performance tuning of DB procedures and functions
  • Providing Technical Assistance to the team
  • Development of Pace Advanced and OLAP reports, Message Center Streams Panels and Oracle PL/SQL.

Project Achievements

  • Data Importing Importing bulk data from Excel to Access has taken more than 25 minutes which caused delay in getting the report output. After implementing the code in C .NET and used the DLL in Access VBA code, time taken to import the data has been reduced to less than 30 seconds. Got appreciation from BNYM Client.
  • LOB Extraction Package During the migration process of all BNYM PCs to Windows 7, collecting the software for each individual PCs and Person, checking Windows 7 compatibility and preparing the manual reports has taken one person's effort for one week. After implementing LOB Extraction Package Scheduled Automated Stored Procedure in SQL which is scheduled and provides the output in 1 hour and 30 minutes on a daily basis without any manual interventions. Hence, this package saved the time and also the end user can view/download the day-to-day data from the UI.

Technical Skills:

  • RDBMS :SQL Server, MS Access
  • Languages :ASP.NET 4.0, C , VB.NET, Visual Basic 6.0, VBA Access, Excel
  • Operating Systems :Windows family
  • Other Utilities :Crystal Reports, Telerik Product, Active Reports, Java Script, AJAX, SQL-Tools, Microsoft VSS, Harvest, MS Office, Hands on Silver Light and WCF
  • Eagle Products :Eagle PACE
  • Eagle Tools :Eagle PACE Advanced Reporting with Active Reports, Pace OLAP Reporting
  • Trained in Eagle Star Message Center Streams- Txt, CSV, SWIFT, Star,Bloomberg, Tag value data formats , Panels, Uploaders, Exporters

Professional Experience

Confidential

Role Technical Team Lead

  • Project Abstract RPC: Request for policy changes is a Web application used to change any of the policy information such as premium, effective date, expiration date etc. RPC is C .net based tool communicate with SQL. All the business logic for RPC resides in the stored procedure.
  • This tool is used to change the existing policies or either can do cancellation as well, but can't able to create new policies. This tool is used by underwriters to the above mentioned parameters. Underwriters will get inputs through the following email, mail and telephone.
  • All the policies will be fetching from CCO customer contract organization on daily basis through nightly Informatics jobs and after processed in the RPC will flow back to CCO. CCO is a central repository for all systems. This is part of commercial Insurance.

Responsibilities:

  • Requirement Analysis E.g.: Analysis, Requirement Clarifications, and Walkthrough Meetings etc.
  • Played team lead Role for RPC application deliverable and Support
  • Handled the Migration of Sybase database to MSSQL Sever 2012
  • Involved in Documentation of Existing jobs such as Business Report, Test ID Creation and Net change job
  • Figured out the existing issues and outcome of new issues from migration of Front End Application and fixed it
  • Production support activities include Daily job running, tracking the issues, root cause etc
  • Development on automating the LMLS jobs running tracker tool
  • Played an integral part in solving challenging issues for the team and had come with suggestions and improvements with respect to code quality.

Environment: ASP.NET 4.0, C , SQL server 2008, VBA Access Excel , SSIS SSRS

Confidential

Role Advanced Report Development

Project Abstract Eagle CoE is responsible for creation of advanced reports using Active Report Technology

Responsibilities:

  • Responsible for Active Reports development
  • Got training on Advanced Report, Active reports and OLAP
  • Developed and delivered the following Eagle PACE Advanced reports using Active Dynamic Reports on time as per Business requirements and standards Coding/Formatting
  • Performance Analysis Report
  • Daily Performance Report
  • Top/Bottom Contributions to Return Report
  • Top/Bottom Active Weights Report
  • Multi-Client Cumulative Performance Comparison Reports
  • Unit testing of Reports
  • Implementation of UAT comments
  • Developed report with Dynamic Chart control

Environment: ASP.NET 3.5, C , SQL server 2008, Oracle, Advanced Report, Active Report 6.0

Confidential

Role Technical Team Lead

Project Abstract

  • Desktop Product Refresh DPR program is to update the end-users desktop or laptop from Windows XP to Windows 7 operating system and Office 2010 desktop which is created using Access Services 2010.
  • Desktop Products Management DPM provides an environment that allows end users to intelligently search for existing software within an application knowledge base that includes description of business functionality, data sources, technical requirements, certification status, cost per license, availability of existing licenses, cost for software maintenance, application business owner, application support manager, application development manager, vendor contact details, links to application documentation, and so on.

Responsibilities

  • Create functional requirement document as well as business requirement document after understanding the client requirement.
  • Prepare detailed design document applying N tier .NET architectural framework where data access layer is build using .NET enterprise library, presentation layer using AJAX for better usability and service layer is built with the help of latest Windows Communication Foundation technology.
  • Prepare estimations using use case point estimation technique.
  • Create and Write the code for Web pages/reports using Telerik controls
  • Create pseudo code of complex tasks such as estimated expense report, upload data in GL upload application, monthly scheduler using SQL Server, create and copy configuration, account summary and fund information.
  • Using SQL Server Reporting Services 2008 R2 to generate complex configuration setup and variance analysis reports.
  • Unit test cases and system test cases reviews.
  • Doing automated code review using FxCop tool to improve code quality without much manual intervention and for implementing automated nightly build using Harvest source control tool which is a best way to maintain code integrity between onshore and offshore developers.
  • Technically mentoring other team members for applying architectural framework, using AJAX technology, using Gang Of Four design patterns, doing peer code reviews to check the code quality as well as code-commenting standards.

Environment: ASP.NET, C .NET, ADO.NET, .NET Framework 3.5, SSRS 2008, Telerik Product, MS Access Services 2010, VBA, SharePoint 2010 and Visual Studio 2010

Confidential

Role Technical Team Lead

Project Abstract

The IAS portal helps to track and maintain different business users and their accounting portfolios using applications like PACER and RECON. This project involves creating reports to various clients as desired. The FA project deals with various clients and has a mainframe. The Fund accounting department also has Corporate Action Processing

  • Reconciliation
  • Reporting
  • NAV Calculations
  • Unit Price Calculations
  • Trade Processing
  • Preparation of Accounts
  • Tax Computations
  • Performance Measurement
  • Compliance Monitoring

Responsibilities

  • Involved in Business requirements analysis and in preparing the detailed design documents based on it and also responsible for system analysis, writing technical specification, design, construction and testing of various modules present in the application.
  • Played multitude roles by involving in design, development and testing. Took ownership for the project and led the team in achieving the technical requirements.
  • Developed web pages in .Net 3.5 and also worked with the web parts, customization of web parts, customizing workflow and lists.
  • Ensured top quality deliverables.

Environment : ASP.NET, C .NET, ADO.NET, .NET Framework 2.0/3.5, SSRS 2005, Macros VBA Access and Excel , VB 6.0, Crystal Reports and SQL Server 2005/2008

Confidential

Role Team Lead

Project Abstract

The Confidential is an enhanced version of knowledge repository which is being used by all Cognizant employees, allocated to Mellon as well as the relevant stakeholders of Mellon Corporation. After the merger of Bank of New York and Mellon Corporation, this application will be used by the relevant stakeholders of Bank of New York Mellon Corporation. This portal helps to track and maintain different work orders for different LOBs, resources associated with the work orders, management tasks like allocation, de-allocation of resources, visa tracking, steering committee reports etc. This application also hosts a number of study materials which can help the portal users to enhance their knowledge in both technical, solution as well as domain areas. The requirement is to re-architect the whole product to make the design robust enough to cater the needs of internal and external user of the portal with easy navigation and tighten its security.

Responsibilities

  • Create functional requirement document as well as business requirement document after understanding the client requirement.
  • Prepare High Level design document and Low level Design Document applying N tier .NET architectural framework where data access layer was build using .NET data access application block, presentation layer using JQuery and Ajax for better usability and service layer was built with the help of latest Windows Communication Foundation technology.
  • Technically mentoring other team members for applying architectural framework, doing peer code reviews to check the code quality as well as code-commenting standards.
  • Develop web pages in ASP .NET, C and create stored procedures/Functions/Mail trigger in SQL Server 2005.
  • Involved in major/minor enhancements in the application.
  • Took ownership for the application and ensured top quality deliverables.
  • Headed the task of putting build for moving the changes from test to production region.

Environment: ASP.NET, ADO.NET, C , .NET Framework 2.0 and SQL Server 2005

Hire Now