PROFESSIONAL SUMMARY:

• Over 8 years of IT experience in Designing, Developing and Implementation of Integration, Analysis and Reporting projects using SQL Server, SSIS,SSAS,SSRS.
• Over 3 years of good working experience in database using Structured Query Language and T - SQL.
• Strong Analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.
• Involved in all phases of Software Development Life Cycle from Requirements gathering to Implementation.
• Expertise in using Microsoft BI suite: SQL Server Integration Services (SSIS), SQL Server Analysis Service (SSAS), SQL Server Reporting service (SSRS) .
• Good knowledge on Relational Database Management System (RDBMS), OLTP and OLAP concepts, Data Migration and Data Analysis.
• Hands-on Extracting Data from sources like Text Files, CSV, Excel and MS Access to SQL server using SQL Server Integration Services (SSIS).
• Experienced in using SQL Server Data Tools.
• Expert in creating Stored Procedures, Functions, Tables, Views, Scripts, Indexes, Triggers, SQL Jobs and Transaction Analysis.
• Knowledge in working with SSAS in creating Data cubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Designed and developed ETL packages (SSIS) with variables, parameters, and expressions and scheduling SSIS   packages in SQL agent to load data to  data warehouse or OLTP database using error handling, logging and deploying methodologies.
• Experience in checking data quality using SQL/Integration Services, identifying errors and error patterns, and suggesting some data cleansing mechanisms.
• Knowledge on working with large and or complex data sets for business operations.
• Expert in using different methodologies on unstructured Data like ROLAP, MOLAP.
• Experience in Dimensional Data Modeling Star and Snow Flake Schemas.
• Good knowledge on SSRS architecture and Hands on experience in developing deploying and managing Parameterized reports and Linked reports, Sub reports, drilldown reports, drill through reports, ad-hoc reports and Crystal Reports with thorough knowledge of report service architecture. (Table, chart and matrix report) using SSRS.
• Strong Knowledge in using Reporting service to deliver output according to client requirements, Dashboards, scorecards, Graphical Reports.
• Experience in creation of Tabular model in SSAS for creating Power pivots, Power View reports.

TECHNICAL SKILLS:

BI Tools: SQL Server Management Studio, SQL Server Reporting Services (SSRS),SQL Server Integration Service(SSIS), SQL Server Analytical Services (SSAS), Business Intelligent Development Studio, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, SQL Server Agent.

Databases: SQL Server 2008/2008R2/2012,2014,2016

Designing Tools: Erwin, Visio

Reporting Tools: Excel, SQL Server Reporting Services, SAS, Crystal Reports.

Languages: C, Java, SQL, T-SQL, PL/SQL, C#, SAS

Web Technologies: HTML, XML, CSS, Visual Studio.

Operating Systems: Windows XP/7/8/10, Linux, Unix.

Software: Virtual Box, Putty, MS Office MS Excel, MS-Project

IDE: Eclipse

PROFESSIONAL EXPERIENCE:

Confidential, Foster city, CA

SQL Server Programmer/SSIS, SSAS, SSRS

Responsibilities:

• Work with users, product management and business analysts to understand client requirements and help reach data deliverables.
• Design, develop and deploy Business Intelligence solutions using SSIS, SSAS and SSRS.
• Responsible for extraction and loading data from source to SQL environment for performing various business operations using SSIS.
• Create databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Created SSIS package to pull data from different sources consolidate and merge into one single source.
• Work on data issues, performance and production problems to find root cause to maintain data and databases correctly.
• Work with various tasks such as Control Flow (Execute SQL task, For each loop container, Data Flow task, File System etc) and Transformations such as Slowly Changing Dimensions, Aggregate, Sort, Lookup, Fuzzy Lookup, Merge join, Multicast, Conditional Split, Derived Column, Union All etc.
• Create data cubes from unstructured data using different kinds of methodologies ROLAP, MOLAP, HOLAP.
• Provide transformed data to data analysts as required for reporting and business decision process.
• Making use of Joins, Procedures, cursors, triggers and extracting data from different tables for Reporting.
• Configured and maintained Report Manager and Report Server for SSRS.
• Used Merge in development, test and production for changing the referenced data.
• Develop and support OLAP, star schemas, cubes, and conduct data mining and analysis.
• Create Calculated Measures and Dimension Members using MDX, Mathematical formulas and User Defined Functions.
• Use data compression techniques to Back Up data in different servers.
• Generate reports from the cubes by connecting to Analysis server from SSRS.
• Design and create Report templates, bar graphs and pie charts based on client data. 
• Create and deploy reports to Report Manager and Troubleshooting for any error occur in execution. 
• P erformed T-SQL tuning, optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard & SQL Query.
• Develop complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS). 
• Data validation to check if requirements are captured for creation of reports and required data is displayed in the reports.
• Converted crystal reports to SQL Server reports using Reporting Services.
• Generate daily, weekly, Monthly reports based on the business requirements of client.
• Develop complex Stored Procedures and views to generate various Drill-through, Drill Down reports, parameterized reports and linked reports using SSRS.

