SUMMARY: -

• As aData Analyst having over 8 years of IT Experience in System Design, Development and Support of MicrosoftSQLServer in Analysis, Development, Test and Production Environments.
• Strong knowledge and understanding ofDatawarehousing concepts: Star Schema, Snowflake Schema, Fact and Dimension Tables and good knowledge of Dimensional Modelling and Normalization approaches.
• Good knowledge in writing complex queries in SQL, coding in Python, R and Java.
• Proficient in including architecture, wif different RDBMS platforms like Oracle, SQL Server and operating MSSQLServer suite of products like SSIS, SSRS and SSAS.
• Extensive experience working wif enterpriseleveldatawarehouses, writing advancedSQLqueries including OLAP functionality using both OVER CLAUSE (PARTITION BY and ORDER BY) and OLAP functions to perform Ad-Hoc analysis and reporting.
• Extensive experience in creating UI visualizations wifTableauDesktop,TableauServer andTableau Readerin various versions ofTableau9.x/8.x/7.x/6.x
• InterviewedSMEsandStakeholdersto get a better understanding of client business processes and authored Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Extensive experience in Business Intelligence in MSSQLServer Integration Services, MSSQL Server Reporting Services, and MSSQLServer Analysis Services.
• Expertise in dealing wif Sybase OEM on product related issues and licensing needs as well as research on other products satisfying organisational needs.
• Experienced in working in all stages of System Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, Testing and Implementation.
• Excellent knowledge in developing web-based applications using Python Django, PHP, XML, CSS, HTML, Java Script and jQuery.
• Hands on experience in Logical and Physical Database design & development, Normalization andDatamodelling.
• Proficient in using T-SQLfor developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models andDataIntegrity,SQLjoins and Query Writing.
• Proficient in working wif SSIS packages, creating jobs and linked servers for MSSQLServer databases and Created, Configured and tuned MSSQLServer Integration Services (SSIS).
• Expert in creating Jobs, Alerts,SQLMail Agent, and scheduled SSIS Packages and created and deployed SSRS Reports on teh portal for user accessibility.
• Hands on experience in writing MDX queries to work wif cubedata and Proficient in using tools like MSSQLProfiler, Database Engine Tuning\ Advisor, Windows performance for monitoring and tuningSQLServer performance.
• Efficient in up gradation and migration from MSSQLServer 2005 to MSSQLServer 2012 and expert in designing Enterprise reports usingSQLServer Reporting Services (SSRS) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS.
• Working knowledge in developing reports like Tabular Reports, Matrix Report, Charts, Custom Reports, Drill-Down, Parameterized and for teh end user requirement Ad Hoc Reports usingSQL Server Reporting Services (SSRS) in Business Intelligent Development Studio (BIDS).

TECHNICAL SKILLS:

AnalyticalTools: Tableau(Desktop/Server/Public/Online/Reader)9.x/8.x/7.x,Adobe Analytics,SSRS,Business Objects

ETL Tools: Alteryx,DataStage,MicroStrategy, SSIS

Databases: Oracle 11i/10g/9i, DB2 UDB, MS-SQL Server, Sybase

Requirements Management: Requisite Pro, Microsoft Office (Word,PowerPointExcel)

Front End Tools: Microsoft Project, Microsoft Office, VisibleAnalyst,Lotus Notes

Document Management: Documentum, Visual Source Safe 6.0, Share point, Ultra Edit

Defect Management tool: HP Quality Center

Methodologies: DataModeling - Kimball/Inmon,Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP,Waterfall,Agile.

DataModeling Tools: Power Designer, Erwin, ER Studio, MS Visio

Languages: SQL, SQL server 2008, PL/SQL and Java

Operating System: Windows NT/2000, UNIX (HP UX, AIX), AS/400, OS/390.

Web Applications: HTML, Perl, XML and JavaScript

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. DataAnalyst

Responsibilities:

• Gatheird and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Involved in gathering user requirements along wif Business Analyst.
• Involved in meetings wif SME (subject matter experts) for analyzing teh multiple sources.
• DDL scripts were created for teh database and modifications were reviewed.
• Teh Analysis of coding and decoding (reference data) is performed for utilizing in other projects.
• Worked wif lead Data Architect to gather information and requirements for teh data warehouse and business users.
• For teh perfect data warehouse, teh requirements and teh design data model were reviewed.
• Requirements from teh project stakeholders will be analyzed in detail.
• Developed a Conceptual model using MS Visio based on requirements analysis for Home, Auto, Boat, and PCL.
• Logical and physical database models were developed for teh OLTP system design.
• Develop teh dimensional model using teh required dimensions tables and fact tables.
• Developed models and Design reviews were validated through Data Administrators, Business Analysts and Developers.
• Reverse Engineering is used to represent teh script in a graphical form using teh tool Erwin.
• Metadata is maintained by teh developer, which provides teh data about other data.
• Teh referential integrity is enforced in teh OLTP data model and teh relationship between teh tables and efficient database design is consistent.
• Responsible for data modeling of several new and modified systems including OLTP, data feeder systems, and data warehouses. Used Erwin and Quest data modeling tools.
• SQL scripts were developed and triggers, cursors are written.
• Data Validation in done to check whether teh data is correct and clean.
• Teh reports will be generated by tracking, compiling and extracting teh data.
• SQL Query performance tuning is used to identify tables and understanding teh performance of teh database tables.
• Mapping of business requirements to Business Data Model and understanding of system analyst in Canonical Mapping.
• Used Model Mart of Erwin for efficient model management of sharing, dividing and reusing model information and reusing and productivity improvement.
• SQL Server Reporting Service is used to handle reporting of Designed Hierarchy dimensions.
• Designed Blood schema model using Erwin and deployed into an Oracle development environment. Developed SQL stored procedures and functions to support access to teh Oracle database from teh web application.
• Business and technical metadata information is collected and consistency is maintained in applying naming standards.
• Developed Source to Target Data Mapping, Data Profiling, Transformation and Cleansing rules for OLTP and OLAP.

