PROFESSIONAL SUMMARY

• 8+ years of IT Industry Experience in teh 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 Oracle, 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 and
• 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 teh 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 teh needs of teh users.
• Highly proficient in understanding end user requirements and submitting efficient and quick solutions.
• Solid background in technical and problem solving concepts and has an excellent capability of utilizing academic noledge and previous experience.
• Comprehensive noledge and experience in all phases of teh Software Development Life Cycle (SDLC).
• Strong team building and development skills.
• Ability to meet deadlines, and produce TEMPeffective 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)

WORK EXPERIENCE

Confidential

Data quality Analyst

Responsibilities:

• Prepared Business Logic Document (BLD) to transition manual data quality work to Ab Initio, configuring teh datasets and writing business rules respectively.
• Leveraged Ab initio reporting tool for our data quality reports.
• Involved in creating dashboards and reports inTableauto monitor scorecard defects
• Wrote and configure data quality rules in Ab Initio
• Wrote and develop SQL query for business rules
• Responsible for developing data quality checks on teh Teradata/Oracle Landing Production environment for Master and Reference data, ensuring that teh processes and tasks were executing correctly, so teh Business Owners could certify on teh accuracy of data controls and data quality.
• Leveraged teh FSD and BRD to write business rules for Reference data and monitor rules daily using SQL queries.
• GeneratedTableauDashboards with quick/context/global filters, parameters and calculated fieldsonTableaureports
• Prepared reports to summarize teh daily data quality status and work activities.
• Worked with teh QA team in preparing testing strategies, wrote test scripts and coordinated testing with business line partners.

Confidential - Charlotte NC

Data Analyst

Responsibilities:

• Gathering and analyzing business requirements, conduct gap analysis, set operational specifications, designing.
• 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 teh 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
• Work on SSRS reports and deployment, create or automate Peer Review Templates using Excel VBA
• Generated periodic reports based on teh statistical analysis of teh data from various time frame and division using SQL Server Reporting Services (SSRS)
• Develop reports using complex formulas and to query teh database to generate different types of ad-hoc reports usingSSRS.
• 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
• Developed codes in multiple billing applications using SQL queries/scripts based on teh 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
• Created dashboards and reports inTableau and created report schedules onTableau
• Work with Business Analysts to understand client needs and suggested alternatives for a more TEMPeffective and efficient Business process.
• Interacted with end-users and business analysts, identifying and developing business requirements.

Confidential, Burlington NC

Data Analyst

Responsibilities:

• 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 no 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 SSAS to import and export data from and into SQL Server platform.
• Used UML Diagrams to graphically capture system functionalities.
• Periodically Designed Conceptual, Logical and Physical Models to TEMPeffectively 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 TEMPeffective and efficient Business process.
• Worked side by side with end-users and business analysts to identify and develop business requirements.

Data Architect

Confidential

Responsibilities:

• Created and refreshed monthly Data Marts for various processes.
• Requirements Analysis, identifying teh necessary tables that need to be populated into teh 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 halped teh 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 teh 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

Responsibilities:

• 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 teh 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

Responsibilities:

• 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