SUMMARY

• Over 9+ years of extensive IT experience in the Development, Implementation and Support ofSQLServer, T - SQLprogramming.
• Experience in SQLServer Programming, Analysis Services and Reporting services.
• Hands on Experience in Installing, Configuring, Managing, Monitoring and TroubleshootingSQL Server.
• Experience in Data Warehouse Development environment using Microsoft DTS, SSIS and SSRS.
• Experience in BI Development and Deployment of DTS, SSIS packages from flat files, Excel.
• Using Tableau server as a front-end BI tool and MicrosoftSQLServer as a back-end database designed and developed workbooks, dashboards, global filter page, and complex parameters based calculations.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experience in usingSQLserver reporting Services (SSRS) and creating various reports such as Parameterized, Cascading, Tabular, Matrix, Chart and Drill down reports.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users inSQLServer Reporting Services (SSRS).
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimensions usingSQLServer Analysis Services.
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
• Experience in creating and managing SSAS Tabular models, creating Dimension Tables and Fact Tables.
• Good Business and System analysis skills to understand the requirements and customize client applications.
• Excellent Transact-SQL/ T-SQL, PL/SQL(DDL/DML) programming skills using complex Stored Procedures, effective functions, Views, Indexes, appropriate Triggers with optimized Performance Tuning etc.
• Good Experience in using tools like index Tuning Wizard,SQLProfiler, and Windows Performance Monitor for Monitoring and Tuning MSSQLServer Performance.
• Expertise in Business Intelligence Process for Data Integration and Migration services.
• Experience in using Microsoft .NET framework forSQLServer Integration Services (SSIS) packages for logging programmatically and managing, automating Control flow, Data flow and Events.
• Experience in creating jobs,SQLMail Agent, Alerts and schedule SSIS Packages. Experience in transformation data from DB2 toSQLServer.
• Hands on experience in all phases of SDLC (Software Development Life Cycle) and Relational Database Architectures.
• Involved actively on Data Quality Process (Data QA) to avoid data bypassing in the EDW (Enterprises Data Warehouse) and ETL (Extraction, Transformation and Loading) processes.
• Experience in documenting all phases of system QA processes.
• Involved in analysis and creation of the databases relationships using ER (Entity Relationship) diagrams.
• Extensive experience in Microsoft T-SQL/PL-SQL statements (DDL and DML) including features like Temporary Tables, Ranking Functions, Joins, Pivot, For XML path, CTE, While Loops etc.
• Well-versed in using database objects like Batch Scripts, Stored Procedures, Triggers, Views, Cursors, Indexes and User Defined Functions consumed at various stages of Migration/Cleansing process, Reports or Data Validation.
• Experience in creating and managing Clustered and Non-Clustered Indexes to improve database performance.
• Good knowledge of Normalization/De-Normalization, Data Design methodology and building Referential Integrity for the relational Database Model.
• Experienced in database administration work such as setting SQL Server Agent jobs for backups, developing high availability solutions through Replication, Mirroring, Creating Maintenance Plans, and Maintaining Database Security etc.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DMV’s, DMFs and Query Execution Plans.
• Experience in SQL Server installing, Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Check using DBCC commands.
• Expertise in data mining concepts like Building Cubes and Dimension Modeling, creating Data Marts, Kimball / Inman Methodologies, Star / Snowflakes Schemas with different architectures and data sources using SSAS.
• Experienced in building cube starting from scratch and their deployment.
• Experienced in performance optimization of SSAS cubes using Partitions, Hierarchies and Attribute Relationships.
• Good knowledge of ADX/MDX Scripting to perform various tasks including creating Calculated Members.
• Experienced in extracting, transforming and loading (ETL) data, from different Heterogeneous Data sources like MS Access, Flat File, Excel and Oracle, to MS SQL Server using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and Bulk Copy Program utility.
• Involved in migration project of DTS Packages (2000) to SSIS (2005) and troubleshoot any migration issues.
• Experienced in creating Logging, Break Points, Check Points, and use Error Handler in SSIS and automating the ETL process.
• Expertise in designing SSIS packages to Import and Transform Data between Databases and External Data Sources.
• Excellent knowledge and experience of creating Jobs, Alerts, SQL Mail Agent, using various Control flow items (such as Execute package task, Execute Process Task, Script Task, FTP Task, Send Email Task, For Loop Container, For each Loop Container etc.) and various Data Flow Transformations (such as Derived columns, Conditional split, Lookup, Merge Join, Data Conversion, Fuzzy Lookup, Fuzzy Grouping, Pivot etc).
• Experienced in Deploying SSIS packages using Manifest files and Import/Export Wizard while creating various Configuration Files to make the packages work in various environments.
• Worked with different types of transformations like Blocking, Semi-Blocking and Non-Blocking Transformations.
• Experienced in Monitoring and Scheduling ETL processes using DTS EXEC utilities and batch files.
• Involved with Performance Tuning of SSIS packages.
• Experienced in configuring and maintaining Report Manager, Report Server and Repot Builder for SQL Server Reporting Services (SSRS).
• Knowledgeable about other aspects of reporting service such as Report Authoring, Report Management, Report Delivery and Report Security.
• Assisted in the scheduling the reports to refresh and run on daily, weekly and monthly basis and deployment of the reports using Direct deployment and Uploading files using the Report Manger.
• Involved in integration of SSRS Reports using various web parts into SharePoint (MOSS 2007) and Performance Point 2010 and Dashboards.
• Expertise in data mining concepts like Building Cubes and Dimension Modeling, creating Data Marts, Kimball / Inman Methodologies, Star / Snowflakes Schemas with different architectures and data sources using SSAS.
• Experienced in building cube starting from scratch and their deployment.
• Experienced in performance optimization of SSAS cubes using Partitions, Hierarchies and Attribute Relationships.
• Good knowledge of ADX/MDX Scripting to perform various tasks including creating Calculated Members.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2000/2005/2008/2008 R2/2012, Access 2000/2003, ORACLE

