SUMMARY:

• 7 years of IT experience in all phases of Software Development Life Cycle (SDLC) with expertise in ETL Tools, Microsoft Business Intelligence Suite - SQL Server Integration Services ( SSIS ), SQL Server Reporting Services ( SSRS ), Alteryx, Tableau, Python and knowledge in SQL Server Analysis Service( SSAS ).
• 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.
• 2+ years of experience in Alteryx platform, and involved in data preparation, data blending, and the creation of data models, data sets using Alteryx.
• 5+ years in SSIS with high proficiency in design of ETL SSIS packages for integrating data from heterogeneous sources (Excel, Xml, Oracle, flat file, Text Format Data) to MS SQL Server.
• 5+ years in SSRS with Expertise in creating different types of reports such as Tabular, Matrix, Drill-Down, Drill through, Ad hoc, Cascaded parameterized, Chart report, Sub reports, Cross Tab Reports, Distributed Reports in multiple formats using SSRS.
• 1+ years of experience in Python with writing scripts for ETL tasks.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience working on Oracle Databases (9i/10g) with strong PL/SQL skills and proficiency in RICE (Reports, Interfaces, Conversions, Enhancements) components, Oracle forms, Workflow Builder, Discoverer, XML Publisher.
• Responsible for designing, building, and testing workflows in Alteryx .
• 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 and advanced visualizations like lollipop model, donut model, sparkline model and developed reports and using advanced analytics like Reference Lines, Reference Bands, Trend Lines, Box plots and Custom Geocoding in Tableau desktop environment.
• Familiar in Dimensional Modeling, ER Modeling, Data Marts, Star / Snowflake Schema, FACT and Dimensional tables.
• Experience working with Agile Methodology, Sprint Planning, Scrums, and Jira Atlassian Software for user story/tasks.
• Strong written and oral communication skills, self-motivated, focused, creative, quick learner, ability to work with minimal supervision , adaptive to new technologies and platforms, passionate about solving business problems.

TECHNICAL SKILLS:

• SQL Server 2014/2012/2008, TSQL
• Oracle 10g, PL/SQL, Sybase, MS Access
• SSIS, SSRS
• Mongodb NoSQL
• Tableau
• Alteryx
• Visual Studio 2012/2015, JIRA, ServiceNow
• Python, C#, Unix Scripting

PROFESSIONAL EXPERIENCE:

Confidential, Newport Beach, CA

MSBI/Tableau/Alteryx Developer

Responsibilities:

• Developed code, reviewed, fixed bugs, tested and deployed SSIS packages using SQL Server 2014/2012 Business Intelligence Development Studio.
• Created SSIS packages to get data from different sources, consolidated and merged into one single source.
• Processed issuers, securities financial data from Bloomberg and integrated into SQL Server using SSIS .
• Scheduled jobs to streamline and automate cumbersome repeated tasks using SSIS.
• Used SSIS to create ETL packages to validate, extract, transform and load data to excel and csv files.
• Used Script component, Conditional split, Multicast, Lookup transformation for business validations.
• Developed SSRS reports from different data sources with consistent drill-down functionality including Drilldown and Summary reports.
• Responsible for deploying reports to report manager and troubleshooting for any error that occurs in execution.
• Designed and developed ETL workflows and datasets in Alteryx.
• Used Alteryx for Data Preparation and then Tableau for Visualization and Reporting.
• Processed data in Alteryx to create TDE for tableau reporting.
• Involved in Exploring, Designing, Building, and Deployment of the high-level and rich dashboards for decision making of critical metrics using Tableau.
• Written Python scripts to sync most frequently used tables from Oracle Production DB server to Mongodb, which is read by web services for downstream apps consumption.
• Involved in database design and creation of tables, stored procedures, indexes, database check constraints, and business rules using T-SQL, and responsible for performance tuning and optimization of SQL queries and indexes.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.

Confidential, Tustin, CA

MSBI/Tableau Developer

Responsibilities:

• Designed, Developed and Deployed custom reports in SQL Server environment using SQL Server Reporting Services.
• Wrote the ETL scripts and SSIS packages to load the data into database from various source files. Experience in error handling and troubleshooting the scripts failure, to load the data into database.
• Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.
• Designed different types of SSRS reports including Tabular forms, Matrix (cross Tab report) form, Conditional, Charts and Sub reports.
• Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.
• Responsible for deploying reports to report manager and troubleshooting for any error occurs in execution.
• Used ETL to implement the Slowly Changing Transformation, to maintain historical data.
• 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 and created 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

MSBI/Database Developer

Responsibilities:

• Successfully transferred inbound data from various sources like flat files, Access and Excel into database using SSIS.
• Created packages in SSIS with custom error handling, email alerts and worked with different methods of logging in SSIS.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Generated reports using Expressions and Functions using SSRS.
• Created T-SQL Stored Procedures, Triggers, Functions and performance tuning, maintenance of data integrity.
• Created Technical, Functional documents with detail description and screenshots showing functioning of the packages.

Confidential, Lake Forest, CA

PLSQL Database Developer

Responsibilities:

• Worked as a PL/SQL Developer in building the Order to Cash and Procure to Pay cycles, and involved in writing PL/SQL Triggers, Procedures, Functions, Packages and performance tuning.
• Developed Custom BI / XML Publisher reports for On-Hand-Quantity available for all the items in every Sub-Inventory, which belonged to a particular Organization in the Inventory module .
• Developed Custom Reports such as Service Contracts by Status Report, Service Contracts Detail Report, and Service Contract Forecast Management Report using Reports 6i.
• Developed PL/SQL Procedures to convert data in custom tables to service contracts using Service Contracts API.
• Designed and developed custom reports as per the business requirements using XML Publisher like invoice, Purchase Order, Payment status and sales order acknowledgement reports.