SUMMARY

• Over 8 years of experience in SQL Server including Design, Modeling, Development, Implementation and Support of SQL Server 2000/2005/2008/2008 R 2/2012/2014/2016.
• Extensive knowledge of Normalization, Relational Database Management Systems (RDBMS), Data Warehouse Concepts, OLTP, OLAP, Dimensional Modeling and experience with Data Analysis, Data Cleansing/Data Scrubbing and Data Migration.
• 6+ years experience with Business Intelligence tools(SSIS, SSRS, SSAS) in MS SQL Server 2008,2012,2014,2016
• Extensive experience with T - SQL in constructing Triggers, Tables, Stored Procedures, Functions, Views, User Profiles, CTE, Error Handling, Data Integrity, Linked Server, Job Scheduling, Index Management (Rebuilding and Reorganizing Indexes), Data Partitioning, Performance Tuning and Query Optimization.
• Used SSIS to create ETL packages to validate, transform and load data into data warehouse from different sources like SAP B1 (Business one) and QuickBooks, consolidating and merging into one single source.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Skilled in Error and Event Handling, precedence Constraints, Break Points, Check points, Expressions and Logging in SSIS packages. Used Script task/Script Component to write custom code using C# and VB.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Dashboards, Matrix/Tabular, parameterized, Drill through, Drill Down reports, Sub-reports, Linked reports using SSRS and ad-hoc reports using Report Builder.
• Created Tableau Scorecards, Dashboards using Stack Bars, Bar Graphs, Scattered Plots, Geographical Maps, Gantt Charts using show me Functionality
• In depth Knowledge in ER Modeling and Dimensional modeling (Star and Snowflake Schema) building Dimension and Fact tables.
• Experience and understanding of SSAS, OLAP cubes and Architecture.
• Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SSAS 2005/2008/2208 R 2/2012/2016.
• Very skilled Excel Specialist has strong knowledge of and experience with utilizing vLookups, Pivot, Functions, Data Tables, Sorting, filtering...Etc.
• Solid experience working in onshore-offshore model and remote cross functional teams.
• Expert-level knowledge of Shopify Liquid template language and coding experience in e-commerce web application development using HTML5, CSS and JavaScript.
• Familiar with Financial Market Data Sources like Bloomberg and Accounting tools like QuickBooks and SAP B1 (Business One).
• Ability to work in a fast-paced environment, good team player and can work independently.

TECHNICAL SKILLS

• MS SQL Server, T-SQL, SSRS, SSIS, SSAS,BIDS, SSDT, Crystal Reports, Tableau
• TFS, Database design, OOP, Relational and Dimensional modeling, Data warehousing
• Liquid template language, MDX Queries, MS Office, HTML, JAVA Script, VB.net, C#
• ASP.NET, Off-shoring, and Cross functional coordination.

PROFESSIONAL EXPERIENCE

Confidential, Pleasantville, NY

Senior Data Warehouse developer

Responsibilities:

• Built and maintained SQL scripts, indexes, and complex queries/stored procedures for data analysis and extraction for various projects.
• Identified and improved the performance of long running Views, Queries and Stored procedures by 90% (by adding indexes, removing unnecessary columns in the inner views and adding conditions to get only required data)
• Developed SSIS packages to migrate the Historic sales data from QuickBooks to SAP B1 (Business One).
• Used SSIS to create ETL packages to validate, transform and load data into data warehouse from various data sources (SAP, QuickBooks, Excel, Flat files…Etc), consolidating and merging into one single source. Implemented Logging, Event Handlers and Error Handling in SSIS packages.
• Migrated SSIS Packages from development server to production server using package configuration.
• Validating and Looping through various file sources and loading dynamically into the database using SSIS tasks like Script Task, For Each Loop Container, For Loop Container, Bulk Insert Task, Execute SQL Task, File System task and various Data Flow Tasks.
• Configured SSIS Send Mail Task on multiple Control Flow Tasks to send email during failure using SMTP connection Manager.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2012 (SSAS). Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2012 Analysis Services (SSAS).
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Charts.
• Developed Monthly Sales Person Performance reports using SSRS for higher management to measure and monitor the performance of the sales teams and to improve/plan effective sales strategies.
• Automated all Daily/Monthly/Quarterly Product Sales reports, Inventory reports, Anniversary reports, Overview Dashboards, Finances Summary reports...Etc using SSRS that could be used to send information to different Primary Vendors, Clients, and Managers.
• Developed and implemented new Features for the custom client sites that are end-user customizable within Shopify Platform (utilizing Liquid, HTML, JavaScript, CSS and jQuery)
• Used MS Excel to organize company data and budget reports into detailed pivot tables.
• Created management reports in Excel that became company standard for recording financial information.
• Documented reports/SSIS packages using Visio.

Confidential

Senior ETL/Ecommerce Developer

Responsibilities:

• Generated periodic/ ad-hoc reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Understood the SAP platform and analyzed core business functions for data migration including Inventory, Sales &Purchasing, and reporting using Business Intelligence.
• Extensively used various SSIS control flow tasks like Loop Containers, Execute SQL Task, Script Task, FTP, Web service task, Bulk insert task, Transfer job task, etc. and different data flow tasks like Conditional split, Derived Column, Fuzzy lookup, merge join, Multicast, Union all, data conversion, Multicast etc.
• Created complex SSIS Incremental Load packages to load the data on daily basis from various sources. OLEDB, Flat File, and Excel Sources
• Implemented updates to ecommerce platform using ASP.NET, HTML, and CSS for styling the Web pages.
• Worked with developers to setup databases and coordinate the schemas and procedures deployment on staging and production; involved with Query Optimization to increase the performance of the Report.
• Provided onsite support to GET custom ecommerce platform and online meetings registration websites.
• Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema.
• Successfully managed customer expectations and deliverables working with the development team.
• SQL Server 2012 RDBMS database development using T-SQL programming, queries, stored procedures, views.

Confidential

Senior Database Developer

Responsibilities:

• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Company trained on MS CRM Platform (Microsoft Dynamics), played key role in implementations and customization.
• Migrated HR systems from PHP to ASP.net.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and flat files.
• Migrated SQL Server 2000 entire company databases to SQL Server 2005 and applied standard coding practices
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS.
• Managed Login and User: adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Experience in writing global variables, expressions and functions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Prepared estimates of effort and duration for development tasks and activities