SUMMARY:

• 6 years of IT experience in all phases of Software Development Life Cycle (SDLC) and extensive experience in MS SQL Server 2008/2012 with Business Intelligence in SQL Server Reporting Services, SQL Server Integration Services and knowledge in SQL Server Analysis.
• Highly proficient in high level design of ETL SSIS packages for integrating data from heterogeneous sources (Excel, Xml, Oracle, flat file, Text Format Data) to MS SQL Server.
• Excellent T - SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Scheduled and monitored all maintenance activities of SQL Server to meet business requirement activities including database consistency check.
• Experience in ETL process using Integration Services (SSIS) SSIS Import Export Data, Bulk Insert, BCP and DTS/SSIS Packages and deploying and automate SSIS Packages and SSRS reports.
• Used Microsoft Power BI’s Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database and created few reports using Power BI.
• 3 years of experience in Tableau Desktop 10.x/9.x/8.x, Tableau Reader, Tableau Prep and experienced in analysis, modeling, design, and development of Tableau reports and dashboards for analytics.
• Expertise in creating different types reports such as Tabular, Matrix, Drill-Down, Drill through, Ad hoc, Cascaded parameterized, Chart report, Sub reports, Cross Tab Reports and Distributed Reports in multiple formats using SQL Server Reporting Services (SSRS).
• Expertise in creating Dashboards, stories and developing different charts styles including Bar Charts, Line Charts, Tree Maps, Gantts, Circle views, Scatter Plots, Bullet Graphs, Histograms, Heat Maps, Geo Maps, Text Graphs in Tableau desktop environment.
• Experience in creating advanced visualizations like lollipop model, donut model, sparkline model and developed reports using advanced analytics like Reference Lines, Reference Bands, Trend Lines, Box plots and Custom Geocoding.
• Responsible for requirement gathering and analysis and in charge of providing LOD for Tableau reports and dashboards.
• Familiar in Dimensional Modeling, ER Modeling, Data Marts, Star Schema / Snowflake Schema, FACT and Dimensional tables.
• Have knowledge about using Informatica tool.
• Prepared technical documentation.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

Database Management System: Microsoft SQL Server 2014/2012/ 2008 R2/2005/2000, MS Access, Oracle 10g

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

Reporting Tools: MS SQL Server Reporting Services(SSRS), Crystal Reports, Tableau desktop 10.x/9.x/8.x.

PROFESSIONAL EXPERIENCE:

Confidential, Newport Beach, CA

SQL BI/ Tableau Developer

• Extensively involved in the full lifecycle of ETL software development - analysis, design, build, documentation and testing for the project using SQL Server Integration services.
• Responsible for performance tuning and optimization of SQL queries and indexes.
• Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using SQL Server Integration Services (SSIS) 2012.
• Scheduled the jobs to streamline and automate cumbersome repeated tasks using SSIS.
• Created and maintained databases, tables, stored procedures, indexes, database check constraints, and business rules using T-SQL.
• Developed complex T-SQL queries for the ETL packages.
• Designed packages in SSIS 2012 with various complex transformations.
• Designed and created views for security purposes, implemented rules, defaults, user defined data types, documented the table relationships with diagrams.
• Used Script component, Conditional split, Multicast, Lookup transformation for business validations.
• Used SSIS to create ETL packages to validate, extract, transform and load data to excel and csv files.
• Involved in client meetings to gather business requirements.
• Scheduled jobs on daily, monthly and quarterly basis and using Active Batch.
• Did unit test for SSIS packages and stored procedure.
• Involved in Exploring, Designing, Building, and Deployment of the high-level dashboards for decision making of critical metrics using Tableau.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Used data sources from SQL, Oracle, SSAS cubes and files to generate reports in Tableau.

Confidential, Tustin, CA

SQL BI/ Tableau Developer

• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for generating reports using SSRS.
• Designed, Developed and Deployed custom reports in MS SQL Server environment using SQL Server Reporting Services 2012.
• Designed packages in SSIS with various complex transformations.
• Designed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, Charts and Sub reports.
• Designed and created views for security purposes, implemented rules, defaults, user defined data types, documented the table relationships with diagrams.
• Wrote the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Designed and created views for security purposes, implemented rules, defaults, user defined data types, documented the table relationships with diagrams.
• Responsible for deploying reports to report manager and troubleshooting for any error occurs in execution.
• Dashboard encompasses various types of charts like bar graphs, line graphs, word cloud with filters and actions.
• Incorporated user level security, which allows employees to see their own data, and managers to see data of just their reportees.
• Developed functionality to show hierarchies in tableau for all levels of employees.
• Created Heat Map showing sales by color that were broken into regions allowing business user to understand where we have most sales vs. least sales.
• Created dashboard using parameters, sets, groups and calculations.
• Created drill down and drill up in worksheets.
• Involved in creating a dual-axis bar chart with multiple measures.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, SQL Server and MS Excel.

Confidential, Costa Mesa, CA

SQL BI Developer

• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Generated reports using Expressions and Functions using SSRS.
• Generated various reports like Matrix reports, Tabular reports, and Chart reports, link Reports, Drill down reports, parameterized.
• Involved to optimize stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS.
• Created automated stored procedures for day end operations using SQL Server agent.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS.
• Implemented failure alerts using email in SSIS.
• Snapshot Replication was being used to synchronize the data between their Different Stores.
• Involved in SQL Server Mirroring and Database optimization.
• Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.
• Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
• Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SQL Server 2008 Analysis Services (SSAS).
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Developed Query for generating drill down reports in SSRS 2008. Prepared AD HOC reports through MSXL using crystal reports.
• Created Windows Logins and privileges to User Accounts/Groups and objects.
• Created Technical and Functional documents including detailed description and screenshots showing functioning of the package.

Confidential, Foothill Ranch, CA

SQL Developer

• Plan, design, and implement application database code objects such as stored procedures and views.
• Provide database coding to support business applications using T-SQL.
• Perform quality assurance and testing of SQL server environment.
• Develop new processes to facilitate import and normalization, including data files for counterparties.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.
• Trained and mentored EBI team, users and assisted and coached them in material, processes and delivery of training, training standards and best practices.
• Interacted with report owners to establish/clarify their requirements and developed report specifications.
• Performed development activities from gathering requirements and designing solutions, through developing code/ reports, to testing and release / deployment