Uploaded File
Archana
Archana.Malneni@gmail.com
240-848-0240
Lexington, KY 40505
SQL BI Developer
10 years experience W2
2
Recommendations
Average rating
149
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
SQL BI Developer
Information Technology
Feb 2014 - present
  • Created and used the usage performance monitor fact and dimension table which stores data of Managed Print Services (MPS) details /Hourly/Daily and performance tuned the ad-hoc query used for the SSRS report.
  • SSRS graph report provides the information such as recurring charges, usage charges, toner purchase and ADHOC purchase information in different locations in graph format.
  • Designed transformation rules and processes to derive the correct data from the extracted data and transform into the required format and structure to support the business requirements.
  • Loading the transformed data into the target database and the associated metadata into the enterprise metadata repository.
  • Designed various schemas which are used for Landing the data, staging for transforming the data and PROD in MS SQL Server 2012.
  • Created complex SSIS packages using proper control and data flow elements.
  • Developed triggers and stored procedures for data manipulation.
  • Created views, clustered & non-clustered indexes, user defined data types, user defined functions and CTE's.
  • Designed different kinds of reports from scratch depending upon the requirements of the markets, vendors, providers and scanners.
  • Worked with different sources to extract the data like Flat File, Excel, OLE DB, and Raw File and loaded the data into different destinations like OLE DB, Flat File, Excel and Record set Destination.
  • Created database maintenance plans and deleting of history data using SSIS packages.
  • Worked on migrating data from SQL Server 2008(R2) to 2016.
  • Created drill through, drill down reports, parameterized reports.
  • 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.
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
Remove Skill
References
Average Rating

1 recommendation
BI Developer
Information Technology
Sep 2012 - Jan 2014
  • Gather requirements and understand the specifications of wholesale access certification needs.
  • Designed and built prototype for access certification challenge on the wholesale end to integrate with Enterprise access certification tool.
  • Database migration is done from SQL Server 2005 to SQL Server 2008 to enable the applications to run better and reduce the amount of time you need to spend managing them.
  • Created Database objects - Tables, Views, and Functions and developing Procedures for implementing application functionality at the database side for performance improvement.
  • Worked on SSIS Packages for extracting the data of the file system and transformed that data and load it into OLAP.
  • Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
  • Designed, developed, debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
  • Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.
  • Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs.
  • Generated reports using SQL Server Reporting Services integrated and deploying them using web applications onto the web servers.
  • Developed datasets to perform reporting and included interactive drill down reports, report models and ad-hoc reports.
  • Developed Tabular, Cross Tab reports, Charts reports, Parameterized, cascaded and sub-reports using SSRS 2008.
  • Managed the historical data in the data warehouse from various data sources.
  • Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Pro filers, Activity Monitor.
  • Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case.
  • Environment: MS SQL Server 2008, Business Intelligence MS SQL Server Integrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), ETL, visual studio 2005, MS Visio 2008.
SQL Visual Studio Stored Procedure Data Warehousing SQL Server ETL SSIS SSRS Business Intelligence BI Developer Project Management
Remove Skill
SQL Server / BI Developer
Information Technology
Jul 2011 - Aug 2012
Providence, RI
  • Extensively worked in data integration in developing ETL mappings and scripts using SSIS
  • Perform database administration tasks including Installation, Configuration, Upgrades, Capacity Planning, Performance Tuning, Backup and Recovery.
  • Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
  • Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
  • Created the ETL (SSIS) packages and scheduled them for SQL Agent Jobs.
  • Create Stored Procedures, Triggers, Tables and Indexes for MySQL and MSSQL 2005
  • Perform database maintenance tasks which includes Rebuilding and Reorganizing Indexes, Updating Statistics as well as running Integrity Checks (DBCC).
  • Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
  • Responsible for Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups.
  • Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures.
  • Knowledge of developing reports from Cubes using the KPI's for decision making, also debugged data connections, data sources and Data Source Views.
  • Creating Ad Hoc and parameterized various Reports using SQL server 2008 Reporting Services.
  • Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
  • Have used BCP, BULK INSERT to transfer data from and to SQL server database.
  • Implemented security to restrict the access to users and to allow them to use only certain reports.
  • Environment: T-SQL, SSMS, SSIS, SQL Server and Microsoft Visual Studio, XML, MySQL, Windows XP.
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
Remove Skill
Edit Skills
Non-cloudteam Skill
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
Requirements Gathering
0
1
Scrum
0
1
System Design
0
1