Uploaded File
Archana
SQL BI Developer
9 years experience W2 Lexington, KY
Available immediately
Actively seeking
Archana
132
views
SQL BI Developer
2 recommendations
2
Recommendations
Average rating
132
Profile views
Database Design Microsoft Excel BI Developer ETL SQL SQL Server SSIS Stored Procedure Visual Studio Business Intelligence
Remove Note
View Note
Recent Experience
SQL BI Developer 02/14 - present
SQL Visual Studio Stored Procedure Data Warehousing SQL Server ETL SSIS SSRS Business Intelligence BI Developer Metadata Triggers T-SQL SSAS OLE-DB Database Design Microsoft Excel
BI Developer 09/12 - 01/14
SQL Visual Studio Stored Procedure Data Warehousing SQL Server ETL SSIS SSRS Business Intelligence BI Developer Project Management
SQL Server / BI Developer 07/11 - 08/12
SQL XML Visual Studio Stored Procedure SQL Server ETL SSIS Database Backups T-SQL Data Integration Triggers Disaster Recovery BI Developer MySQL Database Design Database Upgrades DBA Performance Tuning Windows
Summary

  • Over 6 years of IT Experience in System Design, Development and Support of Microsoft SQL Server technologies.
  • Strong experience in MS SQL Server 2008/2012/2016 with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and T-SQL.
  • Excellent working experience in major domains like Hi-Tech Services, Health Care and Banking.
  • Highly proficient in the use of TSQL (DDL, DML AND DCL) for developing/creating new database objects such as Tables, Views, Indexes, Complex stored procedures, function (UDF), cursors, and triggers, common table expressions (CTEs).
  • Extensive knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys Data Import/Export, Performance Tuning and Query Optimization.
  • Strong Knowledge in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.
  • Expertise in creating, configuring and fine-tuning ETL designs between Homogenous and Heterogeneous Systems using SSIS and SQL tools (DTS, SSIS, BCP and Bulk Insert).
  • Adept at developing SSIS Packages and using data transformations and deploying them on various production servers.
  • Experience in developing table, matrix and chart with drill-down and drill-through functionality.
  • Highly skilled in writing Parameterized queries for generating Tabular reports and Sub reports using Global variables, Expressions and Functions, Sorting the data, Defining Data Sources and Subtotals for the reports using SSRS 2012/2008.
  • Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2012 / 2008 (SSRS).
  • Participated in requirements gathering and analysis, as well as Design sessions to understand the needs of the users.
  • Excellent communication and inter-personal skills with ability to handle multiple tasks and responsibilities independently. Good proactive team member.
  • Good knowledge in software development methodologies including Scrum/Agile Model.
  • Experience in working with clients directly helping them meet their goals, coordinating work and establishing good rapport for mutually beneficial partnership.
  • Created Ad-Hoc reports for different markets and generated PDF and Excel copies based on the requirement of the market.
  • Excellent work ethics, self-motivated, quick learner, team player, and team oriented.
  • Continually provided value-added services to the clients through thoughtful experience, productive coding habits, and excellent logical aptitude and communication skills.
  • Ability to handle multiple tasks and work independently as well as in a team.

Top 5 Skills
SkillsProficiencyLast Used
Database Design
2020
Microsoft Excel
2020
BI Developer
2020
ETL
2020
SQL
2020
Education and Certifications
Preferences
Availability:Immediately
Willing to relocate?:Yes
Relocation preference
Any location
Prepared to Travel:No travel (0%)
Employment Type:Any
Security Clearance:No clearance
Citizenship:Employment Authorization Document