Hi,
I Hope my email finds you in best health. Kindly have a look at the summary of my SQL Server/MSBI Consultants PFB my MSBI / SQL candidates *CONSULTANT DETAILS :* *Consultant Name: Divya - (Venkata Sri Divya Bavireddy)* *Contact Number: 702-751-5945 / 404-889-5374* *Email: venkatasrii...@gmail.com <venkatasrii...@gmail.com>* *Skills: SQL/MSBI Developer* *Location: Ft. Worth, TX* *Relocation: Open* *Work Authorization: H1B* *Experience (In Years): 7+ years* *Rate: $55/hr on C2C* *CONSULTANT DETAILS :* *Consultant Name: Megha Mehta* *Contact Number: 562-396-3121* *Email: mm.rajkot...@gmail.com <mm.rajkot...@gmail.com>* *Skills: SQL/MSBI Developer* *Location: Los Angeles, CA* *Relocation: Open* *Work Authorization: H1B* *Experience (In Years): 6 years* *Rate: $55/hr on C2C* *CONSULTANT DETAILS :* *Consultant Name: Pravallika Chundu* *Contact Number: 707-540-1090* *Email: pravallika.sq...@gmail.com <pravallika.sq...@gmail.com>* *Skills: SQL Server/BI Developer* *Location: Austin, TX* *Relocation: Open* *Work Authorization: H1B* *Experience (In Years): 7+ years* *Rate: $55/hr on C2C* Kindly have a look at the summary of my SQL Server/MSBI Consultant *Divya*. Please keep me posted if you have any similar opportunities. *PROFESSIONAL SUMMARY* · 7+ years of working experience in MS SQL Server 2000/2005/2008/2012/2014 Database Developer in various environments. · Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, and E-R Diagrams. · Experience in BI Development and Deployment of SSIS 2005/2008/2012/2014 packages from MS-Access, Excel, Oracle and CSV. · In-depth knowledge of T-SQL (DDL and DML) and programming stored procedures, database triggers, cursors, functions. · Proficient in DTS packages, troubleshoot and performance tuning of databases. Administering database backups and recovery of server failures and disaster recovery of databases. · Hands-on experience in Extract/Transform/Load (ETL) tools including SQL Server Integration Services (SSIS) and DTS. Knowledge in designing large multi gigabit cubes with SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS). · Experience in configuration & administration of MS SQL Server suite of products like SSAS, SSIS and SSRS*.* · Experience in monitoring tools like SQL Management Studio, Business Intelligence Development Studio, Enterprise Manager and Query Analyzer, Profiler. · Knowledge in Data warehousing, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services · Creating databases and granting user access to databases. Setting up DTS tasks for data transfer to SQL Server. · Experience in configuration and administration of databases on My SQL. *EDUCATION* *Bachelor of Information Technology.* *AREAS OF EXPERTISE* *Platforms* Windows 2003 Enterprise, Windows 2000 Datacenter, Windows NT & XP *Database/Data warehousing* MS SQL Server 2014/2012/2008R2, 2005 & 2000/7.0, MS SQL Server 2008 Evaluation Edition, T-SQL, PL/SQL, ODBC, JDBC, OLEDB, MySQL, Oracle 11g/10g/9i/8i, Installation, Upgrade, & Migration, Performance Tuning, Capacity Planning *BI Tools* SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS). *Applications* C/C++, C#, HTML, CSS, Java Script, XML, ASP.Net, VB.NET, Visual Studio 2008/2010/2013. *Desktop* MS Office Suite, Word, Excel, Access, PowerPoint, Outlook, Dreamweaver, Fire Fox *Methodologies* Agile, Water Fall, Scrum, SDLC. *Database Design Tools and Data Modeling* MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Erwin. Kindly have a look at the summary of my SQL Server/MSBI Consultant *Megha*. Please keep me posted if you have any similar opportunities. *EXPERIENCE SUMMARY* · About 6 years of experience in Software development and testing · Good experience in requirements gathering & analysis, development, delivery, reporting and documentation. · Strong experience of Databases such as *Oracle 11g (PL/SQL), SQL Server and MySQL -*writing complex PL/SQL queries, Stored Procedures, Functions and Cursors*.* · Expertise in *SQL Server Integration Services* *(SSIS)* and *SQL Server Reporting Services (SSRS)*. - Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional , Table, Chart and Sub Reports*.* - Expert in Data Extraction, Transforming and Loading (*ETL*) between Homogenous and Heterogeneous Systems using SQL Server tools like SSIS. · Strong team player with excellent problem-solving, organization and leadership skills. · Quick learner of processes and technology. · Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player · Winner of innovative project in technical paper presentation at California Lutheran University. · Good knowledge of testing tools like *Quality Center* (QC) and *QTP* *COMPUTER/SOFTWARE PROFICIENCY* *Technical skills* C, C++, Java, Database, Oracle, Data Warehousing (ETL), SQL 11g, MySQL/PLSQL. *Operating Systems* Windows 98, 2000, XP, Windows 7, Vista *Tools * ODI (*Oracle Data Integrator* <http://www.oracle.com/technetwork/middleware/data-integrator/overview/index.html>),Oracle SQL developer, SSRS, SSIS, SSAS, Eclipse, Net Beans, Turbo C/C++ *Web Designing* HTML, CSS *Scripting Languages* Java Script Kindly have a look at the summary of my SQL Server/BI Consultant *Pravallika*. Please keep me posted if you have any similar opportunities. *Professional Summary:* · *Around 7+ Years of Experience* in *Database Design*, *Development, Business Intelligence Performance Tuning, Administration of MS SQL Server 2012/2008/2005* in *Development & Production environments*. · Includes*4 Years of Experience* in MS SQL Server 2012/2008/2005 Business Intelligence performing ETL Solutions using *SQL Server Integration Services* · Includes around *2 Years of Experience* performing Reporting services using *SQL Server Reporting Services (SSRS)* *Technical Skills:* *Database Tools* SQL Server Management Studio, SQL Programmer 18, Enterprise Manager, Query Analyzer *Business Intelligence* Informatica, SSIS,SSRS *ETL Tools* Informatica Power center 7.1.2,8.1.1,9.0.1,SSIS, Data Transformation Services, Import & Export Utility *Reporting Tools* SQL Server Reporting Services(SSRS) *Job Scheduling Tools* SQL Server Agent *Monitoring Tools* Microsoft SQL Performance Monitor, Microsoft SQL Profiler, Database Engine Tuning Advisor, Upgrade Wizard *Operating Systems* Windows 8,Windows 7,Windows XP, Windows Server 2003/2008 *SQL Server Development:* · Expert in designing Relational Database Model and physical database design using SQL Server 2012/2008/2005 and T-SQL · Extended expertise in writing T-SQL scripts and in SQL Server 2008 · Good hands on Creating and maintaining SQL database objects like procedures, functions, <https://secure.cbtnuggets.com/it-training-videos/series/msft_70_433/5568> Indexes, partitioned. · Implemented SQL Server 2005/2008 new concepts like Data partitioning, Data Base Snapshot, Common Table Expression (CTE), DDL Triggers and DMV &DMF · Experience in implementing ANSI changes and Unicode Changes on the existing database Structure and Objects in development environment and doing Unit Testing · Administered MySQL database installations and upgrades, performance monitoring and tuning, backup and recovery, space management, capacity planning and resource utilization · Experience in avoiding the usage of expensive Cursors in SQL Queries by replacing them with SET based statements. · Experience in implementing Error Handling in SQL database objects to ensure Data Consistency, implementing Transactions, working with DDL and DML Queries, usage of MERGE Statement. · Experience in using multiple sources for getting Business data using Linked Servers, Open Query, Open Row Set, and Open Data Source. · Tuning SQL Objects/Query performance through Execution plan. Finding out the most Expensive operation and tried to avoid expensive operators like Key Lookup, Sort, Hash Match, Table Scan by creating Covering index, including Order by Clause in the query, Query hint to force Merge Join, creating clustered or non-clustered indexes respectively. · Experience in regularly checking SQL Server Statistics and Fragmentation of SQL Tables Using Dynamic Management Views (DMVs) and accordingly updating Statistics. *SQL Server Integration Services (SSIS):* · Experience in extracting, transforming and loading data (ETL) using SSIS, DTS Import/Export Data, Bulk Insert, BCP. · Experience in loading data from different sources like Excel, Flat file, Oracle to MS SQL Server by using MS SQL Server DTS and SSIS · Experience in analyzing the Source data, Business rules, doing the Data Profiling and preparing the Mapping document accordingly before creating the SSIS package · Formatting the data within the input Flat files to the acceptable SQL Server data by creating Inbuilt Transformations using view or Active X Script Task of SSIS. · Thorough understanding and experience on different types of Tasks and Transformations Included in SSIS like Data profiling Task, FTP Task, File System Task, Script Task, For Loop and For each Loop Container along with Variables. · Experience in using checkpoints, Transaction Control, Configuring Error Logging, Package Configurations, Deploying package onto the Staging Environment and Testing it prior to deploy on Production Box. · Debugging SSIS packages in case of failures/issues during ETL process. *SQL Server Reporting Services (SSRS):* · Experience in building Adhoc Reports, Parameterized Reports using Report Designer and Report Builder · Experience in Configuring the Reporting Services, Configuring the Report Server for Email Delivery using SMTP Server, changes to concerned Reporting services config files. · Experience in maintaining the Reports using Report Manager and creating Subscriptions like Standard or Data Driven Subscription to ensure email delivery or file sharing of Reports*.* Thanks! Regards, Anu Sud, (Anubhav Krishna Sood) Sr. Accounts Manager TEKshapers, USA 248 565 4747 Ext 193 a...@tekshapers.com (Gtalk, Skype - anubhavsood11...@gmail.com) Certification: WMBE Certified | E-Verified Company | ISO 9001:2008 PSave trees. Print Only When Necessary -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at https://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.
