Sql Server Data Entry
Resume:
Chitra Kanwar
*********@*****.***
Dublin, CA
Work Authorization: Green Card
Information Technology professional with extensive experience in SQL, MS-Excel, ERP, data analysis, quality analysis, seeking full time employment and contract opportunities.
Business Systems Analyst
Over 3 years of IT experience in Software development life cycle: system analysis, design, development, testing and implementation of projects in Healthcare & other Financial Systems.
Experience as a Business and Data analyst using SQL and Excel across various database systems
Working knowledge of Data Warehouse and ETL/OLAP processes.
Familiarity with SAP Business Objects and Crystal Reports and other workflow management tools.
Good command of MS SQL, MS Access, Visio, Word, Excel Using VLOOKUP and other mathematical functions
Good understanding of Data modeling concepts like ER Diagrams, Use Cases, Normalization (3NF) and De-normalization of Tables, star schema table structures.
Strong in various SDLC methodologies, agile, waterfall framework.
Ability to translate business requirements into defined tasks and technical specifications.
Well organized, strong work ethics and willingness to work hard to achieve employer objectives, a strong team player.
Can run the extra mile to finish the job on time and can quickly adapt to any/aggressive environments.
Possess good leadership qualities, good Interpersonal Skills, team-working attitude, take initiatives and very proactive in problems solving and providing best solutions
TECHNICAL SUMMARY
Programming Languages: C#, ASP.Net-3.5/4.0, Java, HTML/CSS, Python(basics)
Software: MS Office, .Net Framework, ArcGIS 10.3
Database: SQL Server, Oracle, MS Access, SSRS, Crystal Reports
CRM tools: SAP Business One, Salesforce
Statistical tool: SAS (basics)
Testing tools: UAT, JIRA
Operating systems: Windows, Unix/Linux
Accounting Software: QuickBooks, Payroll Accounting
Visualization Tools: Tableau
WORK EXPERIENCE
Database Administrator Osullivanvending San Jose, CA
December 2016 to Jan 2017
Responsibilities: Finance and Business Operations
Data administration (Master files entry/maintenance including Customers, Invoice Items, pricing Sheets, products, reporting, vendors, supply chain)
Data entry and data validation of inventory invoices using Excel
Data administration (Excel)
Environment: MS- Excel, Vendmax software, Data entry, Inventory
Business Systems Analyst(Contract), SafeSecurity San Ramon, CA
November 2015 – August -2016
Responsibilities : Finance and accounting Project
Data conversion and migration from Legacy systems to modern application
Created & ran various ad-hoc SQL queries for data reporting and analysis across databases
Provide day-to-day reporting and analysis of data to accounting and acquisition teams.
Update and published old Crystal reports using SAP info view
Worked with Pivot tables, VLOOKUP in Excel
Export customer data from Excel to SQL tables.
Environment:
MS-Excel (VLOOKUP and Pivot Tables), T-SQL, Business Objects, Crystal Reports
Data Analyst, Bracket San Francisco, CA
Dec 2014 to Feb 2015
Responsibilities: healthcare project
Worked on clinical trial databases
Plan and execute test scripts during unit testing
Create and run stored procedure to make tables based on client requirements
Updated business documents using MS-Visio and MS-word
Environment: Sql Server 2012, Unit testing, MS-Visio
Web Developer (Contract), Imperva Redwood City, CA
Oct 2014 to Nov 2014
Responsibilities: Web development project
Translate the company website in Japanese and Chinese language using ASP.net MVC
Mainly working on Front end technologies using Views in MVC.
Tested the web application on various mobile devices
Temporary UAT testing of web application on mobile platform using Agile
Environment: Asp.net MVC, Mobile testing etc.
Data Analyst (Contract), Ramsell Corp Oakland, CA
June 2014 to July 2014
Responsibilities: healthcare project
Worked on California AIDS patients project using SQL server.
Prepared various analysis reports on MS Excel.
Analyzed reporting requirements and assisted in enhancements to the dimensional model for the data warehouse.
Identify Bugs, write/track bug reports in bug tracking systems.
Worked with several teams during full SDLC, including offshore teams.
Analyzing the source data coming from different sources (SQL Server and from flat files like Access and Excel)
Environment: Excel, SQL Server, JIRA
Data Analyst, AJWI San Francisco, CA
August 2013 to September 2013
Responsibilities:
Worked on healthcare project using ASP.Net, C# and SQL server
Updated SSRS reports
Added validation controls in the web application
Tested and Validated the assessment forms in the web application
Environment: ASP.net, C#, Sql server, Tortoise subversion
Web Content Developer, Tibetan Aid Project Berkeley, CA
July 2012 to Dec 2012
Responsibilities:
•Uploaded and maintained web content
•Configured and managed permissions and roles
•Entered sales data in Salesforce CRM
•Perform Salesforce Administrative responsibility (this include: Users, Role, Profile, Access, Field creation/updates, etc.)
•Customization of Joomla Modules, Word press sites
•Tested sites on development/test servers prior to publishing
Environment: HTML, CSS, Joomla, Salesforce, SEO, WordPress, Drupal, Google Analytics
EDUCATION
•MCA - Masters in Computer Applications, Panjab University
•BSc - Bachelors of Science in Mathematics, Panjab University
•Completed courses in Business statistics from DVC (Pleasant Hill)
•Preparing for PMP certification, Financial Accounting
Contact this candidate