OBJECTIVE:

To continuously work as a Data Analyst, in a progressive environment, with the opportunity to contribute to the success of the Organization that would allow me to utilize my technical, analytical, as well as interpersonal skills.

SUMMARY:

• 6+ years of IT Industry Experience in the Data Analysis, Design, Modeling and Data Warehousing.
• Expertise in Microsoft SQL Server and Sybase.
• Proficient in Informatica.
• Professional experience using advanced SQL coding, in various platforms, such as Teradata and SQL server for data mining and report generation.
• Expertise in DDL and DML, as well as using Aggregate Functions.
• Extensively worked on MS SQL Server Databases, as well as Microsoft Access.
• Professional experience in data analysis and identifying issues, as well as report creation from several andComplex data sources.
• Created numerous Volatile, Set and Multi - Set tables using Teradata.
• Developed numerous SQL Queries for data Extraction.
• Proficient in Conceptual, Logical and Physical Modeling
• Expertise in the use of UML Diagrams (Use Case, Class, and Package).
• Proficient in Data Cleansing and Scrubbing.
• Excellent communication with multifunctional teams, programmers and technical staff at all levels.
• Strong customer service skills and experience consulting with users, resolving problems and meeting specific technical and business needs.
• Participated in requirements gathering and analysis, as well as Design sessions to understand the needs of the users.
• Highly proficient in understanding end user requirements and submitting efficient and quick solutions.
• Solid background in technical and problem solving concepts and have an excellent capability of utilizing academic knowledge and previous experience.
• Comprehensive knowledge and experience in all phases of the Software Development Life Cycle (SDLC).
• Strong team building and development skills.
• Ability to meet deadlines, and produce effective results, while working both independently and in teams.

TECHNICAL SKILLS:

Operating System: Win XP, 7, and 8, Windows Server 2003, 2008, (X64), and Linux

Databases: MS SQL Server 2008/2012, Sybase, Netezza, Reports-To-Go

ETL/Other Tools: SSAS, SSRS, SSIS, Sybase

Scripting: SQL, Tableau, MicroStrategy

Querying Tools: SQL Server Management Studio 2008/2012, Teradata SQL Assistant, SQL Developer, MicroStrategy, Reports-To-Go

Software: Microsoft Office Word, Excel, Access, PowerPoint, Visio, and SQL Server Power Pivot for Excel

Software Development: Analysis, Design, Coding, Testing and Documentation, Software Development Life Cycle (SDLC)

PROFESSIONAL EXPERIENCE:

Confidential,Charlotte,NC

Data Analyst

• Gathering and analyzing business requirements, conduct gap analysis, set operational specifications, designing.
• Developed, implemented and evaluated metadata and cataloging workflows and standards
• Drafted and implemented metadata and cataloging policies and workflows for library resources
• Developed, analyzed, improved and maintained metadata information
• Interpreted and adhered to established cataloging and metadata standards
• Create and develop data linage from the source to the target point that is destination point
• Develop reusable, enterprise-wide analysis, design, and construction components through data modeling processes using data movement tools, to ensure an acceptable level of data quality per business specifications
• Enforce standards and best practices around data mining, data modeling efforts
• Integrate controls into the data modelling movement process to ensure data quality and integrity
• Developing and testing of Client/ Server and Internet based applications using Java, JSP, Servlets, SQL, XML, MS Access, Oracle and QA testing tools.
• Migrate reports from multiple platforms to centralized BI ODS platform in order to get centralized source suing ICOMS and CSG Billing systems for all the reports.
• Create and maintain reports based on report requests from different customer and sales, Finance, Marketing and several other departments using SQL/TSQL, (AS400), Oracle and develop and maintain Ad-hoc reports using Microstrategy tools.
• Work on SSRS reports and deployment, create or automate Peer Review Templates using Excel VBA
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Involved in designing cubes in SSAS environment
• Work with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects
• Create and maintain reports based on report requests from different customer and sales, Finance, Marketing and several other departments using SQL/TSQL, (AS400), Oracle and develop and maintain Ad-hoc reports using Microstrategy tools.
• Developed codes in multiple billing applications using SQL queries/scripts based on the approved Business Requirement Document.
• Provided functional / technical support on current systems in ICOMS, ODS and CSG billing system by ensuring escalated issues are communicated, managed and resolved considering priority and customer impact
• Create and develop report using Microstrategy reporting tools and maintains data consistency and integrity
• Work with Business Analysts to understand client needs and suggested alternatives for a more effective and efficient Business process.
• Interacted with end-users and business analysts, identifying and developing business requirements.

