PROFESSIONAL SUMMARY:

• Over 7 years of IT experience in all the aspects of Software Development Life Cycle SDLC whichincludesAnalysis, Design, Development, Testing of applications using Data Warehousing concepts and Business Intelligence tools.
• Working experience with MS SQL Server 2012/2008/2005/2000/7.0 and Visual Studio 2010/2008/2005/2003 usedto generate reports, design models, integration, developing custom utilities and applications using .NET.
• Extensive experience developing and implementing solutions using Microsoft SQL Server integration services SSIS , Reporting Services SSRS andAnalysis Services SSAS for data warehousing and data marts.
• Created packages using SQLServerIntegration Services SSIS for data Extraction from/Load to Flat Files, Excel File MSAccess, DB2, Oracle etc.
• Creating and monitoring the batch jobs using SQL Server Agent.
• Installed Configured and Maintained SQL Server Integration Services SSIS . Created SSIS/DTS packages and deployed them to SQL Server and File system. Maintained the configurations passing the variable values though XML file, database table and sometimes through Environment variables to run the packages manually upon failure.
• Also configured and deployed the new Projectbaseddeployment introduced in 2012 SQL Server Data Tools SSDT . Deployed the Projects to IntegrationServicesCatalog and managed the security. The Configurations are set from Project and Package parameters through the Environment.
• Installed Configured and maintained SQL Server Reporting Services SSRS reports and deployed to the ReportManager and the Sharepoint. Also maintained the security and performance of these reports.
• Created cascade parameterized, adhoc, drillthrough, drilldown, Graph, Chart, KPIs, linked, snapshot, subreports, canned reports etc. using SSRS.
• Integrated SSRS and Crystal Reports with .net application automatically passing the report parameters from the application and defaulting to the desired output to a certain format if required.
• Created SQLServerAnalysisServices SSAS cubes and migrated some of the existing cubes. Also created SSRS reports out of these cubes writing MDX queries to pull the data.
• Created multiple cubes in a database solution with multiplefacts in a single cube with shareddimensions.
• Created hierarchies, partitions and perspectives as and when required based on the complexity of the cube.
• Processed and maintained the cubes on a schedule directly in SQL Agent using XMLA or through SSIS process task.
• Experience with design of datawarehouse and datamarts using Inman and Kimball methodologies based on the organization.
• Experience with design and implementation of StarSchema and SnowflakeSchemaDimensionalmodel.
• Experience in RDBMS database and tables design Normalization, DeNormalization, Unique,primary, foreignkeys andClustered, NonclusteredIndexes.
• Extensive experience with T-SQL in writing and debugging complex storedprocedures, triggers, tableviews and user-definedfunctions.
• Working experience with ASP .NET and C and its integration with Webfocus Reporting and SQL Server Reporting Services.
• Connecting to database using ADO.NET and data retrieval using Dataset and Datareader. Also using LINQ and AJAX in the new frameworks.
• Experience in web applications with .NET framework 2.0/3.0/3.5/4.0 using ASP.NET,C , ADO.NET, SOAP, WebServices, XML and XSL.
• Development of Interoperable WebServices, Winforms, Console Applications using C and VB. Net.
• Well versed with IIS, registry, assemblyconfiguration. Used Powershell script to register .net assembly in GAC.
• Also has experience in MS SQL Server configuration, performancetuning using Sql profiler and tuning advisor client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Delivered 24/7 support including scheduled and emergency night and weekend work.
• Effective Team Player with excellent Analytical, Programming, Written and Verbal Communication skills.

Technical Skills:

PROFESSIONAL EXPERIENCE:

Confidential

BI Developer

Description:

• Interface with users, project manager to ensure that implemented solutions satisfy business requirements and are delivered in a timely manner.
• Understand the functional requirement specifications and preparing designdocumentation.
• Installed, configured and maintained SQL Server Integration Services SSIS .
• Deployed packages to SQL Server and filesystem in 2008 and also used the new ProjectbasedDeployment introduced in 2012 SQL Server Data Tools SSDT to deploy the 2012 packages.
• Configured and deployedthe SSIS2012projects to the new IntegrationServicesCatalog. Set the Environment and managed configurations using the Package and Projectvariables.
• Maintained the SSIS projects and users accessing the Catalog and SSISDB.
• Scheduled and monitored the SQLAgentjobs to run these packages periodically.
• Created SSISpackages toExtract, Transformation and Load ETL inventoryandothersalesdata from Flat Files, Excel Files, Access, Mainframe DB2, Oracle etc.
• Created new SSISpackages for the existing legacy Data Transformation Services DTS packages in the due course of data migration from SQL Server 2000 to 2005.
• Scheduled and monitored the execution of the jobs using a third party tool Global Event Control Server GECS and SQL Server Agent.
• Used packagevariables and configurationfiles to run the packages manually mapping through environmentvariables in case of job failure.
• Implemented SQL Server SSIS packages for ETL methodologies involved in the migration from SQL Server 2000 to 2005and2008 and created new SSIS packages for the legacy DTS packages and scheduled and monitored the execution of the jobs.
• Used SQLServer Reporting Services SSRS to create reports, customized Reports, on-demand reports, Charts, KPIs, DrilldownDrillthrough and other Canned reports and multi-dimensional reports from the cubes and Deployed to Sharepoint and ReportManager.
• Excel at developing and implementing reporting and data solutions, including custom user interfaces.
• Migrated,recreated and maintained the Legacy packages, cubes and reports.
• Migrated some of the SSRS reports from 2005 to 2008 and from 2008 to 2012 environment.
• Supported Style Sheets that contain drill down parameters and links to arbitrary URLs and embeddedGIFimages in report headings and footings.
• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Involved in building and maintaining dimensional cubes with SQL Server Analysis Services SSAS and usedMDXscript for querying the data.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union allScheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• DevelopedBusinessviews, Reportobjects, Cubes for the users to analyze the data and help them in decision making.
• Deployed SSRS reports to ReportManager and made a call to those reports through a URL from .Net API .aspx .
• Developed reports using SSRS and exported directly to EXCEL, CSV and PDF formats bypassing the report manager screen running the reports from ASP.NET application.
• Designed interactive web pages in ASP.NET and user controls using C . The pages are developed using dynamic controls with java scripting.
• Experience developing web applications using ASP.NET,C , ADO.NET using both C and VB .
• Also developer Web applications on the client side using HTML, AJAX, JQuery and LINQ to SQL which is much faster to render since it runs on the client side.
• Performing Unittesting and internal QA for the developed application.
• Created and maintained the SSRS reports, design documents and other scrum status trackers available on SharePoint for the business users and the steering team.
• Used Compucom ticketing system for the change management and tracking the issues and enhancements.
• Working closely with the users supporting the existing reports and creating new reports.
• Prepared of project documentation.

Environment: MS SQL Server 2012/2008R2/2005, SSIS, SSRS, SSAS, DB2, MS Access, SQL Plus, ASP.NET, C .NET, ADO.NET, Windows XP, .NET Framework 3.5/3.0,Visual Studio 2010/2008/2005, HTML, JavaScript, AJAX, LINQ.

Confidential

BI Developer

Responsibilities:

• Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model.
• Design/Build Extract Transform Load procedures in SQL Server 2005 to import/export data feeds to/from data warehouse and claim systems.
• Worked on Stored Procedures andDatabase Triggers.
• Involved in designing, developing and testing of the ETL Extract, Transformation and Load strategy to populate the insurance data from various source systems feeds using SSIS.
• Worked Extensively with SSIS to import, export and transform the data between the linked servers.
• Developed custom selection of reports ordering using SQL Server Reporting Services SSRS .
• Involved with various business groups while developing their applications, assisting in database design. Worked on SQL query tuning, execution plan to enhance query performance.
• Design and implementation of Performance Tuning and Maintenance plan for database consistency checks, backup/restore. Designed DTS package to export data from/to access data source to SQL Server.
• PerformanceTuning the Stored Procedures used in SSIS Packages and SSRSReports.
• Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Created SQL Agent Jobs and scheduled the SSIS Package to run overnight. Resolved the issues associated with the job failure.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008.
• Prepare documentation related to database design, objects security and rules.
• Involved in Performance Tuning of SSIS Packages,reports, Views, Stored proceduresusing SQL Profiler and Tuning Advisor improving performance and scalability.
• Defined production support document with recovery process.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Hands on experience in designing SSIS Packages for integrating data using OLE DB connection from heterogeneous sources Excel, CSV, Oracle, flat file by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insertetc.
• Used various control flow tasks like FTP, Bulk insert task, Transfer job task etc and different data flow tasks.
• Created indexes and implemented optimizal fill factor for all tables.
• Create and Modify User Defined Functions,Stored Procedures, Triggers, Views according to the business requirements.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques. Used Try catch and error for exceptional handling.

Environment: MS SQL Server 2008R2/2005, SSIS, SSRS, SSAS, DB2, MS Access,, ASP.NET, C .NET, ADO.NET, Windows XP, .NET Framework 3.0,Visual Studio 2008/2005, HTML, JavaScript, XML.

