SUMMARY

• Proactive, results - driven professional with a solid track record of providing support to maintain and expand new or existing data collections and delivery platforms to optimize data quality management.
• Expert in acquiring data from different sources and developing data systems to support analysis and reports. Proficient in technical software, languages, and tools as well as learning new strategies quickly.
• Frequently praised as hard-working by my peers. Strong analytical, troubleshooting, and decision-making skills; a self-starter; and good team player.
• Ability to complete tasks on time in both individual & team settings. Willing to take on challenges and adapt to new situations.
• Having 9+ years of professional IT experience as a Database Admin / Analyst / Developer and Business System Analyst in banking, financial, insurance, and corporate and retail companies.
• Expertise in Database Design and Programming using SQL Server Management Studio, writing queries, designing tables, views, indexing, and defining relationships between tables, and developing Stored Procedures, Functions, and Triggers to use for the implementation of data integrity. Experience in schedulingJobs and Alerts throughSQL Server Agent.
• Experience in ETL (Extraction, Transformation, and Loading) using SQL Server Integration Services (SSIS).
• Skilled in developingSQL Server Analysis Services (SSAS)cubes, dimensions, facts, and data source views.
• Performing significant data analysis and developing and designing reports using BI tools like SQL Server Reporting Services (SSRS), Power BI, and Tableau.
• Expert knowledge of MS Access Databases, Visual Basic, and Crystal Report.
• Extensive experience in Excel including creating Pivot tables, Macro, functions & formulas. Good at creating summary reports with a graphical representation of data.
• Strong visual modeling and business process modeling skills with tools like MS Visio.
• Good knowledge of frontend and backend of administrative support for Business Management CRM & ERP Software System’s like Salesforce, Soaring, Compass Sherpa, OMD, and E-Automate.
• Hands-on experience with Salesforce Query language SOQL. Skilled in creating functional dashboards and reports in Salesforce.
• Experience in developing Business requirement documents (BRD), Functional Requirement Specification (FRS), Software Requirement Specification (SRS), and Use Case Specification. Expert in creating PowerPoint presentations.
• Experience in the different phases of SDLC including Waterfall and Agile.
• Maintained a 99.5 % quality level for over a year by demonstrating expertise in SQL data analytics.

TECHNICAL SKILLS

• Microsoft SQL Server
• SQL Server Reporting Services
• SQL Server Integration Services
• SQL Server AnalysisServices
• Microsoft Visual Studio
• MS Access Database
• Microsoft Share Point
• Tortoise SVN
• Business Intelligence Tools
• WorkBench (SOQL Query)
• DataLoader
• ServiceNow
• Visual Studio
• Advance Excel
• Word
• PowerPoint
• Visio
• Office 365
• Crystal Reports
• Tableau
• Power BI
• Google Sheets
• Office Converter
• Monarch
• Salesforce
• Compass Sherpa
• Soaring
• Sales Chain
• OMD
• E-Automate
• Visual Basic
• HTML
• JavaScrpit
• CSS
• .Net Framework
• Data Modeling
• Data Mining
• Data Visualization
• Data Quality

PROFESSIONAL EXPERIENCE

Confidential, Mt Laurel, NJ

Senior Database Analyst

Responsibilities:

• Designed databases, stored procedures, dashboards, reports, writing queries and creating views, functions, triggers, indexes, and data input interfaces using SQL Server Management Studio to better accommodate user needs, provide accurate information and validation, and maintain streamlined processes, gaining a 99% satisfaction rate from all end user.
• Performed accurate and thorough analysis of mining data from the SQL database that is used as a backend for the CRM & ERP systems, presenting results using SQL, ETL tools (SSIS), MS Access, Excel, and Visual Basic scripts, obtaining positive feedback of 95% during the presentation and analysis.
• Played pivotal role in gathering project requirements through research, formal-informal sessions, and JAD sessions with end users and stakeholders. Prepared Business Requirements Document (BRD), and Functional Requirements Document (FRD), and providing gap and data analysis for business process improvement.
• Making sound decisions related to data collection, analysis, security, methodologies and designs.
• Worked directly with the senior managers to provide the analysis of all the department benchmarks and to ensure its data and reporting needs are met.
• Actively participated in the development of Business Intelligence (BI) reports and dashboards using Power BI, Tableau & SQL Query to provide meaningful intelligence to support, planning, & decision making reports.
• Worked on Salesforce lighting platform objects like Accounts, Contact, Cases, and Leads, Opportunities, Camping, Reports and Dashboards. Managed Salesforce requests/issues for company total end users. Trained over 200+ users on Salesforce.
• Reduce 20% SLA response time for issues & change request ticket through ServiceNow.
• Used Workbench & Data Loader for insert, updating bulk imports or exportation of data from salesforce object.
• Actively involved in 3 data migration & 5 database merge projects and was the key point of contact for migration and support issues.

Confidential, Mt Laurel, NJ

Database Analyst

Responsibilities:

• Imported, exported, and manipulated large data sets in multi-million-row databases under tight deadlines, successfully resulting in the 100% delivery of all projects within the given timeframe and completing all goals/objectives while maintaining data integrity.
• Gather data necessary to accomplish analysis from several sources, researching specified problems, using data analysis to solve problems, and arrange analysis reports as well as be available to answer any queries, complaints, or proposals about risks, opportunities, recommendations, etc.
• Generated a Dashboard with KPIs (Key Performance Indicators) based on the statistical analysis of data from various time frames and divisions using SQL Server Reporting Services (SSRS). This includes not only getting the correct data, but also aggregating, integrating, and presenting it in a manner that is clear and decisive and setting up data-driven email subscriptions.
• Actively involved in SQL development and writing complex SQL queries, pulling data from Enterprise Teradata (National Data warehouse) and then using ETL tools (SSIS) to import data into internal DataMart by creating packages and automating and scheduling them for a fixed, timely delivery.
• Enhanced MS-Access databases by improving the user interface, introducing multiple-user access, and increasing security and stability.
• Frequently used Advanced Microsoft Excel (Data Connections, Pivots, Lookups, Slicers, VBA macros, etc.) for various tasks and automating several business processes.
• Modified old and created new reports and sub-reports using Crystal Report.
• Managed multiple CRM and ERP Systems like Soaring, Sherpa, Sales Chain, OMD and E-Automation.
• Provide help to solve Zen desk tickets related to Dashboard, Soaring, Sherpa, OMD and E-Automation.

Confidential, Mt. Laurel, NJ

Business System Analyst

Responsibilities:

• Played a major role as a part of the EDGE Deployment team and was responsible for planning, converting, testing and deployment in Office 2010 environment, used Convertor tool for analysis & conversion of EUCs
• Performed compatibility testing and resolving any post-migration issues like VBA macros, Link table on Access database and Excel.
• Performed Data mapping between source systems and target systems, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Responsible for all LOBs for BackOffice and programs for end-to-end Smoke Testing & Application Remediation including communication with LOB’s contact people for detailed requirements, generating smoke testing scripts, updating the trackers, Pivot tables, etc. Utilized Tortoise SVN for Change Management of all developmental (code and non-code) artifacts.
• Developed some custom tools through .net applications to support EUC Conversion features that were not supported by the third-party tool “Office Converter” (File Scanner, EUC Remediation, Link Table Picker, File name Modifier, File Cleaner, File Compare, etc.)
• Used Monarch as a data extraction tool to extract semi-structured data from pdf & text files.
• Gathering information like machine details & managed/unmanaged types, communicating the rollout & handling issues during the IE8 rollout that was completed for the bank.