Confidential,Burlington,NC

Data Analyst

• Requirements gathering & analysis.
• Performed Documentation of Business & Systems Requirements
• Performed numerous SQL Statements to Load and Extract Data to and From Database.
• Created Multi Set, Set and Volatile tables using Teradata.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Developed Tableau visualizations and dashboards using Tableau Desktop
• Developed Tableau workbooks from multiple data sources using Data Blending
• Extensive use of OLAP Function as well as complex joins to extract data for reporting purposes
• Created views to make data available on need to know basis.
• Created queries to fetch data from different tables, using derived tables, Sub queries, as well as Correlated queries on SQL Server platform.
• Performed numerous SQL queries that were highly tuned using concepts like Explain, Stats and CAST.
• Used UML Diagrams to graphically capture system functionalities.
• Periodically Designed Conceptual, Logical and Physical Models to effectively improve Business processes.
• Modified various data sources, writing complex new queries based on business needs.
• Maintained departmental reports on daily basis and managed performance issues.
• Daily interaction with internal users, and business analysts for updates and implementation of data request for key business reports.
• Interacted with Business Analysts to understand client needs and suggested alternatives for a more effective and efficient Business process.
• Worked side by side with end-users and business analysts to identify and develop business requirements.

Confidential,Abbott Park,IL

Data Architect

• Created and refreshed monthly Data Marts for various processes.
• Requirements Analysis, identifying the necessary tables that need to be populated into the database.
• Performed numerous data extraction requests involving SQL scripts.
• Analyzed data coming from different Data Sources.
• In depth analysis and preparation of data, generating weekly, biweekly and monthly reports using MS Access and SQL.
• Extensive use of SAS functions such as Proc Report, Proc Summary, Proc Print and Data Null Reports.
• Data Analysis, Documentation, and Data Quality Checking.
• Periodically created UML Diagrams to come up with a Data Design, that helped the business run more efficiently.
• Created Multi-set and Set tables in Teradata database.
• Maintained Data consistency and integrity.
• Excellent Analytical and Documentation skills, along with the ability to be a key player in a Team Environment.
• Interacted with end-users and business analysts, identifying and developing business requirements.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects reports.

Confidential,New York,NY

Data Analyst

• Understanding Business requirements, and translating them into System requirements.
• Created Data Models using Conceptual, Logical and Physical approach.
• Performed calculations for expected results.
• Performed Data analysis and generated Datasets for quantitative analysis.
• Created Tables in Teradata Database.
• Wrote complex SQL statements using joins to extract data from the Tables.
• Performed numerous SQL Queries using OLAP Functions, such as RANK, QUALIFY, CUBE, ROLLUP etc…
• Performed in depth analysis of data & prepared weekly, biweekly and monthly reports by using MS Excel, MS Access and SQL.
• Periodically interacted and coordination with end users and team members to identify Business system needs, to evaluate solutions for business problems and come up with alternative methods that will increase efficiency and improve performance.
• Analyzed and documented information system requirements and related outcomes on business processes.

Confidential

Data Analyst

• Developed new reporting solutions and updated existing reports
• Developed simple to moderately complex SQL queries for ad-hoc reports
• Completed user service/maintenance requests
• Maintained user application access control through Azure Active Directory
• Worked in cross-functional collaboration with internal customers to identify opportunities for improvement in business operations and processes
• Provided functional / technical support on current systems in production and new development by ensuring escalated issues are communicated, managed and resolved considering priority and customer impact
• Provided process improvements as requested by researching existing functionality and working with vendors to design functional changes for implementation
• Resolved data issues and updates for multiple applications using SQL queries/scripts
• Assisted in testing proposed vendor solutions
• Created support documentation for common issues in new and existing applications
• Provided periodic user training (for new application users, on application updates, for general issues)
• Assisted in new system implementation and tasks (CRPs, running Go-live meeting calls and noting/resolving issues