SUMMARY:

• Over 5+ years of total IT and Business experience with extensive knowledge in MSSQL
• Strong skills in Microsoft SQL Server environment, Microsoft Excel and/or Excel Services, SharePoint: expertise in SQL Server 2008 R2/2012 SSRS, SSIS, SSDT, Business Intelligent Development Studio (BIDS).
• Strong skills and knowledge in building data warehouses, data integration, operational stores and ETL processes.
• Strong experience in working with large scale Data Warehouse implementations using Microsoft SQL Server.
• Extensive experience in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse using SQL Server Data Tool, BIDS
• Extensive working knowledge with different types of data load strategies and scenarios like Historical Dimensions, Surrogate keys, Summary facts etc.,
• Experience in implementing Backup & Restore (Full, Differential and Transactional) procedures, Log Shipping and Transactional Replication.
• Experience in Performance Tuning and Optimization of SQL Server, SQL Scripts and Stored Procedures.
• Very good understanding of Software Development Life Cycle (SDLC) and Quality Assurance Life Cycle (QALC) and QA Methodologies
• Experience includes White Box Testing, Black Box Testing, GUI Testing, System Testing, Performance Testing, Regression Testing, Functional Testing, Integration Testing, Benchmark (with external client) testing and Data warehouse testing
• Experience in writing test plans, developing test cases, developing and maintaining test scripts in Quality Center/Clear Quest tools. Documented all phases of QA process
• Extensively executed SQL queries on SQL Server tables to view successful transactions of data and for data validation
• Proficient in Bug tracking tool like HP ALM and JIRA
• Strong written and verbal communication, interpersonal skills, attention to detail and organization.

TECHNICAL SKILLS:

Programming Languages: SQL, Transact SQL, XML, ASP.NET using C#, HTML, CSS

Microsoft Technologies: MS SSRS, SSIS, MS Office 2003/2007/2010 , MS Visual Studio 2008/2010, MS SharePoint

Databases: MSSQL Server 2008 R2/2012/2014, MS Access, Tera Data, SQL Developer

Database Concepts/Strategy: Snowflake, Star Schema, Datamart, Data Warehousing, OLAP and OLTP

Software: SQL Server Studio Management, Database Engine Tuning Advisor, SQL Server Profiler, MS Visio, MS Project, Waterfall, Scrum/Agile

Operating Systems: Windows XP/Vista/7/8/8.1/10, Windows Server 2003/2008, Linux

Bug Tracking Tool:: HP ALM, JIRA

PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence Analytic Consultant

Responsibilities:

• Reviewed the Business Requirement Documents (BRD) and System Requirement Specification (SRS) and developed test cases for each functional requirement.
• Developed and executed database queries and conducted analyses
• Analyzed testing results to ensure the solution meets the needs of the business.
• Create visualizations and reports for requested projects using BI technologies (Microsoft BI, Oracle)
• Reviews test plans and monitors testing process to ensure that business results are tested. performed analysis for a wide range of requests using data in different formats and from various platforms.
• Created visualizations and reports for requested projects using Tableau
• Created and managed BI and analytics solutions that turn data into knowledge
• Developed and updated technical documentation
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business. Configured performance tuning settings using indexes, SQL profiler
• Good knowledge in Normalizing and De - normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Writing test plans and test cases for different test environments relating to different System of Records
• Worked in all phases testing like Smoke, GUI, Integration, System, Business Functionality and Regression Testing of the application.
• Efficiently handled entire Bug Tracking process, which includes verifying, closing and reporting them, using JIRA Bug Tracking Tool.
• Coordinated with technical leads to determine when fixes be promoted to test/Prod environments.
• Extensive use of JIRA in filing bugs along with determining urgency level and regular follow up with developers ensuring that resolution goes out within specific timeline.
• Collaborating with Developers, Business Analyst, project managers, and product owners to resolve issues relating to performance and data quality.
• Performed backend regression testing by writing SQL statements to review the returned data to ensure that the correct data was retrieved.

Confidential, Maplewood, MN.

Data Analyst

Responsibilities:

• Reporting the results back to the relevant members of the business
• Identifying patterns and trends in data sets
• Working alongside teams within the business or the management team to establish business needs
• Defining new data collection and analysis processes
• Assist with data migration to office 365 portal. Store client files on OneDrive database and maintenance
• Interpreted data, analyzed results using statistical techniques and provide ongoing reports
• Developed and implemented databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality
• Acquired data from primary or secondary data sources and maintain databases/data systems
• Using multiple software such as Cashe, QuickBooks, Microsoft, Adobe, google AdWords in the day to day operations.
• Responsible for communicating with remote design and programming staff about software issues, documentation.
• Assure ongoing compliance with quality and industry regulatory requirement.
• Developed, maintain, and analyze budgets, preparing periodic reports that compare budgeted costs to actual costs.
• Analyzed business operations, trends, costs, revenues, financial commitments, and obligations, to project future revenues and expenses or to provide advice.

Confidential, Bloomington, MN.

Quality Analyst - Part time consultant

Responsibilities:

• SQL scripting to create test data and loading it into a MS SQL server database.
• Fixed fields mapping issues that arose while loading client data files.
• Working with multifunctional applications from end for software quality engineering.
• Collaborating with Developers, senior DBA’s, project managers, and product owners to resolve issues relating to performance and data quality.
• Trouble shooting when loaded data doesn’t show up on a UI search.
• Tracing bugs in data until they are resolved.
• Logging defects and escalating when necessary.
• Knowledge of agile methodology and teamwork with excellent communication skills.
• Strength in different RDMS like MySQL and MS SQL server.
• Working knowledge in all MS Office that are used frequently at work.
• Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures.
• Create and support SQL Server stored procedures, Databases, functions, views, and tables
• Extensive knowledge in dealing with table joins, queries and SQL indexing.
• An independent thinker with the ability to multitask in a fast-paced environment

Confidential, Eagan MN

Account Payable/Receivable Analyst

• Imported and exported data from text files, saved queries, or databases; used automatic outlining, inserted subtotals, created advanced filters, and used database functions.
• Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and group data, and refreshed and formatted pivot tables.
• Designed, recorded, and executed macros to automate data entry inputs.
• Formatted spreadsheets and workbooks for print, document reproduction, and presentations.
• Verify and calculate all extensions and totals on invoices, calculating and taking discounts when applicable.
• Reconcile invoice statements