Job description:
who we are?for the past 20 years, we have powered many digital experiences for the fortune 500. since 1999, we have grown from a few people to more than 4000 team members across the globe that are engaged in various digital modernization. for a brief 1 minute video about us, you can check https:youtu.beujwbwqzea6o.responsibilities:evaluating business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing solutions.leading ongoing reviews of business processes and developing optimization strategies.staying up-to-date on the latest process and it advancements to automate and modernize systems.conducting meetings and presentations to share ideas and findings.performing requirements analysis.documenting and communicating the results of your efforts.effectively communicating your insights and plans to cross-functional team members and management.gathering critical information from meetings with various stakeholders and producing useful reports.working closely with clients, technicians, and managerial staff.providing leadership, training, coaching, and guidance to junior staff.allocating resources and maintaining cost efficiency.ensuring solutions meet business needs and requirements.performing user acceptance testing.managing projects, developing project plans, and monitoring performance.updating, implementing, and maintaining procedures.prioritizing initiatives based on business needs and requirements.serving as a liaison between stakeholders and users.managing competing resources and priorities.monitoring deliverables and ensuring timely completion of projects.requirements:a bachelors degree in itcomputer science or related field or an mba.10+ years of experience in business analysis or a related field.exceptional analytical and conceptual thinking skills.the ability to influence stakeholders and work closely with them to determine acceptable solutions.advanced technical skills.excellent documentation skills.fundamental analytical and conceptual thinking skills.experience creating detailed reports and giving presentations.competency in microsoft applications including word, excel, and outlook.a track record of following through on commitments.excellent planning, organizational, and time management skills.experience leading and developing top-performing teams.a history of leading and supporting successful projects.

Resume:
<<career overviewsenior data analyst with 8+ years experience in business/data analysis, data profiling, data mining and reporting. 8+ years in pl/sql and t-sql programming. 7+ years experience with oracle database. 6+ years experience in sql server 2005/2008/2012. 4+ years experience with sas and teradata proficient in advance excel functions, pivot, graphs, vlookup and macros. knowledge of big data ecosystem such as hadoop, hive and hdfs. qualificationsoperating system: windows xp/7/8/10, ubuntu 12.04, mac os.programming languages: pl/sql, c++, java, unix, visual basic.database: teradata, oracle 8i/9i/10g/11g, sql server 2003/2005/2008, access.scripting: python.reporting tools: hyperion, brio, omniture, jmp, tableau, sas and excel.etl tools: teradata fastload, teradata fastimport, sql server, sas enterprise guide.other tools: toad, sas enterprise guide, sas enterprise miner, putty, cygwin, filezilla, winscp.web technology: html, xhtml, xmldesign methodologies: ms visio, erwin work experience 08/2011topresentsenior technical data analyst consultantc.h. robinson worldwide, inc. ,involved in requirement gathering, creating function requirement document, technical design document, process flow documents, excel and ms visio. /sql, t-sql on teradata, oracle and sql server 2008/2012 and sas database created and maintained supply chain reporting.automated new and existing reports by using teradata bteq batch scripts.created reports in sas 9.2.performed etl from text/csv to sas and sas to teradata/oracle.used sql server, teradata fastload, teradata fastimport for etl monitor unix production jobs through putty.experience in unix scripting.performed gap analysis between processes, data and reports.performed uat on the production and staging database and documented the uat results for business.provided sas and sql training non-technical members of the team.experience using business analysis and requirements modeling tools, such as data flow diagrams, relationship data models, xml modeling, business process modelling.conduct data analysis in support of applications and projects, including identifying and documenting business rules, data needs and data specifications.perform technical data profiling including the development of baselines, statistics and aggregated data attributes. 06/2008to 07/2011senior marketing data analyst consultantroyal caribbean cruise lines ltd city,state,worked as a part of celebrity cruises crm team which maintains 80+ million customer and transactional data.created sas marketing data models for marketing by using proc sql programming in sas.this data model helped to predict the probability of what segments of customers would choose type or destination of cruise.performed qa and ad- /sql and t-sql.worked with direct marketing team to provide potential customer data for their email and direct marketing campaign.worked with 3rd party travel agents to update rccl customer database by importing customer data in flat files into oracle database.provided idea's and strategies to indentify target customers data for a marketing camapigns.created reports and analysis on the performance of a marketing campaign by identifying targeted audience for a marketing campaign vs total bookings achieved from the original data.created reports on the celebrity.com website performance using omniture site catalyst.created ad-hoc and scheduled reports on customer profiles and behavior, sailing and transactional data.supported different teams such as sales, air and sea, customer care with reporting, etl, analysis and testing.created reports on customer info, cruise sailings, web bookings etc.used reporting tools such as hyperion, sas, jmp, brio, omniture and excel.automated reports in sas and hyperion.provided basic sas training to different teams within royal caribbean cruise lines created presentations slides, for the senior management. 05/2007to 04/2008data analyst consultantchoice point inc city,state,performed data analysis and data validation by writing pl/sql queries on toad against the oracle database.created data dictionary, data mapping and used cased documents on various data sets like government records, public records, corporate records etc using excel.performed data modeling by creating logical and physical data model of the database system.analyzed and created multiple ad-hoc and scheduled reports for users based on user requirements.created er diagrams, data flow diagrams and data mapping documents using ms visio and words interacted with users for verifying user requirements, managing change control process, updating existing documentation.worked extensively with flat files such as .txt, .csv, .xml.performed data mapping and generated reports on the mapping results using excel.developed, tracked and managed issues log created during the test phase.managed and tracked defects using quality center. 01/2007to 04/2007business data analyst consultantsnap-on business solutions city,state,responsible for writing functional requirement specifications and user requirement specification.interacted with users for verifying user requirements, managing change control process, updating existing documentation.wrote standard and complex sql and pl/sql queries to perform data validation and graph validation to make sure test results matched back to expected results based on the user needs.involved in qa check on flat files my importing into sql server database and performing quality and volume checks.involved in logical and physical data modeling.created reports as per business requirements and developing drill down reporting.created process documents, reporting specs and templates, training material and slideshow presentations for the application development teams and managements.created and maintained process flow documentations with data flow diagrams. education and trainingexpected indecember 2008totom.s computer scienceinstitute of technology (suny), .gpa:computer scienceexpected inmay 2004totob.s computer engineeringmumbai university,mumbai,gpa:computer engineering skills ad, application development, basic, brio, business analysis, business process, c++, com, crm, customer care, data analysis, data dictionary, data modeling, data validation, database, direct marketing, documentation, email, erwin, etl, senior management, xml, functional, government, html, hyperion, web technology, java, mac os, managing, excel, words, modeling, enterprise, operating system, oracle 8i, /sql, oracle and sql, predict, presentations, processes, programming, python, , reporting, requirement, sales, sas 9.2, scripts, scripting, specification, sql server, statistics, supply chain, tableau, teradata, toad, training material, t-sql, type, unix scripting, validation, visio, visual basic, website, xhtml.