Archana
Archana.Malneni@gmail.com
240-848-0240
Lexington, KY 40505
SQL BI Developer
13 years experience W2
2
Recommendations
Average rating
230
Profile views
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.

Experience
Education
Skills
Database Design
2021
6
Microsoft Excel
2021
6
BI Developer
2021
5
ETL
2021
5
SQL
2021
5
SQL Server
2021
5
SSIS
2021
5
Stored Procedure
2021
5
Visual Studio
2021
5
Business Intelligence
2021
4
Data Warehousing
2021
4
OLE-DB
2021
4
SSAS
2021
4
SSRS
2021
4
T-SQL
2021
4
Triggers
2021
4
Metadata
2021
3
Project Management
2014
2
Data Integration
2012
1
Database Backups
2012
1
Database Upgrades
2012
1
DBA
2012
1
Disaster Recovery
2012
1
MySQL
2012
1
Performance Tuning
2012
1
Windows
2012
1
XML
2012
1
Agile Methodology
0
1
OPTIM
0
1
Requirements Gathering
0
1
Scrum
0
1
System Design
0
1