SUMMARY:

• 7+ yrs of real time experience as an MSBI and .Net developer with good analytical skills and experience in all the phases of Software Development Life Cycle (SDLC) including requirements, analysis, design, implementation, integration and testing, deployment and maintenance.
• Experience in excellent end user interaction, business requirement analysis, capacity planning, preparing the estimations and timelines of the projects and deliverables.
• Extensive experience with SQL development with good knowledge in RDBMS concepts.
• Extensive experience in SQL Server 2014/2012/2008/2005 in writing complex stored procedures, Triggers, Schema design, Index, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS) and Power BI.
• Technical expertise with Microsoft .Net technologies, such as C# (4.0/3.5/3.0/2.0 ), .Net Framework (4.0/3.5/3.0/2.0 ), ASP.Net (4.0/3.5/3.0/2.0 ), ASP.Net MVC 5.0/4.0/3.0, Visual Studio .Net 2008, 2010, 2012, 2013.
• Expertise working on various tasks within an SSIS package like sequence container, for loop, for each loop container, SQL tasks, files system tasks, script tasks using C# and data flow tasks etc.
• Experienced in performing various data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived column, Lookup etc.
• Experience in building SSIS packages involving ETL process, extracting data from various heterogeneous sources like flat files, Excel files, legacy systems and loading into SQL server
• Experience in Performance Tuning of SSIS packages by non - blocking, partially blocking and row transformations.
• Scheduled Jobs for SSIS ETL Packages to run daily, weekly or monthly using various job scheduling tools like Autosys (CA Workload Control Center).
• Experience working with SQL reporting services (SSRS) reports like linked reports, sub-reports, tabular reports, charts, matrix reports and parameterized reports.
• Good knowledge on data visualization and dashboard designing using Power BI.
• Expertise in designing the dashboards using Power Pivot and Power BI.
• Good knowledge in writing complex Stored Procedures using TSQL Scripting and CTE.
• Expertise in query optimization & performance tuning. Used tools like SQL Profiler.
• Experience in designing lightweight web pages using javascript and, jquery.
• Experienced in implementing WCF services and consuming the services using different protocols like SOAP.
• Good knowledge on Object Oriented Programming (OOPS) Concepts including Inheritance, Abstraction, Encapsulation and Polymorphism, good experience in Exception Handling and Debugging.
• Experienced working with version control tools like Team Foundation Server-TFS 2010 and 2013.
• Good working knowledge on application server management software like Microsoft Internet Information Services (IIS) 6, 7 and 8.
• Good working knowledge on creating websites, development and maintenance setting up application pools etc in IIS 6, 7 and 8.
• Good understanding of project issues, ability to work independently/teams, onsite coordinator, quick problem solver and effectively handled offshore team.

TECHNICAL SKILLS:

Database: MS SQL SERVER 2014/2008/2005, MS Access 2010/2007/2003, Oracle 11g/10g/9i/8i

ETL Tools: SQL Server Integration Services (SSIS)

Reporting Tools: SQL Server Reporting Services, Power BI, Power Pivot

Analytical Tools: SQL Server Analysis Services

Programming Languages: SQL, PL/SQL, T-SQL, C#.Net, ASP.Net, ADO.Net, XML, HTML

Other Tools: SQL Server Management Studio, Toad, Business Intelligence Development Studio, Visual Studio 2013/2010/2008 /2005, QNXT 4.8/5.3

Servers: Windows 2012 R2/2008 R2/2008/2003, XP, Windows 7, Vista. Microsoft IIS (8/7/6)

Version Control Tools: Team Foundation Server 2013/2010/2008

WORK EXPERIENCE:

Confidential, Longbeach, CA

Sr. MSBI & .Net developer

Responsibilities:

