SUMMARY

• 8+ years of IT Experience in SQL Developer, Business Intelligence solution Design, Development with Microsoft SQL Server 2008/2005/2000 in Development, Test and Production Environments.
• Good experience in analysis, design and development of client/server, web based and n - tier application. Expert in developing windows applications, web applications, web services in Microsoft Visual Studio .Net IDE using C#.NET, VB.NET, ASP.NET, ADO.NET.
• Expert Knowledge of Reporting Services (SSRS), Integration Services (SSIS), Analysis Services.
• Proficiency in creating different types of reports such as Ad-hoc, Cross-Tab, Conditional, Drill-down, interactive, Cascading, Top N, Summary, Form, OLAP, Sub reports, Chart reports and Matrix reports with conditional formatting in SSRS.
• Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology, Enterprise Reporting Life Cycle, and SQL Server Migration.
• Experience in various Extracting, Transforming and Loading (ETL) tasks using SSIS including tools like DTS and SSIS ( ) Packages with proper control & data flow elements.
• Monitored the SQL server by using Profilers, Performance monitor and Database Tuning Advisor.
• Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET and LINQ (Language Integrated Query) to access and update database
• Expert in debugging an application using debugging tools provided by the Visual Studio.Net IDE.
• Experience in Creating User Controls, Custom Controls and Web Services.
• Experience in using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Experience in SQL Server development with good T-SQL skills with use of database objects, stored procedures, triggers, functions.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and of end users.

TECHNICAL SKILLS

Operating Systems: Windows Vista Business / XP Pro. / 2003 / NT / 9.X

Programming: C#. Net, VB.Net, ASP, C, C++, ADO.NET

Scripting Language: Java Script, VB Script

Databases: MS SQL SERVER / 2000, MS Access 2003, Oracle, DB2

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Enterprise Manager, Import and Export Data wizard, SQL Server Business Development studio (BIDS).

ETL Tools: SQL Server Integration services (SSIS) 2005 and 2008, Data Transformation Services (DTS)

Analytical Tools: SQL server Analysis Service (SSAS), Performance Point Server 2007.

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

Data Modeling Tools: Erwin, Visio, MS Access

Web server technology: IIS

Hardware: EMC DMX & IBM Fast T 700 Storage Area Network (SAN), Compaq Proliant 8000, 6500, 6000

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

SR. SQL BI Consultant (SSIS/SSRS/.Net)

Responsibilities:

• Implementation of business requirements in various reports of BeneSmart application.
• Developed optimized stored procedures, T-SQL queries, User Defined Functions (UDF), Cursors, Views and Triggers, SQL Joins and other statements for benesmart reporting Application, maintained referential integrity and implemented complex logic .
• Enhancing the layouts available for the reports in the BeneSmart application
• Gather requirements from business user and modify the stored procedures, codes to provide functionality as required.
• Troubleshooting and fixing Bugs/issues in the enterprise level web application using C#.NET, ADO.NET, ASP.NET.
• Perform including filters to the reports and make it parameter-driven
• Perform including SQL Agent jobs to update source of data by use of SSIS package.
• Utilized a combination of stored procedures and Integration Services to enable required data extract, transform and load procedures and packages (ETL).
• Deploying the reports to staging server prior to business user acceptance testing.
• Perform including security to the reports and data in the application
• Implement updates of reports in BeneSmart application to recognize same-day data updates/changes.
• Interacting with sr. leadership and executive management to understand their needs.
• Doing release builds and fixing issues related to reports in staging environment of BeneSmart application.
• Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET and LINQ (Language Integrated Query) to access and update database
• Expert in debugging an application using debugging tools provided by the Visual Studio.Net IDE.
• Sound Knowledge in ADO.NET to communicate with database for retrieving, accessing, and updating data.
• Proficient withDynamic HTML, XML, CSS, for building a dynamic flexible and highly interactive Real-Time User Interface.

