pradeep reddy

• Over 12 years of I.T experience in developing Business Intelligence Solutions, within Data warehousing.• Implementation and development of BI Applications using PowerBI, Office 365, Azure, SSIS, SSAS, SSRS, QlikView, Tableau, Business Objects (Desktop intelligence, Web Intelligence) and AWS.• Experience of Analysing, developing, testing and documenting complex data extracting process.• Efficient in designing, developing and implementing Enterprise BI Solutions to meet existing and new business demands to develop the most innovative data management framework for impactful digital analytics solution within the organisation.• Developed Front end reporting and analytics platforms including data models, ETL packages, OLAP cubes and reports utilizing PowerBI, Tableau, SSRS by applying best practices through the development lifecycle.• Designing the data flow procedures for importing the data from various data sources like ERP, CRM, share point, Flat files, XML etc in to Data Warehousing system and standardizing data to store various Business Units in databases.• Back end data integration and architecture including dimensional data modeling, database design, data warehousing, ETL development, and performance tuning.• Experience in designing, creating, monitoring and troubleshooting pipelines in Azure for processing data transformation and data loading on to target servers and databases.• Applied machine learning techniques using AWS SageMaker for Fraud Detection and sanction screening of the data.• Worked on Deployment and automatic scheduling of Data Flows on TFS and GitLab and documented the execution plans.• Configuration of environmental variables with the ETL project parameters in Integration service catalogues and documentation of source-to-target mappings, data dictionaries and database design.• Designed Data ware housing methodologies using Star Schema and Snowflake Schema Concepts.• Experience in writing Programming Languages like Power Shell, Python, R, C#, ASP.NET, and VBA Macros.• Good Knowledge of Big Data Analytics, parallel processing of data and understanding of big data technologies like Hadoop and Spark.• Worked With in all phases of Software Development Life Cycle (SDLC) in accordance with Agile Methodologies.• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors• Good commitment, result oriented, hard working with a quest and zeal to learn new technologies.