PROFESSIONAL SUMMARY:

• 8 years of Extensive experience in MS SQL Server with Business Intelligence/SQL Server Reporting Services (SSRS) and ETL/SQL Server Integration Services (SSIS).
• Experience in Design and Developing applications using C# and ASP.Net Technologies and Sound Working Knowledge in Web application development and Web services design.
• Hands on experience in MS SQL Server SSIS Packages for integrating data from heterogeneous sources (RDBMS, Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Aggregate, Data Conversion, Conditional Split, Bulk Insert, Fuzzy Grouping, Fuzzy Lookup and Merge.
• Hands on experience in Creating Report Subscription, Data Driven Subscription, linked & parameterized reports, drill down reports using SQL Server reporting services (SSRS). Configuring and maintaining Report Manager and Report Server.
• Implemented SSIS transformations such as lookup, merge, derived column, data conversion and aggregate.
• Loaded large table data and created SSRS reports from different source using SSIS and SQL Ad - hoc queries. Modified the format and structures of the SSRS reports according to the end-user requirements. Created Ad-Hoc reports using Report Builder.
• Created complex Stored Procedures, Triggers, Tables and other SQL Joins and Statements for Applications by using T-SQL. Experience in Creating complex Views, Triggers Tables, Views, Indexes, Stored Procedures and User-Defined Functions to implement Business Logic and Data Protection.
• Experience in Creating SSIS and DTS package development and implementation for different tasks.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using MSSQL Server DTS and SSIS
• Experience in SQL Server Migration and Migration of DTS Packages to SSIS.
• Strong experience in creating complex Stored Procedures, Replication, Index, Functions, DTS packages, triggers, cursors, tables, views and other SQL joins and statements.
• Expert in creating SQL Server Reports using SSRS in designing stylish report layout parameterized, performance, Chart Reports, ad-hocreports.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS. Experience in report writing according to the business requirement in SSRS.
• Expert Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Experience in SQL Server Migration and Migration of DTS Packages to SSIS.
• Experienced in performance Monitoring and Tuning, Query Optimization via T-SQL and SQL Profiler.
• Strong experience in design and construction of data marts, data views and data mining
• Experience in SQL Server Migration and Migration of DTS Packages to SSIS.
• Experience in creating Jobs, Sending Alerts using SQL Mail. Used Microsoft Source Safe for version control and configuration management.
• Good experience in web development using ASP.Net, C#, HTML, DHTML, CSS and JavaScript
• Sound Knowledge on .Net framework visual studio.
• Strong communication skills and ability to work in a team and individually.
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
• Scheduling package execution in SSIS.
• Provided support SQL Server Reporting Services (SSRS) environment by installing, configuring and deploying reports.

TECHNICAL SKILLS:

Operating Systems: Windows Server and Windows 98/XP/Vista/07

Database Tools: Profiler, Management Studio/Enterprise Manager, Query Analyzer, SSIS, SSRS

Languages: C#, ASP.Net, SQL, T-SQL, HTML

Databases: SQL Server 2012,2008 R 2/2008/2005/2000

OLAP Tools: SQL Server Reporting Server, SSIS (as ETL);

GUI Tools: Visual Studio .NET 2010/2013, .Net Framework 4.0/4.5

Web Server: Internet Information Server (IIS) 5.0/6.0

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

MS SQL Server SSRS / SSIS Developer.

Responsibilities:

• Migration of databases from SQL Server 2008 R2 to SQL Server 2012 for various environments.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Expertise in SQL Server Reporting Services (SSRS), Created Tabular, Matrix, Drill Down, Bar Chart, Pie Chart reports to analyze critical data in SSRS.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments.
• Created the SSIS /DTS packages and scheduled them using Sql Server agent
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component and Slowly changing dimension .
• Utilized event handling effectively to generate audits and logs for the generated SSIS packages.
• Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS
• Working with development and systems teams to perform application and database tuning.
• Hands-on experience in Microsoft .NET Framework 4.5/4/3.5, C#.
• Applied Styles to Webpages using CSS to ensure standards
• Designed and developed webpages using ASP.NET, C#, AJAX, JavaScript
• Enhanced existing reports using ASP.net MVC 4.0 / C#.Net4.0.
• Designed, developed Email functionality including UI interfaces using ASP.net MVC 4.0 and C#.Net 4.0 and integrated seamlessly with existing module
• Developed an Enterprise web application using ASP.Net, C#, .Net3.5, SQL Server 2005 and SSIS.
• Used .Net Framework class library to build user interface that separated application logic from presentation code using code behind pages.
• Writing new engine classes, business model in C# also maintaining existing classes for connectivity with SQL Server databases
• Created business Model in C# to maintained connectivity with SQL Server databases
• Developed ASP.NET MVC views, models and controllers.
• Evaluating data modeling, database administration, and database backup and recovery.
• Involved in creation of Relational Database, dimension tables, fact tables, constraints between the dimension and fact tables and primary and foreign key relationships between the dimensions and facts.
• Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.

Environment: SQL Server, 2008 R2, Windows Server 2008, SSIS, SSRS, C#, .Net, ASP.Net, SQL Profiler, Database Mirroring

Confidential, Irvine, CA

MS SQL Server SSIS SSRS SSAS Developer

Responsibilities:

• I was working as a Senior SQL Server SSIS/SSRS/Developer.
• Used checkpoints to implement the restart ability of the packages in SSIS
• Implemented custom logging in SSIS using event handlers and execute sql task.
• Developed Dynamic packages using SSIS and Implemented Incremental Data Loading.
• Implemented Error Logging using Event Handlers and also implemented logging in SSIS Packages in visual studio(MSVS)
• Created dynamic Package Configuration of type Sql Server table.
• Involved in Setup of maintenance jobs in all Servers schedule to run at various times.
• Creating and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS)
• Created partitions to improve the performance of data retrieval.
• Documentation of Technical specification documents from Functional documents provided by client.
• Worked on additional features like prompt pages, setting filters, conditional variables, calculations and hyperlinks to improve report presentation and to make report user friendly.
• Dashboards creation with charts (line bar, stacked bar) and crosstab and repeaters to provide required Calendar view report and better data presentation.
• Created Calendar view report using List and repeater tables to capture the project Deployment Start date and project Names within the selected start and end date.
• Designed prompt page using Value prompt (drop down), Radio button, Multi- Select, date, etc to provide value selection flexibility to user. Dashboard and report designing with multiple functionalities.
• Design and develop reports using Conditional Blocks and Conditional Styles to fulfill complex business requirement into a single report and to highlight key data.
• Understanding existing C# code developed in Windows application and converted that into Web.
• Participated in Design session to develop UI screen and application design.
• Developed screens using ASP.NET, Html, CSS
• Several interactive Web forms were created using ASP.net using backend as SQL 2005. Several validators were used. Created WCF service interfaces. Developed business objects using ASP.Net for various modules.
• Involved in Design and Developing components of this application using ASP.NET, C# .NET, JavaScript
• Worked With ASP.NET Web Parts, Navigation Control, Master Pages and Web User Controls.
• Designed the database structure as per the requirements using SQL Server Data Flow Diagram.
• Developed Application layer using ASP. Net, Server controls, HTML Controls, Data Grid, Data List and Validation controls.
• Developed business layer components in C# as code behind files.
• Worked on Line chart to analyze the detailed Average amount spend per deliverables per month.

