OBJECTIVE

• Highly motivated Professional over 8+ Years of experience in IT includes extensive Functional and Technical experience in Business Intelligence (BI) product development and reports generation experience along with Business Analyst experience of translating business needs into long - term business intelligence solutions with the Power BI, Business Objects, Crystal Report, Tableau, MS SQL Server platform with SSIS and SSRS and other related tools.

SUMMARY

• Over 8+ years of experience in the field of information technology with expertise in Database Design, Development, Implementation and Support of MS SQL Server 2016/2014/2012/2008 R2/2008 and over 4+ years of experience in suite products like SSIS, SSRS, and SSAS.
• Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Extensive Experience in creating, configuring and Fine-tuning ETL workflows designed between Homogeneous and Heterogeneous Systems using DTS and SSIS of MS SQL.
• Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSRS, SSAS) including MS solutions like MS EXCEL 2007/2010, Microsoft Office.
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
• Experience in various Extracting, Transforming and Loading ETL/SSIS data flow ETL/SSIS using SSIS. experience in Data Design and Development on Microsoft SQL Server 2012/2008R 2/2008/2005/2000 , T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing.
• Excellent in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration, also created Indexed Views, complex Stored Procedures, Triggers, effective functions to facilitate efficient data manipulation and data consistency.
• Highly Proficient in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts.
• Skilled in creating virtualization reports using Power BI.
• Extensive experience with data modeling, logical and physical database design using Erwin.
• Experience in using tools like Database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Experience in deploying reports on SharePoint Server using SharePoint Integrated Mode.
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.
• Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2012/2014/2016.
• Creating and deploying parameterized reports using Power BI
• Good SQL Server Administration skills including, Backups, Restore, database maintenance, user authorizations and Database creation.
• Used various SSIS components like Conditional split, derived column, multicast, OLEDB sources, OLEDB destinations, control flow components, data flow components, Aggregates, Execute SQL Used various SSIS components like Conditional split, derived column, multicast, OLEDB sources, OLEDB destinations, control flow components, data flow components, Aggregates, Execute SQL
• In depth understanding of SQL Server Migrations and problem management.
• On-call duty with teammates 1-2 weeks per month and active involvement in Go-live activities.

TECHNICAL SKILLS

Languages: Transact SQL, C, Visual Basic 6.0, VB.NET, C#, .NET, ASP.NET.

Web Technologies: HTML, Java Script, VB Script, XML.

Databases: SQL Server 2008/2012R2/2014, MS Access.

Operating Systems: Windows 95/98/2000/XP/NT, UNIX, VISTA.

ETL Tools: DTS, SSIS, Informatica, Import Export Data.

Data Modeling Tools: MS Visio.

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2012 Query Editor, Solution Explorer, Analysis Manager, Reporting Server.

Other Software: MS Office 2000/2003/2007/2010 , MS Visio.

Bug Tracker Tools: JIRA, Quality Center (QC), TFS through Visual Studio.

Code Management: Team Foundation Server.

PROFESSIONAL EXPERIENCE

Confidential, MINNEAPOLIS, MN

Senior SQL BI Developer

RESPONSIBILITIES:

• Created SSIS ETL packages in 2008R2/2016 to extract data from multiple sources like XML, OLE DB, Excel, Flat file, and JSON source.
• Collaborated with other DWH Architect in assessing fact and dimensional data modeling and applications.
• Ensured accuracy of data by defining and building necessary audits and controls.
• Designed and developed data load and ETL jobs using SSIS package scheduled in SQL Server Agent job.
• Collaborated with teams to design an algorithm to understand customer behavior leading to 95% success in targeted marketing campaigns.
• Created charts in Jupyter Notebook to perform preliminary analysis & visualize data using Matplotlib.
• Worked with the team to produce a workable model to optimize the company’s financial transaction.
• Excellent T-SQL and PostgreSQL development skills to write complex queries involving multiple tables, creating indexed views, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in Performance Tuning and Query Optimization.
• Experienced in using ETL tools like SSIS.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, JSON, Oracle to SQL Server by using BCP utility, DTS and SSIS services.
• Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
• Data analysis and data migration by transferring them using SSIS packages and later loading the data into Azure Cloud Servers
• Create ETL (SSIS) packages to develop jobs to extract, transform and loading data into data warehouse.
• Practice Reporting tools like SSRS to convert data into meaningful information.
• Day to day Profile database structure to identify the size, structure, and data types, etc. in SQL Server.
• Maintained Databases for development, testing and production environments and loaded scripts into TFS.
• Maintain excellent interpersonal and interaction skills with cross team and business users.
• Establish bridge between users and customers with converting raw data to meaningful financial information.
• Ability to coordinated with DBAs and other BI teams and facilitate meetings and delegate responsibilities.

