Dear professionals ,
Hope you are doing great. Bellow skilled consultant Available for your requirement. Feel free contact me at kr...@sannitsolutions.com /703-953-2639. Thanks. Kindly share JD and add me in your distribution list . *Sr SQL Server/BI Developer* Name: *Chaitanya* Experience – 8 Years Availability – Immediate Relocation - OPEN Current Location & Name of Client – *Chicago* IL / *IBM (Ernst & Young), * PROFESSIONAL SUMMARY: · *8 years* of experience in IT industry as a *Microsoft SQL Server BI Developer and *specializing in database design, development & administration work with* Microsoft SQL Server 2016/2012/2008R2/2008/2005* for OLTP, OLAP, large-scale data warehouse applications. · Over *6+* Years of experience in data warehouse development with *Integration Services (SSIS), reporting services (SSRS) and Analysis services (SSAS).* · Experience in *hybrid cloud* application using *Microsoft Azure.* · Experience in *Power BI *Desktop to develop data analysis multiple data sources to visualize the reports. · Experience in testing of *Business Intelligence solutions, Data Warehouses, Data Marts, ETL, OLAP, Client/Server applications*, Web-based applications in Insurance, Finance, and *HealthCare* domains. · Extensive experience with different phases of *software development life cycle (Analysis, Design, Implementation, Testing, *and * debugging *new and* existing client-server based applications*). · Extensive experience in developing complex *Stored Procedures*, * Functions,* *Triggers, Views, Cursors, Joins *and* Sub queries *with * T-SQL.* · Strong knowledge in *database design* features including *ER Diagrams, normalization, tables, views, indexes, constraints, keys*, data dictionaries, and data integrity. · Profound knowledge and ability to write *stored procedures, temporary tables, views, indexes, triggers* when required and complex queries including correlated queries and queries with complex joins and aggregate functions. · Expertise with DDL and DML statements, RDBMS’s, data dictionaries and normal forms. · Proficiency and expertise in SQL Server *Replication*, *Backup/Recovery*, *Disaster recovery and planning*. · Experience in *JIRA* as a defected tracking and work status tool and Confluence for cloud documentation. · Worked in *Agile/Scrum methodology* with daily status meetings. · Experience in query optimization (SQL tuning) using SQL* Profiler* , *Database Tuning Advisor (DTA)*, Index tuning wizard and *Performance monitor* for performance tuning. · Experience in building Data Integration, Workflow Solutions and *Extract, Transform, *and* Load (ETL)*solutions for data warehousing using *SQL Server Integration Service (SSIS)* · Developed *ETL* process using *SSIS* with various *control flow, data flow tasks* and store procedures for work order validation process. · Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in *SSIS* packages by using Row Transformations, Block and Unblock Transformations. · Experience in creating jobs, SQL Mail, Alerts and schedule* SSIS* Packages using SQL Server Agent. · Creating *SSIS Packages* and involved in Package configurations and deployments between Development and QA and Production servers. · Expert in designing and generating reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, matrix, dynamic reports and other features of reporting service. · Experience in* Microsoft Reporting Service (SSRS) *with Report authoring, Report management, Report delivery and Report security*.* · Experience in SSRS installation, configuring report server and configuring scale out deployment. · Hands on experience in developing Custom Reports and different types of *Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports* in multiple formats using *SQL Server **Reporting Services* (*SSRS*) in Business intelligence development studio (*BIDS*). · Expert in creating *parameterized reports, Drill down, Drill through*, Sub reports, Linked reports, *Snapshot, Cached*, Adhoc reports using *SSRS*. · Experience in created simple and Data Driven subscriptions. · Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008. · Experienced in working with Star Schema modeling to develop ROLAP/MOLAP Cubes using SQL Server 2005/2008 Analysis Services. · Experience in Cube designing in Business Intelligence Development Studio using SSAS. · Strong experience in defining Referenced relationships in *SSAS*. · Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications. TECHNICAL SKILLS: *SQL Server/BI Tools* SQL Server Integrating Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Azure, Power BI, SQL Profiler, Query Analyzer, SSDT, Export & Import (DTS) *Databases* MS SQL Server 2016/2012/2008R2/2008/2005, MS Access, My SQL *Programming Languages* C#, T-SQL, HTML, JSP, Java Script, Asp.Net and VB.Net. *Tools* Visual Studio 2012/2010/2005, Erwin 7.2 *Application Packages* MS Office, MOSS 2007 *Operating Systems* Windows 2000/NT/XP, UNIX, Windows Server 2012/2003 *Architecture* RDBMS, OLAP, OLTP *Data Modeling Tools* Erwin 7.2/4.5/4.0, MS Visio 2003/2007, Rational Rose Nope: I too have consultants on *MSBI *|| Full Stack Developer || *ETL informatica* || Salesforce ||. Thanks & Regards, AK Phone: 703-953-2639 kr...@sannitsolutions.com 459 Parkway, Suit18 Herndon, VA, 20170 -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to android-developers+unsubscr...@googlegroups.com. To post to this group, send email to email@example.com. Visit this group at https://groups.google.com/group/android-developers. To view this discussion on the web visit https://groups.google.com/d/msgid/android-developers/4f715d33-b5c1-410c-9b0e-c29fe370c381%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.