Languages: T-SQL, MDX, VB Script, PL-SQL

Developer Tools: SQL Server Management Studio, Business Intelligence Development Studio (BIDS), SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, Visual Studio 2005/2008, BCP, Team Foundation Server (TFS)

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

Reporting Tools: SQL Server Reporting Services (SSRS)/COGNOS 10

Analysis Tools: SQL Server Analysis Services (SSAS)

Data Modeling: MS Visio 2000/2007/2010 , ERWIN 7.1, ERWIN 4.1

Operating Systems: Windows NT/ 98/2000/2003 Server XP/Vista, UNIX, Linux

Web Technologies: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Senior SQL Developer

Responsibilities:

• Responsible for maintaining the CMC/CMS for the entireBIdeployment that had 300 users in stage and production.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Evaluate and analyze existing OLTP databases and develop/maintain integrations to data warehouse. Understand OLTP vs OLAP.
• Build and deploy ssas OLAP cubes, KPI, Partition and, Perspectives.
• Write MDX on cube to build SSRS reports.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard.
• Defined best practices for Tableau report development. Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Using Tableau developed dash boards for executive display of vacancy/occupancy.
• Installed and configured BI4.1 and migrated BOBJ3.1 toBI4.1 using upgrade Management tool.
• Used Promotion Management tool to migrate the objects from Dev to QA to Production.
• Responsible for the migration of the entire Business Objects Content from XIR3.1 to R4 from the old environment to the new.
• Worked with report conversion tools to convert reports from DeskI to WebI.
• Provided production support during various time zones for business users in resolving data discrepancy and formatting issues.
• Resolved user tickets in a timely fashion and supported business by creating new users and managing user rights of existing users.

Environment: Windows 2010, SQL Server 2015, Business Objects XIR3,BI4.1, Crystal Reports 2011, Tomcat7, Tableau 9.3

BI Reporting Analyst

Responsibilities:

• Assist with the integration of a corporate merger by designing couple reports showing system usage to help client understand itsreportingsystem. Inventoried and compared hundreds of reports from both companies that are merging. Found the matching reports and gave advice for the creation of new reports to meet both companies' business needs. Led newreportingsystem development.
• Build thereportingportal for marketing and sales team in CRM. This business intelligence portal includes dashboards and linked detail reports that provide all key information in one place.
• Build the POWERBIReportingsystem for client from scratch, which included setting up the PowerBIstructure, writing stored procedures to get data asreportingsource, data modeling, visualization designation and reports, as well as, dashboard developing and publishing.
• Be responsible for requirements gathering, analysis, design, implementation, validation, and maintenance of ad-hoc and automated reports focused on understanding product usage and core business operations.
• Construct dashboards and reports to provide key insights and metrics, using a variety ofreporting tools (e.g., PowerBI, Excel, Tableau, etc.) depending on the needs of the project.

