SUMMARY:

• Over 9 years of experience as Business Data Analyst working in agile development with audit data and data security, Data Warehouse systems and Process Improvement.
• Work on Business Intelligence tools like Tableau for developing different dashboards for the better understanding of the reports.
• Experience in Tableau report developing, testing and deploying reporting solutions using Tableau Server.
• Experience with Data Analysis and data profiling using complex SQL on various sources systems including Oracle 10g/11g and Teradata, in order to ensure accuracy of the data between the warehouse and source systems.
• Use Python and R for machine learning algorithms for data mining. Cluster analysis, hidden Markov models, and time series analysis.
• Expert in Data Analysis, Data Validation, Data Cleansing, Data Verification and Data Migration
• Involved in python supervised deep learning programs and passionate about learning unsupervised deep learning.
• Experience with technical skills in SQL to extract data from the database for data analysis.
• Sound knowledge on working with MySQL, Oracle DB databases.
• Have knowledge to create highly interactive Data visualization Reports and Dashboards etc.
• Create analysis documents to track all feedback and inputs from SME reviews of Source to Target mapping of scoped elements.
• Highly skill in Tableau Desktop for data visualization, using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, Heat Map and Density Chart.
• Organize many Joint Application developments (JAD) and Joint Requirement Planning sessions (JRP), Interviews, workshops and requirement Elicitation sessions, Rapid Application Development (RAD) sessions and JAM session with end - user/clients/stake holders and the development group.
• Perform analytics generated Reports, Published dashboards with data Visualization.
• Excellent Experience in Rational Unified Processing (RUP), Unified Modeling Language (UML), Capability Maturity Model (CMM) and Use Case Specification Documents (USD).
• Work on conversion of Business Intelligence reports from Business Objects, Excel in to Tableau and Power BI visualization.
• Use Agile tools Jira for all phases such as product backlog, sprint planning and sprint backlog creation, scrum meetings while working on sprints, testing and product demonstration and retrospective and next sprint planning.
• Proficient in Creating and Transforming Business Requirements into software requirement specification (SRS) using MS Word and Rational Requisite Pro.
• Experience with Data Analysis and Data Validation by writing complex SQL queries using Teradata SQL Assistant.
• Extensive experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive Dashboards with page and dashboard Prompts.
• Expert in creating Risk Management Plan, User requirement Specification (URS), Functional Requirement Specification (FRS), Business Requirement Documents (BRDs).
• Proficiency in analyzing and Creating Use cases, Use Case Diagrams, Activity diagrams, Class diagrams, Data Flow Diagrams, Business Flow Diagrams and Navigational flow diagram and Sequence diagrams using MS Visio and Rational Rose.
• Expertise in MS Office Suite, MS Project for Project Plan, MS Visio, Rational Rose, Rational Requisite Pro, Rally, and HP Quality Center.
• Experience in configuring automation reports using various delivery mechanisms like Email Links, PDF attachments and Excel attachments.
• Extensively worked on database testing using SQL on different versions of Oracle databases and SQL server.
• Good knowledge of various RDBMS like DB2, Oracle, MS-Access and MS-SQL Server.
• Thorough knowledge of HP Quality Center and Defect Lifecycle and Triage process.
• Experience in Black Box Testing and User Acceptance Testing (UAT).

TECHNICAL SKILLS:

Web Technologies: HTML, DHTML, XML, CSS, XSLT, JavaScript, Python scripts

Reporting Tools: Tableau Desktop 10, 9, 8.2.2, 8.1.6, 8.0, 7.0, Tableau ServerDatabases ETL, PLSQL, T- SQL, MDR, MDM, OS Oracle … SQL Server … Teradata V2R6, DB2 UDB 8.0, MS Access, UNIX, Windows XP/NT.

Tools: Python, R, AWS, MS Visio, HP ALM, JIRA, HP QC.

SDLC Methodologies: Waterfall, RUP (Rational Unified Process), Agile (Scrum)

PROFESSIONAL EXPERIENCE;

Confidential, Chicago, IL

Business Data Analyst

Responsibilities:

• Gathered new Basel requirements from business matter experts and communicated the same to external vendors.
• Worked on developing Data mapping documents for Meta Data Repository (MDR) capturing source to target mapping from multiple Sources.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Designed, developed and supported BusinessObjects Reports and provided high value analytical insights by designing BusinessObjects Web Intelligence reporting.
• Performed data profiling and data mapping to map various source data systems to the new Basel database.
• Assisted the UI/UX team in the designing user dashboards Wireframe, Mockups and Prototypes by providing them clear business requirements and conducting Requirement Workshops with stakeholders and tech team. proficient in Business Process Flows, Business Process Re-in engineering, Business Process Modeling & Management.
• Used Python and R for machine learning algorithms for data mining. Cluster analysis, hidden Markov models, and time series analysis.
• Used Python and Microsoft Excel to organize raw data from multiple databases, Excel files, Excel-based modeling and different file types. Data conversion and export from databases.
• Used JIRA project management tool to track user stories.
• Supported major clients with predictive analyses on customer churn rate through R, built and maintained dashboards and reports to perform data visualization through Tableau
• Utilized and manipulated canned queries from Sprints Business Objects report repository
• Worked with Scrum Master in implementing Agile SDLC processes, including ticketing system, burn down charts, scrum sessions, and sprint and product backlogs.
• Documented and maintain requirements traceability matrix to ensure all requirements are traceable from top to bottom.
• Created visually impactful dashboards in Excel and Tableau for data reporting by using pivot tables and VLOOKUP. Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information.
• Performed Data Analysis and Data Validation by writing complex SQL queries using Teradata SQL Assistant.
• Created and presents standard reports, using multiple tools including Access, Advanced Excel (VLOOKUP, Pivot Table and Pivot Charts), clearly recognized and summarized the trends in a visual format that is easily understood and actionable
• Wrote and maintain Business Requirements Documents (BRD) and Functional Requirements Documents (FRD) defining new systems operations for the project using Rational Requisite Pro.
• Created Use cases, Use Case Diagram, Business flow diagram, Work and Navigation flow diagram using Unified modeling language (UML).
• Strong in RDBMS concepts and experience in creating, maintaining and tuning Views, Stored Procedures, Functions and Triggers using SQL Server, T-SQL.
• Created Use Cases and developed detailed Use Case Diagrams and Sequence diagrams describing how actions are to be carried out using MS Visio.
• Extensively involved in creating repots on top of Data warehousing and creating the reporting by using Tableau.
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center.

Confidential, North Chicago, IL

Business Analyst/ Data Analyst

Responsibilities:

• Created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.
• Performed Data analysis of existing data base to understand the data flow and business rules applied to Different data bases using SQL.
• Developed Business Intelligence reporting requirements by extracting requirements from excel macros to convert these reports to Tableau.
• Developed, managed and validated existing data models including logical and physical models of the data warehouse and source systems utilizing a 3NFmodel.
• Developed MapReduce/Spark Python modules for machine learning & predictive analytics in Hadoop on AWS. Implemented a Python-based distributed random forest via Python streaming. Query large sets of data for quality control purposes.
• Maintained version control of SQL, Python and R code using GitHub data using data visualization software such as Tableau, Excel, Power BI, in conjunction with strong verbal ability to present data clearly to non-technical audiences
• Defined system requirements (BRD - Business Requirements Document) for complex, multi-departmental and multi-functions projects
• Participated in daily Agile Scrum, Sprint Planning and Retrospective Sessions and update the team on status of upcoming User Stories for a project of changing the client's software maintenance structure of their various software products.
• Created Process Flows for various scenarios within the enterprise
• Designed and developed extensive Business Objects reports like Simple, Complex, Cross Tab using multiple Queries, Prompts, combination chart and tables.
• Managed requirements and facilitates all requirements and documentation. Worked with other groups to provide, resolve questions, assess user's needs, and document user requirements.
• Gathered data and prepared necessary reports for clients to support decision-making and requirements analysis.
• Developed reports using Business Intelligence tools such as Web Intelligence and Crystal Reports.
• Responsible for designing, developing and testing of the ETL strategy to populate the data from various source systems (Flat files, Oracle).
• Successfully created requirement document to create associate based performance evaluation metrics in tableau.
• Performed Data Analysis and data profiling using complex SQL on various sources systems including Oracle 10g/11g and Teradata, in order to ensure accuracy of the data between the warehouse and source systems.
• Worked as Analyst to create Data Models using Erwin and developed relational database system.
• Reviewed with users’ functional specifications (FRD - Functional Requirements Document), provided feedback to Technology.
• Translated business requirements into technical requirements in the form of user stories within Jira/TFS backlog on various projects
• Used VLOOKUP in excel to create data tables from large unformatted data.
• Worked closely with the Data Stewards to ensure correct and related data is captured in the data warehouse as part of Data Quality check.
• Used HP Quality Center and ALM for overall test management including creation of test plans and test cases, test case execution in QC and defect reporting and tracking.
• Built and maintained a robust data warehousing system for the organization.
• Maintained and managed logs of various Environments (Development, QA, UAT)

