SUMMARY

• About 7+ years of IT experience in Analysis, Design, Development, Implementation, Debugging and Testing of software applications to support reporting and Business Intelligence initiatives
• Excellent knowledge in RDBMS and Data warehouse concepts
• Good programming, installing, configuring, managing, monitoring and troubleshooting experience in MS SQL Server 2005/2008/2008 R2/2012 and Business Intelligence in SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis Services
• Experience in creating stored procedures, views, indexes and effective user defined functions and appropriate triggers to facilitate data manipulation using T - SQL
• Experience in developing and modifying Cubes and Dimensions in cubes using SSAS
• Experience in creating different types of reports such as Table reports, List reports, drill down, drill through reports, Pie chart reports, Total reports, Sub-Total reports, Grand-Total reports
• Experience in integrating SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager.
• Experience in creating traditional as well as web-based interactive reports using SQL server reporting services sourcing OLAP cubes and Data warehouse, Data marts as well as transactional systems
• Expert in designing and scheduling complex SSIS packages for transferring data manually from multiple data sources to SQL server
• Experience with Data Transformation Services(DTL) an Extract Transform Load(ETL) tool of SQL server to populate data from various data sources by creating packages for different data loading operations of each application
• Developed SSIS packages to ETL/DTS data into the data warehouse from heterogeneous databases such as Excel, MS Access, MS SQL, Oracle

TECHNICAL SKILLS

Databases: SQL server 2005/2008/2008 R2/2012, MS Access, Excel

Database Utilities: SSIS, SSRS, SSAS, Data Transformation Services(DTS), Business Intelligence Development Studio(BIDS), Enterprise Manager, Query Analyzer, BCP, DTS Analysis Manager, SQL profiler

Languages/Scripting: C, C++, Java, HTML, CSS, PHP, SQL, T-SQL

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

PROFESSIONAL EXPERIENCE

Confidential, Lexington, MA

SQL BI Developer

Responsibilities:

• Created Tables, Views, Indexes, Stored Procedure. Used multiple join statements to retrieve data and update the tables.
• Used SSIS to produce a Data Mart for reporting.
• Strong experience in working withBCP,SSIS(DTS,DTSX)packages forData Integration Services.
• Extensive knowledge of usingSystem Variablesand creatingUser-Defined VariablesforSSISPackages.
• Implemented SSIS data, created maintenance procedures and provided data integrity strategies.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance.
• Maintained production OLAP cubes, wrote MDX queries to generate reports using SQL Server 2008 Reporting Services (SSRS).
• Implemented the complex query techniques of Passing Multi-Valued Parameters and cascading parameters in MDX.
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS).
• Worked with Report Builder 2.0, Report Models and Ad Hoc Reports.
• Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports.

Environment: SQL Server 2012/2008R2 Management Studio- Enterprise Edition, T-SQL, BIDS, SSIS, SSRS, SSAS, ProClarity, OLAP, XML, SharePoint, Agile, Microsoft Visual Studio 2008 w/.NET Framework 3.5, Windows XP.

Confidential, NC

SQL BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation. Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, and Views.
• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated reports using Global Variables, Expressions and Functions using SSRS 2008.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Maintained the table performance by following the tuning tips like Normalization, Creating Indexes etc.
• Performed Documentation for all kinds of reports and SSIS packages.

Environment: Microsoft SQL Server 2008, Management Studio, Reporting Services, SQL Server Integration Services, Oracle, Team Foundation Server, Visual Studio, Win 2000/XP

Confidential, Renton WA

SQL Developer

Responsibilities:

• Gathered requirements from Business and documented them based on functional specifications.
• Designed and implemented complex SSIS package to migrate data from multiple data sources.
• Created SSIS package to extract, validate and load data into Data warehouse.
• Extensively worked on creating SSIS packages and have used For each Loop containers, Sequence Container for developing processes and loaded data using different transformations such as Derived Columns, Condition Split, Aggregate, Merge Join and Union all.
• Created Stored procedure, Views, Cursors and functions to support application
• Extensively created SSRS reports (Executive Summary report for Annual and Quarterly) and Configured Report Server on all the environments. Also automate deployment for SSRS reports for all the environments.
• Implemented multiple grouping into several reports using visibility and toggle options.
• Actively supported Business users for change requests and provide support to team members.
• Provided support by troubleshooting and solving the issues.

Environment: MS SQL Server 2008 R2,SSMS 2008, Neteeza,DB2, Excel, Windows 2003 Server, Windows XP Professional, Visual Studio 2008, 2010, MS Visio 2010, Star Team.

Confidential, Foster City, CA

SQL BI Developer

Responsibilities:

• Created several SSIS packages in Microsoft SQL Server 2008.
• Transferred data from various OLTP data sources such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2008.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data into data warehouse
• Wrote several complex stored procedures for the ease of application.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Constructed Cubes based on data volumes
• Debugged and deployed reports in SSRS.
• Used SSRS to create, execute, and deliver tabular, matrix and chart reports.

Environment: Microsoft SQL Server 2008, Business Intelligence Development Studio, SQL Server Integration Services, SQL Server Reporting Services, Data Transformation Services, ODBC, Oracle 8i, MS Access, T-SQL programming.

Confidential

Jr. SQL Server Database Administrator

Responsibilities:

• Involved as part of a team for gathering and analyzing the end User Requirements.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Defined relationship between tables and enforced the referential integrity constraints.
• Created Clustered and Non-Clustered Indexes.
• Responsible for General Database Administration, Query Performance tuning.
• Worked with DTS packages to load the data into Data warehousing system.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Trouble shooting Problems by using SQL server profiler.
• Used DBCC commands for maintaining the databases.
• Assisted Database Developers to optimize SQL queries and Stored Procedures
• Export & Import data from Flat file, CSV file to/from SQL Server Database using SSIS
• Export & Import data from/to databases like Oracle, MySQL, and Access to/from SQL Server
• Responsible for capacity planning and disaster recovery
• Scheduled jobs to automate different database related activities including backup,
• Monitoring database health, disk space, backup verification
• Developed Different Maintenance Plans for database monitoring
• Monitored Server Activity, and solved problem as needed

Environment: Microsoft SQL Server 2000/2005, DTS, Windows 2000, XP