SUMMARY

• 6 Year experience as SQL/BI/SSIS/SSRS developer
• Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL data ware house environment
• Design & implement migration strategies for traditional systems on Azure (Lift and shift/Azure Migrate, other third - party tools) worked on Azure suite: Data Lake(ADLS), Azure Data Factory(ADF) V2, Azure Blob Storage
• Participated in designing and implement end-to-end data solutions (storage, integration, processing, visualization) in Azure
• Engage with business users to gather requirements, design visualizations and provide to use self-service BI tools.
• Experience in SDLC (Software Development Life Cycle) involving System analysis, Design Development & Implementation cycle
• Created different type of reports including Cross-tab, Drill through, Drill-down, Sub reports, and parameterized reports
• Experience in troubleshooting and resolving architecture problems including database and storage, network, security and applications
• Extensive knowledge in ER Diagram and design of logical and physical data modeling using Oracle Data modeler.
• Extensive experience in designing de-normalized data warehouse including Star Schema, Snow Flake Schema and data flow diagrams.
• Extensive experience in creating and using Stored Procedure, Views, Triggers, schemas and Complex queries onSQLServer Management Studio.
• Extensive work experience on creating different Synonym, Common Table Expressions, Table and User-Defined Function Types
• Expert in creating Dynamic SSIS Packages with Parameters, local and environmental variables and check points
• Hands on Experience on SSIS package development, deployment and scheduling
• Expert in creating data visualizations such as dashboards, parameterized reports, drill down reports, and interactive reports using SQL Server Reporting Service.
• Experience inPerformance Tuning and Query Optimization
• Strong interpersonal communication skills and problem solving skills

PROFESSIONAL EXPERIENCE

SSIS/SQL Developer

Confidential, Dallas, Texas

Responsibilities:

• Experience in Extracting, Transforming and Loading (ETL) data using different transformations from SFTP to on premise DB
• Experience in Designing and Building the Dimensions and cubes with star schema usingSQL Server Analysis Services(SSAS).
• Create and maintaining stored procedures, SSIS packages, Agent Jobs setting to ensure they are applied with new business rules, including loading additional files, and applying new validation logics.
• Check in and out SSIS packages, in Team Foundation Server(TFS)
• Follows data standards, resolves data issues, completes unit testing and system documentation for Extract Transfer Load (ETL) processes
• Gathers business requirements and works with data analysts to convert requirements into SQL stored procedures and functions.
• Review, analyze, and ensure the quality of data loaded into the database
• Performs code reviews, analyzes execution plans, and re-factors inefficient code
• Collaborates with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements
• Follows change management process to resolve application defects or to implement development enhancements
• Perform Data profiling and analysis of structured and unstructured data
• Participated in designing and implement end-to-end data solutions (storage, integration, processing, visualization) in Azure
• Unzip large password protected health data using Scala language
• Load and store data in Azure Blob storage
• Documented and delivered Functional Specification Document to the project team by using SQL Server

Confidential, Herndon, Virginia

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation
• Developed various T-SQL objects such as functions, tables, views, triggers, indexes, constraints, stored Procedures and queries to be used in the project
• Worked with data extraction using SSIS and Data Warehouse staging, and loading.
• Monitored queries using query analyzer and tuned queries and procedures to boost database performance
• Provided ETL solutions to populate and enhance out data stores, design and build optimized data structures, data pipelines to transform and validate data
• Support back end database for Appian front end Application
• Provided ETL solutions to populate and enhance out data stores, design and build optimized data structures, data pipelines to transform and validate data
• Experience in creating Jobs, Alerts,SQLMail Agent, and scheduleSSISPackages
• Learned and experienced the DW/BI Project Lifecycle projects and tasks required for successful implementation of DW/BI Engagements
• Performed Data Warehouse Requirements Gathering with Business Sponsors for new requirements as well as translations of existing legacy reporting; including intake documentation and created conceptual design and detailed designed documents for DW/BI implementations
• Designed logical and physical data models for Dimensions, Facts, Operational Data Sources, 3rd normal form tables and Slowly Changing Dimensions; including aggregations, deformalized tables, snowflake schemas and other staging data warehouse structures
• Designed and Developed complex ETL Mappings to transform data and load from various sources to an Enterprise Data Warehouse consisting of staging tables, facts and conformed dimensions
• Designed and implemented Business Intelligence architecture including user security, metadata layers and report authoring layers including dashboards, prompts, drill- through to detail and compound layouts

Confidential, Washington, DC

Responsibilities:

• Involved with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance
• Develop and improve continuous integration and deployment processes and contribute to the ongoing development of the data warehouses ecosystem
• Worked with different types of dimensions, fact tables, operational data Store (ODS), leveling and other data warehouse concepts
• Created different type of reports including Cross-tab, Drill through, Drill-down, Sub reports, and parameterized reports
• Monitored time taking queries with performance tuning to reduce the execution time
• Export and import data from Flat file, CSV file, Excel salesforce and to/from SQL Server database using SSIS
• Supported back end database for Appian front end application by writing complex stored procedures and functions
• Developed Complex SSIS Packages to load data into Staging, ODS, and Data Warehouse systems.
• Developed various T-SQL objects such as functions, tables, views, triggers, indexes, constraints, stored Procedures and queries to be used in the project
• Optimizedthe performance of queries with modification in PL/SQL queries,creating sub queries, establishing joins and creatingindexes wherever necessary
• Developed, monitored and deployed SSIS packages for ETL flow tovalidate, extract, transform and load data into database
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan
• Design and Developedmultiple enterprise reports using SSRS fromboth OLTP andOLAP databases
• Tested the reports and fixed bugs in the stored procedures.Involved in scheduling the reports and setting security for reports

Confidential, Denver, Colorado

SQL Developer

Responsibilities:

• UsedSSISandT-SQLstored procedures to transfer data fromOLTPdatabases to staging area and finally transfer into data warehouse.
• Experience inMicrosoft C#in script component of SSIS.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup, etc…for Data scrubbing, data validation checks during staging, before loading the data into thedata warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Experience in creating Jobs, Alerts,SQLMail Agent, and scheduleSSISPackages.
• Designed, developed and tested the Data Stage jobs using Designer and Director based on business requirements and business rules to load data from source to target tables.
• Defined the report layout and identified Datasets for report generation.
• Created different type of reports including Cross-tab, Drill through, Drill-down, Sub reports, and parameterized reports.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• Created Packages to group logically related column types and to transfer data.
• Documented and delivered Functional Specification Document to the project team by using SQL Server.and: