SUMMARY

• Overall 9+ years of working experience as a Business System Analyst/Data Engineer/Data Modeler.
• Highly proficient in requirement gathering and Data Modelling including design and support of various applications in OLTP, Data Warehousing, OLAP and ETL Environment.
• Expert knowledge of UNIX Shell Scripting and batch processing.
• Highly Proficient working in Agile methodology and expert in various project management tools like JIRA, RALLY.
• Skilled in visualizing, manipulating, analysing large datasets to further create effective reports and dashboards with Tableau desktop.
• Hands on experience with Data Loading, Data Cleaning, Data Wrangling and making conclusions from the data for decision - making purposes.
• Solid understanding of statistical analysis, predictive analysis using various machine learning algorithms, Deep Learning.
• Have good Power BI background working on Power BI Report Server / desktop / on-prem, Power BI Content packs, templates, integrations, and security.
• Very good Power BI background on Power BI Report Server / desktop / on-prem experience, Power BI Content packs, templates, integrations, and security.
• Familiarity with BI technologies (Including Tableau, Microsoft Power BI, etc.)
• Experience building data pipelines in any public cloud (AWS, GCP Dataflow, Glue, Azure DataFactory) or any equivalent
• Good understanding of Teradata and Metadata usage and benefits.
• Experience in data modeling, data design and persistence (e.g. warehousing, data marts, data lakes).
• Strong Knowledge of Big Data architectures and distributed data processing frameworks: Hadoop, Spark, Kafka, Hive
• Experience and working knowledge of various development platforms, frameworks and languages such as Java, Python, Scala and SQL
• Experience in both RDBMS and No-SQL Database.
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Well versed in system analysis, ER/Dimensional Modelling, Database design and implementing RDBMS specific features.
• Participated in requirements gathering. Gathered, analyzed and defined business requirements for insurance products.
• Possess a knack for quick learning and a resilient team player, flexible to learn advancements in the Data Science industry.
• Review UX and identify requirement gaps to share with Business stakeholders.

TECHNICAL SKILLS

SDLC Project Methodologies: Agile, Waterfall, RSA, Hybrid

Testing tools/Servers: HP Quality Center/ ALM, Cucumber, CRM/Salesforce, FACETS, TFS, JIRA, RALLY

Software Languages: C, VB Script, XML, Microsoft SQL, Java

Version Control Systems: Rational Clear Case, Rational Rose

System Integration Tool: MS SQL Server, MS Access, and Oracle, Sybase, AS400, Hadoop, Hive

Modeling Tools: MS Visio, MS SharePoint, Tableau, Confluence

Database Management/Dataware House Tool: MS SQL Server, Toad (oracle), IBM Data Studio, Informatica PowerCenter, Microsoft Power BI

Reporting Tool: Report builder, Report designer

Document Management Tools: Confluence, SharePoint, Share Drive, MS Office, MSPM, MKS

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Sr. Business Analyst/Data Modeler

Responsibilities:

• Involved in complete end to end Agile Software Development Methodology and developed, tested, deployed and monitored the application in each iteration.
• Applies predictive models, third party data, and other tools to develop and execute appropriate segmentation and targeting for acquisition and portfolio strategies to provide insight into portfolio risk
• Wrote several Teradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.
• Created Teradata objects like Tables and Views.
• Extensively worked on to convert ORACLE scripts into Teradata scripts
• Works with business, credit, data, and model development partners to design, develop, and monitor test designs and analytical reporting to track and enhance strategies.
• Created Metadata and ETL mapping documents to load data from various source systems into IODS.
• Hands-on experience with relational DBMS, with Teradata experience to support the development of strategies that align to the long-term goals and visions of Teradata
• Worked closely with senior leadership team members, managers and developers.
• Handled many tasks to enhance the process and special projects.
• Extensively worked and completed archiving process (task to analyze and decision files that can be archived from share drive to web storage) by coordinating 45 associates to learn and work on it.
• Provides financial and regulatory reporting and analyses to maintain adequate controls over the financial and regulatory reporting processes.
• Improve performance, productivity, efficiency and profitability through the implementation of effective business intelligence methods & strategies
• Created and managed BI and analytics solutions that turn data into knowledge
• Successfully created a Business Requirement Document (BRD) and Functional Requirement Specifications (FRD) in a timely manner. Conducted the FRD reviews and walkthroughs with designers, developers and stakeholders.
• Analysed complex Business Requirements based on ETL and Reporting business intelligence tools and segregated them into high level and low-level Use Cases, Activity Diagrams/State Chart Diagrams (UML).
• Analysed Business Requirements and segregated them into high level and low-level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Assisted developers to design ETL work flows using informatica power center
• Gathered handsome and strong working experience with knowledge on Data Mapping, Data Modeling, Data Mining, and Data Warehousing/Mart, Teradata, Relational databases and SQL Query performance tuning.
• Worked with ETL teams to deliver the reporting layer composed of the highly tuned and aggregated tables designed from the base tables using informatica power-centre.
• Worked on Different SQL database servers like My SQL Server, DB2, Oracle, Sybase 400 etc.
• Performed numerous data pulling requests using SQL for analysis.
• Used Joins like Inner Join, Outer join while creating tables from multiple tables.
• Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent.
• Designed and developed Ad-hoc reports as per business analyst, operation analyst, and project manager data requests.
• Loaded data into staging tables via SQL Views.
• Created the prototype of Tableau reports and enhanced dashboards with the key metrics as required by Business Management.

