Sql Server Bi Developer
Resume:
NARE ANIL KUMAR Mobile: 717-***-****
*********@*****.***
PROFESSIONAL SUMMARY
Having 10+ Years of Experience in Business Intelligence development in PowerBI, SSIS SSRS, C#, ADO.NET, LINQ and SQL Server.
Expertise in writing Stored Procedures, Triggers, Cursors and Functions using T-SQL.
Experienced in generating Reports by using PowerBI.
Used Team Foundation Server as version control
Developed and Invoked WebAPI using C# and Linq.
Migrated SQL server data to AWS cloud environment.
Expertise in developing SSIS (SQL Server Integration Services) packages for extracting data from different sources like Xml, Excel and Flat files transforming and loading the large amount of data into Sql Server database.
Conducted database backup and restore, attach and detach, recovery and disaster recovery procedures.
Expertise in developing reports using SQL Server Reporting Services (SSRS) as per the client specifications.
Involved in developing Enterprise applications for various Business Domains such as Finance/Banking, Personal and Commercial Lines of Insurance, and Sales.
Excellent written and verbal communication skills, a super work ethics and the ability to work well in a team or individual environment and also extensive mentoring experience.
Technical Skills
Languages
C#, T-SQL
Databases
SQL Server, MS-ACCESS.
Design & Development Tools
Visual Studio.Net, Sql Server Management Studio.
Web Servers
Windows Server, IIS.
ETL tools
Sql Server Integration Services in Visual studio.
Reporting Tools
Sql Server Reporting Services and PowerBI.
Operating System
Windows 10, Windows 7.
PROFESSIONAL EXPERIENCE
Client: Geovera Holdings
Role: Senior BI Developer
Location: Fairfield, CA
Duration: JAN 14-TILL DATE
Description: Geovera provides surplus lines homeowners and also offers residential earthquake products in California, Oregon and Washington. Geovera competitive advantages include highly automated underwriting platform, strong broker relationships and ability to analyze catastrophe risk. Surplus Lines Homeowners provides coverage for the residence premises owned by the named insured in the event of a partial or total loss which is caused by Wind or Water.
Responsibilities
Involved in BI Development the using SSIS and PoweBI and C#.
Developed WebAPI using C#, LINQ and Invoked in the Backend application.
Design and develop database objects like stored procedures, functions and triggers to help store and modify user input data using SQL Server 2018.
Involved in designing and documenting sing MS VISIO.
Wrote SQL queries using XPATH to retrieve and manipulate the XML data in SQL.
Used XSLT to transform XML’s from one format of XML to another formats of XML.
Developed SQL SERVER INTEGRATION SERVICES (SSIS) packages to extract data from different sources like Flat files, Excel and CSV files, transform and load the data to Sql Server.
Developed reports, dashboards using PowerBI as per the client specifications.
Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies
for various categories of users.
Rebuilding the indexes at regular intervals for better performance Involved in troubleshooting
and fine-tuning of databases.
Involved in disaster recovery plans like Backup and restore.
Used Team Foundation Server as version control.
Review the code to verify the accuracy, standards and optimizing the queries.
Facilitated effective communication through the team regarding the Project and the Status of the Project.
Environment: Visual Studio, C#, SQL Server 2018, Windows XP/7, IIS 6.0, PowerBI, Windows Server, MS VISIO.
Client: One Beacon Insurance.
Role: BI Developer
Location: Canton, MA
Duration: JAN 12-OCT 13
Description: Claims Work Station (CWS) is an enterprise web based application which is used by One Beacon Insurance agents, claim adjusters and claim supervisors to create claims for One Beacon policies as well as external vendor policies. The lifecycle of Claims Work Station includes, Create New Claim, First Report Complete, Work Assignment, Policy Verification and Financials.
Responsibilities
Invoked the WebAPI using C# and LINQ.
Design and develop database objects like stored procedures, functions and triggers to help store and modify user input data using SQL Server 2005/2008.
Involved in designing and documenting sing MS VISIO.
Involved in BI Development using PowerBI, SSRS and SSIS.
Wrote SQL queries using XPATH to retrieve and manipulate the XML data in SQL Server 2005/2008.
Used XSLT to transform XML’s from one format of XML to another formats of XML.
Developed SQL SERVER INTEGRATION SERVICES (SSIS) packages to extract data from different sources like Flat files, Excel and CSV files, transform and load the data to Sql Server.
Developed reports using SQL Server Reporting Services (SSRS) as per the client specifications.
Review the code to verify the accuracy, standards and optimizing the queries.
Facilitated effective communication through the team regarding the Project and the Status of the Project.
Environment: Visual Studio, C#, SQL Server 2018, Windows XP/7, IIS 6.0, SSRS, Windows Server, MS VISIO.
Client: Penn National Insurance.
Role: BI Analyst
Location: Harrisburg, PA
Duration: JAN 09-JAN 12
Description: PennPlus commonly referred as “Agency Portal” which is a web based enterprise application used by all the agents of Penn national insurance to create policies or provide quotes to customers interested in taking Personal and Commercial Lines of insurance. The major functionality of this agency portal is to help create quotes to look up premiums, issue quotes as policies and help to do any further endorsements and renewals for those issued policies.
Responsibilities
Involved in Analysing and developing the BI reporting using PowerBI, SSRS and SSIS.
Design and develop database objects like stored procedures, functions and triggers to help store and modify user input data using SQL Server 2005/2008.
Involved in designing and documenting sing MS VISIO.
Wrote SQL queries using XPATH to retrieve and manipulate the XML data in SQL Server 2005/2008.
Used XSLT to transform XML’s from one format of XML to another formats of XML.
Developed SQL SERVER INTEGRATION SERVICES (SSIS) packages to extract data from different sources like Flat files, Excel and CSV files, transform and load the data to Sql Server.
Developed reports using SQL Server Reporting Services (SSRS) as per the client specifications.
Review the code to verify the accuracy, standards and optimizing the queries.
Facilitated effective communication through the team regarding the Project and the Status of the Project.
Environment: Visual Studio, C#, SQL Server, Windows XP/7, SSRS, Windows Server, MS VISIO.
ACADEMIC QUALIFICATION
Bachelor’s in Electrical & Electronics Engineering from Visveswaraiah Technological University, Karnataka, India.
Contact this candidate