Environment: SQL Server 2005/2008 Enterprise Edition, SQL Server BI Suite(SSRS, SSIS and SSAS), SQL Server 2008 Query Analyzer, Profiler, Microsoft Visual Stuidio.NET 2005/2010, ASP.NET, ADO.NET, C#.NET XML, MS Project, MS EXCEL 2007, MS Access 2003 & Windows Server 2008, MS SharePoint 2007.

Confidential, Freehold, NJ

SQL SERVER SSRS / asp.net DEVELOPER

Responsibilities:

• Plan, design, and implement application database code objects, such as stored procedures, views using SQL Server 2008 and Windows Server 2008.
• Develop new processes to facilitate validation and create reports to show the business data to the users in form of reports.
• Dealt with database of terabyte size with complex stored procedures and views having multiple embedded procedures and views.
• Hands on experience in writing T-SQL queries, Stored Procedures, User Defined Functions (UDF), Cursors, Views and Triggers.
• Extensively used transformation of data between servers by creating linked servers and transforming data into table from a text file using BCP/Bulk insert method.
• Error handling application using SQL server profiler to trace information submitted to the server.
• Extensive use of Query Analyzer for performance tuning
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Created package using various control flow and dataflow component for extracting data from the daily feed file and storing those information into table.
• Utilized a combination of stored procedures and Integration Services to enable required data extract, transform and load procedures and packages (ETL).
• Worked intensely on the User Interface and developed Web Forms using Vb.net and ASP.NET
• Created custom control and user control to reuse the control more than once in an application.
• Developed Web Services exposing web method providing functionality that being used in application.
• Extensively used Repeater, Data Grid, Grid Views with sorting and paging
• Implemented Template Columns for Custom Nested Grid Views.
• Created SQL agent jobs to schedule the package, stored procedure and various processes to be executed at regular time intervals.
• Developed Cascading Style Sheets (CSS) for User Interface uniformity throughout the application.
• Used HTML, JavaScript and AJAX for developing Controls and web forms
• Work with application developers and production teams and across functional units to identify business needs and discuss solution options.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management

Environment: SQL Server 2005/2008 Enterprise Edition, SQL Server 2008 Query Analyzer, Profiler, Microsoft Visual Stuidio.NET 2005, ASP.NET, ADO.NET, C#.NET XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2008.

Confidential

SQL SERVER BI (SSIS), SQL DEVELOPER

Responsibilities:

• Created package in SQL Server 2008 and Windows Server 2008 for extracting data located in multiple server having millions of data records and loading it to data mart
• Designed the package logic to extract information and organizes it in an efficient manner to manage large volumes of data and run queries very efficiently.
• Created complex SSIS package using various control flow like Sequence container, Transfer SQL Server object task, Execute SQL task, Script task and various data flow transformation like Cache Transform, Lookup transform, Derived column, Multicast and For Each loop Transformation.
• Implemented table partitioning for flexibility and better performance where used objects such as multiple stored procedure, functions to implement logic in the SSIS package.
• Created several package with condition of running of successive package after complete successful run of previous package
• Created variable for connection string to supply the server name, user name, password, and database at run time.
• Created Linked server to moved data between different servers.
• Implemented error handling in package using script task getting error rows, error Description, message dynamically and moving them to a centralized table as well as sending message to support DBA via email.
• Successfully enhanced and deployed the SSIS packages from the developmental server to the production server.
• Loading data from various sources like Excel, flat files to SQL Server database Using SSIS Packages as well as loading data into flat file destination from multiple sources.
• Created scripts using C#.net and Vb.net to implement logic at various places in the package.
• Created configuration file to store package property in XML format to ease deployment of package.

Environment: SQL Server 2005/2008 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, PPS, SharePoint, Crystal Reports, ASP.NET, ADO.NET, C#.NET

Confidential, Boston

SQL SERVER-SSRS/.net Developer

Responsibilities:

