Employment History 

• SQL / Power BI Developer

  Colaberry Inc.

  February 2019 - Present

  • Involved in planning, defining, and designing database based on the business requirements document BRD.
  • Created SSIS packages to extract the data from multiple sources like Excel, XML and OLTP and consolidate them into staging tables.
  • Used multiple SSIS transformations such as: data conversion, derived column, conditional split to cleanse and validate data.
  • Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
  • Scheduling Jobs and Alerting using SQL Server Agent.
  • Followed a star schema design in data warehouse creation, which outlined measurable financial data in the fact table, along with detailed data in surrounding dimension tables.
  • Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS) to display in a customized format as per business requirements.
  • Created and deployed reports to report manager and troubleshooting for any error occur in execution.
  • Created Sub-Reports, Drilldown-Reports, Drill through, Summary Reports, and Parameterized Reports in SSRS.
  • Ensure all reports meet agency and performance requirements.

• SQL / SSIS Developer

  LendingTree

  January 2018 - January 2019

  • Gathered business requirements, definition and design of data source and data flows
  • Created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For Loop and Foreach Loop Container, Execute SQL/Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge
  • Join, Union All, flat file source and destination, OLE DB source and destination, excel source and destination.
  • Designed SQL database with control and audit schema tables to maintain historical data and error handling.
  • Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production
  • Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler
  • Created Sub-Reports, Drilldown-Reports, Drill through, Summary Reports, and parameterized Reports in SSRS