SUMMARY:

• 6 years Data Analyst Experience.
• Professional experience in the IT Industry, Data ware Housing and other DW Tools.
• Create complex SQL queries and Scripting for data extraction.
• Created numerous stored procedures, views, triggers
• Used Inner, Outer Join, Union, Intersect, Rank, Dense Rank.
• Created an automated daily ETL (Extract, Transform& Load) process using SSIS
• Create Join Indexes, Primary Partitioned Indexes Added Collect Statistics from better performance.
• Able to communicate effectively with multifunctional teams, programmers and technical staff at all levels. Strong customer service orientation
• Experience in requirements gathering, workflow preparation, and process re - engineering and testing.
• Excellent in data analysis and identifying issues when reports are created from several and complex data source
• Hands on experience and proven practices of resolving performance issues at various (Applications, Database) Levels.
• Participated in requirements analysis reviews and Design sessions to understand the requirements and designing Reporting Solutions.
• Committed team player, with excellent communication skills and self-starter, capable of working independently.
• Good problem-solving skills, initiative and judgment.
• Good business understanding and effective at working across multiple teams within an organization.
• Good background in problem solving and technical concepts.
• Experience to coordinate and interact with internal and external stakeholders in the project like Operation group, Production group, Change Management group, Third party vendors, Management support group, Business Analysts group, IT group, User Acceptance group.
• Excellent documentation skills in MS Office, MS Project and MS Visio and ability to work in multiplatform environments.

TECHNICAL SKILLS:

Platforms: Windows 8, 10, Win XP, Vista,7, Unix

RDBMS: Oracle 10g, SQL SERVER 2008/2012/2014, MySQL

Data Modeling Tools: MS Visio, Erwin, ER Assistance

Querying Tools: SQL Server Management Studio 2008, SQL Plus, SQL Developer

ETL/Business Intelligence tools.: SAS 9.x, Business objects xi3.1, Tableau 9.3,QLIK, Microstrategy, Power BI 10.0, SSAS, SSRS, SSIS

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Data Analyst / BI Analyst

Responsibilities:

• Created and delivered presentations to various business teams regarding the current status and key decisions regarding their business issues.
• Applied technical skills using SAS, Tableau and SQL in data collection, data analysis and reporting to procure data from database structures to report and provide solutions to client requests in a timely manner.
• Designed and performed monthly incentive performance analysis to lead to marketing incentive offer adjustment.
• Supported rapid turnaround for ad-hoc analysis, developed use cases, researched and resolved issues
• Analyzed and compiled an itemized list of components that will migrate or will need to be configured to be eligible for the migration process
• Validated the data from the reports against the database by developing SQL queries.
• Streamlined the reporting process through tuning SQL and SAS script and automated the daily reporting process.
• Defined data requirements and report layouts for the business to review. Created testing plans and scripts based on requirements.
• Create SQL queries to develop different reports.
• Create Partitioned Indexes, Join Indexes and Collect Statistics from better performance.
• Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Analyze and solve business problems at their root, stepping back to understand the broader context

Confidential, Newcastle, Delaware

Data Analyst / Data Architect.

Responsibilities:

• Analyzing and Reporting using different Technique SQL, and other business intelligence tools.
• Wrote SQL queries that were highly tuned using concepts like Explain, CAST and volatile tables.
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets.
• Create SQL queries to develop different reports.
• Create Gap analysis document and performed data quality Check.
• Use and Extract data from existing data stores, execute report by using oracle SQL, SAS.
• Use and create pivot table in Access and Excel by getting data from SQL Server and Oracle.
• Create gap analysis document, performs different types of check.
• Create Mappings and Transformations using Informatica Designer and processing tasks using Workflow Manger to move data from multiple sources in to targets.
• Create Partitioned Indexes, Join Indexes and Collect Statistics from better performance.
• Communicate effectively with different teams, Technical staff and. Strong customer service orientation
• Use and Create different type of tables like volatile, temporary, permanent and derived tables.
• Execute and Develop departmental reports for performance and response purposes by using oracle SQL, SAS, procedures, packages, functions, database triggers.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Develop User Manuals, and Training Manuals as per Project Specifications and timelines. Maintained and improved the GUI interface of the Data Control Department Database in MS Access/SQL for all reports and super users within the company.

Confidential, Newcastle, Delaware

Data Analyst / SQL Developer

Responsibilities:

• Use SQL Assistant and SQL Server management studio to write complex queries and using SQL advance concept.
• Wrote complex SQL queries using advanced SQL concepts like aggregate functions, Group by and OLAP (Online Analytical Functions).
• Wrote queries to fetch data from different table by using JOINs, Sub-queries, Correlated sub-queries and derived tables on SQL server platform.
• Used SAS to import and export data from and into Oracle tables.
• Used Pivot tables to create reports that did dicing and slicing functions on data. This is called dimensional analysis and gives business a 360 view of what is going on.
• Created numerous permanent tables, Volatile tables and Global Temporary tables.
• Created numerous Universes for implementing Web business intelligence for clients.
• Experience in creating metadata.
• Maintained a very close interaction between business users and developers to avoid any gaps in understanding or implementation of requirements.
• Did data analysis, created data mapping and data interface documents and kept the documents updated with changes in requirements and functional specifications.
• Developed Reports and Graphs using suing SQL Server to present the Stress Test results to the management.
• Stepped in when requirements were not moving forward and mentored analysts on documentation, facilitation and agile processes.

Confidential, Newcastle, DE

Data Analyst / Tableau Developer

Responsibilities:

• Wrote SQL queries.
• Create different table in data base.
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
• Performed Data Analysis, created gap analysis document, and performed data quality Checking.
• Created numerous temporary, derived, permanent and volatile tables.
• Created dashboards for analyzing POS data using Tableau
• Consistently attended meetings with the client subject matter experts to acquire functional business requirements.
• Developed case studies to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting.
• Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets
• Created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reports.
• Experience in creating metadata.
• Participated in the logical and physical design sessions, assisted and developed high and low-level design documents.
• Extracted data from existing data stores, Developing and executing departmental reports for performance and response purposes by using oracle SQL, SAS, procedures, packages, functions, database triggers.
• Created pivot tables in Excel by getting data from Teradata and Oracle.
• Maintained data consistency, database integrity and reported instances of data corruption.
• Interacted with end-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects reports.

Portfolio Analyst / Investment Analyst

Confidential

Responsibilities:

• Researched and analyzed potential investment opportunities towards recommendation for high net worth and institutional clients to management.
• Assisted Portfolio Managers with day to day operations of portfolios with strict due diligence and adherence to bank/industry compliance regulations.
• Created risk templates with the team members to enhance the risk framework of the asset management services.
• Engaged in monthly monitoring of 250+ portfolios and detecting potential risk factors which prevented loss of about $1.5million after reporting to the management of findings.
• Evaluated potential trading opportunities, recommended bid prices to management.
• Managed and simplified the reporting process which increased efficiency in risk mitigation and historical Value-at-Risk data.
• Investigated, identified and resolved abnormal daily Value-at-Risk and risk.
• Provided reports to management regarding current market and macro-economic trends.
• Engaged and performed on daily, weekly, monthly reporting that were accurate and timely for the objective of the company
• Performed tasks in improving effectiveness of AML and KYC policies in the company.