PROFESSIONAL SUMMARY:

• Over 6+ years of IT experience as a MS SQL Server/MSBI/Tableau Developer in various Industry verticals like Logistics, Finance, Retailers, Insurance, Pharmaceuticals and Banking.
• Experience in developing teh applications usingT - SQL Programming (DDL, DML, and DCL)MSBI and Tableau.
• Conversant with all phase of Software Development life cycle (SDLC) including development, designing, analysis, coding, testing and implementation.
• Plans and coordinates teh administration of PostgreSQL databases to ensure accurate, appropriate, and TEMPeffective use of data, including database definition, structure, documentation, long - range requirements, and operational guidelines.
• Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.
• Develop SQL reports that meet client expectations for teh application (used by custom application).
• Extensive experience in MS SQL Server 2012/2016/2019, BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Tableau Desktop and Tableau Server.
• Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, common table expressions, Relational Database Models and Data Integrity, SQL join, Change Data Capture for track DML Operation on Database level and Query Writing.
• Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into teh Data warehouse from Heterogeneous data sources such as Oracle, DB2, Sybase, Excel, MS Access, CSV, flat file.
• Experience in creating Jobs, Alerts, SQL Mail Agent and Scheduling SSIS Packages.
• Strong experience in designing and developing large number of enterprise reports (SSRS/Business Objects) using teh data from ETL loads, and various heterogeneous data sources.
• Expert in designing complex reports using Cascading parameters, Drill-Through Reports, Parameterized Reports andAd hoc reports and deploying SSRS reports on teh portal for user accessibility.
• Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting teh data, defining data sources for teh reports using SSRS.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight teh value of analytics in Executive decision support control.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.
• Strong experience in logical and physical database design and development using Erwin and MS Visio.
• Extensive database programming experience in writing T-SQL, User Defined Functions, Triggers, Views, Temporary Tables Constraints and Indexes using various DDL and DML commands.
• Expert in using Performance Tuning tools like MS SQL Profiler, Index Tuning wizard, SQL Server Database Engine Tuning Advisor. Also strong in creating table Partition for better performance for Database and creating Partition Function and Partition Scheme.
• Experience in writing C# code to load data, database connections, Manipulating files, data tables, variables.
• Worked in collaborative team environment with other developers, business analysts, and a project management team.

TECHNICAL SKILLS:

• MS SQL Server 2012/2016/2019
• SQL Server Integration Services (SSIS 2014/2016)
• SQL Server Reporting Services (SSRS 2014/2016/2018 )
• MS Visual Studio, SQL Server Data Tools, MS-Access
• SQL Profiler, Query Analyzer
• MS Power Point,MS Access
• Microsoft Visio,MS VISIO
• C#, Tableau Server, Tableau Desktop, MS office, Windows.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas TX

Sr. BI Developer

Responsibilities:

• Worked with Users, BA for functional requirements and enhancements.
• Worked with DBAs and Data modelers to implement new database objects like tables and indexes for teh new enterprise release or enhancements.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Build efficient SSIS packages for processing fact and dimension tables with complex Transforms and type 1 and type 2 slowly changing dimensions.
• Performed system test, UAT test, Stress test for performance test, and co-ordinates in end to end test.
• Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within teh organization.
• Responsible for all backup, recovery, and upgrading of all of teh PostgreSQL databases
• Enhanced performance using Execution Plan, SQL Profiler, Indexes, Indexed views, sub queries/joins, Table Type, Temp Table for Bulk Insert etc.
• Involved in Production Support and monitoring daily and monthly run.
• Provided multiple demonstrations ofTableaufunctionalities and efficient data visualizations approaches usingTableauto teh senior management.
• Working on generating various dashboards inTableauDesktop using SQL SERVER as data source.
• Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
• Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema.
• Created SSAS cubes with KPIs and aggregation for teh front-end analysis team.
• Developed complex calculated fields for teh business logic, field, actions, sets and parameters to include various filtering capabilities for teh dashboards, and to provide drill down features for teh detailed reports.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for teh weekly and monthly dashboard reports onTableauServer.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Created Tableau scorecards, dashboards using Stack bars, Bar graphs, scattered plots, geographical maps, Gantt charts using Show me functionality.
• Provided 24/7 production support forTableauusers and conducting s to user on interact, filter, sort and customize views on an existing visualization generated thruTableaudesktop.
• PerformedTableauAdmin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in theTableauServer.

Tools: & Technologies: SQL Server 2012, SQL Server Data Tools 2012, SQL Integration Services(SSIS), Tableau server, tableau desktop,JAMA,Visual Studio, MS Excel, T-SQL,C#,Rebex.net.

Confidential, NJ

MS SQL Server/BI/SSIS Developer

Responsibilities:

