SUMMARY

• 7 years of experience as SQL Business Intelligence Developer in SQL - BI suite comprising of SQL Server Integration Services (SSIS)/ SQL Server Analysis Services (SSAS)/SQL Server Reporting Services (SSRS) along with professional database design, development and maintenance of MS SQL Server 2014/2012/2008 r2/2008/2005 and Oracle 11g/10g.
• Over 4 years of experience as a Tableau/Power BI developer with extensive knowledge of delivering user-friendly visualization solutions to clients.
• Diverse experience in delivering business intelligence (BI) and analytic solutions, including SQL Server Analysis Services (SSAS), Microsoft Power BI and Tableau Dashboards and Stories.
• Proficiency in using SQL Server to develop T-SQL statements and SQL objects including Store Procedure, Trigger, Table, User Defined Function, View, SQL Joins, and implementing performance based query writing skills.
• Steady knowledge in normalizing and de-normalizing tables to maintain referential integrity by using primary and foreign keys; thorough understanding and experience in Data Warehouse and Data Mart design, Star Schema, Snow Flake Schema concepts and principles.
• Solid experience in using TOAD for Oracle to develop and manage database items including table, view, function, stored procedure, index, and partition of tables by P/L SQL.
• Experience in SQL query optimization techniques and debugging SQL commands.
• Experience in installing and configuring SQL Server Database and Oracle Database.
• Expertise in using SQL Server Analysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality and creating cubes with measures and calculated columns with MDX.
• Proven ability in utilizing ETL Tools including SQL Server Integration Services (SSIS) to load data into Data warehouse from heterogeneous databases like Flat Files, Excel, and SQL Server.
• Proficiency in developing and deploying various reports like drill down, drill through, Sub reports, and Parameterized reports using MS SQL Server Reporting Services (SSRS).
• Experience in creating ad-hoc reports by using Excel, SharePoint and Report Builder in SSRS 2012/2008r 2/2008/2005.
• Expert on delivering efficient and direct to point visualizing business solution through Microsoft Power BI. Give end user dynamic powers over customizing solutions to meet their business needs.
• Efficiently load, combine, refine, and clean data from various sources through Power Query; created relationships, measures, calculated columns, filters, charts with DAX in PowerPivot.
• Experience on configuring SharePoint farm, managing team site, and creating workflow.
• Solid experience working with Tableau to meet clients’ requirements, including creating visuals, building dashboards, and customizing reports.
• Proficiency in using Tableau functions including data blending, actions, and parameters to design complex dashboards to give clients’ full understanding of all aspects of information.
• Experience in Software Development Life Cycle (SDLC) methods like Agile and Waterfall.
• Experienced in efficiently working with cross-functional team as a liaison to connect technique team and functional team. Highly skilled working as an individual as well as in a team.
• Able to multitask and set priorities in delivering and meeting project deadlines.
• Excellent interpersonal communication, problem solving, documentation and business analytical skills with an ability to adapt new technology quickly and a strong team player.

TECHNICAL SKILLS

• MS SQL Server 2014/2012/2008 R2/2008/2005
• Oracle 11g/10g
• TOAD 11
• Visual Studio 2012/2010
• SQL Server Management Studio
• SQL Server Integration Services(SSIS)/SQL Server Analysis Services(SSAS)/SQL Server Reporting Services(SSRS)
• PowerPivot
• Power Query
• Windows 8/7/XP
• MS VISIO
• SQL Profiler
• SQL Query Analyzer
• T-SQL
• P/L SQL
• MDX
• DAX
• SQL Tuning Advisor
• C
• MS Access
• MS Office Suite
• Tableau 8.1/8.0
• SharePoint 2013/2010
• Palisades Decision Tools
• SAP ERP
• SourceControl
• JIRA
• TFS

PROFESSIONAL EXPERIENCE

Confidential, Brentwood, TN

BI Developer/ Dashboard Expert/ Report Developer/SSAS

Responsibilities:

• Created and maintained Oracle database objects such as tables, views, indexes, and stored procedures with P/L SQL on TOAD 11.
• Modified, organized, and reloaded legacy data to new tables; developed partitioning tables to improve database objects’ efficiency.
• Developed advanced SSAS models with multiple cubes; updated fact tables to keep redundancy minimal.
• Implemented measures and calculation columns with complex MDX queries.
• Designed SSAS model relationships among tables to build dimensions.
• Deployed and scheduled running, auto-refresh of SSAS projects. Loaded and checked-in SSAS projects to SourceControl to avoid concurrency, maximized team-work effort, and synchronized local and server’s latest version.
• Applied business intelligent solution by using Microsoft Power BI.
• Built profound Microsoft PowerPivot models with varied data sources, such as Oracle Database, MS SQL Server, Access, and Excel files.
• Transformed and automated data sources by Power Query; applied activities, such as integrate, duplicate, de-duplicate, add primary and foreign keys, and design index to merge and sharp data sources for further analysis.
• Created PowerPivot measures and calculate columns with advance DAX queries. Set up filters to give end users dynamic power over information.
• Designed visual and graphic solutions, providing efficient and direct to point information helps end users make critical operational decisions. Such solutions include such as PowerPivot Dashboard with drill down categories, Power Chart linked to detailed information, and intelligent timeline empowers end users see both full picture and details of the business.
• Deployed Dashboards to SharePoint, assigned authentication of the items, and granted access to selected groups of users.
• Created SSRS Reports, such as drilled-down, drilled-through, and parameterized reports, with P/L Query to pull data from Oracle Database.
• Deployed SSRS reports to Report Server. Added reporting items to database through TOAD. Synchronized Report Center with the deployed SSRS reports. Granted access groups to reports.
• Extracted and transformed source data by SSIS. Soundly used SSIS transformations, such as Fuzzy Lookup, Conditional Split, Merge, Union All, and Derived Column.
• Deployed SSIS package with both Project Deployment Model and Package Deployment Model. Set up environment in SSISDB Catalog. Created SQL Server Agent jobs for auto-run SSIS package, such as SSAS cubes’ refreshment.
• Benchmarked dashboards and reports with query results from database and debugged unmatched results among reports and dashboards based on different sources.
• Worked closely with end users with little technical background. Translated requests to BI designing plans and delivered solutions meet end users’ needs.

Environment: Oracle 11g, TOAD for Oracle, Microsoft Visual Studio 2012, Microsoft Management Studio, SSIS, SSRS, SSAS, PowerPivot, Power BI, SharePoint, SourceControl, P/L SQL, T-SQL, MDX, DAX, Excel

Confidential, North Brunswick, NJ

SQL Server/Tableau Developer

Responsibilities:

• Created and maintained database for the company’s daily operation.
• Used SSIS to extract data of orders, freight schedule, and account payable every day from various sources such as Flat File, Excel, and other Relational Databases, and inserted them into SQL server database.
• Developed, modified and upgraded Stored Procedures based on changes made in operation to maintain data processing quickly and efficiently.
• Created views for the most retrieved data sets to make sure every team member has easy access to updated key data sets.
• Monitored SQL server database and assisted solving SQL server related issues.
• Scheduled ETL (Extract, Transform, and Load) process to populate Data Marts.
• Summarized, converted, and distributed data based on data values by using SSIS.
• Used Event Handler, and Custom Logging to created Logging, Error Handling for SSIS Packages.
• Created Gauge Report, Sub-Reports, Drilldown-Reports, Summary Reports, Linked Reports, and Parameterized Reports in SSRS and Tableau for different departments.
• Extracted data from Flat File, Excel, and Relational Databased to generate reports in Tableau.
• Created Tableau worksheets of quarterly financial and operational reports, and implemented the business logic by customization. Compiled worksheets into dashboards to give clients a clear understanding of quarterly performance.
• Highly involved in configuring Service on Server, member permission, and Configured SharePoint farms, created team sites and monitored workflow. Also configured documents properties and set alerts on files based on requirements.
• Embedded Tableau views into SharePoint.

Environment: MS SQL Server 2012, T-SQL, SSIS 2012/2010, SSRS 2012/2010, SharePoint 2013/2010, Tableau 8.1/8.0, MS Excel, MS Access

Confidential, McLean, VA

MS SQL Server / Tableau Developer

Responsibilities:

• Used SSIS to extract data from different sources, including Excel and Access.
• Used ETL tools such as IBM WebSphere DataStage and Talend to extract data from Teradata database, to the target Databases, Flat Files, and CSV Files.
• Used Teradata utilities like BTEQ, MLOAD, FLOAD, and TPump. Involved in importing and exporting the data from tables using the Teradata utilities.
• Created SSAS cubes with multiple fact measure groups and multi-dimension hierarchies based on the OLAP Reporting needs. Designed fact and dimension tables, and defined fact relationships.
• Created SSAS solutions, including KPI, Calculation, and Aggregation.
• Involved in requirements gathering and analysis in support of defining Tableau interactive Dashboards, as well as data quality analysis for cleansing and developed ETL specifications.
• Created reports, including Drill-Down Reports, Drill Through Reports, Parameterized Reports, and Linked Reports by SSIS and Tableau.
• Generated data into Tableau from data sources, such as Excel, Access, and SQL Server.
• Generated Tableau Dashboards and Reports for performance of Individual Accounts and Small Business Accounts with trending lines and reference lines.
• Efficiently used data blending, embedded functionalities, and defined best practices for Tableau report development.
• Created several Ad-hoc reports in both SharePoint and Tableau.
• Scheduled and published dashboards from Tableau Server on bi-weekly basis.
• Wrote complex SQL scripts in DB2 for testing data qualify and validation.

Environment: MS SQL Server 2008r2, Teradata, SSRS 2010, SSIS 2010, SSAS 2010, Tableau 8.0/7.0, SharePoint 2010, MS Excel

Confidential, San Francisco, CA

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Involved in performance tuning of existing database objects like complex stored procedures.
• Worked on troubleshooting and problem solving of SQL development and created log for each Stored Procedure.
• Wrote SQL joins and functions to assist database processing quickly.
• Designed dynamic SSIS Packages to transfer data between servers, load data into Database and tuned the existing package.
• Optimized and modified existed stored procedure by monitoring through SQL profiler.
• Worked with SQL in-built functions and user defined functions including scalar and table valued functions.
• Created views for extracting a specific set of data using different procedures
• Implemented database management techniques that include backup/restore, import/export and generated scripts.
• Exported and imported data from sources such as flat files using ETL transformation through SSIS
• Designed user defined hierarchies (parent-child hierarchies) along with attribute hierarchies.
• Normalized and de-normalized tables to maintain referential integrity by using Primary and Foreign Keys.
• Supported team in resolving SQL Reporting services and T-SQL related issues.
• Proficient in creating and formatting various reports such as drill down, drill through, sub reports and parameterized reports.

Environment: Windows 7, SQL Server 2008r2, SSIS 2010, SSRS 2010, T-SQL

Confidential, Rogers, AR

MS SQL Server/BI Developer

Responsibilities:

• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Created Databases, Schemas, Tables, Views, Indexes.
• Wrote complex stored procedures, queries, triggers.
• Formatted the reports using the Global variables and expressions.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area and Price-Range.
• Developed OLAP Cubes by using SQL server Analysis (SSAS), worked on Performance tuning of SSAS Cubes.
• Involved in SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data mining Models, and developing reports using MDX and SQL.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and name queries.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Server Reporting Services (SSRS).

Environment: MS SQL Server 2008r2, SSIS 2008, SSRS 2008, SSAS 2008

Confidential, Columbus, OH

MS SQL Server/BI Developer

Responsibilities:

• Designed and implemented stored procedures and triggers for automating tasks.
• Developed flowcharts for complex stored procedures.
• Loading data from various sources to SQL Server database using SSIS package.
• Involved in writing SQL statements which includes joins and functions.
• Implemented complicated transactions for the existing tables.
• Used common table expressions for better performance in executing commands.
• Worked with SQL System Defined Functions and User Defined Functions.
• Used table variables in stored procedures to simplify complex queries.
• Used SSIS to build high performance data integration solutions, including Extraction, Transformation and Load (ETL) packages and also scheduled the SSIS packages and jobs.
• Involved in improving the performance of the system by implementing indexes.
• Developed tables, views, stored procedures and executed several optimized queries in SQL.
• Pulled data from flat files, excel, and Access using SSIS package.
• Highly involved in creating, structuring, formatting reports using Report Designer and Report Builder.
• Developed customized reports for each department, including Scheduling, Financial, Customer Satisfaction, and Cargo Shipment.

Environment: SQL Server 2008r2, T-SQL, Integration Services, Windows 7, BIDS, SSRS 2008