• Highly responsible for development and management of SSIS, SSAS and SSRS projects.
• Created Multiple Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Cascading reports, Drill down reports.
• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
• Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, FuzzyLook Up, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components.
• Created Reports that involve Dynamic Grouping and Sorting to provide information about the particular Sales regions.
• Worked with .net Developers for developing custom codes for reporting and excel services as well as for creating SQL Server Objects.
• Created joins and sub-queries for complex queries & store procedures involving multiple tables.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Implemented the project using ASP.Net, Visual C# as the front end and SQL Server 2005 as the back end Database.
• Developing the User-Interface Front-end screens in .Net 3.5 environment using C#.Net, Asp.Net JavaScript, HTML and DHTML
• Created and consumed Web Services using Visual C#, ASP.Net.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007,share point

Environment: SQL Server 2005/2008 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, VB.NET, ASP.NET, ADO.NET, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, PPS, SharePoint, Crystal Reports.

Confidential, Stamford,CT

SQL Server BIDeveloper

Responsibilities:

• Work with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Designed SSIS Packages to extract, transfer, load(ETL) existing data into SQL Server 2005
• Incorporating business logic in SSIS while converting from Oracle, MS Access and Text to SQL Server
• Performed Fuzzy Grouping transformation which performs data cleaning tasks by identifying the rows of data that are likely to be duplicates (SSIS).
• Worked with different methods of logging in SSIS.
• Experience of designing complex SSIS packages for transforming multiple logins, Jobs etc.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005.
• Hands on experience in using different transformations like conditional splitting, FuzzyLook Up, ForEach Loop, Multi Cast, column conversion, FuzzyGrouping, Script Components etc using SSIS 2005
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created Cubes with multiple dimensions, measures, hierarchy, complex MDX queries, and Key Performance indicators as well as slowly changing dimensions (SCD).
• Highly involved in OLAP data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
• Used Multi-dimensional expressions (MDX) to present the ad-hoc data, and to simultaneously query on different dimensions.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2005(SSAS)
• Created calculated measures in a cube by using MDX scripting and worked on slowly changing dimensions.
• Created various complex reports and manage them by using SQL Server Reporting Services.
• Hands on experience in rendering reports for online viewing, document management and for data exchange as Excel, CSV file and XML file.
• Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Translating business requirements into technical design specifications.

Environment: MS SQL Server 2000/2005, Windows 2003 Adv. Server, SSIS, SSRS, SSAS, T-SQL, Query Analyzer, MS Office 2003, C#.Net, PPS, Excel 2007, Oracle 10g.

Confidential, CT

SQL SERVER BI Developer

Responsibilities:

• Provided guidance and decision-making on client reporting needs oversee and participate in the development of the report technical designs as well as participate in the implementation of reports and testing activities
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in working on Cube structure optimization in order to increase the MDX query performance in Analysis Services 2005(SSAS)
• Understanding the OLAP processing for changing and maintaining multi dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes
• Created calculated measures in a cube by using MDX scripting and worked on slowly changing dimensions.
• Created drilldown reports, Parameterized reports, Ad-Hoc reports in SSRS from multiple data sources including SSAS cubes.
• Hands on experience in rendering reports for online viewing, document management and for data exchange as excel, CSV file and XML file.
• Assisted team with data validation, statistical analysis, data migration and complex reports.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
• Worked in coordination with Development Team in deploying and testing the application
• Closely worked with the DBA to fasten certain daily jobs and stored procedure.
• Responsible for Query optimization and Performance tuning, SQL queries using Show Plans and Execution Plans
• Generated and debugged complex stored procedures and functions for better performance and flexibility.
• Created technical designs and user documentation.
• Managed the day-to-day activities to ensure the completion of deliverables on time by providing a weekly status report on progress made.
• Worked with management to develop annual goals and plans.

Environment: SQL server 2005 EE, SSRS, SSAS, SSIS, Windows 2003, VB.Net, DB2, SAP R/3.