• Responsible for installing and maintaining SQL Server database systems. Maintaining teh database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Responsible for creating teh Change Controls and working on them closely till teh production release.
• Responsible for working on Change Request (CR's), Incident Managements (IM's) and Request Fulfillment (RF's) tickets on a daily basis.
• Experience in High Level Design of ETL Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, Flat File, Text Format Data) by using multiple transformations.
• Performed Server installation and configuration using SQL Server 2005/2008/2012/2014
• Responsible for resolving complex issues and Error Handling in SSIS.
• Responsible for creating and scheduling SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File etc. and vice versa.
• Created and scheduled SQL jobs to run SSIS packages on a daily basis using MS SQL Server Integration Services (SSIS).
• Created Complex SSIS Packages to load huge volume of data from Nielson and Tribune on daily basis from Flat Files to Cloud based SQL Server on AWS (Amazon Web Services).
• Loaded data into AWS Redshift and use AWS Cloud Watch to collect and monitor AWS RDS instances within Confidential.
• Used various control flow tasks like FTP, Bulk insert task, Transfer job task etc and different data flow tasks.
• Responsible for creating complex stored procedures, Triggers and user defined functions using joins and cursors as required for SSIS packages.
• Responsible for configuring invoice emails, modified excel files before loading them to database.
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Expertise in ETL techniques using Stored Procedures to Extract and Transform data from various data sources and Load to teh Transactional/Dimensional Databases.
• Generated Report Models using Model Designer, to enable teh business users to build ad-hoc reports using Report Builder.
• Involved in designing reports and delivering them by any of teh delivery methods like standard subscriptions, data-driven subscription, URL access etc.
• Worked with creating mapping document with business requirements, source to destination schema mapping along with teh ETL logic and created design documents.
• Analyze user requirements, functional and technical specifications, preparing test plans.

Environment: Change Control, CR's, MS SQL Server 2016, Visual Studio 2017, Microsoft Business Intelligence, SSIS, T-SQL,SSRS, SSAS, MS Office Access, Windows Server 2003/2008, .Net Framework 4.0,C#.Net

Confidential

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Involved with business stakeholders, application developers, productionteams and across functional units to identify business needs and discuss solution options.
• Worked in teh Agile methodology using Scrum which TEMPhas its primary focus on teh management part of teh software development, dividing teh whole development period into small iterations (of thirty days) called "sprints."
• Developed and deployed SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusing Fore Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task,Lookup, Fuzzy Lookup, Derived Columns, Condition Split, CDC Control Task, CDC Splitter, CDC Source, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices.
• Created C# Script for Control Flow and Check File existence using Script task in SSIS.
• Supported Production Environment with schedule teh packages and make teh package dynamic with SQL Server Package Configuration.
• Involved in Production support with Deployment of teh SSIS Packages and schedule SSIS packages using SQL Server Agent Job.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from teh database.
• Created/Updated database objects like tables, views, stored procedures,function, packages.
• Designed Change data capture to capture insert, update, and delete activity applied to SQL Server tables, and to make teh details of teh changes available in an easily consumed relational format.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into teh database.
• Rigorously tested and debugged teh Stored Procedures and used Triggers to test teh validity ofthe data after teh insert, update or delete.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Developed and delivered dynamic reporting solutions using MS SQL Server Reporting Services (SSRS).
• Involved in monitoring and tuning report performance by analyzing teh execution plan of teh report.
• Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS.
• Designed and developed monthly, quarterly, and yearly reports at branch and bank level.
• Involved in table and indexpartitioning for performance and Manageability.
• Identified, evaluated, and resolved database performance issues (monitoring and tuning) to ensuredatabase optimization.
• Monitored teh overall performance of teh database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace teh slow running queries and teh server activity

Tools: & Technologies: SQL Server, Server Integration Services, SQL server Reporting Service, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN 7.2, .NET

Confidential

MS SQL Server-SSIS Developer

Responsibilities:

• Involved in understanding teh functional requirements, translation of technical documents, data dictionary mapping and data mappings
• Interacted with various upstream and downstream customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs.
• Designed & developed ETL procedures, Data dictionaries, data mappings involving data analysis, data validations and data migrations.
• Involved in writing heavy T-SQL stored procedures, complex joins, newT-SQL features like Merge, Except commands
• Support Batch and Online processes involving development, enhancement and support of T-SQL procedures, views, triggers and query tuning
• Performed Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access, CSV)
• Worked in BI Solutions (ETL & Reporting) using SSIS and T-SQL Programming using DDL, DML, DCL commands for various business applications.
• Extensively involved in creating in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• TEMPEffectively used Normalization and De-Normalization techniques for OLTP systems in creating Database Objects like tables, Constraints and Indexes.
• Used SQL Server Profiler to monitor teh SQL server for deadlocks, long running queries and fine tune teh same to improve performance.
• Experienced in Error handling and debugging coding issues and troubleshoot production problems.
• Well-versed in usage of SSIS Control Flow items(for Loop, execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping).
• Developed SSIS package for implement Slowly Changing Dimension. Fact Load and Dimension Load. Incremental Load.
• Used incremental approach in teh Workflows and Data Flows to integrate source data into warehouse tables using required transformations.
• Involved in configuring and creating SSIS solutions for ETL and Business Intelligence Process for data integration and migration services.
• Experienced in creating configuration files to deploy teh SSIS packages across all environments.
• Implemented error and event handling: precedence Constraints, Break Points, Check points and Logging.

Tools: & Technologies: SQL Server, BIDS, Integration Services, Visual SourceSafe, T-SQL, MS Access, Windows XP, SQL Profiler, Index Tuning Wizard.