Data Transformation Associate 1
Bangalore
PROJECTSEnterprise Information Database (EID)• Database consisting of internal and external clients and fortune 500 companies. • Sourcing information from Wikipedia, NAICS, Company website, Bloomberg, Factiva, Hoovers, ZoomInfo, and D&B.• Analyze business information using primary and secondary research and create company hierarchy with merger and acquisition details.• Establishing necessary data governance and data stewarding process to match project… Show more PROJECTSEnterprise Information Database (EID)• Database consisting of internal and external clients and fortune 500 companies. • Sourcing information from Wikipedia, NAICS, Company website, Bloomberg, Factiva, Hoovers, ZoomInfo, and D&B.• Analyze business information using primary and secondary research and create company hierarchy with merger and acquisition details.• Establishing necessary data governance and data stewarding process to match project requirements.Jane’s (Aerospace & Defence Database)• Oracle based database consisting of companies operating in aerospace and defence sector. • Sourced information from Company website, Government database and through primary research. • Analyze and update financial data from company annual reports, SEC filings etc.• Published Aerospace & Defence magazine annually and further prepared customized reports based on client’s request.• Updated the remote database server regularly via PUTTY using MYSQL commands.• Trained several team members and performed regular quality inspection and analysis. Fairplay (Maritime Database)• Microsoft Access based database consisting of companies operating in Maritime sector. • Sourced information from Company website, Maritime organization website and through primary research. • Published Maritime magazine quarterly and annually. Further prepared customized reports based on client’s request.• Performed automation to increase the accuracy of data and lifecycle of the product using tools such as weblink extractor and WebWatcher.• Subject Matter Expert (SME) for the Maritime process and have conducted numerous audits.• Prepared several process documents towards improving process efficiency.• Led efforts to develop a fully integrated, marketing communications plan. • Responsible for successful corporate re-brand of Fairplay and update all its related assets, including data in website, chasing letter (e-mail), advertising, and customer support materials. Show less