Business Analyst with 5 years exp as Data Ananlyst PL/SQL, SQL, Unix

ANANYA CHOUDHURY

● ********@***.*** ● +1-315-***-**** ● https://www.linkedin.com/in/ananyachoudhury1 PROFESSIONAL SUMMARY

Master’s in Information Management (CAS) & 5 years of experience as a Business Analyst

Proven abilities in customer facing roles in Telecom & Risk Management Domains

Area of expertise: SQL, Risk & Compliance, Project Management, Requirement Analysis, Data Analytics CAREER HIGHLIGHTS

Business Analyst, MetricStream Inc. – Bangalore, India 2014 – 2015

• Led requirement workshops & created specification documents (SRS, FSD & Design) to build GRC library for Barclay’s UK

• Created user stories to develop new feature for existing risk management product to make it SOX compliant

• Improved process flows in risk management system for Barclays, rolled out to 20k users worldwide, reducing manual efforts by 40%

• Developed requirement traceability matrix to identify product gaps, facilitating easier tracking of requirements by QA & Dev teams

• Curated rich dashboards on KPI’s demonstrating risk analytics using SQL & JS validations, increasing efficiency of risk audits by 10% Business Analyst, Tech Mahindra - Doha, Qatar 2012 –2014

• Conducted requirement elicitation workshops & analyzed source systems to revamp telecom system (CRM, BRM) for entire country

• Identified bottlenecks, process gaps in the existing system & performed root cause analysis (RCA), reducing data discrepancy by 11%

• Strategized migration of customer & billing details to new system for process enhancement, reducing time taken for data flow by 35%

• Consulted British Telecom & Vodafone to implement bulk data manipulation thus optimizing deployment/upgrade time by 25%

• Devised comprehensive User Acceptance, Interface & Integration testing plans and boosted on time project delivery

• Acted as a liaison between cross functional teams & clients to address & improve visibility of technical issues & business needs Team Lead/Data Analyst, Tech Mahindra - Bangalore, India 2010 – 2012

• Spearheaded design & development of data flows, error handling, fallout management, reconciliation strategy for common data migration framework, adopted as a standard by the company resulting in saving development efforts by around 40%

• Pioneered source CRM & BRM data analysis, automated data acquisition using Oracle Watchdog & Unix, thus saving 15% dev time

• Capitalized on data quality issues; automated data cleanse using PL/SQL & excel resulting in securing a project worth $100k

• Acted as Scrum Master for projects & communicated with senior management on project metrics, backlogs & plan iterations

• Ensured unit testing, go live & release activities for production issues thus increasing product quality & improving CSAT score by 12%

• Mentored, coached & on-boarded 5 team members for smooth project transition & was closely involved in training end users

• Improved the accuracy of time & budget estimates by 20% by creating Proof of Concept for a data warehouse project ACADEMIC PROJECTS

Enterprise Risk Management – Sadler Dining Hall Spring 2016

• Gathered business requirements, identified risks faced & risk appetite of clients, created requirement document & took client signoff

• Performed qualitative & quantitative Risk assessments using Probability-Impact scores, Risk maps & identified control measures

• Showcased risks & mitigations, cost benefit analysis & contingency planning, disaster recovery strategies & technology requirements

• Used Tableau to create visualizations on risk data & published dashboards on Tableau server with auto refresh feature Project Management – Optical Illusion Fall 2016

• Authored Project Charter by identifying business requirements, stakeholders, scope of project, deliverables, assumptions & risks

• Created Project Plan & allocated budget by identifying various tasks, milestones & dependencies using Microsoft Project plan (MPP) Data Warehouse – Nop Commerce E Shopping Website Fall 2016

• Analyzed shipping & Inventory management processes, identified data flows, granularity of data capture & database tables involved

• Identified business cases to create facts, dimensions & attributes from operational database; created bus matrix & attribute mapping

• Created data mart using Kimball’s architecture, providing Business Intelligence to users using interactive visualizations & dashboards EDUCATION

MS in Information Management, School of Information Studies, Syracuse University 2015 – 2017 Core Subjects: Project Management, Information Visualization, Advanced Data Analytics GPA – 3.93 Bachelor of Engineering, Visvesvaraya Technological University, India 2006 – 2010 Core Subjects: Telecommunication & Electronics GPA - 3.5 TECHNICAL EXPERTISE

• Tools: Oracle SQL developer, Microsoft SQL Server, Power BI, Tableau, GIT, SSAS, SSIS, Jasper Reporting, Erwin, Jupyter, Pig, OWB, Zeppelin, SVN, Microsoft Office Suite, Microsoft Project, Adobe illustrator, MS Visio, OBIEE, Jira

• Programming Languages: UNIX/Linux, SQL, PL/SQL, Oracle 10g/11G, Python, HTML, Pandas

• Competencies: Data analytics & Reporting, RDBMS, Big Data Analytics, Data mining, Object oriented programming, Data structures & Algorithms, Data Migration, Data Acquisition, Performance Tuning, Bulk Data Handling ACHIEVEMENTS & CERTIFICATIONS

• Made Project Module Lead in iConsult for Lock shop Project for displaying management skills & leading others

• Recognized by Senior Management for being collaborative, excellent implementation/delivery of 3 modules & awarded “Outstanding Team Player”

Contact this candidate