Summary | - 8 years of IT experience in Database Design, Development and maintenance of database applications on SQL Server 2005/2008/2008 R2/2012 in OLTP/OLAP/BI environment.
- Experienced in working as MS SQL Server 2012(T-SQL, SSRS, SSIS)/2008R2/2008/2005/2000 developer in various industrial domains
- As part of the team, extensively involved through the Software Development Life Cycle (SDLC) specially Agile Scrum/SVN involving business process analysis, requirements gathering, detailed design and development, testing and post implementation support.
- Skilled in writing SQL queries with Teradata environment.
- In-depth knowledge of Transact-SQL (DDL and DML). Proficient in creating Tables, Indexes, Joins, Triggers, Views, complex Stored Procedures, User Defined Data Types and Functions.
- Experience in sub-queries, CTE's (common table expression), table variables and physical temp tables.
- Expertise in performing and designing ETL data flow using SSIS, DTS, and Bulk Insert.
- Expertise in upgrading/creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets/DTS using SQL Server SSIS.
- Extensive knowledge and experience working with Relational databases (RDBMS), DSS, SourceSafe Administration and serving in multi-tiered environment.
- Expert in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
- Experienced in resolving complex issues and Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging towards SSIS package execution in SSIS 2012/2008R2/2008/2005.
- Experienced in Building OLAP Cubes, Facts and Dimensions tables with different Architectures and Data Sources for Business Intelligence, and populating/maintaining Data Marts in SSAS 2012/2008R2/2008/2005.
- Used Multi-Dimensional Expressions (MDX) queries for calculated members of OLAP cube, Key Performance Indicators, Aggregation, Measures in SSAS 2012/2008R2/2008.
- Strong knowledge of Data Warehouse concepts and technologies; working extensively on Developing SSAS Cubes, Hierarchies, Star and Snow Flake Schemas of Data Mart, Partitioning Cube, Data Mining Models, Deploying and Processing SSAS objects, ETL process, reporting tools and surrogate key generation.
- Strong expertise in Data modeling using Erwin 9/8/7.2 and MS Visio with good understanding of Relational Database Management System (RDBMS).
- Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2012/2008R2/2008/2005) generated Parameterized reports, Linked reports, Sub reports, Drill down, Drill through reports, Matrix dynamics and filters, charts, Indicators graphs in SSRS.
- Worked on MS Power Pivot tool in Excel for Data exploration and processing millions of rows in the data creating Ad-hoc/Analysis reports.
- Provided support to SharePoint users and site level administrators.
- Experienced in generating reports using Crystal Reports, XML, MS Access, Excel and Interfaces with BIDS.
- Excellent Experience in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export and Troubleshooting.
- Flexible, multitasked, responsible, enthusiastic and project oriented team player with excellent written, verbal, presentation and interpersonal communication and leadership skills to develop creative solutions for challenging client needs
TECHNICAL SKILLS: MS SQL Server 2012/2008R2/2008/2005/2000, T-SQL, My SQL, Oracle 9i/10g, MSSQL Server Reporting Services (SSRS), Crystal Reports, DTS, MSSQL Server Integration Services(SSIS), IBM Information Server Data Stage 8.0, SQL Profiler, SQL Query/Index Analyzer, MSSQL Server Analysis Service (SSAS), Backup/Restore Server, Replication, OLAP services, SQL Alerts, SQL Jobs Replication,ADO.NET, SVN, SME, Agile Scrum Methodology, MS Excel, Teradata, MS Office 2010/2007/2003, Source Safe Administration, Team Foundation Server (TFS) 2012, VBScript, MS Visual Studio 2010/2008/2005/2003, ERWIN 9/8/7.2, Visual Studio 6.0,MS SSRS, Crystal Reports, COGNOS Reporting tool, SharePoint 2007, Power View, MS Power Pivot, QlikView, MS Access |
Greetings!!!