SUMMARY:

• Data Analyst with over 6 years of experience
• Solutions - driven, self-motivated analyst with industry experience in providing analytics insights to different areas, identifying the right technical questions that need to be answered, building the most relevant data-driven solutions for business, and deploying the solutions in business applications with Strong mathematical and statistical background in modeling, extensive hands-on programming experience in multiple languages.
• As a Data Analyst Consultant, I provide support in analysis and documentation of business needs and ensuring the accurate alignment of technology with business objectives, I am experienced in data modeling, business analysis, cross system integration analysis, data analysis, use case analysis, requirements elicitation, gap analysis, configuration and change management, process re-engineering, design, testing, problem-solving and project management.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Experienced in leading analysis and requirement-gathering efforts for application development projects involving Agile, Rational Unified Process (RUP), Agile, and Waterfall processes.
• Worked extensively on Erwin and ER studio in several projects in both OLAP and OLTP applications.
• Advanced knowledge of applied statistical methodologies including least square regression, panel regression, Logistics analysis regression, sampling methodologies, time series analysis and forecasting, survival analysis, cluster analysis, categorical data decision tree, multivariate methodologies, non-parametric techniques and principal component analysis.
• Knowledge and experience with SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
• Adept at working in a high-pressured environment, maintaining workload, and driving projects to closure.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin r7.1/7.2, ER Studio V8.0.1 and Oracle Designer

Programming Languages: MS SQL, T-SQL, Base SAS and SAS/SQL, R

Database Tools: Microsoft SQL Server 2000/2005/2008, MS Access, MS Excel, MS PowerPoint

Operating Systems: Microsoft Office Suite, Microsoft Project 2010, Microsoft Windows 9x/NT/2000/XP/Vista/7 and UNIX

Reporting Tools: Crystal Reports 11,10,9, SSRS.

Methodologies: OOAD, UML, RUP (Rational Unified Process), RAD (Rapid Application Development), Agile, Waterfall

PROFESSIONAL EXPERIENCE:

Data Analyst Consultant

Confidential, Rockville, MD

Responsibilities:

• Working with clients to determine requirements and to define scope on a project. Clarifying client’s system specification, understanding their work practices and the nature of their business. Planning timescale and the resources Needed.
• Develop agreed solution and implementing new system. Helping client with change management techniques.
• Coordinated with sponsors and stakeholders to formalize the scope of the project. Developed a detailed project plan in coordination with Stakeholders.
• Worked with business analyst and project managers to determine the most effective testing and inspection strategy for project of varying complexity and size. Coordination with developers, subject experts and technical experts to design test cases based on requirements.
• Employed techniques like sorting and merging on the raw datasets and coded them using PROC SQL facility to get the required output.
• Performed Data Validation and Data cleaning by Peer-Reviewing.
• Performed Program Documentation on all programs, files and variables for accurate historical record and for future reference.
• Produced highly formatted and highly customized reports using Data Null .
• Expertise in Integration (Pooling) of datasets from different studies for further analysis.
• Extensive experience in Database design and development of applications using SQL Server 2000/2005/2008R2, Integration Services (SSIS), Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MDX queries, OLAP Cubes, Star Schema and Snowflake schema.
• Performed hands-on data extraction and collection; analyzed data using MS Access (SQL) & Excel supporting several functional areas (including but not limited to purchasing, sales, accounting, and finance); provided forecasting reports a recommendations.

System analyst

Confidential

Responsibilities:

• Developed scorecards in Excel for suppliers based on key performance indicators like spend data, on time delivery and quality resulting in a 15 % improvement in quality and service.
• Creating Business Requirement Document (BRD), Functional Requirements Specification (FRS), and technical requirement specification for application development.
• Developed software programs for collecting, storing, and analyzing data.
• Utilized MS Excel, pivot tables, V-lookups, and macros to analyze high volume activity, create journal entries, and perform account Reconciliation.
• Involved in preparing Process Flow Diagram & other UML Diagrams using MS Visio.
• Entering and securing information into the data systems with passwords.
• Consolidated data from SAP and Oracle ERP systems into a single report to analyze supplier spend data in different regions.

Confidential

SQL Server Database Administrator

Responsibilities:

• Installation and configuration of SQL Server 2000/2005/2008 /2008R2.
• Used SQL profiler for troubleshooting, monitoring, optimization of SQL server and SQL code.
• Performed data migration task for mission critical database.
• DBA duties including database backups, restores, performance tuning and capacity analysis.,
• Upgrading standalone services in different environment.
• Worked closely with Application DBA team and Network DBA team.
• Developed and maintained standards for SQL server user authentication, database security data naming conventions etc.
• Performed transactional replication.
• Created and monitored SQL server agent jobs and troubleshooting as required.
• Worked on SQL server mails and used for automated reports.
• Analyzed the execution plan for index creation.

Senior Analyst

Confidential

Responsibilities:

• Worked in customization of FirstGen, a software product for general insurance and involved in issue fixing.
• Analyzed the problem requests from customers and diagnosing it.
• Responsible for presenting the proof of concept.
• Configured multiple policies of the prospective insurance client.