SUMMARY

• Over 5 years of extensive experience in business intelligence applications design, development and maintenance of SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analytical Services (SSAS).
• Experienced in developing Power BI reports and dashboards from multiple data sources using data blending.
• Good Experience in database design, data modeling, development, implementation, ETL and reporting in SQL Server 2014/2012/2008/2005 .
• Proficient in developing use cases, sequence diagrams, collaboration diagrams, state diagrams and activity diagrams based on UML methodology using tools like MS Visio, MS Word and MS Excel.
• Experienced in facilitating joint requirement planning (JRP), joint application development (JAD) with business user groups, subject matter experts, and IT to limit the change process and develop the design.
• Reporting Services (SSRS), Analysis Services (SSAS) & Power BI (Power View, Power Pivot)
• Experienced with gap analysis to check the compatibility of existing systems with new business requirements.
• Practical understanding of data modeling (dimensional & amp; relational) concepts like star - schema modeling, snowflake schema modeling, and fact and dimension tables.
• Used Power BI to prepare dashboards to create attractive visualizations.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using PowerPivot, Power View & Power BI.
• Experience monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal performance.
• Expertise configuring and creating SSIS solutions for ETL and business intelligence process for data integration and migration services.
• Skilled in merging data from various heterogeneous data sources, populating dimension and fact tables in data warehouses and data marts, cleaning and standardizing data loaded into OLTP and OLAP databases using SSIS.
• Extensive experience creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Expertise creating various parameterized, cascaded, linked, drill-through and drill-down reports.
• Expertise configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.
• Created SSIS packages with complicated transformations like Lookup, Derived Column, Condition Split, Multicast, Sort, Union All, Cache Transform, and Conditional Split, Fuzzy Look-ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc.
• Great Expertise in event handlers, Package Configurations, Logging, and Check points, Package Securities and User Defined Variables for SSIS Packages.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in Reporting Services, Power BI (Dash Board Reports), Crystal Reports, Tableau using MS SQL Server and in supporting services MDX technology of the analysis services.
• Expertise in designing, supporting complex reports like Drill-Down, Drill-Through, Parameterized, Matrix, and formatting Reports using SQL Server Reporting Services SSRS) based on client requirement.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS) and also created reports using MS Access and Excel VBA.
• BI Integration with SharePoint like Power View, Power Pivot and Power Query, Excel Service, and Reporting service.

TECHNICAL SKILLS

Integration Services: SQL Server Integration Services (SSIS)

Reporting Tools: SSRS, SSAS and Crystal Reports, Tableau, Power BI

Languages: C, C++, C#, SQL, T-SQL, PL/SQL, HTML, Java Script, UNIX, Shell, DTS, SharePoint

Operating Systems: Windows Vista/NT/XP/98/95, Windows 2008/2003 Server, UNIX

Databases: MS SQL Server 2014/2012/2008/2005, Oracle 10g/9i/8i,DB2, MYSQL, MS Access

ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS), IBM AS/400

Scripting: HTML, DHTML, Shell scripting

Internet Tools: Internet Information Server (IIS 5.0 / 6.0), FTP, TCP/IP

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, WI

Power BI Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created SSIS packages for importing the Excel layouts into the database using SSIS.
• Used BIDS to design SSIS packages to transfer data between servers, load data into database, and archived data file from different DBMS. Scheduled the job to do this task periodically.
• Loaded data from ODS to data warehouse using SSIS packages.
• Used Power BI to design interactive reports and data visualization using Power BI Desktop.
• Developed Power BI reports and dashboards from multiple data sources using data blending.
• Explored data in a variety of ways and across multiple visualizations using Power BI. Strategic expertise in design of experiments, data collection, analysis and visualization.
• Used SSIS script tasks, look up transformations and data flow tasks using T-SQL, C# and Visual Basic scripts.
• Used multi-dimensional models such as star schemas and snow flake schema for developing cubes.
• Designed and developed matrix, tabular and parametric reports using SSRS 2012.
• Designed and developed drill down and drill through reports with drop down menu option using SSRS.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Wrote new stored procedures for new system and optimized old store procedures and functions on production server. Improved data load performance by analyzing database design and query plans.
• Modified and created joins to improve the database and execution speed.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Assisted in the implementation of a Confidential federal enterprise system by improving and connecting the existing metadata systems and built the next generation of metadata tools.
• Expert in data visualization development using Tableau to create complex, intuitive and innovative dashboards.
• Involved in performance tuning using SQL Server Profiler and SQL server hints.
• Created SSIS packages using SSIS Designer for exporting heterogeneous data from OLE DB Source and Excel spreadsheet to SQL Server 2012.
• Designed ETL packages dealing with different data sources (SQL Server, flat files, and XMLs, etc.) and loaded the data into target data sources by performing various kinds of transformations using SSIS.
• Conceptualized and Designed Logical and Physical Data Models using ERWIN.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created Complex ETL Packages using SSIS which upserts data from staging table to database tables.
• Worked on windows forms using C# .
• Interacted with business users and gathered the requirements.
• Consumed webservices to connect to sharepoint URL for accessing the word documents.
• Developed the functionality that inserts the text into excel cells using C# .
• Developed the text search functionality that gets content from word documents in sharepoint and display the results in List box.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• Involved in installation of Tableau desktop and Tableau server Application software
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.

