Resume

Sign in

Sql Server Data

Location:
Marysville, Washington, United States
Posted:
January 11, 2018

Contact this candidate

Resume:

Prasanna Mobile: +1-425-***-****

SQL BI Developer/Analyst Email:ac3z5k@r.postjobfree.com

Professional summary:

Over 3 and half years of IT experience in Database Administration, Design, Development, System Administration and Support of MS SQL Server 2014, 2012, 2008, 2005 in an Enterprise environments.

Expertise in the SDLC cycle to Design, Develop, and Unit-Test and deploy the Software Applications.

Hands on Experience in installing, configuring, managing, monitoring and troubleshooting various versions of SQL Server.

Hands on experience with SQL Server and T-SQL in constructing Tables, Views, Indexes, Constraints, Triggers, User Defined Functions, Joins, Linked Servers, Stored Procedures, relational database models, data dictionaries, and data integrity.

Good knowledge in Performance tuning using SQL Profiler, Performance monitor. Hands-on working experience in Performance Tuning, analyzing query plans, usage of extended Stored Procedures, managing indexes, troubleshooting blocks and deadlocks.

Expertise in using BCP, Bulk Insert along with Format Files and Import/Export wizard for importing and exporting data into and out from SQL Server from various file types with various delimiters.

Expertise in generating reports using Crystal Reports and SQL Server Reporting Services (SSRS).

Experience in generating Drill through and Drilldown reports with Drop down menu option,sorting the data, defining subtotals in SSRS.

Experience in Creation and maintenance of databases, creating roles and managing user permissions.

Possesses excellent skills in Data Modeling using Erwin, Star and Snowflake Schemas.

Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.

Expert in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions

Experience in Data warehousing concepts, dimensional, star schema and snow flake schema methodologies.

Excellent analytical, communication, organizational and presentation skills

Experience in designing ETL’s from different sources like PostgreSQL, Redshift and salesforce systems using ODBC.

Participated in disaster recovery drills and real time disaster recovery failovers.

Developed numerous financial models, BI reports,defined built countless key metrics, KPIs, scorecards chart rich reports using complex excel functions.

Experience in Microsoft Power Bi stack -power pivot, DAX, power view, power query, power map, OLAP cubes.

Technical Skills:

Databases: SQL Server 2014/2012/2008/2005 PL/SQL, MySQL, SQL Server Integration Service (SSIS), SQL Server Analysis Service (SSAS), SQL Server Reporting Service (SSRS), Performance Tuning, Capacity Planning.

Languages: HTML, XML

Operating Systems: Windows Enterprise 2012/2008/2003/2000 server / XP

Protocol: HTTP, TCP/IP, FTP

Reporting Tools: SQL Server Reporting Services (SSRS), MS Excel and Informatica.

Revision Control Tools: Star Team server 2005/2008/2012, Microsoft TFS/Stash and Stash/JIRA.

EXPERIENCE

1. SBWC, Atlanta, GA. (March, 2017 - Current)

SQL Server Developer/ Business Intelligence Developer

Description: The State Board of Workers' Compensation assists injured workers and employers by ensuring swift and fair resolution of claims. The Board encourages employers to promote workplace safety and facilitate a safe return to work for employees.

Responsibilities:

Created different SSIS packages and designing data warehouse.

Created SSIS Packages to import and export data from Excel, Xml and Text files.

Identified various transformations in SSIS and their use at various situations in the project and prepared documents and packages.

Troubleshooting ODBC and OLEDB connection issues in SSIS packages.

Worked with various tasks such as Control Flow (Execute SQL task, for each loop container, Data Flow task, File System etc.) and transformations such as Aggregate, Sort, Lookup, Fuzzy Lookup, Merge join, multicast, conditional split, derived column etc.

Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and business logic underlying the requirement.

Built Multi-Dimensional Models (DMR) with Relational Data using Framework Manager and Deployed Packages to the Report Servers.

Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.

Developed List, cross tab, drill through, chart and complex reports which involved Multiple Prompts in Report studio.

Created custom Power BI Dashboards supporting multiple business KPIs.

Designed and developed dashboards in Microsoft power BI for providing excellent analytical functionalities to various business teams.

Environment: SQL Server 2012/2008/2005 Enterprise Edition,SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS),TSQL,C#, .Net framework, XML, MS Visual Source Safe and Windows Server 2003.

2. Virtusa, India. (November, 2015 – October, 2016)

Database Developer

Description: Virtusa Corporation is a global information technology (IT) services company providing IT Consulting, technology and outsourcing services.

Responsibilities:

Developed Stored Procedures, triggers, cursors, tables, views and SQL join Statement for the application.

Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), BULK Insert and SQL Server Integration Services (SSIS).

Maintained the database consistency with DBCC at regular intervals.

Extensively used Command prompt utilities like SQLCMD and OSQL.

Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Performed Data Partitioning in SQL Server 2012.

Worked on rebuilding the indexes at regular intervals for better performance.

Worked on Configuring Linked Servers to execute commands against OLE DB data sources on different Servers.

Designed complex packages with Error Handling and package Logging that stores the Logging results in SQL table and log files.

Monitored the Event Viewer, Event Logs and Server Error Logs for troubleshooting purposes.

Worked with senior SQL DBA to ensure that the best practices are applied and integrity of data is maintained through security, documentation, and change management.

Used data modelling tools like Microsoft Visio, and Erwin.

Environment: SQL Server 2008 Enterprise Edition, SSIS 2008, SSRS 2008,.NET Framework, C#, ASP.NET,CSS,T-SQL, VisualStudio.NET IDE, XML, MS Excel, MS Access, Visual Studio 2008.

3. CTRL, India. (May, 2014 – October, 2015)

SQL Server Developer

Defined objectives, analyzing user requirement and envisioning report features/functionalities

Developed complex queries on SQL Server by applying relational database technique such as T-SQL, DML, DDL

Used Joins and Sub-Queries to simplify complex queries involving multiple tables and Established relationships between tables using Primary Key& Foreign Key Constraints

Built new SQL Data Bases, Stored Procedures, Functions and ETL Process to support new Report Project

Converted and Loaded CSV Raw data files from Service providers into Data Warehouse using MS Data Migration System (SSIS)

Planed, developed and created reports from SQL Server databases using SQL Server Reporting Services (SSRS).

Built Multidimensional Cubes for Analyses using SSAS.

Imported SSAS Cubes and MS SQL Server data into Excel PowerPivot for Reports/Analysis.

Created analytical/Matrix Reports and Dashboards Using Tableau Desktop.

Designed and written the queries in the query builder for retrieving the data.

Created and worked with drill down reports and identified the report parameters.

Used various report items like tables, sub report and charts to develop the reports in SSRS.

Deployed and generated reports on to the server using the Reporting Services Report Manager.

Normalization and De-Normalization of tables.

Developed Backup and Restore scripts for SQL Server.

Environment: SQL Server 2008 Enterprise Edition, SSIS 2008, SSRS 2008,.NET Framework, C#, ASP.NET,CSS,T-SQL, VisualStudio.NET IDE, XML, MS Excel, MS Access, Visual Studio 2008.



Contact this candidate