PROFESSIONAL SUMMARY:

• Over all 8 years of experience as Microsoft Business Intelligence (MSBI) applications Developer in software analysis, requirement, design, application development, testing and support.
• Expertise in ETL Developer using SQL Server Integration Services 2008 and 2012.
• Hands on experience on SSIS, SSAS, SSRS, MDX, T - SQL, PL SQL, Power Pivot and Power View reports.
• Extensively used various SSIS objects like Control Flow components, Data flow components, Connection Managers, Shared Data sources.
• Experience in developing and designing reports on SQL Server Reporting Services (SSRS).
• Expert in deploying, scheduling and debugging reports in SSRS.
• Good hands on experience with SQL Server 2016/2014/2012/2008/2005 , SSIS, SSRS, SSAS and T-SQL.
• Extensive knowledge in Tuning SQL queries, improving the query performance & trouble shooting.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), co-related sub queries, in-line views and PL/SQL programming.
• Performance Tuning like identifying long running queries, Open Transactions, Blockings, Deadlocks, Trace Flagsetc.
• Implemented ‘Always on Availability groups’ in SQL 2012 on multinode Cluster environment.
• Auditing of database for user’stransactions, login and database action and removing orphan users
• Managed slowly Changing dimensions (SCD) and optimized fact table inserts.
• Expert in creating Databases, tables, clustered and non-clustered indexes.
• Expert in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Extensive experience in Information Technology with special emphasis on design &developmentof Database/Data Warehousing/Client-Server applications.
• Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL).
• Proficient in creating T SQL (DML, DDL, DCL and TCL), Indexes, Views, Temporally Tables, Table Variables, Complex Stored Procedures, System and User Defined Functions.
• Expert in creating Calculated Measures and Dimension Members using Multi-Dimensional Expression (MDX), Mathematical Formulas, and User-defined functions.
• Extensively used the advanced features of PL/SQL like collections, nested table and dynamicSQL.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Worked on Power View and Power Map to visualize reports.
• Work with cursor and ref cursor in PL/SQL scripts. Used ref cursor in functions to write the record set of cursor .
• Expertise in Client/Server (Win Forms) and Web based (Web Forms, ASP.NET) application development.
• Strong knowledge of Responsive Web Design, Responsible for checking cross browser compatibility on different browsers.
• Experience in developing the web applications using ASP.NETMVC 4.0/3.0.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.
• Installed and maintained SQL Server failover clustering (active/active and active/passive) for SQL Server 2005 and SQL Server 2008R2, SQL Server 2012 versions and have a good understanding of SQL Server 2014 featuresalways ON, user defined server roles.
• Good knowledge of Data Marts,Data warehousing, OLAP, OLTP, Dimensional Data Modeling, Star Schema Modeling,Snow-Flake Modeling, FACT and Dimensions Tables.
• Expertise in Developing and Extending SSAS Cubes, Partitioning,Data Mining Models, Deploying and Processing SSAS objects, writing MDX queries.
• Familiar with Agile development and waterfall methodologies.
• Excellent Interpersonal and communication skills, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment.
• Excellent logical and analytical skills to solve complex problems.

TECHNICAL SKILLS:

Databases: SQL Server 2016/ 2014/2012/2008 R2/2008/2005, MS Access

Languages: SQL, T- SQL, PL/SQL, XML, C#, JavaScript, .NET, HTML, CSS

Operating Systems: Windows NT/2000/XP/7/8/8.1

ETL Tools: DTS, SQL Server Integration Services (SSIS), Data Stage.

Tools: Red gate, lit speed, Scom, fog lite, for SQL Source Control and database comparison and Performance monitoring.

Other Software: MS Office- 2013/2010/2007/2003

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS).

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, SQL Diagnostic Manager.

CAREER PROFILE:

Confidential, Pittsburgh, PA

Sr. MSBI Developer, SQL Server Developer

Responsibilities:

