SUMMARY

• About 8 years of experience in Design, Development and Implementation on SQL Server 2012/2008,SSIS, SSRS, ETL, ASP.NET, C#, VB.NET, ADO.NET, CSS, JavaScript.
• Experience in all stages of Software Development Life Cycle (SDLC) including Requirements, Analysis and Design, Implementation, Invb.tegration, Testing, Deployment and Post Development Maintenance in Waterfall & Agile Methodologies.
• Good experience in RSAM GRC Tool management and issue logs.
• Good experience in Business Intelligence Development Studio (BIDS).
• Expert in High Level Design of ETL/ SSIS Package for integrating data from heterogeneous sources (Excel, CSV, flat file, Text Format Data) using SSIS Packages.
• Excellent working experience in design and development of several reports using Crystal Reports and MS SQL Server Reporting Services 2008 (SSRS) from OLTP and OLAP data sources.
• Working in Erwin tool for data modeling.
• Strong Database Objects development - Tables, Views, Triggers, Stored procedures, Cursors using SQL Server 2008/2005.
• Excellent noledge in Enterprise Manager, T-SQL, SQL Profiler, Query Analyzer and Execution plan.
• Created functions and triggers to ensure the database consistency and maintained using DBCC check, and Rank functions, CTES and derived table.
• Database/Data migration from Database to Database and SQL batches.
• Experience in Oracle to SQL Server Migration using SSIS tool.
• Designed reports with Drill Down, Drill Through and Drop down menu option and Parameterized Reports.
• Knowledge in service oriented architecture creating and consuming XML Web Services over SOAP in .NET using C# or VB.NET
• Involved in object-oriented analysis, design and coding in a .NET server-side environment, specifically utilizing the Microsoft MVC framework.
• Experience in building application from TFS and deploying projects in different environments.
• Interaction with technical leaders and business analysts (BA) to discuss and understand the functional and requirement specification.
• Ability to participate as an active role for technical teams in a results-oriented environment, TEMPeffective at translating business requirements into on-time deliverables.
• Very strong analytical and problem solving techniques, presentation skills & deliverance and proven team player qualities.
• Expertise in Requirement analysis, Database design, Data modeling and complete software lifecycle.
• Having Working Experience in Banking / Retail / ERP / Healthcare Domains.

TECHNICAL SKILLS

Database: SQL Server 2012/2008, MS Access, Oracle, SSIS, SSRS, SQL Server Profiler,T-SQL,Erwin

