SUMMARY

• Years of professional experience as a Data Modeler in Finance/Banking Domain.
• Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
• Experience in theDataAnalysis,DataMining,DataMapping,DataQuality, andDataProfiling.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Experience in various programming languages (SQL, XML) and operating hardware and software applications including TOAD, Crystal Reports, Oracle Discoverer, Query Analyzer and SQL Navigator.
• Experience in using Microsoft BI studio product like SSMS and Microsoft Excel forImplementationof ETL methodology indataextraction, transformation and loading.
• Worked on voluminousdatastarting from inception toimplementationand On - going support, strong understanding of SQL (SSMS).
• Experience with end-to-end AEM/CQ admin responsibilities including author, publisher, dispatcher server installation, configuration andup gradationof servers, performance tuning, scheduling repository backups, weekly maintenance and reports, creating users/groups and maintaining their access controls using LDAP configuration, setting OSGI configurations, configuring replication agents, setting up run modes, creating OSGI bundles and packages.
• Expertise and Vast noledge ofDataWarehousing includingDataModeling,DataIntegration (ETL) and Business Intelligence.
• Experienced with technical skills in SQL to extractdatafrom the database fordataanalysis.
• Sound noledge on working with MySQL, Oracle DB databases.
• Extensive noledge of working in Agile Scrum and SDLC Methodology.
• Create Excel file system, to track vendor time, mileage, hours. Transfer numericdatainto Excel.
• Created visually impactful dashboards in Excel and Tableau fordatareporting by using pivot tables
• Expertise in the ETL (Extract, Transform and Load) ofdatainto adatawarehouse/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Results-oriented Joint Application Development (JAD) Facilitator and meetings coordinator with excellent interpersonal skills.
• Experience as aDataAnalystwith solid understanding ofDataModeling, EvaluatingDataSources and strong understanding of BigDataEcosystem.
• Expert in designing automated reports, dashboards, and optimizing the resource utilization using automation techniques and programming skills.
• Expert inDataModeling,DataAnalysis,DataVisualization and ModernDataWarehouse concepts. Designed Various Reports/dashboards to provide insights anddatavisualization using tools like Tableau, Excel, VBA, Access, SF Analytics, Crystal, and Power BI.
• Excellent Software Development Life Cycle (SDLC) with good working noledge of testing methodologies, disciplines, tasks, resources and scheduling
• Expertise in the ETL (Extract, Transform and Load) ofdatainto adatawarehouse/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Designed and implemented cloud basedQlikViewdevelopment and on-premise QA, Production, and Disaster Recovery systems.
• Analyzed and performedDatavalidation in Excel andQlikViewagainst internal software like Strategic Review Tool, Patent Analysis Database and Sales force before it went into ETL process in MS SQL.
• Strong experience of various BI,ETL, different database,datamodeling,datamining, Object Oriented Programming and real time integration tools.
• PerformingDatatransfers between different homogeneous/heterogeneous systems and SQL Server/Oracle as a part ofDataMigration,DataMaintenance and otherETLtasks.
• Authored and supportedETLprocesses
• Worked as liaison between business anddatamodeler, ETL developer to implement EDW,data mapping,dataVisualization and MasterDataManagement (MDM).

TECHNICAL SKILLS

Programming Languages: C, C++, HTML, XML, SQL, Hadoop, Python, Java, Swift, Ruby, PHP, Javascript

Data Base: MS Access, Oracle (SQL Series), DB2,MySQL, Microsoft Access

Reporting Tools: Crystal Reports 8.0

Operating Systems: MS-DOS, Windows95/98/NT/2000/XP, Confidential McIntosh, Linux, Ubuntu

Software: MS Office Suite (Word, Excel, Access, PowerPoint & Outlook), MS Visio, Rational Rose, Rational Requisite Pro, Adobe Acrobat, MS Office FrontPage, Lotus Notes, Cognos. SSIS, Autosys and Control-M, Notion 6, Forte Home, Espionage 3, ConcealerContentBarrier, Witigo, Net Nanny

Performance Testing Tools: Virtual User Generator, Load Runner, Apache JMeter, NeoLoad, Locust, BlazeMeter, WAPT.

Processes/Technologies: Rational Unified Process (RUP), Waterfall, UML & Microsoft Office SharePoint

Automation Tools: Requisite Pro, Win runner, QTP, Test Director, Quality Center

PROFESSIONAL EXPERIENCE

Confidential, Cupertino, California

Data Analyst

Responsibilities:

• Understanding user intent with their text queries.
• Enhancing Database Design based on new generation requirements from Business.
• Worked on AzureDataFactory based solutions including SQL Azure & Power BI technologies (Migrated OnPrem to SQL Azure & SSIS to ADF).
• Analyze thedatafrom differentdatasources and develop Tableau Reports.
• Designed and developed various analytical reports from multipledatasources by blendingdataon a single Worksheet in Tableau Desktop.
• Worked on functional requirements sessions with business and technology stakeholders ondata modeling, integration, and configuration fordatawarehouse with automated and manual fielddata collection systems.
• Performed reverse engineering on a database to sync Erwindatamodel with database model.
• Administered user, user groups, and scheduled instances ofdatarefresh activity to be consumed by Tableau reports.
• Used extraction, transformation and loading ofdatadirectly from different source systems like flat files, Excel, Oracle and SQL Server.
• Prepared High-level logicaldatamodels and BRDs (business required documents) supporting the documents containing the essential business elements and the description between the entities.
• Worked on generating various dashboards in Tableau Server using differentdatasources such as Teradata, Oracle, and MS Excel.
• Responsible for providing support services for workstation, network and application technologies used by employees.
• Performeddataminingtasks utilizing SAP software and other financial systems.
• Evaluatesdataminingrequest requirements and help develop the queries for the requests.
• StrongDataminingwork and responsible for working with Business Stakeholders and Vice Presidents in order to report weekly sales, issues, timeliness, trends, statistics and all other road blocks that needs to be addressed
• Experienced in Writing PL/SQL ETL routines inDatawarehousing applications Involved in database design andDatamodeling.
• Performeddatamigrationalong withdatavalidation. Transfer and loading ofdata.
• Maintainingdataintegrity as part ofdatamigrationprocess.

Confidential, Dearborn, Michigan

Data Modeler/Data Analyst

Responsibilities:

• me was involved in data cleaning, data manipulation, requirement gathering, generating reports, statistical analysis, and data analysis.
• Performed data validation and data cleaning on clinical data using procedures like PROC SORT, PROC TRANSPOSE, PROC FREQ, PROC REPORT and PROC MEANS.
• Involved in design, program development, logic, testing and implementation phases of SDLC using Agile methodologies
• Use of SQL Server to run queries through the database to collect data and generate automated management reports for departments through SSRS implementation.
• Experience in using Microsoft BI studio product like SSMS and Microsoft Excel for Implementation of ETL methodology in data extraction, transformation and loading.
• Involved in design, program development, logic, testing and implementation phases of SDLC using Agile methodologies
• Use of SQL Server to run queries through the database to collect data and generate automated management reports for departments through SSRS implementation.
• Managed implementation of Document Management System meeting requirement deadlines.
• Worked on up gradation of Eagle STAR
• Worked using SAS Macros and SAS procedures in Banking for credit card report generation and upgradation.
• Actively contributed in SDLC up gradation by facilitating workshops with Tech Business Analyst, Data Designer and Tech Development Team for Governance process and Template update
• Translated business requirements to data mining requirements by using different data analysis tools such as Tableau.
• Maintained requirements in JIRA for tracking and testing purposes.
• Used Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Designed various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), UML diagrams and Systems Design Specification (SDS)
• Performed quality improvement of database schemas leading to up gradation of entire downstream application
• Manipulate, cleansing and processing data using Excel, Access, and SQL.
• Developed SQL Server Database objects including Tables, Views and Indexes.
• Designed framework manager models for ad-hoc analysis and reporting, also resolved loops utilizing shortcuts and Alias shortcuts in Cognos framework manager.
• Resolved double counting of multi granular data between tables using determinants in Cognosframework.
• Applied security features of Cognos like row level, report level, object level security in the framework manager to make the sensitive data secure.
• Worked on reports existing in Micro strategy .Developed some ordinary reports in the micro strategy.
• Worked on reports existing in Micro strategy .Developed some ordinary reports in the micro strategy.

Confidential, Minnetonka,Minnesota

Data Modeler/Data Analyst

Responsibilities:

• Modeldatausing MS Excel, Access, SQL, and/or otherdatawarehouseanalytical tools
• Use SQL, PL/SQL to validate theDatagoing into theDataWareHouse.
• Creating complexdataanalysis queries to troubleshoot issues reported by users.
• Evaluatesdatamining request requirements and help develop the queries for the requests.
• Extract thedatafrom database and providedataanalysis using SQL to the business user based on the requirements. Create pivots and charts in excel sheet to reportdatain the format requested.
• PerformedDataanalysis andDataprofiling using complex SQL on various sources systems including Oracle and Teradata.
• Excellent noledge in the ETL (Extract, Transform and Load) ofdatainto adatawarehouse/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Carried out queries from customerdatabaseusing SQL.
• Interacted with Business Users and executives to identify their needs, gathering requirements and authoring Business Requirement Documents (BRD), Project Charter and Project Approach Documents.
• Facilitated and conducted Joint Application Development (JAD) sessions with Business Clients to identify business rules, Functional and Non-Functional Requirements.
• Written complex SQL queries for queryingdataagainst differentdatabases fordataverification process.
• Using SQL Server Integration Services (SSIS) to buildDataIntegration and Workflow Solutions, Extract, Transform and Load (ETL) solutions forDatabaseapplications.
• Successfully designed and delivered Executive managementQlikViewDashboards spanning 15+datasources.
• Implemented practices and procedures for source controlling and releasingQlikViewdashboards across Development, UAT and Production using Rational Team Concert and Github.
• Developed analytical dashboard inQlikViewand PowerBi to understand the root causes of problems and the drivers for decision making in driving customer acquisition and retention Using the MESdata.
• Developed many Dashboard and Reports usingQlikViewfordataentry management team.
• Working to resolve some of the complex issues related toETLand reporting.
• DevelopedETLmappings as per user's requirement.
• CreatedETLpackages using SSIS import Emaildatafrom CSV files to SQL Server.
• Monitored theMDMenvironment for issues and resolve as needed.
• Collaborated with IT Staff, Systems Analysts, and business subject matter experts, to support theMDMenvironment.
• Acted as a liaison between the business and development team in gathering requirements and supporting theMDMteam.
• Assist in the development and Implement masterdatamanagement (MDM) initiatives for internal Budget Formulation team.
• Working with MDM, TIBCO,Abintioteams and DBA for development and performance troubleshooting.
• MigratedDataand bunch ofAbintioETL applications from one server to another during End Of Server Life project.
• TestedAbintiographs for various ETL functions and transformations.
• Extensively usedAbintioGDE for mockingdatausing continuous flow graphs.
• Defined and codingOraclepackages, procedures and functions.
• The interfaces were developed to be able to connect to multiple databases like SQL server andoracle.
• Defined and codingOraclepackages, procedures and functions.