• Involve in software development Life cycle (SDLC) and participated in scrum meetings with team.
• Involve in requirement gathering and calls with clients.
• Wrote hundreds of stored procedures and function on numerous SQL server to use in SSIS package and Power BI.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports
• Extensively worked in Service Oriented Architecture (SOA) through WCF, RESTful Services and C#.NET.
• Developed data driven business logic using C# and SQL Server database.
• Communicate to business users on sprint basis for development update and confirmations.
• Develop Excel Power View, Power Query and PowerPivot dashboards for data analysis.
• Developed complex SSIS packages for data retrieval and cube processing automation.
• Create DAX and VB scripts for Excel reporting and calculated members.
• Use SSIS for data processing on daily basis and automation.
• Created procedures and functions using PL/SQL.
• Developed C# tool to update and populatedestination tables schema based on source tables/ excel files
• Design, develop and deliver services analytics materials including back-end development of analytics services, SQL Reporting, delivery of automated reports & Power BI reports customization
• Design, Develop and Deploy Microsoft Power BI reports.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Writing PL/SQL code using the technical and functional specifications
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Worked extensively with debugging, defect tracking and troubleshooting issues.
• Implemented the concepts of Incremental Data Load, Slowly Changing Dimensions for updating and maintaining the history of the records
• Created List reports, cross tab reports, charts, sectional reports,& Drill through reports by usingReport studio.
• Generating Reports as per the requirement using SSRS 2005/2008.
• Responsible for creating Drilldown, Drill through OLAP reports using SSRS 2008.
• Developed various drill down, parameterized reports using SSRS 2008.
• Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries .
• Generating Reports as per the requirement using SSRS 2005/2008.
• Responsible for creating Drilldown, Drill through OLAP reports using SSRS 2012.
• Created stored procedures as per business logic to populate mart.
• Developed different Scripts for the Dataanalysts for Verification of reports.
• Configured Database mirroring between SQL 2008instances for high availability.
• DevelopedEntity-Relationship modeling for OLTP system using MS Visio 2007.
• Monitoring the server’s performance and diskspace available for log, data etc.
• Monitoring SSIS/SSRS jobs in all servers QA, UAT and Production.
• Worked in production support team to support, debug SQL code and SSIS packages to fix any failures.
• Analyzed the tables and indexes using SQL and PL/SQL scripts.
• Created materializedviews, dimensions and stored outlines for optimalperformance.
• Responsible for creating use cases for datamart and cubetesting and also performed initial validations to check data consistency.
• Worked on datacompressions and backupcompressions, completedeployment to production and verification.
• Understand legacy OBIEE reports, and coming up with data points, create understanding and guidelines documents for business users.

Operating System: Windows 7 Enterprise

Languages: T SQL, PL SQL, SQL Server 2008R 2/2012/2014/2016 SSIS, SSAS, SSRS, Oracle 11g, Oracle Extra data,.Net, SharePoint, Tabular, Excel Power Pivot

Special Software: Visual Studio, Team Foundation Server, SQL Server Management Studio, SQL Profiler, Automic UC4, SAP, Oracle SQL Developer

Confidential, San Diego, CA

MSBI Developer, SQL Server Developer

Responsibilities:

• Created SSIS Packages to import and export files from Database and load data in to the target servers/locations.
• Deploying SSIS Packages to QA, and UAT and Production servers, Scheduling deployed Packages.
• Responsible for writing T-SQL (DDL/DML) Queries, Stored Procedures, Views, Functions and Triggers.
• Worked extensively with debugging, defect tracking and troubleshooting issues.
• Responsible for migration of databases from old SQL server versions to SQL Server 2005/2008.
• Communicate to client on sprint basis for development update and confirmations.
• Performed SQL and PL/SQL tuning to improve the performance with the help of SQL Trace , Explain Plan, Indexing and Hints.
• Create scorecards and dashboards to empower reports from OLTP, OLAP and reporting tables using SharePoint Insight and Power BI sheet.
• Design, Develop and Deploy Microsoft Power BI reports.
• Involved in writing T-SQL statements for retrieval of data.
• Worked on performance tuning of T-SQL queries and Stored Procedures . Optimized query performance by creating indexes.
• Writing T-SQL scripts for migrating databases and security from SQL 2005 to SQL 2012
• Writing T-SQL scripts for re-running failed jobs, restoring databases, and application security settings
• Implemented the changes/modification like iterative/incremental development and used .NET Framework and Object Oriented Methodologies for application development by using agile scrum methodology.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Developed web pages using ASP.NET and VB.NET.
• Used ASP.NET MVC and C# in the new development projects
• Developed Excel Power View, Power Query and PowerPivot dashboards for data analysis.
• Created DAX and VB scripts for Excel reporting and calculated members.
• Used SSIS extensively for data loading with different source and destination connections.
• Used various transformations like UNION, MERGE, LOOKUP, CONVERSION, DERIVED COLUMN, AGGREGATIONS.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Used SFTP components in fetching files from FTP servers.
• Wrote PowerShell script for downloading and archiving files from FTP server.
• Created tabular SSAS cubes for fast retrieval of data.
• Created perspectives in tabular SSAS cube.
• Created roles in tabular SSAS cube for security.
• Generated MDX scripts for KPIs and calculated members based on business requirements in SSAS .
• Generating Reports as per the requirement using SSRS 2005/2008.
• Responsible for creating Drilldown, Drill through OLAP reports using SSRS 2008.
• Developed various drill down, parameterized reports using SSRS 2008.
• Developed different Scripts for the Data analysts for Verification of reports.
• Worked on Side by Side migration of multiple SQL 2005 instances to SQL 2008.
• Configured Database mirroring between SQL 2008 instances for high availability.
• Developed Entity-Relationship modeling for OLTP system using MS Visio 2007.
• Monitoring the server’s performance and disk space available for log, data etc.
• Created materialized views, dimensions and storedoutlines for optimal performance.
• Responsible for creating use cases for data mart and cube testing and also performed initial validations to check data consistency.
• Worked on data compressions and backup compressions.

