PROFESSIONAL SUMMARY:

• Over 7 years of professional experience in the Analysis, Design, Development, Implementation and Testing Client/Server applications using Microsoft SQL Server 2005/2008/2008 R2/2012, SQL Server Management Studio, MS Business Intelligence Suite (SSIS, SSRS) and Tableau.
• Hands on experience with Tableau Desktops v. 7/8.1/9.3, Tableau Reader and Server.
• High understanding in Oracle environment to manage enterprise information effectively.
• Excellent T - SQL Developer skills including writing, reviewing, debugging complex Stored Procedures, Indexes, Views, User Defined Functions, Triggers, Cursors and Transactions.
• Extensive experience in working with different environment including MySQL, SQL Server 2005/2008/2008 R2/2012, Microsoft Visual Studio 2005/2008/2012 and Windows Server 2008 R2/2012.
• Worked with multiple System Development Life Cycle (SDLC) methodologies including Waterfall, Agile and Scrum Framework and have extensive experience with working in Development, Production and QA environment.
• Highly skilled in developing, documenting and deploying ETL packages with Package/Project Deployment Model with the use of SQL Server Integration Services (SSIS) to load and transform data from one or more sources into data warehouses and data marts to be used for Analytical processing and Reports.
• Involved in data migrations, transfers using utilities like SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Expert in Architectural Design of SSIS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) and Data conversion process.
• Experience in creating SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Conditional Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleansed data.
• Highly skilled in implementing incremental data loading techniques with the use of SQL Merge, Lookups, Slowly Changing Dimensions and Change Data Capture.
• Proficient in designing, developing and deployment of different business/use reports with the use of Drill-down, Drill-through, sub-reports, Parameterized, and Snapshot reports in SQL Server Reporting Services (SSRS).
• Deep knowledge and understanding of Enterprise Data Warehouse concepts which includes On-line Transaction Processing and On-line Analytical Processing, Star/Snowflake Schemas and Top-down/Bottom-up approach and Dimension/Fact Tables.
• Experience in designing Conceptual, Logical and Physical Data models for Enterprise Data Warehouse.
• Excellent communication skills, strong analytical thinking, fast learner, and very adaptable to changes.

TECHNICAL SKILLS:

Relational Database: Microsoft SQL Server 2005/2008/2008 R 2/2012/2014/2016, MS Access, MS Excel, MySQL, Oracle 10g/9i

Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio(BIDS), SQL Server Integration Services (SSIS), Tableau 7/8.1/9.3/10, Power BI, Alteryx, Visual Studio 2005/2008/2012, Team Foundation Server (TFS), JIRA, Tortoise SVN

Language: T-SQL, PL/SQL, ASP.NET, C#.NET, Javascript, R, Python, HTML, CSS, AJAX

Operating System: Windows Server 2008 R2/ 2012, Windows XP/7/8/10

Data Modeling Tools: MS Visio, ERwin 4.0

PROFESSIONAL EXPERIENCE:

Confidential, Saint Louis, MO

Sr. Business Intelligence Developer

Responsibilities:

• Involved in gathering project requirements from business users and managers to be able to design a complete flow of migration process.
• Was the overall developer of the project that is used to migrate 2000 customers that is using different applications to target a multiple database using a single application of the company.
• Designed and developed the whole migration package to be used in upgrading the company’s existing customers as well as future customers to have their data fit into the company’s database structure.
• Created packages to migrate legacy customers from various sources and transform it to be able to load to the new application the company is developing.
• Used multiple lookups and casts to match source data and be able to map it to the new existing application of the company.
• Designed and created new database for the migration project.
• Wrote complex dynamic stored procedure to accommodate unstructured data from multiple sources targeting multiple tables and databases.
• Created trigger for logging and also used to execute specific SSIS packages.
• Created SSIS package that push data from staging environment to production environment with the use of multiple lookups.
• Created queries using PL/SQL to be able to export data from the legacy database with specific format that the SSIS package was designed to accept.
• Used Transfer Database Task to sync production server with the migration server to eliminate process redundancy in provisioning databases for the customers.
• Developed automated scripts to deploy both SSIS and Database into production without using manual deployment method.
• Involved in the development of the User Interface to manually execute the SSIS package for migration.
• Used both project and package deployment model for the project.
• Created SSIS packages that involved dealing with different source formats (Text files, XML, Database Tables).
• Highly involved in an Agile Project Management method throughout the project.
• Involved in the development, testing and deployment phase.

Environment: Oracle 10g, SQL Server 2012, SQL Server 2016 SQL Server Management Studio, Microsoft Visual Studio 2012/2015, SQL BI Suite (SSIS, SSRS), PowerShell, XML, C#.NET, MS Project, MS Access & Windows Server 2008 R2, Amazon RedShift, Microsoft Hyper V.

Confidential, Moonachie, NJ

Tableau/Business Intelligence Developer

Responsibilities:

• Involved in gathering user/project requirements from business users and IT managers, translated it into functional and non-functional specifications needed and created documentation for the project.
• Created calculated member for complex calculation in reports using Business Intelligence.
• Developed workbooks with Tableau to perform year over year, year/quarter/month to date type of analysis.
• Worked with a team of developers to implement Business Intelligence solution for Sales, Product and Customer KPIs.
• Provided 24/7 production support for Tableau users.
• Involved in publishing workbooks, setting permissions, ownerships and providing access to specific user groups.
• Worked with writing complex SQL queries that involved reoccurring sub queries with the use of multiple joins and unions.
• Used T-SQL in SQL Server to develop complex Stored Procedures, Triggers, Clustered Index & Non-Clustered Index, Views, and User-Defined Functions (UDFs).
• Designed and created Data Warehouse solutions using SSIS packages with the use of lookup, merge, union-all.
• Involved in incremental loading task using Slowly Changing Dimension to maintain historical data in data warehouse. Applied several types of transformations like Data Conversion, Multicasting, Conditional Split, and Derived Column in SSIS.
• Performed performance tuning with existing SQL queries with the use of SQL Server Profiler/Database Engine Tuning Advisor.
• Created ETL packages that uses Slowly Changing Dimension, Error Logging, Transactions, Lookups and Merge to transfer data from various sources to the company’s data warehouse.
• Performed Report Testing and Verification as per Internal Reporting system requirements.