Confidential, Richmond, VA

Business/Data Analyst

Responsibilities:

• Designing, development and testing of new modules by communicating with client and team members, using Power BI.
• Created Test Strategy for UAT, Test Plan, Test Cases and Test Scenarios. Tested the application manually by executing Test Cases, logged defects and ensured that the defects were remediated
• Maintain JIRA projects, workflows, permissions, and users while working in a JIRA environment.
• Coordinated the UAT Testing efforts/updates between the Testing Team and the Business Team.
• Data Analysis and requirements gatherings, including meeting with the business unit stakeholders, subject matter experts and engineering
• Identified the entities and relationship between the entities to develop Conceptual Model using ERWIN.
• Created data mappings, Tech Design, loading strategies for ETL to load newly created or existing tables from ERwin tool.
• Created Schema objects like Indexes, Views, and Sequences, triggers, grants, roles, Snapshots.
• Extensively worked on documentation of Data Model, Mapping, Transformations and Scheduling batch jobs with hadoop.
• Created and maintained logical or physical data models of relational databases using hadoop.
• Developed dimensional model for Data Warehouse/OLAP applications by identifying required facts and dimensions and performed data analysis to come up with data cleansing and integration rules for the ETL process using Erwin tool.
• Develops process improvements to enhance overall data quality for both on premise business as usual (BAU) initiatives and AWS cloud transformation journey
• Collaborates with technology partners to identify a best in class data quality (DQ) tool that allows easy configuration, integration and dash boarding capabilities with the AWS cloud environment
• Proactively identifies areas of risk and bring forward with recommendations to address on aws platform.
• Created model aggregation layers and specific star schemas as subject areas within a logical and physical model to understand and meet referential data integrity requirements.
• Used forward engineering to create a physical data model with DDL that best suits the requirements from the Logical Data Model using ERwin.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle.
• Created advanced chart visualizations in Tableau using Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Pie Chart, Gantt chart, Histograms.
• Involved in Creation of dashboards, stories and visualizations in Tableau. Created report schedules on Tableau Server.
• Worked on SQL queries in a dimensional data warehouse as well as a relational data warehouse.
• Perform administrative tasks, including creation of database objects such as database, tables, and views, using SQL DCL, DDL, and DML requests.

Confidential, Newark, NJ

Business/Data Analyst

Responsibilities:

• Worked with Data Architect and SMEs in identifying the solution for reporting issues found while comparing existing data model in ISR and that developed for ASM.
• Performed requirements modelling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
• Actively involved in analysing the order management and supply chain management process, managing inventory process and documenting the process.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping, ETL tools like Informatica for loading data into the staging tables in the database.
• Involved in designing logical and physical Data models and wrote Business and technical metadata as well as prepared source to target data mappings documents in excels.
• Involved in multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Informatica, Data Warehousing, and Tableau reporting tool.
• Coordinated with data stewards / data owners to discuss the source data quality issues and resolving the issues based on the findings.
• Defined and created procedures to install Tableau desktop in silent mode.
• Preparing Dashboards using calculations, parameters in Tableau.
• Generate DDL's and make the same available to the DBA for execution
• Identified Key data Elements (KDE's) and building business rules to measure KPI's.
• Audited Data of the identified subject areas, and assist building DQ Dashboards
• Established a process for data review and remediation of Data Quality issues
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content