Environment: SQL Server, SQL Server Data Tool, T-SQL, SSRS, SQL Server Profiler, MS Office, MS Windows 10, MS Team Foundation Server, Sales Force, SQL Red Gate Tools.

Confidential, IRVINE, CA

SENIOR SQL BI DEVELOPER

RESPONSIBILITIES:

• Implemented Complex business logic with User-Defined-Functions, Index, Views and also created User Defined Data types, Clustered & Non-clustered Indexes.
• Created database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005/2008/2008 R2/2012.
• Participated in migration from SQL Server 2005 to SQL Server 2008/2012.
• Experience in tuning of Stored Procedures and query optimization to improve the performance and eliminate the deadlock situations and hang-ups on server.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Charts, Drill down reports, and Ad Hoc reports using SQL Server Reporting Services (SSRS).
• Highly involved in creating, structuring, formatting reports using Report Designer and Report Builder.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on weekly and monthly basis.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Used Fuzzy Lookup and Fuzzy grouping transformations for improving the data quality of the existing data as well as new data that is being loaded into the database.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Designed the new data warehouse (DWH) while constructing the cubes and dimensions of a system for the purpose of analysis, decision making based on historical data.
• Created and designed dimensions and fact tables using star and snowflake schemas in SQL Server Analysis Service(SSAS)

Confidential, CHESAPEAKE, VA

SENIOR SQL BI DEVELOPER

RESPONSIBILITIES:

• Actively Participated in technical discussions to understand changes and to gather business requirements.
• Analyzed to find the impact to EDW and downstream applications due to upstream enhancements.
• Performed the Source system analysis to make sure source data is aligned with EDW Data model.
• Created Technical and ETL Design Documents with details of source tables and Transformation logic.
• Developed several complex SSIS packages and performed Unit & Integration Testing.
• Created SSIS (SQL Server Integration Service) packages to extract data and scheduled Jobs to call the packages and Stored Procedures using SQL Server Agent.
• Involved in Bulk Load and Incremental Data Load from various sources into SQL Server Database Engine with ETL Operations.
• Worked on creating SCD type I and SCD type II during incremental data loading from IR Server to EDW Server.
• Debugged issues and resolved time-to-time technical problems.
• Responsible for preparing the Release Documents and work with Release Management to release codes/objects to SQA and UAT environment.
• Responsible for fixing issues and bugs identified by SQA and UAT resources.
• Performed data query, extraction, compilation, and reporting tasks.
• Create T-SQL scripts to manipulate data for data loads and extracts.
• Created indexes, Views, complex Stored Procedures, user defined functions, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Performed Data Validation using SQL Server Management Studio 2008.
• Managed, updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables and V-Lookups, H-Lookups.
• Performed Data Analysis for automating various Customers Order Reports utilizing SSRS 2008.
• Designed and developed Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Expertise in Developing and Extending MS SQL Server Analysis Services 2012 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects.

Environment: MS SQL Server 2008R2, MS SQL Server Integration Services 2008R2 (SSIS), T-SQL, MS SQL Server Reporting Services 2008R2 (SSRS), SQL Server Analysis Service, MS Excel, MS Access, Oracle, DB2, Flat Files.

Confidential

SQL BI DEVELOPER

RESPONSIBILITIES:

• Used SQL Server Reporting Services (SSRS) for all reporting purposes, creation of new and modification of existing reports
• Developed rich interactive graphics and data visualizations of large structured data in browser-friendly formats.
• Gathered functional and non-functional client requirements in order to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).
• Planned, Defined and Designed data based on business requirement and provided documentation
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS
• Created new Data source and replaced with existed Data source. Created Schedules and Extracted the data into Tableau Data Engine.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps
• Generated parameterized reports, sub reports, tabular reports using SSRS 2012
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio
• Created various SSRS Reports involving variety of features like Charts, Filters, Sub-Reports, Multi-valued parameters and also understanding of the tablix control and Dashboard reporting, Share Point with Power View tool etc

Environment: SQL Server 2005/2008/2012 , ORACLE, MS Access, EXCEL, VBScript, HTML, XML, Visio, Windows Server 2003/2007/2008 , ASP.NET, VB.NET, BIDS 2005/2008,Visual Studio 2005/2008/2008 R2/2012, SQL Server Analysis Service.