SUMMARY:

• 6+ years of experience in designing, developing backend application using MSSQL server 2008/2012/2014
• 6+ years of experience in writing complex SQL queries including stored procedure, views, triggers, SQL jobs, User defined data types, functions, Indexes .
• Extensive experience in import, transform and load data between databases and external data sources using SSIS package, Import Export Wizard, and Bulk Insert.
• Excellent in high level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert , Merge and union all.
• 6+ years of Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports.
• 6+ years of experience working with OLTP and OLAP databases.
• Experience in Product deployment and shipment.
• Experience in testing SSRS/SSIS/SSAS and complex Queries.
• 2+ years of writing C# automation
• Experience in white - box, black-box, stress, regression, back end testing, UI automation testing.
• In-depth knowledge of data Structures and algorithms, Object Oriented Analysis and Design.
• Experience in Performance Tuning and Query Optimization.
• Excellent analytical, diagnostic and problem solving skills.

TECHNICAL SKILLS:

Languages: SQL and C#

Platforms: Windows, Window Server

Databases: MS - SQL Server 2005/2008/2012

Tools: SSRS, SSIS,SSAS,SQL profiler Visual Studio, UI Spy, TFS server

Source Control: TFS, Git

PROFESSIONAL EXPERIENCE:

Confidential

BI Developer

Responsibilities:

• Created Azure data factory pipelines in Azure portal to transfer data.
• Wrote HIVE query to get data from HIVE to sql Azure.
• Wrote a powershell deployment script to deploy to different databases and to deploy pipelines to Azure portal.
• Wrote stored procedures, views .
• Wrote UAT test scripts .
• Load data Using SSIS to Data warehouse and investigates and fixed failures that occurs in the SSIS packages on day today basis.

Environment: SQL Server 2012/2016, Azure Portal, Jason, Powershell, T-SQL, SQL Server Reporting Services, SQL Profiler, Visual Studio 2013/2015, putty, Ambari, HDinsight Cluster.

Confidential

SSRS Developer

Responsibilities:

• Optimized the sql query to boost the performance of existing SSRS report.
• Created new SSRS report
• Analyze old SSRS reports and compare to new reports to determine whether they have the sources that they need. Then work with the data warehouse team to get the sources in place.
• Building out additional SSRS reports as needed

Environment: SQL Server 2008, Windows 7/8, Confidential office 2007/2013, T-SQL, SQL Server Reporting Services, SQL Profiler, Visual Studio 2008/2012.

Confidential

BI Developer (SSRS/SSIS/SSAS)

Responsibilities:

• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, in to the data warehouse
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Analyzed the existing tool and participated with the business users to gather the requirements and design goals of data warehouse.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Developed Multi - dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Defined appropriate measure groups and KPIs & deployed cubes.
• Created Parameterized reports, drill down reports & Summary reports Using SSRS.
• Created report snapshots to improve the performance of SSRS.
• Troubleshoot report, ETL, and cubes on a daily bases.
• Modify MDX Queries of the reports based on Customer request.
• Created T-SQL Functions, views, indexes, stored procedures.
• Imported power Pivot data to SSAS Tabular.
• Deployed Analysis services database in multi-dimensional mode or tabular mode or power pivot
• Used Power BI Desk top to do data modeling and different visualization.

Environment: SQL Server 2008, Windows 7/8, Confidential office 2007/2013, T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, Visual Studio 2008/2012.

Confidential

Software Design Engineer 2

Responsibilities:

• Design and develop dynamic reports using SSRS 2008 created a very complex Stored Procedures and Functions for drilldown/ parameterized reports using SQL Server 2008
• Created Drill - through, Drill-down, Linked Reports and Sub-Report using RDL.
• Created parameterized reports passing parameter through report screen.
• Utilize SQL Profiler to troubleshoot issues with SSRS
• Formatted the reports using the expressions and Functions.
• Did schema comparison to post the stored procedure used for the report on production.
• Worked on improving the performance of the existing SSRS report
• Fixing reported bugs.
• Migrated a report from Excel to Reporting Services (SSRS)
• Design, Develop, Deploy complex and interactive reports using SQL Server Reporting Services (SSRS).

Confidential

SDET

Responsibilities:

• Perform manual and automated test of the backend application.
• Perform effective exploratory/ad hoc testing on assigned areas of software.
• Detect, research, and document software defects in a bug tracking system and close the bugs.
• Review product documentation, and report any errors

Confidential

Responsibilities:

• Designed and developed dynamic reports using SSRS 2008
• Created many complex Stored Procedures / Functions and used them in Matrix Reports/tabular Report using SSRS.
• Created stored procedures for the Main report, Drill down report as well as for the parameters.
• Created parameterized reports.
• Utilized SQL Profiler to troubleshoot issues with SSRS Queries.
• Created SSRS alternate views
• Used schema comparison to update schema
• Created different views and stored procedures to test the counts on the report.
• Actively participated and interacted with customers, team lead, DBAs, technical manager for requirement gathering, design, implementation and testing phases for all the projects.
• Supported customers by quickly implementing late change requests and fix defects
• Wrote C# code for automation.

Environment: C#, SQL Server 20008R2, SQL Server Reporting Services (SSRS), SQL Profiler, Team Foundation Server (TFS) 2008, SQL Server Analysis Services 2008R2 (SSAS), BIDS, SSMS, MS Excel, MS Outlook.

Confidential

Responsibilities:

• Wrote SQL Queries and stored procedure for validation and updating of data.
• Created SSIS packages to migrate data from different data sources like flat file destination, OLE DB destination, Excel destination...etc.
• Created SSIS Packages using Condition Split, Merge joins, Multicast, Execute SQL Task, Data Flow Task to generate underlying data for the reports
• Wrote a comparison Query for validating the data before import and after import in SSIS package using SQL server 2008.

Environment: SQL Server 20008R2, Team Foundation Server (TFS) 2008, SQL Server Analysis Services 2008R2 (SSAS), BIDS, SSMS, MS Excel, MS Outlook.

Confidential

Responsibilities:

• Wrote test cases and file bugs
• Executed both manual test and Automation test.
• Wrote C# to automate for WPF application.
• Executed functional, integration, Performance, and smoke test
• Design and execute functional and black box test plan and test procedure
• Create test data using XML
• Created the test automation framework
• Reported QA team status to executives
• Wrote test plans and test cases
• Set up and maintained usability and browser compatibility testing
• Performed stress, Performance, Boundary, regression, load and globalization test.