Badges
Certifications
Work Experience
Senior Programmer
Enterprise Pals Inc• July 2014 - Present
• Assisted Business Leaders in the decision-making process with basic, advanced and complex Reports, Dashboards using Reporting tools like IBM Cognos Analytics, Microsoft Power BI and Tableau. • Managed and developed new/existing integrations from various sources like Oracle ERP, Salsforce.com, Files, SQL Server etc., to Data Warehouse using Informatica ETL. • Get data from Azure HD Insight using Hive (HiveQL) for data analytics. • Create Packages/Models, Cubes using Cognos Framework Manager, Transformer and Power BI to help the business for Self Service analysis portal. • Lead team of 10 Members to develop and maintain Cognos reports, by gathering requirements from business teams and getting it delivered in time with teamwork. • Experience in writing advanced SQL to get large data sets in Microsoft Excel for analysis using standard Formulas, Pivot, VLOOKUPS etc.,
Technical Lead
iGATE/Patni Computers• November 2009 - July 2014
• Lead team of 10 members in offshore with explaining Requirements and getting the work done in time by helping them and getting the status regularly. • Developed and maintained Cognos Reports, Dashboards, Packages for business requirements. • Integrated different sources of data with Data Warehouse using Informatica. • Utilized Unix Shell scripting to automate Informatica jobs and to perform tasks which are not natively possible in Informatica. • Work on Enhancement and fix issues on existing objects in Business Intelligence Environment. • Resolving the Service Calls raised by users as per SLA. • Direct interaction with the clients for understanding the functionality, business logic, and requirement. • Develop Reports, Scorecards, and Dashboards required for the business development using Cognos for various modules in ERP like Finance, AP, AR, PA, PO etc. and also from Salesforce • Write complex or simple SQL to extract data from Data Warehouse to help with the business users with their one-time analysis. • Also, Support and maintain the existing environment by resolving issues from Client. • Client Liaison and Quality Management • Maintain and Support the ETL load from Oracle ERP R12 to Data warehouse using Informatica. • Create Integrations using Informatica from Sources like Oracle ERP, Salesforce, and Files etc. • Developed new integrations with different sources using Informatica ETL for BI Reporting. • Scheduling of Informatica Jobs using Crontabs or Scripts. • Develop different Visualizations, Dashboards, and Scorecards etc. for Business Leaders.
Software Engineer
Keane International Pvt Ltd• March 2008 - April 2009
• Worked in multiple Projects as BI Developer. • Worked as a developer in creating Packages (Universe) for Ad-Hoc Business Objects Reporting to see the Historical Data for Honeywell • Worked as a Cognos Developer in developing reports based on the requirements received from Onsite for Staples. • Worked as an Informatica developer for a Data Migration project to develop ETL loads for Honeywell
Education
Anna University
Information Technology, B.Tech• June 2003 - May 2007
Links
Skills
pkarthik86 has not updated skills details yet.