Name: Vamsi Location: New York Availability:IMM Relocation: Yes
Summary - Over *8 years* of IT experience in database design and development on Microsoft SQL Server 2005/2008/R2/2012/2014. - Extensive knowledge of software development life cycle (SDLC) including requirement gathering from business users, analysis, design specification writing, development and implementation - Experience in building data integration and workflow solutions for data warehousing using SQL Server Integration Service (SSIS) - Experience in independently handling design, development, documentation and testing phases in a project environment. - Experience of Relational Database Management Systems (RDBMS) and database design issues like normalization and de-normalization. - Extensive experience with T-SQL functions, indexes, triggers and extracting data from multiple tables. - Developed complex stored procedures and queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces. - Experience in Extracting, Transforming and Loading (ETL) data from MS Excel, flat file, Oracle to MS SQL Server by using SSIS services. - Experience in using APIs to retrieve data and load it into database after parsing and data cleaning - Excellent at High Level Design of ETL Packages & SSIS packages using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All. - Experienced in performing incremental loads and data cleaning using SSIS. - Managed error handling, logging using event handlers in SSIS. - Expert in creating parameterized reports and complex reports involving Sub Reports, Matrix Reports, Tabular Reports, Charts/Graphs using SSRS in Business intelligence development studio (BIDS). - Experience in implementing Key Performance Indicator (KPI) objects in SSAS and creating calculated members in MOLAP cube using MDX in SSAS - Experience with Team Foundation Server(TFS) for source code management and bug tracking - Experience in design and implement processes for deploying, managing and extracting data for reporting using SQL Reporting Services SSRS. - Experience in providing visual analytics to customers using Tableau and Power BI - Expertise in SQL Query performance analysis and ability to redesign queries for optimal efficiency. - Good knowledge of defining, developing and deploying Star schema, Snowflake schema and Multi -dimensional data modeling using MS SQL Server Analysis Services (SSAS). - Involved in developing OLAP dimensions, cubes, and measures with SQL Server Analysis Services - Efficient in creating complex queries involving multiple tables. - Managed all database servers in development, staging, test and production environments. - Ability to work independently as well as collaborate cross functionally within a team Technical skills Databases MS SQL Server 2005/2008 R2/2012, Oracle 12c/11g/10g/9i, MySQL, MS Access, PostGres Operating Systems Windows XP/Vista/7/8/8.1/10, UNIX Tools/Utilities SQL Server Data Tools, Business Intelligence Development Studio (BIDS), SQL Server Management Studio, MS Excel, Power BI, Tableau, PowerPivot, Report Builder, MS Visio, SQL Profiler, SQL Query Analyzer, OLAP Services, SQL Server Agent, SQL *Plus, phpMyAdmin, DataPump, PuTTY, WinSCP, Visual Studio Languages T- SQL, XML, C#, HTML, PL/SQL, UNIX Shell Scripts, CSS, PHP, Java Frameworks ADO.NET , LINQ, ASP .NET -- *Bagwanth* Business Development (Bench Sales) Email: [email protected] Address: 100 Kensington Lane, Frankfort, KY Website: www.rpsteksol.com -- You received this message because you are subscribed to the Google Groups "Companies Looking for IT Out Staffing & Recruitment" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/arunsinh. For more options, visit https://groups.google.com/d/optout.