Confidential, O'Fallon, MO

Data Analyst

Responsibilities:

• Analyzed complex data flow from front office systems to finance systems to identify gaps and trades to understand incorrect/inconsistent valuation and accounting.
• Worked on Business Intelligence environment for Share our Strength by providing direction in building data dictionary
• Created flattened base table for tableau and aggregated table based on business requirement.
• Created T-SQL Scripts for data clean up in the production environment.
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Created roadmap to convert all Business objects report as metrics in tableau dashboard.
• Summarized data sets by respective fields and utilize data visualization charts such as Tree maps, Geo maps and Pivot charts to present the analysis and results.
• Developed SQL server scripts to get the relevant data.
• Created new database objects like Procedures, Functions, Tables, Triggers, Indexes and Views using T-SQL
• Created source to target mapping document for Datawarehouse development.
• Analytics reports implementation. Provided ability for ad-hoc reporting and dashboard for live reporting capabilities.
• Applied referential integrity constraints to define relationship between fact and dimensions tables for tableau base tables.
• Conducted Daily Standup meetings to ensure that proposed changes went through the system as well as the project team produced solutions that meet established standards, procedures, practices, risks and mitigation plans
• Maintained JIRA for tracking user stories, issues and changes.
• Created reports and Dashboards utilizing MS Excel
• Applied Master Data Management standards in data conversion, mapping and migration.
• Worked on creating Star & Snow-Flake Schemas, Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• Reported various counterparty exposures and capital limits for all clients across the firm

Confidential, Deerfield, IL

Business Analyst / Data Analyst

Responsibilities:

• Created process flows, UI mockups, wireframes and flow charts.
• Analyzed data lineage processes to identify vulnerable data points, control gaps, data quality issues, and overall lack of data governance.
• Created visually impactful dashboards in Excel and Tableau for data reporting by using pivot tables
• Worked extensively in Teradata data modeling for both logical and physical data models.
• Performed requirement analysis by writing user Stories gathering both functional and nonfunctional requirements based on interactions with Risk Analyst and SME's.
• Designed SSIS Packages in SQL Server to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Created and translate User Stories to define the functions the system must provide and facilitate requirements management.
• Developed ad-hoc / canned reports using the Business Objects Intelligence Web Intelligence Reporting Tool/ Crystal Reports.
• Extensively worked in Agile Scrum framework as software development compliance management system.
• Created and maintain various technical STTM's (Source to Target Mappings) for current and future s.
• Ability to create mockups, graphics and prototypes to enable the understanding of user centered design
• Worked on designing and developing ETL jobs, utilizing Pentaho as an ETL tool to extract data from heterogeneous sources, applied transformation logic to extract data and load into Data Warehouse Databases.
• Applied Master Data Management standards in data conversion, mapping and migration.
• Was Responsible for defining the functional requirement documents for each source to target interface.
• Provided primary liaison between business/operations/vendors and development
• Elaborated the user requirements by developing prototypes, wireframes and screen mockups.
• Involved in developing business process models, process flows and DFDs using MS VISIO.
• Created and maintained data mappings & data Dictionary and performed extensive data validations.
• Authored, published and presented on a secure web site: reports, charts and dashboards using Excel (VBA) and SQL Reporting Services (SSIS, SSRS, SSAS, ACCESS)
• Conducted UAT (User Acceptance Testing) and wrote the user manual for UAT.