Summary:

• Over 7 years of full-time experience in Business Intelligence as BI Developer in data modeling, development and maintenance of database applications on SQL Server in OLTP/OLAP/BI environment.
• Expert in business intelligence using Microsoft technology: SQL Server 2012, SQL Server 2008, SQL Server 2005, Analysis Services SSAS , Integration Services SSIS , Reporting Services SSRS . Also, in basic level T-SQL advance level T-SQL in different version of SQL server.
• Well-versed knowledge of SQL profiler and Query analyzer to enhance performance of SQL server by tracing and tuning the query.
• Expertise in building complex cubes using SSAS SQL Server Analysis Services by implementing dimension table and fact table either form of Star schema or Snow-flex schema.
• Skilled in implementing Calculations, Perspective, and Key Performance Indicators KPI , also providing the cube solution in Excel file for slicing and dicing the data and analyze KPIs across various dimensions.
• Experienced in developing ETL packages using SSIS SQL Server Integrated Services. Developed those packages bringing data form various heterogeneous sources like: Oracle, SQL server and OLEDB sources. Also did transformations like Execute SQL Task, Conditional Split, Merge, Lookup, fuzzy Lookup and Slowly Changing Dimension while loading the data into destination.
• Good experience in maintaining batch Logging, Error logging with Event Handlers and configuring connection managers using SSIS. Packages. Plus implemented Checkpoints, Break points to make the packages dynamically work.
• Implement migration SQL Server databases, user logins, and DTS packages from one server to another with help of Configuration files.
• Highly skilled in designing complex reports such as Drill-down, Cascading, Matrix, cross tab and Map reports using SSRS SQL Server Reporting Services tools. Plus build ad-hoc reports using SSRS 2012/2008R2/2008 based on specific client or manager's requirements.
• Extensive experience in building and deploying complex packages like: File Share System, E-mail additionally has knowledge about Subscription and Snapshot.
• Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
• Detail-oriented, versatile adaptable in new environment, with strong interest in learning new technologies.
• Excellent Experience in installing, upgrading and configuring Microsoft SQL Server 2012/2008R2/2008/2005 and with 24/7 standby troubleshooting support.

Skillset:

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

Projects Summary:

Confidential

BI Developer SSIS, SSAS, SSRS

Responsibilities:

• Experienced in extracting data from various data sources like: Oracle and SQL server, raw file, flat file, Excel, and OLE DB sources from Client servers.
• Worked on different packages with various types of transformation tool like: Lookup, fuzzy Lookup, derived column, join, merge join, conditional split and slowly changing dimension.
• Expertise in troubleshooting ETL packages by implementing SSIS functionalities, like: breakpoints, checkpoints and event handler.
• Utilized configuration tables to update multiple SSIS packages simultaneously.
• Tune ETL procedures and STAR schemas to optimize load and query Performance.
• Prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.
• Experienced in using SSIS catalog, File System SQL Server deployment process to deploy ETL packages.
• Utilized configuration tables to update multiple SSIS packages simultaneously.
• Implemented Custom Logging, Auditing and custom Email notifications using SSIS.
• Build complex cubes using SSAS SQL Server Analysis Services by implementing dimension table and fact table either form of star schema or snow-flex schema.
• To analyze performance, used: Calculation, KPI, Derived column and hierarchy. Also created MDX Multidimensional Expressions scripts and built reports on top of cubes.
• Build regular ad-hoc reports using SSRS SQL Server Reporting Services with help of various tools such as Group by, Drill-down, Cascading, Summarized, Matrix, Map and Cross-join.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Designed and developed the reports according to the requirements using Tableau and Power Map.
• Involved in Installation, Configuration and Deployment of Reports using SSRS.
• Scheduled the reports to run on daily, weekly basis in the report manager.

Environment: MS Visio 2008, SQL Server 2012, Microsoft Visual Studio 2010, Windows 7, MS Office, Windows Server, SQL Server Integrated Services SSIS , SQL Server Analysis Services SSAS , SQL Server Reporting Services SSRS , SharePoint 2010, Oracle 8, Tableau 8.3, Power BI 2013.

