BUSINESS SYSTEMS ANALYST I Qualifications TECHNICAL SKILLS: Business Applications: SAP Web Intelligence, Informatica Data Explorer, MS Visio, MS Project, Rational Rose, Business Objects Languages: SQL, UML,C, C++ Core Java Perl Web Development: HTML, XML, PHP Operating Systems: Windows XP/Vista/7, Linux Databases: Netezza, MS SQL Server 2005/2008, Oracle 9i/10g Accomplishments Organized workshops SQL Server 2005 technical fest Mumbai University Active member Student Council Asian Students University Maryland. Interface client multi-disciplinary teams within Merkle (Business Intelligence, Information Technology, Database Data Warehouse Developers) support solution delivery process Work closely clients understand marketing goals, design marketing databases, facilitate optimum segmentation provide platforms reports measure marketing ROI. Involved designing rolling global marketing databases (North America, Europe Middle East, Latin America) thus well versed Customer Data Integration international data hygiene standardization concepts. Enable client generate reports Measuring ROI, effective channels successful campaigns optimum segments trend analysis etc using tools like Business Objects Sound understanding projects life cycle, demand generation understanding customer requirement converting technical specifications finally implementing project. Jusitn: Served subject matter expert marketing data database design European Asia Pacific regions Involved support client requests adhoc reporting campaign execution. Also responsible identifying gaps deployed functionality building necessary new functionality alongwith correcting issues current solution -data integration,data hygiene, cleansing CDI -created marketing programs based client's requirements -supported existing solution daily basis data functionality issues -supervised change requests development implementation performed QA deliverables handoff client Automated Warranty Renewal Campaign Solution Project involved warranty based CRM marketing solution enabling warranty specific campaign execution reporting Responsibilities: -Support deployed CRM database solution Latin America region Fortune 500 company focusing Public Large enterprises -Executed marketing programs weekly basis Work Experience Company Name Business Systems Analyst I 09/2014 Current Acted lead BSA client team drive consistency support projects spanning multiple regional databases support teams Primary contact client, client partners stakeholders, managing daily responsibilities associated delivering multi-channel database marketing programs. Responsibilities include working client stake holders understand marketing program objectives business rules help define metrics program measurement Partner client, client partners stakeholders define campaign audience requirements, program specifications business requirements Project: SMB CRM Marketing Database Solution Maintaining global marketing data advanced targeting segmentation drive optimal business results Gathered analyzed business requirements provided client draft detailed project specifications lead developers development QA process Managed primary ownership creating artifacts like Business Requirement Document Functional Requirement Documents Performed gap analysis Root Cause analysis data issues functionality ensured client satisfaction Project: Consumer Global Marketing Database Solution CRM solution Latin America region Fortune 500 High Tech company supporting data integration, marketing program execution, reporting analytics Led change requests within cross-functional teams using defined change management process ensuring timely deployment Analyzed complex client data using Merkle's in-house methodologies provided recommendations improve marketing programs performance Created automated processes minimizing run-time increased efficiency database update campaign deliveries Manage overall coordination, status reporting stability complex cross-functional project oriented work efforts continuing evolve solution delivery lifecycle encompass multiple methodologies Interacted development QA teams ensure timely delivery project deliverables managing project timeline communicating adjustments issues program management. Responsibilities included creating documentation detail functional requirements, technical solution design, code review, implementation QA deliverables handoff client Project: Dell Financial Services Project service provided Dell provides credit line accounts Dell customers qualify. integrated database solution allows us use customer data Consumer marketing campaigns Led project change requests throughout full solution lifecycle performing requirements gathering, process documentation, data analysis quality control Lead solution discovery sessions client stakeholders means illicit solution requirements -Set data load automated processing data extracts weekly basis -Responsible process documentation consisting Business requirements functional requirements Source Target mapping data dictionary -Designed implemented email marketing campaigns Canada region per client's specifications -Created email marketing campaign targeting customers based credit line account information Reported campaign attribution, performance, key metrics Interface client, marketing vendors, cross-functional teams within Merkle solution delivery new project development Perform requirements gathering change requests maintain documentation Synthesize complex sometimes contradictory information concise, readable, unambiguous written requirements multiple levels detail Support campaign management process develop business goals, campaign requirements campaign metrics. Build maintain client reports relating data quality campaign measurement Work Solution Account Lead define project scope, level effort timeline Work closely delivery team (including system software engineers, QA, regression test teams, product manager) ensure clients' solution created exceptional quality. Accountable determining requesting campaign data elements creative agencies build accurate segmentations targeted educational public relations program deployments Provide input Project Management regarding schedule, level effort project scope Manage client communication expectation setting Lead change requests initiation delivery Interface client multi-disciplinary teams within Merkle support solution delivery process Take direction Project Management regarding schedule, scope, cost tradeoffs Assist delivery system production designing supporting formal client acceptance process, according Merkle's defined standards Accurately document requirements acceptance criteria Merkle Marketing solutions Perform analysis new data inclusion marketing database, ad-hoc analysis data database support requirements process Company Name IT Analyst Intern 05/2011 12/2011 Assisted IT Admin managing user access rights, user groups documentation upload MS SharePoint Analyzed business applications determine changes upgrades required business users processes Gathered business requirements converted detailed technical functional specifications Served technical liaison end-users application vendors obtain solutions application issues using HEAT ticketing system Tested vendor solutions newly modified systems ensure meet client specifications Generate customized reports using Business Intelligence tools meet user requirements Company Name IT Support 05/2010 07/2010 Used Sys-Aid ticketing software handling service requests library staff Responsible troubleshooting maintenance hardware software devices Maintained Local Area Network UM Libraries performed Ghosting, G-Disking processes Education Training MS Information Management University Maryland MS Information Management (Dec 2011) University Maryland GPA 3.67 /4.0 Relevant Courses: Database Design, Web Enabled Databases (PHP), Information Architecture, Management Information Services, Project Performance Measurement, System Software Requirements B.E Computer Engineering Mumbai University B.E Computer Engineering (May 2009) Mumbai University First Division Specialties: Professional Affiliations Active member Student Council Asian Students University Maryland Skills Database, Marketing, Systems Analyst, Project Management, Business Requirements, Solutions, Metrics, Qa, Documentation, Accountable For, Accounts To, Adjustments, And Account, Basis, Campaign Management, Client Communication, Clients, Consumer Marketing, Credit, Data Analysis, Data Quality, Financial Services, Mapping, Marketing Analysis, Marketing Campaign, Marketing Research, Process Documentation, Product Manager, Program Management, Public Relations, Quality Control, Requirements Gathering, Topo, Databases, Bsa, Business Systems Analysis, Change Management, Crm, Crm Marketing, Customer Relationship Management, Data Integration, Database Marketing, Deployment, Gap Analysis, Integration, Integrator, Qa Process, Root Cause Analysis, Satisfaction, Segmentation, Access, Business Intelligence, Functional Specifications, Liaison, Microsoft Sharepoint, Ms Sharepoint, Sharepoint, User Access, Writing Functional, C++, Data Warehouse, Front End, Front End Design, Front-end, Html, Informatica, Java, Lamp, Lamp Stack, Life Cycle, Linux, Microsoft Project, Ms Project, Ms Sql Server, Ms Sql Server 2005, Ms Visio, Mysql, Oracle, Perl, Rational, Rational Rose, Roi, Sap, Sorting, Sql, Sql Server, Sql Server 2005, Subject Matter Expert, Technical Specifications, Translated, Uml, Visio, Warranty, Windows Xp, Xml, Ghosting, It Support, Maintenance, Architecture, Database Design, Information Architecture, Php, Software Requirements