PROFESSIONAL SUMMARY

• Around 9+ years of in - depth experience in database design, development, administration maintenance and Analysis of SQL Server 2012/ 2008 / 2005 large scale databases for both OLTP and Data Warehousing System applications like SSIS and SSRS in Government, Finance, Health Care, Insurance, E-Commerce and Pharmaceutical Sector .
• Hands on experience in developing and writing T-SQL queries, store procedures, triggers, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous Systems using DTS and SSIS of MS SQL Server 2012/2008/2005.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Good hands on experience on SQL Server 2012/2008 administration.
• Good command in generating On-demand and Scheduled reports for Business Analysis and Management decisions using MS SQL Server Reporting Services 2012/2008 (SSRS).
• Accomplished in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Defining Data sources and Subtotals for the reports using SSRS 2012/2008.
• Strong experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
• Knowledge of migrating DTS packages, reports and analysis services projects from SQL Server 2000 to SQL Server 2008.
• Experience of Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling.
• Experience in working with the DBA Team to perform day to day rollouts.
• Expert in using tools like MS SQL Profiler, Database Engine Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member and managing the data quality issues.
• Development experience using technologies like .Net 4.0/3.5/2.0, ASP.NET, WCF Services, C#, VB.NET, ASP, VBScript, VB, HTML and XML.
• Experience in developing projects using Agile Methodology. Worked in sprint cycles in the incremental product development approach using SCRUM.
• Excellent working experience on n-Tier and layered architecture, Service Oriented Apps, Load Balancing, Web form applications and Single Page Applications (SPA)
• Proficient experience in web and window application development using Object Oriented N- Architecture.
• Significant Experience in each phases of Software Development Life Cycle (SDLC).
• Experience in using unit-testing like NUNIT, log4Net and proficient in writing test plans.
• Integrated X509Certificate to secure the service and enable Message Security mode in WSHTTP and Net.TCP binding.
• Extensively used WCF components to implement Service Oriented Architecture.
• Configure IIS and hosting WCF service and Web sites.
• Configure Application Pool, set domain user and pass through integration security.
• Proficiently used Team Foundation Server, Visual Source Safe, Tortoise SVN and GIT for version control.

PROFESSIONAL EXPERIENCE

Confidential, Aventura, FL

Senior BI & SQL Developer

Responsibilities:

• Developed various T-SQL stored procedures triggers, views, data extraction and adding/changing tables for data load and transformation.
• Analyzed & designed the business rules for data cleansing that are required by the staging, OLAP and OLTP databases.
• Worked very closely with the DBA team to ensure data integrity and security, provided architecture guidance.
• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing data sources.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file and Text Format Data.
• Created & formatted cross-tab, conditional, Confidential -down, Confidential through, summary, form, sub reports, parameterized reports, interactive reports & custom reports.
• Responsible for automation of maintenance jobs, SSRS subscriptions (Data Driven, Normal subscriptions), locks and index configurations.
• implemented SSRS Business Intelligence Life cycle such as Configuration of Report server Configuration, Deployment of reports, creating report subscription (Data Driven) in Development, Test, Production environments.
• Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements.
• Created stored procedures that retrieve XML and created packages in Visual Studio.
• Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Developed Qlikview Dashboard and Load Scripts for distribution across multiple data sources.
• Designed and maintained Qlikview applications.
• Maintain Job scheduling and manage End of month Process.
• Performed database backup/recovery, performance tuning with the DBA team.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Migrated packages from development server to production server using package configuration.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Created various geographical and time dimension reports of fiscal year, quarter, month, week and daily reports for all domains and published through Report Server.
• Designed and developed various reports by comparing the growth of company based on each quarter by using bar charts.
• Responsible for generating annual reports based on the growth of company with respect to customers.
• Used Visual Source safe for repository and maintaining versions.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Environment: BI 2013, MS SQL Server 2012/2008 R2/2008, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Visual Studio 2012, VB .NET, C#, MS Visio.

Confidential, Miramar, FL

Senior BI & SQL Developer

Responsibilities:

• Created databases and schema objects including tables, indexes, constraints and connected various applications to the database and written functions, stored procedures and triggers.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Created Ad hoc reports using Report builder 2.0/3.0 in SQL SERVER 2005/2008/2008 R2
• Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded into target data sources by performing different kinds of transformations using
• SQL Server Integration Services (SSIS).
• Working experience with Column store indexes, table partitioning in SQL SERVER 2012.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created different Power Pivot reports as per the client requirement.
• Involved in performance tuning using indexing (Clustered Index, Non-Clustered Index) tables.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.

