SUMMARY:

• 7+ Years of experience in IT with primary skills on the Analysis, Design, Development and Support of Client/Server application using Microsoft SQL Server 2012, 2008, 2005, 2000 and BI suite.
• Extensive experience in developing Business Intelligence Solutions in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
• Expertise in SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report Security.
• Experienced in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions using SQL Server Integration Service (SSIS).
• Experienced in migrating DTS packages to Integration Services.
• Experienced in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• In - depth knowledge of Transact-SQL (DDL, DML, DCL), Design and normalization of the database tables and Relational Database Management Systems.
• Proficient knowledge of writing, modifying and implementing Tables, Stored Procedures, Functions, Views, Indexes, Triggers, Cursors, Joins & User Defined data types.
• Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Drill-Up, Drill-through, Top N, Summary, Form, Lists, Sub reports, Matrix Reports and formatting them.
• Experienced in integrating the SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager.
• Experienced in migration of Data from Excel, Flat file, Oracle to MS SQL Server using MS SQL Server DTS and SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Experienced in Cube designing to create shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Experienced in building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2005/2008 Analysis Services Business Intelligence (SSAS, SSRS)
• Experienced in Logical Data Modeling, ER Modeling, Data warehouse design concepts, Dimensional Modeling using Star/ Snowflake Schemas, Normalized and De-normalized Schemas with respect to query and analysis requirements.
• Experienced with working on Power BI and related reporting tools to produce variety of Dashboards.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Excellent Communication and interpersonal skills with strong ability and experience in seeking solutions effectively in challenging environments.

TECHNICAL SKILLS:

Operating Systems: Windows 98/ 2000/ XP/ Vista/7/8, MS-DOS, Windows 2003/2008/2012 Server.

Programming Languages: C, T-SQL, PL/SQL.

RDBMS: Microsoft SQL Server /, Oracle 9i/10g, MS Access.

SQL Server Tools: SQL Service Analysis Services (SSAS), Integration Services (SSIS), Reporting Services (SSRS), SQL Profiler, Query Analyzer, Export & Import

IDE: Microsoft Visual Studio 2013/2012/ 2008/ 2005.

Web Technologies: HTML, XML, JavaScript, PHP.

Other Tools: Crystal Reports, ERWIN, MS Access, MS TFS, MS Excel, MS Visio, MS Office Suite

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server BI Developer/Analyst (SSRS, SSIS)

Responsibilities:

• Created tables, temporary tables, table variables, indexes, procedures, views and triggers for automating various tasks in TSQL.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard and SQL Sentry plan explorer.
• Involved in database design of the project and integration with third party tools like Power Designer 15.
• Worked on internal project to develop a performance Data warehouse.
• Created SSIS Packages to generate flat file report for different customers based on the User requirement.
• Created SSIS Packages to load data to the Staging DB and from Staging DB to the Destination DB with necessary transformations to the data by using different tasks.
• Designed and worked with cubes having star schema using SQL Server Analysis Services (SSAS).
• Developed Dimensions, Data source views, SSAS Cubes, deployed and processed SSAS objects, created SSAS storage and partitions and aggregations.
• Applied various data transformations like Slowly Changing Dimension (SCD), aggregate, sort, multicasting, conditional split, derived column etc.
• Designed and deployed various complex reports using MS Reporting Services.
• Prepared Documents of each process involved
• Developed complex stored procedures using T-SQL to generate reports using SSRS 2008/2012.
• Created Tabular reports, Cross Tab Reports, Matrix, Sub Reports and Parameterized reports.
• Analyzed reports and fixed bugs in stored procedures.
• Designed and implemented stored procedures and triggers for automating tasks.
• Fine-tuned SQL queries for maximum efficiency and performance.
• Configured the report viewing security for various users at various levels using Report Manager.
• Used SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.

