Rakesh Dareddy 816-***-**** adhxbi@r.postjobfree.com

Professional Summary:

Over 8+ years of IT experience, including 5+ years as BI Developer in interpreting and analyzing data for driving Business Solutions.

Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge of SQL Server Analysis Services (SSAS).

Strong knowledge of various procedural and object-oriented programming languages such as C#

Designed and developed a different type of reports including Drill through reports, Sub reports, drill-down reports based on business requirement using Tableau

Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views, and Cursors.

Experience in building client/server, database, graphics and/or Internet-based systems using Visual Studio .NET

Experience in developing applications based on Microsoft InfoPath Forms, Web parts, Web Services, Workflows, BDC, BCS, Master Pages, Content Pages using SharePoint 2016/2013/2010, SharePoint Designer, Visual Studio 2012/2010/2008.

Experience in setting up of Office 365 online-based solution including migration of content from existing SharePoint on-premise, custom workflow, and reporting capabilities.

Experience in developing System Analysis Design, document management, record management and Implementation of major applications including Web Server/ Client-Server, application development using SharePoint 2016/2013/2010, Microsoft .NET Framework, C#.NET, ASP.NET, and VB.NET.

Knowledge of configuring Outlook Services with SharePoint 2016/2013/2010 for synchronization of SharePoint Libraries and Lists.

Used ETL tools like Alteryx, SAS and joined multiple data source into a single file with data manipulation

Expertise in Visual Studio .Net environment and Microsoft .Net Framework2.0/3.0/3.5/4.0.

Developed and reviewed SQL queries with the use of join clauses in Tableau Desktop to validate static and dynamic data for data validation.

Experience in working with SAS ENTERPRISE GUIDE SOFTWARE for reporting and analytical tasks

Extensive experience in deploying solutions in a sandbox environment.

Developed Responsive web pages in ASP.NET, VB.NET, HTML Using CSS and Media Queries.

Experience in working with Active Directory Services, with adding users in the directory, granting permissions to them according to the rules using User Profile Management.

Experience in using TFS (Team Foundation Server) and SVN (Subversion) to improve collaboration between multiple users

Excellent team player with proven ability to achieve short-term and long-term goals

Education

Master of Science, International Technological University, California, USA, 2015

Major: Software Engineering

Bachelor of Technology, JNTU, Hyderabad, INDIA, 2010

Major: Computer Science

Technical Skills:

Development Tools

Microsoft Visual Studio 2012/2010/2008/2005, Microsoft SharePoint Designer 2013/2010/2007, Microsoft InfoPath 2013/2010/2007, Microsoft Visio 2010/2007, Microsoft Project 2010/2007, Microsoft Office, Tableau, Power BI

Operating Systems

Windows 10/8/7/Vista /XP

Database

MS SQL Server 2013/ 2008/2005, Oracle 9i/10g, PL/SQL, MS Access 2007/2010/2013/2016, Teradata

Internet Development

AJAX, Silverlight, CSS, XSL, XSLT, HTML, DHTML, ASP, VBScript, JavaScript, JQuery, Web Services, WSDL, SOAP, IIS, Media Quires

Programming Languages

C#, C, C++, Visual Basic 6.0, J2SE

.NET Technologies

. NET Framework (1.1/2.0/3.0/3.5/4.0/4.5), ADO.NET, ASP.NET

Professional Experience:

Ford Credit, Dearborn, MI Apr’19-Present

Role: Sr. BI Developer

Description: Ford Motor Credit Company LLC, d/b/a Ford Credit, is the financial services arm of Ford Motor Company and is headquartered in Dearborn, Michigan. The predominant share of Ford Credit's business consists of financing Ford and Lincoln vehicles and supporting Ford and Lincoln dealers.

Responsibilities:

Participated in system specification meetings, analyzed user requirements, coordinated with developers and team members.

Involved in the development of a web-based internal management system which supports the Ford credit insurance system for dealer/lessee claims.

Designed and developed stored procedures, queries, and views necessary to support SSRS reports

Extensively used joins and sub-queries for complex queries which involves multiple tables from different databases. Analyzing data and re-mapping fields based on business requirements.

Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the business users and filed insurance agents.

Created parameterized reports, drill-down and drill-through reports using SSRS.

Created complex ETL packages using SSIS to extract data from staging tables to partitioned tables with an incremental load.

Developed multiple parameterized stored procedures which were used by the reports to get the data.

