Having three years of Experience in Database development, Database modeling, Design and Technical Management using SQL Server 2012/2008/2008R2 in various domains as SQL Developer and MSBI Developer. Familiar with different SDLC methodologies like Waterfall, XP also understanding of various phases in these methodologies. Hands on Experience in Business Intelligence applications design, development and Maintenance of SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS). Having good understanding of Data warehouse, Data marts, Model, Design and Implementation. Having experienced in MS Access and MS Excel Visual Basic for application. Having Good understanding on Relational databases like SQL server and having knowledge on visualization tools like tableau. Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
SQL Server 2000/2005/2008 R2/2012, MS-Access, Sybase. oracle 11g/10g/9i, PL/SQL
SQL Server (SSIS, SSAS, SSRS), Crystal Reporting 10.0, Tableau
SSIS Developer/Tableau Developer, 01/2017
to 06/2017 Golub Corporation Price Chopper – Schenectady,
Responsible of making enhancement to the front end of the web application and focused mainly on the smart promotion in promo planning projects.
Design SSIS packages and schedule jobs to migrate data from multiple sources.
Created complex SQL queries with joins, correlated subqueries, CTEs, and views.
Working with active batch in order to schedule jobs across multiple platforms.
Implement incremental loads with timestamp techniques.
Developed, supported, and maintained ETL (extract, transform, load) and ELT (extract, transform, load) processes utilizing SSIS.
Implement master-child package techniques to efficiently manage large ETL and ELT project.
Collaborate with data and business analysts to refine business requirements for developing data warehouses/marts.
Designed views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
Using Configurations to make dynamic changes to packages.
Configurations like XML, SQL Server and Environment Variables have been used.
Build dashboard using parameters sets groups and calculations.
Involved in creating a dual axis bar chart with multiple measures.
Blended data from multiple databases into one report by selecting primary key s from each database for data validation.
Involved in publishing of various kinds of live interactive data visualizations dashboards
reports and workbooks from Tableau Desktop to Tableau servers.
Created actions parameters Filter Local Global and calculated sets for preparing dashboards and worksheets using Tableau Desktop.
Implement scrum methodology to complete tasks, based on complexity levels
Environment: SQL Server 2012/2014, SSIS, Visual Studio 2010/2012/2014, Netezza, Active Batch TFS, Tableau Desktop, Tableau Server.
Application Developer/SQL Server, 06/2016
to 12/2016 Wells Fargo – San Antonio,
Created complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications and developed complex T-SQL code for the application.
Worked on designing the physical databases model on SQL Server 2008 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
Developed SSIS package for implement Slowly Changing Dimension, Fact Load and Dimension Load with Incremental Lookup.
Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations.
Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance using SQL Server Profiler, Execution Plan and Performance Monitors.
Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, Parameterized Reports and AD Hoc Reports using SQL Server 2008 R2 Reports Services (SSRS).
Worked on remediation of MS ACCESS and MS Excel applications.
Migrated MS Access (2002-2003) application to MS Access 2010.
Used SQL Server as backend database for MS Access applications.
Modified/Created MS Access and Excel applications to run on windows 10.
Migrated MS Access application from ADP to ACCDB to run application in latest version of windows OS.
Experienced in creating linked tables from SQL server to MS Access.
Created ODBC connection string to SQL server from Access VBA to call Stored procedures.
Wrote VBA code to update linked tables automatically on opening application.
Worked on database tables and forms in the MS Access and created queries.
Resolved performance issues on opening MS Access application updating Linked tables.
Created Stored Procedures and Pass thru Queries.
Experienced writing Complex SQL Queries and Procedures.
providing security to the applications with respect to user access.
Experienced in using Confluence and / or JIRA tools.
Environment: SQL Server 2012, Microsoft Visual Studio 2010, MS Access (2003-2016), MS Excel (2003-2016), Visual basic for Application 6.5/10.0/15.0/16.0, windows 7/10, Tableau 8/9.
Programmer Analyst/BI Developer, 05/2015
to 04/2016 Reliable Software Resource MI
We follow an Agile Methodology with a 2-week sprint where we will be having daily scrum meetings with Scrum Master along with the other employees on the team.
Responsible for submitting weekly timesheets and status reports to the manager which would include all the tasks completed during the week and tasks/activities planned for the following week.
Perform SQL server installation, testing and troubleshooting.
Write intelligent SQL queries against the database.
Troubleshoot and install network security rangers for secured work environment which include creating user profiles for access etc.
Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
Experienced migration of data from various OLTP data sources such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server.
Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, SlowlyChanging Dimension and more.
Performed ETL mappings using MS SQL Server Integration Services.
Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables.
Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
Involve in unit testing and integration testing.
Monitor computer networks for security attacks/unauthorized users.
Developing and testing software deployment tools.
Experience in creating Jobs, Alerts, SQL Mail Agent.