OBJECTIVE:

• Nearly 6 years of IT experience in the field of Business & Data analysis, ETL Development, ETL Testing and Data Modeling.
• Strong experience in Business and Data Analysis, Data Profiling, Data Mining, Data Migration, Data Integration, Data architecture and Metadata Management Services and Configuration Management.
• Excellent skills in MS Office, MS Word, MS Excel and MS Visio
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams with all related entities and relationship with each entity based on the rules provided by the business manager using ERWIN.
• Worked extensively in forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes. Published Data model to acrobat PDF files, extensively created ERWIN reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, coordinated with DBAs to apply the data model changes.
• Extensive experience in development of T - SQL, DTS, OLAP, PL/SQL, Stored Procedures, Triggers, Functions, Packages, performance tuning and optimization for business logic implementation.
• Experienced using query tools like SQL Developer, PLSQL Developer, and Teradata SQL Assistant and extensively worked with Teradata utilities BTEQ, Fast Load, Multiload, Fast Export, TPump, TPT and to export and load data to/from different source systems including flat files.
• Extensive Experience on Creating Visualization Dashboards using Tableau and Alteryx.
• Very large database optimization and performance tuning to address data latency requirements utilizing performance analysis, execution plans, Bitmap Indexing, Partitioning, Materialized Views, Parallel Queries, Merge and Pipelines.
• Enterprise wide applications security and compliance, corporate standards and best practices.
• Collaboration software (SharePoint)

TECHNICAL SKILLS

• Data Analysis
• Data Analyst
• Data Mapping
• Data Migration
• Data Retreival
• Data Retrieval
• Database Modeling
• Data Model
• Data Modeling
• Data Models
• Database Design
• DDL
• EPM
• Mapping
• Microsoft Access
• MS SQL Server
• SQL Server
• Oracle
• PL/SQL
• SQL
• SQL Queries
• Stored Procedures
• Sybase
• Apache Hadoop HDFS
• HDFS
• Apache Hadoop Oozie
• Oozie
• Apache Hadoop Sqoop
• Sqoop
• Content Management System
• CMS
• Data Architecture
• Data Cleansing
• Data Governance
• Data Integration
• Data Management
• Data Mining
• Data Profiling
• Data Sources
• Data Visualization
• Electronic Health Records
• EHR
• ETL
• Flume
• Hadoop
• HANA
• Hbase
• Informatica
• Metadata
• Microsoft SQL Server Analysis Services
• SQL Server Analysis Services
• Mongodb
• Online Analytical Processing
• OLAP
• Operational Data Store
• Power Bi
• Snowflake Schema
• Teradata
• Algorithm
• Analysis Services
• Coding
• Hive
• HTML
• Software Development
• Visio
• XML
• Cognos
• Microsoft Project
• Microsoft SharePoint
• Microsoft SQL Server Reporting Services
• SQL Server Reporting Services
• Microsoft SSRS
• SSRS
• SAS
• Tableau
• T-SQL
• SDLC
• Data Quality
• Data Validation
• JIRA
• Rally
• Unit Testing
• Project Manager
• SCRUM
• Team Lead
• Data Warehouse
• Powercenter
• Juniper
• Qualys
• Java
• Amazon Web Services
• AWS
• Pivot Tables
• Deployment
• SAP
• Shell Scripting
• Unix Shell
• SOPS
• Acrobat
• Microsoft Office
• MS Word
• Word
• MS Visio
• Documentation
• Technical Specifications
• Publishing
• Translating
• Writing Test
• CBT
• TOPO
• Reverse Engineering
• Serial Attached Scsi
• Optimization
• BI
• Marketing Analysis
• Ecosystem
• Segmentation
• Marketing
• ROI
• Marketing Mix
• Market Segmentation
• Digital Marketing
• Digital Campaign
• Audience Segmentation
• Credit Card
• Retail Sales
• Healthcare

PROFESSIONAL EXPERIENCE

Confidential

Business Data Analyst

Responsibilities:

• Working in Agile Environment; attending daily scrum meeting.
• Actively involved in creating business requirements, analysis and design of ETL and Report Development Process.
• Creating several SDLC documents
• Experienced in formatting, editing using MS word, Excel and Power point
• Work extensively with various database to create customized reports utilizing Excels MS Query, VLOOKUP, Pivot table, Microsoft access and crystal reporting.
• Experienced in developing Web Services with Python programming language.
• Experienced in developing web-based applications using Python.
• Experience object oriented programming (OOP) concepts using Python
• Involved advanced report design and development in SSRS
• Created user stories in Rally, JIRA and Confluence.
• Performed Process mapping using Lean/Six Sigma methodologies.
• Used Toad for Oracle for database connection and writing queries
• Used KPI measure to evaluate the performance of organizations business objectives and also tried to track the performances using KPI key indicators.
• Created several queries to insert, update and delete the data from the database.
• Having Data Governance skills, interacting with internal and external stakeholders
• Having analytical abilities in order to examine infrastructures and make recommendations on improvements
• Developed ETL packages to aggregate the data from existing data warehouse and reporting.
• I have worked with meta data and having operational knowledge of using integrated library system and metadata management software.
• Developing, implementing and evaluating metadata and cataloguing workflows and standards
• Support the Material Master team during peak times with workflow management and data entry of Material Data.
• Understands its end-to-end functioning, as well as the interactions and dependencies with master data and other processes.
• Support the data security management program across Confidential through realization of Confidential 's Data Management Policies and Standards
• Creating reports for executives to show quality and quantitative trends to define key metrics
• Involved in creating and testing of ETL packages with different scenarios.
• Supported SQL, Tableau and coding and modification Efforts for CBT Risk and Regulatory Dashboard.
• Created Tableau Dashboards with views.
• Worked on Reports like JAVA, Middleware, OS Security Pathing, Privileged Access, Qualys Vulnerability Management (QVR), Technology Asset Management (TAM), Preventative Action.
• Worked on I Tracker.
• Created, Maintained and optimized a simplified reporting view for all the MW, QVR, OS, JATS Reports across CBT.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Create monthly excel reports into Tableau Workbooks and Dashboards.

Confidential

Business /Data Analyst

Responsibilities:

• Participated in Requirement Gathering, Business Analysis, User meetings, discussing the issues to be resolved and translating user inputs into ETL design documents
• Having hands on experience on SAS and Report Design
• Processed the spend and goals data in Alteryx in such a way that it is suitable for reporting
• SAS Data Analysts analysing client business needs, managing large data sets, storing and extracting information, updating SAS programs, and ensuring database security
• Experienced with MS Excel to filter the data validation and also used MS Visio as well.
• Experienced with employee management systems.
• Extensive experience using data cleansing techniques, Excel pivot tables, formulas, and charts.
• Strong communication and customer service skills.
• Strong end-user computing skills (Excel, SharePoint, Power Point, Word).
• Experienced with NextGen EHR and report development.
• Provide support for NextGen EHR, ability to perform break-fix,
• Responsible for resolving NextGen tickets and projects while providing high quality customer service, properly documenting and timely communication of ticket/project status '/needs and collaborating with numbers.
• Understanding of Python best Practices.
• Experienced in developing Web Services with Python programming language.
• Used KPI to support strategic outcome -an increase in net new revenue and helped clearly outline an outcome of the company.
• Worked on the Data Warehouse team analysing data files that had to be compiled from disparate non-production sources and readied them for production.
• Tasks included comparing data to requirements documentation, creation of data layouts, data dictionary, and the pipe delimited and fixed width files.
• In addition, was team lead for managing the completion and loading of these files for the Data Management group
• Developed Lording Scripts for Teradata database using Fast Load Utility
• Having experienced with process visualization software
• Participated as member of a project team performing various lifecycle tasks for an intranet application with Oracle database for tracking public offering orders.
• Developed logical and physical database models and data dictionary documentation.
• Worked as liaison between users and developers refining and explaining user requirements.
• Worked with Teradata utilities Fast Load to develop loading scripts to mock the Data
• Assess data quality requirements in terms of data completeness, consistency, conformity, accuracy, referential integrity, duplication and evaluate vendors (Informatica Data Explorer/Data Quality, identify and measure data quality, design and implement data profiling and data quality improvement solution to analyse, match, cleanse, and consolidate data before loading into data warehouse.
• Develop data quality reports/dashboards with Cognos Framework Manager and Report Studio

Confidential

Data Analyst

Responsibilities:

• Involved in the analysis, design, and development and testing phases of Software Development Life Cycle (SDLC).
• Gathered the requirements from the data analysts and architects and performed technical analysis to reach a viable solution.
• Used Pivot table to help the user to expand, isolate, sum, and group the particular data in real time.
• Receives escalated tickets; resolves or escalates tickets based on Member, Member need and application issues; communicates NextGen updates that need completed to resolve Member issues with other internal resources as needed.
• Skilled in working SSRS and Report design.
• Develops NextGen template customizations and System/Practice template configuration.
• Troubleshoot NextGen EPM/EHR issues with templates, stored procedures, and documents
• Interacted with the development team to create, interpret and implement business requiremen ts into technical specifications.
• Adhoc data cleansing and standardization using Alteryx
• Created SQL queries using Toad for data analysis and ad-hoc reporting.
• Worked with the business users, system analysts and development team to find the bottlenec k issues and fix them.
• Effectively communicated and accurately managed technical expectations.
• Streamlined development and implementation life cycles.
• Created and managed primary data base objects such as Tables, Views, Indexes Sequences and Synonyms.
• Built complex queries using SQL and wrote stored procedures &packages using PL/SQL.
• Wrote PL/SQL Stored Procedures, Functions, and Packages to implement Business Rules.
• Developed PL/SQL ETL scripts to transfer data across the schemas and databases.
• Unit testing on PL/SQL Packages and procedure, functions according to business requirement.
• Managed and resolved design issues during deployment.
• Involved in tuning and optimization of SQL statements.
• Involved in writing test scripts, unit testing, system testing and documentation.
• Documented every phase like Technical specifications, source to target mappings, data and release notes.
• Involved in Creating Tableau reports.
• Worked with production support team in resolving production issues.
• Assisted in testing and deployment of the application.

Confidential

Data Analyst

Responsibilities:

• Developed Stored Procedures, Views, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.
• Developed SSIS packages to load the staging tables, data marts, and to run jobs.
• Data sources include flat files, spreadsheet, Access, and other third-party sources.
• Created derived columns from the present columns for the given requirements.
• Used Text Files/ SQL Server Logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Identified long running stored procedures using Execution Plan and optimized queries for more effective data retrieval.
• Deployed and supported SSIS packages to production server, and jobs were scheduled run the packages.
• Analyzes data by defining quality requirements, making recommendations for changes on the source system, working with users to correct historical data and by applying standard data cleansing in integration services flows using SQL Server
• Involved in performing partitions on the SQL table, and performance tuning such as building indexes, dynamic cube creation.
• Developing and Extending SSAS Cubes, Partitioning, Data Mining Models, Deploying and Processing SSAS objects, writing Confidential queries.
• Helped business users to reconcile reports generated from Data Warehouse with reports from legacy systems, and validate the data before and after the migration/integration
• Created Drill-through, Drill-down, Cross Tab Reports, Sub-Report and periodic reports based on the statistical analysis of the data using SQL Server Reporting Services, deploy them onto SharePoint.

Confidential

Business System Analyst

Responsibilities:

• Extensively worked on various database impacts on CMS application once the impacted changes are known in project requirements review.
• Extensively worked with Model maintenance project where all the Data models which are not to up to standards making them standardized
• Advanced knowledge of SSRS Report Serverplatform (version 2012+) and Experienced in Report design and development in SSRS.
• Writing implementation plans in order to implement the database changes into QA and Production environment
• Coordinating with DBA in implementing the Database changes and also updating Data Models with changes implemented in development QA and Production
• Created Data dictionary using ERWIN modeler.
• Involved in Low level Design for the scripts of the database sequences, constraints, triggers and stored procedures.
• Knowledge of Merging several flat files into one XML file.
• Extensively worked on creating, Altering and Deleting the Tables in different Development Environments and also Production.
• Extensively involved in various data modelling tasks including forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas, data dictionary, publishing model to PDF and HTML format, generating various data modelling reports etc.
• Extensively worked with logical models to change them into complete physical models from where we can implement these models into database.
• Designed a Conceptual Data Model, Logical Data Model, and Physical Data Model using Erwin.
• Extensively worked with developers on analysing the impacted changes on respective applications based on which design approach is taken and also same charges are implemented in database with help of DBA.
• Created physical models for the applications which don't have any physical models from logical models

Confidential

Data Analyst

Responsibilities:

• Worked with Python developers to extract, clean and ready data for importing into BI tools
• Generated data visualization reports for Sr. management with Tableau
• Prepared bi-weekly market segmentation report with separate Leads Lists
• Designed customer surveys to test marketing hypothesis and identify venues with the best ROI
• Analysed survey results to prove or disprove data correlations hypothesis
• Segmented potential customers based on the "credit card utilization" algorithm
• Developed marketing reports to align potential clients with best-fit financial product
• Automated reports and dashboards by combining SQL, Tableau, and BI applications
• Fulfilled ad-hoc requests for the marketing team and other stakeholders
• Utilized statistical techniques to assess channel efficiency
• Recommended optimal marketing mix by channel and by product based on analytical data
• Determined sequence of customer touchpoints across channels including path to conversion
• Provided segmentation and personalized recommendations for digital marketing channels