SUMMARY

• More than 7 years of experience in SQL Development, Data Warehousing, Reporting and Business Intelligence solutions using SQL Server 2019/2017/2016/2014/2012 and MSBI tools (SSIS, SSAS, SSRS,Power Bi and C#).

TECHNICAL SKILLS

Data Warehousing & BI: SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS)

Reporting Tools: SSRS 2017/2016/2012/2008 , Crystal Reports XI/X/9/8, Excel, Power BI, Tableau.

Database: MS SQL Server 2018,2016, 2014/2012/2008/2005 , Oracle 10g/9i/8i, PostgreSQL 9.0/9.1, MYSQL, MS - ACCES, MDS.

Programming: C, C++, Visual C++ 6.0, VB6.0, C#.Net, VB.Net, PL/SQL, TSQL, Java, EE, Shell Scripting.

IT Processes: Software Development Life Cycle (SDLC), Project Management

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio, SSMS

Operating System: Windows Vista/NT/XP/98/95, Windows 2003/2000 Server.

Application Servers: Microsoft IIS 6.0/5.0/4.0, Apache.

Web Technologies: HTML, XML, JSON, JavaScript, PHP, jQuery.

PROFESSIONAL EXPERIENCE

Confidential, Seattle, Washington

SQL/ SSIS/SSRS/Power BI Developer

Responsibilities:

• Developed T - SQL Scripts to validate the data after the loading process. Modified and tested T-SQL stored procedures
• Written complex SQLs using joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data.
• Transformer, Lookup, Merge, Join, Aggregator, Sort, Filter and Remove duplicates stages were extensively used to Cleanse/Transform the data extracted into staging.
• Modified and tested T-SQL stored procedures.
• Extracted and loaded SharePoint lists and Surveys Data into SQL Server Database with SQL Server Integration
• Implemented Indexes, Constraints, Views, Cursors and Optimizing Queries, Execution Plan, Tuning the database.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures, and Triggers.
• Involved in all the phases of ETL process and performed different roles in the different phases of the project.
• Created test data and unit test cases to ensure successful data loading process including creating XML and SQL Server package configuration to make package dynamic using SSIS package
• Designed dynamic ETL solution using SSIS packages to implement Slowly changing dimensions of Type 2 to populate current and historical data into Dimensions.
• Responsible to design and developthe ETL data flowto populate the CER Cube Analysis Database using theSQL Server Integration Services (SSIS).
• Scheduled and automated the packages to populate the data in the cube daily up to date for business reporting
• Involved in the troubleshooting and resolved complex technical issues, performance tuning of the databases.
• Analyzing business requirements and worked closely with the business users to
• Strong technical expertise of understanding business requirements and designing the process for the data extraction, business logic implementation and loading into target tables. Identifying
• Establishing end-to-end complex data migration, conversion and data modeling. Defined the migration strategy and plan.
• Developed drill-through, drill-down, sub-Reports, Charts, Matrix reports, linked reports usingSQL Server Reporting Services (SSRS).
• Prepared detailed reports for the customers throughout the cycle
• Imported data from SQL Server DB,Azure SQL DB to Power BI to generate reports.Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up-to-date with on premise data sources.

Confidential, New York, NY

SQL/SSIS/SSRS Developer

Responsibilities:

• SQL Server Data warehouse Developerfor the Confidential EDW and BI projects team.
• Involved in all the phases of the Sales and Billing project from scratch and end to end and performed different roles in the different phases of the project.
• Developed database object asT-SQLstored procedures, user defined functions, triggers, views, Advanced queries, indexing.
• Strong technical skills of writingSQL, PL/SQLprograms required to retrieve data using cursors and exception handling.
• Leading skills in working with high volume datasets from various sources like Text files, Relational Tables and xml targets.
• Responsible for mandatory checks, date field checks and number field checks in ETL packages.
• Extracting Transform and loading data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL.
• Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data inAzure Databricks.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Support deployment of solution, cut over planning and execution activities
• Strong Design and implementing skills in the ETL processes using SSIS which involves collection of data from sources like SQL Server 2014/2016/2018.
• Detail design of source to target data mappings
• Extensive experience with Data warehousing techniques (Star Schema, snow flaking, denormalization, Normalization, Aggregations)
• Working with enterprise application integration personnel to anticipate and resolve data integration issues across applications and technical infrastructures
• ETL testing experience and verification utilizing SQL querying skills (PL/SQL, Toad, or other tool) and formal testing methodologies
• Comprehensive understanding of data analysis and/or reporting along with strong knowledge of databases and related technologies (SQL, OLAP, etc.)

Confidential

BI (SQL/SSIS/SSRS) Developer

Responsibilities:

• Effectively translating technology terms and functionality into a business vocabulary understandable by non-technical staff
• Understanding of ETL concepts of data flow, data enrichment, data consolidation, change data capture and transformation
• Recent experience with development process; including requirements, design, construction
• Testing and implementation required working with data warehouse architecture, extract/transform/load (ETL) and business requirements gathering and analysis
• Proven ETL/Data Integration experience using the following: Scripting, PL/SQL, and Microsoft SSIS
• Critical thinking and analytical skills; ability to take loosely formed ideas, coordinate and evolve them
• Understanding of Data encryption, TDE, and key management - Intermediate level knowledge/experience
• Spark development including data frames, data transformations, performance tuning, memory sizing and tuning Spark Master and Executors
• Strong requirements development (facilitation) and design skills in BI solutions
• Providing first/second level troubleshooting, technical and operational support with limited guidance
• Identifying reusability across projects by leveraging and customizing the data integration patterns and designing reusable framework
• Responsible for project’s analytical requirements management and estimations
• Analyzing the impact of changes on existing ETL/ELT processes and systems. Assesses the compatibility with goals in all areas. Analyzes cost effectiveness and feasibility
• Utilizing SSIS, along with related operating system and database procedures and functions to construct efficient code to transform and load required solution data to our operational staging, warehouse and reporting layers of the data repository stack from disparate source systems.
• Facilitating data retrieval and manipulation through implementation of Views, Procedures, Triggers and Cursors.