Ms Sql Server/bi Developer(ssms/ssis/ssrs/tableau) Resume
New York, NY
SUMMARY:
- 7 Years of experience as SQL/Business Intelligence Developer in SQL - BI suite Comprising of SQL Server Integration Services(SSIS)/SQL Server Reporting Services (SSRS) along with Professional Database design, development and maintenance of MS SQL Server 2014/2012/2008 r 2/2008/2005.
- Strong experience in various versions (9.x/8.x/7.x) of Tableau Desktop, Tableau Server including report design, technical support, troubleshooting and monitoring of system usage.
- Experienced in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
- Proficient in using SQL Server to Develop T-SQL statements and SQL objects including Store Procedure, Trigger, Table, User Defined Function, View, SQL Joins and implementing performance based query writing skills.
- Steady knowledge in Normalizing and De-Normalizing tables to maintain referential integrity by using primary and foreign keys; thorough understanding and experience in Data Warehouse and Data Mart design, Star Schema, Snow Flake Schema concepts and principles.
- Experienced in SQL Query optimization techniques and debugging SQL Commands
- Experienced in installing and Configuring SQL Server Database.
- Proven ability in utilizing ETL Tools including SQL Server Integration Services(SSIS) to load data into the Data Warehouse from heterogeneous database like Flat Files, Excel and SQL Server.
- Efficiently load, combine, refine, and clean data from various sources through Power Query; Created relationships, measures, calculated columns, filter charts with DAX in PowerPivot.
- Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
- Proficiency in developing and deploying various reports like drilled down, drilled through, sub reports and Parameterized reports using MS SQL Server Reporting Services(SSRS).
- Experienced in Creating Ad-Hoc reports by using Excel, SharePoint and Report Builder in SSRS 2012/2008r2/2008 and 2005.
- Diverse experience in delivering business intelligence (BI) and analytic solutions, including SQL Server Reporting Services (SSRS), Microsoft Power BI and Tableau Dashboards and stories.
- Expert on delivering Efficient and direct to point Visualizing business solution through Microsoft Power BI. Give end user dynamic power over customizing solution to meet their business needs.
- Solid Experience working with tableau to meet clients’ requirements including creating visuals, building dashboards and customizing reports.
- Experienced in Software Development Life Cycle(SDLC) methods like Agile and Waterfall.
- Able to multitask and set priorities in delivering and meeting project deadlines.
- Excellent interpersonal communication, problem solving, documentation and business analytical skills with an ability to adapt new technology quickly and Confidential strong team player.
TECHNICAL SKILLS:
- MS SQL SERVER 2014/2012/2008 R2/2008/2005,
- Visual Studio 2012/2010,
- SQL Server Management Studio(SSMS),
- SQL Server Integration Services(SSIS)/SQL Server Analysis Services(SSAS)/SQL Server Reporting Services(SSRS),
- PowerPivot,
- Power Query,
- Windows 8/7/XP,
- MS VISIO,
- SQL Profiler,
- SQL Query Analyzer,
- T-SQL,
- P/L SQL,
- MDX,
- DAX,
- SQL Tuning Advisor,
- C#,
- MS Access
- MS Office Suite,
- Tableau 8.1/8.0/9.0,
- SharePoint 2013/2010,
- SVN,
- JIRA,
- TFS
PROFESSIONAL EXPERIENCE:
Confidential, NEW YORK, NY
MS SQL SERVER/BI Developer(SSMS/SSIS/SSRS/Tableau)
Responsibilities:- Participated in scrum meeting and sprint meeting to coordinate with software development life cycle process; involved in Confidential global team environment.
- Gathered requirement from team lead and prepared for technical documentation.
- Extracted data from FTP server and internal website using Sequence Container, FTP task, Execute SQL Task, Stored Procedure.
- Used T-SQL in SQL Server 2012 to develop Stored Procedure, User-Defined Functions(UDFs), and DML trigger to support the incremental loading packages.
- Optimized existing Store Procedure by monitoring through SQL Profiler, and Query Analyzer.
- Involved in developing initial load/incremental load ETL Packages, Staging Data ETL Packages, Package Test Script, and Report requirements/Unit Testing Document and Synchronized these packages/ Document into Team Foundation Server(TFS).
- Developed Store Procedure in T-SQL to replace existing SSIS packages in ETL process and gained better Performance.
- Involved in creating Jobs, SQL Mail Agent Alerts and Schedule SSIS Packages.
- Deployed and Configured ETL Packages and coordinated with broad Database Administration team to schedule the package in SQL server agent.
- Used SQL Server Analysis Services(SSAS) to create cubes with various measures and dimensions for report generation.
- Developed Aggregations, partitions based on calendar quarter for cube to improve running performance and business needs.
- Involved in generating reports using Tableau.
- Cleaned data source in SQL Server and prepared data source in Tableau metadata using complex joins, Custom SQL, split and data blending.
- Designed, developed and maintained daily, weekly, monthly and year-end summary, trending and benchmark reports repository in Tableau Desktop.
Environment: MS SQL SERVER 2012, SQL Server Integrations Services(SSIS), SQL Server Analysis Services(SSAS), Team Foundation Server(TFS), SQL Server Management Studio(SSMS), SQL Server Reporting Services(SSRS), T-SQL, Tableau 8.x, Tableau 9.x.
Confidential, Brentwood, TN
BI Developer/Report Developer(SSMS/SSIS/SSRS)
Responsibilities:- Created and maintained SQL database object such as tables, views, indexes and store procedures with SQL Server Management Studio(SSMS) 2012.
- Applied business intelligence solution by using Microsoft Power BI.
- Built profound Microsoft PowerPivot models with varied data sources, such as, MS SQL Server, Flat Files, Access and Excel Files.
- Transformed and automated data sources by Power Query; applied activities, such as integrate, duplicate, de-duplicate, add primary key and foreign keys, and index to merge and sharp data sources for further analysis.
- Developed advanced SSAS models with multiple cubes; updated fact tables to keep redundancy minimal.
- Created SSRS report, such as drilled down, drilled through and parameterized reports with T-SQL query to pull data from MS SQL databases.
- Extracted and transformed Source Data by SSIS. Soundly used SSIS transformations, Such as Fuzzy Lookup, Conditional Split, Merge, Union ALL and Derived Column.
- Deployed SSIS Project with both Project Deployment Model and Package Deployment Model. Set up environment in SSISDB Catalog. Created SQL Server Agent jobs for auto-run SSIS package, such as SSAS cubes’ refreshment.
- Worked closely with end users with very little technical background. Translated requests to BI and delivered Solutions to meet end users’ needs.
Environment: Microsoft Visual Studio 2012, SQL Server Management Studio(SSMS), SQL Server Integration Service(SSIS), SQL Server Reporting Service(SSRS), C#, PowerPivot, Power BI, SharePoint, Source Control, T-SQL, Excel.
Confidential, North Brunswick, NJ
SQL SERVER/Tableau Developer(SSMS/SSIS/Tableau)
Responsibilities:- Created and maintained database for the company’s daily operation.
- Monitored SQL Server Database and assisted solving SQL server related issues.
- Used SSIS to extract data of orders, freight schedule and account payable every day from various sources such as flat file, Excel and other Relational Databases and inserted them into SQL Server Database.
- Developed, modified and upgraded store procedures based on changes made in operation to maintain data processing quickly and efficiently.
- Created views for the most retrieved data sets to make sure every team member has access to updated key data sets.
- Scheduled ETL Process to populate Data Marts.
- Summarized, converted and distributed data based on data value by using SSIS.
- Used Event Handler, and Custom Logging to created Logging, Error Handlin for SSIS Packages.
- Created Gauge Report, Sub Reports, Drilled Down Reports, Summary Reports, Linked Reports and Parameterized Reports in SSRS and Tableau for different departments.
- Extracted data from Flat file, Excel and Relational Database to generate reports from Tableau.
- Created tableau worksheet of quarterly financial and operational reports, and implemented the business logic by customization. Compiled worksheets into dashboards to give clients Confidential clear understanding of quarterly performance.
- Highly involved in configuring service on server, member permission and configured SharePoint farms, created team sites and monitored workflow.
- Configured documents properties and set alerts on files based requirements.
- Deployed Dashboards to SharePoint, assisted authentication of the items, and granted access to selected groups and users.
- Benchmarked dashboards and reports with query result from database and debugged unmatched results among reports and dashboards based on different sources.
Environment: MS SQL Server 2008/2008r2, SQL Server Integration Service(SSIS) 2010, SQL Server Reporting Service(SSRS) 2010, C#, SharePoint 2010, Tableau 7.0/8.0, T-SQL.
Confidential, Trenton, NJ
BI/Tableau Developer (SSMS/SSIS/SSRS)
Responsibilities:- Designed relational/dimensional SQL Server database/DataMart using Visio, implemented in SQL Server Management Studio(SSMS) and migrated data using SQL Server Integration Service(SSIS) and SQL Server Management Studio(SSMS).
- Created and maintained stored procedures, user defined functions, views, tables and T-SQL scripting for managing complex business logic.
- Scheduled ETL packages to keep extracting the data from OLTP systems at specific time intervals.
- Used various script tasks, look up transformations, control flow tasks like File System Task, bulk insert task, transfer job task etc. and different data flow tasks using T- SQL and C# scripts to create ETL packages for data extraction.
- Implemented Event Handlers and Error Handling in SSIS packages and notified process results to Manager.
- Proficient in designing and developing various reports such as matrix report, linked reports, sub-reports, parameterized reports, drilled down reports, drilled through reports and snapshot reports in SQL Server Reporting Services(SSRS) and deploying to end users through data-driven subscriptions and SharePoint Server.
- Built ad-hoc reports using SQL Server Reporting Services(SSRS) and Excel and created dashboards that include that report.
- Optimized reports at the server, report, and item levels based on report execution time specifications in the business rule.
- Optimized reports by altering embedded queries or modifying stored procedures which generate reports.
- Designed and written the queries in the query builder for retrieving the data.
- Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules.
Environment: MS SQL Server 2008, SQL Server Integration Service(SSIS), SQL Server Reporting Service(SSRS), Microsoft Visio, Cenbase Portal, SharePoint.
Confidential, Paramus, NJ
BI Developer (SSMS/SSIS/SSRS/Report Builder)
Responsibilities:- Used SSIS to develop ETL jobs for extracting, cleaning, transforming and loading data into data warehouse.
- Integrated data from different departments into staging database using the SSIS ETL tools, and cleansed, loaded the processed data into the data warehouse.
- Designed ETL packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
- Designed and developed Ad-hoc reports including drill-down reports, drill-through reports, cascading reports and dashboard reports to meet requirements for Retail Banking management and daily operation
- Used report builder to customize parameterized reports, Sub reports, Nested Region reports and Linked reports
- Created calculated fields in report using functions including Switch, IIf, Lookup, Lookup Set, Count, Count Distinct, Sum, Left, Right, Get Char, Month, Month Name, Date, and Row Number
- Managed Sorting and Filters within the matrix table and group.
- Developed subscription tasks to run and deliver daily reports, monthly reports and quarterly reports
- Reviewed and proved report data with Synergy reports, Teller Desktop and the documents from branches as to guarantee the accuracy of report data.
Environment: MS Office Suite, MS Excel, SQL Server 2005, SQL Server Integration Service(SSIS), SQL Server Reporting Service(SSRS), Windows XP, TFS (Team Foundation Server).