PROFESSIONAL SUMMARY:

• 5+ years of experience in analyzing, designing and developing client/server, Business Intelligence (BI) database applications, Requirement Elicitation, Data visualization, Analytics, Data Integration and related database Platforms in banking and Real Estate sectors
• Experienced in data analysis with solid understanding of Business Requirements Gathering, Data warehousing, Business Intelligence, Data Mapping and Data Modeling
• Experience in MS - SSRS, SSIS, SSAS, OLTP, OLAP, Slowly Changing Dimensions, Data Cleansing and Data Migration
• Good Knowledge of data warehousing techniques and standards
• Extensively worked on Erwin Data Model Tool and good knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts
• Experience in High Level Design of ETL Packages for integrating data using OLE DB and Flat File connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations
• Proficient in Data migration between homogeneous/heterogeneous systems and SQL Server using Integration Service (SSIS), BULK INSERT, DTS Import/Export utility, and Bulk Copy Program (BCP)
• Experience in Data modeling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs
• Scheduling the SSIS packages and Jobs using BMC Control-M Scheduler
• Specialized in creating several reports such as drill down/drill-through reports, parameterized reports, linked reports, sub reports, Matrix Reports, Charts using SQL Server Reporting Services
• Created email subscriptions for data driven reports by using Report Manager
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services
• Used Report Manager to assign roles, permissions and to create report schedules
• Experience with Ad-Hoc reporting using Report Builder in SSRS for daily reports
• Expertise in designing/creating several reporting services reports that have been formatted specifically for dashboard displays, i.e. with charts, KPIs, tables, etc
• Used Performance Monitor/Profiler to solve dead locks/long running queries
• Worked on analyzing and performance tuning queries by looking at Query Statistics and Execution plans
• Experienced in managing Alerts, Operators and Jobs through BMC Control-M Scheduler
• Experienced in scheduling ETL Packages and .Net application jobs using SQL server Agent
• Experienced in creating DDL objects like Databases, Tables, Views, Relational Keys, constraints, indexes, logins, Linked Servers, Sequences, and Synonyms etc.
• Worked with SSRS Reporting web services in ASP.NET web and Windows forms applications using C#. NET to generate the reports in different rendering formats such as PDF, EXCEL etc.

TECHNICAL SKILLS:

Business Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), MS Visio, MS Project, MS Access, MS Office Suite, PowerPoint, Outlook, Visual Paradigm, Doors, Erwin, Data Modeler 4x, Business Object (Crystal Reports)

Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modelling & Analysis, Business Environment

Methodologies: RUP, OOAD, AGILE, Scrum, Waterfall, UML, Business/Data Modelling

Testing Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, PR Tracker

Operating Systems: Windows XP/95/98/NT/2000, Mac OS X, DOS, UNIX, Linux

Databases: Oracle 8i/9i; SQL Server 7.0 & 2000; Access 2000, MS SQL Server, MySQL, DB2,Tableau

Languages: UML (Use case, activity diagram, sequence diagram, data flow diagram, component diagram), C, C++, HTML, Java, SQL, PL/SQL, ASP.NET, XML, Python, R

PROFESSIONAL EXPERIENCE:

Confidential, Mahwah, NJ

Sr Data Analyst

Responsibilities:

• Envisaged and worked as a System Analyst in deploying Performance Guard application by drafting project deployment.
• Coordinating with the application Owners, in tuning the tool matching the business needs, this in turned helped the ticket resolution time by 40%, network enhancement by 15%
• Designed Dashboards, and created interactive Data Analytics solution using Technology aided tools like Tableau to analyze incoming data in Request Tracker
• Created Performance Metrics using Qualitative Analysis and Benchmark Scorecard evaluating the team performance using MS excel, SQL, MS access and power point, this helped executives gain actionable insights
• Experienced in Cost Benefit analysis to illustrate benefits of engaging a performance Guard project to automate it and built consensus with IT partner’s to provided necessary automated downloads from the server
• Worked on building queries to retrieve data into Tableau from SQL Server 2008 and Oracle SQL Developer, and developed T-SQL statement for loading data into Target Database
• Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management at the client as part of the BRD
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server
• Wrote Teradata Macros and used various Teradata analytic functions.
• Good knowledge on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ.
• Implemented MDM hub match and merge rules batch groups
• Participated in refinement and technical documentation of database reporting requirements
• Creating Business Requirements specification using MS Visio, participating in Daily Scrum meetings and documenting the progress of the Project
• Created Performance Metrics using Quantitative Analyst and Benchmark Scorecard evaluating the team performance using MS Excel, SQL, Access and power point, which helped executives gain actionable insights

Environment: Windows /XP, Microsoft Office SharePoint 2007, Rational Requisite Pro, MS Office, XML, SOA, SQL Server, Agile, MS Project, MS FrontPage, MS Access, MS Visio, MS Excel, MS word, EDI, Facets, Tableau, T-SQL, MDM hub, Teradata

Confidential

Data Analyst

Responsibilities:

• Gathered requirements from Business Analysts and Operational Analysts and identifying the data sources required for the requests
• Coordinated with several managers for Financial Data within the Financial Departments.
• Performed numerous data pulling requests using SQL for analysis
• Used Joins like Inner Join, Outer join while creating tables from multiple tables
• Actively participated in JAD sessions to review and document business processes and to produce high-quality deliverables
• Created & maintained data mapping templates, Meta data information, tracked the data lineage at various hops to ensure better data quality across various systems
• Facilitated and resolved outstanding issues with business and technical team
• Created flow diagrams for easier understanding of the data flow between various systems, for the team to reference it
• Commented the existing code for future references to make sure the new associates could understand why we are implementing the logic
• Took ownership of the modules to deliver high quality deliverables
• Wrote SQL queries to perform data quality checks, to know the domain of values and to determine reasonableness conditions for the fields that were getting mapped
• Performed data analysis & validation by writing complex queries using SQL Server Management Studio
• Performed research on data using pivot tables in excels
• Utilized bulk copy program (BCP) commands to perform bulk data loads into database tables from external data files
• Conducted post deployment analysis on production server for new code changes
• Worked closely with various related groups to resolve the issues preventing alignment on milestones, resources and deliverables

Environment: Facets, Windows XP Professional, Oracle, XML, SOA, MS Access, MS Excel, MS Visio, JAD, BCP, MS project, RUP, Oracle, UML, SQL, Rational Rose, Requisite Pro, Clear Case, Rational Clear Quest, MS Office suite, MS Visio