Environment: BI 2013, MS SQL Server 2012/2008 R2/2008, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services 2008 (SSRS), Visual Studio 2012, VB .NET, C#, MS Visio.

Confidential, Miami, FL

Senior BI & SQL Developer

Responsibilities:

• Performed Design and Coding for Standard Tabular type reports, including Confidential down and
• Confidential through functionality and Graphical presentations such as Charts and Dashboard type metrics, SSRS reports using MS Visual Studio.
• Converted Business Objects reports into SSRS.
• B uilt connections to pulling data from AS400, mainframe/db2 and Oracle.
• Created database objects like table, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and maintain database efficiently.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the SSRS report.
• Configure SSIS Package for run time Parameters and config file.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Developed many stored procedures which were used in the reporting.
• Scheduled alerts for successful or unsuccessful completion of Scheduled Jobs.
• Documented the data flow, source and target mappings from the existing data loads which are being carried out through manual steps and developed a strategy to automate the process using SSIS.
• Designed and developed SSIS (ETL) packages to validate, extract, transform, which was load data from spread sheets to the Clients server, automated many manual steps which were being used to load the data.
• Implemented data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived column and Joins in SSIS
• Developed and deployed data transfer packages using SSIS and maintained the jobs running on Servers.

Environment: MS SQL Server 2012/2008R2,Reporting Services (SSRS), Integration Services(SSIS), Microsoft Performance Point Server 2007, XML,T-SQL, .NET, C# MS Access and Excel.

Confidential, Sunrise, FL

Senior BI & SQL Developer

Responsibilities:

• Responsible for Conceptual, logical and physical design with a significant effort towards application
• Created SSIS packages to extract, transform and load data from Flat File to Flat File and Flat File into the Data warehouse to Report-
• Data mart, using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Changing Dimension.
• Used VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Generated Tabular reports, Cross Tabs, Confidential down, Confidential Through, Cascading and Parameterized Cascading Reports, Sub Reports, Summary Reports, Charts, Functions and Maps using SSRS, Tableau reports.
• Worked with Business Analysts, other DBA team members to review the business requirements and translate them into database objects.
• Analyzed informational needs and elements, data relationships and attributes, proposed manipulation, data flow and storage requirements, have reporting and data output capabilities for complex databases.
• Managed Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Developed measures and dimension members using multi-dimensional expression (MDX) to meet additional needs that were calculated from existing measures.
• Used Query Optimization and SQL Server Profiler for tuning report queries and improves performance in SQL Server.

Environment: MS SQL Server 2012/2008 R2/2008, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services 2008 (SSRS), Visual Studio 2012/2008.

Confidential

Senior BI & SQL Developer

Responsibilities:

• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to DW
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Generated reports to retrieve data using database code objects, such as Stored Procedures, views, functions and multiple TSQL.
• Used to develop the reports by using SSRS and Power Pivot.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the SSRS report.
• Included Report Design and Coding for Standard Tabular type reports, including
• Confidential down and Confidential through functionality and Graphical presentations such as Charts and Dashboard type metrics, Tableau Reports using SSRS
• Designed and developed Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.
• Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Configured the report viewing security for various users at various levels using SSRS Report Manager.

Environment: MS SQL Server 2008, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services 2008 (SSRS), Visual Studio 2008, Win NT /2000/ 2003, C#, MS Office 2003/ 2007, MS Visio, Data staging.

Confidential, Portland, ME

.Net Developer & SQL Developer

Responsibilities:

• The various modules involved in the application are related to Policy, Plan, Claims, Payment and Accounts.
• The Admin module is acting as the central and core initiator of all the other modules.
• Application is also used to bring together data from multiple, unrelated sources to make a better performance.

Environment: ASP.Net 3.5, VS 2010, C#, SQL Server 2008, ADO.Net, ASP.Net, AJAX, LINQ

Confidential, FL

.Net Developer & SQL Developer

Responsibilities:

• Confidential is an internet security company that Confidential technologies and provides consumers with products to insure safe web activities.
• The project Consumer Confidence is an independent authority in providing consumers with information to ensure they are purchasing from sites they can trust.
• It gives valuable information about the owner company of a website including contact and hours of customer service, security level of the website, return policy which helps in increasing consumer s confidence for their online shopping.
• My role here was to develop this website from scratch to finish.
• I have developed UI and business logic using ASP.Net 3.5 in C# and SQL Server 2005 as database.

Environment: ASP.Net 3.5, VS 2010, C#, SQL Server 2008, ADO.Net, ASP.Net, AJAX, LINQ