Created ETL metadata reports using SSRS, including execution times for the SSIS packages, failure reports with the error description.

Created SSIS packages to load each dimension, fact tables, and configured packages using XML, SQL Server, parent package variable methods.

Generated and formatted reports using global variables, expressions, and functions for the reports

Designed SSIS packages to extract, transfer, and load (ETL) existing data into SQL server from different environments.

Created SSIS packages for file transfer from one location to the other using FTP.

Used GitHub for version control and Code deployment

Environment: Visual Studio 2017, SQL Server 2016, SQL Management Studio 2017, SQL Server Data Tools 2017, GitHub, SSIS, and SSRS

General Motors, Detroit, MI May’15-Mar’19

Role: SharePoint/BI Developer

Description: General Motors Company, commonly known as GM, is an American multinational corporation headquartered in Detroit, Michigan, that designs, manufactures, markets and distributes vehicles and vehicle parts and sells financial services. Global Tax Solutions group represents the Tax organization's business needs to GM IT and enterprise system initiatives.

Responsibilities:

Planning, analysis, design, implementation, production support and maintenance of existing applications, primarily using Microsoft SharePoint and BI Tools.

Interacting with the different users and understanding their issues with the SharePoint sites and giving a quick solution.

Successfully developed front end web-based dashboard with trending data, animated pipeline charts, and demographic charts with drill-down functions that displays a breakdown of Regional/States sales, utilizing data aggregation from SQL statements.

Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.

Developed custom page layouts with multiple sections using CSS and jQuery

Developed Workflows for Form Libraries and lists by using InfoPath Forms and SharePoint designer 2013 to provide a flow of approval process in the organization.

Created customized Access on SharePoint portal based on roles and groups.

Used SSIS to unite data from an existing system and performed transformations on MS SQL 2008.

Configuring the SharePoint sites for effective usage using out of the box features.

Develop and implement SharePoint data collection systems and other strategies that optimize statistical efficiency and data quality.

Loading SAP data into the Teradata database using Fast load on a monthly basis for Reporting

Used ETL tools like Alteryx, SAS Enterprise Guide and joined multiple data source into a single file with data manipulation

Worked on advanced querying the database using SAS Enterprise guide in calculating and computing columns, using filters, manipulated and prepare the data for reporting and statistical summarization

Developed canned / Ad-Hoc reports and complex dashboards in Tableau as needed.

Created customs SQL for complex data pulls from Teradata and developed Tableau dashboards

Created workbooks and Dashboards using calculated metrics for different Visualization requirements

Designed dynamic PDF reports in Tableau using SharePoint list data

Designing and implementing dashboard solutions.

Managed around 40 Site Collections with Production Support and User access renewals

Environment: SharePoint 2016 Enterprise, SharePoint Designer 2013, InfoPath designer 2013, CSS, jQuery, Tableau, Access Database 2016, Teradata, Power BI, Alteryx, SAS Enterprise Guide

Blue Cross Blue Shield, Southfield, MI Feb’15-Apr’15

Role: SharePoint Developer

Description: The Blue Cross Blue Shield Association is a federation of 37 separate United States health insurance organizations and companies, providing health insurance to over 100 million Americans.

Responsibilities:

Involved in the overall design, development, implementation, and support of the internal portal for a company using SharePoint 2010.

Involved in Business requirement gathering and analysis.

Created workflows using Nintex Workflow Designer for merging two lists.

Formatted list items using Nintex Console and copied to another list.

Created multiple list views based on the requirement.

Designed list items in HTML using CSS and JQuery and displayed them in SharePoint pages using List Web parts.

Created multiple list workflows to configure list data based on list items.

Designed email notification workflows using Nintex Workflow Designer.

Designed role-based security based upon user category

Environment: SharePoint 2010 Enterprise, CSS, JQuery, HTML, Nintex Workflows

Wells Fargo, SFO, CA Sep’13-Jan’15

Role: SharePoint Developer

Description: Wells Fargo & Company is an American multinational banking and financial services holding company with operations around the world. Wells Fargo is the fourth-largest bank in the U.S. by assets and the largest bank by market capitalization. Wells Fargo is a provider of banking, mortgage, investing, credit card, insurance, and consumer and commercial financial services.

Responsibilities:

Involved in the overall design, development, implementation, and support of the internet and external portal for a company using SharePoint 2013/2007.

Used Device channels and user agent string to design different look and feel for all supported smart devices.

Used Responsive Web Design to support multiple devices like tablet, mobile, etc.,

Migrated Master Pages, Page Layouts, User control, and custom web parts from MOSS 2007 to SharePoint 2013.

Worked on custom branding and look and feel using CSS, JavaScript, and jQuery to support all browsers like IE8 and later, Chrome and Firefox.

Created a custom image slider’s using JQuery with clickable image option.

Worked on implementing and customizing MOSS 2007, 2013 SharePoint sites.

Created custom user controls to pull the data form share point lists and display them on pages using custom CSS

Created custom user control using C#, ASP.Net and SharePoint Object model

Updated Share point list items through customization using SharePoint Object model

Used SVN (Subversion) to improve collaboration between multiple users

Environment: SharePoint 2013/2007 Enterprise, Visual Studio 2012/2010, VB.net, SVN Subversion, Windows Server 2012/2008, SQL Server 2012/2008, CSS, jQuery, Anthill, Media Queries

Allianz Asset Management, Newport Beach, CA Nov’12- Apr’13 Role: SharePoint Developer

Description: Allianz Asset Management (AAM) is the financial and governance holding company for the asset management business. AAM is comprised of two separate investment management companies Allianz Global Investors and PIMCO. The primary aim of their website is to provide with insights into the thinking that drives investment strategies and firm.

Responsibilities:

Involved in Software Development Life Cycle (SDLC) level and detail level designing, development, test planning and execution, deployment.

Worked on custom web parts and created WSP Packages and features to deploy the solutions in SharePoint Central Administration.

Worked on creating Master Pages, Page layouts using SharePoint 2010, and customize them using SharePoint Designer, Microsoft Silverlight, and CSS scripting language

Worked on Web Services, User Controls, Site Collection, Sites, and Work Flows using XML, HTML, JavaScript, Excel Services, SharePoint Designer 2010, SQL Server Reporting Services, Team Foundation Services, and Visual Studio.

Worked on existing custom web parts on the site by adding filtering capabilities to the web part.

Developed out of Box SharePoint Features, SharePoint Designer Applications, Custom Web Parts, and Workflows to manage external user profiles.

Worked on Site templates, List Templates for configuring permissions to different users based on the user’s request.

Developed Master Pages/Content Pages, Custom Web Parts, Event Handlers, Timer Jobs, List Features, Web Services, Document Libraries, and Alerts Web parts.

Developed Workflows for Form Libraries and lists by using InfoPath Forms and SharePoint designer 2010 to provide a flow of approval process in the organization.

Created forms in InfoPath that will facilitate the compilation/Production of a report and deployed them on the SharePoint Portal.

Used Team Foundation Server to improve collaboration between multiple users.

Environment: SharePoint 2010 Enterprise, SharePoint Designer, Visual Studio 2010, TFS Server, Windows Server 2008, SQL SERVER 2008, CSS, AJAX

PCAOB, Ashburn, VA Apr’12 – Oct’12 Role: SharePoint Developer

Description:

The PCAOB is a nonprofit corporation established by Congress to oversee the audits of public companies to protect the interests of investors and further the public interest in the preparation of informative, accurate and independent audit reports.

Responsibilities:

Conducted multiple business requirement gathering and discovery workshops to gather the business and functional requirements for a Microsoft Office SharePoint Server 2010 based Case Management System.

Migrated custom web parts from MOSS 2007 to SP 2010

Created automated alert workflows using SharePoint designer.

Created filter web parts using Visual Studio .NET. This web part is a cross-functional tool, designed using jQuery, AJAX, XML, and CSS

Created and published custom InfoPath expense reports, timesheets and application forms to SharePoint Portal Sites using Office Form Services.

Developed FAST Search, Master Pages, WCF and Event Handlers.

Developed several Dashboards. Used Excel, Visio Services.

Created a custom site column, content types, lists, list views, and Templates.

Responsible for the content DB migration from MOSS 2007 to SharePoint 2010. Automated SharePoint backups & application pool recycles using power shell.

Worked on Content Editor Web Part, Page Viewer Web Parts, Lists, Survey, Calendar, Announcements, etc.

Designed role-based security based upon user category.

Environment: Windows Server 2008, SharePoint 2010, C#, ASP.NET3.5, Visual Studio 2010, SQL Server 2008, MS SharePoint Designer 2010, Silver Light, AJAX, InfoPath, IIS, XML, XSLT, CAML, WSP Builder, Microsoft VSS, CSS, Dash Boards.

Contact this candidate