Environment: SQL Server 2014/2012/2008 , DTS, SSIS, SSRS, Microsoft Analysis Services 2012/2014, T-SQL, MS Access.

Confidential, Bothell, WA

SQL Server/SSRS Developer

Responsibilities

• Worked extensively on installation, upgrade and configuration of MS SQL Server 2008/2012 databases servers .
• Worked with business/functional analysts to determine reports and analytical requirements. 
• Planning, coordinating and implementing security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
• Documented Report Models and Report Templates for other Team Members. 
• Involve with BI Support Team and QA Team in the development, testing and support of BI Solutions.
• Design and develop SSIS packages, configuration files, stored procedures, tables, views and functions.
• Working with SSIS for creating ETL jobs in migration of data from one database to other.
• Create Prototypes of some complex reports and validated from the production.
• Categorized reports into batch reports and on demand reports and scheduled it according to that. 
• Develop complex queries, stored procedures, views, and constraints, triggers using inner and outer joins, unions, and SQL Statements for various applications in different environments. 
• Design new reports considering accuracy, performance, maintainability, and clarity of presentation.
• Switch from task to another based on higher-priority and work with required teams and complete the task immediately based on business requirement.
• Using SSRS to creat e reports with Drop Down menus and multi-select variables as parameters which are passed to store d procedure to populate the report accordingly.
• Create graphical outputs using SSRS according to the requirement.
• Exporting output file from one environment to another environment.
• Creating Dashboards, Scorecards, pie charts and bar graphs.

Confidential, Boston, MA

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Participated in Project development life cycle SDLC.
• Working closely with clients and gathering requirements.
• Migration of Data from other environments into SQL environments using SSIS Packages.
• Using Data flow and Control flow methodologies for data modifications.
• Using SSIS Packages for day to day tasks like Sorting, Aggregative functions.
• Create Tables and Views on available data
• Writing T-SQL Queries, creating Stored Procedures, Triggers, Sub-Query’s.
• Create Data Cubes using SSAS and running reports from cubes using SSRS.
• Develop dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Generate reports on all types like tables, matrix, charts, sub reports etc.
• Export reports from SQL Environment to other destinations.
• Involved in Debugging and Deploying reports on the production and UAT servers by modifying the RDL files using XML.
• Developed complex Stored Procedures and Views to generate various reports using Excel Macro’s and SSRS.
• Making use of SSRS service deriving Drill-Down, Drill-through reports.
• Responsible for Scheduling reports to run daily, weekly and monthly basis using Report Manager.
• Responsible for implementing Unit testing and performance improvement purposes.
• Using C#, VB, .NET in the process of reporting.

Environment: MS-SQL Server 2008R2 Enterprise Manager, MS Business intelligence SSIS, SSRS,SSAS, SharePoint Server 2010, XML, MS Excel, VB.Net, C#.Net, Visual Studio 2010.

Confidential

SQL Server Developer, SAS Programmer

Responsibilities:

• Involve in Planning, Defining and Designing data based on business requirements and provided documentation.
• Creating Entity relationship (ER) diagrams for the proposed database.
• Creating Tables, views, Indexes, triggers etc for proposed system.
• Extensively used transformations, control flow tasks, data flow tasks, containers and event handlers.
• Defining Normalization forms and implementing them while table creation.
• Using SSIS packages for integration of data from different source to SQL Server environment.
• Generated reports for internal company purpose for Managers and team.
• Using SAS for Reporting purpose.
• SAS procedures are used for reporting, SAS Macro’s, SAS Graphs, SAS Stats