SUMMARY

• Over 7 years of IT experience in all the aspects of Software Development Life Cycle (SDLC) which includes Analysis, Design, Development, Testing of applications using Data Warehousing concepts and Business Intelligence tools.
• Working experience with MS SQL Server ( /2005/2000 /7.0 ) and Visual Studio ( 2010/20 ) used to 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) and Analysis Services (SSAS) for data warehousing and data marts.
• Created packages using SQL Server Integration Services (SSIS) for data Extraction from/Load to Flat Files, Excel File MS Access, DB2, Oracle etc.
• Creating and monitoring the batch jobs using SQL Server Agent. worked on building a site with modern frameworks such as bootstrap that attracted a lot of visitors.
• 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 Project based deployment introduced in 2012 SQL Server Data Tools (SSDT).
• Deployed the Projects to Integration Services Catalog and managed the security. The Configurations are set from Project and Package parameters through the Environment.
• Having good knowledge on creation and scheduling of T - SQL jobs to run daily
• Sound knowledge of SQL Server Analysis Services (SSAS), SharePoint 2010 development and Performance Point Services (PPS), SQL Server Reporting Services (SSRS), Power Pivot (Excel 2010).
• Installed Configured and maintained SQL Server Reporting Services (SSRS) reports and deployed to the Report Manager 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 SQL Server Analysis Services (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 multiple facts in a single cube with shared dimensions.
• 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 Star Schema and Snowflake Schema Dimensional model.
• Experience in RDBMS database and tables design Normalization, De Normalization, Unique, primary, foreign keys and Clustered, Non clustered Indexes.
• Extensive experience with T-SQL in writing and debugging complex stored procedures, triggers, table views and user-defined functions.
• 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 Data reader. 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, Web Services, XML and XSL.
• Development of Interoperable WebServices, Winforms, Console Applications using C# and VB. Net.
• Well versed with IIS, registry, assembly configuration. Used Powershell script to register .net assembly in GAC.
• Also has experience in MS SQL Server configuration, performance tuning (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

Databases: MS SQL Server 2012/2008R 2/2008/2005/2000, Oracle 10g/9i/8i, DB2, Access

ETL Tools: SSIS, DTS

Reporting Tools: SSRS, Crystal Reports X1/X

Languages: C, C++, C#, LINQ, Visual Basic

.NET Technologies: Web Forms, ASP.NET, ADO.NET, .Net 3.5/3.0/2.0, Web Services

Web Servers: Microsoft IIS, SharePoint 2010/2007

Scripting Languages: JavaScript, JQuery, AJAX, HTML, XML, XSD, CSS, T-SQL, Powershell

Methodologies/Tools: UML, MS Visio

IDEs/CMS/Tools: MS Visual SourceSafe VSS, TFS, Visual Studio 2010/08/05/03, Powerpivot

Operating Systems: Windows Server 2008/2003/2000, Windows 7/XP

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia PA

Bi Developer

Responsibilities:

• 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 design documentation.
• Installed, configured and maintained SQL Server Integration Services (SSIS).
• Deployed packages to SQL Server and file system in 2008 and also used the new Project based Deployment introduced in 2012 SQL Server Data Tools (SSDT) to deploy the 2012 packages.
• Configured and deployed the SSIS 2012 projects to the new Integration Services Catalog. Set the Environment and managed configurations using the Package and Project variables.
• Maintained the SSIS projects and users accessing the Catalog and SSISDB.
• Construction of UIs using jQuery, Backbone.js, Bootstrap and JavaScrip
• Scheduled and monitored the SQL Agent jobs to run these packages periodically.
• Web application design and development using the Play framework, Bootstrap.
• Experience in creating, maintaining and tuning Views, Stored Procedures User Defined Functions and System Functions using SQL Server, T-SQL.
• Involved in loading the partner flat files into the OLTP database. Also, developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Created SSIS packages to Extract, Transformation and Load (ETL) inventory and other sales data from Flat Files, Excel Files, Access, Mainframe DB2, Oracle etc.
• Created new SSIS packages for the existing legacy Data Transformation Services (DTS) packages in the due course of data migration from SQL Server .
• Scheduled and monitored the execution of the jobs using a third party tool Global Event Control Server (GECS) and SQL Server Agent.
• Worked on Excel 2010, Power Pivot for providing ad-hoc reporting for the clients.
• Used package variables and configuration files to run the packages manually mapping through environment variables in case of job failure.
• Implemented SQL Server SSIS packages for ETL methodologies involved in the migration from SQL Server and 2008 and created new SSIS packages for the legacy DTS packages and scheduled and monitored the execution of the jobs.
• Used SQL Server Reporting Services (SSRS) to create reports, customized Reports, on-demand reports, Charts, KPIs, Drilldown Drillthrough and other Canned reports and multi-dimensional reports from the cubes and Deployed to Sharepoint and ReportManager.
• Migrated, recreated and maintained the Legacy packages, cubes and reports.
• Migrated some of the SSRS reports from and from environment.
• Supported Style Sheets that contain drill down parameters and links to arbitrary URLs and embedded GIF images in report headings and footings.
• Involved in building and maintaining dimensional cubes with SQL Server Analysis Services (SSAS) and used MDX script for querying the data.
• Developed Business views, Report objects, Cubes for the users to analyze the data and help them in decision making.
• Deployed SSRS reports to Report Manager 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 Unit testing 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.

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

Confidential, Atlanta, GA

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 and Database 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.
• Performance Tuning the Stored Procedures used in SSIS Packages and SSRS Reports.
• 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.
• 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.
• 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 procedures using 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 Insert etc.
• 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, Irving, TX

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, Houston, TX

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 UML Diagram from start to end MS Visio.
• 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 procedures using 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, Stored procedures, 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:

• 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, key constraints, 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 Database Triggers to enforce Data integrity and additional Referential Integrity.
• Performed Extract Transform and Load (ETL) operations to load data from flat file, Oracle, Access,DB2 etc.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• 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.
• Involved in performance tuning and monitoring of both T-SQL blocks.
• 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
• Took part in data normalization process along with senior data base analyst.
• Creation, manipulation and supporting the SQL Server Database.
• Tested and configured automated routine maintenance tasks like performance tuning, indexes and stores procedures, checked deadlocks and created scheduled jobs.
• Used SQL Server Profiler to track database activities to identify conflict between application and database. Created reports using MS visual studio 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.