Environment: Erwin r7.3/r8/r9.3, MS Excel, MS Word, Agile, Rapid SQL, MS Visio, Sql server, Oracle 10g, DB2

Confidential, St. Cloud, MN

Data Analyst

Responsibilities:

• Interacted wif End user community to understand teh business requirements and analysed them and designed specification document.
• Done designing teh packages and data mapping using Data Profiling Task, Control Flow Task, Sequence Container Task, Dataflow Task, Execute SQL Task, Data Conversion Task
• Performed Data mapping between source systems to Target systems, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Gatheird Requirements and performed Business Analysis and documented all thedataafter pulling thedatafrom database such as CORPSCAN server, used different sites such asSharePoint and discovery sites into excel sheets.
• Hands-on experience in analyzing thedataand writing Custom MySQL queries for better performance, joining teh tables and selecting teh requireddatato run teh reports.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableau Server.
• Restricteddatafor Users using row level security and user filters.
• DevelopedTableauworkbooks from multipledatasources usingdatablending.
• Produced Crosstabs to display underlyingdatabased on various graphs and charts created for furtherdata analysis.
• Responsible for creating dashboards using bars, stacked bars, pie charts, scattered plots, line charts, Gantt charts, and maps.
• Organized in a relational database using mysql and supervised data entry and verified through MySQL queries.
• Utilized technology such as MySQL and Excel PowerPivot to query test data, and customize end-user requests.
• Created guided navigation links for Interactive dashboards inTableau.
• Built a regression model in R dat predicts received signal level of antenna.
• Improved network monitoring by using advanced R graphing libraries to visualizeperformance wif features of weather indicator, color scale of bit-error-rate, an timeframe.
• Developed performance projection tool based on statistical analysis of historic and opportunity data using SQL and R.
• Involved in Custom Coding; By assigning geographic roles to fields not recognized bytableau.
• UsedDataBlending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyzedatain different perspectives.
• Created Actions in Worksheets and Dashboards for interactivity and to comparedataagainst different views.
• Used advanced Excel functions to generate spreadsheets and pivot tables.
• Designed documentation and its delivery management and provided weekly and monthly project status report, resource time sheet for teh senior management and client.
• Managed and tracked project issues and debugged them if needed and developedSQLqueries inSQLServer management studio, Toad and generated complex reports for teh end users.

Environment:TableauDesktop,TableauServer, MySQL, PL/SQL,R, SharePoint,Microsoft SQL Server, MS Visio, Microsoft Office Suite (Word, Excel,PowerPoint), Pivot tables.

Confidential - Denver, CO

Data Analyst/ Data Modeler

Responsibilities:

• Worked wif basic database models conceptual, logical and physical models using Erwin according to requirements.
• All teh existing and created requirements were communicated wif teh business groups for teh analysis.
• Actively developed database design, database models and implement star schema in teh dimensional data warehouse using teh Erwin tool
• Various sources provide teh facility to generate teh data and design conceptual, logical database models.
• Metadata and Data Dictionary are developed and maintained for teh business purpose.
• Gather teh requirements from a complex set of stakeholders and merge them in PMI.
• Experienced wif requirements, designs, and project management.
• Different kinds of testing were performed and teh timelines were identified, risk involvement is estimated.
• Test phases are performed one by one and ensure data analysis, data requirements are met before start.
• Data profiling is performed to check teh data availability in teh database and source to target mapping in teh database is done by mapping transformation.
• Removing of redundancy is done by using teh normalizations forms and snow flake schema.
• Complex data transformation is explained by ETL SSIS developers.
• Data modeling includes creating index, views and join super and sub types.
• Entities, attributes, and their relationships which are created and documented for data models.

Environment: MS Excel, MS Word, MS Access, Oracle, Quality Center, SQL, ERwin, Hadoop, SQL server.

Confidential

SQL BI Developer

Responsibilities:

• Gatheird system requirements through end-user collaboration through JRD and JAD meetings.
• Implemented indexes on tables and views for optimum performance.
• Designed CTEs for code management in complex stored procedures and to query hierarchal data structures.
• Wrote custom TSQLstored procedures and triggers to improve performance and maintain referential integrity.
• Optimized queries wif modifications in TSQL code, removed unnecessary columns, and eliminated data discrepancies.
• Normalized tables, established joins, and created indexes wherever necessary utilizing profiler and execution plans.
• Utilized dimensional data modeling techniques and story boarding ETL processes.
• Created SSIS packages for loading teh data from various sources.
• Collaborated wif cross functional team environments wif team foundation server and VSS.

Environment:SQL Server 2008/05, SSIS, SSAS, SSRS, SSMS, T-SQL, Windows Server, SQL Profiler, DTA, TFS