Confidential, Omaha, NE

SQL Server BI / DBA

Responsibilities:

• Assist the Development staff with the testing and implementation of the application.
• Normalized and De-normalized the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Provide consultation to application development teams regarding the capacity planning of the database.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Create and test DTS packages for importing and exporting data from data warehouse
• Schedules jobs for DTS packages
• Troubleshoot SQL Server performance issues for internal and external customers.
• Monitor and record database activities.
• Monitor and tuned indexes, stored procedures and Server Performance using Performance Monitoring tools for Microsoft SQL Server 2000.
• Developed SQL Server Maintenance Plans.
• Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring
• Create Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach, etc from event viewer, SQL Error log files.
• Used T-SQL to create queries and stored procedures to produce reports for end-users
• Perform security configuration and administration
• Resolve locking conflicts and resource utilization.
• Configured Transactional Replication between the Production server and Reporting server and to move the data to servers in various locations.
• Configure Log Shipping for disaster recovery solutions
• Create Linked Server to transfer data to legacy systems
• Configured mail profile for sending automatic mails to respective people when job is failed or succeed.
• Used Data Modeling Tools like Erwin, MS access and Microsoft Visio.

Environment: Windows 2003 Advanced Server, MS SQL Server 2000/2005, SSRS SSIS, SSAS, Visual Basic 6.0, Microsoft Office Excel 2003.

Confidential, Columbus, Ohio

SQL Server BI / DBA

Responsibilities:

• Actively involved with the front end .net developers as a part of a team for gathering and analyzing the needs of User Requirement.
• Modified existing database to fit new business requirement by adding tables and relationships to support Customer Information System.
• Created efficientStored Procedureand functions which implement necessary business logic to support the front end application.
• Created indexed view to optimize query performance by facilitating easy user interface implementation.
• Createdlinked serverfor load balancing and increasing the performance of the Database.
• Created instead of trigger onindexed viewto facilitate consistent data entry into the databaseUsed SQL reporting services.
• Optimized the query performance by removing unnecessary columns, redundant and inconsistent data. Query performance was improved by normalizing tables, establishing necessary joins and creating useful indexes wherever necessary.
• Worked on Client/Server tools such as SQL Server 2000 Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance plan for the performance of SQL Server, which includesDatabase Integrity Checks, Update Database Statistics and Re-index the fragmented indexes.
• Created DTS packages to migrate data from various sources to the SQL Server 2000.
• Created and maintained Users/Logins.
• Optimized database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Created Reports using SQL Server 2000 Reporting Services using Microsoft Visual Studio 2003.

Environment: MSSQL Server 2000(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS),2000 Reporting services ASP.Net, VB.Net, VB Script.

Confidential

Software Engineer

Responsibilities:

• Analyze customer master data and generates special reports according to need of marketing team.
• Communicate and assist Investment Advisors and Relationship Managers for requirements.
• Developed creative reports for Annual Sales Analysis, Employee Distribution, Revenue - Expenditure, Customer Analysis using SQL Server 2000 Reporting Services.
• Wrote complex T-SQL queries and store procedures.
• Created new tables, views, indexes and user defined functions.
• Closely worked with the Sr. DBA and Sr. Developers to fasten certain daily jobs and stored procedures.
• Involved in performance tuning of T-SQL queries and worked with nested Stored Procedures.
• Create joins and sub-queries for complex queries involving multiple tables and fields.
• Developed complex stored procedures to create Portfolio Management Services (PMS Module).
• Documentation of all developments and approvals in repository of SBI Ltd.
• Involved in the team, with Sr. DBA for Database Administration Jobs like Security & User Admin, Job Scheduling & Notification, Database backups & Restoring, Index Management etc.
• Involved in security & access management for SQL server 2000.
• Provided technical help on database issues to front end users all over India by phone or email to assure smooth business flow.

Environment: Windows 2000 server, SQL server 2000, MS Office 98, VB 6.0