VeeraPratap Boyalla

Dear Hiring manager,

I have 9 + years of IT experience working as Informatica/warehouse Developer with expertise in Informatica Power Centre, IICS and warehousing concepts.

I have good experience in developing SSIS projects and Proficient in SQL.

I am Proficient in Microsoft tools like Word, Excel, MS Access and Azure DevOps

Given the opportunity, I strongly believe that I could be an asset to your esteemed organization

• 9 + years of total IT experience working as a data warehouse/ETL and BI Developer with expertise in Informatica Power Center/IICS, Power BI, T-SQl and PL-SQl ,SSIS
• Extensively used ETL methodology for supporting Data Extraction, transformation, and loading processing, in a corporate-wide-ETL Solution using Informatica 
• Worked on all the Transformations like Lookup, Aggregator, Expression, Filter, Update Strategy (Implemented slowly changing dimensions Type1 and Type2), and stored procedure, Sequence Generator, Sorter, Rank, and Router
• extract, transform, and load data into target systems from Various data sources like SAP ,SQl server, Oracle DB.
• Have experience with cloud based Informatica Services IICS (IPaaS and SaaS).
• Have experience in Converting Power center on-prem jobs to IICS.
• Integrated customer data into Salesforce using IICS
• Experience in implementing and managing workload automation solutions using Control-M.
• Proficient in defining, scheduling, and managing batch processing workflows across multiple platforms and applications using Control-M
• Knowledge in implementing security measures and access controls in Informatica Server to protect sensitive data and ensure compliance with relevant regulations.
• I am Certified Power BI Data Analyst (PL-300) worked extensively in every aspect of the Power Bi Tool like Power Query, Power Pivot, Power View, Power Map, Power Q&A, Power BI Desktop, Power BI Website, and Power Mobile Apps. 
• Experience in creating measures and calculate columns using DAX. 
• Have good understanding of Data ware housing concepts like normalization and DB constraints. 
• Good knowledge in RDBMS, Dimensional Modeling, ER Modeling, Data Marts, Star Schema / Snowflake Schema, FACT, and Dimensional tables. 
• Experience in gathering business requirements by meeting with subject matter experts and identify project impediments, needed resources, or delays in completing the task. 
• Excellent communication and analytical skills and understanding of business requirements in various domains. 
• Strong problem-solving and analytical skills with the ability to work independently and in a team. 

Bachelor’s degree in Bioinformatics From 03-2007 to 03-2011Bharath University, INDIA Post-Graduation Certification in ITBA (Information Technology Business Analysis) From 03-2021 to 09-2022Conestoga College, Ontario