Environment: MS SQL Server 2008, Integration Services (SSIS),ReportingServices (SSRS), T-SQL, PowerBI, Excel.

Data Analyst/Reporting BI expert

Responsibilities:

• Created Several SSIS/ETL packages to load data from various sources like Teradata and DB2 and SQL.
• Created various kinds of reports using SSRS for various users.
• Major involvement in migration of the servers and upgrading of servers from VS 2010 to VS 2013 and SQL 2012 to SQL 2014.
• Migration of ETL Packages from .
• Involved in creating reports in SSRS 2012 for both Relational and Multidimensional.
• Developed parameterized reports and cascading parameter reports using MDX queries (to pull data from SSAS cubes).
• Used Tableau to generate reports for analysis and statistics.
• Also Developed Drill Down, Drill Through and Sub Reports.
• Unit Tested and Deployed reports onto the server.
• Created SSIS packages to load data into tables.
• Used SSAS cube browser for reports datasets and analysis.

Environment: MS SQL Server 2012, SSMS, MS SQL Server Integration/Reporting Services/Analysis Services 2012(SSIS/SSRS/SSAS), Windows 7 Enterprise, Tableau.

Confidential - Deerfield, IL

SQL Server Developer (Microsoft BI)

Responsibilities:

• Analyzed specifications provided by the client.
• Managed, created and altered Databases, Tables, Views, Indexes and Constraints with business rules using T-SQL.
• Created complex Stored Procedures, Triggers and User Defined Functions to support the front-end application.
• Used various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column and Data Conversion Transformations.
• Worked on performance tuning, query optimization and execution plan of queries for better performance.
• Conducted and automated the ETL operations to extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the multi-dimensional data warehouse.
• Extensively used SSIS for Transformations, Aggregations and Lookups.
• Monitored the data warehouse system to maintain periodic data.
• Scheduled the SSIS packages and Jobs.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Created Cross-Tab reports, Summary reports by using SSRS and designed reports using Crystal Reports.
• Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder,SQL server Reporting Services (SSRS) 2012.

Environment: SQL2012, DB2, MS Access, Query Analyzer, Visual Studio 2012, C#, ASP.NET.

Confidential - Sacramento, CA

BI Developer/Business Analyst

Responsibilities:

• Lead development and maintenance of operational, analytic, dashboard and executive-level reporting using Pentaho, SSRS, SSIS.
• Interact with functional business units to analyze, gather and prioritize business and reporting requirements.
• Formulated and provided status updates on project plans and schedules to meet goals/objectives and assumed leadership role in design, implementation, testing, and roll-out of enterprise data warehouse and data marts including development of proof-of-concepts.
• Created and enforced corporate standards for data warehouse design and data integrity and ensured data architecture supports existing and future requirements of evolving business model.
• Evaluate and analyze existing OLTP databases and develop/maintain integrations to data warehouse. Understand OLTP vs OLAP.
• Evaluate, test and assist in selection of Reporting andBItools.
• Monitor and stay abreast of key developments inBIindustry.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Transferred data from various data sources / business systems including MS Excel, MS Access, and Flat Files etc. to SQL server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Designed Dynamic SSIS Packages to transfer data crossing between platforms, validate data during transferring and archived data files for different DBMS.
• Involved in User Acceptance Training (UAT) with user to create reports using Report Builder tool.
• Generated reports using Global Variables, Expressions and Functions for the reports.
• Used various SSIS transformations like Conditional Split, Multicast, Fuzzy look up etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into Data warehouse.
• Created customized reports using various chart types like Text Tables, Bar, Pie, Tree Maps, Line Charts, Pivot Tables in Excel and Tableau.
• Created cubes with Start schema in SSAS and developed SSRS report based on the cubes.
• Used performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters for the analysis of Performance using SSRS.

Environment: MS SQL Server 2014/2012, T-SQL, SQL Server Data Tools, SSIS, SSRS, MS Excel, Unix, Linux, SQL Agent, Git, Microsoft Visual Studio 2014/2012, SharePoint, Oracle 11g, SQLDeveloper.