Confidential

SQL Developer / BI Developer SSAS /SSRS

Responsibilities:

• Involved in the entire project life cycle SDLC , from requirements gathering to implementation.
• Identified information requirements for BI projects by developing conceptual data models, as part of a coordinated effort with management and subject matter experts.
• As part of a team including management and process owners, identified KPIs and analytic needs such as dashboards and scorecards.
• Utilized MDX queries to design and develop cubes with facts, multiple dimensions, KPIs, calculated members as well as hierarchies using SSAS.
• Analyzed prepared cubes for reporting requirements through slice and dice, drill-down, roll up, and pivot.
• Developed, designed and deployed matrix and tabular reports with drill-down and drill-through features using SSRS.
• Deployed patient reports to a report server using SSRS Configuration Manager and created individual subscriptions for patient appointment reminder by enabling event driven schedules.
• Created interactive dashboards by using SSRS 2008 R2 and Tableau 8.1.
• Integrated reports and dashboards within SharePoint 2010 from various reporting tools.
• Used SSRS to create well-formed reports and web-based reports for health related applications and transactions.

Environment: MS SQL Server 2008 R2, Tableau 8.1, Windows Server 2008, MS Excel, SharePoint 2010

Confidential

SQL Developer / ETL Developer

Responsibilities:

• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept.
• Involved in migration from SQL Server 2008R2 to SQL Server 2012.
• Developed SQL Server Stored Procedures, Tuned SQL Queries, also developed User Defined Functions and created Views, Triggers to maintain the Referential Integrity.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler. Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Created SSIS Packages to extract data from Excel Files, MS Access files using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Used Change Data Capture CDC to simplify ETL in data warehouse applications.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Expertise in configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Involved in performing database Backup and Recovery
• Prepare detailed statistical reports in Tableau and MS Excel to track progress of weekly, monthly and quarterly customers and sales growth.
• Trouble shoot problems with the sales terminal including network related issues.

Environment: Visio 2008, SQL Server 2012 and 2008R2, Windows 7, MS Office, Windows Server, Tableau 6.1/ 7.0, Oracle 8.

Confidential

MS SQL Developer / BI Developer

Responsibilities:

• As part of the team, worked closely with DBA's to develop database and data warehouse with installation, configuration, performance tuning, optimization, backup and recovery in SQL Server.
• Involved in creating Tables, Stored procedures, Views, Functions, Triggers, and user profiles in SQL server.
• Used SQL Profiler, Query Analyzer to enhance performance of SQL server by tracing and tuning the query.
• Developed simple or complex cubes in SSAS SQL Server Analysis Services with Dimension table and Fact table either form of Star schema or Snow-flex schema.
• Worked on developing cubes with Derived column, Aggregation, KPI for decision-making, Prospective, measures and hierarchy.
• Created MDX queries to retrieve data from cubes and also to display SSRS SQL Server reporting services.
• Proficient in creating ETL packages, extracting data from various heterogeneous sources like: Oracle and SQL server and transformed it using different transformation as Lookup, Fuzzy lookup and Slowly Changing Dimension SCD .
• Developed reports like: Tabular reports, Matrix, Drill down, Drill through, Cascading and Map using SSRS SQL Server reporting services.
• Created Ad-hoc reports and reports with complex formulas based on managers requirement or client requirement.
• Worked on to build deploy Reports, managing Subscriptions, and creating Snapshot also Report cache.
• Expertise in error handling. Making the packages dynamically work by implementing Checkpoints, Break points, Data Viewer, Securing packages and managers.
• In-depth knowledge of working and implementation of Crystal reports 9.0, Converting Crystal reports to SSRS SQL Server Reporting Services.

Environment: Visio 2008, SQL Server 2005/2008 SSIS, SSAS, SSRS , Windows XP, MS Office, MS Access, SharePoint 2010, Report Builder.