SUMMARY

• 8+ Years of IT experience as SQL BI Developer using MS SQL Server 2012/2008R2/2008/2005 in OLAP/OLTP environments.
• Domain knowledge on Media, Healthcare and Financial industry.
• Extensive experience in implementing SSIS, SSRS, SSAS using Microsoft Business Intelligence development studio (MSBI) and SQL Server data tools (SSDT).
• Expertise in writing DML, DDL and Transaction queries in T - SQL for MS SQL Server database.
• Generating complex Transact SQL (T-SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc. Programming in SQL Server - Using the stored procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs)
• Experience in checking data quality using SQL/Integration Services, identifying errors and error patterns, and suggesting some data cleansing mechanisms.
• Experience in creating and designing SSIS Packages for Integration and Migration of data from Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server using BCP and DTS utility and extracting, transforming and loading of data using SSIS in MSBI and SSDT.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging using SSIS.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Experience in deploying SSIS packages to multiple environments using different methodologies and performing Automation of SSIS Packages using SQL Server agent and different third party automation tools.
• Experience in configuring, scheduling reports for subscriptions on timely basis using SSRS report manager.
• Experienced in designing Ad hoc reports and different types of Cross tabs, Tabular reports, Matrix reports, Custom reports, Drill Down, Drill Through reports, Sub reports, Parameterized reports in multiple formats using multiple Data Sets and creating Charts using SQL Server Reporting Services SSRS 2005/2008/2012.
• Extensive experience in report writing using SSRS and also creating various types of reports like table, matrix and chart report, web reporting by customizing URL Access.
• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Experience and Expert in Generating on-demand and Scheduled Reports for business analysis or management decision using SSRS.
• Data analysis and data migration by transferring them using SSIS packages.
• Handled high level escalates of issues and assessed the risks.
• Excellent communication and analytical skills, good knowledge of business requirements in various domains.

TECHNICAL SKILLS

SQL Server Tools: SQL Profiler, Query Analyzer, SQL Server 2012/2008/2008 R2,SQL Server 2005 Management Studio, DTS, SSIS, SSRS, SSAS, MS Access 2003/2007

Database: MS SQL Server 2012, 2008, 2005, MS-Access.

Language: C, C++, C#, T-SQL.

Operating System: Windows 8/7/Vista/XP/NT/2000, DOS, Windows Server 2003.

Tools: Microsoft Visual Studio 2008/2005,Share Point Server 2007, Microsoft Project Server 2007.

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Reporting Tools: SSRS (SQL Server Reporting Services), Tableau.

ETL Tools: SSIS (SQL Server Integration Services), DTS.

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

SQL Server BI Developer (SSIS/SSRS/T-SQL)

Responsibilities:

• Highly responsible for development and management of SSRS and SSIS projects
• Worked with Business Analysts in requirements gathering and translating them to technical specifications.
• Prepared Reports modules as a developer on MS SQL Server2012 (SSRS, T-SQL, scripts, stored procedures and views).
• Wrote complex SQL queries using table joins (inner and outer).
• Simplified complex queries using temporary tables, table variables and stored procedures.
• Created reports (tabular, matrix, chart, drilldown reports, parameterized, cascade reports )according to business requirements
• Created SSIS packages for uploading of different formats of files (Excel, Access, dbf, flat files) and databases into the SQL Server.
• Coordinated with QA and Release management for projects and bug fixes to be released in production environment.
• Formatted the report layout for the requirement of the end users
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Extracting and Loading data into SQL Server Database using SSIS.
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
• Experienced in SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports
• Enhance existing reports by creating new Parameters & Formulas.
• Schedule the reports using Info View to run at specific times as desired by the Business Users.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Imported the various files provide by the clients into the relational database systems.
• Extensively utilized expression and constraint feature for conditional processing of flat files and flow control in SSIS.
• Proactively monitoring the performance of SQL Server databases, troubleshooting system issues and monitored scheduled jobs.

Environment: SQL Server 2012/2008 R2, Microsoft Visual Studio, MS BIDS, SSRS, SSIS, Management Studio 2005/2008, Windows XP platform, MS Office 2007.

Confidential, California

SQL BI Developer (SSRS/SSIS)

Responsibilities:

• Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Hands on experience with creation of tables, views, stored procedures, Functions and Indexes.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Created Jobs, Alerts and scheduled DTS to generate Reports
• Created SSIS package to load data to SQL Server, from Flat files or excel spreadsheet
• Implemented Extraction, Transformation and Load (ETL), Import, Export activities by DTS/SSIS package
• Experienced in building reports through report builder and report designer.
• Worked with creating reports using report model and applying row level security filters.
• Used BIDS SSAS against the data warehouse to verify the purchases and sales amount is correct.
• Strong technical knowledge in Troubleshooting and Performance tuning.
• Created reports with Conditional hiding and conditional formatting using Expressions in SSRS 2008
• Created reports and performed all Administrative activities. Also Installed and maintained SQL Server Reporting Services (SSRS) 2005.
• Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different retail locations.
• Performed data analysis to generate various trend reports.
• Generated Ad-hoc, matrix and tabular reports using SQL Server reporting services based on customer needs.
• Extensively involved in the SSAS storage and partitions and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Loading data from various data sources using MS Data Transformation Services.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups

Environment: MS SQL Server 2008/2005, Team Foundation Server, Microsoft SharePoint Server, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, Visual Studio 2005, Windows XP, C#.

Confidential, Malvern, PA

SQL BI Developer (SSRS/SSAS/SSRS)

Responsibilities:

• Worked with various upstream and downstream systems and customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs
• Wrote multiple stored procedures and other database objects for handling complex business logic for effective performance.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources.
• Building UAT and Test environments using Production backups.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP process for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data.
• Created SQL server Analysis Projects using MS SQL Server 2008.
• Defined relationships between Measure groups and Dimensions.
• Defined granularity with in a measure group and drill through actions.
• Querying and manipulating multidimensional cube data through MDX Scripting.
• Created report models using the report model designer to support Ad hoc reporting.
• Scheduling the SSIS packages and Jobs
• Created SSIS Packages to migrate slowly changing dimensions
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema
• Scheduled Reports based on a particular Day and sent them through Email in required format (Excel, PDF, etc.)
• Created technical designs and user documentations.
• Managed the day-to-day activities to ensure the completion of deliverables on time by providing a weekly status report on progress made.
• Creating some Score cards and Dash Board Reports using SSRS 2008.

Environment: MS SQL Server Management Studio 2008/2005, SQL Profiler, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), C#.

Confidential, Virginia Beach, VA

SQL BI Developer

Responsibilities:

• Actively involved in requirement gathering and analyzing in coordination with the business.
• Performed the scope analysis of the user requirements.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Extensively used T-SQL in constructing user profiles, relational database models, data dictionaries, and data integrity.
• Generated SSRS Enterprise reports from SQL Server Database (OLTP) and SQL Server and included various reporting features such as groups, sub-groups, adjacent-groups, group by total, group by sub-totals, grand-totals, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2005/2008) like standard parameter reports, cascading parameter reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters including single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Worked on all types of report types like tables, matrix, charts, and sub -reports.
• Created Linked reports, Ad-hoc reports based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Designed models using Framework Manager and deployed packages to the Report Net Servers.
• Implemented security to restrict the access to users and to allow them to use only certain reports.

Environment: SQL Server 2005/2008, SSIS, SQL Query Analyzer, SQL Profile, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS).

Confidential

SQL BI Developer (SSRS)

Responsibilities:

• Created various tables, views, stored procedures, Functions and Indexes.
• Migration of databases from MS SQL Server 2000 to MS SQL Server 2005.
• Created Jobs, Alerts and scheduled DTS to generated Reports
• Created SSIS package to load data to SQL Server, from Flat files or excel spreadsheet
• Implemented Extraction, Transformation and Load (ETL), Import, Export activities by DTS /SSIS package
• Created SSIS Packages for migration of data between SQL Server and other databases like MS Access, MS Excel and Flat Files.
• Created reports and performed all Administrative activities. Also Installed and maintained SQL Server Reporting Services.
• Extensively used SQL Server Reporting Services to generate various types of reports.
• Created ad-hoc reports for business users using SSRS.
• Developed Stepped and Block reports using SSRS.
• Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different retail locations.
• Generated Ad-hoc, matrix and tabular reports using SQL Server reporting services based on customer needs.
• Assigning work to team members based on their ability to handle work load.
• Checked queries and tables to update them for performance.

Environment: SQL Server 2005, Business Intelligence Development Studio (BIDS), SSRS, T-SQL, CSV, Excel.