Environment: Microsoft SQL Server SSRS, SSAS, SSIS 2014/ 2012/ 2008 R2/ 2008/ 2005, T-SQL, MySQL, PL/SQL, MS Visio 2008, SharePoint 2010, Tableau 8.3, Power BI 2013, C#, Windows Server, Power Map, Power Pivot, Power View, MS Office, Microsoft Visual Studio 2008, Reports Builder.

Confidential, Portland, OR

Power BI/SQL BI Developer

Responsibilities:

• Wrote complex SQL statements using joins, sub queries and correlated sub queries. Involved in creation of data modeling techniques.
• Analyzed complex queries and tune the same to optimize application and system performance to set up SQL Server configuration settings.
• Designed and developed monthly, quarterly and yearly reports at branch and bank level.
• Worked with full life cycle development of reporting projects, includes requirements gathering/analysis, design, development, testing and production rollover.
• Helped troubleshoot, performance tune reports and resolve issues with Tableau server and reports.
• Migrated existing data into the Power BI and created reports in Power BI preview portal utilizing the SSAS Tabular.
• Published Power BI desktop reports created in Report View to the Power BI service.
• Transformed and combined the data using Query Editor in Power BI.
• Worked with Power BI mobile app and created mobile layouts to view reports and dashboards effectively.
• Created Tableau wireframes for various lines of business.
• Worked closely with the business as Tableau SME to create the dashboards that were desired by them.
• Created SSIS packages using SSIS Designer for exporting heterogeneous data from OLE DB Source and Excel spreadsheet to SQL Server 2012.
• Coordinated with DBA in creating and managing tables, indexes, and triggers.
• Worked with Exception handling with @@error and with Try/catch.
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems.
• Deployed SSIS packages and Scheduled Jobs .
• Involved in Analyzing and integrating the data.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate, etc.
• Optimized long running stored procedures and queries for effective data retrieval.
• Was involved in converting DTS to SSIS and development and implementation of SSIS on an enterprise level.

Environment: SQL Server 2008/2012, T-SQL, Windows Server 2008, Power BI, SQL Profiler, SQL Server Reporting services, Visio

Confidential

Data Analyst/SQL/SSIS Developer

Responsibilities:

• Installed and configured SQL Server 2012 and SQL Server 2008R2.
• Analyzed and evaluated requests for reports and develop, created and modified procedures to extract data from various data sources and the corporate data warehouse using report writers and data extract tools.
• Participated in the data warehouse design and development team.
• Installed on-premise data gateway and scheduled daily data refresh in Power BI.
• Configured Power BI dashboard and reports.
• Conducted data analysis and designed and developed standardized management computer reporting tools.
• Provided decision support through reporting and data analysis supporting Confidential ’s internal and external data/information customers.
• Oversaw the operation and maintenance of the activities necessary to insure the timely production and dissemination of accurate reports and data and management information.
• Performed project-based analysis and the reporting data projects and executive ad hoc report requests.
• Created mapping documents and technical analysis on paper claims and Medicaid claims like UB04, UB92, and HCFA.
• Conducted ongoing requirement analysis for data needs for department/account managers and customers.
• Created data/reports specifications for IT technical for development using Crystal Reports.
• Ensured that the reports are created and generated accurately in a timely manner for review, analysis and subsequent submission to the customers.
• Conducted project based data analysis and ad hoc reporting.
• Involved in gathering the requirements from different health plans to create the reports.

Environment: MS SQL Server 2012/2008 R2 SSIS, SSRS, SSAS, Power BI, Visual Studio 2008, T- SQL, Crystal Reports, Performance point server 2010, Share point server 2010, Windows 2008 Server, Team Foundation Server, XMLA, MS Access, MS Excel, Cognos reports, Business Objects

Confidential

SQL Server Developer Intern

Responsibilities:

• Interacted with team in analysis, design and develop database using ER Diagram, involved in design, development and testing of the system.
• Developed SQL server stored procedures, tuned SQL queries (using indexes).
• Created and maintained SQL objects like Tables, Constraints, User defined Functions, Indexes, Views, Stored Procedures and SQL scripts, T-SQL queries for developer applications.
• Use SQL Indexes for improving query performance, lower storage and maintenance.
• Knowledge on Design and implement comprehensive Backup plan and disaster recovery strategies.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Implemented exceptional handling.
• Worked on client requirement and wrote complex SQL queries to generate Crystal Reports.
• Tuned and optimized SQL queries using Execution Plan and Profiler.
• Rebuilt indexes and tables as part of performance tuning exercise.
• Involved in performing database backup and recovery.
• Worked on documentation using MS word.

Environment: Windows SQL Server 2008/2005, Query Analyzer, Enterprise Manager, Import and Export and SQL Profiler