Summary of Qualifications

• Over 4 years of IT experience in the field of Business/Data analysis, Market Research, Analytics, ETL Development and Data Modeling.
• Hands on experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration, Predictive Modeling, Credit scoring, Statistical modeling, SQL and SAS programming.
• Hands on experience with BI tools, PM Tools Reporting tools like Oracle BI, Informatica, Micro strategy, Teradata, PPM, Cognos and Crystal reporting
• Experience in performing ad hoc queries for various application and reports on a daily/weekly or monthly basis
• Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using SQL and PL/SQL.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Expertise in defining scope of projects based on gathered Business Requirements including documentation of constraints, assumptions, business impacts project risks.
• Gathering business and Technical requirements that would best suit the needs of the technical architectural development process.
• Familiarity with advanced statistical modeling techniques and methodology
• Hands on experience with object oriented analysis and design and developing use-case models.
• Hands on experience in creating and transforming business requirements into functional requirements.
• Possess fundamental understanding in finance, marketing, production and personnel management.
• Strong numerical, interpretative, analytical and diagnostic skills.

Technical Skills

• BI Tools OBIEE, Rapid Miner, Micro strategy
• SAS Tools Enterprise Miner, Enterprise Guide
• Languages SQL, SAS, PL/SQL, HTML
• PM Tools PPM, Info view, AIM Work Order System
• Reporting tools Oracle BI, Cognos,Oracle,Discoverer, Crystal Reporting
• Database Oracle, SQL Server, Microsoft Excel, Access, Project, Visio
• Operating Systems Windows, Mac-OS

Work Experience

Sr Business/Data Analyst-Analytics, Confidential

• Involved in Analysis Marketing Team to make business decisions.
• Generate management information reports for all levels of management, using SAS, SQL to benchmark and trend findings against appropriate datasets
• Perform business rule analysis, creating process documentation, diagrams and feature specifications across cross functional teams
• Involve in high complex research, quantitative analysis, modeling and monitoring of data necessary to produce the logical design for review
• Report to all levels of management using analysis of data to offer recommendations and work effectively with managers to assess forecast and efficiency needs
• Logically evaluate findings, conduct comprehensive reviews to assess levels of accuracy and clearly summarize results, recommendations for actions
• Interrogate multiple systems, linking the data, and provide advanced application design and functional support
• Assist in planning and testing of application and database changes, installation of upgrades, patches and new versions, interacting with development, business process owners and infrastructure teams
• Interacting extensively with end users on requirement gathering, analysis and documentation
• Documented methodology, data reports and model results and communicated with the Project Team / Manager to share the knowledge
• Carried out data extraction and data manipulation using PROC SQL, PROC SORT, PROC REPORT to create preferred customer list as per business requirements
• Worked on advance querying the database using SQL in calculating and computing columns, using filters, manipulated and prepare the data for reporting and statistical summarization
• Report to all levels of management using analysis of data to offer recommendations and work effectively with managers to assess forecast and efficiency needs
• Used SQL and PROC SQL for ad-hoc report programming and creation of the ad-hoc reports for marketing research data
• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements
• Prepared and created conclusions and forecasts by analyzing and interpreting data summaries.
• Conducted GAP analysis so as to analyze the variance between the system capabilities and business requirements.
• Extract, transform and load datasets with basic modeling variables for each segment type
• Manipulated and updated the tables as per specifications.
• Used SAS/ACCESS to read datasets from Databases, Flat files, also read and write other PC File formats.
• Created new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, and conditional statements.

Market Analyst, Confidential

• Collecting, collating and carrying out complex data analysis in support of management customer requests. Also involved in reporting statistical findings to work colleagues and senior managers.
• Conduct large scale statistical and quantitative analysis using SAS, analyze research solutions and coordinate with sales team to optimize research solutions and deliverables
• Participate in customer analytic requirements, which include identifying data analysis needs, building predictive analytic models, developing analysis reports, and presenting reports to R D team
• Perform ongoing customer/market research using SPSS, SAS and perform demographic profiling to identify and capitalize on unmet market needs ahead of the curve
• Perform analysis and develop patterns using SAS on the historical data as well as data across the digital and social media to provide research solutions and work with the sales team to develop innovative marketing strategies
• Fine-tune ability to iterate back and forth between business questions, implications, data and statistical results to demonstrate present findings in a way that retains their statistical integrity and also perform data visualisation for better understanding and discussion
• Manipulating, cleansing processing data using Excel, Access and SQL.
• Responsible for loading, extracting and validation of client data and Liaising with end-users and 3rd party suppliers.
• Analyzing raw data, drawing conclusions developing recommendations
• Writing SQL scripts to manipulate data for data loads and extracts.
• Monitoring the automated loading processes.
• Using SQL SAS to extract, transform load source data from transaction systems.
• Communicated with third party vendors to do the programming.
• Created Report Models for ad-hoc reporting and analysis.

Market Research Analyst Confidential

• Responsible for collecting market data and evaluating information from diverse market sources. Analyzing qualitative quantitative information to support and review new and existing marketing and sales strategies.
• Creating and produce market research reports on specific products and markets.
• Making recommendations to senior managers based upon research findings.
• Processing and analyzing raw data into reports for senior managers.
• Work with external data suppliers regarding data accuracy and integrity.
• Responsible for the development of client reports on current trends.
• Making sure that methods of data collection are effectively and accurate.
• Designing effective questionnaires based on activity objectives and market knowledge.