PROFESSIONAL SUMMARY:

• Over 6+years of experience in developing BI applications utilizing SQL server, BI stack, Power BI and Tableau.
• Involved in Business Analysis of the OLTP and OLAP data and in decision support .Extensive database programming.
• Significant experience in building SSAS cubes and Dimensions with different Architectures and Data Sources for Business Intelligence and writing MDX scripts.
• Hands on experience in writing T - SQL Stored Procedures, Triggers, Constraints and Indexes using various DDL and DML commands.
• Developed T-SQL scripts for performing automation tasks, Performed and fine-tuned Stored pprocedures and SQL Queries and User Defined Functions.
• Strong Knowledge of Data Warehousing methodologies and including star schemas, snowflakes concepts.
• Used N-tier architectures for presentation layer, the business and the data access layers and were coded using C#, worked with Agile methodology for application development.
• Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning.
• Proficient in Creating, Configuring workflows designed in MS SQL Server Integration Services (SSIS).
• Experience in Reporting Services, Power BI (Dash Board Reports), Crystal Reports, SSRS using MS SQL Server and in supporting services MDX technology of the Analysis services.
• Proficient in designing and scheduling complex SSIS Packages for transforming data from multiple data sources and integrate data based on business logic and to load it in data warehouse.
• Designed ETL using SSIS Packages to reprocess any date data at any time using Reprocess logic.
• Developing C# scripts in SSIS and automating tasks using C#.
• Maintaining the Log and Audit information in SQL tables, Experienced in providing Logging, Error Handling by using Event Handler for SSIS Packages.
• Having Knowledge in Dimensional Data Modeling, Cube development and manipulation in SQL Server Analysis Services (SSAS).
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as Event tracking, Members billing and Person payment along with slicers and dicers enabling end-users to make filters.
• Implemented Power BI gateway different source to matching analysis criteria and further modeling for Power Pivot and Power View.
• Experience in designing and developing SSRS reports using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Excellent analytical, communications and interpersonal skills.
• Proficient in technical writing and presentation and a good team player.
• Strong investigative and troubleshooting skills.

PROFESSIONAL SKILLS:

Databases: MS: SQL Server 2016/2014/2012/2008 R2/2008/2005, Oracle 9i/10g, MS Access, DB2

Programming Languages: T SQL, PL/SQL, C, C#, ASP, VB Script, .NET Framework

BI/Data Warehouse Tools: MSSQL (SSIS, SSAS, SSRS), SQL Server Business Intelligence Development Studio (BIDS), DTS, Enterprise Manager, SQL Profiler, OLTP, OLAP, SQL Server Management studio (SSMS), SQL Query Analyzer, Web Services, BCP, SQL Server Agent, Visio

Operating Systems: Windows NT/98/2000/XP/2003 Server, Unix, Linux, Sun Solaris.

Version Control & Web Servers: HTML, XML, Visual SourceSafe (VSS)

Data Modelling Tools: Erwin, ER Studio, MS Visio, DTS Enterprise Manager

Tools: Tableau, Power BI, Azure, Team Foundation Server (TFS), SharePoint.

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, VA

Sr. SQL/SSIS/SSAS Developer

Responsibilities:

• Gathered the business system requirements and act as a SME for the system and business and created status reports.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Worked with Business Analysts, Developers and customers to resolve and escalate project issues.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and CSV files.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created Multidimensional cubes using SSAS as per the business requirements.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQLServer Analysis Services (SSAS) for analyzing purpose.

Confidential, Lewisville, TX

SQL Server Developer

Responsibilities:

• Created and scheduled SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Creating T-SQL objects to be used as a source in SSIS and SSRS.
• Testing of T-SQL scripts and performance tuning of those scripts using SQL Profiler
• Loading incremental (Delta) data from different sources like flat delimited text files, Excel spreadsheets, Access tables to the SQLServer database tables.
• Database Backup and restore operations.
• Extensively worked on designing reports usingSQLServer Reporting Services (SSRS).
• Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS.
• Generated reports usingSQL ServerReporting Services (SSRS).

Confidential, Coppell, TX

SQL Developer

Responsibilities:

• Responsible for development and management of SSIS, SSAS and SSRS projects.
• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, fuzzy look up, for each loop, multi cast, column conversion, fuzzy grouping, and script components.
• Experience on created reports using stored procedure. Involved in scheduling, creating snapshot and subscription for the reports.
• Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.