Environment: Microsoft SQL Server 2012, SQL Server Reporting Services 2012 (SSRS), SQL Server Integration Services 2012 (SSIS), SQL Server Analysis Services 2012 (SSAS), Microsoft Excel 2010, SharePoint 2010, Power Pivot, Team Foundation Server (TFS), Red Gate Source Control, Windows 2008.

Confidential

SQL Server BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Designed/Developed complete ETL packages/suite (SSIS Master and Child) for Initial and Incremental loads for Data Warehouse.
• Created SSIS packages to load/update staging and dimensional databases as well as rebuilding the cube dimensions and Measure Groups/Partitions in RDB Cube (SSAS).
• Designed SSIS packages for synchronizing data between different servers.
• Created various Tabular and Matrix Reports using SSRS 2008.
• Created\Maintained dimensional models while adhering to enforced development standards.
• Created Drill through Reports to show the status transitions of AEGON Clients.
• Involved in tuning long running reports and handling tickets assigned out of production.
• Optimized SCD task by implementing the same in T SQL using SQL Server Intersect, Except and Merge operators.
• Created parameterized reports enabling report to use same the Stored Procedure\SQL thus making reports to return different results faster with minimal recompiles.
• Extensively worked with Aggregation Design for many partitions via Aggregation Design Wizard, Usage Based Optimization and Manual Addition.
• Involved in the post deployment maintenance of canned reports and cubes.

Environment: SQL Server 2008, SSIS 2008, Performance Point Server, T-SQL, Excel, Microsoft SQL Reporting Services 2008 (SSRS), OLAP, OLTP, SSAS, SharePoint Server.

Confidential

SQL Server BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Designed and Developed Database Objects Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Developed tested and implemented Referential Integrity rules and regulations through constraints, triggers, views and partitioned views.
• Regular responsibilities for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services(SSAS)
• Created SQL Server Analysis Project using MS SSAS 2005
• Created Views for specific columns on a table to maintain privacy of a customer data.
• Created Indexes to get the high level performance.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Designed SSIS packages for synchronizing the data between two different servers.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Involved in reverse and forward loading of the schema of a database using Erwin.
• Responsible for gathering Business Requirements and System Specification from users.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS 2008.
• Created Ad-hoc reports and cascading reports for historical data using SSRS 2008.
• Experience in the design, development and maintenance of different cubes using SSAS 2008.
• Involved in the post deployment maintenance of canned reports and cubes.
• Utilized Analysis Services (SSAS) to design multi-dimensional models, including the construction of Data View, Fact and Dimension tables, and OLAP Cubes while adhering to enforced development methodologies.
• Experience in designing the reports in ProClarity for SSAS cubes.
• Gathered requirement from users and developed year to date reports in ProClarity.
• Involved in the implementation of Performance Point Server (PPS).
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs through AutoSys.

Environment: SQL Server 2008, Query Analyzer, SSIS 2008, Performance Point Server, .NET, C#, T-SQL, Excel, Microsoft SQL Reporting Services 2008 (SSRS), OLAP, OLTP, ProClarity, SSAS, SharePoint Server, Erwin.

Confidential

SQL Server SSIS/ SSRS/ SSAS Developer

Responsibilities:

• Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions.
• Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Created Indexes to get the high level performance.
• Performing the ETL operations to support the data loads and transformations using SSIS.
• Involved in migration from Oracle to SQL Server 2005 using SSMA and SSIS.
• Developed Cubes using SQL Analysis Services (SSAS).
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Designing OLAP cubes, Data Modeling, Dashboard Reports according to the business requirement.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS).
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Implemented automated backup and database maintenance / cleanup jobs.
• Managing Logins, Users, Roles and User permissions.
• Running Trace from the Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.

Environment: SQL Server 2005/2008, Query Analyzer, SSIS 2005, T-SQL, Excel, Microsoft SQL Reporting Services 2008 (SSRS), SQL Analysis Services(SSAS), OLAP, Windows 2000/XP, Oracle 7.0.

Confidential, GA

SQL BI Developer

Responsibilities:

• Created permanent tables, temporary tables, table variables, indexes, procedures, views and triggers for automating tasks in TSQL.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Installed MS SQL server 2005 and MS SQL server 2008 on Windows 2003/2008 servers, applied Service packs and Security fixes. Implementing database standards and naming convention for the database objects.
• Expert in cleansing data for data consistency whether the data source is a single system or multiple disparate sources.
• Used SSIS Packages for extracting, cleaning, transforming and loading data into data warehouse.
• Experience in development of Extracting, Transforming and Loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts.
• Involved in writing complex SSIS Packages to Load Data into both OLTP and OLAP systems.
• Extensively used various control flow tasks like FTP, Bulk insert task, Transfer job task etc. and different data flow tasks like merge join, look up, data conversion etc.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Involved in deploying SSIS packages to QA/Pre-production environments.
• Interacted with business/end users to gather requirements.
• Designed and deployed various complex reports using MS SQL Server Reporting Services.
• Prepared Documents of each process involved.
• Created various types of Reports based on the complex T-SQL queries from the scratch like matrix report, charts, parametric report and tabular reports with different Calculations, formatting options and grouping options.
• Analyzed and tuned stored procedures in reports.
• Tier 3 Production Support for Application and Data warehouse issues.
• Designed & developed ETL procedures, Data dictionaries, data mappings involving data analysis, data validations and data migrations.
• Developed Complex Packages to load data into Staging, ODS and Data Warehouse systems.
• Automating SSIS Packages using SQL Server Agent Jobs, Window Scheduler.
• Created Reports, Sub Reports, Linked Reports, Charts, Drill through Report Models and Drill down Reports.
• CreatedETL packages with different data sources(SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations usingSSIS/DTS packages.
• Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters.
• Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks.
• Used differentControl Flow Tasks and Data flow Taskfor Creating SSIS Packages. Used different types ofTransformationsfor Data Conversion, Sorting and data cleansing from different Sources into Company Formats.
• Provided 24x7 on-call Support for critical production Databases.

Environment: Microsoft SQL Server 2008, Integration Services 2008, Reporting Services 2008 (SSRS), T-SQL, Microsoft Excel, Windows Server 2003

Confidential

SQL Server Developer (SSIS/SSRS)

Responsibilities:

• Create joins and sub-queries for complex queries involving multiple tables.
• Generated dynamic stored procedures, triggers for the database development.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using BCP utility, SSIS services.
• Involved in Report writing according to business requirment using SSRS and Crystal Reports.
• Generated database monitering and data validation reports in SQL Server Reporting Service (SSRS).
• Using SSRS, creating well-formed reports and web-based reports for financial applications and transactions.
• Worked on .Net data access layer and ADO.Net and developed various clauses to connect to database with the front end pages.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Configure the report server and generated the report models for user interactions.
• Configuration of Snapshot and Transactional Replication.
• Experience in creating SSIS packages using different type’s task and with Error Handling.
• Fine-tuned the complex database stored procedures and increase performance up to 5%.
• Taking weekly database backup and schedules job using SQL Agent.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.

Environment: MS SQL Server 2005/2008, Management Studio, ETL, DTS, Notification Services, Crystal Reports, T-SQL, SQL Profiler, IIS 6.0, Windows 2003 Advanced Server, SSIS, SSRS, community server, Erwin.

Confidential

 SQL Server Developer

Responsibilities:

• Requirement gathering - Solution design
• Involved in the migration.
• Actively involved in Normalization of database.
• Designed DDL and DML for MS SQL Server 2005.
• Created rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimized query performance by creating indexes.
• Involved in writing SQL batch scripts.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL
• Queries and Stored Procedures.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Perform daily database backup & restoration and monitor the performance of Database Server.
• Created complex joins and sub-queries for complex queries involving multiple tables.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Installed and Configured SQL Server 2005 on development server for designing and testing.

Environment: MS SQL Server 2005, T-SQL, DTS, SQL Server Enterprise Manager, SQL Profiler.