Uploaded File
no photo
Padma
SQL Developer
Available immediately
no photo
Padma
6
views
SQL Developer
0
Recommendations
Average rating
6
Profile views
SQL HA OLTP jQuery T-SQL ERP Performance Tuning SSIS ETL SDLC
Remove Note
View Note
Recent Experience
SQL Developer 03/14 - 05/16
Summary

  • Over 4+ years of experience in the IT domain focused on Microsoft SQL Server 2008R2, SSIS/SSRS/SSAS, OLTP and OLAP.
  • Experience as BI Developer and utilizing Microsoft SQL Server BI stack (T-SQL, SSAS, SSIS, SSRS) transformed data to intelligence and intelligence to value.
  • Experience working with Very Large Databases(VLDB) such as 2 TB and over 5billion Records.
  • Experience in designing and developing high level ETL Packages to extract, transform and load data from flat files to OLTP and OLTP to Data warehouse tables.
  • Experience with SSIS performance tuning using counters, error handling, event handler, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.
  • Experience in designing Dynamic SSIS Packages using variables,expressions, containers.
  • Expert in Package Management like Saving, Encryption, Logging, and Auditing.
  • Experience with SSAS,MDX ,Reports,ETL Architeure.
  • Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables
  • Expert in creating Data Source Views(DSV),Dimesions,Hierarchies,Cubes, Partitions.
  • Expert in creating calculated measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
  • Experience in designing KPI’s,Perspectives,Actions using Microsoft sql Server 2005/2008 Analysis Services.
  • Worked with MOLAP,OLAP,ROLAP storage modes.
  • Good experience in Designing Aggregations and pre-calculated measures, groups and measures.
  • Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.
  • Experience in generating, adhoc , Parameterized, Drill through, Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008/R2.
  • Experience in creating excutive level Dashboards,Charts using SSRS,Powerpivot and Excel.
  • Expertize knowledge in SSRS using SharePoint Integration Mode.
  • Solid Experience in writing complex T-SQL queries like Aggregate Queries, GROUP BY, HAVING Clauses, Subqueries, CTEs, Derived Tables , JOINs , UNIONs.
  • Experience in writing Stored procedures, Indexes, Views, Synonyms and user defined functions.
  • Experience with Fragmentation and Query analyzer for SQL Server 2005/2008 and experience with Database Tuning Advisor and SQL Profiler for tracing, auditing and Performance Tuning.
  • Experience in SDLC (Software Development Life Cycle) like gathering requirements, design, development, implementation and testing of projects before moving to production
  • Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling the backups.
  • Provided 24 X 7 Production support for the database and application issues.
  • Worked directly with Director of Data warehouse and Vice Presidents of the Company.
  • Experience in translating user & business requirements into functional and technical requirements.
  • Team Player,worked Independently and also as team lead.

Top 5 Skills
SkillsProficiencyLast Used
SQL
HA
OLTP
jQuery
T-SQL
Education and Certifications
not provided
Preferences
Availability:Immediately
Willing to relocate?:No
Prepared to Travel:No travel (0%)
Employment Type:Any
Security Clearance:No clearance
Citizenship:U.S. Citizen