SUMMARY:

• Confidential professional over 13+ years of experience in the areas of BI Development, Azure could services, Database Development and Administrator, Web Development, Client/Server Application Development, Requirements Gathering, Business Analysis.
• Extensive experience in Data Migration between homogeneous & heterogeneous systems using various tools (DTS Import Export Data, DTS Packages, Bulk Insert and BCP, SSIS).
• Hands - on experience in Confidential Azure Services (PaaS & IaaS), Storage, Web Apps, Active Directory, Application Insights, Azure Search, Key Vault, Visual Studio Online (VSO) and SQL Azure.
• Have 7+ years of experience in Confidential .NET Technology, C#, VB.NET, ASP.NET, ADO.NET, MVC, WCF, WPF, LINQ, Entity Framework, AJAX, Web Services, Source Control and Visual Studio .
• Have 8+ years of experience in web technologies like HTML, CSS, Javascript, VBScript.
• Expert in designing dimensional/relational database model and implementation as per business requirements.
• Extensively used several core design patterns like Singleton, Factory, Bridge Pattern etc.
• Expert in implementation of BI, client/server and enterprise applications using Power BI, SSRS, SSIS, SSAS, Power Pivot, SQL Server and SharePoint.
• Strong SQL Server 2005/2008/2012/2014 and SQL Azure skills including Performance tuning Queries, writing stored procedures, user defined functions, triggers, views and indexes.
• Strong Transact-SQL query writing skills (DDL, DML, and DCL) and MDX query skills.
• High expertise in creating dashboards, reports using Confidential Power BI, SSRS and Power Pivot.
• Experience in creating DTS/SSIS packages with ActiveX scripting for transferred data modifications.
• Experienced in different phases of software development life cycle including Requirement gathering, analysis, strategic systems planning, design, programming, testing, documentation and presentation to clients.
• Preparing customer specifications as part of software technical requirements and customer support.
• Strong business and application analysis skills with excellent communication and professional skills.
• Requirements gathering and writing SRS (BRDs) for new client implementations and change orders.
• Excellent communication, learning, problem solving and conceptual skills, ability to work effectively in a team environment.
• Excellent analytical and functional skills with strong communication and interpersonal skills.

TECHNICAL SKILLS:

BI Technologies: SSIS, SSRS, SSAS, MDX, DAX, Power BI, Power Pivot and R

.NET Technologies: ASP.NET, ADO.NET, C#, WCF, WPF, AJAX and VB.NET

Web Technologies: HTML, XML, ASP, Web Services, MVC, WCF, LINQ, Silverlight Java Script, VB Script, AJAX and CSS, .NET Framework, Query

Databases: MS SQL Server 2014/2012/2008 R2/2005/2000, SQL Azure and Oracle

Servers: IIS, MS SharePoint Server

Reports: SSRS, Power BI, Power Pivot, Power View, and Crystal Reports

SDLC: Agile, Waterfall

Platforms/OS: Windows Family, Linux

Others: Azure, Python, VSTF, VSO, Visual Studio

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst

Responsibilities:

• Involved in writing queries, stored procedures, views, User-defined Functions for handling business logic and functionality of various modules.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Extract large volume of data from various data sources to the data warehouse for reporting using SSIS.
• Design and develop SSRS reports for state managers to see the number of renewals, duplicates and logins etc, by profession.
• Designing, developing, testing, deploying and scheduling the SSIS packages using SQL Server agent.

Environment: SSIS, SSRS, SQL Server, C#, ASP.NET, Power Pivot, Visual Studio.

Confidential

Data Analyst

Responsibilities:

• Responsible for database design, development, enhancements and testing the requirements based on release plan.
• Designing Power BI dashboards to see the various ETL and package performance.
• Designing and developing of reports in various technologies per the requirement using SSRS, Power BI, Power Pivot etc.
• Testing various Transformations of data at different stages of Acquisition, Integration, and Distribution, to meet Technical requirements using SQL.
• Test case creation, Automation, and Execution. Maintaining Test cases in TFS and MTM
• Performance improvement and SIT Environment preparation.

Environment: SSIS, SSRS, Azure Services, Power BI, C#, SSAS, MDX, SQL Server 2014, VSTF, MTM and Windows 2012.

Confidential

BI Developer

Responsibilities:

• Requirement gathering, analysis, designing, developing, testing, implementing and maintaining the Business Intelligence solutions, web applications and requirements/Project management tools.
• Extensive ETL created through SSIS from various systems inside the organization.
• Worked on complex T - SQL queries, performance tuning, views and stored procedures.
• Created SSRS reports using T-SQL and MDX for making major business decisions.
• Created Dashboards for the daily health of the data.
• Integrate TFS work items with SQL Server database and create SSRS reports from TFS DW.
• Worked on design, development, testing and code review for internal web sites designed using ASP.NET, C#, HTML and Javascript.

Environment: SSIS, SSRS, SSAS, ASP.NET, MVC, C#, SQL Server 2012, VS, VSTF, Power BI, Power Pivot, Windows 8/2008R2, Silverlight, IIS.

Confidential

Solution Delivery Analyst

Responsibilities:

• Designing and developing ETL’s as per the client requirement using SSIS.
• Analyzing the user requirement, designing and developing the reports using SSRS and Power Pivot.
• Writing SQL queries to retrieve and update data, performance tuning slow running queries.
• Analyzing the data in the data warehouse for consistency between source, DW and reports.
• Handling and managing business requirements, change requests from stakeholders.
• Provide updates to downstream and end users about stale data, down time and data issues.
• Describe root cause analysis of production issues and provide solution options.
• Analyzing the data discrepancies between sources systems and Confidential systems.
• Designing and developing usage statistics and users reports for stakeholders.

Environment: SSIS, SSRS, and SSAS, PowerPivot, SQL Server 2008 R2, T-SQL and VBA

Confidential

BI Developer

Responsibilities:

• Analysis of data in the Data Warehouse for consistency with the Web Trends reports.
• Analysis of Business reporting requirements from various teams within the office group.
• Designing and developing of reports in various technologies per the requirement using SSRS, Power Pivot, excel Services etc.
• Create and maintain TSQL Queries, Stored procedures and views.
• Drilldown reports for detailed view of all the metrics and KPIs and publishing of reports onto the SharePoint.
• Task allocation and provide support to team in solving technical and functional issues.
• Develop/ enhance the SSIS packages to load data from sources to data warehouse.
• Train the team on new BI features and effective use of existing features for building easy accessing and visualized reports to users.

Environment: SSAS, Power Pivot, C#, SSRS, SSIS, T-SQL and SQL Server 2008 R2

Confidential

BI Developer

Responsibilities:

• Requirements gathering, resource planning, team management, delivery ownership of the entire project.
• Allocate the work among the team and support them in solving the technical and functional issues.
• Understand and analyze the business requirement and create dash boards using SSRS reporting tool.
• Designing, Developing, and testing ETL solutions using SSIS.
• Support existing DW platform/applications to ensure system availability and scalability and enhancements to the existing reports.

Environment: SSIS, SSRS, PerformancePoint, SQL Server 2008 R2 and SharePoint 2010

Confidential

BI Developer

Responsibilities:

• Designing, Developing and testing new SSIS Packages.
• Writing complex queries to retrieve data, performance tuning slow running queries.
• Optimizing the existing the packages to improve the performance.
• Getting requirements from client and implementing them same.
• Writing DQ packages to validate the existing package data loads.

Environment: SSIS, BIDS 2008, TFS, SQL Server 2008 R2 and Windows 7

Confidential

Software Developer

Responsibilities:

• Designing, Developing, and testing ETL solutions using SSIS.
• Interacting with client for requirement gathering and status updates.
• Analyzing, designing, developing and testing the reports as per the requirement.
• Writing stored procedures, views and queries for retrieving data from SQL Server 2005 database.
• Scheduling the developed packages and reports using SQL Agent for running them weekly and monthly.

Environment: SSIS, SSRS, BIDS 2008, TFS, Oracle, SQL Server 2008 and Windows 2008

Confidential

Software Developer

Responsibilities:

• Developing and testing web forms as per client requirement.
• Maintenance & support of the existing functionality, involved in enhancement, bug fixing and design changes.
• Designed and developed 3D Charts in office excel 2007 with VB Script.
• Involved in writing SQL stored procedures for retrieving and inserting data from/to SQL Server 2005 database.
• Designed and developed reports as per client requirement using SSRS.

Environment: ASP.NET, C#.NET, MVC, JavaScript, XML, SQL Server 2000/2005 and Windows XP Professional.

Confidential

Software Engineer

Responsibilities:

• Responsible in design changes and enhancement of Confidential portal using ASP.NET and C#.
• Analyzed the requirements and development of the same.
• Developing new tools for automating the maintenance of the existing application.
• Designing, developing and testing ETL packages as per client requirement.

Environment: ASP.NET, SSIS, SSRS, C#.NET, JavaScript, XML, SQL Server 2000 and Windows XP Professional.

Confidential

Software Engineer

Responsibilities:

• Assign the work to all the programmers and support them in solving the technical and functional issues.
• Maintaining the live connection between server and client machines and transferring the data between client and server and vice versa.
• Developing the components as required and involved in creating in databases.
• Involved in writing SQL stored procedures retrieving, deleting and inserting data to SQL Server database.

Environment: C#.NET, SQL Server 2000 and Windows XP Professional.

Confidential

Software Engineer

Responsibilities:

• Managing daily activities analysis and integration of the website on daily basis.
• Fixing Bugs errors in the website and made enhancement to the website.
• Involved in writing SQL stored procedures and views for retrieving, deleting and inserting data to SQL Server database.

Environment: ASP, ASP.NET 2.0, VB 6.0, C#.NET 2.0, Javascript, VB Script, SQL Server 2005 and Windows XP Professional.

Confidential

Software Developer

Responsibilities:

• Involved in analysis, web forms designing, coding, and testing phases of the website.
• Managing daily activities analysis and integration of the website on daily basis.
• Designed business logic using VB.NET and ASP.NET
• Involved in writing SQL stored procedures and views for retrieving, deleting and inserting data to SQL Server database.

Environment: VB.NET 2.0, ASP.NET 2.0, VB 6.0, ASP, Javascript, AJAX, XML, SQL Server 2000 and Windows XP Professional.