PROFESSIONAL SUMMARY:

• Over 8+ years of IT experience as a MSBI Developer 2005/2008/2012 in various Industry verticals like Health Care, Finance, Pharmaceuticals and Retail.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Joins, Indexes, Data Import/Export, Triggers.
• Extensive experience in MSSQL Server 2005/2008/2012, Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
• Expertise in the usage of ETL tools including SSIS, DTS for large - scale Data warehouse implementation Projects involving conversion of data from heterogeneous data sources including SQL Server 2008 R2.
• Proficient in Data Migration from sources like Access, CSV, SQL server, Text Files, Excel to SQL server 2000/2005/2008 using SQL Server Integration Services (SSIS).
• Experience in SQL Server Reporting Services (SSRS). Experience in creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence.
• Expertise in developing parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Drill-down, and Drill-through And Cascading reports using SSRS.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008/2012 .
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Extensive knowledge in SQL Server Integration Services (SSIS). It features a fast and flexible ETL Data Warehouse Tool used for Data Extraction, Transformation, & Loading. The tool also is used to automate maintenance of SQL Server databases and updates to multidimensional.
• Extensive experience working with DTS, SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle.
• Proficient at data transformations like lookups, derived Column, Conditional Splits, Sort, data Conversation, multicast and Derived columns, Union All, Merge Joins, Merge, Fuzzy lookup, Fuzzy Grouping, Pivot, Un-pivot and SCD to load data in SQl SERVER destination.
• Developed ETL process using SSIS with various control flow, data flow tasks and store procedures for work order validation process
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Designed and developed more than 100+ enterprise reports (SSRS/Business Objects) using the data from ETL Loads, various heterogeneous data sources
• Maintained positive communications and working relationships at all business levels.

TECHNICAL SKILLS:

Languages: C, C#, SQL

Web Technologies: HTML, XML.

Databases: MSSQLServer 7.0/2005/2008/2008 R2,2012,Oracle10g/11g/9i,MSAccess 97/2000/2003, MySQL,Teradata V2R5/V2R6/V2R12

SQL Server Tools: Business Intelligence Development Studio (BIDS), Enterprise Manager, Query Analyzer, Profiler, Performance Monitor.

Reporting Tools: SQL Server Reporting Services (SSRS)

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)

Development Skills: T-SQL, PL/SQL

Methodologies: Data Modeling-Logical, OLAP, OLTP, SDLC

Operating Systems: Windows98/NT/2000/XP, Windows Server 2003/2008, UNIX, LINUX

Application Packages: MS Office 200/2007/2012.

PROFESSIONAL EXPERIENCE:

Confidential - Cranbury, NJ

Senior SQL Server Developer/SSAS/SSIS/SSRS

Responsibilities:

• Worked on T-SQL to create Tables, and stored Procedures.
• Created and integrated user defined functions and stored procedures for reporting purposes
• Generated reports using SQL server reporting services (SSRS).
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Created Linked Report In the Report Manager.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS
• Scheduled reports for daily, weekly, quarterly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Identify the associated Store Procedures and parameters used for the reports
• Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server
• Used SSIS package to populate data from excel to database, used lookup, derived column and conditional split to achieve the required data.

Environment: SSIS, SSRS, MS SQL Server 2008/2012, Visual studio 2008/2012, MS Access, MS Excel, MS Office Access 2007

Confidential, Charlotte, NC

Senior SQL Server Developer/SSAS/SSIS/SSRS

Responsibilities:

• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Designed Database, Tables and Views structure for the new database.
• Created SSIS Packages to move the data from tab delimited flat flies into SQL database. Made dynamic SSIS packages which did data scrubbing, including data validation checks
• Created complex SSIS packages using proper control and data flow elements.
• Worked on Designing, developing, implementing, and maintaining reporting frameworks
• Used Lookups Transformation to get the data from reference data sets (SSIS).
• Created sub-reports to present more detailed information about the summary.
• Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
• Created packages using script task, containers to logically execute the SSIS package to improve performance and execution time.
• Worked on data cleansing techniques using look ups, conditional split, and fuzzy lookup.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Designed, developed and modified various interface reports using SSRS.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Drill-down, Drill-through And Cascading reports using SSRS.
• Installing and Configuring the Report Manager
• Deploying, Scheduling and setting Security for reports through the Report Manager. This enables easier a, automatic maintenance of multiple reports in an organization.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Documented all processes involved in maintaining the database for future reference.

Environment: MS SQL Server 2005/2008/21012, MSBI (SSIS, SSRS, SSAS), Visual studio 2008/2012, MS Access, MS Excel, MS Office Access 2007, SQL Profiler, Data Analyzer.

Confidential, Charlotte, NC

Senior SQL Server Developer/SSAS/SSIS/SSRS

Responsibilities:

• Developed stored procedures and triggers in T-SQL.
• Planned, defined and designed data based on the business requirement
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Implemented Incremental load, used Event Handlers to clean the data from different data sources
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved with Query Optimization to increase the performance of the Report.
• Developed Reports for business end users using Report Builder with updating Statistics.
• Database and Log Backups and Scheduling Backups by creating and deploying SSIS packages.
• Dealt with Fine-tuning Stored Procedures to improve performance with a Query plan using SQL Tuning advisor.
• Employed Filtered Indexes to improve query performance and reduce the storage and maintenance cost.
• Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema
• Documented and maintained database system specifications, diagrams, and connectivity charts.

Environment: SQL Server 2008/2012, Integration Services (SSIS), Reporting Services (SSRS), T-SQL, Windows /NT/2007/2008, XML, MS Excel, MS Access, MS visual Studio.

Confidential, Old Bridge, NJ

SQL Server Developer/SSAS/SSIS/SSRS

Responsibilities:

• User Defined Functions, Views, TSQL for complex business logic
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2000 using DTS Packages.
• Created complex Stored Procedures and Functions for integrity checks of transferred data.
• Created complex stored procedures to transfer images, word docs, excel files, pdf files and various other extensions files into the database..
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS. Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
• Worked on using script task, containers to logically execute the SSIS package to improve performance and execution time.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Database.
• Designed, developed and modified various interface reports using SSRS.
• Created Tabular reports, Cross Tabs, Drill Down, Charts, Functions and Parameterized report using SSRS.

Environment: MS SQL Server 2005, .Net 3.0, SQL BI Suite (SSIS), XML, MS Excel, MS Access 2003 & Windows Server 2003, SQL Profiler, DTS, Data Analyzer.

Confidential, Metuchen, NJ

SQL Server Developer/SSAS/SSIS/SSRS

Responsibilities:

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: Windows 2007 enterprise, SQL Server 2008/2005,SQL Integration Services(SSIS), Business Intelligence Development Studio, Visual Studio 2008/2005, OLE DB

Confidential, West Chester, PA

SQL Server Developer/SSIS Developer/SSRS Developer

Responsibilities:

• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard dashboards on SQL Server 2008 using SSAS, SSISDTS, SSRS.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Monitored Full Incremental Daily Loads and support all scheduled ETL jobs for batch processing.
• Migration of DTS packages to SSIS packages
• Involved in Migration of Databases from SQL Server 2005 to SQL Server 2008 using SSIS.
• Configured and Monitored Database Mirroring for Application Development environment
• Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio.
• Developed, monitored and deployed SSIS packages

Environment: MS SQL Server 2000/6.5/7.0, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Profiler, SSAS, SSRS,SSIS.