Hi, Excellent MSBI available for new project, Please do share your requirements to *[email protected]* <[email protected]> or you can contact on *614-416-6748*
Consultant Name: Pavan Contact: 505-469-5354 Location: IL Relocation: Open Availability: Immediate *SUMMARY * · 7 + years of IT Experience in *Microsoft SQL Server 2012/2008R2/2008/2005*, ASP.NET Business Intelligence (BI) tools like *SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)* · Worked on development tool *Visual studio 2008, 2012, 2013* · Experience in Design, Development, Maintenance, Testing and Production Environments with various business domains including Healthcare, Finance and Energy. · Expertise in working with Web Server Controls, HTML Controls, User Controls, Custom Controls using *C#* and *VB.NET <http://VB.NET>*. · Excellent in writing *T-SQL queries* *(DDL and DML)*. · Expertise in using T-SQL for developing *complex Stored Procedures, Triggers, Tables, Views, *User Functions*, Common Table Expressions (CTEs), Relational Database Models and Data Integrity, SQL joins and Query Writing*. · Proficient in understanding Execution plan, *SQL Server Profiler* to trace the slow running queries and optimize SQL Queries for improved performance and availability. · Experience in monitoring and tuning MS SQL Server databases with tools like *Index Tuning Wizard, SQL Profiler* and *SQL server Database Engine Tuning Advisor* for optimal Performance. · Proficient in developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data Warehouse from Heterogeneous data sources such as *Oracle, DB2, Excel and MS Access CSV, Oracle, flat file.* - Experienced in development of content and visually rich reports in SQL Server Reporting Services (SSRS) like *tabular*, *matrix*, *list, chart, gauge, and map.* · Good experience in working with *QNXT *and related databases and data to create complex store procedures. · Worked on monthly TAT reports of *Medicaid reviews, claims* and developed related SSIS packages and SSRS reports. · Deploy packages to file system and schedule the jobs using *SQL Server Agent*. · Experience in building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions for Data Warehousing using *SQL Server Integration Services (SSIS)*. · Expert in designing complex reports using *SQL Server Reporting Services (SSRS)*. - Designing, creating, and managing multidimensional cubes that contain data gathered from other data sources (relational databases) and *Online Analytical Processing* (OLAP) by using SQL Server Analysis Services (SSAS). · Experience in different type of reports including Tabular forms, Matrix (cross/tab) form, *Cascading parameters, Drill-Through, Drill Down, and Parameterized Reports*. · Experience in writing of T-SQL queries *(DDL and DML)* which is utilized in construction of tables and normalization techniques to database tables. - Experienced in usage of Microsoft BI tools like *Power View, Power Pivot, Power Query, Power Map* which are utilized to retrieve, analyze, and to finally display the data in a well-defined visual form. · Proficient in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using *SSRS*. · Designed and developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as *Star Schemas* and *Snowflake Schema*. · Strong analytical, administration and problem solving skills dedicated to maintain the high quality standards. Good communication skills, ability to work independently. *EDUCATIONAL DETAILS* · Bachelor of technology & engineering, JNTU, India. *TECHNICAL SKILLS * *Databases* SQL Server 2012/2008/2008 R2/2005, Oracle, Access *BI Tools* SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Excel *ETL Tools* SQL Server Integration Services, Data Transformation Services (DTS) *Development Tools* Visual Studio 2012/2008/2005, SQL Enterprise Manager, SQL Profiler, Query Analyzer, Security Manger, Service Manager *Programming Languages* T-SQL, PL SQL, C#, XML, .NET 3.5, 4.0, ASP.NET, WCF, Web Services *Operating Systems* Win Server 2008/2003, Windows 8/7, MS-DOS Thanks & Best Regards. *Allegiance-Technologies* *Robert | *Senior Recruiter | Direct: 614-416-6748 9777 Fairway Drive,Suite A,Powell,OH 43065 [email protected] | Gtalk :usitstaffing16 www.allegiance-technologies.com <http://www.google.com/url?q=http%3A%2F%2Fwww.allegiance-technologies.com&sa=D&sntz=1&usg=AFQjCNECzOdxvzUR-xI2mfueyNfbBJ3Law> | -- You received this message because you are subscribed to the Google Groups "as400placements1" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send an email to [email protected]. Visit this group at https://groups.google.com/group/hrccpl. For more options, visit https://groups.google.com/d/optout.
