SUMMARY

• 6+ years of IT experience in Development and business intelligence of Microsoft SQL Server, Power BI, SSIS, SSRS with various business domains like Health, Electrical, Technology, Education and Health domains.
• Experience in managing security of SQL Server 2017/ 2016/2012/2008 R2/2008/2005 databases by creating database users and roles and assigning proper permissions according to business requirements.
• Strong SQL Server 2016/2012/2008 R2/2008 development skills including writing stored procedures, user - defined functions, triggers, views, and indexes.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables. Strong experience in Stored Procedure/TSQL coding, Performance tuning, and Query Optimization.
• Created complex reports, dashboards and workbooks using Power BI Desktop and Published to Power BI Server and SQL Server Reporting Services
• Proficiency in software development life cycle (SDLC) and AGILE methodologies of development process such as requirement analysis & definition, prototyping, proof of concept, designing, coding, testing and implementation.
• Expert in SQL Server Business Intelligence suite of products like SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS).
• Hands on experience with performing various SSIS data transformation tasks like Lookups, Fuzzy Look ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Expertise in dealing with RDBMS including E/R Diagrams, Normalization and De-Normalization, Constraints, Data Import and Export etc.
• Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by
• Region, Year, Quarter, Month and Week.
• Hands on experience in creating Reports using R-language and R-Packages.
• Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations using connectors, tasks and transformations provided by SSIS.
• Strong experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and Sub queries with T-SQL.
• Imported data from SQL server DB, Azure SQL DB to Power BI to generate reports.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.
• Designed different type of reports including: Tabular forms, Matrix (cross Tab report) forsm, Conditional, List items, Charts and Sub reports.
• Excellent experience in developing stylish Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users Using SSRS.

TECHNICAL SKILLS

Operating systems: Windows XP/Vista/7/2008R2

Databases: SQL Server 2005/2008/2008 R 2/2012/2016/2017 Access

Database tools: SQL Enterprise Manager, SQL Profiler, DTS Import/Export, SQL Client Configuration utility, Backup Server, Replication Server, Microsoft OLAP Services, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), SQL Data Tools, EDI

ETL tools: DTS, SQL Server Integration Services, SQL Server Analysis Services, EDI Kit

Reporting tools: SQL Server Reporting Services (SSRS), Power BI, Crystal Reports

Development skills: Transact SQL (T-SQL), PL/SQL

Languages: C, C++, HTML, XML, VB.NET, ASP.NET (C#)

Application packages: Microsoft Office Suite

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Senior SQLBI Developer

Responsibilities:

• 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 ware house.
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Gathering business requirements from various users of different Departments.
• Worked on all types of transformations that are available in Power bi query editor
• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• Tuned Poor performing SQL Queries with SQL Profiler Trace and Query Analyzer.
• Documented all the migration process documents for future reference
• Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation
• Extensively worked on creating SSIS packages and have used for each Loop containers, Sequence Container for developing processes and loaded data using different transformations such as Derived Columns, Condition Split, Aggregate, Merge Join and Union all.
• Created and scheduled SSIS packages to pull data from SQL Server database and export the data to various data sources like excel spreadsheets, flat file etc. and vice versa.
• Deployed SSRS reports in share point for web-based access for multiple end users
• Installed and configured Enterprise gateway and Personal gateway in Power BI service.
• Participated in project planning sessions with project managers, business analysts and team members to analyse business requirements and outline the proposed solution.
• Installed Power BI Gateway and Scheduled Power BI refresh to Maintain fresh data.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation

Confidential, Dallas, TX

Senior SQL/SSIS/SSRS Developer

Responsibilities:

• Created Database Objects, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Used query statements like sub queries, derived tables to insert the data depending on the requirement into the tables.
• Built metric reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards with Power BI service
• Optimized SQL queries for improved performance and availability.
• Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
• Experience in working with different control flow elements like Data Flow Task, Bulk Insert Task, Active X scripts, Execute SQL Task, Script Task, Send Mail Task, and XML Task.
• Created the SSIS templates by implementing the package configurations, auditing, logging, and event handling.
• Responsible for making weekly backup databases and restore these databases in different server.
• Project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Lookup, For Each Loop, Script Components, error handling.
• Involved in code review and code review meetings
• Created 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.
• Custom logging using script tasks and event handlers in SSIS packages.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database.
• Built MDX Queries using SQL Server Analysis Server (SSAS) 2008
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.

Confidential

MSBI Developer

Responsibilities:

• Explored data in a variety of ways and across multiple visualizations using Power BI. Expertise in analysis, Data collection and visualization.
• Debugging of stored procedures, Indexes, Triggers, Views, User Defined Functions and Cursors.
• Used various script tasks, look up transformations, control flow tasks like FTP, bulk insert task, transfer job task etc. and different data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Responsible for performing Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Created and scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for daily, weekly and monthly loads.
• Developed reports and dashboards using Microsoft Power BI stack -Expertise in Creating reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc.
• Worked on performance tuning of SSIS packages using error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Involved in writing MDX queries and performance optimization of the SSAS cubes for calculated members and measure groups.
• Scheduled reports to run daily, weekly, monthly based on the requirement Report Manager.
• Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment.
• Created Parameterized, Cross-Tab, Drill down & Drill Through reports by using SSRS.
• Developed and Reviewed design documents, test plans, user documentations and promotion documents prepared by the team.
• Written various T-SQL scripts to check whether data is ready from different sources and to view database tables log that accessed last time.
• Created several reports using SSRS like drill through reports, linked and sub reports.
• Worked on the Optimization and restructuring of stored procedures for the application by evaluating indexing and partitioning large tables.
• Designed XML stages for reading XML log files for capturing data stage jobs audit data.
• Used the ETL Data Stage Director to schedule and running the jobs, testing and debugging its components & monitoring performance statistics.