SUMMARY

• 8 Years of experience in IT, as MS SQL / MSBI Developer in Windows environment, current experience with SQL Server 2008/2012/2014/2016/2017/2019.
• Experience in Financial and Healthcare environments with primary skills on the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SQL Server SSIS.
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages.
• Experience in developing Custom Reports, Parameterized reports and different types of Tabular, Matrix, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
• Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience in Performance Tuning and Query Optimization.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Experience in creating reports through PROCLARITY. Used PROCLARITY for accessing and analyzing cubes and dimensions.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Expert in creating the MDX cubes and dimensions in SSAS.
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Experienced with working on ProClarity Analytics server to analyze results produced in the Dashboard.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Have knowledge in SharePoint development and scheduling reports using it.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, Profiler, Query Analyser, Export & Import (DTS), SSIS, SSRS, SSAS

RDBMS: MS SQL Server 2019/2016/2014/2012/2008 R2, MS Access, Oracle

ETL Tools: DTS(Data Transformation Services), SSIS(SQL Server Integration Services), Data Stage, Bulk Copy Program (BCP), Import Export Data

Languages: SQL, T-SQL (Transact SQL), PL/SQL, C, C++, Java, C#, Visual Basic 6.0, VB.Net, WCF, HTML, CSS.

Web Technologies: .Net, ASP.NET, Ado.Net

Operating Systems: Windows 95/98,Windows 2000/NT/XP, Windows 7, Windows Vista

Reporting Tools: Report Builder 3.0, Crystal Reports 11,10,9, SSRS

Other tools: Microsoft Visual Studio 2005, Crystal Reports, ProClarity ODBC, Teradata, and MS Office

PROFESSIONAL EXPERIENCE

Confidential, CO

SQL BI Developer

Responsibilities:

• Worked with business system Analyst, Operational risk manager to understand the requirement clearly and to create reports.
• Involved in report development, testing and deployment.
• Created several Excel and report builder reports for mobile services Enrollment and Claims projects.
• Created ad hoc reports, chart reports, tabular and matrix and parameterized reports using Report Builder 3.0.
• Used BIDS to create parameterized reports.
• Used Microsoft SharePoint Designer to upload, download, manage data source, create web parts, web pages, folders, schedule reports daily, monthly, created report web parts to display them in .aspx format.
• Used SharePoint to schedule reports and send by email daily, monthly in different formats such as PDF, Excel, and CSV.
• Browsed the cube for analysis and validation of the data.
• Created several Excel reports using cube data.
• Used MDX to create enrollment and claims timestamp report.
• Worked on T-SQL programming, stored procedures and views in the process of developing reports.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements.
• Developed reports in SSRS and deployed reports into SharePoint Server 2010.
• Involved in regression testing, and optimization of the query.

Environment: MS SQL Server Management Studio 2019/2017, Microsoft Visual Studio 2017, Report Builder (SSRS), Business Intelligence Studio (SSAS, SSRS), SharePoint 2010, T SQL, MDX, MS Excel.

Confidential (Remote)

SQL BI Developer

Responsibilities:

• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Created cubes and dimensions and measures and calculated measures according to the business requirements.
• Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables.
• Browsing the cube for analysis and validation of the data.
• Configured SQL Server Reporting Services in SharePoint Server mode as well as Native mode.
• Processing the cubes and dimensions on a daily basis using the SSIS tasks.
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS.
• Created several SSIS packages for performing ETL operations to transform data from OLTP to OLAP systems.
• Developed ASP.NET user controls and C# classes for code reusability in the list, detail and editviews.
• Responsible for designing and implementing system modules using C#.NET and Visual Studio 2005.
• Share and document the developed components.
• Developed business layer components in C#.NET.
• Created Webpages for various work streams using C#.NET, ASP.NET and business logic layerwhich connects to the other services using C#.NET..
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created several Dashboards and Scorecards with Key Performance Indicators (KPIs) inSQL Server Analysis Services (SSAS) using ProClarity and published via WindowsShare Point Services.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Performing the tasks of data conversions, adding derived columns, sending results in mails is done by making use of various tasks in SSIS.
• Deployed SSIS packages and Reports to Production Servers.
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
• Configured SSRS with MOSS for directly deploying the report in SharePoint.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Created SSIS Packages from various data sources.
• For the data warehouse Analysis services and develops the different reports for the analysis.
• Used ProClarity for analysis services in some cases.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
• Involved in working with MS Excel Pivot Tables.
• Developed reports in SSRS and deployed reports into SharePoint Server (MOSS).
• Responsible for developing graphically rich dashboard reports on the Microsoft SQL Server 2008 R2 platform in a way that users can access, based on role or business function within the organization and user skill sets.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS 2008 R2
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Involve in Agile Methodologies to produce high quality results
• Created Report Models for Ad Hoc reports on different perspective.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Build database queries and test cases for the testing team to test the reports.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Environment: SQL Server 2017/2019 R2, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2013, T SQL, Erwin, MDX, C#, Oracle 10g, ProClarity, Flex, Teradata, Unix, MS Excel.

Confidential

MS SQL BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2014 and Flat files.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS)
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
• Developed classes and interfaces for the Data Access layer using C#.NET, ASP.NET.
• Involved in and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2005/2008 Analysis Services Business Intelligence (SSAS, SSRS)
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Developed reports from OLAP cubes using ProClarity and SSRS.
• Configured the loading of data into Slowly Changing Dimensions using slowly Changing Dimension wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.
• Experience in developing reports using SSRS.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS).
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS).
• Developed a High level dashboard using SSRS.
• Experienced in Designing stylish report layout.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-hoc reports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Developed business layer components in C#.NET.
• Involved in designing Web based ASP.NET applications.
• Implemented and extensively used the Object Oriented programming concepts in C# and ASP.Net 3.5
• Coordinated with front-end for implementing logic in Stored Procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: MS SQL Server 2014/2008 R2, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), MDX, C#, .Net framework, ProClarity, Performance Point Services, Flex, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.ssis