Description
PROFESSIONAL SUMMARY * 10+ Year of experience on MSBI, SQL Server, Tableau, Big Data and Jasper Reports. * Having good experience in BI suite - using integration services (SSIS) for ETL (Extraction, Transformation and Loading), reporting services (SSRS) for creating different types of reports using SQL query's and analysis services (SSAS) for design and developing complex cubes and MDX query's. * Expert in writing T-SQL, data migration for DTS 2000 (Data transformation services) packages to SQL Server 2005/2008 using ActiveX script task to support business logic in packages, data cleansing, data scrubbing. * Expert in understanding and querying complex Oracle databases (10g/11g) as well as an ability to understand the business rules that apply to the data. * Experienced in team mentoring, task planning and estimation, status tracking, Goal Setting and feedback discussion, trainings and recruiting technical resources etc. * Experience in providing SSRS server level, item level security & accessibility to various reports in multi-user environment. * Extensive hands on experience on SQL Server 2005/08/R2/2012/2014 and IReports 5.6 * Good understanding of RDBMS concepts and experience in writing joins, sub queries indexes, views, store procedures and function using SQL Server * Exposure to all phases of software development life cycle (SDLC) with in-depth knowledge of agile methodology, enterprise reporting life cycle, SQL server migrations, change control rules, problem solving skills and escalation procedures. * Skilled in developing Jasper Soft I reports, supporting and maintaining Jasper Report Server. * Strong report layout and presentation skills. Demonstrated skill in designing and developing complex reports * Solid understanding of T/SQL and ability to write scripts to automate and manage data, performance tuning, SQL Query optimization and Drive to automate process and procedures which are manual. * Ability to develop in fast moving, agile product development methodology. Strong data analytical skills for report validation and testing * Have Extensive experience in configuringSSRS\I Reprot Report Manager and Drill down report, Sub reports, creating subscription and scheduling reports. * Experience with open source Java technologies and APIs including Groovy. * Team player with good interpersonal skills and the ability to work in team. TECHNICAL& DOMAIN EXPERTISE Reporting Tools: SSRS, SSAS, OBIEE 10g, I Reports 5.6 (Jasper Reports), Power BI. ETL Tools: SSIS, Informatica ETL Testing Tools: Informatica Data Validation RDBMS/DBMS: MS SQL Server 2008/R2/2012/2014/2016 BIG DATA: HADOOP (SPARK.) Data Model Tools: ERWIN NoSQL DB: Mongo DB
Accomplishments
Highlights:
Keywords