Environment: Unica (EMM), SQL Server 2008 R2, SSIS, SSRS, Red Gate, C#, ASP.Net, SQL Profiler, Replication, Pervasive, Lite Speed, Windows Server 2008.

Confidential, Deerfield, IL

MS SQL Server Developer

Responsibilities:

• Extensive use of SSRS to initiate, design, develop, and deploy reports that projects performance metrics.
• Created simple and complex tabular, matrix, drill-down, and drill-through, sub, and chart reports.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins and formatted the results into reports and kept logs.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis.
• Documentation of all the processes involved in maintaining the database for future
• Created AD-Hoc reports using Report Builder.
• Created number of standard reports and complex reports to analyze data using Slice & Dice and Drill Down, Drill through using SSRS
• Created reports using SQL Server reporting services (SSRS), which is then exported as PDF.
• Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks
• Involved in Unit Testing, Integration and deployment in Production and Staging Servers.
• Reports were deployed and managed on the report server using the report manager.

Environment: MS SQL Server 2005, Reporting Services (SSRS), T-SQL, Report Builder 2.0, Oracle 9i, and Windows 2000 Server/XP.

Confidential, Tampa, FL

BI/SQL Developer

Responsibilities:

• I worked as a SQL Server, Cognos and Microstrategy Report Developer.
• Migration of databases from MS SQL 2005 to MS SQL 2008 in Test Environment and Production Environment. Also worked on Migration from Oracle to SQL Server handling different applications.
• Placed the non-clustered index on the separate file group to improve the performance.
• Created SSIS Packages to migrate the data from database to Text files. Scheduled the SSIS package services to run at different intervals to fetch the data and for transferring the data into other database.
• Involved in migration of DTS Packages into SSIS Packages when moving from SQL 2005 to SQL 2008.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Identified & worked with Parameters for parameterized reports in SSRS 2005. Created Ad-Hoc reports using Report Builder. Generated drilldown, drill through and linked reports using SSRS.
• Generated variousList Reports,Grouped Reports,Cross tab Reports,Chart Reports, Drill-DownandDrill-Through Reports, master-detail, chart and complex reports which involved Multiple Prompts inReport Studio.
• Gathered and analyzed business requirementsfrom users and business community and Documented Technical specification documents from Functional documents.
• Used some advanced features likeConditional FormattinginReport Studioin generating multipage Reports.
• Experience inOLTP/OLAPSystem Study, Analysis and ER Modeling, Maintaining Database Schemas likeStar SchemaandSnowflake Schemaused in relational and dimensional modeling.
• Reports migration from DEV to TEST and TEST to PROD environment after fixing the enhancements and the defects.
• Performed transition KT to Infosys team to handover the support activity.

Environment: Citrix, SQL Server 2008, 2005, Lite Speed, SSIS, SSRS, Clustering, Windows Server 2008, Congo’s (DEV, TEST and PROD), Microstrategy 9.2(DEV, TEST and PROD), Remedy

Confidential, Tampa, FL

BI/SQL Developer

Responsibilities:

• Developed SQL Queries and stored procedures to fetch data from different tables in remote databases using joins, database linked servers. Creating logins & users with specific roles & permissions, managed security and permission of database. Interacted with Business Users for Reporting Requirements. Used third party tools like SQL Safe for protecting the source code and Diagnostics Manager for monitoring the server.
• Experience in working with SSRS 2008 for generating reports like Drill Downs and Drill Through.
• Proper use of Indexes to enhance performance of individual queries for fast & efficient reporting.
• Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history. Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool. On call 24/7 support to databases on weekly rotation
• Experience in requirement gathering, analysis, planning, designing, coding and unit testing.

Environment: SQL Server 2008, 2005, Database Mirroring, SSIS, SSRS, Report Builder