SUMMARY

• Developed Tableau Dashboards for global company used by management for controlling critical metrics.
• Developed efficient ETL strategy that handles updates a procumbent and suppliers changes every 15 minutes.
• Re - wrote an ETL process that helps supply planners to avoid manual intervention in their weekly process.
• Added calculations in Analysis Services Cubes which increases time efficiency by 6 % for demand planners.
• Developed Report that depicts production process & movement that saves time and avoids using 3rd party tools.
• Developed a Report that shows for supply, material and finished goods availability for back end and front end planners on a single point and helped the company to earn more profit.
• Involved in a team at Confidential Tech. that has got appreciation for taking lead in adopting new processes. e.g. Agile
• Worked for Confidential Tech, global company and holds about 26,000 patents in IT industry, metrics and analytics team as Business intelligence Developer capacity .

CORE SKILLS

• Microsoft SQL Server 2008/R2/2012/2014
• System Development Life Cycle
• Business Analysis
• Data Analysis and Modeling
• Big Data {Mongo}/OO programming
• Problem Solving
• Programming-C#,VB.NET, .NET and C++
• Project Management-Agile/Scrum
• Communication
• Web Programming-ASP.Net/MVC,HTML,XML
• Active Batch, Visual studio, TFS, SSDT
• Detail Oriented

PROFESSIONAL EXPERIENCE:

Confidential, Idaho|USA

Microsoft Business Intelligence Developer -SSIS|SSRS|SSAS|Tableau

• Create database object such as tables, views, stored procedures, functions and temporary tables.
• Create cluster, non-cluster, unique/non unique, covering indexes, constraints and foreign keys.
• Choose appropriate data type for table columns space utilization and efficient joins for SQL server engine.
• Write queries using Joins and Window Functions to implement complex business logic.
• Design Fact and Dimension Tables for Data Warehouse using business and surrogate keys.
• Create View from a fact table and related Dimensions for Tableau/SSRS Reporting purpose.
• Write cross and outer apply for recursive logic and Pivot table queries.
• Write MERGE Statement to implement Insert, update and delete logic in ETL.
• Implement error handling in SSIS of Errors from excel file used by multiple users.
• Create connection for Excel, Flat File, OLEDB, SSAS, SharePoint source and destination.
• Implement Incremental, Upsert, Full Load and Kill/Fill Loading of SSIS Packages.
• Implement Slowly Changing Dimension Type 1 and Type 2 for inset, delete and insert using C# hashing.
• Use Active Batch to schedule and trigger jobs; send notification and alert emails.
• Use Auto ETL to import XML credential configuration files, used templates and deploy packages.
• Modify and add new Dimensions in SSAS solutions using Queries, Configure hierarchies and deploy changes.
• Deploy SSAS solutions in local server and synchronize the databases on servers located worldwide.
• Create Tabular models from different sources and wrote DAX queries for calculations.
• Develop Supply Chain Metrics, Cost Investment Tracking Tableau dashboards with details.
• Publish tableau reports/extracts on server and Active Batch with permissions and refresh schedules.
• Apply Filters, Calculated fields, Sets, Action, Groups, Parameters & Tableau built in Functions.

Confidential, Washington |USA |

SSIS (ETL) | SSRS Developer Consultant

• Developed SSIS Packages for Extracting, Transforming and Loading data huge data.
• Created Staging Tables and applied different mappings then Load into Data Warehouse.
• Implemented Error Handling at Package, Control Flow and Data Flow level.
• Used package configuration for ETL packages to dynamically execute on different Environments.
• Created source and destination connection for Excel, Flat Files and OLEDB.
• Chose efficient Data Flow components based on the business logic.
• Wrote complex Queries utilizing Stored Procedures, CTEs, table variables, Functions.
• Developed summarized report for sales recommendation based on different parameters.
• Designed and deployed reports with cascading parameters, linked report and sub reports.

Confidential,Washington| USA|

BI | SSAS Developer

