Summary:

• 6 years of experience in IT industry as a SQL/BI Developer.
• Proficient in SSIS, SSRS and SSAS of 2008R2/2012, especially in Data Migration and Reporting.
• Extracted and transformed data using SSIS Packages, DTS Import/Export Wizard, Bulk Insert, and BCP.
• Designed, developed, implemented and tested ETL processes in SSIS.
• Familiar with SQL Server Agent in Support Services.
• Generated reports in SSRS, such as Drill Down Reports, Drillthrough Reports, and Subreports.
• Called SQL Server Stored Procedures and Oracle Packages and Stored Procedures in SSRS, and passed Parameters to procedures.
• Integrated SharePoint with SSRS for reporting.
• Developed and Extended SSAS Cubes, Dimensions, Data Source Views, Data Mining Models and Deployed and Processed SSAS Objects.
• Created SSAS projects using MDX.
• Experienced in Relational, Multi-Dimensional Data Modeling and involved in creation of Star Schema and Snowflake Schema using MS-Visio in OLTP and OLAP.
• Expert in using tools such as Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for monitoring and tuning SQL Server performance.
• Well-versed with database Installation and Configuration. Developed and Debugged complex Stored Procedures, Indexed Views and Triggers for data consistency and manipulation.
• Operated Data Warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Worked closely with architect and team in designing, developing and implementing logical and physical model for Data Marts.
• Developed Web Applications using ASP.NET, and wrote source codes in VB.NET and C .
• Designed page layout by using HTML, CSS, and JavaScript.
• Expert in MS Office Software and very strong skills in Excel/VBA and PowerPoint.
• Extremely self-motivated, diligent, conceptually strong team player with ability to learn new technology quickly.

Technical Skills:

Professional Experience:

Confidential

Role: BI Developer/.NET Developer

Responsibility:

• Used Team Foundation Server TFS based Work Item assignment process from within Visual Studio 2012.
• Developed screens/web applications in VB.NET and C .
• Applied Unit Tests to test units of source code, sets of one or more modules together with associated control data.
• Generated master page in ASP.NET to control the layout of the application screens.
• Created a base class including all the common operations such as Session Management, Query String Management, Authentication, Authorization, and Message Collection required to be reused on every page.
• Declared Session Variables as constants to capture user inputs through web applications.
• Used Session ID in every page in the application to navigate with/without page specific query string.
• Provided a consistent structure and behavior to the entire web application by using a namespace which is comprised of custom ASP.NET server controls that can be used for various purposes in the presentation layer of the application.
• Involved in Exception Handling and Validation processes.
• Developed reports using SSRS in SQL Server 2008R2 by connecting to an Oracle database.
• Worked with Oracle SQL Developer and wrote PL/SQL to retrieve information from database.
• Compiled Oracle packages and stored procedures based on business requirements.
• Passed parameters to Oracle stored procedures through SSRS.
• Designed reports layout, set parameters, variables, expressions, and used built-in fields and custom fields.
• Added Subreports to the original reports and also created Drill Down Reports and Drillthrough Reports.
• Exported reports to PDF and Excel files, automatically.

Environment:

Visual Studio 2012, TFS, ASP.NET 4.5, VB.NET, C , SQL Server 2008R2, SSRS, Oracle SQL Developer 3.0, PL/SQL

Confidential

Role: SQL/BI Developer

Responsibility:

• Involved in the information gathering and developed the Multi-Dimensional Data model based on the requirements and built the Data Marts based on the BI requirements.

• Worked on OLAP database designs for data mart to leverage fact and dimensional design and used ETL to populate the data.
• Extensively involved in the cube designing using SSAS and involved in the cube optimizations, named set calculated measures, aggregations and partitions.
• Extensively worked with MDX to define the time dimension to support the various calculations and used several MDX functions to implement the business requirement.
• Involved in the Processing, deployment of cubes/SSIS Package in test and productions environment.
• Extensively worked with performance point services to provide the best possible KPIs, Analytical Grid, Line chart and Scorecard to build the best possible Dashboard for the end client.
• Generated various reports Pie and Grid, Decomposition Tree and other reports to embed them into Dashboards, used sets and measure for dashboards.
• Defined various KPIs dynamically, analytical reports and Scorecard using MDX functions and reports built on SSRS to use into Dashboards.
• Responsible for creating Performance point scorecard templates based on the business users requirements.
• Extensively worked to build the dashboard by using Filters.
• Developed and built the reports using SSRS with MDX From cubes and from relational data sources Tables/Views .
• Used different data sources like SQL Server and Oracle data sources.

Environment:

MS SQL Server 2012, SSIS, SSAS, SSRS, T-SQL, Report Builder, MS Visual Studio 2010, SharePoint 2010

Confidential

Role: SQL/BI Developer

Responsibilities:

• Created views and stored procedures and optimized them as required by front-end developers for easier implementation on web pages.
• Troubleshooting DB performance issue and implementing necessary Database changes.
• Applied Business Intelligence to perform Extensive Data Scrubbing for new records with exception report generation to maintain data quality and consistency.
• Developed SSIS packages to refresh Master Policy Data on a daily basis from an Excel Workbook.
• Migrated new policy information published by agencies onto an FTP site in Access file format using SSIS jobs on a nightly basis.
• Migrating the data gathered from third party vendor in XML format and parse it.
• Experience in data extraction, transforming and loading ETL using SSIS, Bulk Insert, and BCP.
• Created logical and physical data model using Erwin.
• Implemented batch processing using Stored Procedures and Jobs.
• Optimized the performance of queries with modification in indexing strategy.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Configured server for sending automatic mails on failure and success of the scheduled jobs.
• Generating management reports using SQL reporting service.

Environment:

MS SQL Server 2008R2, SSIS, SSRS, T-SQL, MS Visual Studio 2008, MS Office 2010, SQL Profiler, Performance Monitor, SQL Server Index Tuning Wizard

Confidential

Role: SQL/BI Developer

Responsibilities:

• ETL development using SSIS for migration of data from sources to SQL Server 2008R2.
• Participated in developing logical model on SQL Server
• Implemented SSIS packages using different tasks such as Execute SQL task, Bulk insert, Execute Package Task, Data Flow Tasks such as OLE DB, Excel source, destination tasks and Transformation Tasks such as Conditional Split, Union ALL, Derived column, Look Up, Fuzzy Look up, Merge and Merge Join tasks etc.
• Configured SSIS packages to make changes at run time.
• Involved in performance tuning and debugging of packages.
• Imported packages in to SSMS to schedule jobs for packages to run daily.
• Identified and defined the Datasets for the report generation using SSRS.
• Defined the report layout and wrote the queries for the drill down reports using SSRS.
• Identified, added the report parameters and created dynamic reports based on the requirements using SSRS.
• Formatted reports for various output formats as requested by the management using SSRS.

Environment:

MS SQL Server 2008R2, SSIS, SSRS, MS Access, MS Excel