Summary
- Over 8+ yearsof experience in SQL Server Development including writing T-SQL Programming, Database Design, SQL server suite of products SSIS, SSRS, SSAS.
- Experience in Tableau visualizationtool
- Knowledge of other big data platforms
- Experience with development tools and tools platforms (i.e.PIG and HIVE)
- Designing data queries against data in the HDFS environment using tools such as Apache Hive
- Expert in writing T-SQL, working on DTS, SSIS, SSRS, SSAS.
- Hands on Experience in installation, upgradationand configurationfor various versions of MS SQL Servers.
- Extensive knowledge in T-SQL queries (DDL, DML).
- Experience in SQL Server DTSand SSIS(Integration Service) package design, constructing, and deployment.
- Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL)Queries, & Dynamic-queries.
- Transformed data from one server to other servers using tools like Bulk Copy Program(BCP), Data Transformation Services(DTS) and SQL Server Integration Services(SSIS *** ).
- Extensive experience in extracting and transforming data using DTS Import/ExportData, Bulk Insert, BCP, Data Replication and DTS Packages.
- Expert in implementing and planning Server Securityand authentication, Database Normalization, designing and creating Indexes, Develop Queries and T-SQL Scripts in MS SQL *** *** .
- Strong ability in defining query for generating drill down reports, handling parameterized reportsand creating stylish report layouts in SSRS 2005/2008R2/2012.
- Experience in writing complex stored procedures, functions, Indexedviewsand triggers for data consistency and manipulation.
- Experience in creating scheduling Jobs,sendingAlerts, SQL Mail Agent,andscheduled DTS Packages.
- Experience in generatingDrill throughand Drill downreports with Drop down menu option,sorting the data,defining subtotalsusingSSRS 2005/2008R2.
- Generated reports using SSRS, Excel (Pivot).
- Expert in extracting and transforming data using DTSImport Export Data, DTS Packages, SSISand Experience in using BCPfor Bulk copy operation and Bulk Insert.
- Created stored proceduresto build the Fact tables in the data mart for Multi-Dimensional analysis.
- Good experience and understanding of SSAS, OLAPcube and Architecture.
- Experience in Cube designingin Business Intelligence Development Studio (SSAS)to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
- Experience in creating MDXcubes and dimensions [SSAS).
- Expert in performance tuning, query optimization and running database.
- Expert level skills in Objects creation such as Tablesand Views, Table Normalization, User created Data Types, Indexes, Stored Procedures, Cursors and Triggers.
- Expert in database activities like Data Modeling, Data Staging, Data cleansing, Data scrubbing.
- Excellent skills in DBA activities such as backups, recovery, restore, replication and Linked servers etc.
- Experience in database integrated application development using VB, VB .Net, C#.Net, Asp.Net
- Experienced in design of logical and physical data modelingusing Erwin data modeling tool.
- Experience in migrating from SQL Server 2000 to SQL Server 2005and from SQL Server 2005 to SQL Server 2008.
- Excellent in High Level Design of ETL DTSPackages& SSISPackages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
- Excellent communication and inter-personal skills with ability to work as a team player or independent player and ability to interact with clients.
- Ability work in challenging and versatile environments and strive for excellence.
- Flexible and versatile to adapt to any new environment and work.
- Experience developing using an AGILE Methodology (i.e. SCRUM, LEAN, etc.)
Education
- BTech in Electronics and Communication Systems, JNTU, India – 2005
- Master of Science in Computers and Information Systems, TSU, USA -2008
- Published research paper in Artificial Intelligence
&...