• Involved in requirement gathering and analysis of business requirements, participated in requirements review meetings with business users, clients, project management and other teams.
• Involved in capacity planning, project estimations and setting the projects timelines of projects or deliverables.
• Worked as an onsite coordinator and effectively led offshore team by work assignment, code review and on-time delivery of the projects or deliverables.
• Migrated data from different sources (text based files, Excel spreadsheets, legacy systems and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Worked on various tasks within an SSIS package like script tasks using C#, sequence container, for loop, for each loop container, SQL tasks, files system tasks and data flow tasks etc.
• Extensively worked on Deployment, Performance tuning of SSIS packages, data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived column, Lookup etc.
• Worked on loading the data into QNXT and extracting the data from QNXT into other staging databases.
• Created SQL reporting services (SSRS) reports, sub-reports and taking care of the deployment issues.
• Created various SSRS reports like linked reports, ad hoc reports, sub-reports, tabular reports, charts and matrix reports.
• Worked on creating dashboards and visualizations using Power BI and Power Pivot.
• Good knowledge on Tableau.
• Involved in designing and development of tables, views, user defined functions and complex stored procedures using T-SQL and CTE.
• Developed applications using ASP.NET MVC, ASP.NET Web Forms, ADO .Net, CSS, HTML, JavaScript and jquery.
• Worked on creating the WCF SOAP services and consuming the services using different protocols.
• Worked on creating role based authentication to different modules in an application using C#.
• Developed Print MS Word and Print Excel features in the web application using various Microsoft assemblies using C#.
• Developed Print PDF feature in the application using Migradoc assemblies.
• Worked on application server management software like Microsoft Internet Information Services (IIS) 6, 7 and 8.
• Worked on creating Virtual Directories, Sites and Application Pools using Internet Information Services (IIS).
• Experience in working with version control tools like Team Foundation Server-TFS 2010 and 2013.
• Good understanding of workload automation tools like Autosys (CA Workload Control Center) for SSIS, xml and FTP job scheduling.

Environment: SQL Server 2008/2012/2014, SSMS, BIDS, Visual Studion 2010/2013, SSMS, BIDS, TFS 2010/2013, IIS 7/8, ASP .Net 3/3.5/4, MVC 4/5, Entity framework 5, QNXT 4.8/5.3

MSBI developer

Responsibilities:

• Involved in interacting with business team and project management team for gathering requirements and developed T-SQL code and SSIS Packages accordingly.
• Translated functional requirements into Technical specifications and Developed Stored Procedures and Complex SQL Queries.
• Created ETL packages using data sources like SQL Server, Flat Files, CSV Files, Excel source files, Access Files, XML files and then loaded the data into ODS/Staging areas by performing different kinds of transformations using SSIS Control Flow and Data Flow transformations.
• Developed SSIS Packages using fuzzy lookup transformation, file system task and for each loop container.
• Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, and Derived column, etc.
• Developed Dashboard reports using Power view and Power Pivot.
• Used Fuzzy Lookup and Fuzzy Grouping transformations to achieve higher degree of control over the data cleansing process such as standardizing data, correcting data, and providing missing values.
• Working knowledge on relational databases like SQL Server 2012/2008 R2/2005, T-SQL.
• Worked on development of ASP .Net web forms using C#.
• Responsible for timely communication and deployment of deliverables with the respective stake holders.

Environment: SQL Server 2008/2012, ASP .Net 3/3.5, Visual Studio 2008/2010, SSMS, BIDS, TFS 2010, MS Access, Advanced MS Excel

Santa Clara, CA

Responsibilities:

• Involved in Business Requirements gathering, User Requirements and technical requirements gathering by interacting with various stake holders of the project.
• Involved in database designing for different projects and resolve database issues.
• Created and developed the Stored Procedures, functions and triggers to support the application.
• Responsible for development of SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Designing, developing and deploying various ETL packages for data loading (SSIS)
• Worked on developing SQL server integration service (SSIS) packages and SSRS reports.
• Worked on maintenance of web applications using C# and ASP.Net.
• Created Web pages using HTML, C#, ASP.NET and Java Scripts.
• Responsible for continuous enhancements of supply chain systems and procurement systems as a supply.
• Involved in data analysis, preparing the metrics and dashboards using advanced excel.
• Responsible for finding the root cause by analyzing huge amount of data and suggesting the solutions to users.
• Built table relationships and wrote stored procedures to clean the existing data.
• Involved in Unit testing and System Integration testing.
• Involved in writing test cases as part of testing process.

Environment: SQL Server 2008/2012, MS Access, Advanced MS Excel, C#, HTML, ASP .Net, Microsoft Visual Studio 2008, SSIS, SSRS