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.
• Strong knowledge in ASP.NET 3.5, C#, VB.NET, Telerik Product, VB 6.0, VBA and SQL
• Highly experienced in MS SQL Server 2008 R with Business Intelligence in SQL Server Reporting Services, SQL Server Analysis Services and SQL Server Integration Services.
• Expert in creating traditional as well as Web - based interactive reports using SSRS
• Hands on experience in SQL Server and SSIS (Integration Services) package design, constructing, and deployment.
• Strong Reporting knowledge in Crystal Reports, Telerik Reports, Active Reports, SSIS and SSRS
• Expert in designing, maintaining & tuning various RDBMS such as SQL Server 2012/2008/2005.
• Experience in developing Custom Reports and different types of Tabular, Matrix and distributed reports in multiple formats using SQL Server Reporting Services (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.
• Hands on experience in SQL Server and SSIS (Integration Services) package design, constructing, and deployment..
• Experience in developing Custom Reports and different types of Tabular, Matrix and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).

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

Databases: SQL Server 2012/2008/2005/2000 , Oracle 9i, DB2

Eagle Products: Eagle PACE

Eagle Tools: Eagle PACE Advanced Reporting with Active Reports, Pace OLAP Reporting

PROFESSIONAL EXPERIENCE

Confidential, Dover, NH

.Net Support Consultant

Responsibilities:

• Requirement Analysis (E.g.: Analysis, Requirement Clarifications, and Walkthrough Meetings etc.)
• Played team lead Role for RPC application deliverable and Support
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc using T-SQL to provide structure to store data and to maintain database efficiently
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.
• 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
• Successfully implemented data masking to hide important data during ETL process.
• 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: MS SQL Server, SSRS & SSIS Integration Services 2008/2005, Oracle 11g/10g/9i, Crystal Reports, ASP.NET 4.0, C#, SQL server 2008, VBA (Access & Excel)

Confidential

Software Developer

Responsibilities:

• Responsible for Active Reports development
• Developed and deployed SSIS packages.
• Involved in extracting the data from OLTP to OLAP using SSIS.
• Involved in installation and configuration of SQL Server 2008.
• Created stylish Report Layouts and Deployed the Reports using SSRS 2005/2008.
• Got training on Advanced Report, Active reports and OLAP
• Configured and maintained Report Manager and Report Server for SSRS.
• Developed and delivered the following Eagle PACE Advanced reports using Active Dynamic Reports on time as per Business requirements and standards (Coding/Formatting)
• Utilize established development tools, guidelines and conventions including but not limited to ASP.NET, SQL Server, HTML, CSS, JavaScript, and C#.
• Performance Analysis Report and 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: MS SQL server 2008, PL/SQL,SQL Profiler Oracle, Advanced Report, SSIS 2005/2008,SSRS, ASP.NET 3.5, C#, Active Report 6.0

Confidential

SQL BI/ .Net Developer

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.
• Extensively used Joins and Sub-queries for complex queries involving multiple tables.
• Improved the performance of database queries and applications by creating well designed Indexes.
• Using SQL Server Reporting Services 2008 R2 to generate complex configuration setup and variance analysis reports.
• Tested and managed the SSIS packages.
• Defined, created and executed SQL Queries, Stored Procedures, User Defined Functions, Triggers and Constraints using MS SQL 2005.
• Configured and maintained Report Manager and Report Server for SSRS.
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2005/2008.
• Developed T-SQL Queries, Stored Procedures, User Defined Functions, Triggers, Constraints, Indexes and Views.
• 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.
• Created indexes, Constraints and rules on database objects.

Environment: MS SQL Server 2008, SSRS, SSIS,T-SQL, Windows 2003, ASP.NET, C#.NET, ADO.NET, .NET Framework 3.5, Telerik Product, MS Access Services 2010, VBA, SharePoint 2010 and Visual Studio 2010

Confidential

SQL BI / .Net Developer

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.
• Created Stored Procedure, User-defined Functions to take care of back end validations when transferring data to Production Server
• 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.
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files).
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML and CSV using SQL Server 2005 Reporting Services (SSRS) and Crystal reports.
• Ensured top quality deliverables.

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

Confidential

Software Developer

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.
• Built SQL Server Integration Services (SSIS) Packages for data transfer from heterogeneous data sources using T-SQL Stored Procedures.
• 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.
• Created and monitored SQL Server automated jobs to transfer data between various data sources.
• Created sophisticated SQL Server database to responsively handle complex queries (T-SQL, DTS, triggers, stored procedures, functions, and optimization).
• 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: MS SQL Server 2005, SSIS, SSRS, T-SQL ASP.NET, ADO.NET, C#, .NET Framework 2.0.