POFESSIONAL SUMMARY:

• An individual committed to deliver high value to the organization.
• Around 7 years of extensive IT Professional experience with expertise in Database Development, Modeling, Data Warehousing, Design and Technical management.
• Experience in developing the applications using T-SQL Programming DDL, DML, and DCL .
• Conversant with various phases of Software Development life cycle SDLC including development, designing, analysis, coding, testing and implementation.
• Extensive experience in MS SQL Server 2012/2008R2/2008/2005/2000, BI tools like SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , and SQL Server Analysis Services SSAS .
• Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS SharePoint , Business Scorecard Manager, Dashboards, Performance Point Server.
• Expertise in creating Dashboards, Metrics, Rules and Goals, corporate/personal dashboards, Alerts.
• Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.
• Experience in maintaining Error Logging using Exceptional Handling in T-SQL and MS SQL Server Integration Services SSIS .
• Highly Proficient in developing SSIS Packages to Extract, Transform and Load ETL /DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, DB2, MS Excel, MS Access, CSV, Oracle, flat file.
• Proficient in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services SSIS .
• Strong experience in designing and developing large number of enterprise reports SSRS/Business Objects using the data from ETL loads, SSAS Cubes and various data sources.
• Expertise in creating cubes with dimensions and facts tables in MOLAP Warehouse using SQL Server Analysis Services SSAS .
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports and deploying SSRS reports on the portal for user accessibility.
• Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
• Strong experience in logical and physical database design and development using Erwin and MS Visio.
• Worked in collaborative team environment with other developers, business analysts, and a project management team.
• Hands on experience in debugging an application using debugging tools provided by the Visual Studio.Net IDE.
• Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET and LINQ Language Integrated Query to access and update database
• Experience in using Data Modeling Tools like Erwin, MS access and Microsoft Visio

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 SQL Server 2012/2008 R2/2008/2005/2000, Oracle 9i/8.x, DB2 MS Access 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 SSIS SQL Developer

Responsibilities:

• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into SQL Server Database
• Applied data conversion transformation in an input column which has an unsupported data type in SQL server to a data type in the output column which is supported by SQL server SSIS .
• Utilized a combination of stored procedures and Integration Services to enable required data extract, transform and load procedures and packages ETL .
• Experience in Microsoft Visual C in script component of SSIS.
• Transformed data from one server to other servers using tools like Bulk Copy Program BCP , and SQL Server Integration Services SSIS 2008/2012 .
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Worked in Objects creation such as Tables and Views, complex Stored Procedures, User-Defined Functions, Indexes and appropriate Triggers to facilitate efficient data manipulation and consistency
• Closely works with Business to help them in analyzing the data and providing an expertise in designing the requests to make the system more efficient.
• Worked on Production Support, receiving production calls, troubleshooting the application and resolving bugs
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Created reports using the report builder and trained users to generate their own reports.
• Worked with Tabular reports, Matrix reports, Gauges Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment
• Enforced the referential Integrity constraints as well as Created Clustered as well as Non-clustered Indexes in order to improve the performance
• Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins
• Maintained referential integrity and implemented complex business logic.
• Generated Reports to the end users by using T-SQL queries.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Created calculated measures in a cube by using MDX scripting.
• Performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes.

Environment: SQL Server 2012/2008 R2/2008 Enterprise Edition, SQL Server Business Intelligence Development Studio SSIS, SSRS, SSAS , T-SQL, .Net framework, Microsoft Visual Stuidio.NET 2008, C .NET, VB.NET, Windows Server 2008

Confidential SSRS Developer/ SQL BI Developer

Responsibilities:

• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements
• Wrote complex expressions and calculations for SSRS reports with Conditional Formatting.
• Created various complex reports and manage those using SQL Server Reporting Services.
• Developed complex Stored Procedures and Views to be used to supply the data to the reports. Complex formulas were used to show derived fields and to format the data based on specific conditions
• Modified current database by adding tables, altering referential integrity and relationships to support the control system
• Optimized SQL queries for efficiency and assisted the front-end developers with their queries and procedures.
• Created views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected
• Created indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures.
• Performed performance tuning by analyzing indexes, queries, table sizes, etc and heavy utilization of SQL Profiler and query execution plan tools.
• Used Triggers to generate customized error messages.
• Error handling application using SQL server profiler to trace information submitted to the server.
• Responsible for Query optimization and Performance tuning, SQL queries using Show Plans and Execution Plans.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
• Involved in daily loads Full Incremental into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services SSIS 2008.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Deploying database objects from development/testing environment to production environment.
• Assisted team with data validation, statistical analysis, data migration and complex reports.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers

Environment: SQL Server 2005/2008 Enterprise Edition, SQL Server Business Intelligence Development Studio SSAS, SSIS, SSRS , T-SQL, SQL Profiler, .Net framework, MS Visual Source Safe ,Windows Server 2008

Confidential SQL / Dotnet 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.
• 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 2000/2005/2008 Enterprise Edition, SQL Server Business Intelligence studio SSIS, SSRS,SSAS , Query Analyzer, Microsoft Visual Stuidio.NET 2005, ASP.NET, ADO.NET, VB.NET ,HTML,IIS , Visual Source Safe, MS Project, MS Office 2003 Windows Server 2008.

Confidential

SSRS/ SQL Developer

Responsibilities:

• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Dealt with huge amount of data and used SSAS in order to retrieve the data
• Designed and created Report templates, Bar graphs and Pie charts based on the financial data.
• Enhancing the layouts available for the reports in the 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 .
• 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.
• Doing release builds and fixing issues related to reports in staging environment of BeneSmart application.
• Created data driven subscriptions for different users using Report Manager.
• 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 with Dynamic HTML, XML, CSS, for building a dynamic flexible and highly interactive Real-Time User Interface.

Environment: SQL Server 2008 Enterprise Edition, MS SQL 2008 r2, SQL Server BI Suite SSRS, SSIS and SSAS , Microsoft Visual Stuidio.NET 2010, Microsoft Visio 2003, ASP.NET 3.5, ADO.NET, C .NET, MS EXCEL 2007.

Confidential

SQL Server BI Developer

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.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.
• 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 and performing data migration
• 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.
• 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

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 reference 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: MS SQL Server Development, Windows 2000 server, SQL server 2000, MS Office 98, VB.Net, C .Net.