SUMMARY

• Over 5+ years of experience in database design, administration, development using Microsoft Business Intelligence technologies: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI, and Tableau.
• Proficient in gathering Business Requirements from business stakeholders, analyzing documenting System Requirement specification, Functional Requirement specifications and maintaining Requirements.
• Expertise in writing T - SQL queries, dynamic queries, sub-queries and complex joins for generating complex stored procedures, triggers, user-defined functions, views and cursors.
• Involved in the development and implementation the full suite of Data Warehouse solutions: Data Warehouses and Data Marts, Cubes and ETL processes.
• Good understanding and designing of Star and Snowflake data models Schema used in relational, dimensional, and multidimensional data modeling.
• Experience in creating and deploying SSIS Packages on high-activity, normalized transaction systems (OLTP), highly usable de-normalized reporting systems (OLAP) as well as staging areas and data marts.
• Proficient in Data Transformations, Tasks, Containers, Sources and Destinations like Derived Column, Conditional Split, Union all, Merge, Lookup and Merge Join Transformations to load data into Data Warehouse, Drill down and drill through Reports, Dashboard Reports.
• Proficient in Requirements Analysis, Designing, Coding, Testing, Deployment and Maintenance.
• Expert in designing, developing, and deploying of Cubes and creating role-based security and row level security in cubes using SSAS.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Experience with advanced Power BI topics such as complex calculations, table calculations, geographic mapping, and performance optimization.
• Good knowledge in creating and developing Power BI Dashboards and Reports in to rich look and Stunning Visualizations.
• Through knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, SQL Profiler and other database related activities.
• Provided 24x7 production support to Batch, continuous flow process for daily, monthly and weekly job schedule.
• Ability to work under pressure and simultaneously on multiple projects and capability of working under aggressive deadlines.
• Handle various change requests & Enhancement requests coming from clients.

TECHNICAL SKILLS

Operating Systems: Windows 2010/2008/2000/2003 , Windows XP.

Databases: MSSQLServer2016, 2014, 2008 R2, 2008, Oracle, MS-Access.

Programming Tools: T-SQL, C#.Net, VB.Net

Databases Tools: SQLProfiler, Query Analyzer

Reporting Tools: SQLServerReporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI

ETL Tools: SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS)

Web Technologies: XML, JSON

Other Software Tools: MS Office/Excel, Visual Studio-2019, Erwin, SharePoint, MS Visio

PROFESSIONAL EXPERIENCE

SQL/ETL Developer

Confidential, Irving, TX

Environment: MS SQLServer 2016, SSRS, SSAS, SSIS, T-SQL and TFS, Visual Studio-2019, C#.Net, MS-Office, Power BI.

Responsibilities:

• Coordinating with business users in analyzing business requirements and translating them to technical specifications.
• Designed and implemented the ETL processes using SSIS which involved collection of data from sources like SQL Server 2008/2014.
• Developed and deployed SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files, Flat files.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Automated File Transfer Processes and mail notifications by using FTP Task and Send Mail task in packages.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Designed and built-up high performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS.
• Extracted data from different sources and stored the data into the intermediate Staging Database using SSIS ETL tool.
• Creating and managing schema objects such as, Tables, Views, Indexes, and referential integrity depending on user requirements.
• Multi-geographic Technical Support (for all Windows 2000/2003/2008/2012 Virtual/HP/Dell/IBM/Cisco 8000+ servers) over the phone, in person, or via e-mail and using Ticketing System (Service-Now), handling each with professionalism and timeliness.
• Worked on several complex drilldown, parameterized reports and on reports that call sub reports using SSRS.
• Developed mock-up Tableau Dashboards to explore options for visualization of data, presentation, and analysis.
• Created and published data sources to the Tableau Server and used for developing and designing dashboards on Tableau Desktop.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
• Promoting the data to the higher environments.
• Collaborated with other members of the product development as well as the front-end team.

SQL Developer

Confidential, OK

Environment: SQL Server 2008R2/2012, SSIS, SSRS, SSAS,C#.Net

Responsibilities:

• Involved in Preparation of documentation for all the requirements and enhancements to reports.
• Design and develop SSIS packages, Store Procedures, configuration files, tables, views, functions and to implement best practices to maintain optimal performance.
• Successfully migrated the data between the heterogeneous sources like Flat File, Excel Source, Oracle and SQL server using SSIS.
• Hands on experience working on Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Developed SSIS Templates, which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Test and Production Environments.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created SSIS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Created cross validation rules to ensure mapping accuracy.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Ability to handle Multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.

MSBI Developer

Confidential, Red Oak, TX

Environment: SQL Server 2000/2005/2008 R2, SSRS, SSIS, T-SQL, Jira etc.

Responsibilities:

• Created Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Created scripts components to write customer functions in dataflow used data grids to display the data in a customized way.
• Created SQL Server Integration Service (SSIS) packages between enterprise databases and third-party data source to transfer data.
• Ensured SSIS Packages to read data from different locations to stage database.
• Ensured and monitored store procedures and functions for SSIS packages to transfer data in Load database.
• Monitored an application on different platforms using VMWare.
• Monitored queries for optimization while execution.
• Designed and developed cascaded and parameterized SSRS reports.
• Job monitored through Sql server Agent and DB Visualizer.
• Provided the Test feedback to the client and getting sign-off from the Test Results.
• Worked on new reports as per the business requirement and provide optimize performance tuning suggestions.
• Worked with Business Client to gather requirements and provide them essential feedback.
• Communicated with the Business Analyst's to prepare the Requirement/Specification document.
• Prepared Technical Architecture Document and guided Offshore Team members to prepare design documents
• Checked the status from offshore team on day-to-day activities and reviewed the work done by the offshore team.
• Provided standard solution across all markets in globe for all new implementation and updating in existing system.
• Worked with the client to open the CMR and SSR and got the codes to be migrated to production.
• Closely involved on critical issues requiring quick resolution and involved in resolving all Dashboard problems.
• Coding, preparing test cases and test result for assigned module.