Environment: MySQL, SQL Server 2012, SQL Server Management Studio, Microsoft Visual Studio 2012, SQL BI Suite (SSIS, SSRS), XML, C#.NET, MS Project, MS Access & Windows Server 2008 R2, Amazon RedShift, Tableau 9.3, Alteryx

Confidential, Jersey City, NJ

Tableau/Business Intelligence Developer

Responsibilities:

• Analyzed the requirements and selected the appropriate fact tables/created fact tables
• Developed reports on Tableau desktop and utilized quick filters and parameter controls.
• Involved in building and publishing customized reports and dashboards in Tableau.
• Interacted with the Strategic Development Team and Business Analysts to analyze business needs and translated the requirements into technical specification to be used in the interactive reports.
• Used Tableau interactive dashboard to analyze market trends for a specific product of the company.
• Created scatter plots, stacked bars, box and whisker plots according to the user specifications.
• Schedules extract refresh for reports on a weekly and monthly basis based on requirements.
• Published workbooks and set permissions to targeted user groups within the company.
• Designed and optimized data connections, extracts and schedules for incremental refresh of the reports for the weekly and monthly dashboard on Tableau server.
• Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions
• Experience in building and maintaining Data marts. Created roles for using the cubes
• Created ETL packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Created tables for data ware housing applications and populated the tables from the OLTP database using DTS packages
• Actively involved in Normalization & De-normalization of database
• Materialized views, dimensions and stored outlines for optimal performance
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems
• Published high-level technical documentation to set standards, guidelines and best practices for SQL Server Database Design, Coding Standards, Periodic Data refresh, database upgrades across the enterprise

Environment: SQL Server 2010, SQL Server Management Studio, Microsoft Visual Studio 2012, XML, MS Project, MS Access & Windows Server, Tableau 8.1

Confidential, Springfield, NJ

Tableau/Business Intelligence Developer

Responsibilities:

• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management, implementation of version control.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Tested to optimize the procedures and triggers to be used in production.
• Involved in project planning with project managers.
• Designed and built reports using Tableau for the trends of incoming and outgoing shipment within the facility of the company.
• Created a live extract Tableau dashboard that shows the current flow of production within the company’s premises.
• Interacted with the Operations Department to be able to develop an automated Tableau dashboard that shows them the capacity and the trend of movement within the yard.
• Involved in maintaining and publishing customized interactive reports and dashboards, report scheduling using Tableau Server.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Involved in analyzing and designing disaster recovery/replication strategies with business managers to meet the business requirements.
• Configured replication servers and transactional replication between production and standby server for disaster recovery.
• Gathered data from various external sources (Oracle) into a data warehousing system (Enterprise Cube) with the help of ETL process.
• Developed and Implemented the SQL Server Integration Services (SSIS) packages to populate the data into Enterprise Data Warehouse from various sources like Flat File Source, Excel Source into OLEDB destination (SQL Server).

Environment: Microsoft SQL Server 2008/2012, T-SQL, SQL Server Integration Service (SSIS), Tableau 7.0, Microsoft Visual Studio 2010, Windows Server 2008 R2, Oracle 10g

Confidential, Exton, PA

MS SQL/Business Intelligence Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Created Packages for Transaction processing using containers as For-Each Loop, Sequence & controlling flow of data using tasks as Script, Data Flow, File System, and Execute Package.
• Used Breakpoints & Event Handlers to debug packages & capture errors.
• Developed SSIS packages for developing a fully-fledged data warehouse solution.
• Gained performance improvement by direct execution of packages on server.
• Defined Dimension Models based on existing fact & dimension tables in Relational Data Warehouse.
• Created dimensions by defining Parent-Child relationships, using different dimension types.
• Created Perspectives & defined security, roles for different group of users.
• Extensive experience using Report Designer, Report Builder, Report Manager & Report Model.
• Created Reports directly from Integration Services packages & Analysis Services.
• Administered Reporting Services by securing Report Server Content by defining roles, role assignments & assigning item level, system level security.
• Created Filtered reports using report parameters, stored procedures & cascading parameters.
• Used C#.Net in modifying and updating in-house dashboard of the company.

Environment: Microsoft SQL Server 2008, Excel 2008, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), Microsoft Visual Studio 2008, Windows Server 2008 R2

Confidential, Manila, Philippines

MS SQL/Business Intelligence Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Gathered requirements from the business users and created technical specification documents.
• Highly involved in all phased of the SDLC of the project.
• Created SSIS package that pulls data from XML files loaded in a shared folder and stores it to the company database for reporting purposes.
• Automated and enhanced company’s terminal dashboard with the use of schedules SSIS packages.
• Developed database objects including Stored Procedures, Triggers, User-Defined Functions and Views.
• Review and optimized stored procedures and user defined functions.
• Wrote complex SQL queries with the use of joins, CTE, temp tables.
• Designed and development database structure (OLTP) and optimized the use of indexes and constraints.
• Involved in normalization and de-normalization of data used for OLTP and OLAP database warehouse.
• Involved in setting up SQL Server Agent Jobs and automate job schedules.
• Created ETL packages that helped the company automat manual processes.

Environment: Microsoft SQL Server 2005, Microsoft Visual Studio 2005, T-SQL, Visio, Windows 2003/2008