SUMMARY

• Tableau BI/MS SQL Server Developer over 10 years of strong experience in various domains like Financial, Healthcare, Retail and insurance with expertise in MS SQL Server 2016/2014/2012/2008 r 2/2008/2005/2000 and SSIS, SSRS, SSAS.
• Expert in designing dashboard, reports using Tableau
• Expert in Microsoft Business Intelligent Studio 2010/2008 (SSIS/SSRS/SSAS)
• Having knowledge about cloud computing technologies like AWS, and others
• Strong in ETL, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies.
• Use Agile methodology to keep Project in line so it should meet the deadline.
• Proficiency in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Extremely diligent strong team player with an ability to take new roles and ability to work under pressure in a highly visible role and 24x7 on call support

TECHNICAL SKILLS

• Tableau
• MS SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000
• Visual studio 2015/2012/2010/2008 (SSAS/SSIS/SSRS)
• Microsoft Access 2007/2003
• Microsoft Excel (Pivot Table)
• Outlook
• MS SQL Profiler
• SQL server Query Analyzer
• Index Tuning Wizard
• ASP.Net Frame Work 2.0
• C#
• Oracle
• DB2
• Crystal report
• Erwin8/7.3/3.5
• Windows 2007/2005 Advanced Server/Professional
• Window XP
• MS Access
• Java
• My SQL
• SQL Compare 10
• Qlik view
• Classic ASP
• AWS cloud computing
• Subversion repository
• Kdb+
• Micro Strategy
• Confidential Data Stage

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

BI developer

Responsibilities:

• Designed and Developed Tableau solutions based on requirement
• Wrote many user defined functions, stored procedures and triggers to do relational Database development.
• Very good understanding of data modeling OLTP as well as OLAP
• Worked on query optimization process and enhanced SQL jobs to run efficiently
• Created SSIS packages to export data from different data sources.
• Used Agile Scrum/ waterfall technique for the project management
• Used filters, data blending concepts, parameters, maps, statistics, and table calculations in Tableau reports to build efficient report.

Tools: SQL server 2019, SSRS, Crystal Reports, Tableau, Windows Batch scripting, Autosys, Visual Studio 2015, MS Office 2016, UNIX, TFS, GitHub, SVN, Classic ASP, Direct connect, C#, Red Gate, VB.Net

Confidential, Columbia, MD

BI developer

Responsibilities:

• Used Data Stage to load the files from various Rating Agency sources like Fitch, Moody’s and S&P to CDO database.
• Supported Classic asp pages with new upgrades and wrote many complex SQL stored procedures.
• Gather requirements from the business and built reports for their clients using SSRS, Qlik View and Micro Strategy.
• Convert many FTP loads to SFTP for security purpose.
• Having experience working with networking teams and top - level management.
• Used sub version/TFS as a source control for all the development
• Also helped in Production Support /other projects where no one would like to take initiative. if there is no project work.
• Wrote many user defined functions, stored procedures and triggers to do relational Database development.
• Very good understanding of data modeling OLTP as well as OLAP
• Also did server migration project from SQL server 2008 R2 to SQL server 2016
• Used Agile Scrum/ waterfall technique for the project management
• Followed SDLC Tracker for any new development and closely worked with Business Analyst and QA team.

Tools: SQL server 2016/2008 R2, SSRS, Crystal Reports, Qlik View, Micro Strategy, Windows Batch scripting, Autosys, Confidential DataStage, Visual Studio 2015, MS Office 2016, UNIX, TFS, GitHub, SVN, Classic ASP, Direct connect, Axway, Java, C#, Red Gate, VB.Net

Confidential, Baltimore, MD

BI developer

Responsibilities:

• POINT Replacement Project Analysis
• Worked with SSIS using different task and containers to automate the process.
• Also worked with their Generic DBI tool so we can schedule email delivery including the snapshot reports and excel reports to the investment analyst.
• Used Quick view reporting as well as SSRS reporting to generate the dashboard/ master reports to the investment Analysts.
• Built POINT/RIM Model Validation Qlik view report for the Quantitative research department.
• Also, used Autosys job tool for the scheduling any operation that needed to automate the process
• Also did data modeling for the risk and attribution data in order to store data with the 100% integrity.
• Created store procedures and other database objects like view, functions and triggers using SQL
• Also did lots of performance tuning with the SSIS, SSRS and with SQL database objects.
• Familiar with Confidential point report system, and created SIGNOFF GUI tool to help IA IL and PG
• Worked with ABS and MBS data provided by the Freddie Mac, Fannie Mae and Ginnie Mae.
• Having knowledge about the EMBS, NARMBS, RISK, ATTRIBUTION, HOLDINGS data and its structures.

Tools: Qlik View Reporting, SQL, SSRS, Batch scripting, MS SQL Server Integration Services 2012, CA Automation, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2012/2015, Erwin, Windows XP, MS Office 2007/2010,2016, MS Access, Power Pivot, XML, ab initio integration, UNIX, TFS, Rally, GitHub

Confidential, Durham, NC

Business Analyst Database / SSIS Developer

Responsibilities:

• Used visual studio 2012 to doing database development and integration development and also used AutosysJil files to create job scheduling for integration and Java.
• Created BNTC (Best Number to Call) and BTTC (Best Time to Call) files for the business by using database and integration backend and java and MSP in front hand tool.
• Worked with BA, QA and Rules developer to make sure everything is up to date.
• Made huge performance tuning in Green Field as compared with existing system called Pulse.
• Also, worked with the EDW, ASD, Skip Trace and DM Loan and Borrower team to make sure they were good from their side so receiving the data from them is quicker.
• Used Agile methodology to achieve Goal by using regular scrums and Sprints.
• Used multiple Transformation like Sort, Data Conversion, Conditional Split, Derived Column, Lookup, Merge and Multi Cast while creating SSIS Packages.
• Created ETL packages with different data sources (SQLServer, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS.Performed Documentation for all kind of SSIS packages.
• Also, Up for the Production Support 24/7. So, the whole system is running Up to date.

Tools: MS SQL server 2008,2008R2,2012, SSIS, SQL Profiler and T-SQL, Visual Studio 2010,2012, Microsoft Office, Index Tuning Wizard, Query Analyzer, SQL Compare 2010, TFS

Confidential, IA

SQL Server/ BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Identified data source and data views for building the OLAP cube in SSAS.
• Defined measures, dimensions and attributes for building the cube in SSAS.
• Use SSRS to create the report for the marketing people by using combination of SSAS and Database.
• So they can present up to date information in front of the future business.
• Investigate and Analyzing data quality tool and creating Analysis documents for the management
• Worked with the Clnt Hub database. And help client by using their DWHTemp and DWHModel (Destination databases) by Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency for the clean data.
• Identified and defined Fact relationships, calculated members while designing OLAP cubes in SSAS.
• Transformed complex business logic into Database design and maintaining it by usingSQLobjects like Stored Procedures, User Defined Functions, and Views.
• Create reports by using the pivot table (MS Excel) by using the OLAP data source for the sales department and keep them up to date to get more future business.
• Successfully implemented indexes on tables for optimum performance.
• By Using SSRS We trigger the SSIS and Write Log into the Reports including IT request Link.
• Identified data source and data views for building the OLAP cube in SSAS.
• Defined measures, dimensions and attributes for building the cube in SSAS.
• Extensively used Joins and Sub-queries including CTE for complex queries involving multiple tables from different databases.
• Use various SSIS transformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Applied ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Experienced in creating package dynamics by using SSIS transformations and variables.
• Developed logging for ETL load at the package level and task level to log number of records processed by each package and each task in a package using SSIS.

Tools: T-SQL, MS SQL Server Integration Services 2008R2, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio, Windows XP, MS Office 2007/2010, MS Access, Power Pivot, SSAS

Confidential, Reston, VA

SQL Server TSQL/SSIS/SSRS

Responsibilities:

• Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.
• Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction
• Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Used Execution Plan,SQLProfiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Accountable for Backup and Recovery Strategy and Planning.
• Created ETL packages with different data sources (SQLServer, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Data quality done by using the Data cleansing by using ETL development
• Use Packages by testing and Cleaning the Standardized Data by using tools in Data
• Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing and new packages.
• Involved in scheduling SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Logged various packages as well as individual tasks using SQL server log providers like text file, sql server database, trace file, xml file.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2012.
• Generated daily, weekly and monthly reports for the managers.
• Maintain data quality by using the SCD and loaded into target database
• Used sub reports functionality for complex report calculations.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Responsible for database tuning using normalization and application tuning.
• Documentation for all kinds of reports and SSIS packages.

Tools: MS SQL Server 2012, T-SQL, SQL server Integration service 2012, SQL server reporting service 2012, Erwin7.3,Query Analyzer, Index Tuning wizard, SQL Profiler Windows server 2003.

Confidential, Bethesda, MD

SQL Server T-SQL Developer /SSRS/DBA

Responsibilities:

• Extensively used SQL server reporting services to generate reports on a weekly basis for a particular sales type in given period.
• Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008R2.
• Created reports using Global Variables, Expressions and Functions using SSRS 2008R2.
• Developed reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.
• Wrote T-SQL queries, created dynamic Stored Procedures by using input values.
• Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.
• Applied monthly patches and hot fixes.
• Created Alerts for successful and unsuccessful completion of Scheduled Jobs.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008R2.
• Developed reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Maintained the table performance by following the tuning tips like Normalization, Creating Indexes etc.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Using ETL to build the required data mart.
• Generated Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler, index tuning wizard.

Confidential, Jacksonville, FL

MS SQL Developer/ SSRS, SSIS, SSAS Developer

Responsibilities:

• Gathered user requirements to develop the business logic and analyzed and designed database solutions.
• Identified data source and data views for building the OLAP cube in SSAS.
• Defined measures, dimensions and attributes for building the cube in SSAS.
• Identified and defined Fact relationships, calculated members while designing OLAP cubes in SSAS.
• Created OLAP cubes using SSAS to analyze the business condition of the sales.
• Wrote complex queries for the drill down reports and used conditional formatting using SSRS.
• Scheduled and monitored all maintenance activities of SQL Server 2008 including database consistency checks and index defragmentation.
• Created Parameterized, matrix and drill down reports using SSRS 2008.
• Used SSIS to transfer data from various sources like SQL Server, MS Access to be used for generating reports using SSRS 2008.
• Formatted reports for various Output formats as requested by the management using SSRS.
• Actively supported business users for changes in reports as and when required using SSRS.
• Analyzed reports and fixed bugs in stored procedures using SSRS.
• Used complex expressions to group data, filter and parameterize reports.
• Created linked reports and managed snapshots using SSRS.
• Performed various calculations using complex expressions in the reports and created report models.
• Designed and optimized indexes, views, stored procedures and functions using T-SQL
• Helped designing and implementing processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Deployed the generated reports created using SSRS 2008 on to the server.
• Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Created Alerts for successful and unsuccessful completion of Scheduled Jobs.