Operating System: Windows 7

Languages: T SQL, PL SQL, SQL Server 2008 R2, SQL Server 2012, .Net, MSBI Tools

Special Software: Visual Studio, Team Foundation Server, SQL Server Management Studio, SQL Profiler.

Confidential, Redmond, Washington

MSBI Developer, SQL Server Developer

Responsibilities:

• Worked on all aspects of MSBI (SSIS, SSAS), Power pivot.
• Implemented Cube Security, ETL mails, quick changes to whole solution in case of requirements.
• Communicating with the client for collecting the requirement, document them, implementation the same.
• Identifying and documenting the technical issues and the approach to resolve the same.
• Scheduled daily refresh jobs from SQL Server agent, and provided support in case off ETL failure.
• Implemented DAX (Data Analysis Expressions) functions for SSAS tabular models and Excel pivot tables.
• Implemented DAX to create various calculations (such as MTD actual totals, MOM and WOW comparisons - based on current month/week, previous month/week, average product review ratings).
• Optimized the SSAS tabular model process speed by properly designing data models and optimizing DAX calculations .
• Synced up with source teams regularly and fixed ETL issues.
• Involved in end to end systemdevelopment and design of the project.
• Provided solutions to automate ETL.
• Communicating with the offshore team for getting the status of work, and making it done if any work pending.Supporting the in project set up and meeting if needed, identifying the issues and trying to resolve them.
• Provided support to down streams regularly who are using reports.
• Implementing slowly changing dimensions to maintaining Historical data in required dimension table.
• Written the Stored Procedures and functions, Involved in the performance Tuning.

Operating System: Windows 7, Windows Server 2008

Languages: T SQL, SQL Server 2008/2008R2/2012 SSIS, SSAS, MDX, HTML5, CSS, JavaScript, .Net

Special Software: Visual Studio, Team Foundation Server, SQL Server Management Studio, SQL Profiler

Confidential

SQL Server Developer

Responsibilities:

• Used the SSIS to migrate Databases such as Oracle and Access database, flat files to centralized IT destination.
• Responsible for Developing, Monitoring and DeployingSSIS packages.
• Successfully created dynamicconfiguration packages in SSIS.
• Used Event Handlers for Exception Handling in SSIS packages.
• Implemented slowly changing dimension on 500,000 records that took 11minutes to complete. Improved the performance by replacing it with checksum to 8 minutes.
• Created many complex Stored Procedure/Functions and used them in Crystal Reports directly to generate reports.
• Involved in Creation of Crystal Reports, created ODBC Connections and database connections.
• Scheduled, maintained, and supported the distribution and access to reports through Crystal Reports.
• Created Stored Procedures, Views and user defined functions to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
• Documenting the business requirements and converting them in to technicalrequirements to start the development phase of the system.
• Designed and Developed Universes and resolved loops by creatingAliases and Contexts.
• Derived key performance indicators or financialreporting modeling with support of complex calculations. Other BI applications merge BI analytics with data collection for budgeting, planning, and forecasting.

Operating System: Windows 7, Windows Server 2008.

Languages: T SQL, SQL Server 2008 R2, MSBI Tools, HTML, CSS, JavaScript, .Net.

Special Software: Visual Studio, Team Foundation Server, SQL Server Management Studio.

Confidential

SQL Server Developer

Responsibilities:

• Worked extensively with debugging, defect tracking and troubleshootingissues.
• Responsible for Import and export of data between the environments and Data Cleansing.
• Developed different Scripts for the Data analysts for Verification of reports.
• Developed various drill down, parameterized reports using SSRS.
• Expert in creatingindexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Implemented various performance tuning methods to improve the performance of queries, stored procedures and SSIS Packages.
• Developed different Scripts for the Data analysts for Verification of reports.
• Generating Reports as per the requirement using SSRS 2005/2008.
• Extensively used joins and sub-queries to simplify complex queries involving multiple tables.

Operating System: Windows 7

Languages: T SQL, SQL Server 2008, SSIS, Excel PowerPivot

Special Software: Visual Studio, Team Foundation Server, SQL ServerManagement Studio.