• Worked on Sales Quota Forecast for Microsoft Accounts based on Historical data.
• Querying data from the Data Warehouse using complex T-SQL Queries.
• Calculate Incentives to different Account Types at Different granularity level using SQL.
• Applying forecasting Mathematical models like Time series and linear regression analysis.
• Collaborate with the off shore team for integrated works and synchronization
• Created CTEs, TempTable, Scalar/Table Valued Functions, Stored Procedures and views.
• Used Window Functions like RANK, ROW NUMBER, NTILE and DENSE RANK.
• Wrote Complex JOINS, CROSS APPLY, Sub Queries and Correlated Queries.
• Analyzed queries for optimization and performance tuning using SQL Profiler.
• Designed and deployed reports with cascading parameters, linked report and sub reports.

Confidential, Colorado| USA |

SSIS (ETL) | SSRS Developer Consultant

• Worked on ETL for loading high volume financial data from different sources and generate report.
• Apply Incremental and Full load loading patterns on the source to load Data Warehouse.
• Configure SSIS packages deployment to dynamically run on different environment.
• ETL testing for data loading verification and Schedule Job Agents for packages.
• Wrote C# code to embed it in Script task to enhance SSIS Package.
• Handled SSIS Errors of dimensions/facts that are not properly populated; monitored scheduled jobs.
• Created various reports SSRS from OLAP cube using MDX query .
• Designed reports with Drill Down, Drill Through, and Parameterized and Linked reports
• Create caching report, snapshot to reduce the burden of report server for processing.
• Developed, modified and deployed reports for Daily, Weekly, Monthly and Quarterly Reports.
• Maintained the physical database integrity and optimize the SQL queries.
• Created views to restrict access to the base table data for security.
• Used Index usage statistics to determine if an index is improving application performance.
• Supported team with database issues, access issues, slowly running Queries.

Confidential, Washington|USA |

SSIS|SSRS|SQL Developer / DBA

• Developed SSIS Packages from different file sources like excel, Flat files and SQL Server.
• Developed SSIS Packages using Union, Union All, Multicast, derived components.
• Created tables with appropriate column data types, indexes and Keys.
• Created staging tables for temporary storage and handling same day ETL loading techniques.
• Scheduled SSIS packages with appropriate configurations.
• Wrote Optimized Queries using Inner and outer joins to implement business logic.
• Created relationships with foreign keys, constraints to enforce business rules.
• Performed database performance Tuning and troubleshooting.
• Created Stored Procedure, Triggers, Functions and Views.
• Generated Data in Excel from SSIS packages and forwarded to report users.
• Created backup and recovery of the database and monitor their performance.
• Creating user logins, permissions, and security for the databases objects.

Confidential

Database |Application Developer

• Involved in replacing the manual registrar system and reducing multiple steps taken manually.
• Increased the efficiency of registrar system for workers and reduce the waiting time for end users.
• Involved in requirement analysis and data gathering from stakeholders and customers.
• Analyzed the organizational structure of the system; policies, rules, documents and formats.
• Reviewed the manual system for better understanding of the new system implemented.
• Developed the conceptual, Logical and Physical design of the system.
• Created system's design documentation to be used in SDLC and Design ER Modeler and ER Diagrams.
• Performed database performance Tuning and troubleshooting for any problem users ask for.
• Created Stored Procedure, Triggers, Functions and views to make the system more manageable.
• Implemented Inner join, left join, right join, full outer join, cross joins and self joins
• Trained Users how to use the database system for the day to day activates in the registrar system.

TECHNICAL SKILLS:

• SQL Server 2005/ 2008 R
• SQL SERVER- BIDS/Data Tools( SSIS
• SSIS
• SSAS )
• TFS 2010/2013
• Visual Studio
• ProClarity
• AutoETL
• DAT Manager
• Active Batch
• Tableau Desktop
• Trans SQL
• C#
• .NET
• VB.NET
• C++
• ASP.NET/MVC
• JavaScript
• XML
• JSON
• Big Data {Mongo}