Confidential

SQL Developer

Responsibilities:

• Developed reports using SSRS and exported directly to EXCEL, CSV and PDF formats bypassing the report manager screen running the reports from ASP.NET application.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 using SSRS, T-SQL, scripts, stored procedures and views .
• Developed complex queries in T-SQL, wrote Stored Procedures, Triggers and Queries with best execution plan. Created cubes and dimensions for the analysis of sales in specific areas.
• Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to SQL server 2005.
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• Created stored procedures and user-defined functions for different Reports.
• Created complex correlated sub queries to generate reports.
• Knowledge of working on translation to SQL cluster.
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies. Developed, monitored and deployed SSIS packages.
• Utilized SSIS SQL Server Integration Services to produce a Data Mart for reporting.
• Worked with SSIS packages involved FTP tasks, Slowly Changing Dimension, Fuzzy Grouping, Merge, Merge joining, Pivot, Unpivot Control Flow Transformations.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Migrated all DTS packages to SQL Server Integration Services SSIS and modified the package according to the advanced feature of SQL Server Integration Services.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services SSRS . Deployed the generated reports on to the server.

Environment: Visual Studio 2008/2005, MS SQL Server 2008R2/2005, SSIS, SSRS,DB2, MS Access, ASP.NET, C .NET, ADO.NET, Windows XP, .NET Framework 3.0/2.0 , HTML, JavaScript.

Confidential

SQL Developer with .Net

Responsibilities:

• Involved in translating the customer requirements into Design specifications and ensured that the requirements translate into software solution.
• Responsible in developing UMLDiagram from start to end MSVisio.
• Written business rules and resolved some of the issues faced by the Analysts.
• Developed custom selection of reports ordering using SQL Server Reporting Services SSRS .
• Governed and maintained performance and analysis portfolio of SQL Server Reporting Services report.
• Designed interactive web pages with front end screens using WinForms, ASP.NET, C , VB and HTML technology for the e-statement server as per the requirements.
• Developed core functionality with the .NET Framework C , ASP.NET, ADO.NET .
• Created a DLL for Data Access Layer, used ADO.NET.
• Used Reporting Services SSRS to schedule reports to be generated on predetermined time.
• Implemented data cleansing, data standardization.
• Created SSIS Packages for populating the data into dimension tables and fact tables.
• Implemented different partition techniques for parallel loading process.
• Involved in Performance Tuning of SSIS Packages,reports, Views, Stored proceduresusing SQL Profiler and Tuning Advisor improving performance and scalability.
• Developed C objects to store/retrieve files directly from SQL Server posted to/from the browser using the ASP.NET.
• Handled Configuration Session, authentication and authorization, custom errors, tracing and so on for the online transactions by the customer and creating user login and privileges.
• Designed relational Database and Datawarehouse Databases.
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
• Created SQL scripts for data load into tables getting customer data from different servers and databases.
• Created user defined functions, Storedprocedures, views and triggers in Sql Server 2005.
• Worked on LDAP connectivity using C to retrieve the contact information.
• Developed Security Layers for web page security and User Authentication in VB.NET.
• Handled Run Time Errors Design Time Errors by implementing appropriate Error Handlers in C and VB.NET / Troubleshooting and testing using Load Runner.
• Design of Class diagrams, Use cases and sequence diagrams in UML.

Environment:MS SQL Server 2008R2/2005, Visual Studio 2008/2005 SSIS, SSRS, C , ASP.NET, WinForms, ADO.NET, XML, CSS, JavaScript, UML, MS Visio.

Confidential

SQL Server Developer

Responsibilities:

• Tested and configured automated routine maintenance tasks like performance tuning, indexes and stores procedures, checked deadlocks and created scheduled jobs.
• Creation, manipulation and supporting the SQL Server Database.
• Took part in data normalization process along with senior data base analyst.
• Involved in performance tuning and monitoring of both T-SQL blocks.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Performed ExtractTransform and Load ETL operations to load data from flat file, Oracle, Access,DB2 etc.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Designed and optimized Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environments.
• Worked with database connections, Joins, cursors, aggregations, keyconstraints, etc.
• Created reports using SSRS. Developed scorecards for the system using SQL Server reporting services SSRS . Used DTS to transfer files from Excel datasheets to SQL server database.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Used SQL Server Profiler to track database activities to identify conflict between application and database. Created reports using MS visual studio 2005 to present data to the management.

Environment:MS SQL Server 2005/2000,Visual Studio 2003/2005, Visual Basic 6.0, DTS, C .Net, ADO.Net, CSS, XML, Oracle, MS Access, Windows XP/2003.