MS Technologies: .NET (VB.NET, C#,ASP.NET, ADO.NET,MVC),ASP,MS-Office,PowerPivot

Web Servers: IIS 7.0, IIS 6.0.

Operating systems: Windows XP, Windows 7, 2008 Server, Windows 8.1

Development tools: Microsoft Visual Studio 2010/2008,VSS, TFS 2010, Business Intelligence Development Studio (BIDS),ETL,DTS

Scripts: HTML, XML, JavaScript, VB Script, CSS

PROFESSIONAL EXPERIENCE

Confidential, MO

RSAM GRC/SSIS/SSRS Consultant

Responsibilities:

• Worked in creating Privacy and Service Reliability Use cases Attribute, Event Handlers, Trigger event in different data types.
• Worked in creating Criteria, Action for each and every handlers, buttons.
• Imported different department data into RSAM application through data mapping. Creating scheduler for daily,weekly,monthly wise data import.
• Finding issues and solved through the Log files.
• Assigned the User's Permission to access different type of department to view,modify,delete and admin rights.
• Created SSIS Packages using SSIS Designer to export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2012.
• Extensive experience deliveringOLAPsolutions by developing Corporate Dashboard Reports usingSQL Server Reporting Services (SSRS).
• Analyzed the bottlenecks in the stored procedures, SQL queries and tuned them for improving the performance of the application, creating new stored procedures & SQL scripts as part of the enhancements.

Environment: SQL Server 2012, SSIS, SSRS,T-SQL,ETL,RSAM GRC Tool.

Confidential, GA

SQL server SSRS/SSIS consultant

Responsibilities:

• Involved in design, development, enhancement, implementation, testing, maintenance, version upgrade and performance tuning of the application.
• Implemented the architecture to separate a Report server from Production Batch server and created replication model to pull the data from Batch server to Report server using SSIS.
• ASP.NET development including MVC.
• Implemented handshake mechanism between CSS Batch server and Lotus notes to keep employee data up to date using SSIS.
• Extracted data from Alcatel tele management system to Report server using SSIS for KPI reporting.
• Design and development of Change management reports using SSRS 2008.
• Develop Incident Summary dashboard reports for Board meetings.
• Migrating SQL server 2008 to SQL server 2012.
• Building the Incident summary reports by school level and Tech. support associate level.
• Created Drill through reports, Drilldown reports and sub reports. Having excellent experience in utilizing filters and multi grouping inside tablix.
• Experience in single & multi parameterized reports and created interactive sorting reports.
• Handled multiple data sources and data sets in a single report.
• Developed matrix reports for School Year to date performance metrics report.
• Developed the Report Dashboard,PowerPivot for School TEMPPrincipals to monitor their school Incidents.
• Created various Chart reports to show the Daily/weekly/monthly Incident Opened/Closed by Incident type, Urgency, School, Tech. Associate.
• Setup the E-mail report delivery system for Directors, managers. Also setup the data-driven report delivery for Individual school report for TEMPPrincipals. dis TEMPhas been done by storing user credentials in a database table.
• Administering reporting services from end to end. dis includes report publishing, setting up report execution (On demand, Snapshot & Cached instance) and managing report subscriptions.
• Experience in Ad-Hoc reporting: Setting up report models, creating reports using Report Builder 2008.
• Data migration (Import & Export using BCP) from text to SQL Server2008

Environment: MS SQL Server 2008 and 2012, SSIS, SSRS2008, T-SQL, CrystalReport,PowerPivot,ETL,Erwin,TFS,.Net Framework, Asp.Net, JavaScript, CSS, HTML,MVC

Confidential, IL

SQL Developer / ETL Developer

Responsibilities:

• Involved in design, development, enhancement, implementation, testing, maintenance, version upgrade and performance tuning of the application
• Participated in meetings with Business Partners & Business Analyst to gather business and software requirements for application backend design and development.
• Analyzed the bottlenecks in the stored procedures, SQL queries and tuned them for improving the performance of the application, creating new stored procedures & SQL scripts as part of the enhancements.
• Migration of the data from text files to SQL Server database using BCP and SSIS packages for the processing of different policies.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Created Business Intelligence reports on a periodic basic for different facilities based on the business requirement
• Perform database consistency checks at regular intervals.
• Used Microsoft Visual Source Safe for version control.

Environment: Microsoft SQL Server 2008, SSIS 2008, SSRS, T-SQL, VB Script, VSS,ETL.

Confidential, IL

SQL Developer

Responsibilities:

• Worked in a team of Ten, Involved in development, enhancement, testing and performance tuning of the application
• Extensively used ADO.Net to interact with the SQL Server database.
• Participated in meetings with Business Partners & Business Analyst for development of the application.
• Developed stored procedures, functions and database triggers. Executed SSIS packages to populate data from the various data sources.
• Created SSIS Packages using SSIS Designer to export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2008.
• Experience working with Crystal Reports Mainly conversion to SSRS reports.
• Extensive experience deliveringOLAPsolutions by developing Corporate Dashboard Reports usingSQL Server Reporting Services (SSRS).
• Analyzed the bottlenecks in the stored procedures, SQL queries and tuned them for improving the performance of the application, creating new stored procedures & SQL scripts as part of the enhancements.
• Perform database consistency checks at regular intervals.

Environment: Microsoft SQL Server 2008, TSQL,SSIS,ETL & SSRS,Crystal Report,ADO.Net, .Net framework 2.0.

Confidential, GA

SQL Server Developer

Responsibilities:

• Involved in meeting with management for requirement gathering and analysis.
• Created the SSIS packages for extracting data from OLTP to OLAP.
• Created reports using SSRS i.e. Parameterization, Drill Down, Drill Through, Sub Reports, Charts, Table.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also sent email to analysts to review in Excel Sheet.
• Design database schema using SQL Server 2008.
• Creating and developing database object such as tables, indexing columns and setting constraints.
• Writing complex SQL queries using merge statement, multiple joins, sub queries and recursive queries.
• Creating multiple views for SSRS report.
• Writing SQL stored procedures, user define functions, triggers and cursors.
• Maintaining TIMS database system.

Environment: SQL Server 2008, T-SQL, CSV, Excel, TFS, SQL server report manager, SQL Server Management Studio. Asp.Net,JavaScript,CSS,HTML

Confidential

SQL Server Developer

Responsibilities:

• Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2005
• Design database schema using SQL Server 2005.
• Creating and developing database object such as tables, indexing columns and setting constraints.
• Wrote T-SQL procedures to generate DML scripts dat modified database objects dynamically based on user inputs.
• Creating multiple views for SSRS report.
• Writing SQL stored procedures, user define functions, triggers and cursors.
• Extensive noledge in performance tuning.
• Developing various reports based on the business requirement using SSRS tool and BIDS environment.
• Design, Deployment and Maintenance various types of reports using SQL Server 2008, SSRS and BIDS
• Understand and identify queries behavior by SQL Profiler and resolving it.
• Technical Analysis, Code Review, Implementation

Environment: SQL Server 2005 and 2008, Business Intelligence Development Studio (BIDS), SSRS, T-SQL, CSV, Excel,VSS.

Confidential 

Software Developer

Responsibilities:

• Analyzed the architectural design for online contract and payment information.
• Design database schema using SQL Server 2005.
• Design the Data Access Layer and Business Layer and coded for those layers using C#, Entity Object.
• Develop application using ASP.NET, C#, JavaScript and Ajax.
• Design the dashboard information using CSS, XHTML to make the screen look and feel better.
• Prepared functional and system design using Microsoft Visio.
• Involved in writing Ajax to perform the screen well with no post back.
• Invoked multi threading to compare multiple images at a time
• Responsible for creating prototype application

Environment: Net frame work 2.0, COM, ADO.NET, C#,VB.net,Ajax, Entity Object Visual Studio 2005, MS SQL Server 2005.