SUMMARY

• Microsoft Certified Professional with 9+ years of IT experience in with a strong background in Analysis, Design and Development in the field of Database and implementation of Business Intelligence applications
• Worked extensively in the field of Data Visualization & Microsoft Business Intelligence (MSBI) and designed & developed solutions using Power BI, Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)
• Experience in Data warehousing, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables
• Hands on experience in Integration of system using SSIS, SSRS, and Crystal Reports
• Extensive experience in writing SQL procedures, functions in MS-SQL Server and Oracle Databases
• Expert in Extracting and Transforming data using SQL Server Integration Services 2005 / 2008 / 2012 /2016 (SSIS), Bulk Insert and BCP
• Excellent knowledge in Implementation of Relational Database (OLTP) and Data warehousing systems (OLAP)
• Extracted data from different sources including Oracle, Flat Files, Lotus notes, XML Files and SQL Server
• Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor
• Expert in creating simple and parameterized reports and complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS)
• Experienced in creating various Parameterized, Cascaded, Linked and Drill-through & Drill-down reports
• Knowledge in designing Star Schema and snowflake schema with Facts, Dimensions, Measures
• Extensive knowledge and experience on Power BI using DAX queries
• Understanding of multidimensional database & Tabular Model (BISM) design and architecture
• Experience in designing, creating, processing of cubes using SSAS Tabular Model
• Experience in creating Power BI reports using different visualizations Slicers Lines Pies Histograms Maps Scatter Bullets Heat Maps Tree maps etc.
• Good knowledge in Data visualization techniques using Tableau
• Worked on Migration of databases from lower to higher as well as between different databases (Oracle, DB2, SQL Server)
• Proficient in applying transformation rules - Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split
• Experience in creating jobs, alerts, SQL mail agent, and schedules for SSIS Packages in SQL Server Agent.
• Developed Web applications and Web Services using ASP. Net, ADO.NET, C#, Web Forms with HTML5, CSS3, JavaScript and Bootstrap
• Written Unit test cases and carried out integration testing to make sure quality
• Experience in version control management tools like CVS, TFS and Visual SourceSafe.
• Having good knowledge in ASP.Net MVC, Entity Framework, jQuery and Azure
• Proficient in analyzing and translating business requirements to technical requirements and architecture
• Well versed in using Software development methodologies Agile methodology based on SCRUM and Waterfall model methodology, that includes analysis and construction, design, code walkthroughs and reviews, testing, implementation, and production support.
• Involved in full lifecycle for development projects as well as worked in production support in various positions ranging from Developer to Technical Lead
• Worked in Production Support system in 24/7 and having good track record of solving tickets within timeline (SLA)

TECHNICAL SKILLS

Database: SQL Server 2017/2016/2012/2008/2005/2000 , MS Access, Oracle 11g/10g/9i, DB2, MS Access

Business Intelligence Tools: SSRS, SSIS, SSAS, Power BI, Tableau

Reporting: SQL Server Reporting Services, Crystal Reports

Visualization Tools: Power BI, Tableau

Web Technologies: JavaScript, HTML, ASP, ADO, CSS, DHTML, XML, X-Path, XSLT, HTTP, FTP, and SSL

Programming Languages: C#.NET, VB.NET, Visual Basic 5.0/6.0, C, T-SQL and PL/SQL

Web Server: IIS 6.0/7.0/8.0

Database tools: SQL Server Management Studio, SQL Server Data Tools, SQL Profiler, Database Tuning Advisor, Query Analyzer

Methodology: Agile, Waterfall

PROFESSIONAL EXPERIENCE

Confidential

MS SQL / MSBI / Power BI Developer

Responsibilities:

• Designed and developed solution using SQL Server, SSRS, SSIS, Power BI
• Participated in requirements gathering
• Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team
• Designed/developed SSRS reports and supported the deployment of the reports to Report Server
• Created Drilldowns, Drill through and Parameterized reports using SSRS
• Designed/developed very rich Power BI Report and Dashboards, Data Models as per the given requirement
• Published reports to Azure-based Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps)
• Used various sources to pull data into Power BI such as SQL Server, Oracle, SQL Azure etc
• Designed/developed ETL jobs using SSIS Packages and supported the deployment of the Packages into SQL Server Integration Services Catalog
• Created Tables, Stored Procedures, Views, Indexes, Cursors, Triggers and User Defined Functions
• Documentation of business and IT solutions, business process functional and nonfunctional requirements and problems
• Designed SSIS packages for transferring data from heterogeneous sources like CSV, flat file and SQL Server Database
• Assisted in managing the MSBI environment, Enhancements and support the applications
• Involved in developing queries as part of Execute SQL Task in SSIS package and creating Stored Procedures which are called from packages
• Implemented Event Handlers for Error Handling in SSIS packages
• Developed business logic in Stored Procedure for the dataset in SSRS reports to pull data based on Business Requirement
• Part of the Agile/Scrum team and participated in Standup, grooming, sprint planning and retrospective meetings
• Involved in Unit test plan preparation, Unit testing, Change request Impact analysis and Integration Testing

Environment: Microsoft SQL Server 2017, SQL Server Integration Services 2017 (SSIS), SQL Server Reporting Services (SSRS), T-SQL, Microsoft Visual Studio 2017, SQL Server Data Tool 2017, TFS, MS Excel.

Confidential

MS SQL/MSBI Developer

Responsibilities:

• Effectively designed the database and created database objects like Tables, views, stored procedures, functions, and indexes
• Used Multidimensional database (MDX Queries) in SSRS Report Development
• Worked on Drill through Report links and Hyperlinks to jump to other reports and web pages using Microsoft SQL Server Reporting Services (SSRS)
• Designed and developed SSIS packages using different transformations like Multicast, Conditional Split, Merge, Merge Join, Data conversion, and Aggregate functions and transfer data from ORACLE, MS ACCESS and FLAT FILES to SQL SERVER
• Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting
• Involved in designing cubes in SSAS environment using Snowflake and Star Schemas
• Created complex SSAS cubes with multiple data partitions to selectively refresh smaller subsets of data to save on processing time in terms of heavy transactional data
• Created Database Jobs and scheduled SSIS Packages using SQL Server Management Studio for the Daily Load
• Performance tuning of the application by fine tuning the stored procedures, applying indexes on frequently accessed tables
• Designed, developed, debugged Stored Procedures, configuration files and implement best practices packages to maintain optimal performance
• Monitor DB jobs and scheduled tasks every day to ensure the application availability
• Involved in Unit test plan preparation, Unit testing, Change request Impact analysis and Integration Testing
• Guided and Lead team to achieve their tasks technically and functionally

Environment: Microsoft SQL Server 2012/2016, SQL Server Integration Services 2012/2016 (SSIS), SQL Server Reporting Services (SSRS), Microsoft Visual Studio 2010, SQL Server Data Tools 2012/2016, JIRA, TFS.